Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Voided Payment Stuck i...
Microsoft Dynamics GP (Archived)

Voided Payment Stuck in GP

(0) ShareShare
ReportReport
Posted on by kuroneko1313 2,119

Hello,

We're having a problem that a voided payment from months ago is still showing up in GP and the reports. Looking it up in the Inquiry, it does not even show its Document Number.It causes our GL to become unbalanced.

Is deleting this record from the PM20000 table going to solve the problem? Or is there a way to delete this entirely from our database? We ran the GP maintenance already but that didn't help.


 Thank you very much for your help, greatly appreciate it.

 

-Elizabeth K.

*This post is locked for comments

  • Acctg BA Profile Picture
    Acctg BA 400 on at
    RE: Voided Payment Stuck in GP

    Apparently, the transaction was from a reprint check request.  The original check was voided.  The new check printed but did not process.  We brought up the batch and processed it.  Success!

  • Acctg BA Profile Picture
    Acctg BA 400 on at
    RE: Voided Payment Stuck in GP

    I have a similar issue today when a Bank contacted us.  The check was printed/paid and someone is trying to cash it at the bank but it is not on the Safepay / Positive Pay file.  When we researched it, we found it on PM10300.  It is also in WORK status. When I drill down on the inquiry, it shows the check number, the GL distributions, etc.

    I am at a loss on how to handle it.  At one time, our consultants advised us not to use Checklinks.

    On PM00400, the dcstatus field is 1 ("good" checks are in dcstatus 3) and TRXSORCE is blank.

    The check is not on PM30200.

  • Bradley Gehrls Profile Picture
    Bradley Gehrls on at
    Re: Voided Payment Stuck in GP

    Hello Elizabeth,

    Thank you for using Microsoft Online Communities.  I understand that you are trying to void a payment that does not have a document number.

    Thank you for attaching the screenshot of what you are seeing.  The reason that the payment does not have a document number is the check has not been printed.  Once you print and post the check then the document number will populate with the check number.  The document number will not populate until you print, the system will not know what check number to use until they are printed.

    I would like to verify if the payment is showing in both the PM10300 and the PM20000 tables.  Based on what I am seeing in the screenshot the payment is in the work table which is the PM10300 table.  Records in work have only been saved and not posted.  

    If the payment is in the batch you can just delete the batch and the payment will be removed from the inquiry window and the PM10300 table.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx

    This posting is provided AS IS with no warranties, and confers no rights

  • Suggested answer
    Nancy Chavez Profile Picture
    Nancy Chavez 195 on at
    Re: Voided Payment Stuck in GP

    Hi

    Maybe you could try in a backup to delete this line from the PM2000 table and then run the utilities in Purchase and Financial modules?

  • Charles Abetz Profile Picture
    Charles Abetz 935 on at
    Re: Re: Voided Payment Stuck in GP

    You will need to also delete it from the keys master (PM00400).

  • kuroneko1313 Profile Picture
    kuroneko1313 2,119 on at
    Re: Re: Voided Payment Stuck in GP

    Hi Leslie, thank you for your reply :)

    You are correct, I just ran Check Links on payables, but the Document is still there. I see that the document also shows up in the PM10300 table.

    The vendor ID actually was whited out in the screenshot. The document shows up when doing inquiry or lookup and it looks like any normal Payable doc.

    Should I just delete this entry from both PM10300 and PM20000 table? Should I delete any more entries from the GL tables or would this be enough to take care of it, or are there any other methods?

    Thanks very much for all your help, appreciate it!

     

    -Elizabeth K.


     

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Voided Payment Stuck in GP

    Hi Elizabeth,

    I would first try running Check Links on payables. If you zoom back on the Document number does anything come up? Also, you may need to look in the PM line table - and distributions - if you are going to approach it from the SQL side. I would run Check Links first, but often this doesn't fix the problem you have illustrated. Your screen shot shows the transaction in the WORK table. The work file is for unposted entries - the PM10000 series. If you do a lookup on the Payables transactions does anything show up in the lookup window? If the transaction does not have a vendor ID, I think you will need to resort to SQL.

    It's worth a shot!

    Kind regards,

    Leslie

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans