Product Invoices/Credits
Product Invoice/Credit and Credits use the same fields. Again the combination of AccountRef/InvRef controls the creation of each new inv/credit with identical items appearing as detail lines. Note that if the UnitPrice field is blank then this will be looked up from the stock record and Value and VATAmount calculated accordingly.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
AccountRef |
A/C |
Product Invoice/Credit - Details |
8 |
The customer account ref this invoice is for |
|
InvRef |
Inv No. |
Product Invoice/Credit - Details |
7 |
The key field for this tab. This controls the creation of each header record. Lines with identical AccountRef/InvRef will be grouped on an invoice/credit as detail lines. |
|
OrderNo |
Order No. |
|
7 |
|
|
CustOrderNo |
Customer Order No. |
Product Invoice/Credit - Order Details - Customer Order Details |
60 |
|
|
Date |
Date |
Product Invoice/Credit - Details |
10 |
|
|
Product |
Product Code |
Product Invoice/Credit - Details - Item Lines |
30 |
|
|
Qty |
Quantity |
Product Invoice/Credit - Details - Item Lines |
|
|
|
UnitPrice |
Price |
Product Invoice/Credit - Details - Item Lines |
8 |
|
|
Value |
Net Amount |
Product Invoice/Credit - Details |
8 |
|
|
DiscountAmount |
Discount Amount |
Product Invoice/Credit - Details - Values |
8 |
|
|
TaxCode |
Tax Code |
Product Invoice/Credit - Details - Line Item - Posting Details |
2 |
|
|
VATAmount |
VAT Amount |
Product Invoice/Credit - Details - Item Line |
8 |
|
|
ExchRate |
Exchange Rate |
|
8 |
If left blank will use Sage default exchange rate (where Foreign Trader enabled in Sage) |
|
NetValueDiscount |
Net £ |
Product Invoice/Credit - Details - Deduction |
8 |
|
|
NetValueDescription |
Description |
Product Invoice/Credit - Details - Deduction |
60 |
|
|
NomCode |
Nominal Code |
Product Invoice/Credit - Details - Line Item - Posting Details |
8 |
|
|
Notes1 |
Notes Line 1 |
Product Invoice/Credit - Order Details - Notes |
60 |
|
|
Notes2 |
Notes Line 2 |
Product Invoice/Credit - Order Details - Notes |
60 |
|
|
Notes3 |
Notes Line 3 |
Product Invoice/Credit - Order Details - Notes |
60 |
|
|
Analysis1 |
Analysis1 |
Product Invoice/Credit - Order Details - Custom Fields |
30 |
|
|
Analysis2 |
Analysis2 |
Product Invoice/Credit - Order Details - Custom Fields |
30 |
|
|
Analysis3 |
Analysis3 |
Product Invoice/Credit - Order Details - Custom Fields |
30 |
|
|
TakenBy |
Order Taken By |
Product Invoice/Credit - Order Details - Customer Order Details |
|
|
|
Dept |
Department |
Product Invoice/Credit - Footer Details - Global |
2 |
|
|
ProjectCode |
Project Ref |
Product Invoice/Credit - Details - Item Line - Project Details |
8 |
|
|
Comment1 |
Comment 1 |
Product Invoice/Credit - Details - Item Line |
60 |
Not special items |
|
Comment2 |
Comment 2 |
Product Invoice/Credit - Details - Item Line |
60 |
Not special items |
|
LineInfo |
Line Information |
Product Invoice/Credit - Details - Item Line - Additional Information |
60 |
Not message items |
|
Units |
Units |
Product Invoice/Credit - Details - Item Line |
8 |
Not message items |
|
Description (for message/special lines) |
Description |
Product Invoice/Credit - (Details) - Item Line |
60 |
Special/message items only |
|
Details (for special items) |
Details |
Product Invoice/Credit - Details - Item Line |
240 |
Special items only |
|
DelName |
Delivery Name |
Product Invoice/Credit - Order Details - Delivery Address |
60 |
|
|
DelAdd1 |
Del Address 1 |
Product Invoice/Credit - Order Details - Delivery Address |
60 |
|
|
DelAdd2 |
Del Address 2 |
Product Invoice/Credit - Order Details - Delivery Address |
60 |
|
|
DelAdd3 |
Del Address 3 |
Product Invoice/Credit - Order Details - Delivery Address |
60 |
|
|
DelAdd4 |
Del Address 4 |
Product Invoice/Credit - Order Details - Delivery Address |
60 |
|
|
DelAdd5 |
Del Address 5 |
Product Invoice/Credit - Order Details - Delivery Address |
60 |
|
|
Name |
Add Line 1 |
Product Invoice/Credit - Details |
60 |
Customer default address used if all blank |
|
Add1 |
Add Line 2 |
Product Invoice/Credit - Details |
60 |
" |
|
Add2 |
Add Line 3 |
Product Invoice/Credit - Details |
60 |
" |
|
Add3 |
Add Line 4 |
Product Invoice/Credit - Details |
60 |
" |
|
Add4 |
Add Line 5 |
Product Invoice/Credit - Details |
60 |
" |
|
Add5 |
Add Line 6 |
Product Invoice/Credit - Details |
60 |
" |
|
Contact |
Customer Contact |
Product Invoice/Credit - Order Details - Customer Order Details |
30 |
|
|
Telephone |
Customer Tel. No |
Product Invoice/Credit - Order Details - Customer Order Details |
30 |
|
|
Proforma |
|
|
|
"Yes" or "No"/blank. On invoices only - defines whether this order will be entered as a Pro-forma rather than standard invoice. Note that if any line on an order has "Yes" in this field the invoice will be entered as a Pro-forma. |
|
CarriageNet |
Net |
Product Invoice/Credit - Footer - Carriage |
8 |
|
|
CarriageTaxCode |
Tax Code |
Product Invoice/Credit - Footer - Carriage |
2 |
|
|
CarriageNomCode |
N/C |
Product Invoice/Credit - Footer - Carriage |
8 |
|
|
CarriageDept |
Department |
Product Invoice/Credit - Footer - Carriage |
2 |
|
|
DueDate |
Due On |
Product Invoice/Credit - Details |
10 |
|
|
PaymentRef |
Payment Ref |
Product Invoice - Payment - Payment Details |
30 |
Invoice Only |
|
PaymentBankCode |
Bank Code |
Product Invoice - Payment - Payment Details |
8 |
" |
|
PaymentAmount |
Payment Amount |
Product Invoice - Payment - Payment Details |
8 |
" |
|
PaymentType |
|
Product Invoice - Payment Type |
2 |
" (SA/SR) |
NB: If you have selected 'Update Ledgers' in Configuration then invoices/credit notes will be posted to the ledger if possible.
Payment details are for invoices only. The highest amount for any Invoice will be used (MAX function) and the total used will include any carriage and discount amounts on the gross amount for the invoice.
From version 2016.12.1 the Description (for message/special lines) field can be used for standard product lines to replace the Sage product description (leave blank for Sage default description).