Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Applied payments showing open in RM

Posted on by 435

We have payments that are fully applied but are still "open".  It looks like it might be because of some rounding issues because the payment is for $7180.19, it shows $7180.18 posted but also shows amount remaining $0.  When you open the invoice it shows the total was $7326.72 with 2% discount of $146.53 for a total of $7180.19 which is the amount that was paid.  Any ideas on why it is doing this or how to fix it?  I would really like these to move to history instead of opening.

Thanks for your help.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Applied payments showing open in RM

    I would try reconciling and checking links - preferably in a test environment first.  (Always back-up before check links.)

    You also have the remove sales utilities if they are fine purging the data.

  • Daisy_P Profile Picture
    Daisy_P 435 on at
    Re: Applied payments showing open in RM

    I thought about unapplying them and redoing the transaction but was hoping there was another option.  I recently started this job and found these items that are from 2005 - 2007.  I don't know why they weren't addressed before now.

  • Daisy_P Profile Picture
    Daisy_P 435 on at
    Re: Applied payments showing open in RM

    I ran the paid transaction removal routine but it didn't move the items from open to history.  

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: Applied payments showing open in RM

    The other thing to take into account is that once a document's "Current Transaction Amount" reaches $0, the paid transaction removal routine needs to be completed to move those documents to history.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Applied payments showing open in RM

    I had a similar issue and I unapplied the document using PSTL RM Unapply.  Then I ran reconcile.  The clerk was capable of applying the payment correctly afterwards.

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans