03333 445950
03333 calls are same cost

 

Home
Up

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Standard Sage 50 Imports - Basic 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 DescriptionNotes
1AACCOUNT_REF 
2BSTOCK_CODEAn existing valid product reference
3CQTY_ORDER*This is optional is not included 1 is assumed, if negative a credit note is made,
4DUNIT_PRICE*This is optional if not included the standard price will be applied

*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.

 


Home Account Apply Terms

Sage 50 Specialists: Pay-as-you-go Support, Sage Reports, Excel Reports, Consultancy, Integration, Help, Advice and more!Copyright - Making I.T. Happen 1995 - 2024
Website last updated 13/03/2024