Overview
CSV files can be generated for customers who wish to analyse their invoices. The new style invoice is now a single page invoice to reduce paper and protect the environment, the information contained in these reports is the information used to generate the invoice.
Format
The reports are in csv format, which means it can be read into your system or can be opened in excel.
Delivery & Scheduling
This report cannot be scheduled, it is emailed realtime as the warehouse generate the invoices.
The file will normally be emailed to your email address as an attachment to an existing message.
File Name Convention
The filename will be:
StockStorageInvoice_<InvoiceNumber>.csv
Limitations
There are no noted limitations
CSV Field Names & Content
Field Name | Size | Notes |
Invoice Number | 12 |
|
Invoice Date | 10 |
|
Customer Code | 8 |
|
Site Code | 6 | The site on which your goods reside. |
Customer Name | 30 |
|
Invoice Period | 30 | This is the invoicing period, if you receive monthly invoices then this will say “Monthly” |
Storage Period | 30 | This is the calculation basis for your invoice, if it is based on the highest point each week it will say “Weekly” |
Rent Date | 10 | The date to which this charge applies |
Rotation Number | 15 |
|
Product Code | 30 |
|
Product Description | 50 |
|
Pallets | 10 |
|
Cases | 10 |
|
Bottles | 10 |
|
Quantity Charged | 15 | This is the calculated charge, so if you are charged per the pallet it will be to the next whole pallet, or by the case to the next whole case or to the number of bottles. |
Rate Name | 30 | A description of the charge type |
Charge | 15 | How much the charge is |
Line Total | 15 |
|
VAT | 15 |
|
Minimum Charge Applied | 3 | Is there a minimum charge per line, if so then this will say “Yes” |