Accounts payable cube (VendCube) for Microsoft Dynamics AX 2012 R2 and R3 [AX 2012]
Updated: July 22, 2014
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
The Accounts payable cube for Microsoft Dynamics AX is used to report on purchase transactions. This article provides details about the cube.
The Accounts payable cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX project—and the cubes that it contains—see Deploy the default cubes.
The Accounts payable cube includes the following measure groups.
This measure group is based on the VendTransOpenCube view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Accounts payable open amount – accounting currency | VendTransOpenCube.AmountMST | Sum | The total open vendor transaction amount, in accounting currency. | Company Vendor Date (transaction date) Date (due 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) |
This measure group is based on the VendTransCube view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Accounts payable amount – transaction currency | VendTransCube.AmountCur | Sum | The total vendor transaction amount, in transaction currency. | Currency Company Vendor Methods of payment - vendor Vendor transaction Date (transaction date) Date (due date) Date (last settlement date) Date (closed 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 | VendTransCube.SettleAmountCur | Sum | The total amount of vendor transactions that have been settled, in transaction currency. | |
| Accounts payable amount – accounting currency | VendTransCube.AmountMST | Sum | The total vendor transaction amount, in accounting currency. | |
| Accounts payable settled amount – accounting currency | VendTransCube.SettleAmountMST | Sum | The total amount of vendor transactions that have been settled, in accounting currency. |
This measure group is based on the VendTransTotalPurchasesCube view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Accounts payable total – accounting currency | VendTransTotalPurchasesCube.AmountMST | Sum | The total purchases amount, in accounting currency. | Currency Company Vendor Methods of payment - vendor Total vendor purchases Date (transaction date) Date (due date) Date (last settlement date) Date (closed 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) |
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
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
