Skip to main content
Question

Recalculate Price/Currency in workflow

  • February 23, 2026
  • 2 replies
  • 20 views
C
Do Gooder (Partner)
Forum|alt.badge.img+1

I’m currently creating a workflow to update a price on a Customer Order Line as well as Purchase Order Line. The scenario is internal trade, where my trigger is state of Customer Order changes to “Delivered”.

Then, I want to update my BaseUnitPrice on the COL with the Cost from the same COL. However, before patching the COL, I need to recalculate my price and currency to correctly update all prices on the COL.

However, in DevTools I can see that manual edit and the command “Recalculate Price/Currency” both use the ValidateBaseSaleUnitPrice to calculate prices. My problem is that workflow doesn’t support this call as it contains ValidationRec, which is an array, as an input parameter.

So, does anybody know how to recalculate my prices prior to patch in a workflow?

    2 replies

    Guzik
    Hero (Customer)
    Forum|alt.badge.img+5
    • Guzik
    • Hero (Customer)
    • March 16, 2026

    hi ​@CeciliePAndersen ,

    I was facing the same problem and finally find the way to query for valid record in the price list.

    I attached the ready workflow. The main logic is as follow:

    check valid price list of a customer

    look for the price in price list lines that valid from is less or equal to todays date and return one row only ($top=1)

     

    That step returns collection which needs to be extracted by a loop/subprocess:

     

     

    the second condition was to test it on one site and for one customer, so please adjust it for your environment:

     

     

     

     

    the first part of the script is from the standard examples and prevents constant loop

     

     

     

    regards,

     

    Kajetan

     

     

      C
      Do Gooder (Partner)
      Forum|alt.badge.img+1

      Hi Kajetan,

      It doesn’t solve my issue unfortunately.

      As we’re moving cost to the BaseSaleUnitPrice, upon doing that, I need to trigger the IFS Price calculation ValidateBaseSaleUnitPrice to calculate all related prices based on the cost - I know my price, I don’t need to collect it - but I need to calculate all correlated prices.

      But other wise thank you for the answer.

      Best regards,

      Cecilie

      Terms & ConditionsCookie settingsAccessibility statement