Freight Expense Tracking

Sites will now have the ability to log and report on Freight expenses from their Carriers. 

Warehousing > Maintenance > Freight Expense Maintenance

A Despatched Invoice can be searched for within ‘Freight Expense Maintenance’ with either the Invoice number or Con note and the User can enter /modify  the associated Freight charge.

Warehousing > Configuration > Freight Expense Import File Spec

A file can also be imported into the system rather than entering individually.. Firstly, a file spec must be set in ‘Freight Expense Import File Spec’. This will tell the system which headings pertain to which field in ACR. The mapped fields available are Invoice Number, Con note number and Charges ex GST $. Users will give each file spec a description and choose the file format of TAB or CSV.

Warehousing > Task > Freight Expense Import

Once the File Spec is created users can import a file by navigating to ‘Freight Expense Import’ and selecting the appropriate file spec (created in ‘Freight Expense Import File Spec’) and the file location. This will open an import screen with a summary from the file and advise the User of any warnings/errors. The successful import will bulk update the Freight charges on all Invoices in the file.

Warehousing > Reports > Freight Expense Report

The Freight Expense information is reportable under ‘Freight Expense Report’ which will display any Freight charge for the qualified Month/Year/Business Unit that holds a freight charge. Users can select a ‘Mode’ so that the chosen month will either show:

  • Transaction Date- Transactions that occurred in the month selected
  • Entered Date – Charges that were uploaded/entered in to the system in the month selected.

There has been additional updates regarding Freight Expense Tracking, please click through the links below.

Freight Expense Maintenance and Freight Expense Import

Freight Expense Report

Freight Expense Exception Report

Carrier Maintenance > Freight Expense