Cashflow purchase

General description #

The cash flow purchase report describes the outgoing cash flow based on invoices and different estimates from purchase orders. The report includes columns order number., ETA, ETD, purchase contract, payment term, etc. The payment term is calculated based on the payment terms ETA and ETD. This report is only for orders with the origin side set as purchase.

The report is available only for customers with configuration rapport.cashflow set to true.

Columns #

  • Order number: This column displays the order number. On hover, the column displays the short info text “Order number”.
  • Subsidiary: This column displays the operating subsidiary selected for the order. On hover, the column displays the short info text “Subsidiary that owns the contract/lot”.
  • Order date: This column displays the creation date of the order. On hover, the column displays the short info text “Order date”.
  • Loading date: The loading date from the general section of the order is displayed in this column. On hover, the column displays the short info text “The loading date of the lot”.
  • Unloading date: The unloading date from the general section of the order is displayed in this column. On hover, the column displays the short info text “The unloading date for the lot”.
  • Purchase Contract: The purchase contract number selected from the origin side of the order is displayed in this column. On hover, the column displays the short info text “Purchase contract number”.
  • Payment condition: This column displays the payment condition of the purchase contract. On hover, the column displays the short info text “Payment condition”.
  • Due Date: This column displays the due date of payment. This is calculated on the basis of the payment date selected. On hover, the column displays the short info text “Due date”.
  • Expected payment date week: This column displays the week number of the expected payment date. On hover, the column displays the short info text “Due date week”.
  • Supplier: This column displays the relation name selected in the purchase contract. On hover, the column displays the short info text “The Supplier”.
  • Product: This column displays the product name of which the purchase contract is created. On hover, the column displays the short info text “The shortcode of the product”.
  • Unit: The standard unit of measurement used for the product is displayed in this column. On hover, the column displays the short info text “Quantity Unit”.
  • Purchase price per kg: The price per kg of the contract is displayed in this column. On hover, the column displays the short info text “Purchase price per KG”.
  • Quantity: This column displays the quantity used in the purchase contract. On hover, the column displays the short info text “Quantity per contract line”.
  • Supplier invoice number: This column displays the supplier invoice number set from the origin side of the order. On hover, the column displays the short info text “Supplier invoice number”.
  • Currency: This column displays the currency of the purchase contract. On hover, the column displays the short info text “Currency”.
  • Exchange Rate: This column displays the exchange rate of the purchase contract. On hover, the column displays the short info text “Currency exchange rate”.
  • Total Amount: This column displays the total amount in the expected goods invoice. On hover, the column displays the short info text “Total Amount”.
  • System Exchange Rate: This column displays the system exchange rate in the expected goods invoice. On hover, the column displays the short info text “System exchange rate”.
  • In transit: This column displays the value ‘yes’ or no’ whether the order has arrived at the destination or not. On hover, the column displays the short info text “In Transit status”.
  • Order line unloading date: This column displays the unloading date from the destination side of the order. On hover, the column displays the short info text “Orderline unloading date”.
  • Amount in FC: This column displays the total amount of the goods expected invoice in foreign currency. On hover, the column displays the short info text “Amount in Foreign currency”.
  • Amount in Euro: This column displays the total amount of the goods expected invoice in euros. On hover, the column displays the short info text “Amount in euro”.
  • Remarks: This column displays the remarks of the goods’ expected invoice. On hover, the column displays the short info text “Remarks chosen in contract or placed at stock lot”.
  • Cashflow Remarks: This column displays the value of the cashflow remark field of the origin side of the order. On hover, the column displays the short info text “Cashflow remarks”.
What are your feelings
Updated on September 23, 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.