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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Convert Vendor Check N...
Microsoft Dynamics GP (Archived)

Convert Vendor Check Name to CAPS

(0) ShareShare
ReportReport
Posted on by Tammy Chavez 820

Is there a quick way to convert the check name in the Vendor cards to ALL CAPS?  Right now they are mixed case.  Wells Fargo requires that the PAYEE NAME be in all caps for Safe Pay.

Version GP 10.

Thank you,

Tammy

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Use SQL statement

    like this:

    Update table set VENDNAME = UPPER(VENDNAME)

  • Tammy Chavez Profile Picture
    Tammy Chavez 820 on at

    Thank you!!  

  • Tammy Chavez Profile Picture
    Tammy Chavez 820 on at

    One more question do I need to run it just against the database or actually select the table where those fields reside?

  • Community Member Profile Picture
    Community Member on at

    Just where the records reside!!!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    I think Francisco was just giving you an example of how to do this, not the actual values for the table and the field to be updated.  To update all the vendor Check Names, run the following against the company database in SQL:

    update PM00200 set VNDCHKNM = UPPER(VNDCHKNM)

    As with any SQL script that will update your data, unless you are 100% confident of what it's going to do (and maybe even then), make a backup and, if possible, try it in a test environment first.

  • Tammy Chavez Profile Picture
    Tammy Chavez 820 on at

    Thank you Victoria.  I figured I needed to put the table name into the script.  We will do this on the test company first.  Thank you all again.  :-)

    Happy Easter!

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans