Share
Report
4,130Hello, I am using eConnect SQL SP, trying to execute taAnalyticsDistribution SP for a SOP transaction already entered in GP usually eConnect SP return error number if not succeeded,with the code below, it does return any error. not sure what i am missing, any help appreciated DECLARE @return_value int, @O_iErrorState int, @oErrString varchar(255) EXEC @return_value = [dbo].[taAnalyticsDistribution] @I_vDOCNMBR = N'INV0007', @I_vDOCTYPE = 3, @I_vAMOUNT = -200, @I_vACTNUMST = N'000-4100-00', @I_vaaAssignedPercent = 100, @I_vaaSubLedgerAssignID = 1, @I_vDistSequence = 16384, @I_vaaTrxDim = N'TEST', @I_vaaTrxDimCode = N'TEST1', @O_iErrorState = @O_iErrorState OUTPUT, @oErrString = @oErrString OUTPUT SELECT @O_iErrorState as N'@O_iErrorState', @oErrString as N'@oErrString' SELECT 'Return Value' = @return_value
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
