Resetting Open A/R (TARO) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | A/R Aging Summary Report |
Printing the A/R Aging Summary Reports (MPAR)
Purpose: Use the Print A/R Aging menu option to print any of the following reports:
• The A/R Aging Summary Report (Condensed) includes the total A/R for each bill-to customer and breaks out the totals into aging buckets
• The A/R Aging Summary Report includes each customer's address, phone numbers, credit limit, and on-order totals
• The Detail Aging Report includes detail information on the open items on each customer's account
You can select the customers to include on the reports based on total A/R, number of days past due, or both criteria.
In this topic:
• A/R Aging Summary Report (Condensed)
Age credits? If the Net A/R Credits in Each Age ’Bucket’ When Aging A/R Items (E14) system control value is selected, credit amounts are included in the appropriate aging buckets and are netted against debit amounts.
For example, the customer has an invoice open item for $200.00 that is 35 days past due, and a credit of $50.00 from that same period.
• if the system control value is selected: the total for the 31-60 aging bucket is $150.00 ($200.00 - $50.00).
• if the system control value is unselected: the $50.00 credit remains in the current aging bucket (that is, it does not age) and the total for the 31-60 aging bucket is $200.00.
To age bill-to customer accounts: You should perform the customer bill-to aging periodic function before running these reports to ensure the information on the reports is current and accurate. See Working with Periodic Processes (WPPR) for more information on working with periodic processing.
The Age by Date Type (C02) system control value defines how open items age. If this field is set to DUE, open items age based on their due dates; if this field is set to INVOICE, open items age based on their invoice dates.
To set up aging buckets: You set up the number of days within each aging bucket in the System Control table. You also use the System Control table to define the labels to appear for each aging bucket on A/R reports. See Setting Up Accounts Receivable Values.
Purpose: Use the A/R Aging Reports screen to print the A/R Aging Summary Report (Condensed), the A/R Aging Summary Report, and/or the Detail Aging Report; see Printing the A/R Aging Summary Reports (MPAR).
How to display this screen: Enter MPAR in the Fast path field at the top of any menu or select Print A/R Aging from a menu.
Field |
Description |
Summary aging report |
This flag indicates whether to print the A/R Aging Summary Report, which presents summary information for each bill-to customer, including complete address information. Valid values are: • Selected (default) = print the Summary Aging report • Unselected = do not print the report |
Summary aging (condensed) |
This flag indicates whether to print the A/R Aging Summary Report (Condensed), which presents summary information for each bill-to customer, including account number, name, and phone number only. Valid values are: • Selected (default) = print the A/R Aging Summary • Unselected = do not print the report |
Detail aging report |
This flag indicates whether to print the Detail Aging Report, which presents complete information for each bill-to account, including open item details. Possible settings are: • Selected = do not print the Detail Aging report • Unselected (default) = print the report |
Enter the minimum total A/R balance for all bill-to accounts to include on the report(s). For example, if you enter 100.00, only bill-to customers whose total A/R balances are $100.00 or greater will be selected for the report(s) you are printing. Negative number: You can enter a negative balance due amount. For example, if you enter 500.00, bill-to customers whose total A/R balances are -$499.99 or more will be selected for the report(s). If you enter a # of days past due: If you complete the # of days past due field and not the Balance due amount field, the system interprets the Balance due amount as a zero; as a result, only bill-to accounts whose total A/R balances are greater than zero will be selected for the report(s). If you leave this field blank and if the # of days past due field is also blank, all bill-to accounts will be selected for the report(s). Numeric, 7 positions with a 2-place decimal; optional. |
|
# of days past due |
Enter the minimum number of days past due a customer bill-to account must be to be included in the report(s). Any account that has a balance (positive or negative) within the aging bucket specified by the number of days will be selected for printing. For example, if you enter 45 in the # of days past due field, and an account has a balance in the 31-60 days past due aging bucket, that account will be selected for printing. How are balances aged? The Customer Bill To Aging periodic function evaluates open items and assigns them to aging buckets based on their due dates. The periods covered by each aging bucket are defined in the System Control table. If the Net A/R credits in each age 'bucket' when aging A/R items system control value is selected, credit open items age in the same way as debit open items, and the totals within each bucket represent the net of debits minus credits. See About Aging for more information. If you enter a Balance due amount: If you complete both the Balance due amount field and the # of days past due field, only bill-to accounts that meet both criteria will be selected for the report(s). See Balance due amount for more information. If you leave this field blank, all bill-to accounts will be eligible to print on the report(s) regardless of their aging. Numeric, 3 positions; optional. |
To generate the reports: Select Accept. See samples of the A/R Aging Summary Report, A/R Aging Summary Report (Condensed), and Detail Aging Report.
Resetting Open A/R (TARO) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | A/R Aging Summary Report |
MPAR OROMS 5.0 2018 OTN