Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Budget control cube (BudgetControlCube) for Microsoft Dynamics AX 2012 R2 [AX 2012]

Updated: January 30, 2013

Applies To: Microsoft Dynamics AX 2012 R2

Use the Budget control cube 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.

The following configuration keys are required to use all features of the Budget control cube:

  • Budget control (LedgerAdv2BudgetCtrl)

The Budget control cube uses data from the following tables and views:

  • BudgetControlConfigurationCube view

  • BudgetSourceTrackingCube view

The Budget control cube includes the following measure groups.

Budget control amounts

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.

Exchange rates by day

This measure group is based on the BIExchangeRateView view and includes the following measures.

Measure

Measure field name

Aggregation

Description

Associated dimensions

Exchange rate

BIExchangeRateView.CrossRate

Max

The exchange rate.

Currency

Date (exchange rate date)

Analysis 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 where carried forward at 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 at 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 at 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.

The Budget control cube does not include any key performance indicators (KPIs).

The Budget control cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.

  • Accounting manager

  • Accounting supervisor

  • Budget manager

  • Chief executive officer

  • Chief financial officer

  • Compliance manager

  • Financial controller

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.