General description #

The purchase contract planning weekly report in Qbil-Trade gives you a comprehensive view of all the upcoming purchase orders planned through purchase contracts. This report gives information about these planned orders concerning the period (week) of planning. The details for the report are mainly fetched from the related purchase contract and order lines. These details include quantity, invoicing, delivery, etc., of the order as per the planning week. Many other general details related to the Contract, product, supplier and other details are also given in this report.

The report is available only for the customers with configuration contracten.planning_period set to weekly.

Columns #

• Subsidiary: The subsidiary that created the contract is displayed in this column. The “code” of the subsidiary from the subsidiary screen is fetched in this column. On hover, the column displays the info text “Subsidiary that owns the contract/lot.”.
• Contract date: The date on which the Contract was created is displayed here. The value is fetched from the field “Contract date” of the related purchase contract. On hover, the column displays the info text “Date contract was closed”.
• Contract number: The unique contract number for each Contract is automatically generated after creating a purchase contract. The value for this column is fetched from the purchase contract screen. On hover, the column displays the info text “Contract number”.
• Counter contract number: This column displays the contract number entered for reference. The value is fetched from the field “Your ref” of the related Contract. On hover, the column displays the info text “Contract number as known by the supplier”.
• Trader: The trader column displays the trader associated with the contract. On hover, the column displays the info text “Trader/Sender of the contract”.
• Relation Name: The relation/supplier of the product for which the purchase contract is created is displayed in this column. The value for this is retrieved from the field “Relation” of the related contract. On hover, the column displays the info text “Buyer/seller of the product.”
• Logistic employee: The internal contact person associated with the contract is shown in this column. On hover, displays the info text “Responsible logistic employees.”
• Country of Origin: The product’s origin is shown in this column. The value of this column is fetched from the “origin” field of the related purchase contract. On hover, the column displays the info text “Country of origin”.
• Broker: The column displays the broker’s name (if involved) in the purchase contract. The data is fetched from the field “Broker” of the related Contract. On hover, the column displays the info text “Broker involved”.
• Broker contract: This column shows the contract number of the broker. The value is retrieved from the field “Broker Contract” in the related purchase contract. On hover, the column displays the info text “Broker contract number”.
• Product Code: The column gives the product name. The data is fetched from the field “Product” of the related Contract. On hover, the column displays the info text “Short code of the product”.
• Product group: The group to which the product from column “Product” has been added to the product screen is shown in this column. On hover, the column displays the info text “The product group the product belongs to”.
• Packaging: The packaging used for the product is shown in this field. The data for this column is fetched from the field “Packaging” of the related Contract. On hover, the column displays the info text “Packing of product”.
• Incoterms: Incoterms are the delivery conditions agreed upon by the seller and the buyer(relation) in the Contract. The delivery conditions added in the purchase contract’s “Delivery Condition” field are displayed in this column. On hover, the column displays the info text “Incoterms”.
• Payment Conditions: The payment terms agreed upon by both the seller and the buyer for payment against the Contract are in this column. The data is fetched from the field “Payment Condition” of the related purchase contract. On hover, the column displays the info text “Payment conditions”.
• Currency: The currency used for the Contract is displayed in this column. The data is fetched from the field “Currency” of the purchase contract. On hover, the column displays the info text “Currency”.
• Base Currency: The accounting currency of the operating subsidiary for the contract is displayed in this column. On hover, it displays the info text “Base currency.”
• Exchange rate: This column displays the exchange rate of the selected currency concerning the subsidiary’s currency. This currency rate is fetched from the related contracts’ field “exchange rate” field. On hover, the column displays the info text “Currency exchange rate”.
• Price per ton F.C: The product price per 1000 units in the currency selected in the Contract is shown in this column. The value is calculated using the price factor added to the Contract. On hover, the column displays the info text “Price per 1000 units in Foreign currency”.
• Price per ton in Base currency: The product’s price per 1000 units in base currency is shown in this column. This price is calculated based on the exchange rate. On hover, the column displays the info text “Price per 1000 units in Base currency”.
• Quantity: The quantity of product to be ordered that is added in the planned week is given in this column. On hover, the column displays the info text “Quantity per contract line”.
• Unit: This column shows the standard in which the quantity of product is measured, e.g., kilograms(kg), stuks, litres, etc. On hover, the column displays the info text “Quantity Unit”.
• Pricing Unit: The pricing unit of the product as per the contract is displayed in this column. On hover, the column gives the short info text “Unit the contract is priced in.”
• Contract value in Base currency: The amount for the total contracted quantity in base currency is given in this column. On hover, the column displays the info text “Total contract value in base currency”.
• Contract value in F.C: The amount for the total contracted quantity in contract currency is given in this column. On hover, the column displays the info text “Total contract value in foreign currency”.
• Delivered Quantity: The quantity of products delivered from the planned quantity is shown in this column. The details for this column are retrieved from the orderlines of the related purchase contract. On hover, the column displays the info text “Delivered quantity to stock”.
• Back to Back quantity delivered: The quantity of products ordered back to back (that is, direct from purchase to sales) from this Contract is given in the column. The value is fetched from the orderlines of the related purchase contract. On hover, the column displays the info text “Back to back quantities supplied”.
• Total delivered Quantity: The quantity of products received/delivered from the Contract for this period(week) is given in this column. The data is retrieved from the orderlines of the related sales contract. On hover, the column displays the info text “Total supplied quantity”.
• Amortized: The quantity of products from the Contract that are amortized or booked due to any reason is displayed in this column. The data is fetched from the field “Amortized” of the related purchase contract. On hover, the column displays the info text “Extra booked-off quantity”.
• Invoiced: The quantity of products for which the invoice has been created is given in this column. The data for this field is retrieved from the orderlines of the related Contract. On hover, the column displays the info text “Amount of the order line whose sales invoices are exported and have a paid date”.
• To be delivered quantity: The quantity of products not delivered from the planned quantity in the purchase contract is shown in this column. Negative values indicate that the quantity ordered exceeds the planned quantity. Data in this column is retrieved from the orderlines of the Contract. On hover, the column displays the info text “Open contract quantity”.
• Planned Quantity: The quantity of products in the week (as per the column period) that has been planned and ordered but not finalized yet is displayed in this column. The value is fetched and calculated from the orderlines of the contract. On hover, the column displays the info text “Planned contract quantity”.
• Schedule: The schedule of planning of contract quantity period-wise is shown in this column. The data is retrieved from the related purchase contract field “Schedule”. On hover, the column displays the info text “Delivery”.
• Trade conditions: Any extra information related to the Contract, product, delivery, etc., is displayed in this column. The data is fetched from “Product Textline2” of the related purchase contract. On hover, the column displays the info text “Trade conditions”.
• Country: The country of the relation for which the Contract is made is given in this column. The value is fetched from the Address tab of the related relation. On hover, the column displays the info text “The country code of the relation”.
• Region: The Region to which the country added in Column “Country” belongs is shown in this column. This region is fetched from the Country screen. On hover, the column displays the info text “Region of the country”.
• Period: The week number along with the year is displayed in this column. All other quantity related values in the report are fetched as per this column. For example the planned quantity is displayed as per the year and week number in this column. On hover, displays the info text “Period”.
• Delivery date: The order’s delivery date is given in this column. The data is fetched from the field “unloading date” of the related order. On hover, the column displays the info text “Delivery Date”.
• Customs reference number: The column displays the customs reference number filled in the order line. This field is only used by companies licensed to manage and store customs goods. Documents that contain this number are, for example, Doc EX1, Doc T1 etc. On hover, the column displays the info text “Customs number field for Doc EX1, Doc T1 etc.”.
• Email approved: This column gives the information when (date and time) the Contract was approved for an email to the user. The data for this is fetched from the audit log of the related sales contracts. On hover, it displays the info text “Authorized contract on”.
• Created by: The user who created the order for the planned week is shown in this column. The data for this column is fetched from the audit log of the related order screen. On hover, it displays the info text “Created by”.
• Finalized: This column gives information on whether all the orders in the week are finalized or not. The information for this column is fetched from the orderlines of the related purchased Contract. On hover, the column displays the info text “Finalized”.
• Sustainability: This is a custom field specific to some customers in which any certification related to the product is shown. The data for this column is fetched from the customized fields in the product section of the Contract like “Sustainability” and “Double counting scheme” of the related purchased Contract. On hover, the column displays the short info text “Sustainability.”
• Quality: This includes columns like FFA, M&I, IV, Sulphur, and PE, which provide information about the composition(usually in percentage) of different elements in a product, like fats, etc. The data for these columns are fetched from the Product analysis section of the related purchase contract.