{"id":21843,"date":"2026-07-23T10:17:46","date_gmt":"2026-07-23T10:17:46","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21843"},"modified":"2026-08-20T07:20:49","modified_gmt":"2026-08-20T07:20:49","slug":"how-does-product-cost-detail-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-product-cost-detail-report-works-in-idempiere\/","title":{"rendered":"How does Product Cost Detail Report works in iDempiere"},"content":{"rendered":"\n

The Product Cost Detail<\/strong> 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.<\/p>\n\n\n\n

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

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • The report retrieves data from the RV_CostDetail<\/strong> report view.<\/li>\n\n\n\n
  • The report combines product, cost detail, accounting schema, and attribute set instance (lot and serial number) information into a single report.<\/li>\n\n\n\n
  • Each record represents a single cost detail transaction for a product, such as a receipt, invoice, inventory movement, production, or project issue.<\/li>\n\n\n\n
  • 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.<\/li>\n\n\n\n
  • 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.<\/li>\n\n\n\n
  • Each record also indicates whether it has been processed and whether it originates from a sales transaction.<\/li>\n\n\n\n
  • The report is read-only and does not create or update cost data.<\/li>\n\n\n\n
  • Based on the available implementation, the report retrieves data directly from the RV_CostDetail<\/strong> report view without using a custom Java process.<\/li>\n<\/ul>\n\n\n\n

    Report Parameters<\/strong><\/h2>\n\n\n\n

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

    \"TenthPlanet-iDempiere-Costing-ProductCostDetail\"<\/figure>\n\n\n\n
    Parameter<\/strong><\/td>Purpose<\/strong><\/td>Filtering Behavior<\/strong><\/td><\/tr><\/thead>
    Accounting Schema<\/td>Selects the accounting schema used for costing.<\/td>Displays cost detail records for the selected accounting schema.<\/td><\/tr>
    Product Category<\/td>Selects the product category.<\/td>Displays cost detail records for products in the selected category.<\/td><\/tr>
    Product<\/td>Selects the product.<\/td>Displays cost detail records for the selected product.<\/td><\/tr>
    Search Key<\/td>Selects the product search key (value).<\/td>Displays cost detail records matching the selected search key.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Report Output<\/strong><\/h2>\n\n\n\n
      \n
    • The Product Cost Detail<\/strong> report displays every individual cost transaction recorded for a product. Each row represents a single cost detail record linked to its source document line.<\/li>\n<\/ul>\n\n\n\n

      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.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-Costing-ProductCostDetail-1\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

      The Product Cost Detail report provides detailed information about individual cost transactions recorded for each product in iDempiere. It displays […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-21843","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=21843"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21843\/revisions"}],"predecessor-version":[{"id":26992,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21843\/revisions\/26992"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}