Customer Statement Standard Aging Issues and tweaks needed for 15.3

Issue No: AR-2025
Created 11/10/2015 10:02:03 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 15.3
Description * The Date "To" field needs to be the as of date on the report ** For instance, if the report parameter is set to a To Date of 10/31/2015, the report needs to process as of 10/31/2015 and should not display any November dated invoices. * The page number needs to be removed or adjusted ** For instance, if we process 33 statements, each customer statement should start the numbering over at 1, or we shouldn't show page numbering. Otherwise, a customer will receive a statement that may say Page 29 of 33. This will be confusing for the customer. * Similar to first item, if date range is through 10/31/2015, it should not include an invoice dated 11/02/2015 and should not be included in the aging. * The report is not footing correctly. Credit Available = Total Balance - Credit Limit. We have to make sure this aligns with balance on statement. * Aging is not footing correctly. Total of all aging buckets needs to equal Total Balance Due. ** This may require us to list all Aging Buckets, but we need to ensure it balances. * Sort Order should be in Date Order for a specific customer. * Aging not showing up in any buckets in some instances.   These are all issues on Delta's system. Perhaps testing with a backup of the Delta database might be helpful to ensure we have their issues covered before we install on their system.     See notes and screenshots below:   !pastedImage_d47041_0.png! As of to show Through date !pastedImage_d47041_1.png! This should be page 1 of 1 for the customer, customer will think that they are missing pages for 4 of 33. Which is all statements.   !pastedImage_d47041_2.png! Date Range through 10/31 Should not include an invoice for 11/2.   !pastedImage_d47041_3.png! Report does not foot. Credit Avail <> Total Balance – credit limit   Aging does not foot. 25443.95+25757.4 = 51,201.35 <> 63981.01   !pastedImage_d47041_4.png! Sort Order should be in Date Order for a specific customer   !pastedImage_d47041_5.png! Aging not showing in any bucket   !pastedImage_d47041_6.png!