|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
| 2.6.3. Receivables Aging | ||
|---|---|---|
 | 2.6. Receivables Reports |  |
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.
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:
When displaying aging open Receivables, you are presented with the following options:
Select all or specific Customers whose Receivables information you want to display.
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.
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.
Specify the date preference you want to use:
Select to include open items as of their document date.
Select to include open items as of their document date.
Specify your preference for the printed report. This option impacts the printed report only and will not change the information displayed on the screen.
Select if you want to print a detailed aging report. This option will not change the screen display.
Select if you want to print a summarized aging report. This option will not change the screen display.
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:
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:
Select the Calendar you want to use for the report.
Associated Calendar periods will be displayed.
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.
Display lists time-phased open Receivables, using the specified parameters.
| |  | |
| 2.6.2. Open Receivables |  | 2.6.4. Invoice Register |