AP02 — Aged Trial Balance by Transaction Date

Operational Reports > Accounts Payable

Who would use this report?

Finance and accounts receivable staff

What is in this report?

ap02Accounts payable values in historical ageing buckets by invoice date or due date, including retrospective.

Recalculates ageing from transaction levelIn a hierarchy, a level indicates a group of common or related members. For example, in a Time level, members may include Year, Month, Day or Fiscal Year, Calendar Year, etc. dates.

This reportA set of data deliberately laid out to communicate business information. Depending on the context, 'report' may refer to report specification or report output. Report (more precisely, report specification) is the generic term for the objects created or edited in Cognos Analytics. Pronto Xi Business Intelligence offers a suite of standard reports. includes both summary and detail options and is generated by aggregating the transactional data. If you have purged pxiPronto Xi transactions through the history settings, this report will not return complete values and it will not reconcile with the General Ledger, either current or retrospective.

This report only includes supplier transactions that are associated with a financial year and period.

How do I use it?

Select Summary or Detail to viewA set of data connected to a cube, deliberately laid out to communicate business information. the summary or detail version of the report.

Sort options:

• Display by — sortArrange elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. and groupIn security, a list of users or other groups that can be used to assign access permissions and capabilities. Groups can be referenced from other authentication sources or can be local to Pronto Xi Business Intelligence. Local groups are managed from BI Administration. The list of groups that an authentication user is a member of is part of the user's passport for an Pronto Xi Business Intelligence session. In reporting, grouping is the action of organising common values of query item together and only displaying the value once. Headers and footers often appear after each instance of a common value in a grouped column by supplier, supplier type, or supplier group

• Rank By — sort, in each group, in alphabetically ascending or descending order, or by the total amount ascending or descending

FiltersSelectively remove data from view. include:

• Period selection — select the period as at which the report is aged

  The report is filtered by transaction date on or before the end of the selected period. You can select any period from the beginning of the time dimensionA broad grouping of data about a major aspect of a business, such as products. A dimension provides the context of a fact and is used in queries to group related facts together. In Analytics Dashboards, a dimension provides a perspective of a DMR Schema. Dimensions tend to be discrete and are often hierarchical. A dimension can contain one or more hierarchies. For example, Product Name, Style, Colour, Size. to 11 periods in the future (based on the current AP Period).

• Age Report by — select invoice date or pay by date as the ageing basis

• Balance selection — filter the values in the Amount column

• Show Invoice Subtotal — specify whether to display the invoice subtotal

• Show Foreign/Mirrored Currency Values — display or hide foreign or mirrored currency values

• Select Mirrored Currency — select the mirrored currency to display

• Show Transacted/Supplier Currency Values — specify whether to show or hide the transacted (supplier) currency values

• Supplier — search by Supplier Code, Supplier Keyword, or enter the supplier code or a range of supplier codes

• Ageing Buckets to display — select one or more ageing buckets to display

Other filters include Supplier Type and Supplier Group.

What can I do in the report?

Select Summary or Detail to view the summary or detail version of the report.

You can sort by Display by and Rank By.

You can filter by Period Selection, Age Report by, and Balance Selection.

You can drill downThe act of navigating from one level of data to a more detailed level. The levels are set by the structure of the data. See also drill up. from this report to the AP02 - Aged Trial Balance report for more detailed analysisA process where a user interacts with data to gain insight and understanding..