Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00277
Item Name Product 00277
Current Stock 2.180
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.264 Opening Balance
1.235 Inbound Qty
319 Outbound Qty
2.180 Closing Balance
Transaction Ledger 27 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.235 0 2.253
01/11/2024 03404 CUS0029 Customer 0029 SALES MAIN 0 6 2.247
02/11/2024 03519 CUS0208 Customer 0208 SALES MAIN 0 6 2.241
04/11/2024 03774 CUS0017 Customer 0017 SALES MAIN 0 3 2.238
04/11/2024 03776 CUS0002 Customer 0002 SALES MAIN 0 1 2.237
06/11/2024 04513 CUS0002 Customer 0002 SALES MAIN 0 1 2.236
11/11/2024 05375 CUS0208 Customer 0208 SALES MAIN 0 3 2.233
11/11/2024 05380 CUS0785 Customer 0785 SALES MAIN 0 16 2.217
11/11/2024 05439 CUS0005 Customer 0005 SALES MAIN 0 1 2.216
12/11/2024 05763 CUS0584 Customer 0584 SALES MAIN 0 3 2.213
12/11/2024 05931 CUS0002 Customer 0002 SALES MAIN 0 3 2.210
13/11/2024 06204 CUS0208 Customer 0208 SALES MAIN 0 3 2.207
15/11/2024 06451 CUS0029 Customer 0029 SALES MAIN 0 83 2.124
15/11/2024 06461 CUS0576 Customer 0576 SALES MAIN 0 10 2.114
15/11/2024 06464 CUS0576 Customer 0576 SALES MAIN 0 10 2.104
16/11/2024 00044 CUS0001 Customer 0001 SALES MAIN 0 16 2.088
16/11/2024 00202 CUS0003 Customer 0003 SALES MAIN 0 10 2.078
18/11/2024 00325 CUS0006 Customer 0006 SALES MAIN 0 33 2.045
18/11/2024 00333 CUS0002 Customer 0002 SALES MAIN 0 3 2.042
18/11/2024 00338 CUS0009 Customer 0009 SALES MAIN 0 3 2.039
21/11/2024 01071 CUS0582 Customer 0582 SALES MAIN 0 3 2.036
27/11/2024 02412 CUS0822 Customer 0822 SALES MAIN 0 83 1.953
27/11/2024 02563 CUS0686 Customer 0686 SALES MAIN 0 6 1.947
28/11/2024 02596 CUS0002 Customer 0002 SALES MAIN 0 1 1.946
29/11/2024 02995 CUS0582 Customer 0582 SALES MAIN 0 3 1.943
29/11/2024 03139 CUS0205 Customer 0205 SALES MAIN 0 3 1.940
30/11/2024 03228 CUS0002 Customer 0002 SALES MAIN 0 6 1.934

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.