web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Preventing multiple us...
Microsoft Dynamics AX (Archived)

Preventing multiple users processing the same order?

(0) ShareShare
ReportReport
Posted on by Dan_AX 20

Hi all,

I have a customer requirement, which is that only one user is allowed in a specific sales order at any one time, to prevent issues when processing. This is due to them having numerous orders coming in at the same time, and do not want users adjusting price/confirming ect. when another user may be active in that order.

Just wondered if there is there any standard functionality in the system which could be used to block/prevent entry into a sales order if another user is in it?

Thanks,

Dan

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,062 User Group Leader on at
    RE: Preventing multiple users processing the same order? AX R3

    Not anything that I can think of, from Standard AX.

    However you may replicate the Journals locking functionality, which locks a journal as soon as a user opens the lines. Meanwhile if a user tries to retrieve such lines, it is not allowed to do so. The lock is released as soon as release the journal. In the standard AX it keeps the lock information within the Journal Header table. To improve that you may want to maintain the information in a separate table for the sales orders, or else SalesTable.UpdatedDateTime may go wrong.

  • Suggested answer
    feelyd Profile Picture
    feelyd 260 on at
    RE: Preventing multiple users processing the same order?

    Have you tested the scenario your are referring to.

    Normally what happens, when you open a sales order and make some changes, another person who has also opened the same sales order, will get an error if they try and save any details.

    You normally get an error, "the current values are not up to date". This prevents two persons changing the same order at the same time.

    The second person would have to refresh the form to get the most recent changes.

    Declan

  • Dan_AX Profile Picture
    Dan_AX 20 on at
    RE: Preventing multiple users processing the same order?

    Hi Declan,

    Thanks for your response.

    We have tested it in a few different scenarios, and that error does appear if, for example, two users try to edit a sales order line, and enter different quantities. However, if for example 2 users are in an order at the same time, and both select to add a new sales order line (the same line for instance), when they both refresh both lines will have been added to the order, without error.

    The error you mentioned would prevent a large proportion of the problems occurring though.

    Dan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans