Share via


ReleaseUpdateDB60_Payroll.updatePayrollEarningCode 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

updatePayrollEarningCode

Description

Inserts records into the PayrollEarningCode, PayrollEarningCodeDetail, PayrollEarningExternalReporting_US, PayrollGrossUpEarningCodeReference, and PayrollEarningCodeAccountingRule tables.

Affected Modules and Tables

Affected Modules

Payroll

Affected Tables

PayrollEarningCode

PayrollEarningCodeDetail

PayrollEarningCodeExternalReporting_US

PayrollEarningCodeAccountingRule

Remarks

The records in the PRLPayElements table with the PRLPayElementType::Earning value in the PaymentType field need to be upgraded into the PayrollEarningCode table and the PayrollEarningCodeDetail table. The W2 related BoxLetter and BoxNumber fields are upgraded to the PayrollEarningExternalReporting_US table. For gross earning code, a record in the PayrollGrossUpEarningCodeReference table should be created to reflect the relationship between the gross up earning code and the secondary earning code. Creates records in the PayrollEarningCodeAccountingRule table from the PRLPostingSetupDetails table for the PRLPayElement table records with earning type.

Data Migration Section

From Table: PRLPayElement

To Table: PayrollEarningCode

PayElementCode

EarningCode

PayElementGroup

EarningCode

Description

Description

Imputed

FringeBenefitType

PRL_GTL

FringeBenefitType

PrimaryCode

IsBaseSalaryComponent

CalcOfSal

QuantityUnit

IncludeInRegular

IncludeInPaymentType

Taxable

TaxMethod

From Table: PRLPayElement

To Table: PayrollEarningCodeDetail

PayElementCode

EarningCode

PayElementGroup

EarningCode

From Table: PRLPayElement

To Table: PayrollGrossUpEarningCodeReference

GrossUpEarningCode

GrossUpEarningCode

From Table: PRLPayElement

To Table: PayrollEarningCodeExternalReporting_US

BoxNumber

W2BoxNumber

BoxLabel

W2BoxLabel

From Table: PRLPostingSetupDetails

To Table: PayrollEarningCodeAccountingRule

DataAreaID

LegalEntity

AccountNum

LedgerDimension

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

PayrollEarningCode

PayrollEarningCodeDetail

PayrollGrossUpEarningCodeReference

PayrollEarningCodeExternalReporting_US

PayrollEarningCodeAccountingRule