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