General description #

This sheet/tab reports all the orders in which the products are shipped/transported from the company warehouse(own or third-party) to buyers of the product(through sales contracts). This report gives details about all the outgoing orders from the company warehouse/stock to the buyer. 

Columns #

• 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”.
• Order number: The order number generated after creating an order is displayed in this column. On hover, it displays the info text “Order number”.
• Subsidiary: The subsidiary that creates the order is displayed in this field. The data for this field is fetched from the “Id” field of the subsidiary. On hover, it displays the info text “Subsidiary that owns the contract/lot”.
• Order Date: The date of order creation is displayed. The value of this column is fetched from the field “Order Date” in the related order. On hover, it displays the info text “Order date”.
• Loading Date: The date of loading of products from stock is shown in this column. The value for this column is fetched from the field “Loading date” of the related order. On hover, it 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 displayed in this field. On hover, it displays the info text “Loading Week”.
• Schedule 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, it displays the info text “Schedule unloading time”.
• Unloading date: The unloading date of the order is given in this field. This value is fetched from the field “Unloading date” in related order. On hover, it 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 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, displays the info text “Unloading week”.
• Product code: the name of the product is shown in this column. The data for this column is fetched from the “product” field of the related sales contract. On hover, displays the info text “Short code of the product”.
• Product Group: This column gives the information about the group to which a group belongs. The data is fetched from the Product screen. On hover, displays the info text “The product group the product belongs to”.
• Our Reference: The reference related to lot or warehouse is shown in this column. The value is fetched from the field “our ref” in the lot screen of the related stock. On hover, displays the info text “Reference number of the lot as known by the subsidiary”.
• Quantity: The quantity of product to be delivered in the orderline is shown in this column. The data for this column is fetched from the related orderline. On hover, displays the info text “Quantity per contract line”.
• Quantity Unit: The quantity unit used in the contract is displayed in this column. On hover, the column displays the info text “Unit used in quantity”.
• Pricing Unit: The pricing unit from the contract is given in this column. The pricing unit is used for the invoicing of the orders. On hover, the column displays the short info text “Unit the contract is priced in.”
• Customer: The grouped columns for customer 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.”
• Contract number: The sales contract number related to the orderline is shown in this column. 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 sales invoice number of the orderline is shown in this column. This value is fetched from the related sales invoice. On hover, it displays the info text “Invoice number”.
• Loading address relation name: The address for the loading of products is shown in this column. The value is fetched from the lot details of the product to be loaded. On hover, it displays the info text “Loading address relation name”.
• 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 number related to the supplier or stock lot. The value is fetched from the field “Ref. suppl/lot no.” in the related orderline.  On hover, displays the info text “Reference number of the supplier”.
• Warehouse relation: The warehouse from which the products are loaded for transportation is shown in this column. The value is fetched from the warehouse details in the lot screen of the related product stock. On hover, displays the info text “Warehouse relation”.
• Transport invoice: The transport order number for the related order is shown in this column. This value is fetched from the “Transport Order” in related order. On hover, displays the info text “Transport invoice number”.
• Transporter: The carrier or transport(relation) that will transport the products from stock to destination is shown in this column. This value is fetched from the “carrier” field on the order screen.  On hover, displays the info text “Transporter”.
• Unloading address relation name: The address of the buyer where the orders are to be unloaded is shown in this column. This value is retrieved from the related orderline. On hover, displays the info text “Unloading address relation name”.
• Unloading Address: The detailed address of the unloading address, along with the city of the address, is displayed in this column. On hover, the column displays the short info text, “Unloading address.”
• Unloading Country: The country of the unloading address is displayed in this column. On hover, displays the info text “Unloading Address Country.” 
• Packaging: The packaging type used for the product in the sales contract is shown in this field. The value is fetched from the related order line. On hover, displays the info text “Packing of the product”.
• License plate: The vehicle number of the vehicle used for transportation of order. This value is fetched from the field “License plates” in the related order. On hover, displays the info text “License plate number”.
• Loading reference: Any reference mentioned by the user for loading of products is displayed. This value is fetched from the field “loading reference” in the orderline.On hover, displays the info text “Loading reference”.
• Unloading reference: Any reference related to unloading or buyer. The value is fetched from the field “unload reference” in the related orderline. On hover, displays the info text “Unloading reference”.
• Finalized: This column shows whether the orderline is finalized or not. On hover, it displays the info text “Finalized”.
• Remarks: Any notes added related to the product, buyer, supplier, etc are shown in this column. The value for this column is fetched from the field “Notes” of the related order. On hover, displays the info text “Remarks chosen in the contract or placed at stock lot”.
• Finalized or pre-finalized: This column shows whether the order is pre-finalized or not. The value is fetched from the own warehouse screen(in the case of companies owning a warehouse). On hover, displays the info text “Finalized or pre-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”.
• 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.”
• 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”.
• Sales total amount F.C: This column shows the total amount in the related sales invoice excluding the VAT in the currency used in the invoice. The value is fetched from the related sales invoice. On hover, displays the info text “Total Amount in Foreign currency”.
• Sales Total amount Base currency: This column shows the total amount in the related sales invoice excluding the VAT in the base currency. The value is fetched from the related sales invoice. On hover, displays the info text “Total Amount in base currency”.
• Sales value including VAT in F.C: This column gives the total amount of sales invoice including the VAT applied in the currency used in the invoice. The value is fetched from the related sales invoice. On hover, displays the info text “Total amount including VAT in F.C”.
• Sales value including VAT in Base currency: This column gives the total amount of sales invoice including the VAT applied in the base currency of the operating subsidiary. The value is fetched from the related sales invoice. On hover, displays the info text “Total amount including VAT in Base currency”.
• Intra Communautair: The intracommunautair status for the order is shown in this column. This value is fetched from the related order. On hover, displays the info text “Intra-community”.
• Invoice date: The date on which the invoice is created is displayed in this column. The data is fetched from the field “Invoice date” in the related sales invoice.  On hover, displays the info text “The invoice date”.
• Origin Arrival Date: This column gives the arrival date of the order at the destination or unloading address. The value is fetched from the field “Arrival date(at destination)” in the related order.  On hover, displays the info text “Arrival date at origin”.
• Origin Departure date: The departure date of the order at the destination or unloading address is given in this field. The value is fetched from the related order field “Departure date(at destination)”. On hover, displays the info text “Departure date at origin”.