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.