Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02157
Item Name Product 02157
Current Stock 2.014
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.868 Opening Balance
444 Inbound Qty
298 Outbound Qty
2.014 Closing Balance
Transaction Ledger 34 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 444 0 1.935
01/11/2024 03328 CUS0208 Customer 0208 SALES MAIN 0 10 1.925
01/11/2024 03352 CUS0786 Customer 0786 SALES MAIN 0 16 1.909
02/11/2024 03595 CUS0686 Customer 0686 SALES MAIN 0 6 1.903
04/11/2024 03693 CUS0017 Customer 0017 SALES MAIN 0 26 1.877
04/11/2024 03788 CUS0006 Customer 0006 SALES MAIN 0 10 1.867
04/11/2024 03886 CUS0029 Customer 0029 SALES MAIN 0 16 1.851
06/11/2024 04385 CUS0017 Customer 0017 SALES MAIN 0 16 1.835
08/11/2024 04878 CUS0021 Customer 0021 SALES MAIN 0 13 1.822
08/11/2024 05003 CUS0006 Customer 0006 SALES MAIN 0 6 1.816
11/11/2024 05378 CUS0795 Customer 0795 SALES MAIN 0 3 1.813
11/11/2024 05540 CUS0822 Customer 0822 SALES MAIN 0 10 1.803
11/11/2024 05559 CUS0795 Customer 0795 SALES MAIN 0 6 1.797
12/11/2024 05436 CUS0821 Customer 0821 SALES MAIN 0 5 1.792
12/11/2024 05596 CUS0006 Customer 0006 SALES MAIN 0 3 1.789
13/11/2024 05941 CUS0822 Customer 0822 SALES MAIN 0 3 1.786
14/11/2024 06316 CUS0001 Customer 0001 SALES MAIN 0 6 1.780
15/11/2024 06468 CUS0022 Customer 0022 SALES MAIN 0 16 1.764
15/11/2024 06471 CUS0029 Customer 0029 SALES MAIN 0 6 1.758
15/11/2024 06715 CUS0017 Customer 0017 SALES MAIN 0 16 1.742
21/11/2024 01050 CUS0022 Customer 0022 SALES MAIN 0 5 1.737
21/11/2024 01139 CUS0029 Customer 0029 SALES MAIN 0 16 1.721
21/11/2024 01150 CUS0584 Customer 0584 SALES MAIN 0 3 1.718
21/11/2024 01230 CUS0573 Customer 0573 SALES MAIN 0 5 1.713
25/11/2024 01879 CUS0007 Customer 0007 SALES MAIN 0 3 1.710
25/11/2024 01944 CUS0795 Customer 0795 SALES MAIN 0 3 1.707
25/11/2024 01957 CUS0205 Customer 0205 SALES MAIN 0 5 1.702
27/11/2024 02416 CUS0001 Customer 0001 SALES MAIN 0 13 1.689
27/11/2024 02427 CUS0584 Customer 0584 SALES MAIN 0 3 1.686
28/11/2024 02724 CUS0611 Customer 0611 SALES MAIN 0 4 1.682
29/11/2024 02896 CUS0017 Customer 0017 SALES MAIN 0 13 1.669
29/11/2024 02983 CUS0022 Customer 0022 SALES MAIN 0 6 1.663
30/11/2024 03210 CUS0027 Customer 0027 SALES MAIN 0 10 1.653
30/11/2024 03226 CUS0822 Customer 0822 SALES MAIN 0 16 1.637

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.