85
Hi All-
We are using Microsoft GP 2013 and we are getting the following error when trying to approve a payable batch:
"You cannot mark the batch for approval. Another user is editing it or it is displayed in another window."
No one is in the batch and it is not open in another window.
Any ideas?
-Randy Short
*This post is locked for comments
Further to what's mentioned by Mr. Frank
In case you are not into SQL, you may consider the automated solutions provided on the customer source. There is an automated solution for this specific case as shown below;
>> Reference: Automated solutions that are available for the System series in Microsoft Dynamics GP
Hi Randy,
There is a batch activity record stuck in SY00800 due to abrupt closure of GP or an internal error. Usually it gets deleted automatically when user completes an operation related to that batch (like editing,posting etc). Deleting the batch activity record for a batch number in SY00800 will not delete the batch you are trying to process.
FYI, A batch activity record is useful to manage multiple users accessing/processing the same batch at same time.
Won't this delete the batch we are trying to process?
I've run the following and it didn't work:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
-Randy
The system thinks someone is in the batch because there's a record hung in the SY00800 table in the Dynamics database. You need to clear the record from that table (it will have the Batch ID in it).
This is the SQL script you would use:
----------
USE DYNAMICS
DELETE SY00800 WHERE BACHNUMB = 'XXXXX'
---------
XXXXX = your Batch ID
Warning: If you're not SQL conversant and don't typically perform this type of operation, contact your IT department or GP Partner to execute the script. Also, make sure to take a backup of the DYNAMICS database before executing any scripts.
Let us know if you need anything else.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (