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).
Important
The following describes the upgrade of a solution without customizations.
If customizations exist in the old solution, separate extensions must be created for the customizations.
Prerequisites for the Upgrade
Minimum NCGLA 8.00
Older versions of NCGLA must first be updated in NAV.
Preparation 1: 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 NCGLA_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.
Preparation 2: Rename old fields in the standard tables of the NAV database
The fields of the old solution are already in the standard tables of the NAV database in the 1000000 range.
In order to bring the field structure of the old solution on a uniform basis and to avoid naming conflicts with the fields of the new solution, the old fields must be updated and renamed.
Important
The changed standard tables can be found in the file NCGLA_UpgradeToBC_Step2_RenameOldFields.fob.
Import the objects into a separate database, which has no customizations.
The objects are based on a Microsoft Dynamics 365 Business Central "Spring 2019" (Version 14.0) AT version.
After you import the objects into a separate database, the fields of the old solution (marked with OLD_NCGLA) must be copied from the separate database to the NAV database.
Once the upgrade is complete, the data from the old NCGLA G/L Application system can be prepared for transfer to the new version. For this purpose, the app "NCGLA G/L Application by NAVAX 14.0.0.0" must be installed.
Use the file NAVAX Consulting GmbH_NCGLA GL Application by NAVAX_14.0.0.0.app here.
This app contains only the data structure and no NCGLA G/L Application application code.
After the installation, the upgrade routine can be started via the page NCGLA 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 NCGLA G/L Application data is now prepared for the new version.
The last step is to publish the latest version of NCGLA G/L Application and install it using the Start-NAVAppDataUpgrade command.
The two apps "NCGLA Customization 14.0.0.0" and "NCGLA Customization 19.0.0.0" must then be uninstalled and unpublished. The same applies to the app "NCGLA G/L Application by NAVAX 14.0.0.0".
