Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03136
Item Name Product 03136
Current Stock 2.257
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.094 Opening Balance
470 Inbound Qty
307 Outbound Qty
2.257 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 470 0 2.306
01/11/2024 03405 CUS0318 Customer 0318 SALES MAIN 0 133 2.173
08/11/2024 04951 CUS0009 Customer 0009 SALES MAIN 0 66 2.107
12/11/2024 05671 CUS0029 Customer 0029 SALES MAIN 0 10 2.097
12/11/2024 05769 CUS0006 Customer 0006 SALES MAIN 0 10 2.087
23/11/2024 01692 CUS0003 Customer 0003 SALES MAIN 0 33 2.054
25/11/2024 01935 CUS0822 Customer 0822 SALES MAIN 0 33 2.021
25/11/2024 02020 CUS0205 Customer 0205 SALES MAIN 0 3 2.018
27/11/2024 02495 CUS0611 Customer 0611 SALES MAIN 0 3 2.015
30/11/2024 03302 CUS0205 Customer 0205 SALES MAIN 0 16 1.999

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.