Open Forum

Expand all | Collapse all

eConnect: Import multiple AA codes per JE line

  • 1.  eConnect: Import multiple AA codes per JE line

    TOP CONTRIBUTOR
    Posted 10 days ago
    I am trying to import multiple AA codes for a single JE line using eConnect, but only one AA code is being imported.

    Am I missing a value in the taAnalyticsDistribution node? (I am not seeing an additional field for multiple AA codes)  Or is this a limitation of eConnect with AA?


    Example:  JE Line 1 for $123.45

    $40 -> AA Dimension PROJECT, Code 1111
    $60 -> AA Dimension PROJECT, Code 2222
    $23.45 -> AA Dimension PROJECT, Code 3333

    If I enter this manually in GP, it looks like this:


    When I attempt to import this type of transaction with eConnect, only one line appears in Analytical Accounting.



    This is the XML that is submitted to eConnect, with 3 taAnalyticsDistribution nodes for $40, $60, and $23.45 for the same JE Dist Sequence.

    <?xml version="1.0"?>
    <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    	<GLTransactionType>
    		<eConnectProcessInfo xsi:nil="true" />
    		<taRequesterTrxDisabler_Items xsi:nil="true" />
    		<taGLTransactionLineInsert_Items>
    			<taGLTransactionLineInsert>
    				<BACHNUMB>GLTEST</BACHNUMB>
    				<JRNENTRY>3598</JRNENTRY>
    				<SQNCLINE>1</SQNCLINE>
    				<CRDTAMNT>0</CRDTAMNT>
    				<DEBITAMT>123.45</DEBITAMT>
    				<ACTNUMST>999-9999-99</ACTNUMST>
    				<DSCRIPTN>Accrual</DSCRIPTN>
    			</taGLTransactionLineInsert>
    			<taGLTransactionLineInsert>
    				<BACHNUMB>GLTEST</BACHNUMB>
    				<JRNENTRY>3598</JRNENTRY>
    				<SQNCLINE>2</SQNCLINE>
    				<CRDTAMNT>123.45</CRDTAMNT>
    				<DEBITAMT>0</DEBITAMT>
    				<ACTNUMST>888-8888-88</ACTNUMST>
    				<DSCRIPTN>Accrual</DSCRIPTN>
    			</taGLTransactionLineInsert>
    		</taGLTransactionLineInsert_Items>
    		<taAnalyticsDistribution_Items>
    			<taAnalyticsDistribution>
    				<DOCNMBR>3598</DOCNMBR>
    				<AMOUNT>40</AMOUNT>
    				<DistSequence>2</DistSequence>
    				<DistRef>Accrual to project 1111</DistRef>
    				<aaTrxDim>PROJECT</aaTrxDim>
    				<aaTrxDimCode>1111</aaTrxDimCode>
    			</taAnalyticsDistribution>
    			<taAnalyticsDistribution>
    				<DOCNMBR>3598</DOCNMBR>
    				<AMOUNT>60</AMOUNT>
    				<DistSequence>2</DistSequence>
    				<DistRef>Accrual to project 2222</DistRef>
    				<aaTrxDim>PROJECT</aaTrxDim>
    				<aaTrxDimCode>2222</aaTrxDimCode>
    			</taAnalyticsDistribution>
    			<taAnalyticsDistribution>
    				<DOCNMBR>3598</DOCNMBR>
    				<AMOUNT>23.45</AMOUNT>
    				<DistSequence>2</DistSequence>
    				<DistRef>Accrual to project 3333</DistRef>
    				<aaTrxDim>PROJECT</aaTrxDim>
    				<aaTrxDimCode>3333</aaTrxDimCode>
    			</taAnalyticsDistribution>
    		</taAnalyticsDistribution_Items>
    		<taGLTransactionHeaderInsert>
    			<BACHNUMB>GLTEST</BACHNUMB>
    			<JRNENTRY>3598</JRNENTRY>
    			<REFRENCE>June Accrual</REFRENCE>
    			<TRXDATE>6/30/2019 12:00:00 AM</TRXDATE>
    			<TRXTYPE>0</TRXTYPE>
    			<USERID>eConnect</USERID>
    		</taGLTransactionHeaderInsert>
    		<taMdaUpdate_Items xsi:nil="true" />
    	</GLTransactionType>
    </eConnect>




    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------


  • 2.  RE: eConnect: Import multiple AA codes per JE line

    TOP CONTRIBUTOR
    Posted 10 days ago
    I found the solution thanks to a post on DynDeveloper.com -- Thanks @Steve Gray!

    http://dyndeveloper.com/thread.aspx?threadid=5215

    When submitting multiple AA codes for a single distribution line, you must include the aaSubLedgerAssignID node and increment it for each AA code.  The eConnect documentation for this node is inscrutable:

    "The subledger assign lookup ID. To add new distribution lines, use this element and increment its value by 1 for each assignment."


    This is what the corrected XML looks like.  Note that the first taAnalyticsDistribution does not include the aaSubLedgerAssignID node, but the second and third do include the node.

    <?xml version="1.0"?>
    <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    	<GLTransactionType>
    		<eConnectProcessInfo xsi:nil="true" />
    		<taRequesterTrxDisabler_Items xsi:nil="true" />
    		<taGLTransactionLineInsert_Items>
    			<taGLTransactionLineInsert>
    				<BACHNUMB>GLTEST</BACHNUMB>
    				<JRNENTRY>3600</JRNENTRY>
    				<SQNCLINE>1</SQNCLINE>
    				<CRDTAMNT>0</CRDTAMNT>
    				<DEBITAMT>123.45</DEBITAMT>
    				<ACTNUMST>999-9999-99</ACTNUMST>
    				<DSCRIPTN>Accrual</DSCRIPTN>
    			</taGLTransactionLineInsert>
    			<taGLTransactionLineInsert>
    				<BACHNUMB>GLTEST</BACHNUMB>
    				<JRNENTRY>3600</JRNENTRY>
    				<SQNCLINE>2</SQNCLINE>
    				<CRDTAMNT>123.45</CRDTAMNT>
    				<DEBITAMT>0</DEBITAMT>
    				<ACTNUMST>888-8888-88</ACTNUMST>
    				<DSCRIPTN>Accrual</DSCRIPTN>
    			</taGLTransactionLineInsert>
    		</taGLTransactionLineInsert_Items>
    		<taAnalyticsDistribution_Items>
    			<taAnalyticsDistribution>
    				<DOCNMBR>3600</DOCNMBR>
    				<AMOUNT>40</AMOUNT>
    				<DistSequence>2</DistSequence>
    				<DistRef>Accrual to project 1111</DistRef>
    				<aaTrxDim>PROJECT</aaTrxDim>
    				<aaTrxDimCode>1111</aaTrxDimCode>
    			</taAnalyticsDistribution>
    			<taAnalyticsDistribution>
    				<DOCNMBR>3600</DOCNMBR>
    				<AMOUNT>60</AMOUNT>
    				<DistSequence>2</DistSequence>
    				<DistRef>Accrual to project 2222</DistRef>
    				<aaTrxDim>PROJECT</aaTrxDim>
    				<aaTrxDimCode>2222</aaTrxDimCode>
    				<aaSubLedgerAssignID>2</aaSubLedgerAssignID>
    			</taAnalyticsDistribution>
    			<taAnalyticsDistribution>
    				<DOCNMBR>3600</DOCNMBR>
    				<AMOUNT>23.45</AMOUNT>
    				<DistSequence>2</DistSequence>
    				<DistRef>Accrual to project 3333</DistRef>
    				<aaTrxDim>PROJECT</aaTrxDim>
    				<aaTrxDimCode>3333</aaTrxDimCode>
    				<aaSubLedgerAssignID>3</aaSubLedgerAssignID>
    			</taAnalyticsDistribution>
    		</taAnalyticsDistribution_Items>
    		<taGLTransactionHeaderInsert>
    			<BACHNUMB>GLTEST</BACHNUMB>
    			<JRNENTRY>3600</JRNENTRY>
    			<REFRENCE>June Accrual</REFRENCE>
    			<TRXDATE>6/30/2019 12:00:00 AM</TRXDATE>
    			<TRXTYPE>0</TRXTYPE>
    			<USERID>eConnect</USERID>
    		</taGLTransactionHeaderInsert>
    		<taMdaUpdate_Items xsi:nil="true" />
    	</GLTransactionType>
    </eConnect>


    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role