Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02764
Item Name Product 02764
Current Stock 2.276
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.853 Opening Balance
634 Inbound Qty
211 Outbound Qty
2.276 Closing Balance
Transaction Ledger 24 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 634 0 1.765
01/11/2024 03345 CUS0822 Customer 0822 SALES MAIN 0 33 1.732
02/11/2024 03504 CUS0006 Customer 0006 SALES MAIN 0 1 1.731
02/11/2024 03573 CUS0630 Customer 0630 SALES MAIN 0 16 1.715
04/11/2024 03600 CUS0576 Customer 0576 SALES MAIN 0 6 1.709
04/11/2024 03787 CUS0795 Customer 0795 SALES MAIN 0 6 1.703
05/11/2024 04084 CUS0784 Customer 0784 SALES MAIN 0 26 1.677
05/11/2024 04209 CUS0611 Customer 0611 SALES MAIN 0 1 1.676
06/11/2024 04306 CUS0029 Customer 0029 SALES MAIN 0 20 1.656
06/11/2024 04507 CUS0611 Customer 0611 SALES MAIN 0 3 1.653
07/11/2024 04573 CUS0611 Customer 0611 SALES MAIN 0 13 1.640
08/11/2024 05026 CUS0611 Customer 0611 SALES MAIN 0 3 1.637
11/11/2024 05575 CUS0611 Customer 0611 SALES MAIN 0 10 1.627
12/11/2024 05597 CUS0822 Customer 0822 SALES MAIN 0 6 1.621
13/11/2024 05960 CUS0006 Customer 0006 SALES MAIN 0 6 1.615
13/11/2024 06162 CUS0017 Customer 0017 SALES MAIN 0 10 1.605
13/11/2024 06164 CUS0630 Customer 0630 SALES MAIN 0 13 1.592
14/11/2024 06304 CUS0611 Customer 0611 SALES MAIN 0 5 1.587
15/11/2024 06706 CUS0630 Customer 0630 SALES MAIN 0 3 1.584
18/11/2024 00234 CUS0006 Customer 0006 SALES MAIN 0 3 1.581
21/11/2024 01235 CUS0822 Customer 0822 SALES MAIN 0 3 1.578
23/11/2024 01710 CUS0630 Customer 0630 SALES MAIN 0 10 1.568
25/11/2024 01867 CUS0611 Customer 0611 SALES MAIN 0 1 1.567
29/11/2024 02920 CUS0630 Customer 0630 SALES MAIN 0 13 1.554

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.