ReleaseUpdateTransformDB40_Ledger.currencyLedgerAccountPreProcessing 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	ReleaseUpdateTransformDB40_Ledger
Method	currencyLedgerAccountPreProcessing
Description	Updates account number data from the Currency table to the CurrencyLedgerGainLossAccount table.
Script Type	Preprocessing 60: Live
Microsoft Dynamics AX Source	Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
Currency

Remarks

One record is created in the CurrencyLedgerGainLossAccount table for each account in the Currency table.

Data Migration Section

From Table: Currency	To Table: CurrencyLedgerGainLossAccount
CurrencyCode	CurrencyCode
LedgerAccountLoss	LedgerDimension
LedgerAccountNonrealLoss	LedgerDimension
LedgerAccountNonrealProfit	LedgerDimension
LedgerAccountProfit	LedgerDimension
	Ledger
	AccountType

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
CurrencyLedgerGainLossAccount

Deleted Tables or Fields

Table	Field
Currency	LedgerAccountLoss
Currency	LedgerAccountNonrealLoss
Currency	LedgerAccountNonrealProfit
Currency	LedgerAccountProfit