ReleaseUpdateDB60_Bank.updateExchAdjPL Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Class	ReleaseUpdateDB60_Bank
Method	updateExchAdjPL
Description	Upgrades script for the exchange adjustment feature for PL.

Affected Modules and Tables

Affected Modules
Bank
Bank

Affected Tables
BankAccountTransPL
LedgerJournalTrans_RCash

Remarks

The upgrade script is necessary due to the following changes in the data model from previous version. 1. The country/region specific fields have been moved from the BankAccounTrans table to the BankAccountTransPL table. 2. The country/region specific fields have been moved from the ledgerJournalTrans table to the LedgerJournalTrans_RCash table.

Data Migration Section

From Table: LedgerJournalTrans	To Table: LedgerJournalTrans_Rcash
DEL_ExcludeExchAdj_PL	ExcludeExchAdj_PL

From Table: BankAccountTrans	To Table: BankAccountTransPL
DEL_ExchAdjustment_PL	ExchAdjustment_PL
DEL_ExcludeExchAdj_PL	ExcludeExchAdj_PL
DEL_SettleAmountCur_PL	SettleAmountCur_PL
DEL_SettleAmountMST_PL	SettleAmountMST_PL

Deleted Tables or Fields

Table	Field
BankAccountTrans	DEL_ExchAdjustment_PL
BankAccountTrans	DEL_ExcludeExchAdj_PL
BankAccountTrans	DEL_SettleAmountCur_PL
BankAccountTrans	DEL_SettleAmountMST_PL
LedgerJournalTrans	DEL_ExcludeExchAdj_PL