ReleaseUpdateDB60_Cust.updateCustLedgerAccounts Upgrade Script [AX 2012]

Updated: July 19, 2010

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

Accounts receivable

Affected Tables

CustLedgerAccounts

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

From Table: CustLedgerAccounts

To Table: CustLedgerAccounts

ClearingAccount

ClearingLedgerDimension

LiabilitiesForDiscountAccount

LiabilitiesForDiscountLedgerDimension

SumAccount

SummaryLedgerDimension

VATprepaymentsAccount

VATPrepaymentsLedgerDimension

WriteOffAccount

WriteOffLedgerDimension

Table

Field

Extended Data Type

-or- Base Enum

CustLedgerAccounts

ClearingLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

LiabilitiesForDiscountLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

SummaryLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

VATPrepaymentsLedgerDimension

LedgerDimensionDefaultAccount

CustLedgerAccounts

WriteOffLedgerDimension

LedgerDimensionDefaultAccount

Table

Field

custLedgerAccounts

DEL_InterestCode

CustLedgerAccounts

ClearingAccount

CustLedgerAccounts

LiabilitiesForDiscountAccount

CustLedgerAccounts

SumAccount

CustLedgerAccounts

VATPrepaymentsAccount

CustLedgerAccounts

WriteOffAccount


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: