Edit

"This transaction is being edited by another user" Error message when you select an existing purchase order in Purchase Order Processing in Microsoft Dynamics GP

  • Article

This article provides a solution to an error that occurs when you select an existing purchase order in the Purchase Order Entry window.

Applies to:   Microsoft Dynamics GP
Original KB number:   859601

Symptoms

When you select an existing purchase order in the Purchase Order Entry window, you receive the following error message:

This transaction is being edited by another user.

This problem occurs in Purchase Order Processing in Microsoft Dynamics GP.

Resolution

To resolve this problem, follow these steps:

  1. Have all users exit Microsoft Dynamics GP.

  2. Back up Microsoft Dynamics GP, and then back up all the Microsoft Dynamics GP databases.

  3. Start SQL Query Analyzer, and then run the following command against the DYNAMICS database.

    DELETE SY00800
DELETE SY00801
DELETE ACTIVITY

  4. Start SQL Query Analyzer, and then run the following command against the tempdb database.

    DELETE DEX_LOCK
DELETE DEX_SESSION

  5. Start Microsoft Dynamics GP, and then select the purchase order.