web
You’re offline. This is a read only version of the page.
close
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) / Payments applied but n...
Microsoft Dynamics GP (Archived)

Payments applied but not showing up as applied

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.  

  • Community Member Profile Picture
    Community Member on at

    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.  

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    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.

  • Verified answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    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.

  • Community Member Profile Picture
    Community Member on at

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

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans