Suppliers
This is used to upload new Supplier records to Sage, however, if this supplier already exists in Sage the record will be updated with the other fields in the XLSX/XLS.
The Configuration tab allows you to chose to overwrite or ignore blank fields.
The key field is AccountRef which corresponds to the A/C supplier account reference field in Sage.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
AccountRef |
A/C |
Supplier Record - Account Details |
8 |
The key field for this tab. This will be the A/C or account ref for the supplier after it's uploaded. If it already exists in Sage the supplier will be updated. |
|
Name |
Company Name |
Supplier Record - Account Details |
60 |
|
|
Add1 |
Street1 |
Supplier Record - Registered Address |
60 |
|
|
Add2 |
Street2 |
Supplier Record - Registered Address |
60 |
|
|
Add3 |
Town |
Supplier Record - Registered Address |
60 |
|
|
Add4 |
County |
Supplier Record - Registered Address |
60 |
|
|
Add5 |
Postcode |
Supplier Record - Registered Address |
60 |
|
|
ContactName |
Contact Name |
Supplier Record - Contact Information |
30 |
|
|
TradeContact |
Trade Contact |
Supplier Record - Contact Information |
30 |
|
|
|
Email 1 |
Supplier Record - Contact Information |
255 |
|
|
Email2 |
Email 2 |
Supplier Record - Contact Information |
255 |
|
|
Email3 |
Email 3 |
Supplier Record - Contact Information |
255 |
|
|
Website |
Website |
Supplier Record - Contact Information |
255 |
|
|
Telephone |
Telephone |
Supplier Record - Contact Information |
30 |
|
|
Telephone2 |
Telephone 2 |
Supplier Record - Contact Information |
30 |
|
|
Fax |
Fax |
Supplier Record - Contact Information |
30 |
|
|
Analysis1 |
Analysis1 |
Defaults Tab - Custom Fields |
30 |
|
|
Analysis2 |
Analysis2 |
Defaults Tab - Custom Fields |
30 |
|
|
Analysis3 |
Analysis3 |
Defaults Tab - Custom Fields |
30 |
|
|
Terms |
Trading Terms Text |
Credit Control Tab - Terms |
30 |
|
|
DefNomCode |
Default Nominal Code |
Defaults Tab - Misc Defaults |
8 |
|
|
DefTaxCode |
Default Tax Code |
Defaults Tab - Misc Defaults |
2 |
|
|
VATRegNo |
VAT Number |
Supplier Record - Registered Address |
8 |
|
|
CountryCode |
Country |
Supplier Record - Registered Address |
2 |
|
|
SendRemEmail |
Email Settings - Option 1 |
Supplier Record - Email Settings |
3 |
Yes/No |
|
SendLettersEmail |
Email Settings - Option 2 |
Supplier Record - Email Settings |
3 |
Yes/No |
|
Memo |
Memo |
Supplier Record - Memo |
Max |
|
|
Currency |
Currency |
Defaults Tab - Misc Defaults |
3 |
Only used for new suppliers in Foreign Trader Sage companies |
|
AccountStatus |
Account Status |
Credit Control Tab - Restrictions |
1 |
Numeric status value (Account On Hold also set where appropriate) |
|
Dept |
Department |
Defaults Tab - Misc Defaults |
2 |
|
|
PaymentDaysDue |
Payment Due |
Credit Control Tab - Terms |
2 |
|
|
PaymentDaysFrom |
Payment Due From |
Credit Control Tab - Terms |
2 |
|