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.
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 =
where budgetid = 'Your budget ID here'
I just tried it and it will clear the password from the budget.
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.
I always like the team approach!
We really need to keep better hours. 4 am, really?
Always happy to help out.
But it was 10:05 AM for me here in the UK ;)
thank you very much for the solution! it worked like magic. you guys are amazing.
Business Applications communities