Question Status

Verified
Karen Swanson asked a question on 6 Jun 2011 11:38 AM

During applying documents in Receivables, I got error message "The selected document may be damaged. Please rebuild RM Keys file to correct it." I am not seeing anything in Knowledge Base. Anyone had this problem before?

Reply
Verified Answer
Gary Letter responded on 6 Jun 2011 11:57 AM

You might try running Check Links on the Receivables Open Transaction Files. This has solved similar errors.

Gary Letter
NextLevel Business Systems

Reply
Verified Answer
Richard Wheeler responded on 6 Jun 2011 12:01 PM

Step 1) Have everyone exit GP

Step 2) Perform Backup

Step 3) Using SQL issue the command Delete RM00400

Step 4) Go into GP and run Check Links on the Open and Historical AR Transaction tables

The RM00400 table is the Receivables Key Master table. By deleting it and then running Check Links you completely repopulate the table based on transactions found in the open and historical tables.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Biser Marinov II responded on 31 Jul 2012 2:35 AM

I thought the RM00401 was the RM Keys master table, but I might have been wrong all that time...

Reply
Richard Wheeler responded on 31 Jul 2012 4:18 AM

I apologize for the typo. The RM Key master table is RM00401.After deleting the records in this table and then running check links you will get a long list of all the receivables documents that have been recreated. Make sure you have a backup and that no one is in GP while you are doing this.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Verified Answer
Gary Letter responded on 6 Jun 2011 11:57 AM

You might try running Check Links on the Receivables Open Transaction Files. This has solved similar errors.

Gary Letter
NextLevel Business Systems

Reply
Verified Answer
Richard Wheeler responded on 6 Jun 2011 12:01 PM

Step 1) Have everyone exit GP

Step 2) Perform Backup

Step 3) Using SQL issue the command Delete RM00400

Step 4) Go into GP and run Check Links on the Open and Historical AR Transaction tables

The RM00400 table is the Receivables Key Master table. By deleting it and then running Check Links you completely repopulate the table based on transactions found in the open and historical tables.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply