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) / Records in RM00401 not...
Microsoft Dynamics GP (Archived)

Records in RM00401 not in RM10101 or RM30101

(0) ShareShare
ReportReport
Posted on by Tricia Mummert 270

I have a client who is using an outdated process to update the receivables tables with payments, but it is fraught with errors.  They don't want to fix the process as they may be replacing it soon, but they do want to ensure the accuracy of the data in their RM tables.

I'm comparing data in tables with what I'm finding in Fabrikam to script some checks and balances, but I've come across something that has me stumped.  In TWO there are 5 payments which are in the RM00401 table that are not in the RM10101 or RM30101 tables.  What would make that happen?  When I apply the same script to the live company database, I find over 3,000 records.  Are the payments indeed missing from the RM10101 or RM30101 (whichever applies) or is there are reason for them not to be there?

select * from RM00401 where DOCNUMBR not in (select DOCNUMBR from RM10101) and DOCNUMBR not in (select DOCNUMBR from RM30101) and RMDTYPAL=9

Thanks!

Trish

*This post is locked for comments

I have the same question (0)
  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    Are the TWO payments at a status of Work? If so these payments would be RM10201.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    When you say they are using an outdated process to update the receivables tables, just what do you mean? Are they doing something outside of GP? If you make a test company from the real company and then delete RM00401 and then run check links on the open and historical transaction tables, have these records been removed from the RM00401 table? If so, they truly do not exist. The question becomes how did the get in the RM00401 table in the first place? Is anyone manually manipulating the other receivables transaction tables? Is it possible that these payments are not fully applied and they are sitting in the RM20101 and RM20201 tables? The RM10101 is the RM Distribution work table. I would change your script to be

    select * from RM00401 where DOCNUMBR not in (select DOCNUMBR from RM10201) and DOCNUMBR not in (select DOCNUMBR from RM20101) and DOCNUMBR not in (select DOCNUMBR from RM30101)  and RMDTYPAL=9

  • Tricia Mummert Profile Picture
    Tricia Mummert 270 on at

    Thanks, Richard.  That definitely worked for Fabrikam, so I know I can use that against the live database.  

    The cash receipt process they are using is a non-GP process using non-eConnect stored procedures to put cash receipts information into their GP 9 tables.  The client runs Check Links every night, and items are removed.  However, the payments should be fully applied but do not exist when trying to drill into the payment document.  They are really looking for some scripts to clean up the data on a daily basis instead of paying the money to fix the overall process.  

    Thanks again for the help!

    Trish

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