web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)
Suggested answer

Delta Change Parameter on Purchase Order Workflows

(0) ShareShare
ReportReport
Posted on by

We have a purchase order workflow set up in our environment and we needed to add a parameter to account for when somebody made a change to a purchase order that has already been approved. As an example, if delivery date changed on a PO, we didn't want to have to wait for reapproval in order to continue with the purchasing process; so we added an auto-approval step with the parameter that if the "Delta amount" was less than $15,000, to automatically approve that workflow. This has worked great for approving our POs with less than $15,000 changed. Unfortunately, it is also automatically approving all purchase orders where the total purchase order amount is less than $15,000. Is there some parameter I can add where this delta amount decision would only auto-approve orders that had already been approved once? Any help would be appreciated.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    298,643 Super User 2025 Season 2 on at
    RE: Delta Change Parameter on Purchase Order Workflows

    Hi stennant,

    Glad it solved your issue. Would you mind to mark correct answers? Then the thread will get the status answered and other people know which answers were verified.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Delta Change Parameter on Purchase Order Workflows

    Andre: This did the trick! Thanks for the tip.

  • Suggested answer
    syed baber Profile Picture
    11,633 on at
    RE: Delta Change Parameter on Purchase Order Workflows

    Hi Stennant,

    How are you calculating the Delta amount field? Are you calculating it based on the last approved version of Purchase order workflow? The PurchTableVersion and PurchTableHistory tables contains all the approved and confirmed purchase orders, so if you calculate the Delta invoice amount field based on the these tables and there is also an another table PurchLineHistory, I think you could prevent auto approving the purchase order when it is created for the first time and invoice amount is less than 15000.

    Please verify and let me know if you have further queries.

    Thanks,

    Baber.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    298,643 Super User 2025 Season 2 on at
    RE: Delta Change Parameter on Purchase Order Workflows

    Hi Stennant,

    In the condition you can add an evaluation on the field "Purchase orders.Previous version exists". This has the value 'yes' if it has been approved before.

  • Community Member Profile Picture
    on at
    RE: Delta Change Parameter on Purchase Order Workflows

    Ram K,

    Here you go:

    Community-2.jpg

    Community-2.jpg

    Community-3.jpg

  • RamK Profile Picture
    2,580 on at
    RE: Delta Change Parameter on Purchase Order Workflows

    Can you please provide a screen shot of your workflow (especially, condition where you have defined $ 15,000)...?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Rahul Shah Profile Picture

Rahul Shah 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans