ReleaseUpdateTransformDB50_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 |
ReleaseUpdateTransformDB50_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 Microsoft Dynamics AX 2009 |
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 |
From Table: |
To Table: |
|---|---|
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 |