Cash Flow Ledger Operations
Algorithm for Generating Cash Flow Ledger Entries
Depending on the source type, Cash Flow Ledger entries are generated according to the following logic:
| Source Type | Calculation of Cash Flow Ledger Entry Amount |
|---|---|
| Sales Order, Purchase Order | Outstanding amount on the order/invoice (excluding the posted invoice amount for the order) minus applied payments to the document. |
| Accounts Payable (AP) | Remaining balance of the vendor ledger entry (reduced by the applied amount to documents if the entry is a payment). |
| Accounts Receivable (AR) | Remaining balance of the customer ledger entry (reduced by the applied amount to documents if the entry is a payment). |
| Purchase Payment Plan | Payment plan for an invoice: outstanding amount per the AP payment schedule minus the applied amount shown in the schedule for each line. Payment plan for a contract: AP plan entry amount per contract reduced by the applied amount to the plan. |
| Sales Payment Plan | Payment plan for an invoice: outstanding amount per the AR payment schedule minus the applied amount shown in the schedule for each line. Payment plan for a contract: AR plan entry amount per contract reduced by the applied amount to the plan. |
Methods for Generating and Updating Cash Flow Ledger Entries
The logic for generating and updating Cash Flow Ledger entries depends on the settings configured on the Cash Flow Forecast Card.
If the Automatic Deletion of Unpaid Entries option is enabled:
When generating entries via the Suggest Lines task, the system automatically deletes all unpaid entries and entries for which no payments have been created in the Bank Payment Journal. As a result, each subsequent run of the Suggest Lines task regenerates entries according to the current system data, including:
- document statuses (posted / unposted);
- presence of or changes in AP/AR payment schedules;
- changes in applied payments.
This mode allows you to automatically keep the cash flow forecast up to date without manually clearing or adjusting records in the Cash Flow Ledger.
If the Automatic Deletion of Unpaid Entries option is disabled:
The system only adds new records that do not yet exist in the Cash Flow Ledger for the given forecast. Existing records remain unchanged.
Important Any changes that occurred with a document or entry after generating Cash Flow Ledger entries based on them are not automatically reflected in the Cash Flow Ledger for this forecast.
In such cases, data updates are performed manually by the user, for example:
- If an entry was generated based on an unposted document, the system with this setting does not modify the Cash Flow Ledger entry after posting the document. The user needs to delete unpaid entries for the unposted document, generate lines in the Cash Flow Journal, and register them in the Cash Flow Ledger.
- If a payment schedule (AP/AR) was created for a document and Cash Flow Ledger entries were generated based on it, and then this schedule was removed from the document — the related Cash Flow Ledger entries must be deleted manually.
- If a document reversal is performed and automatic deletion of unpaid entries is not used, the user must manually delete the corresponding schedule records and related Cash Flow Ledger entries.
Edit Cash Flow Ledger Entries
The Cash Flow Ledger Entries allows manual editing of the following fields: Cash Flow Date, Amount, Amount (LCY) and Due Date. To edit, select the Edit List function on the Cash Flow Ledger Entries page and edit the entries you want. You can also edit operations on specified fields using the Edit function in Excel.
In addition, it is possible to update the data on the Cash Flow Ledger Entries after making changes to the Receivables/Payables Schedule or the released document, for the following source types Sales Payment Plan, Purchase Payment Plan, Sales Order and Purchase Order, for this use the Update button on the Cash Flow ledger Entries page. For source types Sales Payment Plan and Purchase Payment Plan in the Cash Flow Ledger Entries, the following will be updated: Cash Flow Date, Amount, Amount (LCY) and Due Date. For source types Purchase Order and Sales Order when actual Due Date is changed in the released document, the Cash Flow Ledger Entries will update Cash Flow Date and Due Date.
Cash Flow ledger Entries can be deleted as needed. You can only delete transactions that have not been paid and for which a line has not been created in the financial journal. To delete, select the entries you want and click the Delete button on the Cash Flow Ledger Entries page.