Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01970
Item Name Product 01970
Current Stock 2.224
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.798 Opening Balance
579 Inbound Qty
153 Outbound Qty
2.224 Closing Balance
Transaction Ledger 17 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 579 0 1.882
01/11/2024 03405 CUS0318 Customer 0318 SALES MAIN 0 33 1.849
04/11/2024 03909 CUS0208 Customer 0208 SALES MAIN 0 16 1.833
05/11/2024 03991 CUS0006 Customer 0006 SALES MAIN 0 1 1.832
05/11/2024 04107 CUS0001 Customer 0001 SALES MAIN 0 3 1.829
06/11/2024 04518 CUS0630 Customer 0630 SALES MAIN 0 6 1.823
08/11/2024 04944 CUS0208 Customer 0208 SALES MAIN 0 3 1.820
11/11/2024 05334 CUS0006 Customer 0006 SALES MAIN 0 6 1.814
11/11/2024 05585 CUS0822 Customer 0822 SALES MAIN 0 50 1.764
18/11/2024 00223 CUS0017 Customer 0017 SALES MAIN 0 1 1.763
18/11/2024 00423 CUS0029 Customer 0029 SALES MAIN 0 10 1.753
22/11/2024 01438 CUS0611 Customer 0611 SALES MAIN 0 1 1.752
23/11/2024 01725 CUS0822 Customer 0822 SALES MAIN 0 3 1.749
25/11/2024 01737 CUS0029 Customer 0029 SALES MAIN 0 3 1.746
25/11/2024 01756 CUS0630 Customer 0630 SALES MAIN 0 13 1.733
25/11/2024 01873 CUS0009 Customer 0009 SALES MAIN 0 1 1.732
27/11/2024 02418 CUS0006 Customer 0006 SALES MAIN 0 3 1.729

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.