How does Product Cost Detail Report works in iDempiere

The Product Cost Detail report provides detailed information about individual cost transactions recorded for each product in iDempiere. It displays the cost movements that build up a product’s cost, including receipts, invoices, inventory movements, production, and project issues.

The report is mainly used by Cost Accountants, Finance, and Inventory Management teams to trace how a product’s cost was built up transaction by transaction, and to verify individual cost movements.

Business Rules

• The report retrieves data from the RV_CostDetail report view.
• The report combines product, cost detail, accounting schema, and attribute set instance (lot and serial number) information into a single report.
• Each record represents a single cost detail transaction for a product, such as a receipt, invoice, inventory movement, production, or project issue.
• Cost detail records are linked to the corresponding source document line, such as a shipment/receipt line, invoice line, order line, project issue, inventory line, movement line, production line, or cost collector.
• The report displays the transaction amount, transaction quantity, cumulated amount, cumulated quantity, current cost price, current quantity, delta amount, and delta quantity for each cost detail record.
• Each record also indicates whether it has been processed and whether it originates from a sales transaction.
• 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_CostDetail report view without using a custom Java process.

Report Parameters

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

Report Output

• The Product Cost Detail report displays every individual cost transaction recorded for a product. Each row represents a single cost detail record linked to its source document line.

The report includes the product, accounting schema, transaction amount, transaction quantity, cumulated amount, cumulated quantity, current cost price, current quantity, delta amount, delta quantity, lot/serial number, and other related costing details. It helps users trace how each cost movement contributed to a product’s overall cost.