Can I manually add a record to RM20201

(0) Share

Report

Posted on by Spectrum IT

120

Here is an odd one. we have a payment received in 9/2017 and was applied against an invoice. However looking in GP the invoice shows as being unpaid. If Look in the RM20101 I see the payment as being fully applied and I see the invoice as being fully paid. The GL is correct and all the other relevant tables reflect the payment. However their is no entry in the RM20201. Since there is no apply record GP and the collections module show it as unpaid and want to send collection letters.

Can I add the entry to RM20201 or should I reopen 2017, void and then recreate the payment and then apply the payment.

I am not worried about the cause, since we were unable to identify any other instances and for some reason the Check Links does not catch this, as we run it weekly.

thanks,

Rich

*This post is locked for comments

All responses (2)

Answers (1)

Spectrum IT 120 on at

Like (0)

Report

RE: Can I manually add a record to RM20201

Thank you for your reply Leslie.

We have not executed the paid transaction removal process. All the tables look correct, in GP it was not showing as applied even though both the invoice and payment showed correctly in the RM20101 table.

The PSTL tool did the trick. I unapplied using the tool and then reapplied via the apply sales document window.

thank you for your help.

regards,

Rich
Verified answer

L Vail 65,271 on at

Like (0)

Report

RE: Can I manually add a record to RM20201

You can certainly enter a record to the RM20201 table, but I wouldn't recommend it. If you want to keep your records true to the business logic, I would reopen 2017 and make the payment right. A few questions:

-Have you executed the Paid Transactions Removal process in receivables?

-What is the value of the current transaction amount field and the date invoice paid off field?

-Did you look in the history tables?

-Have you run the reconcile utility against the RM Transactions?

-Can you 'unapply' the cash receipt using the PSTL tool?

Leslie