{"id":20698,"date":"2026-07-15T11:26:01","date_gmt":"2026-07-15T11:26:01","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20698"},"modified":"2026-08-20T07:06:13","modified_gmt":"2026-08-20T07:06:13","slug":"how-to-use-standard-cost-update-process-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-use-standard-cost-update-process-in-idempiere\/","title":{"rendered":"How to use Standard Cost Update process in iDempiere"},"content":{"rendered":"\n

The Standard Cost Update process in iDempiere recalculates the standard and future cost price of products, grouped by Product Category, for the Cost Type defined in the Accounting Schema.<\/p>\n\n\n\n

It is used in Material Management and Costing operations whenever a business revises product costs, such as after a purchase cycle, a costing method migration, or a periodic cost revaluation.<\/p>\n\n\n\n

Running this process updates the M_Cost records used for inventory valuation, cost of goods sold, and margin reporting, and can generate an Inventory Cost Adjustment document to post the cost variance to the General Ledger.<\/p>\n\n\n\n

Process Flow Diagram<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Accounting-StandardCostUpdate-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Standard Cost Update recalculates cost only for the Cost Type of the active Accounting Schema.<\/li>\n\n\n\n
  • Document Type is mandatory whenever Set Standard Cost to has a value.<\/li>\n\n\n\n
  • Pricelist Version is mandatory only if Price List Limit is chosen as the cost source.<\/li>\n\n\n\n
  • If Costing Level is set to Tenant (Client), missing M_Cost records are created automatically.<\/li>\n\n\n\n
  • Historical cost options calculate cost from the accumulated amount and quantity of that method.<\/li>\n\n\n\n
  • Standard cost changes generate an Inventory Cost Adjustment document instead of a direct update.<\/li>\n\n\n\n
  • Product Category filter limits the process to products in that category; blank processes all products.<\/li>\n\n\n\n
  • A zero-value calculated cost does not overwrite the existing cost record.<\/li>\n\n\n\n
  • Run as Job allows the process to execute in the background without blocking the user session.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Accounting Schema configured with a valid Costing Method and Cost Type.<\/li>\n\n\n\n
    • Cost Element defined for Standard Costing on the Material Cost Element type.<\/li>\n\n\n\n
    • Products assigned to the Product Category to be processed (if filtering by category).<\/li>\n\n\n\n
    • Document Type configured for Inventory Cost Adjustment (required for standard cost changes).<\/li>\n\n\n\n
    • Price List Version configured, if Price List Limit is used as a cost source.<\/li>\n\n\n\n
    • Existing cost basis available (Average Invoice, Average PO, FIFO, LIFO, or Last Price) for the chosen source method.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Performance Analysis and Accounting \u2192 Costing \u2192 Standard Cost Update<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-StandardCostUpdate-1\"<\/figure>\n\n\n\n

      The window can also be reached directly through the global Search bar by typing “Standard Cost Update”. It opens as a process parameter screen with fields for Product Category, Set Standard Cost to, Set Future Costs to, Pricelist Version, Document Type, and a Run as Job checkbox, followed by OK and Cancel actions.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-StandardCostUpdate-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select the Product Category<\/strong><\/h3>\n\n\n\n
      Limits the recalculation to products in a single category, avoiding an unnecessary full-catalog update.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Open the Product Category field and select a category, such as Finished Goods. Leave blank to process every product in the tenant.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Product Category<\/td>Finished Goods<\/td>Filters the products included in the cost update.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Define Set Standard Cost to<\/strong><\/h3>\n\n\n\n
      Determines the source used to calculate the new Standard Cost price for the selected products.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Select a costing source, for example Average Invoice or Average PO History. Leave blank if only the Future Cost is being updated.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Set Standard Cost to<\/td>Average PO History<\/td>Source used to compute the new standard cost.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Define Set Future Costs to<\/strong><\/h3>\n\n\n\n
      Sets a planned future cost price, typically used for budgeting the next cost cycle without changing the current standard cost.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Select a source such as Last PO Price or Price List Limit. This field can be used independently of Set Standard Cost to.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Set Future Costs to<\/td>Last PO Price<\/td>Source used to compute the future cost price.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Select the Pricelist Version<\/strong><\/h3>\n\n\n\n
      Required only when Price List Limit is chosen as a cost source, since the cost is read from the price list limit price.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Choose the applicable Pricelist Version. Skip this field if neither cost source uses Price List Limit.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Pricelist Version<\/td>Standard 2026 Purchase<\/td>Price list version used to read the price limit.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 5: Select the Document Type<\/strong><\/h3>\n\n\n\n
      Required whenever Set Standard Cost to is populated, because the process posts the cost change through an Inventory Cost Adjustment document.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Select the Document Type configured for Inventory Cost Adjustment. This document is created and completed automatically by the process.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Document Type<\/td>Inventory Cost Adjustment<\/td>Document type used to post the standard cost change.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 6: Enable Run as Job (Optional)<\/strong><\/h3>\n\n\n\n
      Runs the recalculation as a background job, useful when processing a large product category without holding the user session.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Check Run as Job to queue the process in the background, or leave unchecked to run and view results immediately.<\/p>\n\n\n\n
      Step 7: Execute the Process<\/strong><\/h3>\n\n\n\n
      Runs the cost recalculation and, where applicable, posts the Inventory Cost Adjustment document.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Review the selected parameters and click OK. The process log shows the count of cost records updated and any document created.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-StandardCostUpdate-3\"<\/figure>\n\n\n\n
      Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
      Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
      “Fill Mandatory C_DocType_ID” error on OK<\/td>Document Type left blank while Set Standard Cost to has a value.<\/td>Select a Document Type configured for Inventory Cost Adjustment.<\/td><\/tr>
      “Fill Mandatory M_PriceList_Version_ID” error<\/td>Price List Limit chosen as a source without a Pricelist Version.<\/td>Select the Pricelist Version before running the process.<\/td><\/tr>
      “CostElement not found” error<\/td>The chosen costing method has no Cost Element defined for the tenant.<\/td>Create the missing Cost Element under Costing setup, then rerun.<\/td><\/tr>
      Process completes but shows #0 updated<\/td>No M_Cost records matched the Product Category or Cost Type filter.<\/td>Verify the category filter and confirm products have existing cost records.<\/td><\/tr>
      Standard cost value unchanged after running<\/td>Calculated cost equals zero, so the existing cost record is not overwritten.<\/td>Check that the source method (e.g. Average Invoice) has a valid non-zero cost.<\/td><\/tr>
      Inventory Cost Adjustment fails to complete<\/td>Accounting period is closed or Document Type sequence is misconfigured.<\/td>Open the relevant period and verify the Document Type setup, then rerun.<\/td><\/tr>
      New products missing cost records after update<\/td>Costing Level on the Accounting Schema is not set to Tenant (Client).<\/td>Set Costing Level to Client if tenant-wide cost records are required.<\/td><\/tr>
      Process runs but no cost adjustment document appears<\/td>Only Set Future Costs to was used, which does not require a document.<\/td>This is expected; future cost updates do not post accounting entries.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Review updated values in the Product Costs window.<\/li>\n\n\n\n
      • Verify posted entries in the Cost Adjustment window, if a document was created.<\/li>\n\n\n\n
      • Confirm Cost Element and Costing Method setup under the Accounting Schema.<\/li>\n\n\n\n
      • Check the Pricelist Version if Price List Limit is used as a recurring cost source.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        The Standard Cost Update process in iDempiere recalculates the standard and future cost price of products, grouped by Product Category, […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20698","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20698","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=20698"}],"version-history":[{"count":4,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20698\/revisions"}],"predecessor-version":[{"id":27784,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20698\/revisions\/27784"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}