Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00688
Item Name Product 00688
Current Stock 1.708
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.036 Opening Balance
798 Inbound Qty
126 Outbound Qty
1.708 Closing Balance
Transaction Ledger 21 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 798 0 1.629
01/11/2024 03501 CUS0006 Customer 0006 SALES MAIN 0 3 1.626
06/11/2024 04307 CUS0006 Customer 0006 SALES MAIN 0 3 1.623
06/11/2024 04570 CUS0001 Customer 0001 SALES MAIN 0 1 1.622
08/11/2024 04879 CUS0821 Customer 0821 SALES MAIN 0 10 1.612
11/11/2024 05363 CUS0006 Customer 0006 SALES MAIN 0 10 1.602
11/11/2024 05537 CUS0208 Customer 0208 SALES MAIN 0 3 1.599
12/11/2024 05909 CUS0045 Customer 0045 SALES MAIN 0 6 1.593
14/11/2024 06230 CUS0822 Customer 0822 SALES MAIN 0 1 1.592
15/11/2024 06473 CUS0795 Customer 0795 SALES MAIN 0 3 1.589
15/11/2024 06628 CUS0208 Customer 0208 SALES MAIN 0 13 1.576
18/11/2024 00350 CUS0048 Customer 0048 SALES MAIN 0 1 1.575
21/11/2024 01079 CUS0010 Customer 0010 SALES MAIN 0 1 1.574
23/11/2024 01572 CUS0510 Customer 0510 SALES MAIN 0 3 1.571
23/11/2024 01583 CUS0027 Customer 0027 SALES MAIN 0 16 1.555
25/11/2024 01852 CUS0006 Customer 0006 SALES MAIN 0 13 1.542
25/11/2024 01866 CUS0686 Customer 0686 SALES MAIN 0 16 1.526
25/11/2024 01959 CUS0010 Customer 0010 SALES MAIN 0 1 1.525
27/11/2024 02431 CUS0009 Customer 0009 SALES MAIN 0 3 1.522
29/11/2024 02990 CUS0822 Customer 0822 SALES MAIN 0 6 1.516
30/11/2024 03209 CUS0054 Customer 0054 SALES MAIN 0 13 1.503

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.