PO in purchasing batch error

asmyatt
asmyatt used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
 
Victoria YudinOwner / Dynamics GP Consultant

Commented:
I believe Dynamics_Girl gave the right solution for this question.  

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial