Summary of Invoices is used in unique circumstances to report only the open invoices, their balance, and payment history. The Summary of Invoices does not print descriptions, line item text, or reference text. They will print the invoice number, invoice date, payment information, and invoice balance.
Major to minor Sort Fields: Enter the major to minor sort field, separated by commas.
AR Selection Criteria:
-
01 – Command Selection
-
02 – Account Information
-
03 – Responsible ID Information
-
04 – Category (By Term) Information
-
05 – Transaction Detail
-
06 – Special Information
-
07 – AR Reference Date
-
10 – IRIS Information
-
SF – Select File
Would you like separate criteria for the analysis/printing process? Specify separate criteria, if needed.
Would you like address labels printed?
Address Hierarchy: Enter a two-character address code as defined in the Person/Entity (PE) subsystem.
Age Bucket Selection Criteria
When using Age Bucket criteria in ARRESI, the values you enter filter on dollar amounts within each aging bracket — not on the number of days an invoice has been outstanding.
ARRESI computes aging based on the age ranges you configure (e.g., 30,60,90,120) and exposes the resulting amounts as selection fields:
|
Selection Field |
Age Bracket |
Meaning |
|---|---|---|
|
C4 Age Bucket #1 |
0–30 days |
Dollar amount in the 0–30 day bracket |
|
C4 Age Bucket #2 |
31–60 days |
Dollar amount in the 31–60 day bracket |
|
C4 Age Bucket #3 |
61–90 days |
Dollar amount in the 61–90 day bracket |
|
C4 Age Bucket #4 |
91–120 days |
Dollar amount in the 91–120 day bracket |
|
C4 Age Bucket #5 |
121+ days |
Dollar amount in the 121+ day bracket |
Example:
To find accounts where the receivable amount in the 31–60 day bracket is at least $500, set the criteria:
Age Bucket #2 >= 500
This returns accounts with $500 or more in the 31–60 day aging bracket. It does not return invoices that are simply 31–60 days old.
Common Misconception:
Setting Age Bucket #1 >= 31 AND Age Bucket #1 <= 60 filters for accounts where the dollar amount in the 0–30 day bracket is between $31.00 and $60.00 — it does not select invoices aged 31–60 days.
Suggestion: If your goal is to view aging distribution broken out by day ranges, use the Aged Receivables Report (ARRESRAG) instead. ARRESRAG displays balances organized by aging period and is better suited for reviewing how receivables are distributed across time brackets.