Dynamics GP‎ > ‎

Create a customer record using econnect

create Procedure spICB_CustomerIntegration as
Begin
Set nocount on

--exec spICB_CustomerIntegration

--select * from rm00101 where custnmbr='DJDJDJD'

declare @O_iErrorState int, @oErrString varchar(255), @errordesc nvarchar(100)
select @O_iErrorState = 0
if (@O_iErrorState = 0)
 begin
     exec taupdatecreatecustomerrcd
@I_vCustnmbr='DJDJDJD',
@I_vCustname='Devin Johnson3',
@I_vADRSCODE='PRIMARY',
@O_iErrorState =  @O_ierrorstate output,
 @oErrString = @oErrString output
 end
IF @O_iErrorState <> 0 
Begin  
Set @errorDesc = (select errordesc from dynamics.dbo.taerrorcode where errorcode = @O_iErrorState)
select @oErrString
select @errorDesc
End
 
end
 
Comments