Cash flow (form)

Article
10/09/2018

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

Click Project management and accounting > Common > Projects > All projects. On the Action Pane, on the Control tab, in the Monitor group, click Cash flow.

–or–

Click Project management and accounting > Common > Projects > Project contracts. On the Action Pane, on the Control tab, in the Monitor group, click Cash flow.

–or–

In Microsoft Dynamics AX 2012 R3 or cumulative update 7 or later for AX 2012 R2: Click Project management and accounting > Common > Project resources > Resources. On the Action Pane, on the Project resource tab, in the Project control group, click Cash flow.

–or–

In Microsoft Dynamics AX 2012 R3 or cumulative update 7 or later for AX 2012 R2: Click Project management and accounting > Common > Project resources > Resource availability. On the Action Pane, on the Project resource tab, in the Project control group, click Cash flow.

Use this form to calculate forecasted and actual cash flow.

Navigating the form

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

Tabs

Tab	Description
General	Select the data that you want to include in the cash flow calculation.
Direct	View the amounts that have been entered and the actual cash flow calculation totals.

Buttons

Button	Description
Calculate	Calculate the cash flow with the selected data.
Transaction	Open a transaction form.
Forecast	Open a forecast form.
Export to Microsoft Excel	Export the calculated cash flow data to an Excel PivotTable.

Fields

Field	Description
Included project types	Select the check boxes of the project types that you want to include in the calculation of cash flow.
Included transaction types	Select the check boxes of the transaction types you want to include in the calculation of cash flow.
From date / To date	Enter the start date and the end date in which transactions were posted to a project. From date - Enter a start date if you want to delimit the cash flow calculation. To date - Enter an end date if you want to delimit the cash flow calculation.
From date / To date	Enter the time frame in which payments were made. From date - Enter a start date if you want to delimit the cash flow calculation. To date - Enter an end date if you want to delimit the cash flow calculation.
Actual vs. budget	Select the type of cash flow that you want to display in the calculation. Actual - Display the actual cash flow amount. Budget - Display the budgeted cash flow amount. Deviation - Display the difference between the actual and budgeted cash flow amounts. Sum - Display the actual cash flow from the From date to the Break date and the budgeted cash flow from the Break date to the To date.
Include paid payment	Select this check box to include payments that you have already received in the calculation of cash flow.
Include expected payment	Select this check box to include payments that you expect to receive in the calculation of cash flow.
Add days to due payment	Enter the number of days to add to the sales payment when the expected payment date has passed and no payment has been received.
Minimum payment date	Enter the expected payment date. You can change the expected payment date for sales payments if the original date has passed and no payment has been received.
Add days to due payment	Enter the number of days to add to the cost payment if the expected payment date has passed and no payment has been received.
Minimum payment date	Enter the date that the expected payment date should be changed to for cost payments if the expected payment date has passed and no payment has been received.
Cash inflows	View the cash flow of the invoiced revenue.
Cash outflows	View the cash flow of the consumed cost of the calculated data.
Net cash flows	View the net amount of cash inflow and outflow.
Cash inflows received from sale of goods	View the cash flow of the invoiced revenue.
Invoiced revenue	View the cash inflow of invoiced revenue for hour, expense, item, and fee transactions.
Invoiced - on account	View the cash inflow of invoice revenue for on-account transactions.
Cash paid for - hour	View the cash outflow of the consumed hour cost.
Cash paid for - expense	View the cash outflow of the consumed expense cost.
Cash paid for - item	View the cash outflow of the consumed item cost.
Net cash flows	The total net cash flow for the project.

Cash flow (form)

Navigating the form

Tabs

Buttons

Fields

See also

Additional resources