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 |