Compartir a través de


ReleaseUpdateDB60_Vend.updateVendReasonCodes 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

updateVendReasonCodes

Description

Merges reason records from the PurchRFQReasonCode table into the ReasonTable table, and updates related tables.

Affected Modules and Tables

Affected Modules

Accounts payable

Affected Tables

VendRFQJour

VendRFQTrans

PurchRFQTable

PurchRFQLine

ReasonTableRef

Remarks

The reason ID in the PurchRFQReasonCode table has a length of twenty characters, and truncation logic ensures that unique reason IDs will be assigned. The reason ID will be assigned to the ReasonTable.ReasonId field. If it is larger than ten characters, it will be truncated to ten characters. If it does not exist in the ReasonTable table, the assigned ID will be used. If the assigned reason ID already exists in the ReasonTable with the same description, then the Vend property will be set to true if it is false. If the reason ID is matched to a reason ID with a different description, a new reason ID will be assigned by truncating the ID to seven characters, and combining it with a tilde and a unique numeric value. A record that has the assigned ID, the original description and the Vend property of true is inserted into the ReasonTable table. Once a valid reason ID is assigned, the updateReasonCodeReferences method will be called to update the new reason code reference in the VendRFQJour, PurchRFQTable, PurchRFQLine, VendRFQTrans, and ReasonTableRef tables.

Data Migration Section

From Table: PurchRFQReasonCode

To Table: ReasonTable

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

VendRFQJour

ReasonRef

RecId

VendRFQTrans

ReasonRef

RecId

PurchRFQTable

ReasonRef

RecId

PurchRFQLine

ReasonRef

RecId

Deleted Tables or Fields

Table

Field

PurchRFQReasonCode

*