Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP Crash During PM Pay...
Microsoft Dynamics GP (Archived)

GP Crash During PM Payment Apply

(0) ShareShare
ReportReport
Posted on by Jim Lines 4

Hello,
I've got a situation where an accounting user was applying a payment to open invoices for a vendor when GP crashed (not exactly sure what happened there...).  When she logged back in, she could no longer see the payment, but two of the invoices she had applied $ to now show there is zero unapplied funds.  I've verified that the payment does not exist in the vendor open or history window and I've run reconcile and checklinks with no luck.  Any ideas on how to get my two invoices back to payment unapplied status?

Thanks in advance.
Jim

*This post is locked for comments

  • Jim Lines Profile Picture
    Jim Lines 4 on at
    RE: GP Crash During PM Payment Apply

    I ended up clearing out the history and distributions out of the history tables and inserting the data from a backup into the open tables.  Not really the way I like to do things, but it worked.   Thanks to both Thomas & Richard.

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: GP Crash During PM Payment Apply

    Hi Jim!

    Thank you for the post, what is the actual status of the invoices? Are they in open or History? If the invoices are in open you would be able to remove the stuck applied records and change the CURTRXAM to be what it was prior to applying the payments. If they are however in History even if you remove the applied records you would not be able to bring the invoices back into Open status. Once Invoices are in history with no payments that you can void the only way to apply a payment to them would be to remove the history on the transaction and create a GL journal entry to reverse the invoices amounts. Once that has been completed you would be able to re-create the invoices and apply them as needed.

    As Richard had mentioned this should all be completed with having a backup on hand and testing in a test company prior to a live company to verify the results.

    871973 Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, or SQL Server 2012

    support.microsoft.com/.../en-US

    I hope this helps!

    ~Thomas Newcomb

    ------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------

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

  • Jim Lines Profile Picture
    Jim Lines 4 on at
    RE: GP Crash During PM Payment Apply

    Richard,

    I'll give that a try and let you know the results.  Thanks!

    Jim

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: GP Crash During PM Payment Apply

    Can you restore from last night's backup to a separate database and then import these two records back into the PM10200 table in the production database? You can key on the dex_row_id field.

  • Jim Lines Profile Picture
    Jim Lines 4 on at
    RE: GP Crash During PM Payment Apply

    Richard,

    Thanks for the response.  Yes, I've very familiar with SQL and you did point me in the right direction.  That being said... I think my first mistake was that I removed those two invoices from PM10200 thinking that would make them available for payment application.  Per your guidance, I did update PM30200..CRTRXAM, and the invoices now show the amounts unapplied in the Vendor Inquiry, however, when I go into the apply payments window, they are not available.   Seems like I need those records back in PM10200.

    I think this would be much easier if I were to void/re-enter the invoice, but they are generated from the Payroll to PM integration and I've got to dig in and look at what is linked.  

    Any additional suggestions are welcome.

    Thanks!

    Jim

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: GP Crash During PM Payment Apply

    Do you have access to SSMS? Are you comfortable running SQL scripts? If so, you are going to need to look in the PM30300 table and find the apply records for these invoices. You will need to remove the apply records and possibly adjust the record for these invoices in the PM30200 table. Now before you do this make a backup and do this after hours because you may need to restore from this backup so you do not want anyone in GP while you are doing this. in the PM30200 table it will be the field called CURTRXAM you may need to restore to the original amount owed. If you can run this against your database I can send back what you need to run.

    SELECT * FROM PM30200 WHERE VENDORID='Your Vendor ID' AND DOCNUMBR IN ('Invoice Number1,InvoiceNumber2,etc')

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans