Making I.T. 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.

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.