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