{"id":20117,"date":"2026-07-08T10:35:09","date_gmt":"2026-07-08T10:35:09","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20117"},"modified":"2026-07-08T11:21:03","modified_gmt":"2026-07-08T11:21:03","slug":"how-to-reprice-a-sales-order-or-invoice-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-reprice-a-sales-order-or-invoice-in-idempiere\/","title":{"rendered":"How to RePrice a Sales Order or Invoice in iDempiere"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

The RePrice Order\/Invoice process updates the prices on an existing Sales Order or Invoice using the latest active Product Prices in the assigned Price List Version.<\/p>\n\n\n\n

It is used when a product price changes after an order was created but before it ships, so the customer is billed at the current rate without recreating the order.<\/p>\n\n\n\n

The process refreshes line prices, discounts, taxes, and the Grand Total automatically, without changing the original Price List, Product Price, or order quantities.<\/p>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only one document, either a Sales Order or an Invoice, can be repriced per execution.<\/li>\n\n\n\n
  • The selected document must remain editable, typically Drafted or Open.<\/li>\n\n\n\n
  • The document must have a valid Price List assigned.<\/li>\n\n\n\n
  • The process uses the latest active Price List Version tied to the document.<\/li>\n\n\n\n
  • All document lines are repriced automatically, along with taxes and totals.<\/li>\n\n\n\n
  • Product Price records themselves are not modified by this process.<\/li>\n\n\n\n
  • Quantities, warehouse, and business partner details remain unchanged.<\/li>\n<\/ul>\n\n\n\n

    Process Flow Diagram<\/strong><\/h2>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Configuration Steps<\/strong><\/h2>\n\n\n\n

    Step 1: Update the Product Price<\/strong><\/h3>\n\n\n\n

    Repricing only has an effect if the Price List Version actually contains a changed price; otherwise the document is recalculated to the same values.<\/p>\n\n\n\n

    Open Price List \u2192 Version \u2192 Product Price for the product, update the Standard Price (or List or Limit Price), then save the record.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Price List Version<\/td>Retail Sales Price List – 2026<\/td>Active version the order’s Price List points to<\/td><\/tr>
    Product<\/td>AASH-ATTA-5KG_Aashirvaad Atta \u2013 5kg<\/td>Product whose price is being updated<\/td><\/tr>
    List Price<\/td>300.00<\/td>Reference price; unchanged in this example<\/td><\/tr>
    Standard Price<\/td>280.00 (was 290.00)<\/td>Selling price used on new order lines and by RePrice<\/td><\/tr>
    Limit Price<\/td>270.00<\/td>Minimum allowed selling price; unchanged in this example<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 2: Select the Document to Reprice<\/strong><\/h3>\n\n\n\n

    The process needs to know exactly one document to recalculate, so only one of Order or Invoice should be filled in.<\/p>\n\n\n\n

    Open RePrice Order\/Invoice, select the Order (or Invoice) to reprice, leave the other field blank, then click Start.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Order<\/td>50009_08\/03\/2026<\/td>Sales Order to be repriced<\/td><\/tr>
    Invoice<\/td>(Blank)<\/td>Left empty when repricing an Order<\/td><\/tr>
    Run as Job<\/td>Unchecked<\/td>Runs the process in the background<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 3: Execute the Process<\/strong><\/h3>\n\n\n\n

    Clicking Start is what actually triggers the recalculation; selecting the document alone does not change any prices.<\/p>\n\n\n\n

    Click Start. The system reads the document’s Price List, retrieves the latest active Price List Version, finds the latest Product Prices, and updates every line.<\/p>\n\n\n\n

    Step 4: Review the Repricing Result<\/strong><\/h3>\n\n\n\n

    The confirmation message shows exactly which document changed and by how much, before you reopen it.<\/p>\n\n\n\n

    Read the result line in the format Document: Previous Grand Total \u2192 Updated Grand Total.<\/p>\n\n\n\n

    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Document<\/td>50009<\/td>Sales Order that was repriced<\/td><\/tr>
    Previous Grand Total<\/td>342.20<\/td>Grand Total before repricing<\/td><\/tr>
    Updated Grand Total<\/td>330.40<\/td>Grand Total after repricing<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Step 5: Verify the Updated Document<\/strong><\/h3>\n\n\n\n

    A final check on the document itself confirms the new price carried through to every affected field, not just the Grand Total.<\/p>\n\n\n\n

    Reopen the Sales Order and check the Order Line tab: Price, Line Amount, Total Lines, and Grand Total should reflect the updated price.<\/p>\n\n\n\n

    Field Reference<\/strong><\/h3>\n\n\n\n
    Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
    Price<\/td>280.00 (was 290.00)<\/td>Updated line price from the Price List Version<\/td><\/tr>
    Total Lines<\/td>280.00 (was 290.00)<\/td>Sum of line amounts before tax<\/td><\/tr>
    Grand Total<\/td>330.40 (was 342.20)<\/td>Total including tax after repricing<\/td><\/tr>
    Note: <\/strong>Quantity, Warehouse, and Business Partner on the order are unchanged; only price-related fields are refreshed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/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>
    No change after repricing<\/td>Latest Price List Version does not contain an updated Product Price<\/td>Verify the Product Price was actually changed in the active Price List Version<\/td><\/tr>
    Order not available for selection<\/td>Order does not exist, or is no longer eligible for modification<\/td>Confirm the Order exists and is still Drafted or Open<\/td><\/tr>
    Invoice not available for selection<\/td>Invoice status restricts editing<\/td>Verify the Invoice is valid and not Completed or Closed<\/td><\/tr>
    Price remains unchanged<\/td>Product Price edit was not saved before running the process<\/td>Save the Product Price change, then rerun RePrice Order\/Invoice<\/td><\/tr>
    Incorrect totals after repricing<\/td>Tax, discount, or Price List assignment misconfigured<\/td>Review Product Prices, Taxes, Discounts, and the Price List assignment<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Next Steps<\/strong><\/h2>\n\n\n\n
      \n
    • Complete the Sales Order.<\/li>\n\n\n\n
    • Generate the Shipment.<\/li>\n\n\n\n
    • Generate the Customer Invoice.<\/li>\n\n\n\n
    • Process the Customer Payment.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      Introduction The RePrice Order\/Invoice process updates the prices on an existing Sales Order or Invoice using the latest active Product […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[67,76],"tags":[],"class_list":["post-20117","post","type-post","status-publish","format-standard","hentry","category-retail","category-sales"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20117","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=20117"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20117\/revisions"}],"predecessor-version":[{"id":20141,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20117\/revisions\/20141"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}