Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00453
Item Name Product 00453
Current Stock 2.202
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.622 Opening Balance
765 Inbound Qty
185 Outbound Qty
2.202 Closing Balance
Transaction Ledger 16 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 765 0 1.768
05/11/2024 04092 CUS0583 Customer 0583 SALES MAIN 0 10 1.758
07/11/2024 04580 CUS0006 Customer 0006 SALES MAIN 0 3 1.755
07/11/2024 04706 CUS0017 Customer 0017 SALES MAIN 0 33 1.722
07/11/2024 04854 CUS0795 Customer 0795 SALES MAIN 0 13 1.709
08/11/2024 04872 CUS0822 Customer 0822 SALES MAIN 0 13 1.696
09/11/2024 05174 CUS0029 Customer 0029 SALES MAIN 0 16 1.680
11/11/2024 05427 CUS0822 Customer 0822 SALES MAIN 0 6 1.674
12/11/2024 05912 CUS0029 Customer 0029 SALES MAIN 0 33 1.641
13/11/2024 06169 CUS0823 Customer 0823 SALES MAIN 0 6 1.635
14/11/2024 06443 CUS0022 Customer 0022 SALES MAIN 0 6 1.629
15/11/2024 06477 CUS0001 Customer 0001 SALES MAIN 0 16 1.613
21/11/2024 01234 CUS0022 Customer 0022 SALES MAIN 0 16 1.597
23/11/2024 01509 CUS0795 Customer 0795 SALES MAIN 0 1 1.596
28/11/2024 02741 CUS0287 Customer 0287 SALES MAIN 0 3 1.593
30/11/2024 03205 CUS0010 Customer 0010 SALES MAIN 0 10 1.583

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.