Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01620
Item Name Product 01620
Current Stock 10.136
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
8.552 Opening Balance
3.890 Inbound Qty
2.306 Outbound Qty
10.136 Closing Balance
Transaction Ledger 48 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 3.890 0 12.164
01/11/2024 03352 CUS0786 Customer 0786 SALES MAIN 0 80 12.084
01/11/2024 03436 CUS0041 Customer 0041 SALES MAIN 0 33 12.051
04/11/2024 03703 CUS0630 Customer 0630 SALES MAIN 0 4 12.047
04/11/2024 03882 CUS0029 Customer 0029 SALES MAIN 0 26 12.021
04/11/2024 03981 CUS0017 Customer 0017 SALES MAIN 0 33 11.988
05/11/2024 04100 CUS0795 Customer 0795 SALES MAIN 0 400 11.588
06/11/2024 04385 CUS0017 Customer 0017 SALES MAIN 0 10 11.578
06/11/2024 04486 CUS0002 Customer 0002 SALES MAIN 0 3 11.575
07/11/2024 04715 CUS0207 Customer 0207 SALES MAIN 0 10 11.565
07/11/2024 04749 CUS0010 Customer 0010 SALES MAIN 0 40 11.525
08/11/2024 04869 CUS0022 Customer 0022 SALES MAIN 0 8 11.517
08/11/2024 05008 CUS0819 Customer 0819 SALES MAIN 0 33 11.484
09/11/2024 05199 CUS0009 Customer 0009 SALES MAIN 0 40 11.444
09/11/2024 05253 CUS0021 Customer 0021 SALES MAIN 0 66 11.378
09/11/2024 05265 CUS0027 Customer 0027 SALES MAIN 0 80 11.298
11/11/2024 05338 CUS0029 Customer 0029 SALES MAIN 0 40 11.258
11/11/2024 05339 CUS0029 Customer 0029 SALES MAIN 0 33 11.225
11/11/2024 05369 CUS0003 Customer 0003 SALES MAIN 0 33 11.192
11/11/2024 05529 CUS0006 Customer 0006 SALES MAIN 0 13 11.179
11/11/2024 05556 CUS0795 Customer 0795 SALES MAIN 0 40 11.139
12/11/2024 05672 CUS0582 Customer 0582 SALES MAIN 0 16 11.123
12/11/2024 05779 CUS0027 Customer 0027 SALES MAIN 0 80 11.043
12/11/2024 05784 CUS0287 Customer 0287 SALES MAIN 0 10 11.033
12/11/2024 05789 CUS0029 Customer 0029 SALES MAIN 0 23 11.010
12/11/2024 05892 CUS0576 Customer 0576 SALES MAIN 0 33 10.977
12/11/2024 05912 CUS0029 Customer 0029 SALES MAIN 0 40 10.937
12/11/2024 05919 CUS0576 Customer 0576 SALES MAIN 0 3 10.934
13/11/2024 06196 CUS0010 Customer 0010 SALES MAIN 0 120 10.814
14/11/2024 06215 CUS0584 Customer 0584 SALES MAIN 0 200 10.614
14/11/2024 06236 CUS0584 Customer 0584 SALES MAIN 0 40 10.574
14/11/2024 06293 CUS0009 Customer 0009 SALES MAIN 0 40 10.534
14/11/2024 06379 CUS0795 Customer 0795 SALES MAIN 0 80 10.454
14/11/2024 06397 CUS0215 Customer 0215 SALES MAIN 0 16 10.438
14/11/2024 06398 CUS0010 Customer 0010 SALES MAIN 0 40 10.398
15/11/2024 06473 CUS0795 Customer 0795 SALES MAIN 0 33 10.365
15/11/2024 06542 CUS0029 Customer 0029 SALES MAIN 0 40 10.325
16/11/2024 00061 CUS0795 Customer 0795 SALES MAIN 0 66 10.259
16/11/2024 00199 CUS0001 Customer 0001 SALES MAIN 0 100 10.159
18/11/2024 00331 CUS0584 Customer 0584 SALES MAIN 0 10 10.149
21/11/2024 01160 CUS0287 Customer 0287 SALES MAIN 0 10 10.139
21/11/2024 01286 CUS0823 Customer 0823 SALES MAIN 0 16 10.123
23/11/2024 01705 CUS0822 Customer 0822 SALES MAIN 0 66 10.057
25/11/2024 01848 CUS0017 Customer 0017 SALES MAIN 0 10 10.047
25/11/2024 01927 CUS0576 Customer 0576 SALES MAIN 0 33 10.014
25/11/2024 01938 CUS0022 Customer 0022 SALES MAIN 0 50 9.964
28/11/2024 02812 CUS0584 Customer 0584 SALES MAIN 0 40 9.924
30/11/2024 03212 CUS0822 Customer 0822 SALES MAIN 0 66 9.858

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.