Migrate Intercompany from Commerce Gateway to Application Integration Framework (AIF)

Dynamics AX 4.0

Existing installations of Microsoft°Dynamics°AX°3.0 (formerly known as Microsoft Business Solutions–Axapta 3.0) that use Commerce Gateway cannot be migrated in their entirety to the new AIF framework in Microsoft Dynamics AX 4.0 to exchange documents. However, because intercompany functionality (which enables two companies within the same Microsoft Dynamics AX installation to exchange documents as trading partners) relies on a small section of the Commerce Gateway implementation, you can migrate the tables that apply to intercompany functionality into Microsoft Dynamics AX 4.0 for use with AIF. After the tables are migrated, the companies defined in the Commerce Gateway tables can be configured as AIF endpoints, and documents can be exchanged between them.

The tables GatewayOrganization, GatewayOrgRef, and GatewayDocSetup are targeted for migration using the existing upgrade framework.

The tables are mapped as follows:

  • GatewayOrganization to AifEndpoint

  • GatewayOrgRef to AifEndpointConstraint

  • GatewayDocSetup to AifEndpointActionValueMap

This table shows the mapping of the GatewayOrganization to AifEndpoint tables.

Commerce Gateway Field

AIF Field

Comments

GatewayOrgId

String 20 right justified

AifEndpointId

String 30 left justified

The value of this field is the customer/vendor ID in the intercompany organization that represents the current company. This field is mapped directly.

BizTalkOrgId

None

This field is ignored.

Active

Enum: NoYes

No = 0

Yes = 1

Status

Enum: AifEndpointStatus

Disabled = 1

Enabled = 2

This field is used to enable and disable an endpoint configuration.

You must appropriately map enumerations.

TransportIdIn

None

This field is ignored.

Name

String 30

Name

String 30

Free-text.

TransportIdOut

None

This field is ignored.

InterCompanyCompanyId

InterCompanyCompanyId

The company ID of the intercompany organization. This field is mapped directly.

InterCompanyOrg

InterCompanyOrg

When this check box is selected, the record represents an intercompany configuration. This field is mapped directly.

This table shows the mapping of the GatewayOrgRef to AifEndpointConstraint tables.

Commerce Gateway Field

AIF Field

Comments

GatewayOrgId

String 20 right justified

AifEndpointId

String 30 left justified

Foreign key from the AifEndoint table. This field is mapped directly.

RefType

Enum: SysActionRefType

None = 0

Cust = 1

Vend = 2

Type

Enum: AifConstraintType

NotSet = 0

Customer = 1

Vendor = 2

NoConstraint = 3

Warehouse =4

This field provides context for the RefId. That is, it defines whether it is a customer or vendor, and so on.

RefType::Cust maps to AifConstraintType::Customer

RefType::Vend maps to AifConstraintType::Vendor

If the RefType is set to none, that record is ignored.

RefId

String 20 right justified

Status

String 20 right justified

The value of this field is the customer/vendor ID in the current company that is associated with the intercompany organization. This field is mapped directly.

Active

None

This field is ignored.

This table shows the mapping of the GatewayDocSetup to AifEndpointActionValueMap tables.

Commerce Gateway Field

AIF Field

Comments

GatewayOrgId

String 20 right justified

AifEndpointId

String 30 left justified

Foreign key from the AifEndoint table. This field is mapped directly.

ActionId

Enum: SysActionActionId

SalesOrder = 1

PurchOrder = 7

ActionId

String 80

This focuses only on SalesOrder and PurchOrder enumerations because intercompany is developed to use these two options specifically.

The SalesOrder and PurchOrder enumerations are mapped to the #DefaultSalesOrderAction and #DefaultPurchaseRequisitionAction defined in the Intercompany macro.

NoteNote

All other existing fields are mapped directly.


This table shows the mapping of the GatewayDocSetup to AifEndpointActionPolicy tables.

Commerce Gateway Field

AIF Field

Comments

GatewayOrgId

String 20 right justified

AifEndpointId

String 30 left justified

Foreign key from the AifEndoint table. This field is mapped directly.

ActionId

Enum: SysActionActionId

SalesOrder = 1

PurchOrder = 7

ActionId

String 80

This focuses only on SalesOrder and PurchOrder enumerations because intercompany is developed to use these two options specifically.

The SalesOrder and PurchOrder enumerations are mapped to the #DefaultSalesOrderAction and #DefaultPurchaseRequisitionAction defined in the Intercompany macro.

N/A

Status

Status of the endpoint action policy is set to Enabled.

NoteNote

All other fields in the EndpointActionPolicy table are set to their default values.


This table shows the mapping of the GatewayDocSetup to IntercompanyEndpointActionPolicy tables.

Commerce Gateway Field

AIF Field

Comments

GatewayOrgId

String 20 right justified

AifEndpointId

String 30 left justified

Foreign key from the AifEndoint table. This field is mapped directly.

ActionId

Enum: SysActionActionId

SalesOrder = 1

PurchOrder = 7

ActionId

String 80

This focuses only on SalesOrder and PurchOrder enumerations because intercompany is developed to use these two options specifically.

The SalesOrder and PurchOrder enumerations are mapped to the #DefaultSalesOrderAction and #DefaultPurchaseRequisitionAction defined in the Intercompany macro.

NoteNote

All other fields in the IntercompanyEndpointActionPolicy table are set to their default values.


Show: