ReleaseUpdateDB60_Ledger.updateTaxLedgerAccountGroup 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	updateTaxLedgerAccountGroup
Description	The TaxAccountUnrealizedPay and TaxAccountUnrealizedRec ledger account fields need to be converted to ledger dimension fields, that is TaxUnrealizedPayablesLedgerDimension and TaxUnrealizedReceivablesLedgerDimension fields.

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
TaxLedgerAccountGroup

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: TaxLedgerAccountGroup	To Table: TaxLedgerAccountGroup
CashDiscIncoming	CashDiscountIncomingLedgerDimension
CashDiscOutgoing	CashDiscountOutgoingLedgerDimension
PennyDiffCust	PennyDifferenceCustomerLedgerDimension
PennyDiffVend	PennyDifferenceVendorLedgerDimension
TaxAccountFreePct	TaxFreePercentLedgerDimension
TaxAccountIncoming	TaxIncomingLedgerDimension
TaxAccountOutgoing	TaxOutgoingLedgerDimension
TaxAccountReport	TaxReportLedgerDimension
TaxAccountUnrealizedPay	TaxUnrealizedPayablesLedgerDimension
TaxAccountUnrealizedRec	TaxUnrealizedReceivablesLedgerDimension
TaxAccountUseTax	TaxUseTaxLedgerDimension
TaxOffsetAccountUseTax	TaxOffsetUseTaxLedgerDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
TaxLedgerAccountGroup	TaxUnrealizedPayablesLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxUnrealizedReceivablesLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	CashDiscountIncomingLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	CashDiscountOutgoingLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	PennyDifferenceCustomerLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	PennyDifferenceVendorLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxFreePercentLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxIncomingLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxOutgoingLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxReportLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxUseTaxLedgerDimension	LedgerDimensionDefaultAccount
TaxLedgerAccountGroup	TaxOffsetUseTaxLedgerDimension	LedgerDimensionDefaultAccount

Deleted Tables or Fields

Table	Field
TaxLedgerAccountGroup	TaxAccountUnrealizedPay
TaxLedgerAccountGroup	TaxAccountUnrealizedRec
TaxLedgerAccountGroup	CashDiscIncoming
TaxLedgerAccountGroup	CashDiscOutcoming
TaxLedgerAccountGroup	PennyDiffCust
TaxLedgerAccountGroup	PeenyDiffVend
TaxLedgerAccountGroup	TaxAccountFreePct
TaxLedgerAccountGroup	TaxAccountIncoming
TaxLedgerAccountGroup	TaxAccountOutcoming
TaxLedgerAccountGroup	TaxAccountReport
TaxLedgerAccountGroup	TaxAccountUseTax
TaxLedgerAccountGroup	TAxOffsetAccountUseTax