ReleaseUpdateDB60_Bank.updateLedgerJournalTransRCashRounding Upgrade Script

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

Class

ReleaseUpdateDB60_Bank

Method

updateLedgerJournalTransRCashRounding

Description

Moves data from the DEL_Rounding_HU and DEL_RoundOffAmount_HU fields of the LedgerJournalTrans table to the ManualRounding_HU and RoundOffCashAmount_HU fields of the LedgerJournalTrans_RCash table.

Affected Modules and Tables

Affected Modules

General ledger

Bank

Affected Tables

LedgerJournalTrans

LedgerJournalTrans_RCash

Remarks

The fields are moved from the LedgerJournalTrans table to the cash module specific LedgerJournalTrans_RCash table.

Data Migration Section

From Table: LedgerJournalTrans

To Table: LedgerJournalTrans_RCash

DEL_Rounding_HU

ManualRounding_HU

DEL_RoundOffAmount_HU

RoundOffCashAmount_HU

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

LedgerJournalTrans_RCash

ManualRounding_HU

NoYes

LedgerJournalTrans_RCash

RoundOffCashAmount_HU

RoundOff

Deleted Tables or Fields

Table

Field

LedgerJournalTrans

DEL_Rounding_HU

LedgerJournalTrans

DEL_RoundOffAmount_HU