03333 445950 03333 calls are same cost
| | Making It Happen Accounting and Information Technology, Assistance and Support Standard Sage 50 Imports - Medium Invoice
This operation is for import of invoices (or credit notes) for which tax calculations already exist from a csv
The required fields are ACCOUNT_REF, STOCK_CODE, NET_AMOUNT, TAX_AMOUNT. The rest will be given appropriate defaults if the import data is blank, e.g. if INVOICE_NUMBER is left blank the invoice is automatically given the "next" available invoice number.
The exact tax amounts specified in the CSV will be used, rather than values being re-calculated from first principles. This is the best approach to ensure a penny perfect match if tax has already been calculated by an external system.
The start of a new invoice or credit is identified by a change of INVOICE_NUMBER, ACCOUNT_REF, INVOICE_DATE or the sign of NET_AMOUNT. If an INVOICE_NUMBER is supplied the other significant factors ought only to change when the invoice number changes! If the NET_AMOUNT is negative the document is considered a credit. 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 | INVOICE_NUMBER | | 2 | B | ACCOUNT_REF | **Required | 3 | C | INVOICE_DATE | | 4 | D | STOCK_CODE | **Required | 5 | E | DESCRIPTION | | 6 | F | NOMINAL_CODE | | 7 | G | DEPT_NUMBER | | 8 | H | TAX_CODE | | 9 | I | QTY_ORDER | | 10 | J | UNIT_PRICE | | 11 | K | NET_AMOUNT | **Required | 12 | L | TAX_AMOUNT | **Required |
* 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. |