Correct procedures surrounding stock arrival into Retailer will assist your stock control, ensuring that your stock holding figures are accurate, as well as allowing for stock reordering to occur within the system. It also allows you to keep track of your cost prices and gross profit figures.
Arriving an Electronic Invoice
For arriving an electronic invoice from a CSV file, click HERE.
For arriving an electronic invoice from a DD2 or DDO file, click HERE.
Creating an Invoice Arrival Manually
We have a video guide on how to manually arrive a supplier invoice in Retailer - Invoice Arrivals
- From the main screen of Retailer, go to Stock → Invoice Arrivals or Stock Maintenance → Receipt of Stock → Invoice Arrivals.
- In Supplier, select the supplier for the invoice you are arriving.
NOTE: If the supplier does not exist, press [Insert] on the keyboard and follow the prompts to add the supplier. See Adding a Supplier
- In Invoice Number, type in the invoice number or just press [Tab] to allow Retailer to generate a number based on the date.
- Press [Tab] on the keyboard to cycle through the below fields.
- Press [Enter] on the keyboard to skip straight to arriving Stock Items. See below
- Enter the Arrival Date, Invoice Date, and Due Date which will default to today's date.
Invoice Arrival Due Dates will be set based on the Supplier's settings. See Invoice Arrivals Due Date
- Tick Invoice Cost Price includes GST if the cost prices on this invoice have already had GST applied. If not, untick this option and GST will be applied according to the item's Tax Group setting.
NOTE: Once this option is set and the invoice has been created, it can no longer be adjusted.
When changing this option, you will be prompted to update the Supplier's Arrival Tax Setting. This can also be changed in Suppliers and Departments. See HERE. - The Invoice Paid tick-box becomes available after the invoice has been completely arrived.
The Pending box can be ticked to indicate the invoice is not complete, and not ready to be exported to accounting programs like Xero and MYOB.
This setting can be enabled as a default for all invoices for a supplier.
To do this, go to the main screen of Retailer, and click on Stock Maintenance → Suppliers and Departments.
Click on the Supplier tab.
Click the Magnifying Glass 🔎︎ button at the bottom to search for the supplier you wish to set this on.
Click the Other tab, then tick the box 'Enable pending invoice arrivals by default'.
Click Save.
- In Freight, record a freight charge without changing the item's cost price by entering related freight charges as either ex GST or inc GST, based on the invoice's GST setting.
NOTE: If you wish to create a separate Freight Invoice (method C) or apply a Freight Charge (method B) that affects the cost price of items on the invoice, please refer to the advice sheet HERE after completing the invoice.
- If the stock on this invoice will form part of a catalogue, select it from the Catalogue box or press [Insert] on the keyboard to add a new catalogue. This will prompt you to add each item to the catalogue as you arrive them. Click HERE to learn more about catalogues.
- In Order, type in your purchase order number if you have one.
Press [Tab] or [Enter] to start entering stock items.
If your supplier has applied a discount to stock on the invoice, tick the enable discounting option. Click HERE to learn more. If you wish to add notes to the invoice overall (before closing it), click the Notes button in the top right.
In the screen that appears, click Add to add a new note to the invoice. You can also select an existing note from the list for this invoice, and click Edit to change it, or click Delete to remove the note.
Arriving Stock Items Manually
- Retailer has three methods of selecting stock to arrive - Supplier Stock Code, Barcode or PLU. Press [F6] on the keyboard to cycle between these options.
- Scan, type or press [Enter] on the keyboard to bring up the Find Stock Screen and select the item.
If you need to add this item, click Add in the bottom left to open the Add Stock Wizard. See HERE. - Enter the Quantity Received.
- Enter the Individual Cost and Individual Sell price for this item.
Note: To calculate an Individual Cost from a Total Cost figure, enter the Total Cost into the Individual Cost field and press F6 on the keyboard. The Individual Price Calculation screen will appear. Click Ok. - Click the Save button in the bottom left or the [Tab] key. This item will now appear in the lower half of the Invoice Arrivals screen, and the invoice total figures on the bottom right will update.
- Repeat steps 2-5 to arrive more stock items.
- If the item arrived is a Variant item, it will prompt to arrive other variants of the item. Click Yes to get a Variant Arrival screen listing the other variants, where you can enter quantities arrived for each one. Click No to finish arriving this item and continue with the invoice.
- If the item arrived requires a Serial number, a screen will appear to assign serial numbers. Click HERE for more information.
- If the item arrived requires Price Points, a screen will appear with the Classifications used for the item, with separate Price Point lines for the individual items. You can enter the necessary Classifications then click Save to proceed.
When you’ve finished adding items, you may close the Invoice Arrivals screen. Your progress is automatically saved.
If this invoice was
supposed to be a supplier order arrival, and you need to link and update
the supplier order, click the Link Order 🔗 button at the top, next to
the Order box. This will prompt to select a Sent order from the same
supplier, that will be arrived and linked to this invoice. If there are
no supplier orders available, it will show the message 'No orders to
list'.
After
selecting the right order, click OK, and it will link the order and mark
off the items on that supplier order, and the order itself, as being
arrived in Orders Maintenance.
If there are outstanding items on the order, it will prompt to re-order items that were not receive.
Click Yes to create a new backorder with the outstanding items, and click No to leave the items un-arrive.
You must click Yes if the items relate to a customer order, to maintain the link between the customer order and the supplier order.
Streamlining the Arrival Process Before Stock Is Received
If you want to prepare the stock ordered from the supplier into Retailer before receiving the stock and invoice, you can use the Orders Maintenance feature to create it as a Sent order. Click HERE to learn more.
If the supplier can provide you with a CSV file of the order, you can use the Import Order function in Orders Maintenance to create the order directly in Retailer. Click HERE to learn more.
Editing Invoice Arrival
An existing invoice can have the items changed/edited, but the details at the top of the invoice need to be changed in a different area (e.g. Invoice date, freight amount).
To change the invoice header information:
- From the Invoice Arrivals screen, click the Utilities button in the top right corner.
- Click 'Change the details for an invoice that you have already received'.
- Click 'Select an Invoice'.
- Click into the Search box and type the Invoice Number.
- Select the Invoice you wish to edit and click Ok.
- The follow details of the Invoice Arrival can be changed:
- Supplier
- Invoice Number
- Arrival Date
- Invoice Date
- Due Date
- Invoice Paid tickbox
- Invoice Pending tickbox
- Freight
- Order Number
- Exchange Rate
- Extra/Backorder Invoice tickbox
- Click Save and then Close.
You can edit the contents of an existing invoice that has already been arrived by doing the following:
- Select the supplier name at the top.
- Type in and select the invoice number to edit.
- Press [Tab] on the keyboard. Confirm and enter any passwords to continue.
- If you have a supplier order in the system that you wish to link to this invoice arrival, you can click the Link Order🔗 button at the top next to the Order box.
Linking the invoice will mark off the items on that supplier order, and the order itself, as being arrived in Orders Maintenance. - To make changes, simply right-click on an item and select the desired action in the menu. Menu options are explained further below.
If you wish to add notes to the invoice overall, click the Notes button in the top right. In the screen that appears, click Add to add a new note to the invoice.
You can also select an existing note from the list for this invoice, and click Edit to change it, or click Delete to remove the note.
Other Options
The grid on the lower half of the Invoice Arrivals screen has some hidden features, available by right-clicking on an item.
- Print a label for this item - Opens the Setup Barcodes and Labels screen, allowing you to select the type of barcode you’d like to print, and the quantity. The label will then be queued up in Barcode Manager/Label Manager.
- View in Stock Screen - Opens the details of the selected item in the Stock Screen, allowing you to view more information, edit the details, or add extra information such as images.
- View Grid in Arrival Order - Sort the arrival grid so that items are listed in the order they were arrived. Alternatively, click on any of the column headings to sort by that column.
- Change Barcode - Allows you to change the current barcode of the selected stock item to another barcode.
- Delete Stock Received - Removes the selected item from the arrival.
- Edit Serial Number - If you have serial numbers enabled for this item, allows you to change them.
- Edit Arrival - Allows you to re-arrive the item, changing quantity, pricing etc.
Utilities
On the top right of the Invoice Arrivals screen, click on the Utilities button. This gives you access to a number of helpful functions, as follows:
- Change the details for an invoice that you have already received - Opens an invoice editing screen, allowing you to change the supplier, invoice number, invoice date, freight charge and order number of the selected invoice.
- Change the cost prices of all stock items of an invoice received from cost ex. tax to cost inc. tax or vice versa - Allows you to switch an invoice between inc-GST and ex-GST. This tool cannot be used if the invoice's GST setting is correct but the wrong cost price was entered.
- Reprint labels for stock items received in the Invoice Arrivals screen - Opens the Barcode Labels screen, providing a range of options to reprint barcode labels from received invoices. Read our advice sheet on Reprinting Labels from Invoices for more details..
- Merge 2 invoices together - Allows you to merge together two different invoices from the same supplier.
- Print an invoice arrivals report - Opens the setting page for the Invoice Arrivals Report.