• LinkedIn
  • Facebook
  • Twitter
  • Instagram
  • Invoice Payment Details
1-844-OPALBIZ
Opal Biz
  • Security
    • SAFEGUARD SECURITY
      • Security Risk Assessment
      • Unified Threat Management
      • Microsoft Sentinel
      • Security Information & Event Management (SIEM)
  • Business Applications
    • MICROSOFT DYNAMICS
      • Dynamics GP
        • GP Enhancement Package
        • AP Automation
      • Dynamics 365
        • Sales
        • Customer Service
        • Field Service
        • Business Central
          • AP Automation
      • Multi-Entity Management
      • CSP Licensing
    • POWER PLATFORM
      • Power BI
        • ConnectWise Power BI Reporting
      • Power Apps
      • Power Automate
    • OPAL PRODUCTS
      • SAP Concur Connector
      • BlackLine Connector
      • Vena Connector
  • Modern Workplace
    • CLOUD SOLUTIONS
      • Microsoft 365
        • Opal 365 Administration
      • Microsoft Teams
      • SharePoint
      • SQL Server
  • Azure Cloud
    • Azure
  • Resources
    • RESOURCES
      • Blog
      • Videos
      • Pay Invoice
    • COMPANY
      • About Us
      • Microsoft Gold Partner
      • Careers
      • Meet the Opal Team
      • Contact Us
    • OUR APPROACH
      • Modern MSP
      • Client Services
      • Implementation Services
      • Consulting
  • Free Assessment
  • Menu

Adding Fields to Workflow Emails

Dynamics GP, Microsoft

We are frequently asked if the Purchasing Requisition and Purchase Order workflow email can include the account number description. This is just one example, but a similar strategy could be used for adding other fields to the workflow emails.

 

I took the following snapshot before adjusting.

Then I ran the following statements in the live database.

The first adds the value to the Available Fields, while the second adds a join to the GL00100 table for the statement to build the script that would pull the Account Description.

I then closed the workflow and re-opened, we can now see the new Account Description field.

Due to a bug, I removed the items on the right and re-added them in order, which included the Line Account Description at the end.  I then saved and re-opened and the fields are present.

August 2, 2016/by Emma
Tags: Account number Description, Adding Fields to Workflow Emails, Dynamics GP, Pruchasing Requisition and Purchase Order Workflow Email
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
  • Share on Reddit
  • Share by Mail
https://opalbiz.com/wp-content/uploads/2016/08/newaccount-1.jpg 452 380 Emma https://opalbiz.com/wp-content/uploads/2019/05/opal_blue.png Emma2016-08-02 13:21:482016-08-02 13:21:48Adding Fields to Workflow Emails
You might also like
dynamicsgp Financial Reporting for Non-profit Organizations with Dynamics GP
dynamicsgp Management Reporter Web Viewer Prints Only One Page
dynamicsgp Dynamics GP: Deduction in Arrears – Hourly vs. Salary
dynamicsgp Migrating Management Reporter Database to New SQL Server
Excel Financial Dashboard GP Refreshable Excel Reports
dynamicsgp PLEASE NOTE-- GP 2010

Recent Posts

  • Resolve Microsoft Dynamics GP Temp Table Errors
  • Solve Microsoft Dynamics GP Connectivity Issues
  • Track Traction EOS Metrics in Power BI – Part 2
  • ConnectWise Power Automate WebHook Callback
  • Update the Work Center Calendar in Business Central

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • September 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • May 2017
  • February 2017
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • September 2015
  • August 2015
  • August 2014
  • July 2014
  • May 2014
  • February 2014
  • December 2013
  • February 2013
  • January 2013
  • August 2012
  • May 2012
  • February 2011

Mission Statement

Our mission at Opal is to be an extension of our customers, lending our team of dedicated professionals to provide efficient cost-effective business solutions using existing technology.

Opal Pittsburgh

608 E McMurray Rd Suite b1
McMurray, PA 15317

sales@opalbiz.com

Opal Tampa

8050 Old County Road 54
New Port Richey, FL 34653

sales@opalbiz.com

Latest Blog

  • Resolve Microsoft Dynamics GP Temp Table Errors
  • Solve Microsoft Dynamics GP Connectivity Issues
  • Track Traction EOS Metrics in Power BI – Part 2
  • ConnectWise Power Automate WebHook Callback
  • Update the Work Center Calendar in Business Central
© 2022 Opal Business Solutions
Growing globally with landed cost automation GP Workflow Tip!
Scroll to top