/
Release2ERP for AX 2012

Release2ERP for AX 2012

END OF SUPPORT

Dynamics AX 2012 is no longer supported by Perfion after version 2024-R1

Perfion Release2ERP for AX2012 allows you to import and persist information from Perfion to the AX environment.

If you have special use cases or need custom setup tailored to your needs, please contact your Perfion partner for more information.

FAQ regarding installation of Perfion Release2ERP for AX

Perfion Release2ERP for AX 2012 allows you to import and persist information from Perfion to the AX environment.

This document will describe the installation and configuration of Perfion Release2ERP for the typical AX environment. If you have special use cases or need custom setup tailored to your needs, please contact your Perfion representative for more information.

Prerequisites

Supported AX Versions

The following versions of Microsoft Dynamics AX is supported by this solution:

  • Microsoft Dynamics AX 2012.

Perfion Release2ERP also exists for several other Dynamics versions. Please go to Perfion Knowledge Base for the latest compatibility overview.

A Word of Caution

Any changes made to you ERP system should be tested in a proper test environment before being deployed to the live ERP system. Please consult with your Microsoft Dynamics Partner about the changes required to implement this software, before continuing further.

Installation

Installing Release2ERP consists of the following four steps.

Installation of web service communications assembly

Install the Perfion.WebService.dll and Perfion.WebService.XmlSerializers.dll files into the Dynamics AX server bin folder or into the Windows global assembly cache folder on the AOS. As well as to the Client itself.

Install AX customizations

Install the supplied model files into the target environment.

Add Perfion menu to main menu

The main menu modification is not included in module - to simplify the installation (no overlapping in SYS/SYP). To add the Perfion menu to the main menu, open the developer section (ctrl+d) and go to the Menus section.
Now open the MainMenu(sys,var). After this is open you should in the Menus folder structure have a folder named PF_Release2AX(var). now drag this folder into the MainMenu(sys,var) and then you should have the Perfion Release2AX in the main menu of AX2012.

Synchronize + compile application

Synchronize the data dictionary and compile the application.

Configuration

Release2ERP is a very versatile tool that can be configured to fit many different use cases. In this document, we will show simple examples that illustrate what is possible and discuss the options available.

Basic settings in Release2ERP

To set up integrations to Perfion we need to create a few base settings first.

Connections

Connections specifies the source of the data you want to import using Release2ERP. This can be a web service or a local XML file. Before creating a new connection, you need to make sure that you have the right URL for the Perfion API service.

  1. Navigate to the Perfion menu > Setup > Connections

  2. Click the New icon or press Ctrl + N to create a new record.

  3. Assign the connection a meaningful name.

  4. Select the query type (typically Web service) unless you want to test using a local file.

  5. On the General tab you must specify the URL to the Perfion API service (see below for a sample screenshot).

A good way to avoid issues is always to check the URL in a browser before putting it in the connection string, just to make sure you have an open API.

If Authentication has been enabled on the Perfion API end point, you will need to specify username and password on the Authentication tab.

You will need to save the password for each AOS if you have multiple AOS’es in your environment (log on to AX on every AOS). AX 2012 encryption is done using a fingerprint from the AOS Windows machine. This is also the way standard AX saves SMTP passwords.

Setting up a Release2ERP Integration

Open the Integration menu item in the root of the Perfion menu.

Click the New icon or press Ctrl + N to create a new record.

Header fields

The Overview tab of the integration contains setup elements for the integration.

Integration: This is the unique identifier for this integration.

Description: A short description of the integration.

Connection: Select from the list of connections you have created earlier.

XPath root: Root node containing data from Perfion. Defaults to //Data/Product. Change this value if it does not reflect data in your Perfion database.

Update multiple records: Allow updating multiple records when finding existing records matching criteria. This is relevant if multiple records exist in the AX database based on the field mappings and Perfion data. Choose Yes to update possible duplicates. Choose No to skip updates. Choose Error to stop the import when finding multiple records.

Latest import: Latest execution date and time. Not editable.

The Query tab contains a large text field where you can edit the Perfion query. For information about how to write a query, please see the Perfion API documentation.

Use the wildcard %d to insert date and time of latest import into the query. For example, into the where clause to filter records older than a specific time. When the query is executed, %d will be replaced with date and time.

The following is an example query:

<Query>       <Select languages='EN, DE' view='Normal'>             <Feature id='ItemNumber' />             <Feature id='ShortText' />             <Feature id='Description' />             <Feature id='Image' />       </Select>       <From id ='Product'/>       <Where>             <Clause id='brand' operator='=' value="Normal" />             <Clause id='ModifiedDate' operator='>' value="%d" />       </Where> </Query>

Field mapping