General Description #

The report is the combined version of reports “purchase planning,” “sales planning,” “warehouse planning,” and “back-to-back planning.” The report details all the information related to the various orders (purchases, sales, back-to-back, and warehouse movements), thus providing insights into the quantities and values of purchases and sales.

The report also allows you to check whether the invoices have been created for these orders or not.

Objectives of the Report #

The report being the combined version of sales, planning, back-to-back and warehouse movement orders serves various objectives. Some of the main objectives are listed below:

1. The report is used to match purchase orders and sales transactions with their respective invoices. It ensures that for every purchase, an invoice is received, and for every sale, a sales invoice is generated for the correct amount.
2. The report is used to match purchase orders and sales transactions with their respective invoices. It ensures that for every purchase, an invoice is received, and for every sale, a sales invoice is generated for the correct amount.
3. Planning reports are used to determine when a transaction should be recorded based on the unloading date, which ensures accurate timing of reporting and accounting.

Columns #

• Type: The type of the orderline, whether purchase, sales, back-to-back, or warehouse movement, is shown in this column. On hover, the column header displays the short info text “Type.”
• Subsidiary: The subsidiary associated with the order is displayed in this column. On hover, the column header displays the short info text “Subsidiary that owns the contract/lot.”
• Order Number: The order number of the orderline for which the data in other columns is shown is displayed in this column. On hover, the column header displays the short info text, “Order number.”
• Order Date: The order date is displayed in this column. On hover, the column header displays the short info text, “Order date.”
• Loading Date: The loading date entered for the order is displayed in this column. The value for this column is fetched from the field “loading date” of the related order. On hover, the column header displays the short info text, “Loading date of the lot.”
• Loading Time: The loading time of the order is displayed in this column. On hover, the column header displays the short info text, “Loading time.”
• Arrival date: The arrival date as per the order is displayed in this column. On hover, the column header displays the short info text “Arrival date of products at own factory.”
• Loading Week: The week as per the loading date of the order is displayed in this column. On hover, the column header displays the info text “Loading Week.”.
• Unloading Date: The unloading date of the order is given in this field. This value is fetched from the field “Unloading date” of the related order. On hover, the column header displays the info text “Unloading date for the lot.”.
• Unloading Time: The unloading time of products is displayed in this column. The value is fetched from the column “Unloading time” of the associated order. On hover, the column header displays the short info text “Unloading time.”
• Unloading Week: The week number in the year of the unloading date is given in this column. On hover, the column header displays the info text “Unloading week.”
• Unloading time: This column gives the unloading time information of the order in AM or PM. The data for this column is fetched from the field “Schedule unloading time” of the order. On hover, the column header displays the info text “Schedule unloading time.”
• Product Code: The name of the product associated with the order line is shown in this column. On hover, the column header displays the info text “Short code of the product.”
• Product Group: This column gives the information about the group to which the product associated with the orderline belongs. On hover, the column header displays the info text “The product group the product belongs to.”
• Tariff code: The unique tariff code of the product is shown in this column. This value is retrieved from the field “Tarif code” on the product screen. On hover, the column header displays the info text “Tarif code.”
• Our reference: The reference related to the lot or warehouse associated with the orderline is shown in this column. The value is fetched from the field “our ref” in the lot screen of the related stock. On hover, the column header displays the info text “Reference number of the lot as known by the subsidiary.”
• Quantity: The quantity of the product from the orderline is displayed in this column. The data is fetched from the “quantity” column of the destination side of the orderline. On hover, the column header displays the info text “Quantity per contract line.”
• Quantity unit: The quantity unit used in the orderline is displayed in this column. On hover, the column header displays the info text “Unit used in quantity.”
• Pricing Unit: the quantity unit used in the contract associated with the orderline is displayed in this column. On hover, the column header displays the short info text, “Unit the contract is priced in.”
• Unloading address relation name: The information about the warehouse in which the order will be unloaded at delivery is provided in this column. This information is retrieved from the destination section of the orderline. On hover, the column header displays the info text “Unloading address relation name.”
• Unloading country: The country of the unloading address is displayed in this column. On hover, the column header displays the info text “Unloading Address Country.”
• Warehouse reference: The column displays the warehouse reference entered in the destination side of the orderline for the order type “Purchase” and “warehouse movement.” For “Sales,” order type warehouse reference from the associated lot is displayed in this column. The column is left blank for the order type “back-to-back.” On hover, the column header displays the short info text “Reference number of the lot as known by the warehouse.”
• Warehouse relation: The column displays the warehouse associated with the orderline. The company name of the relation is displayed in this column. For the “back-to-back” order type, the column is left blank. On hover, the column header shows the short info text, “Warehouse relation.”
• Supplier: The grouped columns for suppliers display various address details of the supplier associated with the orderline, as listed below:
  • Supplier: This column displays the “company name” of the supplier (relation) associated with the order line. On hover, the column header displays the short info text, “Suppliers name.”
  • Address: The column displays the supplier’s address. The first address added to the relation is shown. If Address 1, Address 2, and Address 3 are added to the relation, they are all displayed, separated by commas. On hover, the column header displays the short info text, “Supplier Address.”
  • Zipcode: The zipcode of this address is displayed in this column. On hover, the column header displays the short info text, “Supplier Zipcode.”
  • City: The city of this address is displayed in this column. On hover, the column header displays the short info text, “Supplier City.”
  • Country: The country code of the country of the address is displayed in this column. On hover, the column header displays the short info text, “Supplier Country.”
• Customer: The grouped columns for customers display various address related details of the customer, as listed below:
  • Customer: This column displays the “company name” of the customer (relation) associated with the order. On hover, the column header displays the short info text, “Customer name.”
  • Address: The column displays the address of the customer. The first address added to the relation is displayed. If Address 1, Address 2, and Address 3 are added to the relation, they are all displayed, separated by commas. On hover, the column header displays the short info text, “Customer Address.”
  • Zipcode: The zipcode of this address is displayed in this column. On hover, the column header displays the short info text, “Customer Zipcode.”
  • City: The city of this address is displayed in this column. On hover, the column header displays the short info text, “Customer City.”
  • Country: The country code of the country of the address is displayed in this column. On hover, the column header displays the short info text, “Customer country.”
• Purchase contracts: The column displays the purchase contract associated with the orderline. The data for this column is displayed only for the order types “purchase” and “back-to-back.” On hover, the column header displays the short info text, “purchase contract numbers.’
• Sales contracts: The column displays the sales contract associated with the orderline. The data for this column is displayed only for the order types “sales” and “back-to-back.” On hover, the column header displays the short info text, “sales contract numbers.’
• Purchase incoterms: The incoterms (delivery conditions) as per the purchase contract associated with the orderline are displayed in this column. The data for this column is displayed only for the order types “purchase” and “back-to-back.” On hover, the column header displays the short info text “incoterms (purchase contract).”
• Sales incoterms: The incoterms (delivery conditions) as per the sales contract associated with the orderline are displayed in this column. The data for this column is displayed only for the order types “sales” and “back-to-back.” On hover, the column header displays the short info text “incoterms (sales contract).”
• DUNS code: The DUNS code of the relation associated with the orderline is given in this column. For “purchase” and “sales” type orderlines, the code is fetched from the relation associated with the contract. For the “back-to-back” type orderline, the code of the relation associated with the purchase contract is displayed. For warehouse movements, the column is left blank. On hover, the column header displays the info text “DUNS code.”
• Supplier reference: Any reference number related to the supplier is shown in this field. The data for this field is fetched from the field “Ref. Supp./Lot no.” of the related orderline’s origin section. On hover, the column header displays the info text “Reference number of the supplier.”
• Invoice number: This is the invoice number associated with the orderline. For “sales” and “back-to-back” orderlines, the sales invoice number is displayed. For the “purchase” type orderlines, the expected goods invoice number is displayed. For “warehouse movements,” the column is left blank. On hover, the column header displays the info text “The invoice number.”
• Client invoice number: The invoice number provided by the supplier is shown in this field. For “purchase” and “back-to-back” orderlines, the supplier invoice number from the associated purchase invoice is displayed. For the “sales” type orderlines, the supplier invoice number of the purchase invoice (origin) associated with the lot (origin) is displayed. For “warehouse movements,” the column is left blank. On hover, the column header displays the info text “client invoice number.”
• Transport invoice: The transport invoice number of the order is displayed in this column. On hover, the column header displays the short info text, “Transport invoice number.”
• Transporter: The transporter associated with the order is displayed in this column. On hover, the column header displays the short info text, “Transporter.”
• Loading Address relation name: The address from which the order is loaded is shown in this column. The data is fetched from the field “loading address” of the origin section of the orderline. On hover, the column header displays the short info text, “Loading address relation name.”
• Loading country: The country code of the loading address is shown in this field. On hover, the column header displays the info text “Loading address country.”
• Packaging: The packaging used for the packing of the product is displayed in this column. This value is retrieved from the related orderline field “packaging.” On hover, the column header displays the info text “Packing of the product.”
• Goods invoice: The column displays the expected goods invoice number associated with the orderline. The “purchase” and “back-to-back” orderlines display the expected goods invoice from the orderline. The “sales” type displays the goods’ expected invoice number of the origin of the lot. For warehouse movements, the column shows no data. On hover, the column header displays the short info text, “Goods Invoices.”
• License plate: The license plate details of the order are displayed in this column. On hover, the column header displays the short info text, “License plate number.”
• Intracommunatair: The details about the intracommunautair status of the order are shown in the column. The value is retrieved from the field “Intracommunautair” in the order screen. On hover, the column header displays the info text “Intra community.”
• Loading reference: Any reference regarding the loading of products is displayed in this column. This value is fetched from the origin side of the related orderline. On hover, the column header displays the info text “Loading reference.”
• Unloading reference: Any reference related to the unloading of products is shown in this column. The data is retrieved from the field “Unloading reference” on the destination side of the related orderline. On hover, the column header displays the info text “Unloading reference.”
• Finalized: The column displays whether the orderline is finalised or not. On hover, the column header displays the short info text, “Finalized.”
• Remarks: Any notes specific to the order are displayed in this column. The data is retrieved from the field “Notes” in related order. On hover, the column header displays the info text “Remarks chosen in the contract or placed at the stock lot.”
• Incoming mutations pre-finalized: The status of the incoming orders associated with the orderline, whether pre-finalised or not, is displayed in this column. The column shows the value for customers with the own factory or own warehouse module enabled; otherwise, it displays n.v.t. On hover, the column header displays the short info text “incoming mutation pre-finalized.”
• Outgoing mutations pre-finalized: The status of the outgoing orders associated with the orderline, whether pre-finalised or not, is displayed in this column. The column shows the value for customers with the own factory or own warehouse module enabled; otherwise, it displays n.v.t. On hover, the column header displays the short info text “outgoing mutation pre-finalized.”
• Currency: The currency used in the contract associated with the orderline is displayed in this column. For “back-to-back” type orderlines, the currency from the sales contract associated with the orderline is displayed. The column is left blank for the orderline type “warehouse movement.” On hover, the column header shows the short info text, “Currency.”
• Base currency: The base currency of the subsidiary associated with the order is displayed in this column. The column is left blank for the orderline type “warehouse movement.” On hover, the column header displays the short info text, “Base currency.”
• Exchange rate: The exchange rate as per the currency and base currency displayed in previous columns is shown in this column for an orderline. The value is fetched from the contracts associated with the orderlines. For orderline type “warehouse movement,” the column displays “0.” On hover, the column header displays the short info text, “Currency exchange rate.”
• Purchase value foreign currency: The total amount of the purchase invoice of the related orderline in the currency used for the order is displayed in this column. For orderline types “purchase” and “back-to-back” the value is displayed. For orderline types “warehouse movements” and “sales,” the column displays “0.” On hover, the column header displays the info text “Total purchase value in foreign currency.”
• Purchase value base currency: The total amount of the purchase invoice of the related orderline in base currency is displayed in this column. For orderline types “purchase” and “back-to-back” the value is displayed. For orderline types “warehouse movements” and “sales,” the column displays “0.” On hover, the column header displays the info text “Total Purchase Value in Base currency.”
• Purchase value foreign currency including VAT: The total amount of the purchase invoice, including VAT in the currency used in the order, is shown in this column. On hover, the column header displays the info text “Total purchase amount including VAT in foreign currency ”.
• Purchase value base currency including VAT: The total amount of the purchase invoice, including VAT in the base currency of the subsidiary associated with the order, is shown in this column. On hover, the column header displays the info text “Total purchase amount including VAT in base currency.”
• Sales value foreign currency: The total amount of the sales invoice of the related orderline in the currency used for the order is displayed in this column. For orderline types “sales” and “back-to-back” the value is displayed. For orderline types “warehouse movements” and “purchase,” the column displays “0.” On hover, the column header displays the info text “Total sales value in foreign currency.”
• Sales value base currency: The total amount of the sales invoice of the related orderline in base currency is displayed in this column. For orderline types “sales” and “back-to-back” the value is displayed. For orderline types “warehouse movements” and “purchase,” the column displays “0.” On hover, the column header displays the info text “Total sales value in base currency.”
• Sales value foreign currency including VAT: The total amount of the sales invoice, including VAT in the currency used in the order, is shown in this column. On hover, the column header displays the info text “Total sales amount including VAT in foreign currency.”
• Sales value base currency including VAT: The total amount of the sales invoice, including VAT in the base currency of the subsidiary associated with the order, is shown in this column. On hover, the column header displays the info text “Total sales amount including VAT in base currency.”
• Invoice Date: The column displays the invoice date of the invoice associated with the orderline. For “back-to-back” and “sales” type orderlines, the column displays the invoice date of the associated sales invoice. For the “purchase” type orderline, the column displays the invoice date of the associated purchase invoice. For warehouse movements, the column is left blank. On hover, the column header displays the short info text, “The invoice date.”
• Origin arrival date: The arrival date of products at the origin is displayed in this column. This data is fetched from the field “arrival date (at origin)” in the related order. On hover, the column header displays the info text “Arrival date at origin.”
• Origin departure date: The arrival date of products at the origin is displayed in this column. This data is fetched from the field “arrival date (at origin)” in the related order. On hover, the column header displays the info text “Arrival date at origin.”
• Destination arrival date: The arrival date of products at the destination is given in this field. This value is fetched from the field “arrival date(at destination)” of the order. On hover, the column header displays the info text “Arrival date at destination.”
• Destination departure date:  The departure date of products at the destination. This value is fetched from the field “Departure date(at destination)” in the related orderline. On hover, the column header displays the info text “Departure date at destination.”
• B/L date: The bill of loading date of the order is displayed in this column. The value for this column is fetched from the field “B/L date” of the order. On hover, the column header displays the short info text, “Bill of loading date of the order.”
• B/L number: The bill of loading number of the order is displayed in this column. The value for this column is fetched from the field “B/L number” of the order. On hover, the column header displays the short info text, “B/L number.”
• Logistic employees:  The employee added as “person responsible for order” in the related order is displayed in this column. On hover, the column header displays the info text “Responsible logistic employees.”.
• Custom fields: The rest of the grouped columns are the custom fields added to various screens like order, product, orderline, etc. Various custom fields added for each screen are grouped separately.