Service Charge Report: Days Charged values are incorrect if Include Paid Invoice is checked

Issue No: AR-14853
Created 6/15/2022 5:29:19 AM
Type Bug-QC
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 22.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-270167 - F-NA-Walter Matter Initiative for Bugs & Features|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-270167]   Detailed steps: [WAMA-T1376|http://jira.irelyserver.com/secure/Tests.jspa#/testCase/WAMA-T1376]     *Issue:*   Paid invoices are displaying on the service charge invoice as the statement date - the due date rather than the days outstanding. (date paid - date due)       *Preconditions:*   Service Charge:   !pastedImage_d187887_0.png|height=276,width=596!     Invoice 1:   * Invoice Date = Today - 10 days * Post Date = Today - 10 days * Currency: CHF * Amount Due: 500.00 * Terms: Due on Receipt * Due Date: Today - 10 days     Invoice 2:   * Invoice Date = Today - 10 days * Post Date = Today - 10 days * Currency: CHF * Amount Due: 500.00 * Terms: Due on Receipt * Due Date: Today - 10 days     Invoice 3 (Paid)   * Invoice Date = Today - 30 days * Post Date = Today - 30 days * Currency: CHF * Amount Due: 1,500.00 * Terms: Due on Receipt * Due Date: Today - 30 days * Date Paid: Today - 10 Days     Invoice 4 (Paid)   * Invoice Date = Today - 40 days * Post Date = Today - 40 days * Currency: CHF * Amount Due: 2,000.00 * Terms: Due on Receipt * Due Date: Today - 40 days * Date Paid: Today - 5 Days     *Steps to reproduce:*   1. Go to Sales > Activities > Calculate Service Charge   2. Enter the following:   * Customer: Entity No of the customer of the above invoices * As of Date: Today * Service Charge Date: Today * Service Charge Post Date: Today * Include Paid Invoices = Checked   {color:#000000}3. Click Preview button{color}   !pastedImage_d187887_1.png|height=389,width=700!   4. Click Process   {color:#000000}5. Click Yes on the message 'Are you sure you want to calculate service charges?'{color}   {color:#000000}6. Select the just generated Service Charge Invoice{color} {color:#000000}7. Click View Invoice button{color}   8. Click Post   9. Click Print   10. Check Service Charge and Balance Column of invoice 3 and 4   *Expected result:* Service Charge and Balance columns should display:   Invoice 3 Days Charged: 20;   Invoice 4 Days Charged: 35;     Actual result: Service Charge and Balance columns display:   Invoice 3 Days Charged: 30;   Invoice 4 Days Charged: 40; Balance:     !pastedImage_d187887_2.png|height=473,width=700!     FYI [~roudinee.panteria]