Accounts payable cube (VendCube) for Microsoft Dynamics AX 2012 R2 and R3

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.

Reference

Deployment

Configuration keys

Tables and views

Measures

Calculated measures

Key performance indicators

Security

Resources

Analytics in Microsoft Dynamics AX

Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3

Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack

Deployment

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.

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

  • VendTransCube view

  • VendTransOpenCube view

  • VendTransTotalPurchasesCube view

Measures

The Accounts payable cube includes the following measure groups.

Open vendor transactions

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)

Vendor transactions

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.

Total vendor purchases

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)

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