Budget control cube (BudgetControlCube) for Microsoft Dynamics AX 2012 R2 and R3 [AX 2012]
Updated: July 22, 2014
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
The Budget control cube for Microsoft Dynamics AX is used to analyze data from budget register entries. Analysis of this data helps organizations effectively manage their approved budgets and make decisions based on accurate information. This article provides details about the cube.
The Budget control cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX project—and the cubes that it contains—see Deploy the default cubes.
The Budget control cube includes the following measure groups.
This measure group is based on the BudgetSourceTrackingCube view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Amount | BudgetSourceTrackingCube.TrackingDetailAmount | Sum | The budgeted amount, in the accounting currency. | Budget control configuration Budget control Company Chart of accounts Ledger derived financial attribute value combinations Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar Date (transaction date) |
| Relieved amount | BudgetSourceTrackingCube.TrackingRelievedDetailAmount | Sum | The relieved budgeted amount, in the accounting currency. |
The Budget control cube contains the following calculated measures.
| Calculated measure | Aggregation | Associated measure group | Description | ||
|---|---|---|---|---|---|
| Original budget | Sum | Budget control amounts | The budget register entries that have the following budget type: Original budget, Fixed asset, Project, Demand, and Supply and have a budget register entry status = Confirmed. Fixed asset, project, demand, and supply transaction types are used when transferring budget from either Fixed assets, Project, or Inventory, and are treated as original budget amounts. For example, when budget transactions of these types are checked for budget control, they are translated to the original budget category. | ||
| Completed revisions | Sum | Budget control amounts | The budget register entries with the transaction type = Revision, and that have a budget register entry status = Confirmed. | ||
| Draft revisions | Sum | Budget control amounts | The budget register entries with the transaction type = Revision, and that have a budget register entry status = Draft. | ||
| Total revisions | Sum | Budget control amounts | The sum of completed and draft budget revisions. | ||
| Completed budget transfers | Sum | Budget control amounts | The budget register entries with the budget type = Transfer, and that have a budget register entry status = Confirmed. | ||
| Draft budget transfers in | Sum | Budget control amounts | The budget register entries with the transaction type = Transfer, have a budget register entry status = Draft, and the impact to budget is an increase. | ||
| Draft budget transfers out | Sum | Budget control amounts | The budget register entries with the budget type = Transfer, have a budget register entry status = Draft, and the impact to budget is a decrease. | ||
| Total transfers | Sum | Budget control amounts | The sum of completed budget transfers, draft budget transfers in, and draft budget transfers out. | ||
| Total revised budget | Sum | Budget control amounts | The sum of original budget, total revisions, and total transfers. | ||
| Posted actual expenditures | Sum | Budget control amounts | The vendor invoices and expense reports that have been recorded in the subledger journal, as well as accounting journals that have been posted. The amounts for the source documents and accounting journals are only included in the budget check when the corresponding document type is enabled for budget control. For these source documents and accounting journals the actual expense is recorded in the ledger at this time. | ||
| Unposted actual expenditures | Sum | Budget control amounts | The vendor invoices and expense reports that have been entered, but not yet recorded in the subledger journal. This also includes accounting journals that have been entered, but not yet posted to ledger. The amounts for the source documents and accounting journals are only included in the budget check when the corresponding document type or accounting journal is enabled for budget control. | ||
| Total actual expenditures | Sum | Budget control amounts | The sum of posted and unposted actual expenditures. | ||
| Confirmed encumbrances | Sum | Budget control amounts | The budget reservations that are created for confirmed purchase orders or travel requests. This also includes budget register entries that are in a status of Confirmed and utilize the budget type of Encumbrance (manual reservations of budget created through budget register entries). | ||
| Unconfirmed encumbrances | Sum | Budget control amounts | The budget reservations that are created for unconfirmed purchase orders or travel requests. This also includes budget register entries that are in a status of Draft and utilize the budget type of Encumbrance (manual reservations of budget created through budget register entries that are not yet included in the overall budget balance). | ||
| Unconfirmed encumbrance reductions | Sum | Budget control amounts | The correction made to a confirmed purchase order, and that change results in a decrease to the original budget reservation related to the purchase order amounts and accounts. | ||
| Total budget reservations for encumbrances | Sum | Budget control amounts | The sum of confirmed and unconfirmed encumbrances and unconfirmed reductions. | ||
| Confirmed pre-encumbrances | Sum | Budget control amounts | The budget reservations that are created for approved or confirmed purchase requisitions. This also includes budget register entries that are in a status of Confirmed and utilize the budget type of Pre-encumbrance. | ||
| Unconfirmed pre-encumbrances | Sum | Budget control amounts | The budget reservations that are created for unconfirmed and unapproved purchase requisitions. This also includes budget register entries that are in a status of Draft and utilize the budget type of Pre-encumbrance (manual reservations of budget created through budget register entries that are not yet included in the overall budget balance). | ||
| Total budget reservations for pre-encumbrances | Sum | Budget control amounts | The sum of confirmed and unconfirmed pre-encumbrances. | ||
| Carry-forward revised budget amount | Sum | Budget control amounts | The revised budget amounts that were carried forward as part of the purchase order year-end process, or budget register entries that use a budget type of Carry Forward. | ||
| Carry-forward encumbrances amount | Sum | Budget control amounts | The encumbrance amounts that were carried forward as part of the purchase order year-end process, or budget transactions that use a transaction type of Carry Forward. | ||
| Carry-forward actual expenditures amount | Sum | Budget control amounts | The actual expenditure amounts that were carried forward as part of the purchase order year-end process, or budget register entries that use a budget type of Carry Forward. | ||
| Total carry-forward budget amounts | Sum | Budget control amounts | The sum of revised, encumbrance, and actual expenditure carry-forward amounts. | ||
| Budget funds available | Sum | Budget control amounts | The remaining balance of a budget using the formula defined on the budget control configuration. | ||
| Carry-forward budget
| Sum | Budget control amounts | The original budget amounts that were carried forward as part of the purchase order year end process or budget register entries that use a budget type of Carry Forward. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Note