ReleaseUpdateDB60_Vend.updateVendPaymModeTable Upgrade Script

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

Class

ReleaseUpdateDB60_Vend

Method

updateVendPaymModeTable

Description

The DimUse needs to be converted to the dimensionAttributeSet as per the new accounts and dimension model. Also transforms data from the InterCoAccount field to the InterCompanyLedgerDimension field and from the PaymAccount field to the PaymentLedgerDimension field.

Affected Modules and Tables

Affected Modules

Accounts payable

Affected Tables

VendPaymModeTable

Remarks

This upgrade is required in order to convert the account and dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.

Data Migration Section

From Table: VendPaymModeTable

To Table: VendPaymModeTable

InterCoAccount

InterCompanyLedgerDimension

PaymAccount

PaymentLedgerDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

VendPaymModeTable

DimensionAttributeSet

DimensionEnumeration

VendPaymModeTable

InterCompanyLedgerDimension

LedgerDimensionDefaultAccount

VendPaymModeTable

PaymentLedgerDimension

LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table

Field

VendPaymModeTable

DimUse

VendPaymModeTable

InterAccount

VendPaymModeTable

PaymAccount