Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Insert new field in purchase order workflow

Posted on by 385

Hello,

We need prepayment field in purchase order workflow condition as by default GP does not allow so can someone help me to insert additionnal field in purchase order workflow condition editor.

Thanks

Categories:
  • Verified answer
    RE: Insert new field in purchase order workflow

    By default, there won't be, you must add it, save changes and then login to GP.

    Then, when you click the lookup for the workflow step condition, besides the Condition tab you're normally seeing, there will be other tabs where you can add pretty much any table/column to use in the workflow condition, see the statement created and execute it to make sure it is valid.

    Note, that this is considered a customization of Dynamics GP including any changes made via this extended condition editor, that isn't default.

    Thanks

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Insert new field in purchase order workflow

    Hello Derek,

    Sorry for the delay reply.

    There is no such key words available "QueryDesignerAllFunctionality=TRUE" in my dex.ini file

  • Suggested answer
    RE: Insert new field in purchase order workflow

    QueryDesignerAllFunctionality=TRUE in Dex.ini is what you'll need to expand the Workflow condition Editor window.

    this will add a tab where you can mark to join pretty much any table/field to be a workflow condition option.

    It isn't a completely supported option, but it is there and many customers have used it, even in newer versions like 18.x.

  • Jozy Profile Picture
    Jozy 385 on at
    RE: Insert new field in purchase order workflow

    May be. But it does not have same steps in GP2018 as I am using GP2018.

  • Suggested answer
    RE: Insert new field in purchase order workflow

    Is this what you're looking for?

    community.dynamics.com/.../joining-in-additional-tables-for-workflow-conditions

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans