General ledger cube (LedgerCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack

Article
11/29/2021

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 Feature Pack, Microsoft Dynamics AX 2012

Use the General ledger cube to report on ledger accounts and bank accounts.

Configuration keys

The following configuration keys are required to use all features of the General ledger cube:

Bank (Bank)
Check (BankCheque)
Reporting currency (CurrencySecondaryCurrency)l
General ledger (LedgerBasic)

Tables and views

The General ledger cube uses data from the following tables and views:

BankAccountTable table
BankAccountTrans table
BankChequePaymTrans table
BankTransType table
BudgetModel table
CustTransOpen table
VendTransOpen table
BudgetTransactionCube view
DimensionFocusBalanceCube view
GeneralJournalCube view
LedgerDerivedFinAttrValueCombinations (This view is used in Microsoft Dynamics AX 2012 Feature Pack.)
LedgerDerivedFinHierarchyCategory (This view is used in Microsoft Dynamics AX 2012 Feature Pack.)
LedgerDerivedFinHierarchyResults (This view is used in Microsoft Dynamics AX 2012 Feature Pack.)
MainAccountCube view

Measures

The General ledger cube includes the following measure groups.

Ledger derived financial hierarchy results

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

Note

This measure group is available in Microsoft Dynamics AX 2012 Feature Pack.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Ledger derived financial hierarchy results count	Not applicable	Count	The number of ledger hierarchy results.	Ledger derived financial attribute value combinations Derived financial category hierarchy Ledger derived financial hierarchy results Company

Ledger derived financial hierarchy results count

Not applicable

Count

The number of ledger hierarchy results.

Ledger derived financial attribute value combinations

Derived financial category hierarchy

Ledger derived financial hierarchy results

Company

Open customer transactions

This measure group is based on the CustTransOpen table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Accounts receivable open amount – accounting currency	CustTransOpen.AmountMST	Sum	Accounts receivable open amount, in accounting currency.	Company Customer Date (last interest date) Date (due date) Date (cash discount date) Date (transaction date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (due date – fiscal calendar) Fiscal period date (cash discount date – fiscal date) Fiscal period date (last interest date – fiscal calendar)

Accounts receivable open amount – accounting currency

CustTransOpen.AmountMST

Sum

Accounts receivable open amount, in accounting currency.

Company

Customer

Date (last interest date)

Date (due date)

Date (cash discount date)

Date (transaction date)

Date (exchange rate date)

Fiscal period date (transaction date – fiscal calendar)

Fiscal period date (due date – fiscal calendar)

Fiscal period date (cash discount date – fiscal date)

Fiscal period date (last interest date – fiscal calendar)

Open vendor transactions

This measure group is based on the VendTransOpen table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Accounts payable open amount – accounting currency	VendTransOpen.AmountMST	Sum	Accounts payable open amount, in accounting currency.	Company Date (due date) Date (cash discount date) Date (transaction date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (due date –fiscal calendar) Fiscal period date (cash discount date – fiscal date)

Accounts payable open amount – accounting currency

VendTransOpen.AmountMST

Sum

Accounts payable open amount, in accounting currency.

Company

Date (due date)

Date (cash discount date)

Date (transaction date)

Date (exchange rate date)

Fiscal period date (transaction date – fiscal calendar)

Fiscal period date (due date –fiscal calendar)

Fiscal period date (cash discount date – fiscal date)

Ledger transactions

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

Measure	Measure field name	Aggregation	Description	Associated dimensions
General ledger amount - accounting currency	GeneralJournalCube.AccountingCurrencyAmount	Sum	General ledger amount, in accounting currency.	Currency Ledger derived financial attribute value combinations Derived financial category hierarchy Company Chart of accounts Ledger transaction Date (transaction date) Date (acknowledgement date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (acknowledgement date – fiscal calendar) Date (document date) Fiscal period date (document date – fiscal calendar)
General ledger amount - transaction currency	GeneralJournalCube.TransactionCurrencyAmount	Sum	General ledger amount, in transaction currency.
General ledger amount - reporting currency	GeneralJournalCube.ReportingCurrencyAmount	Sum	General ledger amount, in reporting currency.

Measure

Measure field name

Aggregation

Description

Associated dimensions

General ledger amount - accounting currency

GeneralJournalCube.AccountingCurrencyAmount

Sum

General ledger amount, in accounting currency.

Currency

Ledger derived financial attribute value combinations

Derived financial category hierarchy

Company

Chart of accounts

Ledger transaction

Date (transaction date)

Date (acknowledgement date)

Date (exchange rate date)

Fiscal period date (transaction date – fiscal calendar)

Fiscal period date (acknowledgement date – fiscal calendar)

Date (document date)

Fiscal period date (document date – fiscal calendar)

General ledger amount - transaction currency

GeneralJournalCube.TransactionCurrencyAmount

Sum

General ledger amount, in transaction currency.

General ledger amount - reporting currency

GeneralJournalCube.ReportingCurrencyAmount

Sum

General ledger amount, in reporting currency.

Ledger budgets

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

Measure	Measure field name	Aggregation	Description	Associated dimensions
General ledger budget amount - transaction currency	BudgetTransactionCube.TransactionCurrencyAmount	Sum	General ledger budget amount, in transaction currency.	Currency Ledger derived financial attribute value combinations Company Chart of accounts Ledger budget model Ledger budget Date (transaction date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar)
General ledger budget amount - accounting currency	BudgetTransactionCube.AccountingCurrencyAmount	Sum	General ledger budget amount, in accounting currency.

Measure

Measure field name

Aggregation

Description

Associated dimensions

General ledger budget amount - transaction currency

BudgetTransactionCube.TransactionCurrencyAmount

Sum

General ledger budget amount, in transaction currency.

Currency

Ledger derived financial attribute value combinations

Company

Chart of accounts

Ledger budget model

Ledger budget

Date (transaction date)

Date (exchange rate date)

Fiscal period date (transaction date – fiscal calendar)

General ledger budget amount - accounting currency

BudgetTransactionCube.AccountingCurrencyAmount

Sum

General ledger budget amount, in accounting currency.

Ledger balances

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

Measure	Measure field name	Aggregation	Description	Associated dimensions
Main account credit amount - reporting currency	DimensionFocusBalanceCube.CreditReportingCurrencyAmount	Sum	Main account credit amount, in reporting currency.	Ledger derived financial attribute value combinations Company Chart of accounts Ledger balance Date (transaction date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar)
Main account debit amount - accounting currency	DimensionFocusBalanceCube.DebitAccountingCurrencyAmount	Sum	Main account debit amount, in accounting currency.
Main account debit amount - reporting currency	DimensionFocusBalanceCube.DebitReportingCurrencyAmount	Sum	Main account debit amount, in reporting currency.
Main account credit amount - accounting currency	DimensionFocusBalanceCube.CreditAccountingCurrencyAmount	Sum	Main account credit amount, in accounting currency.

Bank transactions

This measure group is based on the BankAccountTrans table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Bank amount - bank currency	BankAccountTrans.BankTransAmountCur	Sum	Total bank transaction amount, in bank currency.	Currency Ledger derived financial attribute value combinations Company Bank account description Bank transaction type Bank transaction Currency (currency – registration currency) Date (transaction date) Date (bank statement date) Date (acknowledgement date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (bank statement date – fiscal calendar) Fiscal period date (acknowledgement date – fiscal calendar)
Bank amount - transaction currency	BankAccountTrans.AmountCur	Sum	Total bank transaction amount, in transaction currency.
Bank amount - accounting currency	BankAccountTrans.AmountMst	Sum	Total bank transaction amount, in accounting currency.

Measure

Measure field name

Aggregation

Description

Associated dimensions

Bank amount - bank currency

BankAccountTrans.BankTransAmountCur

Sum

Total bank transaction amount, in bank currency.

Currency

Ledger derived financial attribute value combinations

Company

Bank account description

Bank transaction type

Bank transaction

Currency (currency – registration currency)

Date (transaction date)

Date (bank statement date)

Date (acknowledgement date)

Date (exchange rate date)

Fiscal period date (transaction date – fiscal calendar)

Fiscal period date (bank statement date – fiscal calendar)

Fiscal period date (acknowledgement date – fiscal calendar)

Bank amount - transaction currency

BankAccountTrans.AmountCur

Sum

Total bank transaction amount, in transaction currency.

Bank amount - accounting currency

BankAccountTrans.AmountMst

Sum

Total bank transaction amount, in accounting currency.

Bank payment transactions

This measure group is based on the BankChequePaymTrans table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Bank payment amount - transaction currency	BankChequePaymTrans.PaymentAmountCur	Sum	Bank payment amount, in transaction currency.	Currency Company Bank account description Date (transaction date) Date (invoice transaction date) Date (invoice date) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (invoice date – fiscal calendar) Fiscal period date (invoice transaction date – fiscal calendar)

Bank payment amount - transaction currency

BankChequePaymTrans.PaymentAmountCur

Sum

Bank payment amount, in transaction currency.

Currency

Company

Bank account description

Date (transaction date)

Date (invoice transaction date)

Date (invoice date)

Fiscal period date (transaction date – fiscal calendar)

Fiscal period date (invoice date – fiscal calendar)

Fiscal period date (invoice transaction date – fiscal calendar)

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

Exchange rate

BIExchangeRateView.CrossRate

Max

The exchange rate.

Currency

Date (exchange rate date)

Analysis currency

Calculated measures

The General ledger cube contains the following calculated measures.

Calculated measure	Aggregation	Description
General ledger sales - accounting currency	No accumulation	Sales for your organization in accounting currency.
General ledger sales returns and discounts - accounting currency	No accumulation	Sales, returns, and discounts for your organization in accounting currency.
General ledger actuals total - accounting currency	No accumulation	Total actuals for your organization.
General ledger sales total - accounting currency	No accumulation	Total sales for your organization in accounting currency.
General ledger budget total - accounting currency	No accumulation	Total budget amounts for your organization in accounting currency.
General ledger cost of goods sold - accounting currency	No accumulation	Cost of goods sold for your organization in accounting currency.
General ledger gross profit - accounting currency	No accumulation	Gross profit for your organization in accounting currency.
General ledger accounts receivable - accounting currency	Sum	The accounts receivable balance for the organization.
General ledger accounts payable - accounting currency	Sum	The accounts payable balance for the organization.
Main account net amount - accounting currency	No accumulation	Ledger balance net amount for your organization in accounting currency.
Main account net amount - reporting currency	No accumulation	Ledger balance net amount for your organization in reporting currency.

Key performance indicators

The following sections describe the key performance indicators (KPIs) in the General ledger cube.

KPI calculations

The KPIs in the General ledger cube depend on account categories. For information about account categories, see Main account categories and analysis cubes.

An asterisk (*) indicates that the KPI calculations use accumulated amounts. Accumulated amounts, such as some period-to-date amounts, are not stored in the Microsoft Dynamics AX database. For example, to calculate a period-to-date amount, all the transactions from the beginning of the fiscal calendar to the end of the previous period are totaled. Then all the amounts from the beginning of the fiscal calendar to the current date are totaled. The difference between these two amounts is the period-to-date amount.

You can use the information in the following table to help verify the information in your KPIs. Export your chart of accounts to Office Excel and verify that the accounts that should be included in the KPIs are assigned to the correct ledger account category.

KPI	Calculation
Accounts payable turnover *	[Cost of Goods Sold (Reference ID = 35) + (Ending Inventory (Reference ID = 5) for period - Beginning Inventory (Reference ID = 5) for period)] / [Beginning Accounts Payable (Reference ID = 15) + Ending Accounts Payable (Reference ID = 15) / 2] Note * Only the Inventory and Accounts Payable parts of this KPI are accumulated.
Accounts receivable turnover *	[Sales (Reference ID = 33) -1] - Sales Returns and Discounts (Reference ID = 34) / [Beginning Accounts Receivable (Reference ID = 4) + Ending Accounts Receivable (Reference ID = 4) / 2] Note Only the Accounts Receivable part of this KPI is accumulated.
Average days to pay *	Ending Accounts Payable (Reference ID = 15) balance for the period / [Cost of Goods Sold (Reference ID = 35) + (Ending Inventory (Reference ID = 5) for the period - Beginning Inventory (Reference ID=5) for the period)] * Number of days in the period Note * Only the Accounts Payable and Inventory parts of this KPI are accumulated.
Average collection period *	Accounts Receivable (Reference ID = 4) / Average Daily Sales (Average Daily Sales = Total Sales for the year to date (Reference ID = 33) -1 / Number of days in fiscal year to date) Note Only the Accounts Receivable part of this KPI is accumulated.
Cash position *	Cash (Reference ID = 1) + Cash Equivalents (Reference ID = 2) Note * Accumulation applies to all calculations.
Cash ratio *	Cash Equivalents (Reference ID = 2) + Cash (Reference ID = 1) / (Accounts Payable (Reference ID = 15) + Notes Payable (Reference ID = 16) + Current Maturities on Long Term Debt (Reference ID = 17) + Taxes Payable (Reference ID = 18) + Interest Payable (Reference ID = 19) + Dividends Payable (Reference ID = 20) + Leases Payable (Current) (Reference ID = 21) + Sinking Fund Payable (Current) (Reference ID = 22) + Other Current Liabilities (Reference ID = 23)) Note * Accumulation applies to all calculations.
Cost of goods sold	Cost of Goods Sold (Reference ID = 35)
Current ratio *	[Cash (Reference ID = 1) + Cash Equivalents (Reference ID = 2) + Short Term Investments (Reference ID = 3) + Accounts Receivable (Reference ID = 4) + Inventory (Reference ID = 5) + Notes Receivables (Reference ID = 6) + Work in Process (Reference ID = 7) + Prepaid Expenses (Reference ID = 8) + Other Current Assets (Reference ID = 9) + Inventory (Reference ID = 5)] / [Accounts Payable (Reference ID = 15) + Notes Payable (Reference ID = 16) + Current Maturities on Long Term Debt (Reference ID = 17) + Taxes Payable (Reference ID = 18) + Interest Payable (Reference ID = 19) + Dividends Payable (Reference ID = 20) + Leases Payable (Current) (Reference ID = 21) + Sinking Fund Payable (Current) (Reference ID = 22) + Other Current Liabilities (Reference ID = 23)] Note * Accumulation applies to all calculations.
Debt to equity *	Accounts Payable (Reference ID = 15) + Notes Payable (Reference ID = 16) + Current Maturities on Long Term Debt (Reference ID = 17) + Taxes Payable (Reference ID = 18) + Interest Payable (Reference ID = 19) + Dividends Payable (Reference ID = 20) + Leases Payable (Current) (Reference ID = 21) + Sinking Fund Payable (Current) (Reference ID = 22) + Other Current Liabilities (Reference ID = 23) + Long Term Debt (Reference ID = 24) / Common Stock (Reference ID = 25) + Preferred Stock (Reference ID = 26) + Additional Paid in Capital: Common (Reference ID = 27) + Additional Paid in Capital: Preferred (Reference ID = 28) + Retained Earnings (Reference ID = 29) + Treasury Stock (Reference ID = 30) Note * Accumulation applies to all calculations.
Debt to total assets *	[Accounts Payable (Reference ID = 15) + Notes Payable (Reference ID = 16) + Current Maturities on Long Term Debt (Reference ID = 17) + Taxes Payable (Reference ID = 18) + Interest Payable (Reference ID = 19) + Dividends Payable (Reference ID = 20) + Leases Payable (Current) (Reference ID = 21) + Sinking Fund Payable (Current) (Reference ID = 22) + Other Current Liabilities (Reference ID = 23) + Long Term Debt (Reference ID = 24)] / [Cash (Reference ID = 1) + Cash Equivalents (Reference ID = 2) + Short Term Investments (Reference ID = 3) + Accounts Receivable (Reference ID = 4) + Inventory (Reference ID = 5) + Notes Receivables (Reference ID = 6) + Work in Process (Reference ID = 7) + Prepaid Expenses (Reference ID = 8) + Other Current Assets (Reference ID = 9) + Long Term Investments (Reference ID = 10) + Property Plant and Equipment (Reference ID = 11) + Accumulated Depreciation (Reference ID = 12) + Intangible Assets (Reference ID = 13) + Other Assets (Reference ID = 14)] Note * Accumulation applies to all calculations.
Gross profit	[Sales (Reference ID = 33) *-1] - Sales Returns and Discounts Reference ID = 34) - Cost of Goods Sold (Reference ID = 35) Note The Sales account category is multiplied by -1 to reflect the sales amount as a positive value.
Gross profit margin	[Sales (Reference ID = 33) -1] - Sales Returns and Discounts (Reference ID = 34) - Cost of Goods Sold (Reference ID = 35) / [Sales (Reference ID = 33) -1] - Sales Returns and Discounts (Reference ID = 34))
Inventory turnover *	Cost of Goods Sold (Reference ID = 35) / [Beginning Inventory (Reference ID = 5) + Ending Inventory (Reference = 5) / 2] Note * Only the Inventory part of this KPI is accumulated.
Net income	Result A - Result B Result A = [Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Sales Returns and Discounts (Reference ID = 34)] *-1 Result B = Cost of Goods Sold (Reference ID = 35) + Selling Expense (Reference ID = 36) + Administrative Expense (Reference ID = 37) + Manufacturing Expense (Reference ID = 38) + Travel and Entertainment Expenses (Reference ID = 39) + Project Operation Expenses (Reference ID = 40) + Salaries Expense (Reference ID = 41 ) + Other Employee Expenses (Reference ID = 42) + Interest Expense (Reference ID = 43) + Tax Expense (Reference ID = 44) + Depreciation Expense (Reference ID = 45) + Income Tax Expense (Reference ID = 46) + Other Expenses (Reference ID = 47)
Quick ratio *	[Cash (Reference ID =1) + Cash Equivalents (Reference ID = 2) + Short Term Investments (Reference ID = 3) + Accounts Receivable (Reference ID = 4) + Notes Receivables (Reference ID = 6)] / (Accounts Payable (Reference ID = 15) + Notes Payable (Reference ID = 16) + Current Maturities on Long Term Debt (Reference ID = 17) + Taxes Payable (Reference ID = 18) + Interest Payable (Reference ID=19) + Dividends Payable (Reference ID = 20) + Leases Payable (Current) (Reference ID=21) + Sinking Fund Payable (Current) (Reference ID = 22) + Other Current Liabilities (Reference ID = 23) Note * Accumulation applies to all calculations.
Return on total assets *	[Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Gain or Loss on Asset Disposal (Reference ID = 51) -1] - Sales Returns and Discounts (Reference ID = 34) - Cost of Goods Sold (Reference ID = 35) - Selling Expense (Reference ID = 36) - Administrative Expense (Reference ID = 37) - Manufacturing Expense (Reference ID = 38) - Travel and Entertainment Expenses (Reference ID = 39 ) - Project Operation Expense (Reference ID = 40) - Salaries Expense (Reference ID = 41) - Other Employee Expenses (Reference ID = 42) - Depreciation Expense (Reference ID = 45) - Other Expenses (Reference ID = 47) - Amortization of Intangible Assets (Reference ID = 52) / Cash (Reference ID = 1) + Cash Equivalents (Reference ID = 2) + Short Term Investments (Reference ID = 3) + Accounts Receivable (Reference ID = 4) + Inventory (Reference ID = 5) + Notes Receivables (Reference ID = 6) + Work in Process (Reference ID = 7) + Prepaid Expenses (Reference ID = 8) + Other Current Assets (Reference ID = 9) + Long Term Investments (Reference ID = 10) + Property Plant and Equipment (Reference ID = 11) + Accumulated Depreciation (Reference ID = 12) + Intangible Assets (Reference ID = 13) + Other Assets (Reference ID = 14) Note Reference ID 51 is included only if the balance of the accounts in that account category is negative. Otherwise it is excluded. Only the total assets (Reference ID 1 through 14) part of this KPI is accumulated.
Revenue budget variance	Sum of budget amounts for the period selected for the accounts / Sum of actual balances for revenue accounts for the same time period = Variance. The result is displayed as a percentage. The following ledger account categories are included in the sum of the budget amounts and in the sum of the actual amounts: Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Sales Returns and Discounts (Reference ID = 34) + Gain/Loss on Asset Disposal (Reference ID = 51) Note If necessary, the amounts for each account category are summed by dimension combination to compare the budget versus actual amounts by department, cost center, and so on. Reference ID 51 is included only if the balance of the accounts in that account category is negative. Otherwise it is excluded.
Times interest earned	[Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Gain/Loss on Asset Disposal (Reference ID = 51)) *-1] - Sales Returns and Discounts (Reference ID = 34) - Cost of Goods Sold (Reference ID = 35) - Selling Expense (Reference ID = 36) - Administrative Expense (Reference ID - 37) - Manufacturing Expense (Reference ID - 38) - Travel and Entertainment Expenses (Reference ID - 39 ) - Project Operation Expense (Reference ID = 40) - Salaries Expense (Reference ID = 41) - Other Employee Expenses (Reference ID - 42) - Depreciation Expense (Reference ID = 45) - Other Expenses (Reference ID = 47) - Amortization of Intangible Assets (Reference ID = 52) / Interest Expense (Reference ID = 43) Note Reference ID 51 is included only if the balance of the accounts in that account category is negative. Otherwise it is excluded.
Total expenses	Cost of Goods Sold (Reference ID = 35) + Selling Expense (Reference ID = 36) + Administrative Expense (Reference ID = 37) + Manufacturing Expense (Reference ID = 38) + Travel and Entertainment Expense (Reference ID = 39) + Project Operation Expenses (Reference ID = 40) + Salaries Expense (Reference ID = 41 ) + Other Employee Expense (Reference ID = 42) + Interest Expense (Reference ID = 43) + Tax Expense (Reference ID = 44) + Depreciation Expense (Reference ID = 45) + Income Tax Expense (Reference ID = 46) + Other Expenses (Reference ID = 47) + Amortization of Intangible Assets (Reference ID = 52) + Gain/Loss on Asset Disposal (Reference ID = 51) Note Reference ID 51 is included only if the balance of the accounts in that account category is positive. Otherwise it is excluded.
Total revenue	[Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Sales Returns and Discounts (Reference ID = 34) + Gain/Loss on Asset Disposal (Reference ID = 51)] *-1 Note Reference ID 51 is included only if the balance of the accounts in that account category is negative. Otherwise it is excluded.
Earnings before income tax	(Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Sales Returns and Discounts (Reference ID = 34)) *-1 ) - (COGS (Reference ID = 35) + Selling Expense (Reference ID = 36) + Admin Expense (Reference ID = 37) + Manuf Expense (Reference ID = 38) + T&E Expense (Reference ID = 39) + Project and Operation Expense (Reference ID = 40) + Saleries Expense (Reference ID = 41) + Other Employee Expenses (Reference ID = 42) + Interst Expense (Reference ID = 43) + Tax Expense (Reference ID = 44) + Depreciation Expense (Reference ID = 45) + Income Tax Expense (Reference ID = 46) + Other Expenses (Reference ID = 47) )
Expense budget variance	Sum budget amounts for the period selected for the accounts that have the following AccountCategoryRef: Cost of Goods Sold (Reference ID = 35) + Selling Expense (Reference ID = 36) + Admin Expense (Reference ID = 37) + Manuf Expense (Reference ID = 38) + Travel and Enter Expense (Reference ID = 39) + Project Expense (Reference ID = 40) + Salaries Expense (Reference ID = 41 ) + Other Employee Expenses (Reference ID = 42) + Interest Expense (Reference ID = 43) + Tax Expense (Reference ID = 44) + Depr Expense (Reference ID = 45) + Income Tax Expene (Reference ID = 46) + Other Expenses (Reference ID = 47) + Amortization of Intangible Assets (Reference ID = 52) + Gain/Loss on Asset Disposal (Reference ID = 51) / Sum of actual balances for expense accounts for the same time period: Cost of Goods Sold (Reference ID = 35) + Selling Expense (Reference ID = 36) + Admin Expense (Reference ID = 37) + Manu Expense (Reference ID = 38) + Travel and Enter Expense (Reference ID = 39) + Project Expenses (Reference ID = 40) + Salaries Expense (Reference ID = 41 ) + Other Employee Expenses (Reference ID = 42) + Interest Expense (Reference ID = 43) + Tax Expense (Reference ID = 44) + Depr Expense (Reference ID = 45) + Income Tax Expense (Reference ID = 46) + Other Expenses (Reference ID = 47) + Amortization of Intangible Assets (Reference ID = 52) + Gain/Loss on Asset Disposal (Reference ID = 51) Note Reference ID 51 is included only if the balance of the accounts in that account category is positive. Otherwise it is excluded.
Accounts payable	Accounts Payable (Reference ID = 15)
Notes payable	Notes Payable (Reference ID = 16)
Interest payable	Interest Payable (Reference ID = 19)
Other liabilities	Current Maturities on Long Term Debt (Reference ID = 17) + Taxes Payable (Reference ID = 18) + Leases Payable (Current) (Reference ID = 21) + Sinking Fund Payable (Current) (Reference ID = 22) + Other Current Liabilities (Reference ID = 23) + Dividends Payable (Reference ID = 20)
Long-term debt	Long Term Debt (Reference ID = 24)
Cash and cash equivalents	Cash (Reference ID = 1) + Cash Equivalents (Reference ID = 2)
Short-term investment	Short Term Investments (Reference ID = 3)
Accounts receivable	Accounts Receivable (Reference ID = 4)
Notes receivable	Notes Receivable (Reference ID = 6)
Long-term investment	Long Term Investments (Reference ID = 10)
Inventory and WIP	Inventory (Reference ID = 5) + Work in progress (Reference ID = 7)
Other org assets	Prepaid Expenses (Reference ID = 8) + Other Current Assets (Reference ID = 9) + Property Plant and Equipment (Reference ID = 11) + Accumulated Depreciation (Reference ID = 12) + Intangible Assets (Reference ID = 13) + Other Assets (Reference ID = 14)
Net assets	(Sales (Reference ID = 33) + Other Income (Reference ID = 48) + Sales Returns and Discounts (Reference ID = 34) + Gain/loss on asset disposal (Reference ID = 51)) *-1 — (COGS (Reference ID = 35) + Selling Expense (Reference ID = 36) + Admin Expense (Reference ID = 37) + Manuf Expense (Reference ID = 38) + T&E Expense (Reference ID = 39) + Project and Operation Expense (Reference ID = 40) + Salaries Expense (Reference ID = 41) + Other Employee Expenses (Reference ID = 42) + Interest Expense (Reference ID = 43) + Tax Expense (Reference ID = 44) + Depreciation Expense (Reference ID = 45) + Income Tax Expense (Reference ID = 46) + Other Expenses (Reference ID = 47) + Amortization of intangible assets (Reference ID = 52) Gain/loss on asset disposal (Reference ID = 51)) Note Reference ID 51 is included only if the balance of the accounts in that account category is negative. Otherwise it is excluded. Note This KPI is available in Microsoft Dynamics AX 2012 Feature Pack.

Role Centers

The following table lists the Role Centers and web parts that display the KPIs associated with the General ledger cube.

Role Center	Web parts and KPIs
Credit and collections manager	Operational efficiency (displayed by default): Average collection period Accounts receivable turnover
Controller	Profitability analysis (displayed by default): Revenue Expenses Cost of goods sold Gross profit Gross profit margin Net income Investment analysis: Return on total assets Short-term solvency: Cash ratio Cash position Current ratio Quick ratio Operational efficiency: Accounts receivable turnover Average days to pay Accounts payable turnover Revenue budget variance Expense budget variance Inventory turnover Revised long term solvency: Debt to equity Debt to total assets Times interest earned
CFO	Profitability analysis (displayed by default): Revenue Expenses Cost of goods sold Gross profit Gross profit margin Net income Investment analysis: Return on total assets Short-term solvency: Cash ratio Cash position Current ratio Quick ratio Operational efficiency: Accounts receivable turnover Average days to pay Accounts payable turnover Revenue budget variance Expense budget variance Inventory turnover Long-term solvency: Debt to equity Debt to total assets Times interest earned
Account manager	Profitability analysis (displayed by default): Revenue Expenses Cost of goods sold Gross profit Gross profit margin Net income Investment analysis: Return on total assets Short-term solvency: Cash ratio Cash position Current ratio Quick ratio Operational efficiency: Accounts receivable turnover Average days to pay Accounts payable turnover Inventory turnover Revenue budget variance Expense budget variance Long-term solvency: Debt to equity Debt to total assets Times interest earned
Accountant	Operational efficiency (displayed by default): Accounts receivable turnover Average days to pay Accounts payable turnover Inventory turnover Revenue budget variance Expense budget variance Profitability analysis: Revenue Expenses Cost of goods sold Gross profit Gross profit margin Net income Investment analysis: Return on total assets Revised short-term solvency: Cash ratio Cash position Current ratio Quick ratio Long-term solvency: Debt to equity Debt to total assets Times interest earned
Treasurer	Treasurer asset analysis (displayed by default): Cash and cash equivalents Short-term investments Accounts receivable Notes receivable All other org. assets Long-term investments Return on total assets Inventory and work in progress Profitability analysis: Revenue Expenses Cost of goods sold Gross profit Gross profit margin Net income Investment analysis: Return on total assets Short-term solvency: Cash ratio Cash position Current ratio Quick ratio Investment analysis: Return on total assets Operational efficiency Accounts receivable turnover Average days to pay Accounts payable turnover Revenue budget variance Expense budget variance Inventory turnover Long-term solvency: Debt to equity Debt to total assets Times interest earned Treasurer liability analysis: Accounts payable Notes payable Interest payable Other liabilities Long-term debt

Security

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

Accountant
Accounting manager
Accounting supervisor
Accounts payable centralized payments clerk
Accounts payable clerk
Accounts payable manager
Accounts payable payments clerk
Accounts receivable clerk
Accounts receivable manager
Accounts receivable payments clerk
Accounts receivable centralized payments clerk
Budget clerk
Budget manager
Chief executive officer
Chief financial officer
Collections agent
Collections manager
Compliance manager
Financial controller
Treasurer

General ledger cube (LedgerCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack

Configuration keys

Tables and views

Measures

Ledger derived financial hierarchy results

Open customer transactions

Open vendor transactions

Ledger transactions

Ledger budgets

Ledger balances

Bank transactions

Bank payment transactions

Exchange rates by day

Calculated measures

Key performance indicators

KPI calculations

Role Centers

Security

Additional resources