Dynamics Community Forum Thread Details

Analytics Distribution Issue

Hello,
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

Quick Links

Leaderboard