Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
jowens 8/6/2015 2:58:51 PM

Using TACreateEmployee get an ACTINDX error

I'm trying to use the built in TACreateEmployee Stored procedure to integrate data from our clinical system into our Payroll system of GP.

 When I query the UPR00100 Table all employees have an ACTINDX value of 0 in the table. If I try to pass the 0 into the TACreateEmployee SP (variable named @I_vAccountNumber)it gives me an error validating to the GL00105 table.  If I don't pass the value I get an error from the SP saying that it cannot insert a null into the ACTINDX field. 

Has anybody else encountered this?  My current plan is to populate the value with one validated in the GL table, and then go back through and update that field to a 0 as part of a cleanup script. 

 Here is the sample code I'm working with:


DECLARE @return_value int,

@O_iErrorState int,

@oErrString varchar(255)

EXEC @return_value = [dbo].[taCreateEmployee]

@I_vEMPLOYID = N'123456789',

@I_vLASTNAME = N'Bosephus',

@I_vFRSTNAME = N'Bojangles',

@I_vSOCSCNUM = N'989909523',




@I_vInactive = N'0',

@I_vAccountNumber = @Valid Value here (but I want to push through a 0 or NULL or no value to get it to work w/o this)

@I_vCHANGEDATE_I = N'2015-08-05',

@I_vDefaultFromClass = 1,

@O_iErrorState = @O_iErrorState OUTPUT,

@oErrString = @oErrString OUTPUT

SELECT @O_iErrorState as N'@O_iErrorState',

@oErrString as N'@oErrString'

SELECT 'Return Value' = @return_value


Version: GP 2013
Section: Dynamics GP, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables