Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00555
Item Name Product 00555
Current Stock 2.090
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.341 Opening Balance
1.000 Inbound Qty
251 Outbound Qty
2.090 Closing Balance
Transaction Ledger 61 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 1.000 0 1.877
01/11/2024 03343 CUS0006 Customer 0006 SALES MAIN 0 6 1.871
01/11/2024 03348 CUS0002 Customer 0002 SALES MAIN 0 1 1.870
01/11/2024 03418 CUS0584 Customer 0584 SALES MAIN 0 3 1.867
04/11/2024 03793 CUS0822 Customer 0822 SALES MAIN 0 6 1.861
04/11/2024 03911 CUS0611 Customer 0611 SALES MAIN 0 2 1.859
04/11/2024 03919 CUS0208 Customer 0208 SALES MAIN 0 3 1.856
05/11/2024 03992 CUS0620 Customer 0620 SALES MAIN 0 33 1.823
06/11/2024 04368 CUS0027 Customer 0027 SALES MAIN 0 6 1.817
06/11/2024 04374 CUS0024 Customer 0024 SALES MAIN 0 3 1.814
06/11/2024 04507 CUS0611 Customer 0611 SALES MAIN 0 1 1.813
07/11/2024 04582 CUS0584 Customer 0584 SALES MAIN 0 3 1.810
07/11/2024 04746 CUS0006 Customer 0006 SALES MAIN 0 6 1.804
07/11/2024 04747 CUS0001 Customer 0001 SALES MAIN 0 6 1.798
08/11/2024 04956 CUS0029 Customer 0029 SALES MAIN 0 3 1.795
09/11/2024 05258 CUS0003 Customer 0003 SALES MAIN 0 1 1.794
09/11/2024 05264 CUS0611 Customer 0611 SALES MAIN 0 2 1.792
09/11/2024 05271 CUS0017 Customer 0017 SALES MAIN 0 3 1.789
09/11/2024 05276 CUS0001 Customer 0001 SALES MAIN 0 1 1.788
11/11/2024 05328 CUS0029 Customer 0029 SALES MAIN 0 16 1.772
11/11/2024 05571 CUS0611 Customer 0611 SALES MAIN 0 3 1.769
11/11/2024 05584 CUS0208 Customer 0208 SALES MAIN 0 3 1.766
12/11/2024 05665 CUS0584 Customer 0584 SALES MAIN 0 2 1.764
12/11/2024 05889 CUS0798 Customer 0798 SALES MAIN 0 6 1.758
12/11/2024 05898 CUS0005 Customer 0005 SALES MAIN 0 6 1.752
14/11/2024 06216 CUS0584 Customer 0584 SALES MAIN 0 1 1.751
14/11/2024 06369 CUS0009 Customer 0009 SALES MAIN 0 3 1.748
15/11/2024 06535 CUS0584 Customer 0584 SALES MAIN 0 1 1.747
15/11/2024 06543 CUS0004 Customer 0004 SALES MAIN 0 3 1.744
15/11/2024 06552 CUS0001 Customer 0001 SALES MAIN 0 3 1.741
15/11/2024 06616 CUS0611 Customer 0611 SALES MAIN 0 2 1.739
16/11/2024 00012 CUS0318 Customer 0318 SALES MAIN 0 16 1.723
16/11/2024 00015 CUS0584 Customer 0584 SALES MAIN 0 6 1.717
16/11/2024 00036 CUS0212 Customer 0212 SALES MAIN 0 1 1.716
16/11/2024 00037 CUS0002 Customer 0002 SALES MAIN 0 3 1.713
16/11/2024 00039 CUS0004 Customer 0004 SALES MAIN 0 1 1.712
18/11/2024 00225 CUS0010 Customer 0010 SALES MAIN 0 1 1.711
18/11/2024 00228 CUS0630 Customer 0630 SALES MAIN 0 2 1.709
18/11/2024 00335 CUS0822 Customer 0822 SALES MAIN 0 3 1.706
18/11/2024 00412 CUS0584 Customer 0584 SALES MAIN 0 1 1.705
18/11/2024 00413 CUS0003 Customer 0003 SALES MAIN 0 6 1.699
18/11/2024 00434 CUS0002 Customer 0002 SALES MAIN 0 1 1.698
18/11/2024 00526 CUS0584 Customer 0584 SALES MAIN 0 3 1.695
21/11/2024 01047 CUS0029 Customer 0029 SALES MAIN 0 3 1.692
21/11/2024 01158 CUS0611 Customer 0611 SALES MAIN 0 2 1.690
23/11/2024 01715 CUS0611 Customer 0611 SALES MAIN 0 2 1.688
25/11/2024 01873 CUS0009 Customer 0009 SALES MAIN 0 1 1.687
25/11/2024 01937 CUS0009 Customer 0009 SALES MAIN 0 6 1.681
25/11/2024 01943 CUS0578 Customer 0578 SALES MAIN 0 3 1.678
25/11/2024 01959 CUS0010 Customer 0010 SALES MAIN 0 1 1.677
25/11/2024 02004 CUS0576 Customer 0576 SALES MAIN 0 6 1.671
25/11/2024 02011 CUS0686 Customer 0686 SALES MAIN 0 3 1.668
25/11/2024 02013 CUS0029 Customer 0029 SALES MAIN 0 6 1.662
27/11/2024 02502 CUS0029 Customer 0029 SALES MAIN 0 3 1.659
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 3 1.656
28/11/2024 02726 CUS0003 Customer 0003 SALES MAIN 0 6 1.650
28/11/2024 02803 CUS0611 Customer 0611 SALES MAIN 0 2 1.648
28/11/2024 02820 CUS0009 Customer 0009 SALES MAIN 0 6 1.642
29/11/2024 02918 CUS0001 Customer 0001 SALES MAIN 0 3 1.639
29/11/2024 02972 CUS0017 Customer 0017 SALES MAIN 0 3 1.636
29/11/2024 03131 CUS0029 Customer 0029 SALES MAIN 0 10 1.626

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.