22087 – [Report- Financial snapshot]- Incorrect Year-to-Date Balances When Creating and Deleting Invoices in Subsequent Months of the Same Year

Bug 22087 - [Report- Financial snapshot]- Incorrect Year-to-Date Balances When Creating and Deleting Invoices in Subsequent Months of the Same Year

Summary: [Report- Financial snapshot]- Incorrect Year-to-Date Balances When Creating a...

Status:	CONFIRMED

Alias:	None

Product:	ML DB 64-bit Win
Classification:	Unclassified
Component:	Reports - Financial Snapshot (show other bugs)
Version:	Version-12
Hardware:	Windows Windows 10 Pro

Importance:	Medium Major
Target Milestone:	---
Assignee:	SVPrasad
QA Contact:

URL:
Keywords:

Depends on:
Blocks:

Reported:	2026-11-02 11:09 IST by Nandhini
Modified:	2026-11-02 11:09 IST (History)
CC List:	2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

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