Collapse AllExpand All

1.7.3.  Payables Aging

The Payables Aging report gives you the ability to view open Payables in a bucketed, time-phased perspective. And this perspective is portable, allowing you to view point-in-time snapshots of open balances.

An open Item is recognized by the Payables Aging report "as of" the item's document or distribution date. In the case of Vouchers, the distribution date is the date the Voucher is distributed to the General Ledger (G/L). (Payables Debit/Credit Memos are distributed to the G/L on their document date.) For example, if you post a Voucher on January 1, but the G/L distribution date is February 15, then the "as of" distribution date for that open item will be February 15 while the doc date will be January 1. This means, if you run the Payables Aging report with an "as of" distribution date in January, the open item distributed to the G/L on February 15 will not appear in the report. In fact, it will not appear in the report until an "as of" date of February 15 or later is specified.

Tip

You can view the document date for an open item by right-clicking on a line in the Payables Aging display. You can also find open item details on other screens—for example, Vendor History, Open Items by Vendor, etc.

The grouping of open items into time-phased buckets is driven by a document's due date. In other words, if a due date falls within 0-30 days of the "as of" date specified when the report is run, then the open item will appear in the first bucket. If the due date falls 31-60 days past the specified "as of" date, then the open item will appear in the second bucket. And so on.

To view open Payables from an aging perspective, select the "Aging" option. The following screen will appear:

Payables Aging

When displaying aging A/P open items, you are presented with the following options:

All Vendors

Select to display A/P open items for all Vendors.

Selected Vendor

Select to display A/P open items for a selected Vendor.

Selected Vendor Type

Specify Vendor Type whose A/P open items you want to display.

Vendor Type Pattern

Enter a Vendor Type pattern to select a range of Vendor Types. Refine your search using Regular Expressions.

As of Date

Specify the date you want the A/P open items to be relative to. The report will include any A/P items which were open—that is, not yet paid—as of the specified date. This feature provides "point-in-time" open balance functionality. But again, keep in mind that the document date for an A/P open item (e.g., Voucher distribution date) must be on or before the specified "as of" date for the item to be recognized by the report.

Use Custom Calendar

Select if you want to display A/P open items using a custom Calendar of your choosing. If selected, the screen will present a series of different options, including the option to select a Calendar and associated periods.

Use

Specify your date preference:

Document Date

Select to include open items as of their document date.

Distribution Date

Select to include open items as of their document date.

Report

Specify your report preference:

Detailed Report

Select if you want to see a detailed aging report. The printed report will match the screen display.

Summary Report

Select if you want to see a summarized aging report. The printed report will match the screen display.

Payables Open Items

Display lists aging A/P open items, using the specified parameters.

To view A/P open items using a custom Calendar, select the "Use Custom Calendar" option above. The following screen will appear:

Custom Payables Aging Calendar

When displaying A/P open items using a custom Calendar, you are presented with the following options:

Calendar

Select the Calendar you want to use for the report. Associated Calendar periods will be displayed.

Name/Selected Periods

Select as many periods as you want to display. Selected periods correspond to Calendar specified in the "Calendar" field. Select individual periods or groups of periods together. To select an individual period, highlight the period using your mouse button. The period is now selected. To select a sequence of periods, highlight the first in the sequence using your mouse button. Then, holding down the SHIFT key on your keyboard, highlight the last period in the sequence. The entire sequence is now selected. To select periods that are out of sequence (e.g., January, April, July, October), highlight the first period in the group. Then, holding down the CTRL key on your keyboard, highlight the next period you want to select. Continue highlighting periods with the CTRL key depressed until all desired periods are selected. The entire group is now selected.

A/P Open Items

Display lists time-phased A/P open items, using the specified parameters.