Purchase Invoices/Credits
The data uploaded for Purchase Invoices and Credits are identical. You must provide a valid AccountRef to load the invoice/credit against. Another required field is InvRef. This is used to tell the system when a new invoice/credit is reached. If every line has a different InvRef they will all be single line invoice/credits. If you use the same InvRef on 2 lines (for example) this will create one invoice/credit with 2 detail lines as long as they are both for the same AccountRef.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
AccountRef |
A/C |
Supplier Activity |
8 |
The Supplier account ref this inv/credit is for |
|
InvRef |
Ref |
Supplier Activity - Transaction Line |
30 |
The key field for this tab. This controls the creation of each header record. Lines with identical AccountRef/InvRef will be groups on an inv/credit as detail lines. |
|
ExtRef |
Ex Ref |
Supplier Activity - Transaction Detail Line |
30 |
|
|
Date |
Date |
Supplier Activity - Transaction Line |
10 |
|
|
TaxCode |
n/a Tax Code |
n/a |
2 |
Not visible on Supplier Activity or Nominal Ledger |
|
Value |
Amount |
Supplier Activity - Transaction Line |
8 |
Combined with VATAmount as Amount in Sage |
|
VATAmount |
Combined with above |
Supplier Activity - Transaction Line |
8 |
Combined with Amount as Amount in Sage |
|
ExchRate |
Exchange Rate |
Supplier Activity - Transaction Line |
8 |
If left blank will use Sage default exchange rate (where Foreign Trader enabled in Sage) |
|
Details |
Details |
Supplier Activity - Transaction Line |
60 |
|
|
NomCode |
N/C |
Supplier Activity - Transaction Detail Line |
8 |
|
|
Dept |
Dept |
Supplier Activity - Transaction Detail Line |
2 |
|
|
ProjectCode |
n/a - Project Code |
n/a |
8 |
Not visible on Supplier Activity transactions |
|
CostCode |
n/a - Cost Code |
n/a |
8 |
Not visible on Supplier Activity transactions |
|
Fund |
Funds |
Customer Activity - Transaction Detail Line |
4 |
Also visible in Funds Activity screen |
|
DueDate |
Due On |
Customer Activity - Transaction Line |
10 |
|