Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
I am not able to upgrade from MYOB Premier v 19.5 to AccountRight v2018.4.1. I have tried several times, after several minutes of the upgrade process, I get an 'unsuccessful upgrade' message, with a log file.
Firstly, I am upgrading offline, and have no wish to upgrade to the online version, or upload the file online. Also, I am doing the upgrade to test new features of MYOB, and not doing on our real 'live' database, until such time we have tested.
Secondly, I have verified the data successfully, and also run the optimisation assistant successfully, both before upgrading.
Thirdly, I have tried about five times with same result. Using a fresh copy of our myob file each time (after verification and optimisation has already been done).
I am very frustrated, when trying to get help over the phone, after waiting 30 mintues to speak with someone they could not help, and said they would transfer me to technical support, after another 30 minutes of waiting, I hung up in frustration.
During the upgrade, I was prompted with this message:
"One or more items images cannot be found in a default graphic folder. You can select another folder where the graphics could be found. If you do not select a folder, images will not be upgraded. Would you like to select another folder?"
I select 'No', and the migration process continued. After several more minutes, I get a message pop up "The company file cannot be upgraded. Errors were found during the upgrade process." I open the log file, and I get this:
- Warning1 : ItemImage for ItemID - 1 File not found : C:\Users\Accounts\AppData\Local\MYOB\Temp\Graphics\001
- Warning2 : ItemImage for ItemID - 2 File not found : C:\Users\Accounts\AppData\Local\MYOB\Temp\Graphics\P1010028.JPG
- Warning3 : ItemImage for ItemID - 3 File not found : C:\Users\Accounts\AppData\Local\MYOB\Temp\Graphics\001
<<<<<<lines removed by myself as there are over 1000 lines with similar content>>>>>>
- Warning1118: ItemImage for ItemID - 1411 File not found : C:\Users\Accounts\AppData\Local\MYOB\Temp\Graphics\049
- Warning1119: Processing Sale and Purchase Transactions: The value for column 'ItemRecordId' in table 'SaleAndPurchaseLine' is DBNull.
Source : UpgradeUtility
Method : Upgrade
Error : (UpgradeException):
Extra info : System.Data.StrongTypingException: The value for column 'ItemRecordId' in table 'SaleAndPurchaseLine' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.
--- End of inner exception stack trace ---
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.SaleAndPurchaseBusinessEventMigrationTask.CreateBusinessEventLine(Int32 eventType, SaleAndPurchaseRow saleAndPurchase, SaleAndPurchaseLineRow lineRow, IEnumerable`1 taxInformationRows, Boolean isTaxCollected)
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.SaleAndPurchaseBusinessEventMigrationTask.MigrateEvent(IEnumerable`1 cashTransactionSet)
Solved! Go to Solution.
Sorry to hear you are having trouble with the migration of your company file.
Migration warnings 1-1118 indicate that there images (generally ones added to items) that are not located in the Graphics folder. This is why you are getting that initial message asking you to select the folder location. This will not stop the file from migrating, you just will find that the images are not on the item cards after that migration has been completed.
Migration warning 1119 is the one that is causing the file to not migrate successfully. This is a situation that we have seen with the migrator in AccountRight 2018.4. We do have two options for you in regards to this one:
Upgrading to 2018.3 worked without issue. Thank you for your prompt reply.