Skip to main content
Microsoft Dynamics GP forum
Answered

PA Employee Option Schema

editSubscribe (0) ShareShare
ReportReport
Posted on by 40

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.

pastedimage1581451129153v2.png

thanks in advance.

  • Verified answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: PA Employee Option Schema

    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans