Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1820
  • Last Modified:

PO in purchasing batch error

When trying to open an PO for editing, I get the error: "You cannot open this purchase order since it is currently saved in a purchasing batch. Please select another purchase order."

The PO was in the process of having items received against it and the system crashed. I can see the PO in the POP10100 table, but can't get to it in the system.
0
asmyatt
Asked:
asmyatt
1 Solution
 
Dynamics_GirlCommented:
I havn't ever come across that error before but you can try this.

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
 
0
 
Victoria YudinCommented:
I believe Dynamics_Girl gave the right solution for this question.  
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now