Scenario Example: Calculating Cash Flow Dates and Amounts for Open Invoices

This topic shows how the cash flow forecast dates and amounts are calculated for an open sales invoice.

Calculating Cash Flow Forecast Dates and Amounts

If the payment discount terms have not expired, the cash flow forecast assumes that the customer will pay on the date when the terms expire and get a discount. If the payment discount terms have expired, the cash flow forecast assumes that the customer will pay on the payment due date and will not get a discount.

Scenario Example

The following list describes the scenario example that is used to show how the cash flow forecast dates and amounts are calculated.

  • The invoice date is January 1, 2013.

  • The invoice amount is 100.00 local currency (LCY).

  • The invoice payment terms are 14 days/5 days-2%.

  • The cash flow payment terms are 21 days/3 days-4%.

Results

This section uses the setup scenarios that are described in the Cash Flow Forecast Dates and Amounts topic to show the calculation results of the cash flow forecast dates and amounts.

Results Based on Setup Scenario 1

The following table shows the cash flow forecast dates and amounts based on the setup scenario 1.

Work date Cash flow forecast date Cash flow forecast amount

Any work date between January 1, 2013 and January 4, 2013

January 4, 2013

96

Results Based on Setup Scenario 2

The following table shows the cash flow forecast dates and amounts based on the setup scenario 2.

Work date Cash flow forecast date Cash flow forecast amount

Any work date after January 5, 2013

January 22, 2013

100

Results Based on Setup Scenario 3

The following table shows the cash flow forecast dates and amounts based on the setup scenario 3.

Work date Cash flow forecast date Cash flow forecast amount

Any work date between January 1, 2013 and January 6, 2013

January 6, 2013

98

Results Based on Setup Scenario 4

The following table shows the cash flow forecast dates and amounts based on the setup scenario 4.

Work date Cash flow forecast date Cash flow forecast amount

Any work date after January 7, 2013

January 15, 2013

100

See Also

Concepts

Cash Flow Forecast Dates and Amounts