Finance | Project Operations, Human Resources, ...

"PM_Key_Mstr could not find record" keeps happening

(1) Share

Report

Posted on by RJarrell

319

We have multiple customers who recently have received the PM_Key_Mstr error message when posting AP batches. It is odd that it has happened with multiple customers. We have not applied any updates to their GP instance recently. I have noticed that it does seem to appear more frequently on the customers who are using a terminal server. Could this be something to do with a windows update? I don't think it is a connection issue because they are using a terminal, but not sure what else would cause this. Has anyone else seen this issue appearing recently?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

Hi, please following the below article steps to resolve this issue.

Error when you print checks in Payables Management in Microsoft Dynamics GP - Dynamics GP | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No
RJarrell 319 on at

Like (0)

Report

Judy, we have already applied that resolution. The issue is that the error persists and keeps happening and has also happened for multiple customers (so totally separate systems) in the last few weeks.

Was this reply helpful? Yes No
Judy Microsoft Employee on at

Like (0)

Report

Hi, please raise a SR to Mcirosoft for further investigation.

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

Run "Query User" Command in Command Prompt in the Terminal Server, see "Logon Time" of the users to see how old is their sessions. Sometimes posting errors happens if the User's Server sessions are not logged off for long time.

Was this reply helpful? Yes No
BJ-09051414-0 344 on at

Like (1)

Report
Hey RJarrell,

Based on your scenario, this is most likely environmental due to Posting interruptions.

First thing I would want to know is the error occurring when you are doing check batches or when you are posting Transaction Batches. If Check Batches, the error means that one or more of the Invoices that are getting paid are missing the PM00400 record. This tells us that there was an issue with the posting of the Transaction Batch.

If a Transaction Batch was interrupted, if there were multiple transactions in it, there are likely multiple transaction that are missing this record, and it could just be that those transaction were not corrected from the prior error messages corrections and why it might seem like this is a recurring issue.

Some suggestion going forward:

First, we should verify that all of transaction have a Key Record.

We can do this by running Check Links which will recreate any missing PM00400 records for transactions that have PM10000, PM20000 or PM30200 record. Best to do this in test first as no way to know what it will do until it is run.

Error when you print checks in Payables Management in Microsoft Dynamics GP - Dynamics GP | Microsoft Learn

Before processing any new transactions, I would do the following.

Have all users log out.

Clear out the activity tables in SQL.

If possible, restart the SQL instance completely as this will clear out the temp tables as well.

If you cannot restart the SQL Instance, use step 3 in the KB article below to clear out the activity tables when everyone is logged out.

A batch is held in the several statuses - Dynamics GP | Microsoft Learn

Recreate and Synchronize the Forms and Reports Dictionaries.

Please use the following article to recreate your Reports.dic:

KB 850465 http://support.microsoft.com/kb/850465

If you have any modified forms\windows, you will want to recreate your Forms.dic as well.

KB 951767 http://support.microsoft.com/help/951767

To synchronize after recreating, use the steps below:

Start Great Plains Utilities. To do this, follow the appropriate step:

Click Start, point to All Programs, point to Microsoft Dynamics, point to GP (or appropriate version), and then click Utilities.

In the Additional Tasks window, click Synchronize forms and reports dictionaries, and then click Process.

Locate the Dynamics.set file on the client computer, and then click Next. (C:\Program Files (x86)\Microsoft Dynamics\GP 2018)

Restart the Terminal Box.

Determine if the above mitigates the issue.

Now if the issue still occurs, the suggestion next would be.

Create a backup before posting batches.

If the batch gets interrupted, restore the database.

Post the batch again.

Does the same thing happen?

If not, then this is an environmental issue and will need to dig into the environment.

If you do believe it is a windows update, Undo the windows update and see if the issue still occurs.

If it is recruitable (Assuming the PM00400 is not missing from the Invoice already) and the error occurs during a check run. Then you will need to capture the process in the logs to try and capture what is causing this.

I hope this helps!

Thank you!

Brandon Jarrett
Enavate - Microsoft Dynamics 365 Implementation & Support | Cloud ERP Consultant (enavate.com)
L3 Functional Consultant

Was this reply helpful? Yes No

Join the conversation

Community site session details

"PM_Key_Mstr could not find record" keeps happening

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

"PM_Key_Mstr could not find record" keeps happening

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates