Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02747
Item Name Product 02747
Current Stock 1.789
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.710 Opening Balance
340 Inbound Qty
261 Outbound Qty
1.789 Closing Balance
Transaction Ledger 16 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 340 0 1.613
02/11/2024 03587 CUS0822 Customer 0822 SALES MAIN 0 10 1.603
04/11/2024 03893 CUS0822 Customer 0822 SALES MAIN 0 16 1.587
06/11/2024 04520 CUS0795 Customer 0795 SALES MAIN 0 26 1.561
08/11/2024 05009 CUS0029 Customer 0029 SALES MAIN 0 33 1.528
09/11/2024 05192 CUS0003 Customer 0003 SALES MAIN 0 33 1.495
11/11/2024 05330 CUS0212 Customer 0212 SALES MAIN 0 6 1.489
12/11/2024 05779 CUS0027 Customer 0027 SALES MAIN 0 40 1.449
12/11/2024 05781 CUS0002 Customer 0002 SALES MAIN 0 10 1.439
13/11/2024 05960 CUS0006 Customer 0006 SALES MAIN 0 6 1.433
13/11/2024 06061 CUS0010 Customer 0010 SALES MAIN 0 10 1.423
14/11/2024 06292 CUS0027 Customer 0027 SALES MAIN 0 40 1.383
16/11/2024 00032 CUS0208 Customer 0208 SALES MAIN 0 6 1.377
18/11/2024 00353 CUS0784 Customer 0784 SALES MAIN 0 3 1.374
21/11/2024 01141 CUS0006 Customer 0006 SALES MAIN 0 6 1.368
23/11/2024 01693 CUS0822 Customer 0822 SALES MAIN 0 16 1.352

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.