Accounts payable cube (VendCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack
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 Accounts payable cube to report on purchase transactions.
Configuration keys
The following configuration keys are required to use all features of the Accounts payable cube:
- General ledger (LedgerBasic)
Tables and views
The Accounts payable cube uses data from the following tables and views:
VendPaymModeTable table
VendTrans table
VendTransOpen table
VendTransTotalPurchases view
Measures
The Accounts payable cube includes the following measure groups.
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 |
Total open vendor transaction amount, in accounting currency. |
Company Vendor Date (due date) Date (transaction date) Date (exchange rate date) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (due date – fiscal calendar) Date (cash discount date) Fiscal period date (cash discount date – fiscal calendar) |
Vendor transactions
This measure group is based on the VendTrans table and includes the following measures.
| Measure |
Measure field name |
Aggregation |
Description |
Associated dimensions |
|---|---|---|---|---|
| Accounts payable amount – transaction currency |
VendTrans.AmountCur |
Sum |
Total vendor transaction amount, in transaction currency. |
Currency Company Vendor Methods of payment - vendor Vendor transaction Date (due date) Date (last settlement date) Date (closed date) Date (transaction date) Date (document date) Date (approved date) Date (exchange rate date) Fiscal period date (last settlement date – fiscal calendar) Fiscal period date (closed date – fiscal calendar) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (document date – fiscal calendar) Fiscal period date (approved date – fiscal calendar) Fiscal period date (due date – fiscal calendar) |
| Accounts payable settled amount – transaction currency |
VendTrans.SettleAmountCur |
Sum |
Total amount of vendor transactions that have been settled, in transaction currency. |
|
| Accounts payable amount – accounting currency |
VendTrans.AmountMST |
Sum |
Total vendor transaction amount, in accounting currency. |
|
| Accounts payable settled amount – accounting currency |
VendTrans.SettleAmountMST |
Sum |
Total amount of vendor transactions that have been settled, in accounting currency. |
Total vendor purchases
This measure group is based on the VendTransTotalPurchases view and includes the following measures.
| Measure |
Measure field name |
Aggregation |
Description |
Associated dimensions |
|---|---|---|---|---|
| Accounts payable total – accounting currency |
VendTransTotalPurchases.AmountMST |
Sum |
Total purchases amount, in accounting currency. |
Currency Company Vendor Methods of payment - vendor Total vendor purchases Date (due date) Date (last settlement date) Date (closed date) Date (transaction date) Date (document date) Date (approved date) Date (exchange rate date) Fiscal period date (last settlement date – fiscal calendar) Fiscal period date (closed date – fiscal calendar) Fiscal period date (transaction date – fiscal calendar) Fiscal period date (document date – fiscal calendar) Fiscal period date (approved date – fiscal calendar) Fiscal period date (due 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 |
Calculated measures
The Accounts payable cube does not include any calculated measures.
Key performance indicators
The Accounts payable cube does not include any key performance indicators (KPIs).
Security
The Accounts payable 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 manager
Chief executive officer
Chief financial officer
Compliance manager
Financial controller
Purchasing manager
Treasurer