Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Purchase Order Workflow based on Purchase Agreement

(0) ShareShare
ReportReport
Posted on by 52

I have created a purchase agreement for specific vendor with specific items. Purchase Agreement is confirmed and is effective.

When creating purchase requisition having multiple line items, the items having effective purchase agreement get vendor, price and quantity information inherited from relevant agreement.

I have set the policy of Auto Purchase order creation from requisition & also set the parameter to keep the status of purchase orders generated from requisition to "Draft" status.

Requisition lines with reference to agreement or to which vendor have been added manually get their PO autogenerated.

Workflow

Workflow have been configured having a Approval with Automatic Action based on condition: "Purchase orders.Agreement header record ID" is field "Purchase orders.Agreement header record ID"

If condition is met then PO should get auto approved.

Otherwise, it should be submitted to the approval stage assigned user/role.

Issue:

Purchase orders with agreement reference do not get approved when submitted to workflow.

There is a column in Purchtable (All purchase orders grid) with the name "Purchase agreement". This column has a check mark against the orders having link to purchase agreement. its control name is "AgreementIsLinked" but it cannot be called in workflow condition.

Is there any other field I can use in workflow to get automatic action approve the PO when having effective purchase agreement reference.

pastedimage1639486815308v1.png 

  • D365FOAdvancedUser Profile Picture
    20 on at
    RE: Purchase Order Workflow based on Purchase Agreement

    Hi Talha

    Did you manage to find a solution for it?

    Some of the fields, Workflow conditional evaluation does not allow to check for blank records.

    It has to put an exact value in condition.

  • Talha1651 Profile Picture
    52 on at
    RE: Purchase Order Workflow based on Purchase Agreement

    Hello Andre`,

    Thanks for your feedback.

    The value for the selected field in the workflow is shown as:

    pastedimage1639637099401v1.png

    It shows value columns for :

    • Status (Effective/Hold)
    • Document Title
    • Name (i.e. the agreement type for e.g. Inventory, Non Inventory Etc.)
    • Name (i.e. the user who created the agreement)

    When I select any value from the list it gets the data for condition in combination. For e.g. "Effective Non Inventory User Name"

    I want my workflow to get auto approved if has reference to Purchase Agreement. 

    In purchase requisition lines purchase agreement reference is present, but same filed is not available on PO line or Header.

    Further, In workflow conditions, the only condition with reference to purchase agreement is the one I am trying to use. Correct me if I am wrong.   

  • André Arnaud de Calavon Profile Picture
    293,272 Super User 2025 Season 1 on at
    RE: Purchase Order Workflow based on Purchase Agreement

    Hi Talha,

    You are evaluating the value of a field with it's own value. You can try to change it and evaluate if the value is empty or not.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,272 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,931 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans