ReleaseUpdateDB60_Ledger.updateRTax25LedgerDimensions_RU 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 |
updateRTax25LedgerDimensions_RU |
Description |
Updates the DimensionAttribute fields in the RTax25Parameters table. Converts data from the old account fields to the new LedgerDimension type in the RTax25LedgerInterval, RTax25RegisterParameters, and RTax25TaxTable tables. |
Affected Modules and Tables
Affected Modules |
|---|
General ledger |
Affected Tables |
|---|
RTax25Parameters |
RTax25LedgerInterval |
RTax25RegisterParameters |
RTax25TaxTable |
Remarks
This upgrade is required in order to convert account/dimension data to the new accounts and dimension model for 6.0.
Data Migration Section
From Table: RTax25LedgerInterval |
To Table: RTax25LedgerInterval |
|---|---|
AccountFrom |
FromMainAccountId |
AccountTo |
ToMainAccountId |
From Table: RTax25RegisterParameters |
To Table: RTax25RegisterParameters |
|---|---|
Parameter |
LedgerDimension |
From Table: RTax25TaxTable |
To Table: RTax25TaxTable |
|---|---|
ExportVATFineLedgerAccount |
ExportVATFineLedgerDimension |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
RTax25LedgerInterval |
FromMainAccountId |
RefRecId |
RTax25LedgerInterval |
ToMainAccountId |
RefRecId |
RTax25RegisterParameters |
LedgerDimension |
LedgerDimensionDefaultAccount |
RTax25TaxTable |
ExportVATFineLedgerDimension |
LedgerDimensionDefaultAccount |
RTax25Parameters |
DimensionAttribute |
RefRecId |
Deleted Tables or Fields
Table |
Field |
|---|---|
RTax25LedgerInterval |
AccountFrom |
RTax25LedgerInterval |
AccountTo |
RTax25TaxTable |
ExportVATFineLedgerAccount |