General description #

The incoming deliveries overview report is a customer-specific report used by businesses that use products like oils and fats for production. These companies usually receive these oils and fats from multiple countries. The report provides a listed view of the orders and the percentages of products from multiple countries that have been added to the related order’s product percentages section. Aside from product percentages from various countries, this report provides important information about the physical composition of the product as well as the necessary documents received at the time of delivery.

The report is available only for customers with configuration own factory.enabled set to true.

Purposes/Objectives #

• The report is used by oil and fat production companies to track the origin(usually multiple countries) of their products.
• Such companies are usually required to provide information related to the origin of the products they receive to the relevant authorities, the report thus helping them in easy reporting to such authorities.

Additional Filters #

The additional filter available for the report is “Date range” with options “From date” and “To date”. The filters allow filtering the report data as per the “Departure date” column of the orders. Using the filter enables you to display the order that has the departure dates falling between the selected dates.

Columns #

• Factory:  The column gives the name of the factory in which the silo used for the order is located. On hover, the column displays the short info text “Factory.”
• Date: The departure date-time of the order associated with the contract is displayed in this column. On hover, the column displays the short info text “Date.”
• Month: The departure month of the order is displayed in this column. On hover, the column displays the short info text “Month.”
• Week: The week number of the destination departure date is displayed in this column. On hover, the column displays the short info text “Week.”
• CMR/Handelsdoc/Begeleidingsbrief: Whether the CMR, HandelsdocBegeleidingsbrief document is attached for the order or not is shown in this column. CMR, HD, Begeleidingsbrief, Annex 7, BL checkbox marked in the external document tab of the order screen signifies the information. On hover, the column displays the short info text “CMR/Handelsdoc/Begeleidingsbrief.”
• Weegdocument: The status of the weighing document attached/received with the order is shown in this column. The weegdocument checkbox in the order screen’s external document tab signifies this column’s status. On hover, the column displays the short info text “Weegdocument.”
• POS: Whether the POS document is attached to the order or not is displayed in this column. The status is fetched from the checkbox POS from the external tab of the order screen. On hover, the column displays the short info text “POS.”
• Inkoopfactur: The column displays the purchase(booking) invoice number associated with the order. In case multiple purchase invoices are associated with the order they are all displayed in the column separated by commas. On hover, the column displays the short info text “Inkoopfactuur.”
• Magazjinbon: Whether the magazijnbon (warehouse receipt) is attached to the order or not is displayed in this column. The status is fetched from the checkbox magazijnbon from the external tab of the order screen. On hover, the column displays the short info text “Magazijnbon.”
• Sustainability checked: The sustainability document whether attached with the order or not is defined in this column. On hover, the column displays the short info text “Sustainability checked.”
• Order akkord: The column displays the status of whether the order is completed or not. The status is determined by the checkbox “Order Akkord” on the External documents tab of the order screen. On hover, the column displays the short info text “Order akkord.”
• Supplier: The relation used in the contract as a supplier is displayed in this column. On hover, the column displays the short info text “The supplier.”
• Remarks: Any remarks added to the destination side of the orderline are displayed in this column. On hover, the column displays the short info text “Remarks chosen in the contract or placed at stock lot.”
• Order number: The order number is displayed in this column. On hover, the column displays the short info text “Order number.”
• Contract number: The contract number associated with the order is displayed in this column. On hover, the column displays the short info text “Contract number.”
• Product code: The product used in the contract is displayed in this column. On hover, the column displays the short info text “Short code of the product.”
• Loading reference: The loading reference details from the origin side of the orderline are displayed in this column. On hover, the column displays the short info text “Loading reference.”
• FFA value: The column displays the quantity of the FFA as per the details added in the product analysis of the product. On hover, the column displays the short info text “Quantity of the FFA in the product analysis.”
• CMR weight: The quantity (weight) of the product as per the CMR document or details added on the origin side of the order is displayed in this column. On hover, the column displays the short info text “CMR weight.”
• Actual weight: The quantity received at the factory or as per the destination side of the order is displayed in this column. On hover, the column displays the short info text “Quantity used in the destination side.”
• Difference in weight(kg): The difference between the CMR weight and actual weight is displayed in this column. On hover, the column displays the short info text “Difference between the CMR weight and actual weight.”
• Quantity unit: The unit for measuring the quantity of products is displayed in this column. On hover, the column displays the short info text “unit used in quantity.”
• Eur-contract value: The value of the actual weight is displayed in this column.
  • Calculation: Actual weight * price per kg.
• Feeds stock code : The code of the feedstock used in product percentages is given in this column. On hover, the column displays the short info text “feedstock code.”
• Feedstock label: The label of the feedstock used in the product percentages is displayed in this column. On hover, the column displays the short infotext “feedstock label.”
• Gram CO2 EEC: The value from the field “EEC in Gram CO2” of product percentages is displayed in this column. On hover, the column displays the info text “Gram CO2 EEC.”
• Gram CO2 EP: The value from the field “EP in Gram CO2” of product percentages is displayed in this column. On hover, the column displays the info text “Gram CO2 EP.”
• Gram CO2 ETD: The value from the field “ETD in Gram CO2” of product percentages is displayed in this column. On hover, the column shows the info text “Gram CO2 ETD.”
• Next, follow the columns that show the weight and percentage of the product from various countries (if that is the case) as per the details added in the product percentages dialogue box.
• Address: The address column displays the address of the factory where the order has been delivered. On hover, the column displays the short info text “Address.”
• Subsidiary:  The operating subsidiary of the contract is displayed in this column. On hover, the column displays the info text “Subsidiary that owns the contract/lot.”
• Notes: Any notes added for the order are displayed in this column. The values are fetched from the column “notes” of the order screen. On hover, the columns display the short info text “Notes.”