Issue/Symptom/Question

In order to focus on the oldest AR invoices on an AR Aging report, it would be nice to be able to exclude the Current column aged invoices from the AR Aging Reports.

Environment

• The invoices to include in the Current column are determined by option 46 which defines what the Current aged days are made up of - the default is to include invoices older than 1-30 days from the End Date of the report

• System option 99 determines whether to age invoices based on Invoice Date or Distribution Date - the default is based on Invoice Date
  • Based on the option setting, this determines which column to include an invoice in when comparing the Invoice or Distribution date to the End Date of the report
• See the PENTA legacy AR Aging reports location below

Resolution/Fix/Answer

Steps to run the report:

1. Determine how PENTA is aging AR invoices today based on system option 99 - the default is to age by Invoice Date
   1. This provides you with the background knowledge of how PENTA determines which invoices to include in which aging columns when running the AR Aging reports
2. Determine the report End Date you want to enter when running this report
   1. If you enter 10/31/2017, PENTA will include invoices with an Invoice or Distribution date less than or equal to this date based on option 99
3. To exclude the Current column invoices on the report, determine what the most recent date you want invoices to be included on the report is
   1. If you only want to display invoices aged greater than 30 days old from 10/31/2017 then your most recent date would be 09/30/2017
4. Click on the Additional Criteria button and in the AGING_DATE field, enter in the Low Value field a date back in time like 2000/01/01 in the YYYY/MM/DD format to include all old invoices
5. In the High Value field enter the calculated date in step 3a above - 2017/09/30 - see below
   
6. Close the window and click Submit to run the report
7. PENTA should not display any invoices in the Current column if defined as 1-30 days old