How do I remove a budget password in Dynamics GP 2010

A client forgot the password for her Dynamics GP budget, here’s a SQL update statement to blank out the password, be sure not to put quotes around the password because it’s not a text field.  It should be run against your company database.

update GL00200
set BUDPWRD = 0x00202020202020202020202020202020
where BUDGETID =’Your budget ID’

After I ran this update statement my client was able to get into her budget just fine.

Here’s where I found the answer:


This entry was posted in Dynamics GP. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *