How Physical Inventory Works in iDempiere

The Physical Inventory window in iDempiere enables businesses to perform stock counts and reconcile actual inventory levels with the system’s book quantities. It is used when you want to validate, correct, or adjust inventory counts based on a physical audit of products in a warehouse.

Physical Inventory Setup

To begin, you define a Physical Inventory document, selecting the appropriate Warehouse, Movement Date, and Document Type. This document serves as the framework for your stock count. You can also link the count with a Project or Activity if needed for cost tracking.

Inventory Count List

You can automatically generate count lines based on the currently stored products in the warehouse. When this option is used, iDempiere retrieves all stocked products for the location and creates count lines for them. Alternatively, you may create or edit count lines manually if only a subset of products is being counted.

Each Inventory Count Line includes:

• The Product
• The Locator (warehouse location)
• The Book Quantity (the system’s quantity)
• The Counted Quantity (the physical count)

Record Count Results

Warehouse staff or auditors enter the Counted Quantity for each product. The Book Quantity is shown alongside the count, allowing for a direct comparison between what the system believes is on hand and what is physically present. Users can also assign an Inventory Type or Charge to account for differences transparently.

Process Inventory Count

Once all quantities are counted and recorded, the inventory count needs to be processed. This updates the system’s stock levels based on the difference between the Book Quantity and the Counted Quantity. When processed:

• If the counted quantity is higher than the book quantity, the system increases the on-hand stock.
• If the counted quantity is lower, the system decreases the on-hand stock.

This reconciliation ensures that your ERP’s inventory records reflect the physical reality.

Accounting and Audit Trail

Physical Inventory adjustments generate inventory transactions that may lead to accounting differences if the Inventory Type or Charge indicates a cost adjustment (e.g., loss, internal use). These changes are traceable and auditable through linked transactions and inventory history.

In iDempiere, the Physical Inventory provides a structured method for performing stock counts and reconciling those counts with system quantities. Users define an inventory count document, generate or enter count lines, capture physical counts, and then process the count to update inventory. This ensures operational and financial inventory accuracy.