Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03395
Item Name Product 03395
Current Stock 6.626
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
5.216 Opening Balance
2.840 Inbound Qty
1.430 Outbound Qty
6.626 Closing Balance
Transaction Ledger 29 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 2.840 0 7.657
01/11/2024 03440 CUS0582 Customer 0582 SALES MAIN 0 10 7.647
05/11/2024 04102 CUS0002 Customer 0002 SALES MAIN 0 6 7.641
05/11/2024 04209 CUS0611 Customer 0611 SALES MAIN 0 6 7.635
06/11/2024 04385 CUS0017 Customer 0017 SALES MAIN 0 33 7.602
06/11/2024 04493 CUS0002 Customer 0002 SALES MAIN 0 166 7.436
06/11/2024 04505 CUS0795 Customer 0795 SALES MAIN 0 66 7.370
08/11/2024 04955 CUS0108 Customer 0108 SALES MAIN 0 16 7.354
11/11/2024 05544 CUS0795 Customer 0795 SALES MAIN 0 66 7.288
12/11/2024 05787 CUS0584 Customer 0584 SALES MAIN 0 16 7.272
13/11/2024 06041 CUS0686 Customer 0686 SALES MAIN 0 333 6.939
13/11/2024 06181 CUS0287 Customer 0287 SALES MAIN 0 6 6.933
15/11/2024 06549 CUS0584 Customer 0584 SALES MAIN 0 33 6.900
15/11/2024 06605 CUS0022 Customer 0022 SALES MAIN 0 5 6.895
15/11/2024 06620 CUS0795 Customer 0795 SALES MAIN 0 33 6.862
16/11/2024 00024 CUS0208 Customer 0208 SALES MAIN 0 16 6.846
16/11/2024 00038 CUS0576 Customer 0576 SALES MAIN 0 10 6.836
18/11/2024 00220 CUS0576 Customer 0576 SALES MAIN 0 33 6.803
18/11/2024 00234 CUS0006 Customer 0006 SALES MAIN 0 33 6.770
18/11/2024 00334 CUS0822 Customer 0822 SALES MAIN 0 33 6.737
21/11/2024 01159 CUS0795 Customer 0795 SALES MAIN 0 100 6.637
22/11/2024 01437 CUS0002 Customer 0002 SALES MAIN 0 16 6.621
23/11/2024 01515 CUS0795 Customer 0795 SALES MAIN 0 50 6.571
25/11/2024 02011 CUS0686 Customer 0686 SALES MAIN 0 16 6.555
27/11/2024 02439 CUS0795 Customer 0795 SALES MAIN 0 50 6.505
27/11/2024 02500 CUS0002 Customer 0002 SALES MAIN 0 236 6.269
28/11/2024 02752 CUS0611 Customer 0611 SALES MAIN 0 6 6.263
29/11/2024 03064 CUS0795 Customer 0795 SALES MAIN 0 33 6.230
29/11/2024 03128 CUS0603 Customer 0603 SALES MAIN 0 3 6.227

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.