Recalculate price on existing purchase orders

  • Recalculate price on existing purchase orders

    Posted by Zvika Rimalt on November 4, 2018 at 5:40 pm
    • Zvika Rimalt

      Member

      November 4, 2018 at 5:40 PM

      We are using D365FO
      We have a bunch of purchase orders that were created, and unit prices entered with incorrect amounts.
      later on the product default pricing and trade agreement have been updated in the system

      Is there a way to trigger re-calculation of the unit pricing on all these existing purchase orders?
      We are trying to avoid having to manually re-create all of them.Ā 

      #UnifiedOperations
      #Functional

      ??

      ——————————
      Zvika Rimalt
      Functional Consultant
      Vancouver BC
      ——————————

    • Kaj Schougaard

      Member

      November 5, 2018 at 4:44 AM

      The same issue for sales orders would also be relevant.

      ——————————
      Kaj Schougaard
      AX consultant
      Danish Agro
      Galten, Denmark
      ——————————
      ——————————————-

    • Ryan Sorenson

      Member

      November 5, 2018 at 2:33 PM

      I’m not aware of a way to update all the prices on all the lines.Ā  But if the PO lines do have to be recreated, instead of doing it manually you could export the ‘Purchase order lines V2’ data entity for all the POs.Ā  Then delete the PO lines and reimport using the file that you exported, leaving the price field off the file, so the system will calculate the price.

      ——————————
      Ryan Sorenson
      Sunrise Technologies
      Riverton UT
      ——————————
      ——————————————-

    • Barr Snyderwine

      Member

      November 6, 2018 at 8:48 AM

      I have seen need for this over the years for both SO and PO, most software vendors have resisted due to the danger of updating already confirmed PO’s and SO’s that a vendor or customer already has.Ā 
      The requirement would need to have a selection criteria, confirmation of updates and safeguards to not update already confirmed SO and PO.

      ——————————
      Barr Snyderwine
      Business Solution Architect
      Avanade
      Middletown MD
      ——————————
      ——————————————-

    Zvika Rimalt replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Recalculate price on existing purchase orders’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!