Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00142
Item Name Product 00142
Current Stock 6.228
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
4.104 Opening Balance
3.460 Inbound Qty
1.336 Outbound Qty
6.228 Closing Balance
Transaction Ledger 33 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 3.460 0 6.998
02/11/2024 03580 CUS0208 Customer 0208 SALES MAIN 0 16 6.982
04/11/2024 03902 CUS0215 Customer 0215 SALES MAIN 0 6 6.976
04/11/2024 03904 CUS0584 Customer 0584 SALES MAIN 0 16 6.960
04/11/2024 03979 CUS0006 Customer 0006 SALES MAIN 0 66 6.894
04/11/2024 03982 CUS0003 Customer 0003 SALES MAIN 0 16 6.878
07/11/2024 04749 CUS0010 Customer 0010 SALES MAIN 0 166 6.712
07/11/2024 04842 CUS0208 Customer 0208 SALES MAIN 0 16 6.696
08/11/2024 05022 CUS0104 Customer 0104 SALES MAIN 0 5 6.691
09/11/2024 05275 CUS0287 Customer 0287 SALES MAIN 0 100 6.591
11/11/2024 05327 CUS0010 Customer 0010 SALES MAIN 0 33 6.558
11/11/2024 05379 CUS0208 Customer 0208 SALES MAIN 0 16 6.542
13/11/2024 06044 CUS0009 Customer 0009 SALES MAIN 0 16 6.526
13/11/2024 06168 CUS0318 Customer 0318 SALES MAIN 0 133 6.393
13/11/2024 06170 CUS0010 Customer 0010 SALES MAIN 0 33 6.360
13/11/2024 06175 CUS0822 Customer 0822 SALES MAIN 0 33 6.327
15/11/2024 06534 CUS0208 Customer 0208 SALES MAIN 0 16 6.311
15/11/2024 06603 CUS0001 Customer 0001 SALES MAIN 0 20 6.291
18/11/2024 00326 CUS0001 Customer 0001 SALES MAIN 0 20 6.271
18/11/2024 00351 CUS0006 Customer 0006 SALES MAIN 0 100 6.171
18/11/2024 00358 CUS0795 Customer 0795 SALES MAIN 0 66 6.105
18/11/2024 00429 CUS0001 Customer 0001 SALES MAIN 0 26 6.079
18/11/2024 00535 CUS0576 Customer 0576 SALES MAIN 0 33 6.046
21/11/2024 01286 CUS0823 Customer 0823 SALES MAIN 0 33 6.013
23/11/2024 01579 CUS0287 Customer 0287 SALES MAIN 0 16 5.997
25/11/2024 02011 CUS0686 Customer 0686 SALES MAIN 0 100 5.897
27/11/2024 02506 CUS0002 Customer 0002 SALES MAIN 0 50 5.847
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 33 5.814
28/11/2024 02759 CUS0822 Customer 0822 SALES MAIN 0 33 5.781
29/11/2024 02897 CUS0010 Customer 0010 SALES MAIN 0 33 5.748
29/11/2024 02919 CUS0001 Customer 0001 SALES MAIN 0 20 5.728
30/11/2024 03202 CUS0001 Customer 0001 SALES MAIN 0 33 5.695
30/11/2024 03223 CUS0795 Customer 0795 SALES MAIN 0 33 5.662

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.