Collapse AllExpand All

2.6.3.  Receivables Aging

The Receivables Aging report gives you the ability to view open Receivables in a bucketed, time-phased perspective. An open Item is recognized by the Receivables Aging report "as of" the item's document or distribution date, depending on your preference. In the case of Invoices, the document date is the Invoice date. The distribution date is the date the Invoice shows up in the General Ledger (G/L). For example, if you post an Invoice on January 1, but the Invoice date is February 15, then the "as of" document date will be February 15. This means, if you run the Receivables Aging report with an "as of" document date in January, the open item with an Invoice date of February 15 will not appear in the report. In fact, it will not appear in the report until an "as of" document date of February 15 or later is specified. Conversely, using the distribution date option, the Invoice would appear "as of" January 1.

Tip

You can view the document date for an open item by right-clicking on a line in the Receivables Aging display. You can also find open item details on other screens—for example, Receivables Workbench, Customer History, Open Items by Customer, 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. But again, keep in mind that the document date for an open Receivable (e.g., Invoice date) must be on or before the specified "as of" date for the item to be recognized by the report. To view open Receivables from an aging perspective, select the "Receivables Aging" option. The following screen will appear:

Receivables Aging

When displaying aging open Receivables, you are presented with the following options:

Customer

Select all or specific Customers whose Receivables information you want to display.

As of

Specify the date you want the open Receivables to be relative to. The report will include any Receivable 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 open Receivable (e.g., Invoice 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 open Receivables 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.

Receivables Open Items

Display lists aging open Receivables, using the specified parameters.

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

Custom Receivables Aging Calendar

Note

If a Customer's open Receivables balance exceeds their Credit Limit, the Customer will automatically be placed on Credit Warning. In addition, any new or open Sales Orders for the Customer will also be placed on Credit Hold.

When displaying open Receivables 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.

Open Receivables

Display lists time-phased open Receivables, using the specified parameters.