ReleaseUpdateDB60_Asset.updateAssetBudget Upgrade Script

  • Article

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

updateAssetBudget

Description

Transforms data from the LedgerAccount and the Dimension field to the LedgerDimension field and the LedgerAccountOffset and the Dimension fields to the OffsetLedgerDimension field in the AssetBudget table.

Affected Modules and Tables

Affected Modules

Fixed Asset

Affected Tables

AssetBudget

Remarks

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

Data Migration Section

From Table: AssetBudget

To Table: AssetBudget

LedgerAccount, Dimension

LedgerDimension

LedgerAccountOffset, Dimension

OffsetLedgerDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

AssetBudget

LedgerDimension

LedgerDimensionDefaultAccount

AssetBudget

OffsetLedgerDimension

LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table

Field

AssetBudget

LedgerAccount

AssetBudget

Dimension

AssetBudget

LedgerAccountOffset