Form settings issue

[Former Member]

Hi guys

I wonder if any of you have experienced this issue:

One of our users (who do not have authorization to form settings). When I add the WHSE column in a sales order, quote, or invoice, sometimes after logging out and back in, the column is not there. I need to then access her form settings using my manager username and password to add it again. Its not a consistent problem. Sometimes the column stays and sometimes it removes itself.

Do you guys know what could be causing this?

[jitin_chawla · Accepted solution]

Hi,

Have you checked the Note No. : 715714 ?

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Thanks for all your respnses guys. I have tried everything in the post and the problem seems to be solved.

Thanks!

[KennedyT21]

HI Bradley,

Pls close the Tread

Regards

Kennedy

[former_member218051]

Hi,

As experts mentioned above, educate your user to exit from file menu.

Whenever a super user is setting the form settings for a normal user take care that no other session is running for that user.

thanking you

Malhaar

[Former Member]

Hi,

As you mentioned it is not a consistent problem, in most cases, it is because the user has another session open or the user has not properly exit from B1. User has to use File-Exit or equivalent command to quit exclusive B1 session to save the form setting.

Thanks,

Gordon

[agustin_marcoscividanes]

Hi Bradley

check these notes:

1753610 - Form Settings Change Without User Interaction

1458907 - Form Settings-open items list

You can try this too:

1.Find the formid, itemid of the problematic grid.

a) Open SBO, find the problematic grid in a form.

b) Enable the System/Debug information(Go to Menu->View, check System/Debug information).

c) Put the mouse on any field of the problematic grid, find the formid (The number after 'Form=') and the itemid(The number after 'Item=') on the status bar at the left bottom of SBO.

d) Record this formid and itemid.

2.Close SBO. Make sure no SBO clients are connected to the server.

(This step is very important! If SBO is not closed, this solution won't work.)

3.Open SQL Analyzer, run the update query below.

Before running the query, do please replace:

/!Formid found in Step 1!/  to the formid found in step 1.

/!Itemid found in Step 1!/  to the itemid found in step 1.

/!Problematic User Code!/   to the user code of problematic user.

--begin

--delete all the user settings

delete cprf where formid='/!Formid found in Step 1!/'

--for this forma nd itemid='/!Itemid found in Step 1!/'

-- and this document

and usersign =(select internal_k from ousr where user_code = '/!Problematic User Code!/' )

--end

4.    Open SBO, and check whether the issue is solved.

Kind regards

Agustín Marcos Cividanes

[KennedyT21]

HI Bradley Sharnock

In order to confirm your change, you have to log off from system and restart. Only one user should looged, This is database transaction default.  If an user has more than one session connected to the system, the change will not be saved either. There is no such thing as a web page refresh for DB transaction unless there is a COMMIT command hard coded in the application.

Apply "Authorization" setting to all user

Exactly what u want to hide or read-only mode to particular user

If u want to hide then login with user and then apply form setting "un check for particular module"

if u want to giver mode then go in authorization->general authorization and apply as per yr need.

Note if user must not be superuser

By definition, when a user performs changes in the document settings via the document's window e.g. the Form Settings - Delivery window), these new settings will be saved permanently in the CPRF table ONLY when the user closes SAP Business One properly e.g. upper menu File => Exit.

In case SAP Business One is not closed in a proper way e.g. AltCtrlDel , System Crash etc., the new document settings will not be saved.

Regards

Kennedy