Purpose
This function is used to upload Stock Transfer invoices. This is an alternative way of creating a transfer invoice through data entry via the ‘Manual Despatch’ function. Using this method a “spread-sheet” style tool can be used to create a data file with a list of products & quantities to be used to create a transfer invoice.
For additional details on creating upload files see the note HERE.
Data Input
Step 1 – File Upload
Upload File
Select the data file you wish to upload, by clicking Browse. This assumes you have access to the data file with the product line items and quantities from the browser you are currently using.
Return to the Top
Step 2 – Review details
The line item details of the data file selected will be displayed so that you can review the individual items and confirm that the correct data has been uploaded before you continue. Click Submit to submit all the details.
Return to the Top
Spread sheet format
The spread sheet must be in a csv format.
The first row of the spread sheet must be a heading row – it does not matter what the headings are, as long as they are meaningful to you e.g. you could have ‘Product’, ‘Product Code’ or ‘SKU’.
The columns required are:
| Column | Name | Additional Details |
| A | Transfer Order Number | The transfer order number should be repeated for each product on a specific transaction. This may/may not become the invoice number depending on whether you have the system setting configured so that invoices numbers are matched to order numbers. Mandatory. |
| B | Issue Location | This is the Stock Location the stock is issued from- the ‘Source’. It must be a valid Stock Location code already created in the system. Mandatory |
| C | Receipt Location | This is the Stock Location the stock is received into – the ‘Destination’. It must be a valid Stock Location code already created in the system. Mandatory |
| D | Invoice Date | This will be the date of the invoice. Mandatory |
| E | Product Code | This is the code of the product being transfered. It must be a valid Product code already created in the system. Mandatory |
| F | Product Description | This is a text description of the product transferred. Optional |
| G | Size Code | If used, this is a size code for the product transferred. Mandatory if the product is sized and must be valid for the nominated Product. |
| H | Colour Code | If used, this is a colour code for the product transferred. Mandatory if the product is coloured and must be valid for the nominated Product. |
| I | Delivered Quantity | This is the quantity of the product delivered/despatched for the transfer. Mandatory |
Updating
Once you review the details and click submit, the rows on the spread sheet data are uploaded and validated. If no invalid data is detected, the Stock Transfer invoice(s) are created. Note that if the receiving stock location on a given transfer is set to ‘Direct Delivery’ then the stock is automatically receipted in to the inventory of that location. Otherwise the items will be “in-transit” between the two stock locations and will need to be received into stock manually using the ‘Stock Transfer Receipt’ function.