Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03160
Item Name Product 03160
Current Stock 2.018
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.665 Opening Balance
605 Inbound Qty
252 Outbound Qty
2.018 Closing Balance
Transaction Ledger 19 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 605 0 1.870
01/11/2024 03409 CUS0022 Customer 0022 SALES MAIN 0 16 1.854
04/11/2024 03888 CUS0576 Customer 0576 SALES MAIN 0 6 1.848
04/11/2024 03912 CUS0006 Customer 0006 SALES MAIN 0 10 1.838
07/11/2024 04699 CUS0208 Customer 0208 SALES MAIN 0 6 1.832
08/11/2024 04869 CUS0022 Customer 0022 SALES MAIN 0 33 1.799
08/11/2024 04924 CUS0208 Customer 0208 SALES MAIN 0 50 1.749
08/11/2024 05161 CUS0029 Customer 0029 SALES MAIN 0 16 1.733
09/11/2024 05175 CUS0795 Customer 0795 SALES MAIN 0 10 1.723
15/11/2024 06457 CUS0205 Customer 0205 SALES MAIN 0 16 1.707
16/11/2024 00024 CUS0208 Customer 0208 SALES MAIN 0 10 1.697
16/11/2024 00035 CUS0205 Customer 0205 SALES MAIN 0 6 1.691
18/11/2024 00227 CUS0584 Customer 0584 SALES MAIN 0 6 1.685
22/11/2024 01438 CUS0611 Customer 0611 SALES MAIN 0 2 1.683
28/11/2024 02589 CUS0795 Customer 0795 SALES MAIN 0 3 1.680
28/11/2024 02599 CUS0003 Customer 0003 SALES MAIN 0 16 1.664
28/11/2024 02739 CUS0029 Customer 0029 SALES MAIN 0 10 1.654
30/11/2024 03208 CUS0208 Customer 0208 SALES MAIN 0 3 1.651
30/11/2024 03209 CUS0054 Customer 0054 SALES MAIN 0 33 1.618

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.