Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00662
Item Name Product 00662
Current Stock 2.087
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.984 Opening Balance
456 Inbound Qty
353 Outbound Qty
2.087 Closing Balance
Transaction Ledger 31 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 456 0 1.940
01/11/2024 03418 CUS0584 Customer 0584 SALES MAIN 0 3 1.937
01/11/2024 03503 CUS0029 Customer 0029 SALES MAIN 0 1 1.936
02/11/2024 03579 CUS0795 Customer 0795 SALES MAIN 0 3 1.933
02/11/2024 03595 CUS0686 Customer 0686 SALES MAIN 0 6 1.927
04/11/2024 03920 CUS0004 Customer 0004 SALES MAIN 0 48 1.879
04/11/2024 03982 CUS0003 Customer 0003 SALES MAIN 0 3 1.876
05/11/2024 03990 CUS0208 Customer 0208 SALES MAIN 0 3 1.873
05/11/2024 04234 CUS0029 Customer 0029 SALES MAIN 0 16 1.857
07/11/2024 04717 CUS0029 Customer 0029 SALES MAIN 0 3 1.854
08/11/2024 04871 CUS0003 Customer 0003 SALES MAIN 0 10 1.844
08/11/2024 04945 CUS0029 Customer 0029 SALES MAIN 0 6 1.838
08/11/2024 05032 CUS0002 Customer 0002 SALES MAIN 0 10 1.828
11/11/2024 05332 CUS0581 Customer 0581 SALES MAIN 0 3 1.825
11/11/2024 05418 CUS0795 Customer 0795 SALES MAIN 0 1 1.824
11/11/2024 05567 CUS0029 Customer 0029 SALES MAIN 0 16 1.808
11/11/2024 05586 CUS0029 Customer 0029 SALES MAIN 0 16 1.792
12/11/2024 05787 CUS0584 Customer 0584 SALES MAIN 0 16 1.776
12/11/2024 05788 CUS0584 Customer 0584 SALES MAIN 0 32 1.744
13/11/2024 05942 CUS0795 Customer 0795 SALES MAIN 0 3 1.741
13/11/2024 06179 CUS0630 Customer 0630 SALES MAIN 0 6 1.735
13/11/2024 06196 CUS0010 Customer 0010 SALES MAIN 0 16 1.719
14/11/2024 06232 CUS0010 Customer 0010 SALES MAIN 0 1 1.718
14/11/2024 06381 CUS0218 Customer 0218 SALES MAIN 0 6 1.712
14/11/2024 06383 CUS0218 Customer 0218 SALES MAIN 0 3 1.709
15/11/2024 06541 CUS0029 Customer 0029 SALES MAIN 0 16 1.693
15/11/2024 06558 CUS0022 Customer 0022 SALES MAIN 0 6 1.687
15/11/2024 06621 CUS0029 Customer 0029 SALES MAIN 0 16 1.671
28/11/2024 02723 CUS0017 Customer 0017 SALES MAIN 0 1 1.670
28/11/2024 02830 CUS0004 Customer 0004 SALES MAIN 0 80 1.590
29/11/2024 03140 CUS0029 Customer 0029 SALES MAIN 0 3 1.587

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.