workflow and lock

SUGGESTED

Good morning, We are experiencing an issue where users are locking during creation of a document (quotation, order, invoice etc..). We have tested this across other areas of the system and we have the same problem. I report an example: We had 5 users in the process of creating quotation document. The first user is creating the quotation document without a problem, BUT it seems that this user still has a lock on the AVALNUM table in SQL Server. This means that all other users and all other areas in the system is locked out of the sequence number functionality in Sage. The system keeps spinning and does not assign a sequence number for our Quotation document as long as the first user does not close the Workflow Notification Box. They use the workflow regle to check and modify the message for the customer but if there is a delay to confirm of the message, we have this problem. It depend by filed [M:AWA3]INTERV of workflow regle....the transaction is active and the lock there are active until the user confirm the message. can this behavior be avoided or is there a standard workaround to avoid it?

Thank you in advanced

  • 0
    SUGGESTED

    I'm not sure what the workflow you're referencing does - I don't think REGLE is an out-of-the-box workflow? In my past experience, this error message would appear when 2+ users would try to create a record using the same sequence number assignment/structure simultaneously. The workflow in question might be causing a delay in the assignment of the sequence number and triggering the sequence number to go to the next sequence number.

    If the workflow triggers an email action to the customer (I'm not sure what your REGLE explanation means), maybe contact your ROR to create a customization to add an 'email' triggering button or the like? This would allow the sequence number to be assigned and not hold up the other users. I'm not sure about a good workaround otherwise.