Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM04849
Item Name Product 04849
Current Stock 2.980
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.576 Opening Balance
1.601 Inbound Qty
197 Outbound Qty
2.980 Closing Balance
Transaction Ledger 14 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 1.601 0 2.701
02/11/2024 03589 CUS0822 Customer 0822 SALES MAIN 0 10 2.691
04/11/2024 03709 CUS0022 Customer 0022 SALES MAIN 0 23 2.668
04/11/2024 03985 CUS0045 Customer 0045 SALES MAIN 0 6 2.662
07/11/2024 04578 CUS0006 Customer 0006 SALES MAIN 0 6 2.656
08/11/2024 04878 CUS0021 Customer 0021 SALES MAIN 0 1 2.655
11/11/2024 05389 CUS0581 Customer 0581 SALES MAIN 0 33 2.622
12/11/2024 05675 CUS0021 Customer 0021 SALES MAIN 0 23 2.599
14/11/2024 06233 CUS0287 Customer 0287 SALES MAIN 0 6 2.593
14/11/2024 06375 CUS0287 Customer 0287 SALES MAIN 0 3 2.590
15/11/2024 06627 CUS0630 Customer 0630 SALES MAIN 0 1 2.589
21/11/2024 01060 CUS0022 Customer 0022 SALES MAIN 0 66 2.523
27/11/2024 02402 CUS0821 Customer 0821 SALES MAIN 0 16 2.507
30/11/2024 03299 CUS0287 Customer 0287 SALES MAIN 0 3 2.504

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.