About querying dimension balances

  • Article

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

Click Cost accounting > Common > Cost categories.

To view dimension balances for cost categories in the Cost categories form, select a cost category, select either Primary costs or Secondary costs in the Cost type column, and then click Dimension balance > Cost category.

To view query dimension balances for service categories in the Cost categories form, select a cost category, select Service category in the Cost type column, and then click Dimension balance > Service category.

In the Dimension balance form, you can view the dimension balances for the selected period and for two different value types. For each column group, you can select the following value types:

  • Actual costs

  • Budget costs

  • Basic plan costs

  • Flexible plan costs

  • Target costs

Note

If you select Basic plan costs, Flexible plan costs, or Target costs, you must select a budget model.

The Total values section consists of two areas:

  • The total of primary costs, secondary costs, and total costs

  • The dimensions that these costs are posted to

Primary costs are posted to ledger accounts. Secondary costs are generated only in Cost accounting.

For the selected dimension, you can display cost, service, and calculation transactions by clicking Transactions. To display cost balances, click Cost balance.