General ledger cube (LedgerCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack [AX 2012]
Updated: July 3, 2012
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.
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
The General ledger cube includes the following measure groups.
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 |
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) |
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) |
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. |
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. |
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. |
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. |
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) |
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. |
The following sections describe the key performance indicators (KPIs) in the General ledger cube.
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]
| ||||
| 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]
| ||||
| 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
| ||||
| 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)
| ||||
| Cash position * | Cash (Reference ID = 1) + Cash Equivalents (Reference ID = 2)
| ||||
| 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))
| ||||
| 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)]
| ||||
| 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)
| ||||
| 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)]
| ||||
| Gross profit | [Sales (Reference ID = 33) *-1] - Sales Returns and Discounts Reference ID = 34) - Cost of Goods Sold (Reference ID = 35)
| ||||
| 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]
| ||||
| 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)
| ||||
| 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)
| ||||
| 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)
| ||||
| 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)
| ||||
| 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)
| ||||
| 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
| ||||
| 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)
| ||||
| 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))
|
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):
|
| Controller | Profitability analysis (displayed by default):
Investment analysis:
Short-term solvency:
Operational efficiency:
Revised long term solvency:
|
| CFO | Profitability analysis (displayed by default):
Investment analysis:
Short-term solvency:
Operational efficiency:
Long-term solvency:
|
| Account manager | Profitability analysis (displayed by default):
Investment analysis:
Short-term solvency:
Operational efficiency:
Long-term solvency:
|
| Accountant | Operational efficiency (displayed by default):
Profitability analysis:
Investment analysis:
Revised short-term solvency:
Long-term solvency:
|
| Treasurer | Treasurer asset analysis (displayed by default):
Profitability analysis:
Investment analysis:
Short-term solvency:
Investment analysis:
Operational efficiency
Long-term solvency:
Treasurer liability analysis:
|
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
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Note