Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00557
Item Name Product 00557
Current Stock 1.410
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
792 Opening Balance
809 Inbound Qty
191 Outbound Qty
1.410 Closing Balance
Transaction Ledger 60 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 809 0 1.476
01/11/2024 03343 CUS0006 Customer 0006 SALES MAIN 0 6 1.470
01/11/2024 03418 CUS0584 Customer 0584 SALES MAIN 0 3 1.467
02/11/2024 03520 CUS0509 Customer 0509 SALES MAIN 0 1 1.466
02/11/2024 03581 CUS0017 Customer 0017 SALES MAIN 0 3 1.463
04/11/2024 03903 CUS0029 Customer 0029 SALES MAIN 0 3 1.460
04/11/2024 03909 CUS0208 Customer 0208 SALES MAIN 0 3 1.457
04/11/2024 03982 CUS0003 Customer 0003 SALES MAIN 0 10 1.447
05/11/2024 04101 CUS0584 Customer 0584 SALES MAIN 0 1 1.446
06/11/2024 04372 CUS0003 Customer 0003 SALES MAIN 0 3 1.443
06/11/2024 04374 CUS0024 Customer 0024 SALES MAIN 0 3 1.440
06/11/2024 04510 CUS0001 Customer 0001 SALES MAIN 0 3 1.437
07/11/2024 04582 CUS0584 Customer 0584 SALES MAIN 0 3 1.434
07/11/2024 04719 CUS0001 Customer 0001 SALES MAIN 0 1 1.433
07/11/2024 04743 CUS0017 Customer 0017 SALES MAIN 0 5 1.428
07/11/2024 04747 CUS0001 Customer 0001 SALES MAIN 0 3 1.425
08/11/2024 04956 CUS0029 Customer 0029 SALES MAIN 0 3 1.422
11/11/2024 05524 CUS0006 Customer 0006 SALES MAIN 0 1 1.421
11/11/2024 05584 CUS0208 Customer 0208 SALES MAIN 0 3 1.418
12/11/2024 05597 CUS0822 Customer 0822 SALES MAIN 0 3 1.415
12/11/2024 05665 CUS0584 Customer 0584 SALES MAIN 0 1 1.414
12/11/2024 05761 CUS0029 Customer 0029 SALES MAIN 0 10 1.404
12/11/2024 05889 CUS0798 Customer 0798 SALES MAIN 0 6 1.398
12/11/2024 05908 CUS0029 Customer 0029 SALES MAIN 0 3 1.395
12/11/2024 05925 CUS0029 Customer 0029 SALES MAIN 0 3 1.392
13/11/2024 06079 CUS0584 Customer 0584 SALES MAIN 0 3 1.389
13/11/2024 06180 CUS0001 Customer 0001 SALES MAIN 0 1 1.388
14/11/2024 06212 CUS0584 Customer 0584 SALES MAIN 0 3 1.385
14/11/2024 06216 CUS0584 Customer 0584 SALES MAIN 0 1 1.384
14/11/2024 06366 CUS0630 Customer 0630 SALES MAIN 0 6 1.378
14/11/2024 06369 CUS0009 Customer 0009 SALES MAIN 0 3 1.375
15/11/2024 06535 CUS0584 Customer 0584 SALES MAIN 0 1 1.374
15/11/2024 06552 CUS0001 Customer 0001 SALES MAIN 0 3 1.371
16/11/2024 00028 CUS0005 Customer 0005 SALES MAIN 0 3 1.368
16/11/2024 00039 CUS0004 Customer 0004 SALES MAIN 0 1 1.367
16/11/2024 00174 CUS0509 Customer 0509 SALES MAIN 0 3 1.364
18/11/2024 00225 CUS0010 Customer 0010 SALES MAIN 0 1 1.363
18/11/2024 00412 CUS0584 Customer 0584 SALES MAIN 0 1 1.362
18/11/2024 00420 CUS0006 Customer 0006 SALES MAIN 0 3 1.359
18/11/2024 00434 CUS0002 Customer 0002 SALES MAIN 0 1 1.358
18/11/2024 00526 CUS0584 Customer 0584 SALES MAIN 0 3 1.355
21/11/2024 01042 CUS0577 Customer 0577 SALES MAIN 0 1 1.354
21/11/2024 01047 CUS0029 Customer 0029 SALES MAIN 0 3 1.351
23/11/2024 01511 CUS0822 Customer 0822 SALES MAIN 0 6 1.345
23/11/2024 01518 CUS0576 Customer 0576 SALES MAIN 0 10 1.335
25/11/2024 01873 CUS0009 Customer 0009 SALES MAIN 0 1 1.334
25/11/2024 01937 CUS0009 Customer 0009 SALES MAIN 0 6 1.328
25/11/2024 01938 CUS0022 Customer 0022 SALES MAIN 0 1 1.327
25/11/2024 01943 CUS0578 Customer 0578 SALES MAIN 0 3 1.324
25/11/2024 01959 CUS0010 Customer 0010 SALES MAIN 0 1 1.323
25/11/2024 02004 CUS0576 Customer 0576 SALES MAIN 0 6 1.317
25/11/2024 02011 CUS0686 Customer 0686 SALES MAIN 0 6 1.311
27/11/2024 02502 CUS0029 Customer 0029 SALES MAIN 0 3 1.308
27/11/2024 02515 CUS0822 Customer 0822 SALES MAIN 0 6 1.302
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 3 1.299
28/11/2024 02596 CUS0002 Customer 0002 SALES MAIN 0 3 1.296
28/11/2024 02750 CUS0002 Customer 0002 SALES MAIN 0 1 1.295
28/11/2024 02820 CUS0009 Customer 0009 SALES MAIN 0 6 1.289
29/11/2024 02918 CUS0001 Customer 0001 SALES MAIN 0 3 1.286
30/11/2024 03233 CUS0001 Customer 0001 SALES MAIN 0 1 1.285

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.