Bug 21609

Summary:	[Customer Reports][AR, AR-AGed, AR-Summary AGed] – A Sales Journal invoice that was paid with a discount reappears as an open invoice after generating the Transaction Detail Report.
Product:	ML DB 64-bit Mac 2027	Reporter:	G.Shivasai <gshiva>
Component:	Customer Reports	Assignee:	pmyadav <pmyadav>
Status:	CONFIRMED ---	QA Contact:
Severity:	Major
Priority:	High	CC:	btadepalli
Version:	27.0.0 Ver-03
Target Milestone:	---
Hardware:	MAC
OS:	macOS Sequoia

Description G.Shivasai 2026-09-21 11:30:49 IST

[Customer Reports][AR, AR-AGed, AR-Summary AGed] – A Sales Journal invoice that was paid with a discount reappears as an open invoice after generating the Transaction Detail Report.

Screenshot:
https://prnt.sc/JBhLSATFyWl3

For further steps refer the below link screen record:
https://drive.google.com/file/d/1UgMwd3d47mM11iaj60TKn89iKCQbVD5t/view?usp=sharing

DB:
https://drive.google.com/file/d/1FzuUW780IIOZODFAiA6cclt56JZvQlwD/view?usp=sharing

NOTE:This issue exists in 14.0.25 & 26.0.4 Version-04 Applications too.

Comment 1 G.Shivasai 2026-09-22 12:15:44 IST

#2.Deleted Invoices are reappeared again in AR, AR-Aged, AR-Summary Aged Reports after generating the Transaction Detail Report.

Screen Record:
https://drive.google.com/file/d/1acux7l63ggNG8z3-gukdTIwDgmyFEw43/view?usp=sharing