ReleaseUpdateDB60_Cust.updateCustLedgerAccounts 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

updateCustLedgerAccounts

Description

Updates CustInterest field of the CustLedgerAccounts table. Also transforms the old accounts or dimension field to the new account or dimension fields in Microsoft Dynamics AX 2012.

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustLedgerAccounts

Remarks

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

Data Migration Section

From Table: CustLedgerAccounts

To Table: CustLedgerAccounts

ClearingAccount

ClearingLedgerDimension

LiabilitiesForDiscountAccount

LiabilitiesForDiscountLedgerDimension

SumAccount

SummaryLedgerDimension

VATprepaymentsAccount

VATPrepaymentsLedgerDimension

WriteOffAccount

WriteOffLedgerDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

CustLedgerAccounts

ClearingLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

LiabilitiesForDiscountLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

SummaryLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

VATPrepaymentsLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

WriteOffLedgerDimension

LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table

Field

custLedgerAccounts

DEL_InterestCode

CustLedgerAccounts

ClearingAccount

CustLedgerAccounts

LiabilitiesForDiscountAccount

CustLedgerAccounts

SumAccount

CustLedgerAccounts

VATPrepaymentsAccount

CustLedgerAccounts

WriteOffAccount