Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03161
Item Name Product 03161
Current Stock 2.172
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.710 Opening Balance
583 Inbound Qty
121 Outbound Qty
2.172 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 583 0 1.753
07/11/2024 04699 CUS0208 Customer 0208 SALES MAIN 0 6 1.747
07/11/2024 04727 CUS0003 Customer 0003 SALES MAIN 0 6 1.741
09/11/2024 05175 CUS0795 Customer 0795 SALES MAIN 0 10 1.731
13/11/2024 05953 CUS0795 Customer 0795 SALES MAIN 0 1 1.730
16/11/2024 00024 CUS0208 Customer 0208 SALES MAIN 0 10 1.720
28/11/2024 02589 CUS0795 Customer 0795 SALES MAIN 0 3 1.717
28/11/2024 02739 CUS0029 Customer 0029 SALES MAIN 0 6 1.711
29/11/2024 03133 CUS0215 Customer 0215 SALES MAIN 0 66 1.645
30/11/2024 03208 CUS0208 Customer 0208 SALES MAIN 0 3 1.642
30/11/2024 03226 CUS0822 Customer 0822 SALES MAIN 0 10 1.632

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.