ReleaseUpdateDB60_Asset.updateRAssetLedgerAccounts_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_Asset
Method	updateRAssetLedgerAccounts_RU
Description	Transforms data from the AssetLedgerAccount and AssetLedgerOffsetAccount fields to the AssetLedgerDimension and AssetOffsetLedgerDimension fields in the RAssetLedgerAccounts table

Affected Modules and Tables

Affected Modules
Fixed Asset

Affected Tables
RAssetLedgerAccounts
RAssetLedgerAccountsByLocation

Remarks

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

Data Migration Section

From Table: RAssetLedgerAccounts	To Table: RAssetLedgerAccounts
AssetLedgerAccount	AssetLedgerDimension
AssetLedgerOffsetAccount	AssetOffsetLedgerDimension

From Table: RAssetLedgerAccountsByLocation	To Table: RAssetLedgerAccountsByLocation
AssetLedgerAccount	AssetLedgerDimension
LedgerAccountForDepreciationBonus	DepreciationBonusLedgerDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
RAssetLedgerAccounts	AssetLedgerDimension	LedgerDimensionDefaultAccount
RAssetLedgerAccounts	AssetOffsetLedgerDimension	LedgerDimensionDefaultAccount
RAssetLedgerAccountsByLocation	AssetLedgerDimension	LedgerDimensionDefaultAccount
RAssetLedgerAccountsByLocation	DepreciationBonusLedgerDimension	LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table	Field
RAssetLedgerAccounts	AssetLedgerAccount
RAssetLedgerAccounts	AssetLedgerOffsetAccount
RAssetLedgerAccountsByLocation	AssetLedgerAccount
RAssetLedgerAccountsByLocation	LedgerAccountForDepreciationBonus