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:
http://community.dynamics.com/gp/f/32/p/70117/128092.aspx
