ReleaseUpdateDB60_Cust.updateCustIntTransLedgerEntRef 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_Cust

Method

updateCustIntTransLedgerEntRef

Description

Updates the CustInterestTrans.LedgerEntryReference field by matching the CustInterestJour.LedgerVoucher field with the LedgerEntryReference.ReferenceNumber field.

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustInterestTrans

Remarks

The LedgerVoucher field of the CustInterestJour table will now be storing only Fee vouchers and not the transaction voucher. To upgrade the old data, this method will copy Fee voucher data to the vouchers of interest note transactions.

Data Migration Section

From Table: CustInterestJour

To Table: CustInterestTrans

FeeVoucher

LedgerEntryReference

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

CustInterestTrans

LedgerEntryReference

RefRecId

Name Changes for Tables or Fields

Old Table Name:

New Table Name:

Old Field Name:

New Field Name:

CustInterestJour.LedgerVoucher

CustInterestJour.FeeVoucher