Bug 22219

Summary:	[Rwport- Vendor]- Incorrect Balances and Missing Transactions in Ap, AP-aged and AP summary aged
Product:	ML DB 64-bit Win	Reporter:	Nandhini <bnandhini>
Component:	Reports - Vendor Reports	Assignee:	SPramod <SPramod>
Status:	CONFIRMED ---	QA Contact:
Severity:	Major
Priority:	High	CC:	SVPrasad
Version:	Version-12
Target Milestone:	---
Hardware:	Windows
OS:	All

Description Nandhini 2026-11-06 16:04:15 IST

Create multiple purchases and payables, then save
Open the vendor report and verify the options.

#1. Report Type: Accounts payable
In the generated text and CSV files, some transactions are missing, resulting in incorrect total balances
Screenshot:
https://drive.google.com/file/d/102z8fxjc3iB93yhRo_uuYXM0DcXgc32s/view?usp=sharing
Screenshot: https://prnt.sc/zNW4xR10oSEK
Screenshot: https://prnt.sc/zRVI8n_IFiGg

#2. The total balances are still incorrect; once closed and reopened, the screen balances work fine
Screenshot:
https://drive.google.com/file/d/15imYEimz3mRu6pRZpkzb5wpVLG1sv3W5/view?usp=sharing

#3. AP-aged and summary reports: The created transactions are not reflected in the reports
Screenshot1: https://prnt.sc/RQkvjoCoId8J (AP-aged)
https://drive.google.com/file/d/1zRHaUPBt9B6n3alLD6iWwQtW_QIzPr3p/view?usp=sharing
screenshot2: AP- summary aged
https://drive.google.com/file/d/1-Nw55rH7n02ZZDwDSpTQs-1U8FUcfYJ_/view?usp=sharing

DB:
https://drive.google.com/file/d/10QLkm0FAm6PCfLvBwxOiwZ7InbF6kOuc/view?usp=sharing