Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00633
Item Name Product 00633
Current Stock 1.425
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.514 Opening Balance
62 Inbound Qty
151 Outbound Qty
1.425 Closing Balance
Transaction Ledger 11 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 62 0 1.357
01/11/2024 03498 CUS0001 Customer 0001 SALES MAIN 0 121 1.236
05/11/2024 04208 CUS0510 Customer 0510 SALES MAIN 0 3 1.233
07/11/2024 04760 CUS0001 Customer 0001 SALES MAIN 0 6 1.227
08/11/2024 04925 CUS0006 Customer 0006 SALES MAIN 0 3 1.224
13/11/2024 06183 CUS0576 Customer 0576 SALES MAIN 0 1 1.223
14/11/2024 06220 CUS0822 Customer 0822 SALES MAIN 0 1 1.222
16/11/2024 00181 CUS0611 Customer 0611 SALES MAIN 0 1 1.221
18/11/2024 00414 CUS0004 Customer 0004 SALES MAIN 0 6 1.215
21/11/2024 01157 CUS0005 Customer 0005 SALES MAIN 0 3 1.212
23/11/2024 01727 CUS0008 Customer 0008 SALES MAIN 0 6 1.206

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.