How does Product Cost Report works in iDempiere

The Product Cost report provides detailed information about product costing records maintained in iDempiere. It displays the current and future cost prices for each product, broken down by accounting schema, cost type, and cost element.

The report is mainly used by Cost Accountants, Finance, and Inventory Management teams to review product costs, verify costing methods, and analyze cost movements across accounting schemas.

Business Rules

• The report retrieves data from the RV_Cost report view.
• The report combines product, cost element, cost type, and accounting schema information into a single report.
• Each record represents the cost of a single product for a specific accounting schema and cost element.
• Cost records are linked to the corresponding product category, search key, and cost type.
• The report displays current cost price, future cost price, cumulated amount, cumulated quantity, and cost-frozen status for each product.
• The report is read-only and does not create or update cost data.
• Based on the available implementation, the report retrieves data directly from the RV_Cost report view without using a custom Java process.

Report Parameters

Product Cost – Parameter window

The Product Cost parameter window allows users to filter cost records before generating the report. Users can select Accounting Schema, Cost Type, Product Category, Product, Search Key, and Cost Element to display only the cost records that match the selected criteria.

Parameter	Purpose	Filtering Behavior
Accounting Schema	Selects the accounting schema used for costing.	Displays cost records for the selected accounting schema.
Cost Type	Selects the cost type definition.	Displays cost records for the selected cost type.
Product Category	Selects the product category.	Displays cost records for products in the selected category.
Product	Selects the product.	Displays cost records for the selected product.
Search Key	Selects the product search key (value).	Displays cost records matching the selected search key.
Cost Element	Selects the cost element, such as material or overhead.	Displays cost records for the selected cost element.

Report Output

• The Product Cost report displays detailed cost information for each product included in a cost record. Each row represents the cost of a single product for a specific accounting schema and cost element.

The report includes the product, cost type, cost element, accounting schema, current cost price, future cost price, cumulated amount, cumulated quantity, and other related costing details. It helps users verify product costs and understand how each cost value was derived.