Bug 19395

Summary: [Report- Item]- Report filters incorrectly exclude zero-quantity items when including non-inventory items, and inventory adjustments are not carried forward correctly between months, causing inaccurate data.
Product: ML_DB 64-bit Mac Reporter: Nandhini <bnandhini>
Component: Item ReportsAssignee: Nandhini <bnandhini>
Status: CLOSED ---    
Severity: Medium CC: dharisha, ksagarika
Priority: Medium    
Version: 2026-14.0.22 + 26.0.1 Ver 03   
Hardware: MAC   
OS: All   

Description Nandhini 2026-04-30 12:22:05 IST 
Issue#1: Incorrect Report Results When Including Non-Inventory Items
1. Create a basic setup by assigning coas, vendors, and items across all categories (like zero qty and non-inventory items), then save.
2. Open the item report screen by selecting inventory-related options along with the report-type options.
Report type: Omit zero items and include non-inventory options.
3. When the include non-inventory option is selected, zero-qty items are also missing even without the checkbox selected. The report-type details are fetched incorrectly, with intermittent issues occurring.
screenshot:
https://drive.google.com/file/d/17imMSpzt4f6ZZ7T79uP0OUTdeHE0WnDE/view?usp=sharing

Issue#2:Adjusted Inventory Not Reflected Correctly Month-wise.

Adjust some amount in the 1st month, then again adjust some amount in the 3rd month - here for the 2nd month, previously saved amount for that item is not displaying instead of showing 0. Monthly values should reflect cumulative
screen rec:
https://drive.google.com/file/d/1JdZKhNkQ8pUEWaBSvB_-Y2pZgqZNWMCo/view?usp=sharing
Comment 1 Bhavani 2026-05-03 00:02:49 IST 
Fixed, Available in next build