500
I am wanting to change all the account descriptions in GP Dynamics, simplifying the names so other users can identify accounts easier.
Ran a test of this in SQL in a test environment and seems successful,
Update GL00100 (Financial Account Master Table)
Set ACTDESCR='newname' where ACTINDX='x'
Would this be all to change the account descriptions correctly?
*This post is locked for comments
In future, If you want to create your new account descriptions from GL account segment descriptions, you need to update the segment descriptions to the table GL40200 as Richard suggested. Otherwise your above query is enough for updating account descriptions.
Hope this helps!!!
If you use GL account segment descriptions to build your account descriptions you may want to pay attention to the GL40200 table as well.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
