The Consignment Export Report will provide users with a csv extract of all consignments created over a set period of time. This report will allow users to run a large-scale analysis of your freight movements.
How to Run the Consignment Export Report
The Consignment Export Report can be run by selecting Reports and Export Consignments.
This will prompt the modal below:
This modal will allow you to filter down the data which is reported on.
The fields are:
Start Date - Start of the reports date range (note this report is run off despatch date)
End Date - End of the reports date range (note this report is run off despatch date)
Status - Select from the below:
Carrier - Type in the carrier and select from the typeahead.
Company (include Children Flag) - If you wish to run from a selected child company and its children, type its name in this section.
Customer Ref 1 or Ref 2 (and Partials) - To run the report just on particular references provide them in the box. Partial matches can be set by selecting the tag.
Saved To Company Location - This will be a receiving saved company location.
To Location - This will be a receiving suburb.
Saved To Company Location - This will be a sending saved company location.
From Location - This will be a sending suburb.
Only Show Total by Company - This tag will enable a user to summarize the totals for consignments, dollars, weight, volume, etc by each applicable company. If this is set to be no then MachShip will provide the report as one line per consignment.
Show Item Information
If you set this to be yes, MachShip will produce the report which has the item type, dimensions and the carrier commodity that was charged. This will be presented on different lines with all information duplicated.
Exclude Closed – If you want to exclude closed consignments from the report, you can do it by enabling this flag.
Tags to Filter By – This will give you the ability to adjust the data you wish to return on the report. If you wish to run a report just on specific carrier accounts linked to a tag, you can do it by putting in the tag or tags lin the Tags to Filter By section The report will then only include the consignments created under those accounts.
Tags to Exclude – If you want to exclude or filter out specific carrier accounts in your report. You can use this filter and put in the tags linked to the accounts you wish to exclude from the report. This will then exclude data from that carrier account.
If you want to know how these tags are created, it is outlined here.
Note: You can put in multiple tags on the modal
Once you have filled in your chosen fields, click Generate Report to CSV or the button with the UP arrow for more options.
- Generate Report to Excel
- Generate Report to CSV via Notification
- Generate Report to Excel via Notification
The report will run in the background if the option to Generate Report to CSV via Notification or Generate Report to Excel via Notification were selected, you will get a notification once the report has been generated on your main dashboard. Click on the notification to download the report.
You will also get notified via email. The email body will show all the fields that were filled in. Click on the link to download the report.
How to Read the Consignment Export Report
(Only Show Total by Company set to No)
The report will contain the following fields:
Despatch Date - The date the user indicated the freight would be provided to the transport provider.
MachShip # - The MachShip internal reference number.
Carrier Connote Reference - The reference number in the transport provider's system.
Reference 1 + Reference 2 - Reference 1 and reference 2 on the consignment.
Company - The company in MachShip who despatched the freight.
Carrier - The carrier the consignment was despatched with.
Service - The service the consignment was despatched on.
From and To Zone - The zone used by MachShip to generate the price.
From and To suburb and Name - The from and to location name and the sending suburb name.
# of Items - The total number of items on the consignment.
Total Volume (consignment) - The total cubic metres of the consignment.
Total Weight (consignment) - The total weight of the consignment.
Sales Portfolio - If the company has been assigned sales
Account Management Portfolio - If the company has been assigned an Account manager
Tier - If the company has been assigned a Tier
Price Ex Tax - The total calculated price of the consignment ex Tax.
Total Price - The total calculated price of the consignment.
Tax - The total calculated tax price of the consignment.
Fuel - The total calculated fuel price of the consignment.
Base - The total calculated sum of route and surcharges price of the consignment.
From and to Address Line 1, Address Line 2, State, Postcode - The remaining address details of the consignment.
Item Type - The Item type of the consignment, if more then one item type is used then this is set to be various.
Created Date - The date that the consignment is created.
Completed / ETA Date - Either the completed date of the consignment or the eta date of the consignment if it is not completed.
Status - The current status of the consignment.
Delivery special Instructions - If there are any delivery special instructions for the consignment.
From and To Location ID - The ID of the saved company location used (if applicable).
From and To Location Abbreviation - The from and to location abbreviation used on the consignment (if applicable).
Created by User ID - The user who created the consignment.
Attachment Count - If there are any attachments such as POD's.
First Attachment Added - The date of the first attachment added.
From and To Email, Phone, Contact - This is the from location and to locations contact details, phone number and email as put on the consignment
From Country - This is the country of the sending location
To Country - This is the country of the delivery location
If the Include Items Field is Set to be Yes:
If you set the Include Items field to be yes then the report will include the below fields.
Item Name - Name of the item sent
Carrier Item Type - The carrier commodity that was used to charge for the freight
Item Type - The shipping item type the user selected
Quantity - Quantity of that line item
Length - Length in cm
Width - Width in cm
Height - Height in cm
Weight - Weight in kg
How to Read the Consignment Export Report
(Only Show Total by Company set to Yes)
Number of Consignments - The total consignments created by that company.
Company - The company in MachShip that despatched the freight.
# Items - The total items of all the consignments despatched by the company.
Total Volume - The total volume of all the consignments despatched by the company.
Total Weight - The total weight of all the consignments despatched by the company.
Price Ex Tax - The total price of all consignments ex Tax despatched.
Total Price - The total price of all consignments despatched.
Tax - The total tax price of all consignments despatched.
Fuel - The total fuel price of all consignments despatched.
Base - The total sum of route and surcharges prices of all consignments despatched.