Changing the Owner on Smart Notes

If you need to change the account that owns smart notes and/or the notifications, you can execute a mass change using the database.  Open your LBI database server using a database editing tool.  Then, run a query against your Smart Notes db (often called “LawsonSN”).

First, get the IDs for your current owner and the new owner from ENPUSERMAP.  You should be able to search on the username and grab the numeric id from there.

Next, make an update to the ENPBATREE.  Set the entry owner to the new id where it is set to the current id.  The query will look something like this (in this case, current owner is id 5 and new owner is id 3):

update ENPBATREE set ENTRYOWNER = 3 where ENTRYOWNER = 5

That’s it!  Now, when you log into Smart Notes as the new owner, you will see all the notifications!