Bug 20327 - [Report-Item]- Inventory report does not carry forward previous month balances when filtering by selected month
Summary: [Report-Item]- Inventory report does not carry forward previous month balance...
Status: RESOLVED FIXED
Alias: None
Product: ML DB 64-bit Win
Classification: Unclassified
Component: Reports - Item Reports (show other bugs)
Version: Version-09
Hardware: Windows Windows 10 Pro
: High Major
Assignee: SVPrasad
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-07-15 12:37 IST by Nandhini
Modified: 2026-08-07 17:03 IST (History)
2 users (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nandhini 2026-07-15 12:37:14 IST
Complete the basic setup (COAs, Items, Vendors).
Create an Item Purchase in January and save.
Create another Item Purchase in March and save.
Open Item Reports → Inventory-selected date.
Select the report month-wise (January, February, March) using the Selected Date filter.
Observe the inventory quantities displayed for each month.

Actual Result
January: Displays the item setup quantity plus the January purchase quantity.
February: Since no transaction exists, only the item setup quantity is displayed.
March: Displays only the item setup quantity plus the March purchase quantity.
The inventory balances from previous months are not carried forward to subsequent months.

Expected Result
Inventory balances should be cumulative across months. If no transaction occurs in an intermediate month, the previous month's balances should be carried forward.

screen rec:
https://drive.google.com/file/d/1tScH8bUrjvvzd4ZdYTupRerbuv0HqQHe/view?usp=sharing
screenshot:
https://drive.google.com/file/d/1C92C650v2ze2pPtr21st3lsi-IQAkVPx/view?usp=sharing
Comment 1 psaikumar 2026-08-07 17:03:45 IST
Fixed and Available in next build.