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 |