| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-215856 - Customer Aging totals not matching report totals|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-215856]
Goal: The customer is working on collection calls. They want a list of customer from Customer Aging Report that reflects ONLY customers who have data in 61-90 and/or 91+ buckets.
How do we set the filter to reflect the same same total as Customer Aging report on 61-90 + 90+.
They're current work around is to create two separate reports and they have to merge them together so if the customer exists in both reports, they know to sum up both reports
!pastedImage_d103908_0.png!
!pastedImage_d103908_1.png! Expected Results to show all records in the 61-90 buckets and/or over 90 buckets . Each column should total when printing customer aging report without filters.
The report total should reflect customers with total of report
61-90 $27,209.77
Over 90 $21,262.48
!pastedImage_d103908_2.png!
Steps to reproduce:
1. Go to Sales \| Reports \| Customer Aging
2. Click Generate. Note the total values in 61-90 Days and Over 90 Days columns.
3. Filter the report:
Print Customer with Balances equal to 61-90 Days (Operator = OR)
Print Customer with Balances equal to Over 90 Days (Operator = OR)
4. Click Generate
Expected result: Totals in filtered columns (61-90 Days, Over 90 Days) in both unfiltered and filtered reports should be equal
Actual result: Totals in filtered columns (61-90 Days, Over 90 Days) in both unfiltered and filtered reports are not equal
|