Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01421
Item Name Product 01421
Current Stock 7.335
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
7.616 Opening Balance
1.776 Inbound Qty
2.057 Outbound Qty
7.335 Closing Balance
Transaction Ledger 33 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.776 0 8.783
01/11/2024 03274 CUS0795 Customer 0795 SALES MAIN 0 33 8.750
01/11/2024 03410 CUS0029 Customer 0029 SALES MAIN 0 66 8.684
02/11/2024 03516 CUS0003 Customer 0003 SALES MAIN 0 10 8.674
04/11/2024 03961 CUS0010 Customer 0010 SALES MAIN 0 33 8.641
04/11/2024 03982 CUS0003 Customer 0003 SALES MAIN 0 13 8.628
07/11/2024 04588 CUS0051 Customer 0051 SALES MAIN 0 108 8.520
07/11/2024 04749 CUS0010 Customer 0010 SALES MAIN 0 54 8.466
08/11/2024 04922 CUS0029 Customer 0029 SALES MAIN 0 133 8.333
08/11/2024 05039 CUS0029 Customer 0029 SALES MAIN 0 108 8.225
09/11/2024 05265 CUS0027 Customer 0027 SALES MAIN 0 216 8.009
09/11/2024 05267 CUS0576 Customer 0576 SALES MAIN 0 16 7.993
11/11/2024 05337 CUS0795 Customer 0795 SALES MAIN 0 54 7.939
11/11/2024 05535 CUS0029 Customer 0029 SALES MAIN 0 16 7.923
11/11/2024 05567 CUS0029 Customer 0029 SALES MAIN 0 33 7.890
12/11/2024 05783 CUS0584 Customer 0584 SALES MAIN 0 33 7.857
12/11/2024 05918 CUS0041 Customer 0041 SALES MAIN 0 16 7.841
13/11/2024 06196 CUS0010 Customer 0010 SALES MAIN 0 270 7.571
14/11/2024 06226 CUS0029 Customer 0029 SALES MAIN 0 540 7.031
15/11/2024 06541 CUS0029 Customer 0029 SALES MAIN 0 54 6.977
16/11/2024 00075 CUS0006 Customer 0006 SALES MAIN 0 33 6.944
18/11/2024 00415 CUS0822 Customer 0822 SALES MAIN 0 54 6.890
18/11/2024 00435 CUS0611 Customer 0611 SALES MAIN 0 6 6.884
18/11/2024 00531 CUS0576 Customer 0576 SALES MAIN 0 33 6.851
25/11/2024 01843 CUS0006 Customer 0006 SALES MAIN 0 13 6.838
25/11/2024 01848 CUS0017 Customer 0017 SALES MAIN 0 33 6.805
25/11/2024 01945 CUS0001 Customer 0001 SALES MAIN 0 3 6.802
28/11/2024 02588 CUS0207 Customer 0207 SALES MAIN 0 3 6.799
28/11/2024 02595 CUS0287 Customer 0287 SALES MAIN 0 10 6.789
28/11/2024 02737 CUS0584 Customer 0584 SALES MAIN 0 10 6.779
28/11/2024 02818 CUS0584 Customer 0584 SALES MAIN 0 10 6.769
28/11/2024 02823 CUS0002 Customer 0002 SALES MAIN 0 10 6.759
29/11/2024 02969 CUS0003 Customer 0003 SALES MAIN 0 33 6.726

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.