PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

450+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Give Permissions for User Queries

SAP Business One Tips Give Permissions For User Queries


In SAP Business One, there is a way to view reports with user queries instead of the report form, and sometimes there are some users that cannot access the user query that has been saved. These are the following steps to give permissions to the saved user query.

If the user query has been created and saved, first define the user query into which query group.

  1. Go to the Tools menu → Query → Query Manager.
  2. Click on Manage Categories.

    SAP Business One Tips - Give Permissions for User Queries

    SAP Business One Tips – Give Permissions for User Queries

  3. Choose the query group that was previously created.

    SAP Business One Tips - Give Permissions for User Queries

    SAP Business One Tips – Give Permissions for User Queries

  4. Click the Assign Group button.

    SAP Business One Tips - Give Permissions for User Queries

    SAP Business One Tips – Give Permissions for User Queries

  5. Then select the number saved query group, for this case the selected case is selected in a Saved Queries – Group No. 12.

    SAP Business One Tips - Give Permissions for User Queries

    SAP Business One Tips – Give Permissions for User Queries

  6. then click the  button.
  7. After the second step is performed, this step provided access rights for the specified query group. Go to Administration menu → System InitializationAuthorizationGeneral Authorization.

    SAP Business One Tips - Give Permissions for User Queries

    SAP Business One Tips – Give Permissions for User Queries

  8. Select the user who wants to be restricted cannot access the ‘STEM_SALES’ Group Query.
  9. Select the subject ReportsQuery Generator.
  10. Select the query specified in the previous point, namely the Saved Queries – Group No.12.
  11. then give No Authorization.

    SAP Business One Tips - Give Permissions for User Queries

    SAP Business One Tips – Give Permissions for User Queries

  12. Click the  button.

By doing this, when accessing the User Query, the query group ‘STEM_SALES’ will not appear, because the access rights are not given to that user.

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , , , , , , , ,