SBX - Search With Button

SBX - Forum Post Title

how do i remove password on the budget in GP10? user forgot the password.

Microsoft Dynamics GP Forum

James Anthony asked a question on 3 Jan 2012 10:11 PM

Question Status

Verified

we have our budget locked with a password and apparently the Finance manager forgot the password that they used and now we cant open it up.

Reply
Verified Answer

James,

I'm not where I can test this, but using SQL you can usually blank out the password using a script like this:

update gl00200 set budpwrd =

0x00202020202020202020202020202020

where budgetid = 'Your budget ID here'

kind regards,

Leslie

Reply

James,

I just tried it and it will clear the password from the budget.

Kind regards,

Leslie

Reply
Ian Grieve responded on 4 Jan 2012 2:05 AM
My Badges

Leslie's script works fine for removing the password.

Edit: I should have refreshed before posting as I see Leslie has been able to confirm it works.

Reply

Ian,

I always like the team approach!

We really need to keep better hours. 4 am, really?

Kind regards,

Leslie

Reply
Ian Grieve responded on 4 Jan 2012 3:49 AM
My Badges

Hi Leslie,

Always happy to help out.

But it was 10:05 AM for me here in the UK ;)

Ian

Reply
James Anthony responded on 10 Jan 2012 4:00 AM

Hi Leslie

thank you very much for the solution! it worked like magic. you guys are amazing.

Reply
Verified Answer

James,

I'm not where I can test this, but using SQL you can usually blank out the password using a script like this:

update gl00200 set budpwrd =

0x00202020202020202020202020202020

where budgetid = 'Your budget ID here'

kind regards,

Leslie

Reply

SBX - Two Col Forum

SBX - Migrated JS