Profit loss ex silo

General description #

The profit loss ex-silo report is a customized report for the companies that use silos for storing their products usually Fats & Oils. Silos are large cylindrical structures used for the bulk storage of materials.

The report is available only for customers with configuration voorraad.silos set to true.

Purposes/Objectives #

This report allows you to generate the profit loss statement for the invoices of the orders created for outgoing products from silos.

Columns #

  • Subsidiary: This column displays the subsidiary for which the invoice was created. This value is fetched from the related invoice field “Subsidiary”. On hover, displays the info text “Subsidiary that owns the contract/lot”.
  • Printed: The column gives the information on whether the invoice has been printed or not. On hover, displays the info text “Invoice is printed or not”.
  • Exported: Whether the invoice has been exported or not is displayed in the column. On hover, displays the info text “Exported”.
  • Sales Product code: The product name of the invoice is given in this column. This value is fetched from the related invoice field “Short code of the sales product”.
  • Invoice Number: The invoice number that is generated automatically after creating an invoice is displayed in this column. On hover, displays the info text “Invoice number”.
  • Invoice Date: The invoice creation date is given in this column. On hover, displays the info text “The invoice date”.
  • Relation Name: The company name of the relation/buyer for which the invoice has been created. On hover, displays the info text “Buyer/Seller of the product”.
  • Sales quantity: The invoiced quantity of products is given in this column. The value is retrieved from the related invoice field “Quantity”. On hover, displays the info text “Sales Quantity”.
  • Purchase quantity: This column displays the quantity of product from the source that is, the lot or purchase contract from which the order has been made. On hover, displays the info text “Purchased Quantity”.
  • Purchase Unit: The column displays the unit of measurement used for the purchased product. On hover, displays the info text “Purchase Unit”.
  • Value Per Ton: The price of the product per 1000 units as per the source(lot or purchase contract) of the product. On hover, displays the info text “Value per 1000 units including extra costs”.
  • Price per ton: The price of products including all the taxes applied on the product while purchasing or producing(in case of a lot from production order). On hover, displays the info text “Price per 1000 units”.
  • Sales price per ton: The price of the product per 1000 units as mentioned in the sales invoice is given in this column. This value is retrieved from the field “Price”. On hover, displays the info text “Sales ppt”.
  • Sales Value: The total amount of the invoice including any VAT amount is displayed in this column. This value is fetched from the related sales invoice field “Amount”. On hover, displays the info text “Sales value”.
  • Sales Unit: The column displays the unit of measurement used for the Sale product. On hover, displays the info text “Sales Unit”.
  • Purchase Value: The total amount/value of the quantity as per the purchased price (from source) is shown in this column. On hover, displays the info text “Total purchase value”.
  • Purchase Value Gross: The gross(total) value of sales quantity as per the purchasing price is given in this column. On hover, displays the info text “gross(total) value of sales quantity”.
  • Sales transport costs: The carrier charges added for the sales invoice are given in this column. On hover, displays the info text “Carrier charges for sales invoice”.
  • Transport cost final: This column shows the value of any transport order that has been booked for the related invoice by the user. On hover, displays the info text “Transport order that has been booked”.
  • Carrier Purchase: This column displays any carrier charges applied at the source of the product. This value is retrieved from the source of the product(whether purchased or produced). On hover, displays the info text “Carrier charges at the source of the product”.
  • Result: This shows the amount of profit or loss (in Euros) per invoice with respect to the price of products from purchase. The negative value in the result depicts loss. On hover, displays the info text “Result”.
What are your feelings
Updated on September 19, 2024
Table Of Contents

FAQ'S

Accounts and Financial

  • Unable to find invoice for export in current month

    Invoices are displayed on the export screen in a particular month. The month of the invoice is taken from the invoice date and not from another date, such as the due date.

    The invoice date is therefore leading in terms of month for export periods. For example: Invoice date 22-05-2022 and due date 15-06-2022. This invoice will appear in the export under the month May.