philip zhu 7/12/2019 9:50:29 PM

using econnect taUpdateCreateCustomerRcd to update customer class

Hi there I was trying to use this following script to update customer class. But the customer class did not get updated. Appreciate if any one has a clue. Thank you!

using GHTCA

declare @ErrorState int = 0
declare @ErrorString varchar(1000) = ''

exec dbo.taUpdateCreateCustomerRcd
@I_vCUSTNMBR = 'AACTLA00',
@I_vUpdateIfExists = 1,
@I_vCUSTCLAS = 'LOCAL',
@O_iErrorState = @ErrorState,
@oErrString = @ErrorString

if @ErrorState <> 0 select @ErrorState ErrorState, @ErrorString ErrorString

 

Version: GP 2015
Section: Dynamics GP, eConnect, 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
3