Script for Rebuilding the RM Keys Master (RM00401)

(0) Share

Report

Posted on by sueconrod

337

I know that we can build the RM00401 by doing checklinks. But I also know that there used to be a script available to rebuild the keys thru SQL that built it much faster when you have a customer who has a whole lot of transactions in Sales/Receivables.

Does anyone know if this script is still available.

Sue C

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Script for Rebuilding the RM Keys Master (RM00401)

Log-out all users from Dynamics GP. Save backup of your company database.
Goto SQL Analyzer select company database and run TRUNCATE TABLE RM00401.

Login to GP as 'sa' user and goto > Maintenance > Check Links.

Select Sales from the Series drop down and add the following tables

Receivables Transaction History Files
Receivables Batch History
Receivables Open Transaction Files

press OK button to continue.

Was this reply helpful? Yes No