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!
|