Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02758
Item Name Product 02758
Current Stock 1.911
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.438 Opening Balance
613 Inbound Qty
140 Outbound Qty
1.911 Closing Balance
Transaction Ledger 19 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 613 0 1.584
01/11/2024 03345 CUS0822 Customer 0822 SALES MAIN 0 16 1.568
02/11/2024 03573 CUS0630 Customer 0630 SALES MAIN 0 10 1.558
02/11/2024 03582 CUS0022 Customer 0022 SALES MAIN 0 6 1.552
02/11/2024 03588 CUS0822 Customer 0822 SALES MAIN 0 3 1.549
05/11/2024 04084 CUS0784 Customer 0784 SALES MAIN 0 5 1.544
09/11/2024 05264 CUS0611 Customer 0611 SALES MAIN 0 2 1.542
11/11/2024 05438 CUS0001 Customer 0001 SALES MAIN 0 10 1.532
12/11/2024 05796 CUS0029 Customer 0029 SALES MAIN 0 5 1.527
13/11/2024 05960 CUS0006 Customer 0006 SALES MAIN 0 6 1.521
14/11/2024 06304 CUS0611 Customer 0611 SALES MAIN 0 2 1.519
15/11/2024 06534 CUS0208 Customer 0208 SALES MAIN 0 3 1.516
15/11/2024 06609 CUS0630 Customer 0630 SALES MAIN 0 16 1.500
18/11/2024 00422 CUS0006 Customer 0006 SALES MAIN 0 1 1.499
21/11/2024 01239 CUS0002 Customer 0002 SALES MAIN 0 10 1.489
23/11/2024 01715 CUS0611 Customer 0611 SALES MAIN 0 3 1.486
25/11/2024 01960 CUS0022 Customer 0022 SALES MAIN 0 16 1.470
29/11/2024 02920 CUS0630 Customer 0630 SALES MAIN 0 13 1.457
29/11/2024 03131 CUS0029 Customer 0029 SALES MAIN 0 13 1.444

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.