Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03813
Item Name Product 03813
Current Stock 3.287
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.937 Opening Balance
880 Inbound Qty
530 Outbound Qty
3.287 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 880 0 3.081
01/11/2024 03334 CUS0001 Customer 0001 SALES MAIN 0 3 3.078
01/11/2024 03416 CUS0005 Customer 0005 SALES MAIN 0 16 3.062
04/11/2024 03784 CUS0009 Customer 0009 SALES MAIN 0 10 3.052
04/11/2024 03890 CUS0205 Customer 0205 SALES MAIN 0 10 3.042
04/11/2024 03970 CUS0584 Customer 0584 SALES MAIN 0 50 2.992
04/11/2024 03978 CUS0823 Customer 0823 SALES MAIN 0 2 2.990
05/11/2024 03991 CUS0006 Customer 0006 SALES MAIN 0 13 2.977
07/11/2024 04726 CUS0001 Customer 0001 SALES MAIN 0 66 2.911
08/11/2024 05037 CUS0045 Customer 0045 SALES MAIN 0 16 2.895
11/11/2024 05526 CUS0795 Customer 0795 SALES MAIN 0 33 2.862
12/11/2024 05799 CUS0576 Customer 0576 SALES MAIN 0 33 2.829
12/11/2024 05888 CUS0798 Customer 0798 SALES MAIN 0 66 2.763
13/11/2024 06080 CUS0584 Customer 0584 SALES MAIN 0 50 2.713
14/11/2024 06210 CUS0701 Customer 0701 SALES MAIN 0 33 2.680
14/11/2024 06231 CUS0029 Customer 0029 SALES MAIN 0 6 2.674
15/11/2024 06603 CUS0001 Customer 0001 SALES MAIN 0 3 2.671
16/11/2024 00029 CUS0001 Customer 0001 SALES MAIN 0 16 2.655
16/11/2024 00203 CUS0003 Customer 0003 SALES MAIN 0 10 2.645
23/11/2024 01684 CUS0005 Customer 0005 SALES MAIN 0 6 2.639
23/11/2024 01716 CUS0022 Customer 0022 SALES MAIN 0 66 2.573
29/11/2024 02884 CUS0584 Customer 0584 SALES MAIN 0 16 2.557
29/11/2024 02893 CUS0010 Customer 0010 SALES MAIN 0 6 2.551

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.