Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03820
Item Name Product 03820
Current Stock 10.231
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
7.423 Opening Balance
4.900 Inbound Qty
2.092 Outbound Qty
10.231 Closing Balance
Transaction Ledger 23 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 4.900 0 11.646
01/11/2024 03423 CUS0584 Customer 0584 SALES MAIN 0 33 11.613
02/11/2024 03571 CUS0205 Customer 0205 SALES MAIN 0 500 11.113
04/11/2024 03904 CUS0584 Customer 0584 SALES MAIN 0 100 11.013
04/11/2024 03966 CUS0010 Customer 0010 SALES MAIN 0 16 10.997
05/11/2024 03986 CUS0208 Customer 0208 SALES MAIN 0 33 10.964
05/11/2024 04092 CUS0583 Customer 0583 SALES MAIN 0 100 10.864
06/11/2024 04504 CUS0006 Customer 0006 SALES MAIN 0 33 10.831
07/11/2024 04575 CUS0581 Customer 0581 SALES MAIN 0 66 10.765
07/11/2024 04693 CUS0584 Customer 0584 SALES MAIN 0 66 10.699
11/11/2024 05394 CUS0029 Customer 0029 SALES MAIN 0 100 10.599
11/11/2024 05424 CUS0005 Customer 0005 SALES MAIN 0 16 10.583
11/11/2024 05527 CUS0795 Customer 0795 SALES MAIN 0 66 10.517
12/11/2024 05888 CUS0798 Customer 0798 SALES MAIN 0 500 10.017
13/11/2024 06080 CUS0584 Customer 0584 SALES MAIN 0 100 9.917
16/11/2024 00036 CUS0212 Customer 0212 SALES MAIN 0 33 9.884
16/11/2024 00046 CUS0010 Customer 0010 SALES MAIN 0 66 9.818
18/11/2024 00528 CUS0583 Customer 0583 SALES MAIN 0 33 9.785
27/11/2024 02515 CUS0822 Customer 0822 SALES MAIN 0 33 9.752
28/11/2024 02731 CUS0584 Customer 0584 SALES MAIN 0 66 9.686
28/11/2024 02809 CUS0208 Customer 0208 SALES MAIN 0 50 9.636
29/11/2024 02905 CUS0584 Customer 0584 SALES MAIN 0 66 9.570
29/11/2024 02966 CUS0584 Customer 0584 SALES MAIN 0 16 9.554

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.