EDITION: Standard, Enterprise
RESOLUTION
The Statement and Open invoice report both contain the customer aging along with transactional aging. The Late Aging buckets can be created using the transactional aging fields.
To create Late Aging Buckets in the Report Manager:
-
Open Report Manager
-
Delete current aging table at bottom of report (located in the Bottom Margin Tasks)
-
Insert new GroupFooter by right-clicking on GroupFooter1> Insert Band > GroupFooter
-
Insert new table into new GroupFooter2 using the Table icon in the left margin
-
Adjust table (insert add'l columns and rows) to create table to be 6 columns, 2 rows
-
Create and format labels in row 1 of table for the each Late Aging fields (TransAgeCurrent, TransAgeFuture, TransAgeAge1, TransAgeAge2, TransAgeAge3, TransAgeAge4)
-
Add summary for each field on row 2, Select the field properties, set the field with the data binding and using the drop-down to select the TransAge field
-
Select Summary (to set summary properties and formatting)
-
Set Summary Running by Group
-
Select Format string to set the formatting on the field
-
Click OK to save Summary Editor
-
Complete for each of the Late Aging fields in table on row 2
-
Format the table
-
Select GroupFooter2 properties and select 'Print at Bottom' for this section to print at bottom of report
-
Save report and preview to verify