Docs  /  NCB Balance

Upgrade to Business Central

2023/01/23 • 5 min. to read

In this topic

• Prerequisites for the Upgrade
• Files for the upgrade
• Preparation: Rename old tables in the NAV database
• APPLICATION UPGRADE
• Task 3: Move code customizations to extensions
• Task 4: Create empty System, Base, and customization extensions
• Task 5: Create table migration extension
• Task 10: Publish DestinationAppsForMigrations extensions
• Task 12: Install DestinationAppsForMigration and move tables
• Task 13: Publish final extensions
• Task 14: Synchronize final extensions
• Task 17: Upgrade and install final extensions
• After the upgrade

Show more

Show less

This topic is for developers and describes the steps required to transfer the data from the old C/AL version (NAV AddOn) to the new AL version (BC Extension).

Prerequisites for the Upgrade

None

Files for the upgrade

All files needed in each step for the upgrade can be downloaded here: NCB_UpgradeToBC_20230123.zip

Preparation: Rename old tables in the NAV database

The tables of the old solution are already in the NAV database in the 1000000 object range. In order to bring the table structure of the old solution on a uniform basis and to avoid naming conflicts with the tables of the new solution, the old tables must be updated and renamed. To do this, import the NCB_UpgradeToBC_Step1_RenameOldTables.fob file with Replace All. The old tables are then marked with OLD_. The code, variables and functions and all TableRelations to the standard objects were also removed from the old tables.

APPLICATION UPGRADE

All steps described refer to this document: [Microsoft Docs] Business Central - Upgrading Customized C/AL Application to Microsoft Base Application Version 19. Preparations and steps 1-2 must be performed for each installation.

Task 3: Move code customizations to extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-3-move-code-customizations-to-extensions The current NCB Balance represents the target app, so there is nothing else to do in step 3.

Task 4: Create empty System, Base, and customization extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-4-create-empty-system-base-and-customization-extensions In step 4, empty apps are created, which subsequently take ownership of old C/AL tables. Use the file NAVAX Consulting GmbH_NCB Customization_14.0.0.app here. For each further change to the data structure of the standard application or NAVAX NCB Balance, separate upgrade apps and conversion routines must be created.

Task 5: Create table migration extension

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-5-create-table-migration-extension In Task 5 a "Table migration Extension" is created, which contains all tables of the old C/AL solution (incl. NCB). This is necessary so that data from the old C/AL tables can be transferred to the new AL apps (system and NCB). In the second version of the "Table migration Extension", a reference to the provided app "NCB Customization" must be added to the migration.json file:

migration.json
{
    "apprules": [
        {
            "id": "63ca2fa4-4f03-4f2b-a480-172fef340d3f"
        },
        {
            "id": "437dbf0e-84ff-417a-965d-ed2bb9650972"
        },
        {
            "id": "aab0e9be-c24e-4f4c-a869-69890ac372e4"
        }
    ]
}

Task 10: Publish DestinationAppsForMigrations extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-10-publish-destinationappsformigrations-extensions In step 10, the app "NCB Customization 14.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCB Customization_14.0.0.app here.

Task 12: Install DestinationAppsForMigration and move tables

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-12-install-destinationappsformigration-and-move-tables In step 12, the "NCB Customization 14.0.0.0" app is installed.

Task 13: Publish final extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-13-publish-final-extensions In step 13, the app "NCB Customization 19.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCB Customization_19.0.0.app here.

Task 14: Synchronize final extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-14-synchronize-final-extensions In step 14, the "NCB Customization 19.0.0.0" app is synchronized.

Task 17: Upgrade and install final extensions

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v19#task-17-upgrade-and-install-final-extensions In step 17, the "NCB Customization 19.0.0.0" app is installed with the Start-NAVAppDataUpgrade command. The upgrade to BC19 can be completed, there are no other special considerations regarding NCB Balance.

After the upgrade

Once the upgrade is complete, the data from the old NCB Balance system can be prepared for transfer to the new version. For this purpose, the app "NCB Balance by NAVAX 14.0.0.0" must be installed. Use the file NAVAX Consulting GmbH_NCB Balance by NAVAX_14.0.0.0.app here. This app contains only the data structure and no NCB Balance application code. After the installation, the upgrade routine can be started via the page NCB Upgrade, which can be found via the search. The upgrade routine only needs to be started in one company and runs automatically across all companies in the database. Please note that the date format of the client (region settings) is used when converting the date filters. The NCB Balance data is now prepared for the new version. The last step is to publish the latest version of NCB Balance and install it using the Start-NAVAppDataUpgrade command. The two apps "NCB Customization 14.0.0.0" and "NCB Customization 19.0.0.0" must then be uninstalled and unpublished. The same applies to the app "NCB Balance by NAVAX 14.0.0.0".