web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Applied payments showi...
Microsoft Dynamics GP (Archived)

Applied payments showing open in RM

(0) ShareShare
ReportReport
Posted on by Daisy_P 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member 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.

  • 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.

  • 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.  

  • 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.

  • Community Member Profile Picture
    Community Member 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.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans