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:

GoodsInInvoice_<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”
Reference	12	This is the unique number for the pre advice on the warehouse system.
Rotation Number	15
Product Code	30
Product Description	50
Pallets	10
Cases	10
Singles	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
Rate	15	How much the charge is
Line Total	15
Total Charge	15
VAT	15
Minimum Charge Applied	3	Is there a minimum charge per line, if so then this will say “Yes”
Premium Charge Applied	3	Is there a premium charge applied, if so then this will say “Yes”
Reduced Rate Applied	3	Has the reduced rate been applied, if so then this will say “Yes”

Browser not supported