Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00153
Item Name Product 00153
Current Stock 15.958
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
9.442 Opening Balance
8.790 Inbound Qty
2.274 Outbound Qty
15.958 Closing Balance
Transaction Ledger 43 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 8.790 0 17.787
01/11/2024 03340 CUS0006 Customer 0006 SALES MAIN 0 16 17.771
04/11/2024 03799 CUS0029 Customer 0029 SALES MAIN 0 33 17.738
05/11/2024 04086 CUS0584 Customer 0584 SALES MAIN 0 333 17.405
05/11/2024 04099 CUS0010 Customer 0010 SALES MAIN 0 20 17.385
05/11/2024 04103 CUS0584 Customer 0584 SALES MAIN 0 66 17.319
05/11/2024 04217 CUS0029 Customer 0029 SALES MAIN 0 16 17.303
06/11/2024 04320 CUS0009 Customer 0009 SALES MAIN 0 33 17.270
06/11/2024 04482 CUS0006 Customer 0006 SALES MAIN 0 66 17.204
07/11/2024 04580 CUS0006 Customer 0006 SALES MAIN 0 20 17.184
07/11/2024 04749 CUS0010 Customer 0010 SALES MAIN 0 100 17.084
07/11/2024 04854 CUS0795 Customer 0795 SALES MAIN 0 116 16.968
08/11/2024 04874 CUS0010 Customer 0010 SALES MAIN 0 66 16.902
08/11/2024 04938 CUS0584 Customer 0584 SALES MAIN 0 66 16.836
08/11/2024 05009 CUS0029 Customer 0029 SALES MAIN 0 33 16.803
08/11/2024 05030 CUS0017 Customer 0017 SALES MAIN 0 33 16.770
08/11/2024 05034 CUS0510 Customer 0510 SALES MAIN 0 66 16.704
11/11/2024 05367 CUS0822 Customer 0822 SALES MAIN 0 23 16.681
11/11/2024 05370 CUS0006 Customer 0006 SALES MAIN 0 33 16.648
11/11/2024 05373 CUS0208 Customer 0208 SALES MAIN 0 20 16.628
11/11/2024 05427 CUS0822 Customer 0822 SALES MAIN 0 66 16.562
11/11/2024 05428 CUS0584 Customer 0584 SALES MAIN 0 16 16.546
11/11/2024 05551 CUS0049 Customer 0049 SALES MAIN 0 166 16.380
12/11/2024 05669 CUS0822 Customer 0822 SALES MAIN 0 50 16.330
12/11/2024 05800 CUS0006 Customer 0006 SALES MAIN 0 10 16.320
12/11/2024 05914 CUS0287 Customer 0287 SALES MAIN 0 33 16.287
12/11/2024 05925 CUS0029 Customer 0029 SALES MAIN 0 16 16.271
13/11/2024 06163 CUS0009 Customer 0009 SALES MAIN 0 66 16.205
13/11/2024 06169 CUS0823 Customer 0823 SALES MAIN 0 33 16.172
15/11/2024 06468 CUS0022 Customer 0022 SALES MAIN 0 66 16.106
18/11/2024 00321 CUS0037 Customer 0037 SALES MAIN 0 6 16.100
21/11/2024 01045 CUS0686 Customer 0686 SALES MAIN 0 16 16.084
23/11/2024 01514 CUS0003 Customer 0003 SALES MAIN 0 33 16.051
23/11/2024 01682 CUS0208 Customer 0208 SALES MAIN 0 16 16.035
23/11/2024 01703 CUS0208 Customer 0208 SALES MAIN 0 16 16.019
23/11/2024 01705 CUS0822 Customer 0822 SALES MAIN 0 33 15.986
25/11/2024 01844 CUS0024 Customer 0024 SALES MAIN 0 26 15.960
25/11/2024 01874 CUS0003 Customer 0003 SALES MAIN 0 33 15.927
25/11/2024 01931 CUS0049 Customer 0049 SALES MAIN 0 166 15.761
28/11/2024 02570 CUS0041 Customer 0041 SALES MAIN 0 33 15.728
28/11/2024 02592 CUS0041 Customer 0041 SALES MAIN 0 66 15.662
29/11/2024 03069 CUS0005 Customer 0005 SALES MAIN 0 33 15.629
30/11/2024 03205 CUS0010 Customer 0010 SALES MAIN 0 116 15.513

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.