Docs  /  NCKR Cost Accounting (NAV)  /  Appendix

Upgrade to Business Central

2024/05/08 • 6 min. to read

In this topic

• Prerequisites for the Upgrade
• Upgrade notes
• Files for the upgrade
• Preparation 1: Rename old tables in the NAV database
• Preparation 2: Rename old fields in the standard tables of 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
• Information about the new solution and settings that should be checked 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

• Minimum NCKR 6.00 Older versions of NCKR must first be updated in NAV.

Upgrade notes

• Allocations cannot be converted automatically and must be recreated after the upgrade.

Files for the upgrade

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

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 NCCA_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. After you import the objects into a separate database, the fields of the old solution (marked with OLD_NCCA) must be copied from the separate database to the NAV database.

The following fields must be copied:

Table 17 G/L Entry Field No. 1002000

Table 200 Work Type Field No. 1002000 to Field No. 1002001

Table 242 Source Code Setup Field No. 1002000 to Field No. 1002010

Table 5601 FA Ledger Entry Field No. 1002000

Table 5606 FA Posting Group Field No. 1001750 to Field No. 1001751

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 NCCA Cost Accounting 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_NCCA Customization_14.0.0.app here. For each further change to the data structure of the standard application or NAVAX Cost Accounting, 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. NCCA). This is necessary so that data from the old C/AL tables can be transferred to the new AL apps (system and NCCA). In the second version of the "Table migration Extension", a reference to the provided app "NCCA 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": "ca7a7451-d586-4034-9afe-7a2468241936"
        }
    ]
}

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 "NCCA Customization 14.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCCA 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 "NCCA 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 "NCCA Customization 19.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCCA 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 "NCCA 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 "NCCA 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 NCCA Cost Accounting.

After the upgrade

Once the upgrade is complete, the data from the old cost accounting system can be prepared for transfer to the new version. For this purpose, the app "NCCA Cost Accounting by NAVAX 14.0.0.0" must be installed. Use the file NAVAX Consulting GmbH_NCCA Cost Accounting by NAVAX_14.0.0.0.app here. This app contains only the data structure and no cost accounting application code. After the installation, the upgrade routine can be started via the page NCCA 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 cost accounting data is now prepared for the new version. The last step is to publish the latest version of NCCA Cost Accounting and install it using the Start-NAVAppDataUpgrade command. The two apps "NCCA Customization 14.0.0.0" and "NCCA Customization 19.0.0.0" must then be uninstalled and unpublished. The same applies to the app "NCCA Cost Accounting by NAVAX 14.0.0.0".

Information about the new solution and settings that should be checked after the upgrade

• In the FA Posting Groups page, there are now 3 fields for cost accounting instead of 2.
• If certain NaviCalc settings could not be applied, comments with further information are created in the rows and columns of the evaluation.