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

Affected Modules and Tables

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

New Tables or Fields

Deleted Tables or Fields