Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00273
Item Name Product 00273
Current Stock 4.479
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.530 Opening Balance
2.443 Inbound Qty
494 Outbound Qty
4.479 Closing Balance
Transaction Ledger 44 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 2.443 0 4.313
02/11/2024 03572 CUS0510 Customer 0510 SALES MAIN 0 6 4.307
02/11/2024 03587 CUS0822 Customer 0822 SALES MAIN 0 3 4.304
04/11/2024 03776 CUS0002 Customer 0002 SALES MAIN 0 6 4.298
05/11/2024 04105 CUS0002 Customer 0002 SALES MAIN 0 3 4.295
06/11/2024 04313 CUS0022 Customer 0022 SALES MAIN 0 16 4.279
06/11/2024 04513 CUS0002 Customer 0002 SALES MAIN 0 1 4.278
07/11/2024 04585 CUS0002 Customer 0002 SALES MAIN 0 3 4.275
08/11/2024 04933 CUS0029 Customer 0029 SALES MAIN 0 3 4.272
09/11/2024 05261 CUS0510 Customer 0510 SALES MAIN 0 16 4.256
11/11/2024 05380 CUS0785 Customer 0785 SALES MAIN 0 50 4.206
11/11/2024 05416 CUS0004 Customer 0004 SALES MAIN 0 10 4.196
12/11/2024 05763 CUS0584 Customer 0584 SALES MAIN 0 3 4.193
12/11/2024 05916 CUS0795 Customer 0795 SALES MAIN 0 3 4.190
13/11/2024 06193 CUS0006 Customer 0006 SALES MAIN 0 6 4.184
13/11/2024 06204 CUS0208 Customer 0208 SALES MAIN 0 6 4.178
14/11/2024 06219 CUS0001 Customer 0001 SALES MAIN 0 3 4.175
14/11/2024 06296 CUS0208 Customer 0208 SALES MAIN 0 6 4.169
15/11/2024 06461 CUS0576 Customer 0576 SALES MAIN 0 16 4.153
15/11/2024 06464 CUS0576 Customer 0576 SALES MAIN 0 26 4.127
16/11/2024 00192 CUS0029 Customer 0029 SALES MAIN 0 10 4.117
16/11/2024 00202 CUS0003 Customer 0003 SALES MAIN 0 16 4.101
16/11/2024 00203 CUS0003 Customer 0003 SALES MAIN 0 16 4.085
18/11/2024 00324 CUS0510 Customer 0510 SALES MAIN 0 6 4.079
18/11/2024 00325 CUS0006 Customer 0006 SALES MAIN 0 100 3.979
18/11/2024 00432 CUS0218 Customer 0218 SALES MAIN 0 16 3.963
21/11/2024 01075 CUS0006 Customer 0006 SALES MAIN 0 6 3.957
21/11/2024 01151 CUS0006 Customer 0006 SALES MAIN 0 10 3.947
21/11/2024 01160 CUS0287 Customer 0287 SALES MAIN 0 6 3.941
22/11/2024 01499 CUS0208 Customer 0208 SALES MAIN 0 6 3.935
23/11/2024 01502 CUS0611 Customer 0611 SALES MAIN 0 6 3.929
23/11/2024 01509 CUS0795 Customer 0795 SALES MAIN 0 3 3.926
23/11/2024 01510 CUS0509 Customer 0509 SALES MAIN 0 6 3.920
23/11/2024 01703 CUS0208 Customer 0208 SALES MAIN 0 6 3.914
25/11/2024 01749 CUS0006 Customer 0006 SALES MAIN 0 6 3.908
25/11/2024 01959 CUS0010 Customer 0010 SALES MAIN 0 1 3.907
27/11/2024 02417 CUS0208 Customer 0208 SALES MAIN 0 10 3.897
28/11/2024 02736 CUS0022 Customer 0022 SALES MAIN 0 1 3.896
28/11/2024 02748 CUS0041 Customer 0041 SALES MAIN 0 10 3.886
29/11/2024 02915 CUS0006 Customer 0006 SALES MAIN 0 33 3.853
29/11/2024 02988 CUS0006 Customer 0006 SALES MAIN 0 2 3.851
29/11/2024 02995 CUS0582 Customer 0582 SALES MAIN 0 16 3.835
30/11/2024 03154 CUS0006 Customer 0006 SALES MAIN 0 13 3.822
30/11/2024 03219 CUS0584 Customer 0584 SALES MAIN 0 3 3.819

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.