This document describes how to update Microsoft Dynamics NAV 2013 R2 to Microsoft Dynamics NAV 2013 R2 Cumulative Update 1. The document contains the following sections:

Important
PREREQUISITE: You must apply platform hotfix 2901564 before you begin the update steps described below. For more information, see the “Release Notes for Microsoft Dynamics NAV 2013 R2 Cumulative Update 1” document on the download page on PartnerSource.

Updating the product to Microsoft Dynamics NAV 2013 R2 Cumulative Update 1

Microsoft Dynamics NAV 2013 R2 Cumulative Update 1 is an application update only. The cumulative update includes the following files:

  • CU1Objects.<locale>.fob

  • CU1Objects.<locale>.txt

  • CU1DefaultDataExchangeSetup.<locale>.xml

  • CU1Help.zip

To install the cumulative update in non-modified databases

  1. Import the CU1Objects.<locale>.fob file into an unmodified Microsoft Dynamics NAV 2013 R2 database.

  2. Replace the existing objects in the database with the cumulative update objects.

    For more information, see How to: Import Objects.

  3. Recompile all objects.

To install the cumulative update in modified databases

  1. Import the CU1Objects.<Locale>.fob file into the import worksheet in a modified Microsoft Dynamics NAV 2013 R2 database.

    For more information, see Import Worksheet.

  2. Replace the objects in your database that have NOT been modified.

  3. Use the CU1Objects.<Locale>.txt file to compare and merge the cumulative update with the objects in your database that have been modified.

    Note
    If a table in the cumulative update has a new field and the same table in your database has been modified, use the Merge: Existing<-New or the Merge: New<-Existing options in the Import Worksheet window to import the new fields. For more information, see Options for Merging Objects.

  4. Recompile all objects.

Note
Microsoft Dynamics NAV product licenses must be updated before customers can use the cumulative update. Customers can download an updated license from CustomerSource, and partners can download their customers’ updated license from VOICE. For more information, see the following articles:

The imported objects include one MenuSuite per country, which must be compiled before you can access new pages described in the following procedures.

Creating Data Exchange Setup Records

The Data Exchange Framework has been modified to enable import of SEPA CAMT bank statements. After installing the cumulative update, you must manually replace default Danish data exchange setup records and update any custom data exchange records.

For general information about the Data Exchange Framework, see for example Data Exchange Framework (Business Value, Slides) on PartnerSource.

Important
Only the Danish version of Microsoft Dynamics NAV 2013 R2 has out-of-the-box support for local bank and payroll file formats. Therefore, the “DK: To update custom data exchange setup records” procedure below is only relevant for installations of Microsoft Dynamics NAV 2013 R2 where both of the following are true:

  • The installation is the Danish version.

  • The installation has custom data exchange setup records created with the Data Exchange Framework.

To add user permissions for SEPA import and export

  1. To import default data exchange setup records that enable users to import SEPA CAMT files and to export SEPA Direct Debit files, add user permissions to the following tables.

    Table Permissions Purpose

    1200 and 1220 to 1227

    Read,Modify,Insert

    For an administrator to import a data exchange setup for SEPA CAMT into the Posting Exch. Definitions window.

    1228

    Read,Modify,Insert

    For a user to export SEPA Direct Debit files from the Direct Debit Collect. Entries window.

    For more information, see How to: Define Permissions for Users.

To import default data exchange setup records

  1. Copy CU1DefaultDataExchangeSetup.<locale>.xml to an appropriate location.

  2. In the Search box, Posting Exchange Definitions, and then choose the related link.

  3. In the Posting Exchange Definitions window, delete all lines with default records.

    Caution
    For Danish versions, do not delete lines with custom data exchange setup records.

  4. Choose Import Data Exchange Setup.

  5. Select CU1DefaultDataExchangeSetup.<locale>.xml, and then choose OK.

DK: To update existing custom data exchange setup records in the Danish version

  1. Copy CU1DefaultDataExchangeSetup.DK.xml to an appropriate location.

  2. In the Search box, Posting Exchange Definitions, and then choose the related link.

  3. In the Posting Exchange Definitions window, select a line for a custom data exchange setup, and then choose Edit.

  4. In the Posting Exchange Definition window, in the Source Processing Codeunit ID field, enter 1240.

    This codeunit prompts users to select a file when they choose the Import Bank Statement action.

  5. On the Posting Line Definitions FastTab, choose Field Mapping.

    In the Posting Exchange Mapping window, in the Processing Codeunit ID field, enter one of the following values depending on the purpose of the data exchange setup.

    Value Purpose

    1247

    The data exchange setup enables import to table 81, Gen. Journal Line.

    1248

    The data exchange setup enables import to table 273, Bank Acc. Reconciliation.

  6. Make the Multiplier field visible on the lines of the Posting Exchange Mapping window. If the column is not visible, open the shortcut menu for the column headings, and then choose Choose Columns to add it.

    In Microsoft Dynamics NAV 2013 R2 Cumulative Update 1, the Data Exchange Framework handles reversal of amount signs in a different way. Follow the next step to make sure that amount signs remain correct after you update custom data exchange setup records.

  7. For every mapping to the Amount (LCY) field in the General Journal window that you specified and expected the amount sign to be reversed, for example when importing to the General Journal window, enter -1 in the Multiplier field.

    While the Multiplier field is normally used to multiply an amount being imported or exported, you use it in connection with this update to make sure amount signs are reversed correctly.

  8. Close the Posting Exchange Mapping window.

    In Microsoft Dynamics NAV 2013 R2 Cumulative Update 1, the Multiplier field is moved from the Posting Exchange Definition window to the Posting Exchange Mapping window. Follow the next step to recreate any multipliers in the updated custom data exchange setup records.

  9. In the Multiplier field in the Posting Exchange Definitions window, manually enter any multiplier that applies to the data exchange setup.

  10. Repeat steps 1 through 7 for every line in the Posting Exchange Definitions window that represents a custom data exchange setup.

Enabling SEPA CAMT Import

To enable SEPA CAMT import in Microsoft Dynamics NAV 2013 R2 Cumulative Update 1, you must select the imported data exchange setup record in the Bank Export/Import Setup window.

To select the SEPA CAMT data exchange setup from the relevant bank account

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Open the Bank Account Card window of the bank that you want to import SEPA CAMT bank statement files to.

  3. In the Bank Statement Import Format field, choose the lookup button, and then choose Advanced.

  4. In the Bank Export/Import Setup window, create a new line and fill the fields as described in the following table.

    Field Description

    Code

    Enter a code that identifies the SEPA CAMT bank statement import format, such as “SEPA CAMT”.

    Name

    Enter a name for the SEPA CAMT bank statement import format, such as “SEPA CAMT”.

    Direction

    Select Import.

    Posting Exch. Def. Code

    Select the SEPA CAMT code.

    This code represents the format data exchange setup that you implemented in the “To import default data exchange setup records” procedure.

Enabling Legacy Direct Debit Export

Microsoft Dynamics NAV 2013 R2 Cumulative Update 1 includes support for SEPA Direct Debit in all country versions. Three country versions of Microsoft Dynamics NAV 2013 R2 have non-SEPA solutions for exporting direct debit bank instructions. After you install the objects in this cumulative update, the legacy export formats in BE, IT, and ES must be re-enabled by selecting modified processing codeunits that are installed with the objects. For more information about the relation between legacy and W1 direct debit formats, see “What’s New” topics for the involved countries, released in the HelpCU1.zip file.

To select the legacy direct debit formats from the relevant bank account

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Open the Bank Account Card window of the bank that you want to export direct debit bank instructions from.

  3. In the SEPA Direct Debit Exp. Format field, choose the lookup button, and then choose Advanced.

  4. In the Bank Export/Import Setup window, create a new line and fill the fields as described in the following table.

    Field Description

    Code

    Enter an appropriate code that identifies the country-specific direct debit export format.

    Name

    Enter an appropriate name code for the country-specific direct debit export format.

    Direction

    Select Export.

    Processing Codeunit ID

    Select the following codeunits for the different country versions:

    • BE: 2000021, File Domiciliations

    • IT: 12176, Customer Bills Floppy

    • ES: Create a separate Bank Export/Import Setup line for each of the following codeunits:

      • 7000089, Bill group – Export factoring

      • 7000091, Bill group – Export N58

      • 7000092, Bill group – Export N19

      • 7000093, Bill group – Export N32

Updating Help to Microsoft Dynamics NAV 2013 R2 Cumulative Update 1

As a new service, this cumulative update contains a zip file with selected help topics that have changed since Microsoft Dynamics NAV 2013 R2. The content is in English language only. In the next major release, the same content will be available as a full Help experience in all translated versions.

The majority of the Help content is for Cash Management features, such as UI for the Data Exchange Framework, import of SEPA CAMT bank statements in W1, NL, and BE, and SEPA Direct Debit in FR, IT, ES, BE, and CH. For more information, see the W1 and local What’s New topics in the CU1Help.zip file.

The CU1Help.zip file contains 89 .htm files with Help topics for application changes in the W1 and six country versions of Microsoft Dynamics NAV 2013 R2 Cumulative Update 1. 58 files are for are new or updated topics in W1 Help. 31 files are for new or updated topics in country-specific Help. The country-specific files are distributed as described in the following table.

Country Name of .htm file in CU1Help.zip Type of change

France (FR)

conWhatsNew[2].htm

tskSetUpPaymentClasses.htm

tskSetUpPaymentSteps.htm

tskCreatePaymentSlips.htm

T_10865_132.htm

T_10860_12.htm

Updated

Updated

Updated

Updated

New

New

Italy (IT)

conWhatsNew[8].htm

tskSetUpAutomaticPaymentsAutomaticBills.htm

R_12176.htm

T_12174_132.htm

T_12177_132.htm

Updated

Updated

Updated

New

New

Spain (ES)

conWhatsNew[16].htm

T_7000006_1200.htm

T_7000005_1200.htm

T_7000007_1200.htm

Updated

New

New

New

Netherlands (NL)

conWhatsNew[7].htm

tskImportReconcileBankStatements.htm

conTelebanking.htm

N_11401.htm

T_11000007_2.htm

T_11000007_10.htm

T_11000007_11.htm

T_11000007.htm

T_11000002_140.htm

Updated

Updated

Updated

Updated

Updated

Updated

Updated

Updated

New

Belgium (BE)

conWhatsNew[4].htm

tskExportPostDomiciliations.htm

T_2000021_10.htm

T_2000022_1201.htm

T_2000022_1200.htm

Updated

Updated

New

New

New

Switzerland (CH)

conWhatsNew[1].htm

T_3010832_1200.htm

Updated

New

The CU1Help.zip file also contains two .png files (with GUID names) that are for images shown in the “About the Data Exchange Framework” topic.

Caution
Help content for the cumulative update is in English language only. If you add the files to a country version of Help, in the [locale] folder, you may replace existing translated help topics with the English versions.

To update Help for an English-only NAV installation

  1. Extract the contents of the CU1Help.zip file to an appropriate location.

  2. Copy the W1-specific .htm files to the en folder on the Help Server. For more information, see Configuring Microsoft Dynamics NAV Help Server.

    See the table in the “Updating Help to Microsoft Dynamics NAV 2013 R2 Cumulative Update 1” section to see which files are not W1-specific.

  3. Select to replace existing files.

  4. Copy the two .png files to the local folder on the Help Server. This provides two images that are displayed in the “About the Data Exchange Framework” topic.

New or updated W1 topics for Microsoft Dynamics NAV 2013 R2 Cumulative Update 1 are now available in Help when the client language is set to English (United States).

To make new or updated country-specific topics available, in English language only, when the client language is set to other languages, see the following procedure.

To update Help for a translated NAV installation

  1. Copy the country-specific .htm files from the CU1Help.zip file. to the [locale] folder on the Help Server.

    See the table in the “Updating Help to Microsoft Dynamics NAV 2013 R2 Cumulative Update 1” section to see which files relate to which country version.

  2. Select to replace existing files if you accept that any translated content in the topics in question will be overwritten with English content.

New or updated country-specific topics for Microsoft Dynamics NAV 2013 R2 Cumulative Update 1 are now available in Help when the client language is set to the relevant language. The new or updated topics are in English language only.

Tip
When you have added the new Help topics, you can add one or more nodes in the Help table of contents, for example to the “Data Exchange Setup” orientation topic or a “What’s New” topic. For more information, see Help Table of Contents.