How To Import Account Schedules in Microsoft Dynamics Business Central or NAV

How To Import Account Schedules in Microsoft Dynamics Business Central or NAV

This blog explains how to import account schedules into a database in Microsoft Dynamics 365 Business Central or Dynamics NAV. Important steps include:

  1. Export Customer Data
  2. Export Default Cronus data
  3. Export Default Cronus Package
  4. Import Cronus package into Customer database
  5. Import Cronus data

Let’s get started with a backup. Normally, you do a backup of the database, but in the SaaS world, backups are automatically stored. However, you still need to make a backup of the account schedule data in the customer database.

Import Account Schedules Step 1: Export Customer Data

The first step in the process to import account schedules is to export the default Cronus data.

  • Create a new configuration package; then update the required details like code, package name, product version, and language ID. The Exclude Configuration Tables field is used to get related tables, so that should be enabled.
  • Start adding the tables beginning with ID 84, getting related tables using Get Related Tables under the Functions tab.
Import Account Schedules BC NAV-1
Figure 1 - Creating and adding fields in the Config. Package card in Microsoft Dynamics Business Central and NAV
Import Account Schedules BC NAV-2
Figure 2 – Related tables for table 84 in the Configuration package card in Microsoft Dynamics Business Central or NAV
  • Simultaneously add table 85 with its related tables. Once you add the tables, you will receive a notification, “Some fields have 3 or more related tables. Do you want to check them?” Click Yes.
  • In the EDIT – CONFIG. PACKAGE FIELDS page, uncheck the Included Field and Validated Field boxes and select the Clear Included option.
Import Account Schedules BC NAV-3
Figure 3 – Clearing the Included Field and Validated Field in the EDIT-CONFIG. PACKAGE FIELDS page in Microsoft Dynamics Business Central or NAV
  • Now you have four tables. You do not need the Analysis View table, so delete it and do an export to Excel. Select all the tables.
Importing Account Schedules BC NAV-4
Figure 4 – Exporting to Excel and selecting all tables on the Config. Package card in Microsoft Dynamics Business Central or NAV
  • When you get the notification, “3 tables have been selected. Do you want to continue?” click Yes. An Excel file is created containing the customer account schedule data values.
Importing Account Schedules BC NAV-5
Figure 5 – Excel file with customer account schedule data in Microsoft Dynamics Business Central or NAV

Step 2: Export Default Cronus Data

The next step in the process to import account schedules is to export the default Cronus data.

  • Follow the same instructions with the Cronus database to get the default account schedule data package. Create a new configuration package, add required details, get the related tables, and export to Excel.
  • After you export, if you need to cross check the data in this Excel file you created, you can compare it with account schedule values (both are Cronus data).
Importing Account Schedules BC NAV-6
Figure 6 – Comparing Cronus data and Excel data in Microsoft Dynamics Business Central or NAV
  • One more check point: Cross check the Cronus account schedules with the customer account schedule data. Any account schedules names that are the same need to be changed in Cronus.
Importing Account Schedules BC NAV-7
Figure 7 – Comparing Cronus data and customer data in Microsoft Dynamics Business Central or NAV

In this example, some values are similar so the values in Cronus need to be changed. Following are the names that were changed in account schedule name table:

M-BALANCE :M-BALANCE-1,

M-CASHFLOW:M-CASHFLOW-1,

M-INCOME:M-INCOME-1,

M-RETAIND:M-RETAINED-1

Importing Account Schedules BC NAV-8
Figure 8 – Changed values in the Account Schedule Names table in Microsoft Dynamics Business Central or NAV
  • In the Account Schedule Line table, the following four values also need to be changed:  

M-BALANCE :M-BALANCE-1,

M-CASHFLOW:M-CASHFLOW-1,

M-INCOME:M-INCOME-1,

M-RETAIND:M-RETAINED-1

Importing Account Schedules BC NAV-9
Figure 9 – Changed values in the Account Schedule Lines table in Microsoft Dynamics Business Central or NAV
  • Simultaneously change the values in column layout name table.
Importing Account Schedules BC NAV-10
Figure 10 – After changing the values in the Column Layout Name table in Microsoft Dynamics Business Central or NAV

Step 3: Export the Default Cronus Package

  • Once the data steps are completed, the next step in the process to import account schedules is to export the Cronus default package using the Export Package function on the Package card.
Importing Account Schedules BC NAV-11
Figure 11 – Exporting the Package in the Cronus database in Microsoft Dynamics Business Central or NAV

Step 4: Import the Cronus Package Into the Customer Database

  • Use Import Package to import the Cronus Package into the customer database.
Importing Account Schedules BC NAV-12
Figure 12 – Importing the Cronus Package into the customer database in Microsoft Dynamics Business Central or NAV
Importing Account Schedules BC NAV-13
Figure 13 – Cronus Package successfully imported into the customer database in Microsoft Dynamics Business Central or NAV

Import Account Schedules, Step 5: Import Cronus Data

The final step in the process to import account schedules is to import the Cronus data.

  • To import the Excel file you took from Cronus, select all the tables to get all the data. Then select Import from Excel.
Importing Account Schedules BC NAV-14
Figure 14 – Importing the Cronus default Excel file into the customer database in Microsoft Dynamics Business Central or NAV
  • Once you choose the Excel file, it should ask for importing options. Select all, then select Import.
Importing Account Schedules BC NAV-15
Figure 15 – Importing the Cronus default Excel file in Microsoft Dynamics Business Central or NAV
  • You will receive three notifications related to three tables—Account Schedule Name, Account Schedule Line, and Column Layout Name. Click Yes for all notifications.
  • This is the most important step. Select all the tables, then select Apply Data under the Functions tab. Click yes on the notification you receive.
Importing Account Schedules BC NAV-16
Figure 16 – Apply data for all the tables in Microsoft Dynamics Business Central/NAV
  • A final note will display with record changes, like how many records are inserted, how many records are modified, and errors found. Click OK.
Importing Account Schedules BC NAV-17
Figure 17 – Note for record changes in Microsoft Dynamics Business Central or NAV
  • Finally, all the default account schedules are successfully imported into the customer database.
Importing Account Schedules BC NAV-18
Figure 18 –Default account schedules are imported in Microsoft Dynamics Business Central or NAV

If you have any questions about Dynamics NAV or Business Central for any version, contact ArcherPoint.

Read more "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics Business Central or NAV.

If you are interested in NAV/Business Central development, check out our collection of Development Blogs.

Trending Posts

Stay Informed

Choose Your Preferences
First Name
*required
Last Name
*required
Email
*required
Subscription Options
Your Privacy is Guaranteed