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) / Can I manually add a r...
Microsoft Dynamics GP (Archived)

Can I manually add a record to RM20201

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    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

  • Spectrum IT Profile Picture
    Spectrum IT 120 on at

    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

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