Hi,
eConnect is not calculating taxes on my SOP Line, please advise. If I use the values on the SOP Entry screen tax is calculated. Here's my SQL code:
declare @p4 nvarchar(20) set @p4=N'' declare @p5 int set @p5=0 exec taGetSopNumber @I_tSOPTYPE=N'4',@I_cDOCID=N'RET',@I_tInc_Dec=1,@O_vSopNumber=@p4 output,@O_iErrorState=@p5 output select @p4, @p5
declare @p8 int set @p8=0 declare @p9 nvarchar(1) set @p9=N'' exec taSopLineIvcInsert @I_vSOPTYPE=4,@I_vSOPNUMBE=@p4,@I_vCUSTNMBR=N'0186', @I_vDOCDATE='2013-07-23 00:00:00',@I_vITEMNMBR=N'HG-910',@I_vQUANTITY=1,@I_vQTYONHND=1,@O_iErrorState=@p8 output,@oErrString=@p9 output,@I_vUNITPRCE=1110 select @p8, @p9
SELECT TAXAMNT, * FROM SOP10200 WHERE SOPNUMBE = @p4
*This post is locked for comments