Skip to main content

Restrict Record by Owner or Created By

  • July 10, 2025
  • 2 replies
  • 61 views

Certainly we can’t be the only company using Acumatica that has this scenario.

User A creates a quote and user B has access to the branch the quote was created on.  Both users have the ability to edit at the same time but user B selects SAVE first which causes “another process” error for user A and they loose their work.

I saw another discussion that was closed so opening up a new one.  Workgroups wont’ work here, approvals are too heavy, neither would access or row level security.

I would think that the Created By user could edit and give access to employees to edit but if one user is in a transaction and another users accesses it it would tell them who is editing the transaction so they don’t overlap.  Think shared Microsoft files with edit permissions.

Thoughts?

2 replies

  • Author
  • Jr Varsity II
  • May 26, 2026

Bumping this back up!


WillH
Semi-Pro II
Forum|alt.badge.img+4
  • Semi-Pro II
  • June 1, 2026

Hi ​@Lanaswillow  
Not sure if you have access to the Product Ideas boards, this has been discussed there before in the following places:
 


The determination from Acumatica Product Management 4 years ago was:

Acumatica is not likely to make changes to this structure. The workaround is to train users to save their work often. By pressing the save key frequently, users minimize the impact.

 


There’s a separate idea that’s to do with enabling more collaboration, which hasn’t had a specific product management reply:
 

 

 

If your business needs to force some kind of aggressive locking, you might be able to get a developer to set up a specific customization to support you ,but you’d need to be pretty careful about it.

Another option might be just to set up some GIs for showing records and filter out anything that has a last edit that’s very recent, and then train people to save the record immediately on openiing.  
Wouldn’t be fool proof, but might give you a way around?

So fundamentally, process changes are going to be your best bet here.