Dynamics Community Forum Thread Details

eConnect GL Transaction with Analytics receiving Error

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

Quick Links

Leaderboard