Authorized GL Accounts

[gregfallon1]

Is there a way or SQL code to give a user access to all GL accounts vs. using the UserGLAccounts.php page.

[TimSchofield]

Hi Greg, by default a new user should have access to all GL accounts. If this has been changed and you want to revert a user to all, then:

UPDATE glaccountusers SET canview=1 AND canupd=1 WHERE userid="xxxxxxx";

substituting the real userid for the xxxxxxx

Thanks
Tim