Dynamics Community Forum Thread Details

PA Employee Option Schema

Hi, I'm trying to create an employee using eConnect. There are options in the Project tab from the employee window that I do not know how to set.

Which xml Node refers to the PA Employee Options windows in GP?

The specific fields I'm looking to set are ProfitType for TM, Markup Percent for TM, and Percentage of Actual Cost.

thanks in advance.

Categories:

Microsoft Dynamics GP

Hello,

In reviewing the eConnect Programmers guide, there is not a node that will update this information by default. You would have to use the 5 developer fields to pass in this information, then in the taCreateEmployeePost.sql stored procedure, you could write an insert statement for the PA00601 for this employee and use the developer fields to pass in the values that you wish for each field that you listed, and hard code the remaining fields with their defaults.

@I_vUSRDEFND1 char(50) = '', /* User Defined field - developer use only */

@I_vUSRDEFND2 char(50) = '', /* User Defined field - developer use only */

@I_vUSRDEFND3 char(50) = '', /* User Defined field - developer use only */

@I_vUSRDEFND4 varchar(8000) = '', /* User Defined field - developer use only */

@I_vUSRDEFND5 varchar(8000) = '', /* User Defined field - developer use only */

For example, below in my insert i used the employee id variable from the eConnect Stored Procedure, and you could replace any of the hard coded values below with your deveoper fields for user defined 1-5 for your desired changes to the project window for the employee.

insert into PA00601 Values(

@I_vEMPLOYID, 0, 0, 0, 0, 0,

1, '', '', 0, '', '',

0, '1900-01-01', '1900-01-01', 0, 0, 0,

'Hour', 0, 1, 0, 0, 0, 3,

0, 0, 3, 0, 0, '',

0, 0, 0, '', '', 0)

I hope this at least gets you started in the right direction.

Thanks!

Isaac Olson

Microsoft Support

Quick Links