Accounts Payable

The Accounts Payable module is composed of two cubes:

  • UDM AP Historical Staging
  • UDM AP Historical

The UDM AP Historical Staging cube collects all raw data related to accounts payable (i.e. invoices, credit, payments) to create the views located in the Accounts Payable Historical data model.

The UDM AP Historical cube takes its source from the UDM AP Historical Staging and UDM Dimtime cubes and is used to recreate the Accounts Payable status for each of the fiscal periods. The views located in the Accounts Payable by Period data model are created from this cube.

Note

Tables that are used in the Accounts Payable data models are listed in this file if you want more details.

Accounts Payable Historical

This data model recreates the status of unpaid supplier / vendor accounts from a specific date.

Important

Before following the steps below, perform a recalculation of supplier / vendor accounts in Sage X3.

To get access to these data:

  1. In the Data Models and Views tab, expand the Universal Data Model and the Accounts Payable folders.
  2. Expand the Accounts Payable Historical data model and open the view you are interested to retrieve data.
  3. In the Set Data Model Parameters window, adjust the Date field and click on Confirm.

The views located in this data model give information about supplier / vendor account balances in a particular time range.

To adjust this time range you need to change the UDM_APBUCKETXX_MIN and UDM_APBUCKETXX_MAX global variables. In order to do so:

  1. In the Administration section , click on Global Variables in the left pane.
  2. Click on the pencil icon located to edit one of the UDM_APBUCKET global variable.
  3. Change the value in the Script field to define the period and click on Update.
Note

The UDM_APBUCKET01_MIN and UDM_APBUCKET01_MAX global variables define the beginning and end of the first period.

The UDM_APBUCKET02_MIN and UDM_APBUCKET02_MAX global variables define the beginning and end of the second period.

The UDM_APBUCKET03_MIN and UDM_APBUCKET03_MAX global variables define the beginning and end of the third period.

The UDM_APBUCKET04 global variable define the beginning of the fourth period and include what is beyond that period.

Accounts Payable By Period

While Accounts Payable Historical gives you the overview of a specific date one at a time, this data model gives you the overview at the end of every period simultaneously. This data model is mainly for graphing purposes to see how your Account Payable changed through time.

  1. In the Data Models and Views tab, expand the Universal Data Model and the Accounts Payable folders.
  2. Expand the Accounts Payable By Period data model and open the view you want to retrieve data from.
  3. In the Selection Page, set the filters you want to use and click on Confirm.

Accounts Payable Analysis

This dashboard gives you an overview of the evolution of supplier / vendor accounts over the last 12 months from a specific period.

To get access to this dashboard:

  1. In the Dashboards tab, expand the Universal Data Model and the Accounts Payable folders.
  2. Open the dashboard to display data.