ReleaseUpdateDB60_Payroll.updatePayrollPayStatement Upgrade Script
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Class |
ReleaseUpdateDB60_Payroll |
Method |
updatePayrollPayStatement |
Description |
Inserts records into the PayrollPayStatement table from the PrlEmployeePayElementsTransPosted table. |
Affected Modules and Tables
Affected Modules |
|---|
Payroll |
Affected Tables |
|---|
PayrollPayStatement |
Remarks
This upgrade will create records in the PayrollPayStatement table from the PrlEmployeePayElementsTransPosted table records that are posted and paid. Creates required document numbers based on the number sequence.
Data Migration Section
From Table: PRLEmployeePayElementsTransPosted |
To Table: PayrollPayStatement |
|---|---|
Worker |
Worker |
PaymMode |
PaymentMethodType |
VoidPost |
IsReversed |
PaymentDate |
PaymentDate |
RunType |
PaymentType |
SalaryExpenseJournalId |
PaymentJournalBatchNum |
From Table: PRLEmployeePayElementsTrans |
To Table: PayrollPayStatement |
|---|---|
Amount |
GrossAccountingCurrencyAmount |
Amount |
NetAccountingCurrencyAmount |
From Table: DEL_PRLPayrollPeriod |
To Table: PayrollPayStatement |
|---|---|
RecId |
PayPeriod |
From Table: PRLEmployeePayElementsTransPosted |
To Table: DocuRef |
|---|---|
txt |
Notes |
PayElementDate |
createdDateTime |
From Table: PRLEmployeePayElementsTrans |
To Table: DocuRef |
|---|---|
DataAreaId |
RefCompanyId |
From Table: PayrollPayStatement |
To Table: DocuRef |
|---|---|
RecId |
RefRecId |
TableId |
RefTableId |