Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Tricia Mummert Profile Picture
    Tricia Mummert 270 on at
    RE: Records in RM00401 not in RM10101 or RM30101

    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

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Records in RM00401 not in RM10101 or RM30101

    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

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Records in RM00401 not in RM10101 or RM30101

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans