03333 445950
03333 calls are same cost
 |  |  |
Making It Happen
Accounting and Information Technology, Assistance and Support
Standard Sage 50 Imports - Retail Invoice
If the quantity is negative the document is considered a credit. Only the first item in each document is checked for this.
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| Field | Description | Notes | |
| 1 | A | ACCOUNT_REF | |
| 2 | B | STOCK_CODE | An existing valid product reference |
| 3 | C | QTY_ORDER | *This is optional is not included 1 is assumed, if negative a credit note is made, |
| 4 | D | UNIT_PRICE | *This is optional if not included the standard price will be applied |
| 5 | E | CARR_NET | |
| 6 | F | CARR_NOM_CODE |
*quantity and unit price are optional - but if they are present in any line, they should also be present in at least in the first line (because that line sets the pattern).
Refer to our field information table for the actual limitations of data values for these fields, additional fields can be added and a bespoke customiser made for you at low cost.