Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03056
Item Name Product 03056
Current Stock 4.860
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
3.965 Opening Balance
1.610 Inbound Qty
715 Outbound Qty
4.860 Closing Balance
Transaction Ledger 22 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.610 0 5.027
04/11/2024 03888 CUS0576 Customer 0576 SALES MAIN 0 16 5.011
06/11/2024 04397 CUS0584 Customer 0584 SALES MAIN 0 16 4.995
07/11/2024 04699 CUS0208 Customer 0208 SALES MAIN 0 6 4.989
07/11/2024 04742 CUS0584 Customer 0584 SALES MAIN 0 16 4.973
07/11/2024 04844 CUS0630 Customer 0630 SALES MAIN 0 166 4.807
07/11/2024 04860 CUS0576 Customer 0576 SALES MAIN 0 66 4.741
08/11/2024 04869 CUS0022 Customer 0022 SALES MAIN 0 23 4.718
09/11/2024 05184 CUS0584 Customer 0584 SALES MAIN 0 33 4.685
11/11/2024 05422 CUS0215 Customer 0215 SALES MAIN 0 6 4.679
11/11/2024 05551 CUS0049 Customer 0049 SALES MAIN 0 66 4.613
11/11/2024 05558 CUS0002 Customer 0002 SALES MAIN 0 16 4.597
13/11/2024 06191 CUS0002 Customer 0002 SALES MAIN 0 33 4.564
14/11/2024 06392 CUS0046 Customer 0046 SALES MAIN 0 16 4.548
18/11/2024 00227 CUS0584 Customer 0584 SALES MAIN 0 16 4.532
18/11/2024 00233 CUS0208 Customer 0208 SALES MAIN 0 66 4.466
18/11/2024 00416 CUS0205 Customer 0205 SALES MAIN 0 16 4.450
23/11/2024 01592 CUS0208 Customer 0208 SALES MAIN 0 33 4.417
23/11/2024 01689 CUS0822 Customer 0822 SALES MAIN 0 33 4.384
28/11/2024 02820 CUS0009 Customer 0009 SALES MAIN 0 33 4.351
29/11/2024 02997 CUS0784 Customer 0784 SALES MAIN 0 33 4.318
30/11/2024 03208 CUS0208 Customer 0208 SALES MAIN 0 6 4.312

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.