SAP® Business One: Update all users wallpapers at once

by

One annoying thing about setting the wallpaper in SAP® Business One is that you technically would have to login to each user and set the image path manually which is a pain in the butt.  I found a simple way to update everyone at once.

Here is the SQL:

UPDATE OUSR
SET OUSR.WallPaper = ‘\\server\B1_SHR\background.png’

Note that it is a network relative path.  This is very important.  Set the image up on the server in B1_SHR and then point everyone to it.  If you want to do a Christmas theme or something then you can simply replace the wallpaper and it will update for everyone.

By default all users are set to  OUSR.WllPprDsp = ‘1’ which is centralized.  You can do an update to set it to ‘2’ or full screen which will stretch the background or you can set it to ‘3’ which will tile.

UPDATE OUSR
SET OUSR.WllPprDsp= ‘3’

Really simple solution to the problem and now everyone can see your nice logo in the middle of the screen.  Somehow brings the company closer together.

I have not tested this on 2007 but it works fine in 8.8.

2 thoughts on “SAP® Business One: Update all users wallpapers at once”

  1. I apologise for being critical but you need to be careful with doing direct SQL updates in a SAP database. If SAP discover that this has been done (and on a lot of tables this is easy to do using the audit trails) then they will refuse to support the database and i know of Companies that have had to throw away an established database and re-implement in order to get support back.
    The moral of the story is – dont do SQL updates in a production database and use the DI instead.

    Reply

    • Hey Gordon, under normal circumstances I agree. But for the user wallpaper it’s a dead-end table. I have done this hundreds of times and have had no ill effects. I never update system tables. Your warning is correct, so thanks for that. But you can do the wallpaper update. I don’t even know how to do a DI API update without wasting tens of hours trying to drag the answer out of a developer. SQL UPDATE is also OK for UDTs, UDOs and UDFs. The only thing I avoid are direct SAP fields. You can use the B1UP Master Data Manager to do scheduled updates to system tables without the SDK as well. Thanks for the comment!

Leave a Comment