ReleaseUpdateDB60_Cust.updateCustInvoiceTrans_PL Upgrade Script

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

Class

ReleaseUpdateDB60_Cust

Method

updateCustInvoiceTrans_PL

Description

Migrates the DEL_CorrectionDesc_PL field of the CustInvoiceTrans table to the ReasonRefRecId field.

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustInvoiceTrans

ReasonTableRef

Remarks

The CustInvoiceTrans table used to hold the textual string in the old fields in AX5. The new data model is a field that now holds a surrogate foreign key reference to the ReasonTableRef table.

Data Migration Section

From Table: CustInvoiceTrans

To Table: ReasonTableRef

del_CorrectionDesc_PL

ReasonComment

From Table: ReasonTableRef

To Table: CustInvoiceTrans

RecID

ReasonRefRecId

Deleted Tables or Fields

Table

Field

CustInvoiceTrans

del_CorrectionDesc_PL