General description #

This report provides an overview of all the orders that were created directly from the purchase contract to the sales contract. That is, the products were purchased from the supplier and transported directly to the buyer of the products. This report thus provides the overview of such orders where products move from purchase contracts to sales contracts directly.

Columns #

• Subsidiary: The subsidiary that created the order is displayed in this field. The value is fetched for this column from the subsidiary field in related order. On hover, displays the info text “Subsidiary that owns the contract/lot”.
• Order number: This column gives the order number generated automatically after creating an order. On hover, displays the info text “Order number”.
• Order Date: The order creation date is displayed in this column. The value for the column is fetched from the field “Order Date” of the related order. On hover, displays the info text “Order date”.
• Loading Date: The Loading date of the order at origin is displayed in this column. This value is fetched from the field “Loading Date” of the related order. On hover, displays the info text “Loading date of the lot”.
• Loading Time: The column displays the Loading time entered in the order. On hover. the column 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 displays the short info text “Arrival date of products at own factory.”
• Loading week: The week of the loading date is shown in this field. On hover, displays the info text “Loading week”.
• Unloading date: The unloading date of the order at the destination is shown in this column. This value is fetched from the field “Unloading Date” in the related order. On hover, display 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 displays the short info text “Unloading time.”
• Unloading week: The week of the unloading date is displayed in this column. On hover, display the info text “Unloading week”.
• Product code: The name of the product is given in this field. On hover, displays the info text “Short code of the product”.
• Tarif Code: The tariff code of the product is given in this column. The value for this column is fetched from the field “Tariff Code” of the related product. On hover, it displays the info text “Tariff Code”.
• ONS code: The ONS code of the product added to the related product screen is displayed in this column. On hover, displays the info text “ONS Code”.
• Product Group: The product group to which the product belongs is displayed in this column. On hover, displays the info text “The product group the product belongs to”.
• Quantity: The quantity of products ordered in the respective orderline is displayed in this column. This value is fetched from the field “Quantity” of the related orderline. On hover, displays the info text “Quantity per contract line”.
• Quantity Unit: The quantity unit of the sales contract from the orderline is displayed in this column. On hover, the column displays the short info text “Quantity unit.”
• 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 displays the short info text, “Customers 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 displays the short info text, “Customer Address.”
  • Zipcode: The zipcode of this address is displayed in this column. On hover, the column displays the short info text, “Customer Zipcode.”
  • City: The city of this address is displayed in this column. On hover, the column 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 displays the short info text, “Customer country.”
• Unloading Country: The country of the unloading address is displayed in this column. On hover, it displays the info text “Unloading Address country”. 
• Sales Contract: The sales contract number of the related orderline is given in this column. The data is retrieved from the related sales contract. On hover, it displays the info text “Contract number”.
• Sales incoterms: The incoterms (delivery conditions) as per the sales contract associated with the order line are displayed in this column. On hover, the column displays the short info text “Incoterms (sales contracts).
• Invoice number: The invoice number of the sales invoice created for the orderline is displayed in this column. On hover, display the info text “Invoice number”.
• Supplier: The grouped columns for suppliers display various address related details of the supplier, as listed below:
  • Supplier: This column displays the “company name” of the supplier (relation) associated with the order. On hover, the column displays the short info text, “Suppliers name.”
  • Address: The column displays the address of the supplier. 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 displays the short info text, “Supplier Address.”
  • Zipcode: The zipcode of this address is displayed in this column. On hover, the column displays the short info text, “Supplier Zipcode.”
  • City: The city of this address is displayed in this column. On hover, the column 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 displays the short info text, “Supplier Country.”
• Relation name: The relation of the purchase contract or the supplier from whom the product has been purchased is displayed in this column.  On hover, displays the info text “Buyer/seller of the product”.
• DUNS code: The DUNS code related to the supplier(relation) is given in this column.  On hover, displays the info text “DUNS Code”.
• Loading Country: The country code of the loading address is shown in this field. On hover, displays the info text “Loading address country”.
• Reference supplier: Any reference related to the supplier is given in this column. The value from field “Ref. Supp/Lot No.” of the source in the related orderline is fetched in this column. On hover, display the info text “Reference number of the supplier”.
• Purchase contract: The purchase contract number of the related orderline is shown in this column. On hover, display the info text “Purchase contract number”.
• Purchase Incoterms: The incoterms(deliver conditions) as per the purchase contract associated with the order is displayed in this column. On hover, the column displays the short info text “incoterms(purchase contract).”
• Goods Invoices: The purchase invoice number of the related orderline is shown in this column. On hover, displays the info text “Goods invoices”.
• Client invoice number: The invoice number provided by the supplier is shown in this field. The value of this column is fetched from the purchase invoice of the related orderline. On hover, displays the info text “Client Invoice number”.
• Transport Number: The transport order number of the related order is given in this column. On hover, displays the info text “Transport number”.
• Transporter: The transporter that carries the product from origin to destination. This value is fetched from the order. On hover, displays the info text “Transporter”.
• Loading address relation name: The address of the supplier selected for loading products from the origin is shown in this column. On hover, it displays the info text “Loading address relation name.”
• Unloading address relation name: The address that is used for the unloading of products at the destination or buyer’s address. On hover, it displays the info text “Unloading address relation name.”
• Packaging: The type of packing used for the packaging of products is displayed in the column. This value is fetched from the packing field of the Destination(Sales Contract) side. On hover, displays the info text “Packing of the product”.
• License Plate: The vehicle number of the carrier is shown in this column. The value is fetched from the “License plates” field in the order. On hover, it displays the info text “License plate number.”
• Loading reference: Any reference regarding the loading of products is displayed in this column. This value is fetched from the origin of the related orderline. On hover, it displays the info text “Loading reference.”
• Unloading reference: The reference regarding the unloading of products is shown in this column. These details are retrieved from the destination side (sales contract) of the related orderline. On hover, it displays the info text “Unloading reference.”
• Remarks: Any remarks added related to the buyer of the product are displayed in this column. The data is fetched from the field “Remarks for buyer” on the destination side of the orderline. On hover, it displays the info text “Remarks chosen in the contract or placed at stock lot”.
• Finalized: This column shows whether the orderline is finalized or not. On hover, it displays the info text “Finalized”.
• Sales currency: The currency of the sales invoice associated is displayed in this column. If no sales invoice is created the currency from the sales contracts associated with the order is displayed in this column. On hover, it displays the info text “Sales currency”.
• Sales Exchange Rate: The exchange rate as per the currency used in the invoice is displayed in this column. If no invoice is created for the order, the exchange rate as per the currency used in the sales contract is displayed in this column. On hover, it displays the info text “Sales Exchange rate”.
• 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.”
• Purchase value foreign currency: The total amount of the purchase invoice of the related orderline in currency used for the order is displayed in this column. On hover, it 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. On hover, it displays the info text “Total Purchase value in Base currency”.
• Sales total amount F.C: The total amount on the sales invoice excluding VAT of the related orderline in currency used for the order is shown in this column. On hover, it displays the info text “Total sales amount in foreign currency ”.
• Sales Total amount base currency: The total amount on the sales invoice excluding VAT of the related orderline in the base currency of the subsidiary is shown in this column. If no invoice is created for the order, the column displays “0”. On hover, it displays the info text “Total sales amount in base currency”.
• Sales VAT amount F.C: The total amount on the sales invoice including VAT in the currency used in the order is displayed in this column. On hover, it displays the info text “Total amount including VAT in foreign currency”.
• Sales VAT amount base currency: This column displays the total amount on the sales invoice, including VAT, in the operating subsidiary’s base currency. On hover, it displays the info text “Total amount including VAT in base currency”.
• Pricing unit: This column specifies the unit of measurement used when entering the price details for the product in the sales contract. On hover, the column displays the short info text “Unit the contract is priced in.”
• Intracommunautair: The intracommunautair status of the related order is given in this column.  On hover, displays the info text “Intra community”.
• Invoice date: The date on which the invoice was created is shown in this column. The value is fetched from the related purchase invoice. On hover, displays the info text “The Invoice date”.
• Logistic employee: The employee added as “Person responsible for order” in the related order is displayed in this column.  On hover, displays the info text “Responsible logistic employee”.