CF Invoice > Balance Forward issues

Issue No: AR-6073
Created 11/30/2017 1:12:44 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 17.3
Description _Scenario 1:_   *Steps to replicate:*   * Restore the customer's database. * Go to Card Fueling > Invoice ** Enter the following parameters: ** Invoice Date: 10/31/2017 ** Customer: Vil*** of swan**** ** Include Remittance Page: Checked ** Balance Forward Date: 9/30/2017 ** Reprint Invoice: Checked ** Billing Cycle: Checked * Click on Run button. * Balance forward report will be generated.   *Issue:* Wrong info on the generated report.   *Acceptance:*   # On Uninvoiced Transactions that have a Post Date <= Balance Forward Date and will be included in the current CF Invoice run   ## Do not include Uninvoiced Transaction (aka Future) the the balance forward amount.   ## Do not show in Future Amount, but include in Current Amount ### Current Amount should include any existing current aging + new CFSI # Amount # Credit Memos are not calculated properly when backing out balances on Aging recap. # Future Amount should only include Uninvoiced Transaction <= to CFSI Invoice Date but that are not included in the current CF Invoice critieria ## For example: ### CF Invoice Criteria #### Invoice Date = 10/15 #### Through Tran Date of 10/15 ### Example CF Trans #### Trans Date = 10/16, #### CF Tran Post Date = 10/15 ### Since Tran Date 10/16 > Critiera Tran Date of 10/15 this would be excluded from CFSI ### Since CF Tran Post Date <= CF Invoice Date it would still be considered Future # Future Amount should be omitted from Balance Due that prints on Statement, as this is not due yet.     _Scenario 2:_   *Steps to replicate:*   * Go to Card Fueling > Invoice * ** Enter the following parameters: ** Invoice Date: 11/30/2017 ** Customer: Prai*** Far*** ** Include Remittance Page: Checked ** Balance Forward Date: 10/31/2017 ** Billing Cycle: Checked * Click on Run button. * Balance forward report will be generated.   *Issue:*   # Future is still showing a negative amount, but when netted against current it is still the correct balance due. # Credit Memos are not being added properly for future/current in summary.