Bug 22087

Summary:	[Report- Financial snapshot]- Incorrect Year-to-Date Balances When Creating and Deleting Invoices in Subsequent Months of the Same Year
Product:	ML DB 64-bit Win	Reporter:	Nandhini <bnandhini>
Component:	Reports - Financial Snapshot	Assignee:	SVPrasad <SVPrasad>
Status:	CONFIRMED ---	QA Contact:
Severity:	Major
Priority:	Medium	CC:	btadepalli, skatragadda
Version:	Version-12
Target Milestone:	---
Hardware:	Windows
OS:	Windows 10 Pro

Description Nandhini 2026-11-02 11:09:19 IST

Create and save transactions in October.
Create and save an invoice in November of the same year.
Open the Financial Snapshot report.
Verify the Year-to-Date balances.
Delete the created November invoice.
Reopen the Financial Snapshot report and verify the Year-to-Date balances.

Issue #1: The Year-to-Date details are updated based on the invoice balances, but the new invoice amounts are included along with the previous balances instead of being reflected correctly.

Issue #2: After deleting the created invoice, the Year-to-Date balances become zero, and the balances from the previously created October transactions are also removed.

Screen recording:
https://drive.google.com/file/d/1SgloEP_uKcJwroeelKNoMSD6kMwjPeNI/view?usp=sharing
DB:
https://drive.google.com/file/d/1YkT72qtPdaiMeT8FNZsuAomBPAMy42Tx/view?usp=sharing
Flatfile:
https://drive.google.com/file/d/1-5f_GWOyhVpTUnPoDOI-Fo92Y6nrd68G/view?usp=sharing