Dynamics GP 2013 -AP batch cannot be edited.

(0) Share

Report

Posted on by Community Member

After printing a check and then attempting to print the check remittance (which did print), the process kid me out of payables. But now when you try to go back in to AP batches, the batch is still there and you cannot edit it or post it. The message is this "This batch cannot be edited. Please verity status using the Batch ID's window". The check show as "work" when do an inquiry into the vendor history file.

How can I get this batch posted and cleared?

Thanks,

Pat

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you checked to see if the batch is sitting in Batch Recovery? Administration>>Routines>>Batch Recovery. If it is not, the batch will need to be released via SQL. Instructions can be found here - support.microsoft.com/.../850289.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Frank,

It was not in batch recovery and the fix to the SQL tables did not work, since the table in the suggested fix did not exist.

Thx,

Pat

Was this reply helpful? Yes No
Suggested answer

John Olley 365 on at

Like (0)

Report
Copy link

Link copied!

Pat,

Like the link above that Frank mentioned, you need to run this in SQL. If you are not familiar with SQL then you should get some professional help! Before you run ANYTHING in SQL, please make backups first. That is very important!

You need to run this against your company database through SQL.

4.Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post or select in Microsoft Dynamics GP.

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB= 'XXX'

Note The value of BACHNUMB is the same as the value of the Batch ID window in Microsoft Dynamics GP.

5.Verify the accuracy of the transactions.

6.Verify that you can edit and post the batches.

The check probably posted through the GL. You'll need help from there if it did and you don't know what to do.

Thank you,

John Olley

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

i have posted a batch but the system didn't show the voucher and when i went through posting journal for reprint it message that posting is in process , how can i void the transaction ?

Was this reply helpful? Yes No