Error message when you click "Process" in the Create Refund Checks window in Microsoft Dynamics GP: "Data entry errors exist in batch RMPMXFR UserID

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

When you click Process in the Create Refund Checks window, and then you click Transfer , you may experience the following problems.

Scenario 1

Data entry errors exist in batch RMPMXFR UserID . Use the Batch Recovery window to process this batch.

• Note UserID is a placeholder for the logon name of the user who is processing the refund checks. This logon name is part of the batch name.
  
  If the Auto-open Print Payables Checks check box is selected in the Refund Checks Setup window, this error message is displayed before the Print Payables Check window is displayed.
  • You click OK after you receive the error message. If you continue to print the check batch, you receive the following error message:

  Errors have been found in this check batch. Please correct the errors before printing.



• NOTE:  If you have Multi-Dimensional Analysis (MDA) enabled for any of the GL accounts used in the Refund check, and if it has an MDA Analysis group set to Required, but no default MDA codes ID's are defined, the same error happens and it also creates a blank record in the PM20000 table.  After this occurs, the damaged record needs to be manually removed from the PM20000 table.  The issue can be avoided by either designating a default MDA analysis code ID for the MDA account/analysis group set to 100%, or by setting the assigned MDA analysis group ID for the account to Optional instead of Required. 





 
•  
•  
•  
•  

Scenario 2

The stored procedure createSQLTmpTable returned the following results: DBMS 2627, Microsoft Dynamics GP:0.

The "Payables Transaction Inquiry - Vendor" window contains the following two work documents that resulted from the processing of the refund check:

• The check payment for the refund
• A miscellaneous charge

Note You do not see any duplicate documents in the "Payables Transaction Inquiry - Vendor" window.

If you click to clear the Work check box and the History check box, and then you click Redisplay , another miscellaneous charge document appears. This document has a status of Open, and the duplicate error message is not displayed. If you drill down on that open document, the miscellaneous charge does not have any amounts, and it appears to be damaged. This document does not appear if you click to select the following check boxes at the same time:

• Work
• Open
• History

This problem occurs if the posting of the miscellaneous charge in Payables Management in Microsoft Dynamics GP is interrupted for one of the following reasons:

• The accounts payable account is not assigned in the Vendor Account Maintenance window, and the accounts payable account is not assigned in the Posting Accounts Setup window.
• The company is registered for Account Level Security. Additionally, the user who is processing the refund checks does not have permission to use the designated accounts payable accounts in the Vendor Account Maintenance window or in the Posting Accounts Setup window.
• The fiscal period in which the refund occurs in Accounts Payable in Microsoft Dynamics GP is closed.
• The processing of the refund checks encountered a posting interruption or a network interruption.

Scenario 2

Scenario 2

Delete PM20000 where Dex_Row_ID = XX 

To use refund checks, note the following requirements:

• The Refund Checks feature must be registered, and you must have purchased both Accounts Payable and Accounts Receivable in Microsoft Dynamics GP.
• The Refund Checks Setup window must be configured.
• The vendor record must be created for the customer.
• The relationship between the customer and the vendor must be established in the Customer/Vendor Relationships window.