Calculate, view, and print a cash flow forecast [AX 2012]

Updated: May 13, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

A cash flow forecast is a financial statement that summarizes and provides details about the sources and uses of a legal entity’s cash and cash equivalents over a specific period of time. You can calculate, view, and print a cash flow statement.

Use the Calculate cash flow forecasts form to calculate, view, and print a cash flow forecast.

  1. Click General ledger > Periodic > Currency requirement > Calculate cash flow forecasts.

  2. Select how to calculate cash flow forecasts.

    • Total – Clear all existing cash flow forecast transactions and recalculate.

    • New – Create a new cash flow forecast, but do not clear other cash flow forecasts. Select this option to view the consequences of modifying budgets.

  3. Update batch processing options, if you have to, and then click OK to calculate the cash flow forecast.

Refer to the following table to view the results of the cash flow calculation for sales orders, purchase orders, main accounts, and inventory items.

Cash flow forecast for

Path and form to use


  1. Click Sales and marketing > Common > Sales orders > All sales orders.

  2. Select a sales order to view.

  3. On the Action Pane, click the Invoice tab, and then click Cash flow forecast.


  1. Click Procurement and sourcing > Common > Purchase orders > All purchase orders.

  2. Select a purchase order to view.

  3. On the Action Pane, click the Invoice tab, and then click Cash flow forecasts.

Main accounts

  1. Click General ledger > Common > Main accounts.

  2. Select a main account to view.

  3. On the Action Pane, click Cash flow forecasts.


  1. Click Product information management > Common > Released products.

  2. Select an item number to view.

  3. On the Action Pane, click the Plan tab, and then click Inventory forecast. To view purchases and sales, click Supply forecast or Demand forecast, respectively.

You can print a report when you view the cash flow results that are shown in each form that is listed in the previous table.

  1. Click the File menu > Print > Print, and make selections in the Autoreport form to print a report.

  2. In the Financial statement form, you can set up a cash flow forecast to print as a financial statement or part of a financial statement by selecting one or more of the following options in the Column type field: Cash flow forecast, Cash flow forecast currency, or Cash flow forecast default currency.

For more information, see About traditional financial statements.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).