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 NCC 13.00
Older versions of NCC must first be updated in NAV.
Once the upgrade is complete, the data from the old NCC Cube system can be prepared for transfer to the new version. For this purpose, the app "Excel Report Builder 14.0.0.0" must be installed.
Use the file NAVAX Consulting GmbH_Excel Report Builder_14.0.0.0.app here.
This app contains only the data structure and no Excel Report Builder application code.
After the installation, the upgrade routine can be started via the page NCE 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 Excel Report Builder data is now prepared for the new version.
The last step is to publish the latest version of Excel Report Builder and install it using the Start-NAVAppDataUpgrade command.
The two apps "NCE Customization 14.0.0.0" and "NCE Customization 19.0.0.0" must then be uninstalled and unpublished. The same applies to the app "Excel Report Builder 14.0.0.0".
Information about the new solution and settings that should be checked after the upgrade
Note that in a Formula the English Excel Function names, commas instead of semicolons and dots as decimal separators must be used.
After the upgrade, the action Translate all Excel Functions on the Excel Report Builder Setup page can be used to translate the Excel Function names in the Formulas of all evaluations into English Excel Function names. For more information, see [Docs] Excel Report Builder - Setup - Excel Report Builder Setup
If required, the Excel Function names can be translated into English Excel Function names individually in the evaluations using the Translate action. For more information, see [Docs] Excel Report Builder - Edit Evaluations - Data Sheets - Formulas