Cash Flow Forecast Dates and Amounts

This topic describes the frequently used setup combinations to show how cash flow forecasts are made.

Cash Flow Payment Terms

Cash flow payment terms work in the similar way as standard payment terms. Cash flow payment terms must contain a due date calculation formula that is used to calculate the due date. In addition, cash flow payment terms can contain a discount date calculation formula with a discount percentage that is used to calculate the cash discount date and amount. After you have assigned cash flow payment terms to a customer or vendor, the cash flow date is calculated based on either the due date or the cash discount date. In addition to the cash flow discount date, the cash discount amount is also calculated.

For more information about standard payment terms, see Payment Terms and How to: Set Up Payment Terms.

Note

There are a variety of options for setting up standard payment terms and cash flow payment terms. Different setup combinations affect how cash flow forecast dates and amounts are calculated. If you are familiar with these setup combinations, you can understand how cash flow forecast dates and amounts are calculated.

Note

Cash flow payment terms are not valid in the Italian version of Microsoft Dynamics NAV 2013 R2.

Calculating Cash Flow Forecast Dates and Amounts Based On Setup Scenario 1

The cash flow forecast uses the cash discount date and the cash discount amount that are defined in the Cash Flow Payment Terms Code field in the Customer table and the Cash Flow Payment Terms Code field in the Vendor table.

The following table describes the setup scenario.

Setup field name Setup definition

Cash Flow Payment Terms Code in the Customer table or Cash Flow Payment Terms Code in the Vendor table

The field is set up and contains cash flow payment terms with cash discount.

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is selected.

Consider Discount in the Cash Flow Forecast Card window

The check box is selected.

Work date

Either before or on the cash discount date that is defined in the cash flow payment terms.

Calculating Cash Flow Forecast Dates and Amounts Based On Setup Scenario 2

The cash flow forecast uses the due date and the full amount that are defined in the Cash Flow Payment Terms Code field in the Customer table and the Cash Flow Payment Terms Code field in the Vendor table in both scenario A and scenario B.

The following table describes the setup scenario A.

Setup field name Setup definition

Cash Flow Payment Terms Code in the Customer table or Cash Flow Payment Terms Code in the Vendor table

The field is set up and contains cash flow payment terms without cash discount.

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is selected.

Consider Discount in the Cash Flow Forecast Card window

N/A

Work date

N/A

The following table describes the setup scenario B.

Setup field name Setup definition

Cash Flow Payment Terms Code in the Customer table or Cash Flow Payment Terms Code in the Vendor table

The field is set up and contains cash flow payment terms with cash discount.

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is selected.

Consider Discount in the Cash Flow Forecast Card window

N/A

Work date

After the cash discount date defined in the cash flow payment terms.

Calculating Cash Flow Forecast Dates and Amounts Based On Setup Scenario 3

The cash flow forecast uses the standard cash discount date and discount amount in both scenario A and scenario B.

The following table describes the setup scenario A.

Setup field name Setup definition

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is not selected.

Payment Terms Code in the Customer table or Payment Terms Code in the Vendor table

The field is set up and contains standard payment terms with cash discount.

Consider Discount in the Cash Flow Forecast Card window

The check box is selected.

Work date

Either before or on the standard cash discount date defined in the standard payment terms.

The following table describes the setup scenario B.

Setup field name Setup definition

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is selected.

Cash Flow Payment Terms Code in the Customer table or Cash Flow Payment Terms Code in the Vendor table

The field is not set up and does not contain cash flow payment terms.

Payment Terms Code in the Customer table or Payment Terms Code in the Vendor table

The field is set up and contains standard payment terms with cash discount.

Consider Discount in the Cash Flow Forecast Card window

The check box is selected.

Work date

Either before or on the standard cash discount date defined in the standard payment terms.

Calculating Cash Flow Forecast Dates and Amounts Based On Setup Scenario 4

The cash flow forecast uses the standard due date and full amount in scenario A, scenario B, and scenario C.

The following table describes the setup scenario A.

Setup field name Setup definition

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is not selected.

Consider Discount in the Cash Flow Forecast Card window

The check box is not selected.

The follow table describes the setup scenario B.

Setup field name Setup definition

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is not selected.

Payment Terms Code in the Customer table or Payment Terms Code in the Vendor table

The field is set up and contains standard payment terms with cash discount

Consider Discount in the Cash Flow Forecast Card window

The check box is selected.

Work date

After the standard cash discount date defined in the standard payment terms.

The follow table describes the setup scenario C.

Setup field name Setup definition

Consider CF Payment Terms in the Cash Flow Forecast Card window

The check box is selected.

Cash Flow Payment Terms Code in the Customer table or Cash Flow Payment Terms Code in the Vendor table

The field is not set up and does not contain cash flow payment terms.

Payment Terms Code in the Customer table or Payment Terms Code in the Vendor table

The field is set up and contains standard payment terms with cash discount.

Consider Discount in the Cash Flow Forecast Card window

The check box is selected.

Work date

After the standard cash discount date defined in the standard payment terms.

Note

To see an example of how cash flow forecast dates and amounts are calculated based on the setup scenarios described in the topic, see Scenario Example: Calculating Cash Flow Dates and Amounts for Open Invoices.

See Also

Tasks

How to: Set Up Payment Terms
How to: Register Cash Flow Worksheet Lines

Concepts

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

Other Resources

Payment Terms
Cash Flow Payment Terms Code
Cash Flow Payment Terms Code
Payment Terms Code
Payment Terms Code
Calc. Pmt. Disc. on Cr. Memos
Pmt. Discount Date
Due Date
Pmt. Discount Date
Due Date