Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03822
Item Name Product 03822
Current Stock 1.580
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.428 Opening Balance
410 Inbound Qty
258 Outbound Qty
1.580 Closing Balance
Transaction Ledger 15 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 410 0 1.511
01/11/2024 03334 CUS0001 Customer 0001 SALES MAIN 0 6 1.505
01/11/2024 03492 CUS0795 Customer 0795 SALES MAIN 0 6 1.499
02/11/2024 03595 CUS0686 Customer 0686 SALES MAIN 0 33 1.466
04/11/2024 03788 CUS0006 Customer 0006 SALES MAIN 0 7 1.459
04/11/2024 03962 CUS0002 Customer 0002 SALES MAIN 0 33 1.426
06/11/2024 04361 CUS0584 Customer 0584 SALES MAIN 0 6 1.420
12/11/2024 05799 CUS0576 Customer 0576 SALES MAIN 0 33 1.387
13/11/2024 05947 CUS0795 Customer 0795 SALES MAIN 0 16 1.371
14/11/2024 06218 CUS0001 Customer 0001 SALES MAIN 0 16 1.355
15/11/2024 06548 CUS0029 Customer 0029 SALES MAIN 0 33 1.322
18/11/2024 00326 CUS0001 Customer 0001 SALES MAIN 0 10 1.312
18/11/2024 00359 CUS0795 Customer 0795 SALES MAIN 0 16 1.296
18/11/2024 00427 CUS0584 Customer 0584 SALES MAIN 0 33 1.263
29/11/2024 02835 CUS0009 Customer 0009 SALES MAIN 0 10 1.253

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.