Purchase Orders
Purchase Orders are similar to Sales Orders, but there is no quote option.
If the price/value fields are not filled in the best customer price (price list if valid, stock price if not) is used and the tax is calculated for you.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
AccountRef |
A/C |
Product Purchase Order - Details |
8 |
The customer account ref this inv/credit is for |
|
InvRef |
Inv Ref |
Product Purchase Order - Details |
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 order as detail lines. |
|
SuppOrderNo |
Supplier Order No |
Product Purchase Order - Order Details - Supplier Order Details |
60 |
|
|
Date |
Date |
Product Purchase Order - Details |
10 |
|
|
Product |
Product Code |
Product Purchase Order - Details - Item Lines |
30 |
|
|
Description |
Description |
Product Purchase Order - Details - Item Lines |
60 |
If blank stock record description used |
|
Qty |
Quantity |
Product Purchase Order - Details - Item Lines |
8 |
|
|
UnitPrice |
Price |
Product Purchase Order - Details - Item Lines |
8 |
|
|
Value |
Net Amount |
Product Purchase Order - Details |
8 |
|
|
DiscountAmount |
Discount Amount |
|
8 |
|
|
TaxCode |
Tax Code |
n/a |
2 |
Not visible on Product Purchase Order |
|
VATAmount |
VAT Amount |
Product Purchase Order - Details - Item Line |
8 |
|
|
ExchRate |
Exchange Rate |
|
8 |
If left blank will use Sage default exchange rate (where Foreign Trader enabled in Sage) |
|
NomCode |
Nominal |
Product Purchase Order - Details - Item Line - Posting Details |
8 |
If blank system default of Supplier or Product nominal code will be used depending on system override settings |
|
OrderDueDate |
Delivery Date |
Product Purchase Order - Deliveries |
10 |
|
|
DueDate |
Due Date |
Product Purchase Order - Details - Item Line - Item Status |
10 |
|
|
Notes1 |
Notes Line 1 |
Product Purchase Order - Order Details - Notes |
60 |
|
|
Notes2 |
Notes Line 2 |
Product Purchase Order - Order Details - Notes |
60 |
|
|
Notes3 |
Notes Line 3 |
Product Purchase Order - Order Details - Notes |
60 |
|
|
Analysis1 |
Analysis1 |
Product Purchase Order - Order Details - Custom Fields |
30 |
|
|
Analysis2 |
Analysis2 |
Product Purchase Order - Order Details - Custom Fields |
30 |
|
|
Analysis3 |
Analysis3 |
Product Purchase Order - Order Details - Custom Fields |
30 |
|
|
TakenBy |
Order Taken By |
Product Purchase Order - Order Details - Supplier Order Details |
60 |
|
|
Dept |
Department |
Product Purchase Order - Footer Details - Global |
2 |
|
|
ProjectCode |
|
Product Purchase Order - Details - Item Line - Project Ref |
8 |
|
|
CostCode |
|
|
8 |
|
|
DelName |
Delivery Add Line 1 |
Product Purchase Order - Order Details - Delivery Address |
60 |
|
|
DelAdd1 |
Delivery Add Line 2 |
Product Purchase Order - Order Details - Delivery Address |
60 |
|
|
DelAdd2 |
Delivery Add Line 3 |
Product Purchase Order - Order Details - Delivery Address |
60 |
|
|
DelAdd3 |
Delivery Add Line 4 |
Product Purchase Order - Order Details - Delivery Address |
60 |
|
|
DelAdd4 |
Delivery Add Line 5 |
Product Purchase Order - Order Details - Delivery Address |
60 |
|
|
DelAdd5 |
Delivery Add Line 6 |
Product Purchase Order - Order Details - Delivery Address |
60 |
|
|
Name |
Add Line 1 |
Product Purchase Order - Details |
60 |
Customer default address used if all blank |
|
Add1 |
Add Line 2 |
Product Purchase Order - Details |
60 |
" |
|
Add2 |
Add Line 3 |
Product Purchase Order - Details |
60 |
" |
|
Add3 |
Add Line 4 |
Product Purchase Order - Details |
60 |
" |
|
Add4 |
Add Line 5 |
Product Purchase Order - Details |
60 |
" |
|
Add5 |
Add Line 6 |
Product Purchase Order - Details |
60 |
" |
|
Contact |
Customer Contact |
Product Purchase Order - Order Details - Supplier Order Details |
30 |
|
|
Telephone |
Customer Tel. No |
Product Purchase Order - Order Details - Supplier Order Details |
30 |
|
|
Comment1 |
Comment 1 |
Product Purchase Order - Details - Item Line - Details |
60 |
|
|
Comment2 |
Comment 2 |
Product Purchase Order - Details - Item Line - Details |
60 |
|
|
LineInfo |
Line Information |
Product Purchase Order - Details - Item Line - Additional Information |
30 |
|
|
Units |
Units |
Product Purchase Order - Details |
8 |
|
|
Description (for message/special lines) |
Description |
Product Purchase Order - (Details) - Item Line |
60 |
|
|
Details (for special items) |
Details |
Product Purchase Order - (Details) - Item Line |
240 |
|
|
CarriageNet |
Net |
Product Purchase Order - Footer - Carriage |
8 |
|
|
CarriageTaxCode |
Tax Code |
Product Purchase Order - Footer - Carriage |
2 |
|
|
CarriageNomCode |
N/C |
Product Purchase Order - Footer - Carriage |
8 |
|
|
CarriageDept |
Department |
Product Purchase Order - Footer - Carriage |
2 |
|