Donations
Donations creates both a Sales Invoice and a related and allocated Sales Receipt. The key field on this load is AccountRef. It is important to fill in a Nominal Code for the Invoice and a Bank Code for the receipt. FundID is also used on both parts. Each line will create a new donation. If the customer in AccountRef is set-up for Gift-Aid and the Date is after the declaration valid from date then the sales receipt record will be marked for Gift-Aid.
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. |
|
Ref |
Ref |
Customer Activity - Transaction Line |
30 |
|
|
ExtRef |
ExtRef |
Customer Activity - Transaction Detail Line |
30 |
|
|
Date |
Date |
Customer Activity - Transaction Line |
10 |
|
|
TaxCode |
n/a Tax Code |
n/a |
2 |
Not visible on Customer Activity or Nominal Ledger |
|
Value |
Amount |
Customer Activity - Transaction Line |
8 |
Combined with VATAmount as Amount in Sage |
|
VATAmount |
Combined with above |
Customer Activity - Transaction Line |
8 |
Combined with Amount as Amount in Sage |
|
Details |
Details |
Customer Activity - Transaction Line |
30 |
|
|
NomCode |
N/C Invoice |
Customer Activity - Transaction Detail Line |
8 |
|
|
BankCode |
N/C Receipt |
Customer Activity - Transaction Detail Line |
8 |
|
|
Dept |
Dept |
Customer Activity - Transaction Detail Line |
2 |
|
|
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 |
|
Fund |
Funds |
Customer Activity - Transaction Detail Line |
4 |
|
NB: Some fields for the Invoice record only are also visible via Funds.