Historical Data Sales Invoice template field definitions
Follow
Heather
Updated : Created :
Use the Historical Data Sales Invoice template to upload historical data to Business Intelligence (BI) and Advanced Inventory Manager (AIM).
Points to note
- Numeric fields should not have more than 4 decimal values.
- The Historical Data Sales Invoice template must be uploaded at the same time as the Historical Data Sales Order template.
|
Field |
Definition |
Size |
Type |
Mandatory field |
|
InvoiceNumber |
Unique invoice number linked to the Sales Order number |
21 |
PK - Alphanumeric |
Yes |
|
InvoiceDate |
The date the order was invoiced. (Oldest date = 2015-01-01) |
- |
yyyy-MM-dd |
Yes |
|
CompleteDate |
The date the invoice was completed.(Oldest date = 2015-01-01) |
- |
yyyy-MM-dd |
Yes |
|
OrderNumber |
The unique sales order number this invoice is linked to. |
20 |
FK - Alphanumeric |
Yes |
|
ExchangeRate |
The exchange rate at the time of sale. Only needed to be complete if the sale to the customer was done in a foreign currency. (eg. 0.984) |
18 |
Numeric |
Enter “1” if it is the same as the base currency |
|
ChargeTotal |
Any additional charges/costs linked to this Sales Invoice, repeat the amount on all line items. (The format of this field should be plain numeric with no thousand separators or currencies eg. $1,000.00 should be entered as 1000.00.) |
18 |
Numeric * |
Leave blank if there were no additional charges. |
|
LineNumber |
Each product on the Sales Invoice represents a sales order line, starting from number 1 for the first product, 2 for the second etc. This should match the line order number per product listed on the completed sales orders template. |
18 |
Numeric |
Yes |
|
ProductCode |
The product code must match the product code as captured in Unleashed. https://unleashedsoftware.com/v2/Product/List#Obsolete=All,Sellable=All |
100 |
Alphanumeric |
Yes |
|
InvoiceQuantity |
The number of units invoiced. |
18 |
Numeric |
Yes |