Docs  /  NCP Payments

<topic header undefined>

2024/04/18 • 7 min. to read

In this topic

• Prerequisites for the Upgrade
• 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

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 NCP 13.00 Older versions of NCP must first be updated in NAV.

Files for the upgrade

All files needed in each step for the upgrade can be downloaded here: NCP_UpgradeToBC_20230405.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 NCP_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_NCP) must be copied from the separate database to the NAV database.

The following fields must be copied:

Table 18 Customer Field No. 1001700

Table 21 Cust. Ledger Entry Field No. 1001702 to Field No. 1001705

Table 23 Vendor Field No. 1001700

Table 25 Vendor Ledger Entry Field No. 1001702 to Field No. 1001705

Table 81 Gen. Journal Line Field No. 1001700 to Field No. 1001753

Table 242 Source Code Setup Field No. 1001700

Table 271 Bank Account Ledger Entry Field No. 1001710 to Field No. 1001740

Table 273 Bank Acc. Reconciliation Field No. 1001700 to Field No. 1001720

Table 274 Bank Acc. Reconciliation Line Field No. 1001700 to Field No. 1001720

Table 275 Bank Account Statement Field No. 1001700 to Field No. 1001710

Table 276 Bank Account Statement Line Field No. 1001700 to Field No. 1001712

Table 287 Customer Bank Account Field No. 1001701 to Field No. 1001712

Table 288 Vendor Bank Account Field No. 1001701 to Field No. 1001708

Table 372 Payment Buffer Field No. 1001702 to Field No. 1001705

Table 5200 Employee Field No. 1001700

Table 5222 Employee Ledger Entry Field No. 1001702

Table 5225 Employee Payment Buffer Field No. 1001702

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 NCP Payments 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_NCP Customization_14.0.0.app here. For each further change to the data structure of the standard application or NAVAX Payments, 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. NCP). This is necessary so that data from the old C/AL tables can be transferred to the new AL apps (system and NCP). In the second version of the "Table migration Extension", a reference to the provided app "NCP 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": "2c40ba68-7b3b-4783-ba82-b1094db31332"
        }
    ]
}

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 "NCP Customization 14.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCP 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 "NCP 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 "NCP Customization 19.0.0.0" is published. Use the file NAVAX Consulting GmbH_NCP 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 "NCP 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 "NCP 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 NCP Payments.

After the upgrade

Once the upgrade is complete, the data from the old NCP Payments system can be prepared for transfer to the new version. Since the new version is split into 3 apps, 3 separate transfers must also be made. It is important that first the Payments Base transfer is performed and only then the Payments Export/Import transfers. First install the 3 apps (also included in the NCP_UpgradeToBC_20220729.zip):

1. NAVAX Consulting GmbH_NCP Payments Base by NAVAX_14.0.0.0.app
2. NAVAX Consulting GmbH_NCPE Payments Export by NAVAX_14.0.0.0.app
3. NAVAX Consulting GmbH_NCPI Payments Import by NAVAX_14.0.0.0.app

These apps contain only the data structure and no application code. After the installation, the Payments Base upgrade routine can be started via the NCP Upgrade page, which can be found via the search. After that, the Payments Export and Payments Import upgrade routines can be started via the NCPE Upgrade and NCPI Upgrade page, which can be found via the search. The upgrade routines only need to be started in one company and run automatically across all companies in the database. The NCP Payments data is now prepared for the new version. The last step is to publish the latest version of NCP Payments (consisting of 3 apps) and install it using the Start-NAVAppDataUpgrade command. The two apps "NCP Customization 14.0.0.0" and "NCP Customization 19.0.0.0" must then be uninstalled and unpublished. The same applies to the 3 apps "NCP Payments Base by NAVAX 14.0.0.0", "NCPE Payments Export by NAVAX 14.0.0.0" and "NCPI Payments Import by NAVAX 14.0.0.0".