Bug 21599

Summary:	[Customer Reports][Customer Statements] - Paid Invoices are not showing in the activity based 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-18 16:09:18 IST

[Customer Reports][Customer Statements] - Paid Invoices are not showing in the activity based report.

STEPS:
=> Create a Invoice and make payment.
=> Open Customer Reports => Customer Statements-Activity Based => Set the cutoff date within the payment of 30 days and generate the report.
=> Observe, the report does not show the transactions which are created and paid.

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

Screenshot:
https://prnt.sc/AMTRjNiGup8D

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