ReleaseUpdateDB60_Ledger.updateLedgerClosingTrans 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 |
ReleaseUpdateDB60_Ledger |
Method |
updateLedgerClosingTrans |
Description |
Transforms data from the AccountNum and the Dimension fields to the LedgerDimension field and from the OffsetAccount and Dimension fields to the OffsetLedgerDimension field in the LedgerClosingTrans table. |
Affected Modules and Tables
Affected Modules |
|---|
General ledger |
Affected Tables |
|---|
LedgerClosingTrans |
Remarks
This upgrade is required in order to convert account or dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.
Data Migration Section
From Table: LedgerClosingTrans |
To Table: LedgerClosingTrans |
|---|---|
AccountNum, Dimension |
LedgerDimension |
OffsetAccountNum, Dimension |
OffsetLedgerDimension |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
LedgerClosingTrans |
LedgerDimension |
LedgerDimensionAccount |
LedgerClosingTrans |
OffsetLedgerDimension |
LedgerDimensionAccount |
Deleted Tables or Fields
Table |
Field |
|---|---|
LedgerClosingTrans |
AccountNum |
LedgerClosingTrans |
Dimension |
LedgerClosingTrans |
OffsetAccountNum |