Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00276
Item Name Product 00276
Current Stock 2.757
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.165 Opening Balance
1.981 Inbound Qty
389 Outbound Qty
2.757 Closing Balance
Transaction Ledger 46 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.981 0 2.925
01/11/2024 03418 CUS0584 Customer 0584 SALES MAIN 0 16 2.909
02/11/2024 03519 CUS0208 Customer 0208 SALES MAIN 0 10 2.899
02/11/2024 03584 CUS0795 Customer 0795 SALES MAIN 0 3 2.896
04/11/2024 03774 CUS0017 Customer 0017 SALES MAIN 0 3 2.893
04/11/2024 03776 CUS0002 Customer 0002 SALES MAIN 0 1 2.892
04/11/2024 03786 CUS0795 Customer 0795 SALES MAIN 0 1 2.891
05/11/2024 04105 CUS0002 Customer 0002 SALES MAIN 0 1 2.890
05/11/2024 04237 CUS0002 Customer 0002 SALES MAIN 0 6 2.884
06/11/2024 04513 CUS0002 Customer 0002 SALES MAIN 0 1 2.883
07/11/2024 04592 CUS0582 Customer 0582 SALES MAIN 0 3 2.880
07/11/2024 04689 CUS0208 Customer 0208 SALES MAIN 0 3 2.877
08/11/2024 04936 CUS0010 Customer 0010 SALES MAIN 0 16 2.861
11/11/2024 05344 CUS0509 Customer 0509 SALES MAIN 0 3 2.858
11/11/2024 05375 CUS0208 Customer 0208 SALES MAIN 0 3 2.855
12/11/2024 05596 CUS0006 Customer 0006 SALES MAIN 0 6 2.849
12/11/2024 05674 CUS0603 Customer 0603 SALES MAIN 0 3 2.846
12/11/2024 05763 CUS0584 Customer 0584 SALES MAIN 0 3 2.843
12/11/2024 05931 CUS0002 Customer 0002 SALES MAIN 0 3 2.840
13/11/2024 06079 CUS0584 Customer 0584 SALES MAIN 0 10 2.830
13/11/2024 06204 CUS0208 Customer 0208 SALES MAIN 0 3 2.827
15/11/2024 06451 CUS0029 Customer 0029 SALES MAIN 0 33 2.794
15/11/2024 06461 CUS0576 Customer 0576 SALES MAIN 0 16 2.778
15/11/2024 06464 CUS0576 Customer 0576 SALES MAIN 0 13 2.765
15/11/2024 06607 CUS0002 Customer 0002 SALES MAIN 0 3 2.762
16/11/2024 00202 CUS0003 Customer 0003 SALES MAIN 0 10 2.752
18/11/2024 00237 CUS0287 Customer 0287 SALES MAIN 0 10 2.742
18/11/2024 00325 CUS0006 Customer 0006 SALES MAIN 0 33 2.709
21/11/2024 01151 CUS0006 Customer 0006 SALES MAIN 0 10 2.699
21/11/2024 01160 CUS0287 Customer 0287 SALES MAIN 0 3 2.696
23/11/2024 01567 CUS0580 Customer 0580 SALES MAIN 0 3 2.693
23/11/2024 01576 CUS0630 Customer 0630 SALES MAIN 0 1 2.692
23/11/2024 01735 CUS0045 Customer 0045 SALES MAIN 0 6 2.686
27/11/2024 02412 CUS0822 Customer 0822 SALES MAIN 0 50 2.636
27/11/2024 02415 CUS0287 Customer 0287 SALES MAIN 0 10 2.626
27/11/2024 02417 CUS0208 Customer 0208 SALES MAIN 0 3 2.623
27/11/2024 02563 CUS0686 Customer 0686 SALES MAIN 0 16 2.607
28/11/2024 02579 CUS0580 Customer 0580 SALES MAIN 0 6 2.601
28/11/2024 02596 CUS0002 Customer 0002 SALES MAIN 0 3 2.598
29/11/2024 02915 CUS0006 Customer 0006 SALES MAIN 0 16 2.582
29/11/2024 02962 CUS0218 Customer 0218 SALES MAIN 0 1 2.581
29/11/2024 02963 CUS0785 Customer 0785 SALES MAIN 0 33 2.548
29/11/2024 02965 CUS0822 Customer 0822 SALES MAIN 0 3 2.545
29/11/2024 03069 CUS0005 Customer 0005 SALES MAIN 0 3 2.542
29/11/2024 03139 CUS0205 Customer 0205 SALES MAIN 0 3 2.539
30/11/2024 03298 CUS0017 Customer 0017 SALES MAIN 0 3 2.536

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.