Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Payments applied but not showing up as applied

Posted on by Microsoft Employee

Payments applied in sales transaction window.  User posts the invoices and then applies payment to the invoices.  The Unapplied amount is supposed to 0 out after being applied but the Original Amount and Unapplied amount both have the same number still.   This is in the Apply Sales Document window. 

I ran Remove Paid Documents and also reconcile on the customer but nothing seems to have changed.  Any idea of what is wrong or what can be done?

Thanks!!

*This post is locked for comments

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Payments applied but not showing up as applied

    RM Tranaction Unapply is in PSTL.  It's free now so just download and install. :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payments applied but not showing up as applied

    That sounds like a good idea.  I cant find the RM Transaction Unapply tool yet but will keep looking.  Thanks!  Will keep you updated!

  • Verified answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Payments applied but not showing up as applied

    Try using the RM Transaction Unapply tool, bring the transactions back to Open, run Reconcile against the Customer then apply the transactions back.

    Another approach is to run an update script against the transactions involved, zero out the current transaction amounts, then run Paid Transaction Removal.  This should move the payment to history.  I recommend doing this on a test company though before you apply it to the live database.

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Payments applied but not showing up as applied

    The invoices will go to History if Paid Transaction Removal is processed.  You may want to check RM30101 and RM30201 for the invoices.  

    If you have PSTL, try using the RM Transaction Unapply tool which should bring back the invoices to Open status.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payments applied but not showing up as applied

    When i select the payment from the RM20201 table I see that it is applied to all of the Invoices (POSTED = 1) but a couple have missing TRXSORCE fields.   THe main thing that is freaking out my user is that the APply Sales Document window still has that money sitting there.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payments applied but not showing up as applied

    Tristan,

    The payments themselves don't show up anymore.  They look like they are paid already.  The Apply Sales Document window still has the payment sitting there but the Invoices that were applied to show up in History because they were posted already.  Very weird.  

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Payments applied but not showing up as applied

    Does the invoices the payments are applied to have the same issue?  Is the Apply Sales Documents window modified?  Is the issue happening to all users or just the one use who applies the payment?

    I can recommend asking the user to go back to the Apply Sales Documents window and un-applying / re-apply the payments to the invoices and check what happens.

    I also recommend checking the RM20201 table to verify if the apply record exists.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans