Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
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 |