Sync-NAVApp : Table Location :: The field 'Location Type' cannot be located. Removing fields is not allowed. Table Location :: The field 'Customer No.' cannot be located. Removing fields is not allowed. Table G/L Entry :: The field 'Bill-to/Pay-to Name' cannot be located. Removing fields is not allowed. Table Item :: The field 'Brand' cannot be located. Removing fields is not allowed. Table Purchase Header :: The field 'Launch Date' cannot be located. Removing fields is not allowed. Table Gen. Journal Line :: The field 'Bill-to/Pay-to Name' cannot be located. Removing fields is not allowed. Table Item Journal Line :: The field 'POS Stock Take Qty.' cannot be located. Removing fields is not allowed. Table Comment Line :: The field 'Last DateTime Modified' cannot be located. Removing fields is not allowed. Table VAT Statement Line :: The field 'Formula' cannot be located. Removing fields is not allowed. Table VAT Statement Line :: The field 'Blank Positive' cannot be located. Removing fields is not allowed. Table VAT Statement Line :: The field 'Blank Negative' cannot be located. Removing fields is not allowed. Table VAT Statement Line :: The field 'Constant Value' cannot be located. Removing fields is not allowed. Table Transfer Header :: The field 'Last DateTime Modified' cannot be located. Removing fields is not allowed. Table Transfer Line :: The field 'Item Cross Reference No.' cannot be located. Removing fields is not allowed. Table Sales Price :: The field 'Last DateTime Modified' cannot be located. Removing fields is not allowed. Table COA Patching :: The table 'COA Patching' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by migration to another app. At line:1 char:1
Answers
Even if its a base to base change then you are supposed to delete all those base tables and fields so that there's no conflict.
P.S- I did the migration of data from NAV 2013 to BC 18.4 for 22 companies and I was all successful its just it took way more time.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
They are already defined in my custom application. And I have already published this in task 13 https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v18#task-13-publish-final-extensions.
Sync-NAVApp : Table Currency :: The field 'Primary Bank Account No.' cannot be located. Removing fields is not allowed.......
But if u find a solution, please update. I still several more upgrades in the pipeline.
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19
Take a look at this
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-v14-v15-compatibility
I have used https://www.hougaard.com/uplifting/ several times now to great success. But since this uses SQL scripts, it only works for onprem. And the explanation there makes it easy to follow.