Applied payments showing open in RM

(0) Share

Report

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

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 435 on at

Like (0)

Report

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 435 on at

Like (0)

Report

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 6,840 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.