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_vDEPRTMNT = N'BERK',
@I_vEMPLCLAS = N'FARM',
@I_vJOBTITLE = N'OT',
@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
GO