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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How to change account description for multiple GL accounts?

(0) ShareShare
ReportReport
Posted on by

Hello,

Is there a way for a multiple account description update?   I need to modify description in a few hundred existing accounts.

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    on at

    If you own Integration Manager you can run an update integration.   If not, then a SQL update of GL00105 would also work.

    Warren

  • Community Member Profile Picture
    on at

    Warren, i do have Integration manager, not sure how to create update integration.  Would you be able to help?

    Thanks

  • Community Member Profile Picture
    on at

    Sure, email me at wrpease@peaseconsulting.net

  • Verified answer
    Hossam Fathy Profile Picture
    2,611 on at

    if you know how to use integration manger just change the option to Update instead from Insert.

    if you need more support send me email hossam@crux-kw.com

     

  • Community Member Profile Picture
    on at

    Thanks Hossam, it worked!

  • Hossam Fathy Profile Picture
    2,611 on at

    You Welcome Lenny

  • MichaelJ2 Profile Picture
    265 on at

    Just FYI - The Account Description is not stored in GL00105.  It is in GL00100.ACTDESCR.

  • Community Member Profile Picture
    on at

    Correct in GL00100 not in GL00105.  

    Warren

  • Community Member Profile Picture
    on at

    Thank you all, i was able to do it through integration manager.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans