Skip to main content
Solved

How to restrict "all sales order records" screen


Hi All,

 

I just want to ask regarding how to restrict the visibility of all sales order records and only show my sales order records?

 

Please refer to the screenshot below.

 

Regards,

Nadia

 

 

Best answer by BenjaminCrisman

Hi @Mle45! I do not believe there is a way to do this with conditions, if you need to set varying levels of access this is best managed through Restriction Groups, probably on Customer.

This way you can have some users part of an ALL group which will see all customers, which will mean all orders.

Otherwise you would probably need some type of Parameter to capture the logged in user and then some chain of IIF statements to dictate if the employee or workgroup is entered, show the records or not, but this seems very inefficient compared to the ease of setting up a few restriction groups.

View original
Did this topic help you find an answer to your question?

9 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • August 16, 2022

Hello @nadia02 ,

We can restrict Sales Orders to those entered by a certain user by adjusting the Sales Order list to show only your Sales Orders, and changing permissions to make the order number and < > navigation buttons inside the sales order screen to be View Only.

Here is a recent post where someone asked the same question about Purchase Orders.

 


DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 119 replies
  • August 16, 2022

@nadia02 I am not aware of a way to hide the All Records tab in a GI. If you want to restrict access across the board, edit the primary list GI as follows.

Add a Hidden Parameter

 

Add a Condition Referencing the Hidden Parameter

 

Result

Then implement the security @laura01 mentions above to secure the SO screen.

 

If you have a group of users that should be able to see all sales orders, that can be accomplished as well within the primary list GI.


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@nadia02 - You can look into a minor customization to display the Sales Order records based on you login username. 


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • September 21, 2022

 @nadia02 We also have this knowledgebase article which gives some direction to filter a GI based on the logged in user:

https://community.acumatica.com/maintenance-and-troubleshooting-15/after-an-upgrade-to-acumatica-erp-2020-r2-generic-inquiries-dashboards-and-widgets-using-ownerid-and-userid-won-t-open-due-to-the-error-437

The article itself is supposed to be direction after updating to 2020 R2 and the @me condition not working quite the same way, but it gives insight into re-configuring the conditions and it should work for this situation.

It’s not that you are hiding the All Records tab, you are adding a condition to the GI to filter based on the current user = the CreatedByUser or the Owner of the document.

Have you already tried this?


Forum|alt.badge.img
  • Freshman I
  • 14 replies
  • July 13, 2023
DConcannon wrote:

@nadia02I am not aware of a way to hide the All Records tab in a GI. If you want to restrict access across the board, edit the primary list GI as follows.

Add a Hidden Parameter

 

Add a Condition Referencing the Hidden Parameter

 

Result

Then implement the security @laura01 mentions above to secure the SO screen.

 

If you have a group of users that should be able to see all sales orders, that can be accomplished as well within the primary list GI.

@DConcannon Can you please share how to allow a group of users to see all sales orders from the GI? Thank you!


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 630 replies
  • Answer
  • July 14, 2023

Hi @Mle45! I do not believe there is a way to do this with conditions, if you need to set varying levels of access this is best managed through Restriction Groups, probably on Customer.

This way you can have some users part of an ALL group which will see all customers, which will mean all orders.

Otherwise you would probably need some type of Parameter to capture the logged in user and then some chain of IIF statements to dictate if the employee or workgroup is entered, show the records or not, but this seems very inefficient compared to the ease of setting up a few restriction groups.


DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 119 replies
  • August 9, 2023

@Mle45 There are caveats here. If you use work groups for other purposes, I recommend against this :)

I assigned people that should have access to all records to workgroup. I did a cross join to the specific work group and added an or condition that <@me was within the group>.

I could not use restriction groups so this was a workaround


Forum|alt.badge.img
  • Freshman I
  • 24 replies
  • July 17, 2024

@DConcannon is there a way to do this for select users only vs the entire company? 


Forum|alt.badge.img
  • Freshman I
  • 24 replies
  • July 22, 2024

anyone know how to restrict certain users to only see there sales quotes and sales order but for the rest of the users they see it all and not effect there access. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings