Conversion - Foreign Key error on Import Payment conversion

Issue No: AR-5185
Created 8/16/2017 10:01:02 PM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 17.1
Description Version: 17.1.0725.128   Database: [http://10.0.5.60/irelyi21hosted/i21/#/SM/OriginConversion]   Company 02.   Steps to Recreate:   1. Run the query to check how many payments is in origin table agpaymst. Total count is 1498.   |select * from agpaymst  | 2. System Manager > Utilities > Origin Conversions > Sales > Import Payments. Notice the record count does not match. Why? Please provide information in what will not import.   !pastedImage_d80746_0.png!   3. Then I received Foreign Key error after clicking Yes.   !pastedImage_d80746_1.png!     Requirements:   1. Provide why there is a difference in payment count between origin table and what will import.   2. Provide information on what the foreign key error for future conversion knowledge.   3. Provide fix for the error to complete conversion of Payment.