Sales Payments/Receipts + On A/C
Sales payments, receipts and receipts on account all use the same fields. The key field on this load is AccountRef. InvoiceRef is not used in the same way as all these records have one line only. It is used to allocate against an existing invoice if it exists in Sage, but is optional.
All these records will be loaded with tax code T9 and zero VAT.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
AccountRef |
A/C |
Customer Activity |
8 |
The key field for this tab. This will be the A/C or account ref for the customer this receipt or payment is for. |
|
Date |
Date |
Customer Activity - Transaction Line |
10 |
|
|
Details |
Details |
Customer Activity - Transaction Line |
60 |
|
|
Value |
Amount |
Customer Activity - Transaction Line |
8-- |
Combined with VATAmount as Amount in Sage |
|
NomCode |
N/C |
Customer Activity - Transaction Detail Line |
8 |
|
|
Dept |
Dept |
Customer Activity - Transaction Detail Line |
2 |
|
|
InvoiceRef/Ref |
Ref |
Customer Activity - Transaction Detail Line |
30 |
If invoice exists in Sage an allocation is made |
|
ProjectCode* |
n/a - Project Code |
n/a |
8 |
Not visible on Customer Activity transactions |
|
CostCode* |
n/a - Cost Code |
n/a |
8 |
Not visible on Customer Activity transactions |
* Sage versions prior to v24