ReleaseUpdateTransformDB50_Ledger.currencyPreProcessing 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	ReleaseUpdateTransformDB50_Ledger
Method	currencyPreProcessing
Description	Updates the Currency table to be a shared table.
Script Type	Preprocessing 60: Live
Microsoft Dynamics AX Source	Microsoft Dynamics AX 4.0 Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
Currency

Remarks

This script will populate the Shadow_Currency table with the currencies selected in the prepare currencies for upgrade task. This scripts needs to be run after the prepare currencies for upgrade task. The prepare currencies for upgrade task will populate the CurrencyUpgradeParameters, CurrencyUpgradeSelection, and CurrencyUpgradeGlobal tables.

Data Migration Section

From Table: Currency	To Table: CurrencyOnlineConversion
CurrencyCode	CurrencyCode
CurrencyPrefix	Name
CurrencySuffix	Name
	Affix

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
CurrencyEuroDenomination
CurrencyOnlineConversion
Currency	IsEuro	NoYes
Currency	RoundingPrecision	RoundOff

Deleted Tables or Fields

Table	Field
Currency	RoundOffAmountType
Currency	RoundOffProject
Currency	RoundOffTypeProject
Currency	OnLineConversionTool
Currency	CurrencyPrefix
Currency	CurrencySuffix