ReleaseUpdateDB60_Payroll.updatePayrollPayStatementTaxLine Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Class |
ReleaseUpdateDB60_Payroll |
Method |
updatePayrollPayStatementTaxLine |
Description |
Inserts records into the PayrollPayStatementTaxLine table from the PrlEmployeePayElementsTrans table. |
Affected Modules and Tables
Affected Modules |
|---|
Payroll |
Affected Tables |
|---|
PayrollPayStatementTaxLine |
PRLEmployeePayElementsTransPosted |
PRLEmployeePayElementsTrans |
PrlUSTaxTransactionHistory |
Remarks
This upgrade will create records in the PayrollPayStatementTaxLine table from the PrlEmployeePayElementsTrans table records of the type withholding tax employer tax.
Data Migration Section
From Table: PRLEmployeePayElementsTransPosted |
To Table: PayrollPayStatementTaxLine |
|---|---|
PayElementDate |
AccountingDate |
From Table: PRLEmployeePayElementsTrans |
To Table: PayrollPayStatementTaxLine |
|---|---|
Amount |
AccountingCurrencyAmount |
PaymentLineModified |
IsPayStatementLineOverridden |
From Table: PrlUSTaxTransactionHistory |
To Table: PayrollPayStatementTaxLine |
|---|---|
TaxCode |
TaxCode |