4. Transport Invoice

Owned by Alan Gilchrist
Last updated: Dec 06, 2018

Overview

TBC

Format

The report is 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:

TransportInvoice_<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


DeliveryDate

10


Doc Reference

8

 Unique Document Reference, generally your order or pick reference.

Delivery  Name

40


PostCode

10


Physical Cases

6


Invoice Cases

6


Rate Band

15


Area 

6


Delivery Charge

15


Handling Charge

15


Re-Delivery

1

Y or N

Re-Del Reason

4


Minimum Charge Applied

1

Y or N - Is there a minimum charge applied

Fuel Surcharge

15


DP Reference20Was known as Order Ref, usually your reference for your customer




Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.