Set up cash flow forecasts (form)

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

Click General ledger > Setup > Chart of accounts > Chart of accounts. Select a chart of accounts. Select a main account then click Edit on the Main accounts FastTab. Select Companies in the Select the level of main account to display field and select a legal entity. On the Setup FastTab, click Cash flow forecast.

Use this form to set up main or budget accounts that are used in cash flow forecasts. In the cash flow forecast, future transactions are estimated based on information that is already registered, such as invoices that are not yet paid, expected sales tax payments, and budget register entries.

To include the line in the cash flow forecast, set up the fields as follows:

• Percent = 100%

• Terms of payment = Blank (no value)

• Main account = Main account for the budget account

For a sales or purchase forecast, select a Terms of payment value that is typical for most customers or vendors.

Tasks that use this form

Set up dependent cash flow forecasts in main accounts

Include budgets in cash flow forecasts

Data used to calculate cash flow

The following information explains what types of transactions are considered when calculating the cash flow.

• Sales orders – Sales orders that are not yet invoiced and that result in physical or financial sales.

• Purchase orders – Purchase orders that are not yet invoiced and that result in physical or financial purchases.

• Accounts receivable – Open customer transactions (invoices that are not yet paid).

• Accounts payable – Open vendor transactions (invoices that are not yet paid).

• Ledger transactions – Transactions where it is specified that a future posting will occur, such as sales tax payments.

  Note

  For sales taxes, sales tax payment periods might not yet be created for the future. You still can calculate cash flow forecasts, but the sales tax payment date cannot be defined.

• Budget register entries – Budget register entries that are selected for cash flow forecasts.

• Customer sales budget – Sales budget amounts that are selected for cash flow forecasts.

• Vendor purchase budget – Purchase budget amounts that are selected for cash flow forecasts.

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Fields

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