You’re offline. This is a read only version of the page.
20
Hi, I am trying to process a GL transaction through eConnect. The example transaction (to keep it simple) contains 1 line of Analytics Distribution but it seems to keep returning the same error no matter what I try.
Error Number = 9469 Stored Procedure taAnalyticsDistribution Error Description = Cannot find a distribution amount based on input values
Here is the xml that is being submitted:
<eConnect>
<GLTransactionType>
<eConnectProcessInfo p3:nil="true" xmlns:p3="http://www.w3.org/2001/XMLSchema-instance" />
<taRequesterTrxDisabler_Items p3:nil="true" xmlns:p3="http://www.w3.org/2001/XMLSchema-instance" />
<taGLTransactionLineInsert_Items>
<taGLTransactionLineInsert>
<BACHNUMB>CDGL0001</BACHNUMB>
<JRNENTRY>3460</JRNENTRY>
<SQNCLINE>16384</SQNCLINE>
<CRDTAMNT>25</CRDTAMNT>
<DEBITAMT>0</DEBITAMT>
<ACTNUMST>000-1100-00</ACTNUMST>
<DSCRIPTN>Test trans</DSCRIPTN>
</taGLTransactionLineInsert>
<taGLTransactionLineInsert>
<BACHNUMB>CDGL0001</BACHNUMB>
<JRNENTRY>3460</JRNENTRY>
<SQNCLINE>32768</SQNCLINE>
<CRDTAMNT>0</CRDTAMNT>
<DEBITAMT>25</DEBITAMT>
<ACTNUMST>000-1100-00</ACTNUMST>
<DSCRIPTN>Test trans</DSCRIPTN>
</taGLTransactionLineInsert>
</taGLTransactionLineInsert_Items>
<taAnalyticsDistribution_Items>
<taAnalyticsDistribution>
<DOCNMBR>3460</DOCNMBR>
<aaTrxDim>DIM1</aaTrxDim>
<aaTrxDimCode>DIM1CODE3</aaTrxDimCode>
</taAnalyticsDistribution>
</taAnalyticsDistribution_Items>
<taGLTransactionHeaderInsert>
<BACHNUMB>CDGL0001</BACHNUMB>
<JRNENTRY>3460</JRNENTRY>
<REFRENCE>CDGL000120120405</REFRENCE>
<TRXDATE>2017/03/06</TRXDATE>
<TRXTYPE>0</TRXTYPE>
</taGLTransactionHeaderInsert>
<taMdaUpdate_Items p3:nil="true" xmlns:p3="http://www.w3.org/2001/XMLSchema-instance" />
</GLTransactionType>
</eConnect>
What I suspect is that in my code I am trying to associate the the analytics line to a GL transaction line through the use of line sequence number. When I attempt to set this value and attempt to set the Doc Type to 0 the values are not reflected in the eConnect serialized xml.
I have been trying a bunch of different scenarios, playing with values in an attempt to get the transaction to go through but I just keep getting the same error.
Regards,
Mike
*This post is locked for comments
I have the same question (0)
Hi Michael,
providing the fields that values appear default from setup results the same error?
Thanks,
Nataraj S
Share
Report
All responses (
Answers (
