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
: 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)
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