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

Question Status

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

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
Leslie Vail responded on 4 Jan 2012 1:54 AM

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
Leslie Vail responded on 4 Jan 2012 2:01 AM

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

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
Leslie Vail responded on 4 Jan 2012 3:33 AM

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

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
Leslie Vail responded on 4 Jan 2012 1:54 AM

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