Actual versus budget report (BudgetBalancesActuals)
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The Actual versus budget report displays budget balances for the original budget, revised budget, actual expenditures, and variances. The original budget amounts are the sum of expense and revenue budget amounts. The revised budget amounts are the sum of original budget, revisions, transfers, and carry-forward amounts. The actual expenditures are the sum of the debits and credits that were posted for the selected financial dimension values. Variances are the differences between actual and revised budget amounts, expressed as amounts and percentages. The report is grouped by budget model and dimension values.
Note
This report will not show budget details for encumbrances and pre-encumbrances. To create reports that include those budget types, use either the Budget funds available or Encumbrance and ledger reconciliation reports. For more information, see Budget funds available report (BudgetFundsAvailable) or Encumbrance and ledger reconciliation report (LedgerEncumbranceReconciliation).
How to filter the data on this report
When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.
Field |
Description |
|---|---|
Financial dimension set |
Select a financial dimension set for the report. These were defined in the Financial dimension sets form. A financial dimension set is a named group of accounts or dimensions that contains either account values for the account or dimension values for a single dimension. Examples include main accounts, departments, and cost centers, or combinations such as a cost center and main account, or a department and cost center. For more information, see Financial dimension sets (form). |
Budget model |
Select a budget model. If you leave this field blank, all budget models will be included on the report. For more information, see Budget model (form). |
Posting layer |
Select the ledger classification for the actual balances: Current, Operations, or Tax. For more information, see Posting layer. |
From date |
Select the starting date for budget balances to include on the report. This date must be in a fiscal year that is included in the fiscal calendar that is used by your organization. Tip To include report dates from one fiscal year, you do not have to enter values in both the From date and To date fields. If you enter a value in the From date field, all the periods in the fiscal year after that date will be included on the report. |
To date |
Select the ending date for budget balances to include on the report. This date must be in a fiscal year that is included in the fiscal calendar that is used by your organization. Tip To include report dates from one fiscal year, you do not have to enter values in both the From date and To date fields. If you enter a value in the To date field, all the periods in the fiscal year before that date will be included on the report. |
View by |
Select Show net change to view budget balances by period. Select Show accumulated to view cumulative budget balances for the fiscal year. |
Budget register entry status |
The status, Completed or Draft, of the budget register entries that will be included on the report. The default status is Completed. Click Select to open an inquiry form to change the value. For more information, see Inquiry (form). For more information about the status types, see Budget registry entry (form). |
Date (Budget account entries) |
The date that determines the period for the budget account entries to include on the report. This field cannot be updated. |
How to work with reports
The following topics explain how to print a report and how to filter and sort the data on a report.
Details of this report
The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.
Detail |
Description |
|---|---|
Name of report in the AOT |
BudgetBalancesActuals |
Location of report in the AOT |
SSRS Reports\Reports\BudgetBalancesActuals |
Menu item of the report |
BudgetBalancesActualsReport |
Navigation to the report |
Click Budgeting > Reports > Basic budgeting > Actual versus budget. |
Where the data in this report comes from
The data on this report comes from the following sources:
BudgetBalancesActualsDP.processReport class instance method
BudgetTmpBalance table
If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.
Open the AOT.
Locate the report in the SSRS Reports\Reports node.
Right-click the report and click Add-Ins > Cross-reference > Using (instant view).