ReleaseUpdateDB60_Payroll.updatePayrollEmployerTaxRegion 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_Payroll
Method	updatePayrollEmployerTaxRegion
Description	Inserts records into the PayrollEmployerTaxRegion table from the PRLNexus table.

Affected Modules and Tables

Affected Modules
Payroll

Affected Tables
PAYROLLEMPLOYERTAXREGION
PRLNEXUS

Remarks

This upgrade will retain the data of each company by assigning the LegalEntity field to the RecId of the CompanyInfo record associated to the old dataAreaId field. In Microsoft Dynamics AX 2009, there were zip code level nexus records. However, this concept was removed for Microsoft Dynamics AX 2012 and only the state level records will be upgraded.

Data Migration Section

From Table: PrlNexus	To Table: PayrollEmployerTaxRegion
GNISLocation	GNIS
Country	CountryRegionId
State	StateId
dataAreaId	LegalEntity