Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00556
Item Name Product 00556
Current Stock 1.364
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.006 Opening Balance
475 Inbound Qty
117 Outbound Qty
1.364 Closing Balance
Transaction Ledger 12 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 475 0 880
01/11/2024 03418 CUS0584 Customer 0584 SALES MAIN 0 6 874
02/11/2024 03520 CUS0509 Customer 0509 SALES MAIN 0 1 873
07/11/2024 04743 CUS0017 Customer 0017 SALES MAIN 0 3 870
08/11/2024 04955 CUS0108 Customer 0108 SALES MAIN 0 26 844
11/11/2024 05524 CUS0006 Customer 0006 SALES MAIN 0 1 843
13/11/2024 06180 CUS0001 Customer 0001 SALES MAIN 0 1 842
16/11/2024 00028 CUS0005 Customer 0005 SALES MAIN 0 1 841
16/11/2024 00068 CUS0029 Customer 0029 SALES MAIN 0 3 838
18/11/2024 00341 CUS0207 Customer 0207 SALES MAIN 0 6 832
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 3 829
29/11/2024 02834 CUS0029 Customer 0029 SALES MAIN 0 66 763

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.