General description #

The transport orders report in Qbil-Trade is a comprehensive summary of all transport orders generated by your company. It provides essential information and helps you track and manage various details related to your transport orders.

Purposes/objectives #

By providing a centralized overview of all transport orders, the carrier orders report helps you monitor and manage the complete lifecycle of your orders. It allows you to easily access and retrieve essential information related to each order, facilitating efficient tracking, analysis, and decision-making processes within your transportation operations.

Columns #

• Currency: The currency used for the carrier order is shown in this column. The currency is selected in the related order. On hover, it displays the info text “Currency”.
• Base Currency: The currency of the operating subsidiary for the order is displayed in this column. On hover, it displays the info text “Base currency.”
• Expected amount in FC: The expected amount of the transport order in the currency used for the order is given in this column. This amount is retrieved from the transport order field “Estimated amount”. On hover, it displays the info text “Expected amount in foreign currency”.
• Expected amount in base currency: The expected amount of the carrier order in the base currency of the operating subsidiary of the order is given in this column. This amount is retrieved from the transport order field “Estimated amount in base currency”. On hover, it displays the info text “Expected amount in base currency”.
• Created by: The user who created the transport order is displayed in this column. On hover, it displays the info text “Created by”.
• Last updated by: The user who edited the transport order is displayed in this column. On hover, it displays the info text “Updated by”.
• Sales Contracts: The sales contract number of the order The data is fetched from the orderline of the related order. On hover, displays the info text “Sales contract number”.
• Order number: The order number is shown in this column. The data is retrieved from the related order. On hover, displays the info text “Order number”.
• Customer: The relation that is purchasing the products is mentioned in this column. The data is fetched from the destination of the orderline. On hover, displays the info text “Buyer of the product”.
• City: The loading address of the carrier order. The data is fetched from the “loading address” field of origin of the orderline. On hover, displays the info text “The city of the relation”.
• Country of origin: The country from where the carrier order is loaded is displayed in this column. On hover, displays the info text “Country of origin”.
• Loading region: The region in which the country of origin (loading country) comes e.g Europe for countries like Poland, Belgium, Etc is given in this column. On hover, displays the info text “Loading region”.
• Unloading place: The address where the carrier order is unloaded is displayed in this column. The unloading address of the carrier order is retrieved from the “Unloading address” given in the destination of the orderline. On hover, displays the info text “Unloading city”.
• Unloading country: The country of the unloading address is displayed in this column. On hover, displays the info text “Unloading country”.
• Unloading region: The region of the unloading country is given in this column. On hover, displays the info text “Unloading region”.
• Product code: The shortcode of the product from the sales contract of the related order is given in this column. On hover, it displays the info text “The shortcode of the product”.
• Container Type: The type of container used for packing is shown in this column. The value is fetched from the logistic setup tab of the related order. On hover, it displays the info text “containers”.
• No. of containers: The number of containers used for the packaging of the product is given in this column. The value is fetched from the logistic setup tab of the related order. On hover, it displays the info text “No. of containers”.
• Quantity: The quantity of product to be transported is mentioned in this column. The value for this column is fetched from the related order’s field “Quantity”. On hover, it displays the info text “Quantity per contract line”.
• Unit: The standard in which the product quantity is measured is displayed in the column e.g, kg, stuks, etc. The value for the column in the report is fetched from the field “Unit” of the order. On hover, it displays the info text “Quantity Unit”.
• Loading date: The date of loading of the carrier order is given in this column. The data is retrieved from the field “Loading date” of the related order. On hover, displays the info text “Loading date of the lot”.
• Unloading date: The unloading date of the carrier order is shown in this column. The data entered in the field “Unloading date” of the order is retrieved here. On hover, displays the info text “The unloading date for the lot”.
• ETD: The estimated departure date entered usually for the shipments outside the EU region is displayed in this column. The value is fetched from the field “Departure date” of the related order. On hover, the column header displays the short info text “Estimated time of delivery”.
• ETA: The estimated arrival date entered, usually for shipments outside the EU, is given in this column. The value is fetched from the field “Arrival date” of the related order. On hover, it displays the short description “Estimated time of arrival”.
• Transporter: The company/relation transporting the carrier order is displayed in this field. The value is fetched from the field “Carrier” of the Order screen. On hover, it displays the info text “Transporter”.
• Carrier Type: The carrier type selected in the kilometer (KMS) tracking popup of the transporter order is displayed in this column. In case of multiple lines added in the pop-up all the carrier types are displayed seperated with commas. On hover, the column displays the short info text “Carrier type.”
• Total Kilometers: This column displays the total sum of the kilometers added in the multiple lines of the Kilometer (KMS) tracking pop-up. The sum is also calculated as per the number of order lines associated with the order. On hover, the column displays the short info text “Total kilometers.”
• Remarks: The remarks added in the field “remarks for customer” of the Kilometer (KMS) tracking pop-up is displayed in this column. On hover, the column displays the short info text “Remarks chosen in the contract or placed at stock lot.”
• Quarter: This column shows the quarter of the year in which the carrier order has been placed. The quarter is usually shown with the year also e.g, 2021-Q2. On hover, it displays the info text “Quarter”.
• Supplier: The supplier column shows the relation that is supplying the product. For back-to-back orders, the relation of the Purchase contract is shown here. But in the case of a uitslag (destination) order, the “company name of the warehouse” is mentioned. On hover, displays the info text “The supplier.”
• Purchase Contract: The purchase contract number of the related order is shown in this column. On hover, displays the info text “Purchase contract number.”
• Remarks for customer: Any remarks added for the customer are displayed in this column. The details of this column are fetched from the field “remarks for the buyer” from the destination of the orderline. On hover, displays the info text “Remarks for customer”.
• Packaging: The packaging type used for the packing of the product is mentioned in this column. The value for the column is fetched from the field “Packing” of destination in the orderline. On hover, it displays the info text “packaging of the product”.
• Number of packings: A total number of packages to be transported in the carrier order is given in this column. Value fetched from the field “Packing amount” of destination in the orderline. On hover, it displays the info text “Number of packings.”
• Brand: The brand of the product is given in this column. The brand of the product is fetched from the product information field “Brand” of the related contract of the order. On hover, it displays the info text “Brand of the stored lot or production order.”
• Finalized: The column displays the status of the order associated with the transport order whether finalised or not. The column displays “yes” when all the orderlines of an order are finalised. On hover, the column displays the short info text, “Finalized.”