Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01623
Item Name Product 01623
Current Stock 1.903
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.427 Opening Balance
750 Inbound Qty
274 Outbound Qty
1.903 Closing Balance
Transaction Ledger 24 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 750 0 1.930
01/11/2024 03341 CUS0584 Customer 0584 SALES MAIN 0 26 1.904
01/11/2024 03423 CUS0584 Customer 0584 SALES MAIN 0 13 1.891
04/11/2024 03908 CUS0584 Customer 0584 SALES MAIN 0 13 1.878
04/11/2024 03917 CUS0029 Customer 0029 SALES MAIN 0 16 1.862
04/11/2024 03969 CUS0006 Customer 0006 SALES MAIN 0 6 1.856
05/11/2024 04095 CUS0022 Customer 0022 SALES MAIN 0 33 1.823
05/11/2024 04290 CUS0010 Customer 0010 SALES MAIN 0 3 1.820
06/11/2024 04316 CUS0009 Customer 0009 SALES MAIN 0 33 1.787
06/11/2024 04378 CUS0584 Customer 0584 SALES MAIN 0 6 1.781
06/11/2024 04513 CUS0002 Customer 0002 SALES MAIN 0 6 1.775
07/11/2024 04748 CUS0822 Customer 0822 SALES MAIN 0 6 1.769
08/11/2024 04879 CUS0821 Customer 0821 SALES MAIN 0 10 1.759
09/11/2024 05189 CUS0584 Customer 0584 SALES MAIN 0 6 1.753
11/11/2024 05363 CUS0006 Customer 0006 SALES MAIN 0 6 1.747
11/11/2024 05569 CUS0584 Customer 0584 SALES MAIN 0 6 1.741
12/11/2024 05765 CUS0003 Customer 0003 SALES MAIN 0 16 1.725
12/11/2024 05905 CUS0576 Customer 0576 SALES MAIN 0 6 1.719
16/11/2024 00004 CUS0006 Customer 0006 SALES MAIN 0 16 1.703
16/11/2024 00203 CUS0003 Customer 0003 SALES MAIN 0 6 1.697
25/11/2024 01849 CUS0581 Customer 0581 SALES MAIN 0 16 1.681
25/11/2024 01852 CUS0006 Customer 0006 SALES MAIN 0 16 1.665
27/11/2024 02407 CUS0208 Customer 0208 SALES MAIN 0 3 1.662
28/11/2024 02596 CUS0002 Customer 0002 SALES MAIN 0 6 1.656

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.