web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

AP Check Batch

(0) ShareShare
ReportReport
Posted on by 10

AP-Checks.PNG

Good day,

I have this check batch where the status is 'available' the checks printed but the batch is still there. I am seeing the transactions in the GL, not sure how to process this where it seems to be there twice.

Have not done a check links  as yet.

Regards

Rosemary

Categories:
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    on at

    I would recommend to make a backup and restore it to a TEST company and run check links to see if it fixes it.   You can't undo check links, so be sure to try it in a test company first, or have a backup of live and have everyone out of GP so you can restore if it does more than you expect it to.  I don't know if it will or won't clean up this batch, so have to test it.  (I'm thinking not.)

    If that is not possible, then verify that the checks look good in Payables (OPEN STATUS) and also made it to Bank Rec (if you use Bank Rec).  Sounds like they made it to GL.   When posting, it has the activity in work, and then updates the posted tables, so are in both work and open tables at the same time, and then goes back to remove the work tables.  So they may have posted, and just need to be cleaned up out of the work tables.   Make sure all the checks in the batch appear as posted (in PM30200, and have DCSTATUS = 3 in PM00400 keys table.)  If so, then go ahead and delete the batch out of the PM10300 ( payment work) table and also the batch ID out of the SY00500 batch master table.    I would not delete the batch through the front-end, or else it will take the distribution records with it.  Delete the batch ID out of PM10300 and SY00500 tables, after you have verified all of them are posted and look good and in history, and in GL and Bank Rec.

    Let me know if any questions,

    Thanks,

    Cheryl W

    Microsoft Suppot

  • Rosemary Profile Picture
    10 on at

    Good day,

    You were right the check links did not fix it. The document is not in the PM30200 table, the DCSTATUS = 1 in the PM00400 table.

    The checks are in the GL and the Bank Rec Module.

    The batch status is 'available'

    Regards

  • Cheryl Waswick Profile Picture
    on at

    Oh, so it is in Bank Rec and GL, and just damaged in Payables, and still in work (PM10300).  Likely something is damaged, so is best to delete the batch and start it over again and rebuild the payables batch. 

    I would go into Bank Rec and void the check (clicking past the message that it originated in Payables) so it backs out of both Bank Rec and GL, so you can start over.  Then mark to allow duplicate checks on the checkbook setup.   You can try to post the batch again if you see it in the PM10300 table (perhaps want to try that in a TEST company, as it may be damaged and get errors), so may be best to just delete the batch from the get-go, and then rebuild it again and print the check to the screen (if you don't need to print it out again) and overwrite the check number so you use the same check number again.  Post, so you hit GL and Bank rec again , and it moves to history in Payables.  

    Hope that helps

    Cheryl 

    Microsoft Support

  • Rosemary Profile Picture
    10 on at

    Thank you, sorry for the late response will correct in Test first before doing anything in Production. 

    Regards

    Rosemary

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans