Share via


ReleaseUpdateDB60_Basic.updateEmplAdvanceHoldersDimensions_RU 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_Basic

Method

updateEmplAdvanceHoldersDimensions_RU

Description

Transforms data from the LedgerAccountProfit and LedgerAccountLoss fields to the ProfitLedgerDimension and LossLedgerDimension fields in the EmplParameters_RU table

Affected Modules and Tables

Affected Modules

General ledger

Affected Tables

EmplParameters_RU

EmplLedgerAccounts_RU

EmplGroup_RU

Remarks

This upgrade is required in order to convert account/dimension data to the new accounts and dimension model for 6.0

Data Migration Section

From Table: EmplParameters_RU

To Table: EmplParameters_RU

LedgerAccountProfit

ProfitLedgerDimension

LedgerAccountLoss

LossLedgerDimension

From Table: EmplLedgerAccounts_RU

To Table: EmplLedgerAccounts_RU

SumAccount

SummaryLedgerDimension

From Table: EmplGroup_RU

To Table: EmplGroup_RU

OffsetLedgerAccount

OffsetLedgerDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

EmplParameters_RU

ProfitLedgerDimension

LedgerDimensionDefaultAccount

EmplParameters_RU

LossLedgerDimension

LedgerDimensionDefaultAccount

EmplLedgerAccounts_RU

SummaryLedgerDimension

LedgerDimensionDefaultAccount

EmplGroup_RU

OffsetLedgerDimension

LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table

Field

EmplParameters_RU

LedgerAccountProfit

EmplParameters_RU

LedgerAccountLoss

EmplLedgerAccounts_RU

SumAccount

EmplGroup_RU

OffsetLedgerAccount