Item Transaction History

Read-only stock ledger inquiry for item movement analysis. Current source: Sales Invoice outbound.

IMS_Demo
Clear
Item Code ITEM00457
Item Name Product 00457
Current Stock 1.771
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.585 Opening Balance
490 Inbound Qty
304 Outbound Qty
1.771 Closing Balance
Transaction Ledger 15 movement(s)
Date Document No Customer Code Customer Name Transaction Type Warehouse In Qty Out Qty Running Balance
01/11/2024 IR202411-0001 - - RECEIPT MAIN 490 0 1.754
07/11/2024 04574 CUS0002 Customer 0002 SALES MAIN 0 6 1.748
09/11/2024 05192 CUS0003 Customer 0003 SALES MAIN 0 16 1.732
12/11/2024 05776 CUS0318 Customer 0318 SALES MAIN 0 66 1.666
13/11/2024 06069 CUS0001 Customer 0001 SALES MAIN 0 10 1.656
14/11/2024 06210 CUS0701 Customer 0701 SALES MAIN 0 100 1.556
14/11/2024 06218 CUS0001 Customer 0001 SALES MAIN 0 16 1.540
15/11/2024 06531 CUS0029 Customer 0029 SALES MAIN 0 10 1.530
18/11/2024 00329 CUS0005 Customer 0005 SALES MAIN 0 13 1.517
22/11/2024 01434 CUS0584 Customer 0584 SALES MAIN 0 10 1.507
25/11/2024 01927 CUS0576 Customer 0576 SALES MAIN 0 6 1.501
27/11/2024 02514 CUS0029 Customer 0029 SALES MAIN 0 16 1.485
29/11/2024 02977 CUS0584 Customer 0584 SALES MAIN 0 3 1.482
30/11/2024 03156 CUS0509 Customer 0509 SALES MAIN 0 16 1.466
30/11/2024 03229 CUS0509 Customer 0509 SALES MAIN 0 16 1.450

Opening Balance — ims.InventoryBeginningSnapshot (PeriodKey 202411, warehouse-specific) • Inbound Qty — SUM(In Qty) from ledger receipts in date range — ims.InventoryTransaction (TransactionType = Receipt) • Outbound Qty — SUM(Out Qty) from sales in date range — ims.SalesDetail via posted Sale ledger rows • Closing Balance — Opening Balance + Total In Qty − Total Out Qty Running balance is calculated independently per warehouse.