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
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!
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.
Just where the records reside!!!
One more question do I need to run it just against the database or actually select the table where those fields reside?
Thank you!!
Use SQL statement
like this:
Update table set VENDNAME = UPPER(VENDNAME)
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
