Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Payment Record in PM30...
Finance | Project Operations, Human Resources, ...
Suggested answer

Payment Record in PM30300 missing in GP subledger

(0) ShareShare
ReportReport
Posted on by Accounting Department 1,540

I found this post https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/415103/manual-payment-couldn-t-be-posted-in-gp/1157692#1157692

This just happened to us.  However, the invoice is not in PM20000. It is in PM30200.

The Hist apply record is in PM30300 but is not found in GP (subledger). It is in the GL20000 and PM30600 and PM00400.

Then another payment that was actually the one processed to the vendor is in PM20000 but not applied to anything, and has a different voucher and trx source.

 

I restored this company into test to try some things. Nothing comes up in Checklinks. Vendor summary changed when I reconciled Vendor.

Seems like I need to get the system to think that the second payment in PM20000 is actually the payment seen n PM30300. No idea how to go about that.

Tried:

 - Voided the open payment just to see what would happen -> no impact on missing doc.

 - Re-entered manual payment with original voucher # but this stayed in PM20000 and could not apply to Hist invoice

 - Cleared CURTRXAM from invoice in PM30200 but still could not apply payments to it (needs to be in PM20000)

Any ideas?  Can I "insert into" PM30300??

Categories:
Microsoft Dynamics GP
  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    RE: Payment Record in PM30300 missing in GP subledger

    I wanted to update you on the fix we did for this.

    We found all the records in the following tables after finding the trx sources, vouchers, etc)

    GL20000, PM20000, PM20100, PM30200, PM30600, PM30300, PM00400

    1) Back-end (SQL): Update the Invoice record in Payables History Table to change the amount outstanding from $0.00 to the document amount. This is so the system thinks that document doesn't have a payment applied.

    UPDATE PM30200 SET CURTRXAM=DOCAMNT WHERE DOCNUMBR='XXXXXXX' AND DEX_ROW_ID=99999

    2) Back-end (SQL): Delete the corrupt payment record from Payables Apply History Table

    DELETE FROM PM30300 WHERE VENDORID='THEVENDOR' AND VCHRNMBR='012345' AND DEX_ROW_ID=99998

    3) GP: Use Remove Transaction History Utility in GP to remove the original invoice (be sure to insert both Doc Type and Voucher Number)

    4) GP: Re-enter the Invoice and post it in GP from payables window. Delete the GL Batch that was left unposted. We don't want anything to post to the GL.

    5) GP: Apply the open payment to the Invoice in GP

    6) Back-end (SQL): Delete the corrupt payment distributions from Payables Distribution History table

    DELETE FROM PM30600 WHERE DOCTYPE=6 AND VCHRNMBR='012345'

    We also added notes to the original Journal Entries as they no longer link to anything.

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Payment Record in PM30300 missing in GP subledger

    Hello Barb,

    Thank you for your response.

    With the working from home, we did start seeing cases with network issues like this. Our systems team put out a blog on tips from working from home that you could provide your IT to take a look at the environment.

    community.dynamics.com/.../working-from-home-with-microsoft-dynamics-gp-general-recommendations-and-troubleshooting

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer

  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    RE: Payment Record in PM30300 missing in GP subledger

    Correct...because the payment is missing, I cannot Void it. Changing CURTRXAM to 0.00 on the Invoice still does not allow me to void it.

    In the Test company I will try using Remove History to get rid of the invoice and ensure the GL is updated.  Then I should be able to apply the newer payment to it.  

    If I need a support case I would have to go thru our VAR, likely they will contact Microsoft anyway.  Thank you!

    P.S.  It seems with so many people working remotely (close to 200 users) our data issues and GP freezing issues have compounded dramatically!

  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Payment Record in PM30300 missing in GP subledger

    Hello Barb,

    With the Invoice in history, there is not much that can be done as when a Debit Document is in history, there are only two ways to get it back to open so it can be applied against.

    1. Void the Credit Document that is applied to the Debit Document you want back in open.
    2. Use SQL Scripting to move the Invoice back to open.

    My interpretation of the information provided is there is either no PM30300 or the PM30300 records is for a damaged payment that you cannot see in the front end. That would leave you with the having to remove history on the Invoice using the Remove History utility. You can then make adjustments to the GL if anything posted to the GL for this invoice. Once removed, you can recreate it and apply the payment to the Invoice to move both back to history.

    Note: You might need to adjust the CURTRXAMT field if it is not correct to allow you to apply to it after it is brought back to open.

    If you would like to create a support case, we can review the data and use scripting to move the Invoice back to open and you can apply the payment to it as needed.

    I hope this helps!

    Brandon Jarrett | Microsoft Support Engineer.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans