Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Dex Procedure to create HR Attendance Transactions in Microsoft Dynamics GP


Symptoms

Integration Manager is being used to create payroll transactions. After the transactions are created, HR reconcile is run to create the corresponding HR attendance transactions. This works fine, but has slow performance. The alternative is to create the HR attendance transactions without running the HR reconcile. 

↑ Back to the top


Resolution

Microsoft Dynamics GP runs a series of scripts to save the attendance data. These scripts are running inside of the window context, but they can be called externally as long as you have the necessary transaction information. You can call the hrCommitAttendance() of form uprComputerTrx function, this is in the core GP dictionary. The parameters can be located in the SDK. In order to call this, you have to populate the hrAttendanceData composite field that has the correct data. Here is the data that GP populates it with, be aware, this is in the context of the window to give an idea of what would have to be populated. 


hrAttendanceData:'Attendance TRX Status' of window uprTransactions = ATTENDANCE_STATUS_POSTED;

hrAttendanceData:'Batch Number' of window uprTransactions = 'Batch Number' of window UPR_TRX_Standard_Entry;

hrAttendanceData:'Computer TRX Number' of window uprTransactions = 'Computer TRX Number' of window uprTransactions;

hrAttendanceData:'Employee ID' of window uprTransactions = 'Employee ID' of window uprTransactions;

hrAttendanceData:'Pay Record' of window uprTransactions = 'UPR TRX Code' of window uprTransactions;

hrAttendanceData:'Start Date' of window uprTransactions = 'TRX Beginning Date' of window uprTransactions;

hrAttendanceData:'End Date' of window uprTransactions = 'TRX Ending Date' of window uprTransactions;

hrAttendanceData:'Hours' of window uprTransactions = long('(L) Amount' of window uprTransactions * 100);

hrAttendanceData:'Days Worked' of window uprTransactions = long('(L) DaysWorked' of window uprTransactions * 100);

hrAttendanceData:'Weeks Worked' of window uprTransactions = long('(L) WeeksWorked' of window uprTransactions * 100);

hrAttendanceData:'Attendance Reason' of window uprTransactions = itemname('Attendance Reason DDL' of window uprTransactions,
'Attendance Reason DDL' of window uprTransactions);
hrAttendanceData:'Attendance Type' of window uprTransactions = itemname('Attendance Type DDL' of window uprTransactions,
'Attendance Type DDL' of window uprTransactions);



As soon as the composite is populated, then call hrCommitAttendance() and pass it in. The one remaining issue would be the hrAttendanceData: 'Time Code', GP is populating
this in a way that is not easily accessible from a 3rd party application. This is a required field and the data must be provided by your application.

↑ Back to the top


Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2453011
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 143