Bug 22091

Summary: [Customer Reports][AR Reports, TD , TS & Statements] - After Creating Refund Check for Credit Memo Invoices & Sales few scenarios are failed.
Product: ML DB 64-bit Win Reporter: G.Shivasai <gshiva>
Component: Reports - Customer ReportsAssignee: SVPrasad <SVPrasad>
Status: CONFIRMED --- QA Contact:
Severity: Major    
Priority: High CC: btadepalli, skatragadda
Version: Version-12   
Target Milestone: ---   
Hardware: Windows   
OS: Windows - 11   

Description G.Shivasai 2026-11-02 12:06:49 IST
[Customer Reports][AR Reports, TD , TS & Statements] - After Creating Refund Check for Credit Memo Invoices & Sales few scenarios are failed.

#1.AR Reports:
Payment of Refund Check for Credit Memo Invoices & Sales. Those Transactions are not showing in AR Reports as unpaid. When Placing Cutoff Date Before Payment Date.
Screenshot:
https://prnt.sc/gfqpsCKduPXo

#2.TD & TS Reports:
After Creating Refund Check for Credit Memo Invoices & Sales. 

In TD Report the refund amount is incorrectly showing in the sales column instead of showing in receipt column with negative amount.

In TS Report the refund amount shows in Receipt column but not displaying with negative amount.

Screenshot:
https://prnt.sc/cP7TqbIVn8Kv


#3.Customer Statements-Open Invoices Report:
After Refund Payment for Credit Memo Invoices and Sales. This Report shows the paid  transaction data. This report should not show the full paid transaction data.
https://prnt.sc/u06U4liY-XGw

#4.Customer Statements-Activity Based Report:
After Refund Payment for Credit Memo Invoices & Sales - This Report not shows the charged transactions data. It shows only the paid data. Placing Cutoff date after payment and on payment dates.
https://prnt.sc/ULLqQd1V9xK6


STEPS:
=> Create Credit Memo Invoices and Sales.
=> Create Refund Check for both.
=> Generate the AR Reports, TD, TS Reports & Statements.
=> Observe the identified issues in above reported.