ReleaseUpdateDB60_Basic.updateGDL_CA_BussinessNumber Upgrade Script [AX 2012]

Updated: April 6, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_Basic

Method

updateGDL_CA_BussinessNumber

Description

Updates the CompanyInfo field in the table TaxRegistration_CA with the value from the RecId field of the CompanyInfo table.

Affected Modules

Basic

Affected Tables

TaxRegistration_CA

This upgrade is required in order to properly related records from the CompanyInfo and TaxRegistration_CA tables. In Microsoft Dynamics AX 2009 the BusinessNumber field was a foreign key field for the CompanyInfo table that was related to the TaxRegistration_CA table. In Microsoft Dynamics AX 2012 the CompanyInfo table on the TaxRegistration_CA table is a foreign key.

From Table: CompanyInfo

To Table: TaxRegistration_CA

RecId

CompanyInfo

Table

Field

Extended Data Type

-or- Base Enum

TaxRegistration_CA

CompanyInfo

RefRecId

Table

Field

CompanyInfo

BusinessNumber


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: