ReleaseUpdateDB60_Payroll.updatePayrollEarningCode Upgrade Script [AX 2012]
Updated: June 15, 2012
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. |
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.
|
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 |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).