Sage 100

MAS90 V4.40 upgrade to Sage 100 Advanced V2014 with update 4. During conversion receiving an error: Create table failed and then it mentions AR_CustomerCreditCard. I tried going back to V4.40 and ran the rebuilds again and then re-migrated but still did not resolve the error. I am stuck and if anyone has any suggestions, it would be greatly appreciated! @Sage100Routine @Sage100UrgentSupportNeeded

Is this the first migration/ conversion to v2014 or are you remigrating. You might try to reconvert the system again too

Actually remigrate the system is what I mean.

Ya, this is the 3rd time re-migrating. I corrected the same message for Sales Order but this is not correcting AR. Ok, I will try re-migrating with System files. Thanks for the suggestion.

If it still doesn't work after remigrating the system files you may want to purge expired credit cards in 4.40 prior to migrating once more. Good luck.

Here's another suggestion in 4.40 - Go through the Payment Types defined and delete any invalid Types that are no longer associated with a valid Merchant and Processor ID

Rename ARxxx. Convert. Rename folder back. Convert again.

Same thing happened to me with a customer that DID NOT USE credit card. I solved it by dumping the CC data in the file: Go into DFDM SY_Company Select the record for the company with the issue Change Field 51 EncryptionKeyAES$ to the word DELETE in caps SY_CreditCardRestart Delete any record in there Go back to company maintenance and Convert

Ok, bringing in the system files allowed AR to convert but now SO failed at SO_SalesOrderHeader. Any thoughts? I am going through DFDM to review the records since the conversion creates a SO_SalesOrderHeader_Orig table while converting and they do have a different record count by 1.

What is the exact message and is there an info button? Can you do a screen shot of the info?

Here is the screenshot.... no info button...

Although it doesn't appear to be the same type of issue, I had something ""similar"" where I received a ""record is missing"" error on the AR_Customer.m4t, and I had to remove records via DFDM from AR_CustomerCreditCard.M4T for Customers that don't exist in the customer masterfile.

Sometimes if you just try reconverting that (with no changes) it will go through the second time. ""Brute force method