Service Invoice/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.
Field Mapping (mandatory fields in RED)
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
AccountRef |
A/C |
Service Invoice/Credit - Details |
8 |
The customer account ref this invoice is for |
InvRef |
Inv. No. |
Service 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 groups on an order as detail lines. |
OrderNo |
Order No. |
|
7 |
|
CustOrderNo |
Customer Order No. |
Service Invoice/Credit - Order Details - Customer Order Details |
60 |
|
Date |
Date |
Service Invoice/Credit - Details |
10 |
|
Details |
Details |
Service Invoice/Credit - Details - Item Lines |
240/60 |
Larger amount is used for item's free text field and 60 is for the normal item details field |
Description |
Description |
Service Invoice/Credit - Details - Item Lines |
60 |
|
Qty |
Qty |
Service Invoice/Credit - Details - Item Lines |
8 |
If blank a value of 1 will be used |
DiscountAmount |
DiscountAmount |
Service Invoice/Credit - Details - Values |
8 |
|
UnitPrice |
Net Amount |
Service Invoice/Credit - Details / Item Lines |
8 |
|
TaxCode |
Tax Code |
Service Invoice/Credit - Details - Line Item - Posting Details |
2 |
|
VATAmount |
VAT Amount |
Service 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 |
Service Invoice/Credit - Details - Line Item - Posting Details |
8 |
|
Notes1 |
Notes Line 1 |
Service Invoice/Credit - Order Details - Notes |
60 |
|
Notes2 |
Notes Line 2 |
Service Invoice/Credit - Order Details - Notes |
60 |
|
Notes3 |
Notes Line 3 |
Service Invoice/Credit - Order Details - Notes |
60 |
|
Analysis1 |
Analysis1 |
Service Invoice/Credit - Order Details - Custom Fields |
30 |
|
Analysis2 |
Analysis2 |
Service Invoice/Credit - Order Details - Custom Fields |
30 |
|
Analysis3 |
Analysis3 |
Service Invoice/Credit - Order Details - Custom Fields |
30 |
|
TakenBy |
Order Taken By |
Service Invoice/Credit - Order Details - Customer Order Details |
60 |
|
Dept |
Department |
Service Invoice/Credit - Footer Details - Global |
2 |
|
LineInfo |
Line Information |
Service Invoice/Credit - Details - Item Line - Additional Information |
60 |
Not message items |
ProjectCode |
Project |
Service Invoice/Credit - Details - Item Line - Project Details |
8 |
|
DelName |
Delivery Name |
Service Invoice/Credit - Order Details - Delivery Address |
60 |
|
DelAdd1 |
Del Address 1 |
Service Invoice/Credit - Order Details - Delivery Address |
60 |
|
DelAdd2 |
Del Address 2 |
Service Invoice/Credit - Order Details - Delivery Address |
60 |
|
DelAdd3 |
Del Address 3 |
Service Invoice/Credit - Order Details - Delivery Address |
60 |
|
DelAdd4 |
Del Address 4 |
Service Invoice/Credit - Order Details - Delivery Address |
60 |
|
DelAdd5 |
Del Address 5 |
Service Invoice/Credit - Order Details - Delivery Address |
60 |
|
Name |
Add Line 1 |
Service Invoice/Credit - Details |
60 |
Customer default address used if all blank |
Add1 |
Add Line 2 |
Service Invoice/Credit - Details |
60 |
" |
Add2 |
Add Line 3 |
Service Invoice/Credit - Details |
60 |
" |
Add3 |
Add Line 4 |
Service Invoice/Credit - Details |
60 |
" |
Add4 |
Add Line 5 |
Service Invoice/Credit - Details |
60 |
" |
Add5 |
Add Line 6 |
Service Invoice/Credit - Details |
60 |
" |
Contact |
Customer Contact |
Service Invoice/Credit - Order Details - Customer Order Details |
30 |
|
Telephone |
Customer Tel. No |
Service 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 |
Service Invoice/Credit - Footer - Carriage |
8 |
|
CarriageTaxCode |
Tax Code |
Service Invoice/Credit - Footer - Carriage |
2 |
|
CarriageNomCode |
N/C |
Service Invoice/Credit - Footer - Carriage |
8 |
|
CarriageDept |
Department |
Service Invoice/Credit - Footer - Carriage |
2 |
|
DueDate |
Due On |
Service Invoice/Credit - Details |
10 |
|
PaymentRef |
Payment Ref |
Service Invoice - Payment - Payment Details |
30 |
Invoice Only |
PaymentBankCode |
Bank Code |
Service Invoice - Payment - Payment Details |
8 |
" |
PaymentAmount |
Payment Amount |
Service Invoice - Payment - Payment Details |
8 |
" |
PaymentType |
|
Service 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.