Follow the following steps inorder to make a form as Query only/Read Only.

1. Login into the System Administrator/Application Developer responsibility.
2. Navigate to ‘Security -> Responsibility -> Define’
3. Query for the responsibility for which you want to make the form as ‘Query Only’ and copy the ‘Menu’ name.
4. Navigate to ‘Application -> Menu’ and query with the menu name which we got in step 3 in ‘User Menu Name’
5. Now look out for the form (Prompt) you want to make it as query only. Copy the value in the ‘Function’ field w.r.t the form that needs to be made as ‘Query Only’.
6. Navigate to ‘Application -> Funtion’ and query with the function name we got in Step 5 in ‘User Function Name’ field.
7. Identify the correct Function for your form and then naviagate to the ‘Form’ tab.
8. Enter the value: QUERY_ONLY=YES in the parameters section in the Form tab, if you already have another value existing in the parameter form then you need to seperate them with a space..

Example: MODE=”PROJECT” QUERY_ONLY=YES

16 thoughts

  1. Hi Shivmohan,

    I am trying to make the function ‘Invoice Payment Schedules’ as QUERY_ONLY through the steps mentioned, but it still lets me create records in Invoice Payment Schedules tab,
    Are you aware of any exceptions to this solution?

    Thanks,

    Like

    Reply

    1. Hi Mounika,

      i am having same query. Function column is NULL under step5, do you find any solution for this.

      thank you.

      Like

      Reply

  4. This is not the correct solution for “How to make a Form as READ ONLY”. This solution only controls “Querying” in the file. If QUERY_ONLY = YES then, you can’t create any new record within that form. You can only query the existing records. and if QUERY_ONLY = No then you can both query the old records and also create new records. The issue here is, how to restrict any user to only ‘read-only’ operation corresponding to any form. I think this can be done through form personalization, but, I’m not sure about the conditions.

    Thanks, Atul
    CTS, India

    Like

    Reply

  5. Hi Shivmohan,

    Can you suggest how to disable the Bill to Check box which is coming in Add Customer function at Sales Order Form.

    Regarda,
    Atul

    Like

    Reply

      1. Hi Shivmohan…But user can also create BILL to from Ship to field.
        can you please help to understand how i can restrict some one to change the value from LOV.

        Regards
        Atul

        Like

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s