Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00871
Item Name Product 00871
Current Stock 1.917
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.776 Opening Balance
270 Inbound Qty
129 Outbound Qty
1.917 Closing Balance
Transaction Ledger 10 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 270 0 1.515
09/11/2024 05168 CUS0584 Customer 0584 SALES MAIN 0 26 1.489
12/11/2024 05772 CUS0584 Customer 0584 SALES MAIN 0 6 1.483
12/11/2024 05916 CUS0795 Customer 0795 SALES MAIN 0 3 1.480
12/11/2024 05925 CUS0029 Customer 0029 SALES MAIN 0 3 1.477
14/11/2024 06238 CUS0027 Customer 0027 SALES MAIN 0 33 1.444
14/11/2024 06392 CUS0046 Customer 0046 SALES MAIN 0 6 1.438
16/11/2024 00167 CUS0822 Customer 0822 SALES MAIN 0 6 1.432
21/11/2024 01068 CUS0208 Customer 0208 SALES MAIN 0 33 1.399
30/11/2024 03220 CUS0009 Customer 0009 SALES MAIN 0 13 1.386

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.