Set up cash flow forecasts (form) [AX 2012]

Updated: May 24, 2011

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.

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.

    NoteNote

    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.

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

Tab

Description

Overview

Set up the criteria for a cash flow forecast for the selected main or budget account, according to the posting type and the terms of payment of current and expected transactions.

General

View the Overview tab information for the selected terms of payment and posting type line.

Field

Description

Percent

The percentage to include in the cash flow forecast.

Terms of payment

The terms of payment for the current account entry.

Posting type

The expected posting type, related to the cash flow forecast.

Main account

Select the main account that the share of the amount is posted to.

Transactions/Budget

Select whether the cash flow forecast is from a budget register entry or an accounting transaction.

Main account

(Identification)

The account that the share of the amount is posted from.


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

Community Additions

Show: