Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP 2013 -AP b...
Microsoft Dynamics GP (Archived)

Dynamics GP 2013 -AP batch cannot be edited.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 2013 -AP batch cannot be edited.

    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 ?

  • Suggested answer
    John Olley Profile Picture
    John Olley 365 on at
    RE: Dynamics GP 2013 -AP batch cannot be edited.

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP 2013 -AP batch cannot be edited.

    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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Dynamics GP 2013 -AP batch cannot be edited.

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans