ReleaseUpdateDB60_Payroll.updatePayrollEmployerTaxRegion Upgrade Script [AX 2012]

Updated: November 9, 2011

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

Payroll

Affected Tables

PAYROLLEMPLOYERTAXREGION

PRLNEXUS

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.

From Table: PrlNexus

To Table: PayrollEmployerTaxRegion

GNISLocation

GNIS

Country

CountryRegionId

State

StateId

dataAreaId

LegalEntity


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: