How does Product Cost Summary Report works in iDempiere
The Product Cost Summary report provides a summarized view of product costing in iDempiere. For each product, it displays the total current cost price and total future cost price, aggregated by accounting schema and cost type.
The report is mainly used by Cost Accountants, Finance, and Management teams to get a quick, high-level view of each product’s overall costing position without reviewing individual cost transactions.
Business Rules
- The report retrieves data from the RV_CostSummary report view.
- The report combines product and accounting schema information into a single summarized report.
- Each record represents the aggregated cost of a single product for a specific accounting schema and cost type.
- The report only includes cost records where the cost type matches the cost type assigned to the accounting schema, so each product appears once per accounting schema.
- The report displays the total current cost price and total future cost price for each product, summed across matching cost records.
- 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_CostSummary report view without using a custom Java process.
Report Parameters
Product Cost Summary – Parameter window
The Product Cost Summary parameter window allows users to filter cost summary records before generating the report. Users can select Accounting Schema, Product Category, Product, and Search Key to display only the cost summary records that match the selected criteria.
| Parameter | Purpose | Filtering Behavior |
| Accounting Schema | Selects the accounting schema used for costing. | Displays cost summary records for the selected accounting schema. |
| Product Category | Selects the product category. | Displays cost summary records for products in the selected category. |
| Product | Selects the product. | Displays cost summary records for the selected product. |
| Search Key | Selects the product search key (value). | Displays cost summary records matching the selected search key. |
Report Output
- The Product Cost Summary report displays one summarized cost row per product per accounting schema. Each row aggregates the cost records for that product into a single total.
The report includes the product, product category, accounting schema, cost type, total current cost price, and total future cost price. It helps users quickly review each product’s overall costing position across accounting schemas without drilling into individual transactions.
