eConnect taAnalyticsDistribution

(0) Share

Report

Posted on by camt

My quest to completely automate my sales hit a roadblock this morning trying to get AA to describe my SOPTransactionType -> taSopLineIvcInsert in eConnect. I've tried every combination of fields I can imagine but nothing seems to work. Perhaps my AA isn't setup correctly.

Can anyone spot on obvious problem with the XML below?

Here is the error returned:

Error Number = 9414 Stored Procedure= taAnalyticsDistribution Error Description = Transaction Dimension assignment does not exist
Node Identifier Parameters: taAnalyticsDistribution
Related Error Code Parameters for Node : taAnalyticsDistribution
aaTrxDimID = Note: This parameter was not passed in, no value for the parameter will be returned.

And the XML:

<?xml version="1.0"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<SOPTransactionType>
		<eConnectProcessInfo xsi:nil="true" />
		<taRequesterTrxDisabler_Items xsi:nil="true" />
		<taUpdateCreateItemRcd xsi:nil="true" />
		<taUpdateCreateCustomerRcd xsi:nil="true" />
		<taCreateCustomerAddress_Items xsi:nil="true" />
		<taSopSerial_Items xsi:nil="true" />
		<taSopLotAuto_Items xsi:nil="true" />
		<taSopLineIvcInsert_Items>
			<taSopLineIvcInsert>
				<SOPTYPE>3</SOPTYPE>
				<SOPNUMBE>REG00000013</SOPNUMBE>
				<CUSTNMBR>001111</CUSTNMBR>
				<DOCDATE>2014-03-19</DOCDATE>
				<ITEMNMBR>BIBL.501</ITEMNMBR>
				<UNITPRCE>451</UNITPRCE>
				<XTNDPRCE>1353.00</XTNDPRCE>
				<QUANTITY>3.00</QUANTITY>
				<PRCLEVEL>GEN</PRCLEVEL>
				<ITEMDESC>Old Testament Foundations</ITEMDESC>
				<LNITMSEQ>16384</LNITMSEQ>
				<DOCID>REG</DOCID>
				<ADDRESS1>Some address</ADDRESS1>
				<ADDRESS2></ADDRESS2>
				<CITY>Some city</CITY>
				<UOFM>Unit</UOFM>
			</taSopLineIvcInsert>
			<taSopLineIvcInsert>
				<SOPTYPE>3</SOPTYPE>
				<SOPNUMBE>REG00000013</SOPNUMBE>
				<CUSTNMBR>001111</CUSTNMBR>
				<DOCDATE>2014-03-19</DOCDATE>
				<ITEMNMBR>REG</ITEMNMBR>
				<UNITPRCE>35</UNITPRCE>
				<XTNDPRCE>35.00</XTNDPRCE>
				<QUANTITY>1.00</QUANTITY>
				<PRCLEVEL>GEN</PRCLEVEL>
				<ITEMDESC>Registration Fee</ITEMDESC>
				<LNITMSEQ>32768</LNITMSEQ>
				<DOCID>REG</DOCID>
				<ADDRESS1>some address</ADDRESS1>
				<ADDRESS2></ADDRESS2>
				<CITY>some city</CITY>
				<UOFM>Each</UOFM>
			</taSopLineIvcInsert>
		</taSopLineIvcInsert_Items>
		<taSopLineIvcInsertComponent_Items xsi:nil="true" />
		<taSopTrackingNum_Items xsi:nil="true" />
		<taSopCommissions_Items xsi:nil="true" />
		<taSopLineIvcTaxInsert_Items xsi:nil="true" />
		<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
		<taSopUserDefined xsi:nil="true" />
		<taSopDistribution_Items>
			<taSopDistribution>
				<SOPTYPE>3</SOPTYPE>
				<SOPNUMBE>REG00000013</SOPNUMBE>
				<SEQNUMBR>16384</SEQNUMBR>
				<DISTTYPE>1</DISTTYPE>
				<ACTNUMST>1-00-000-2119</ACTNUMST>
				<CRDTAMNT>1353.00</CRDTAMNT>
				<CUSTNMBR>001111</CUSTNMBR>
			</taSopDistribution>
			<taSopDistribution>
				<SOPTYPE>3</SOPTYPE>
				<SOPNUMBE>REG00000013</SOPNUMBE>
				<SEQNUMBR>32768</SEQNUMBR>
				<DISTTYPE>1</DISTTYPE>
				<ACTNUMST>1-07-000-5137</ACTNUMST>
				<CRDTAMNT>35.00</CRDTAMNT>
				<CUSTNMBR>001111</CUSTNMBR>
			</taSopDistribution>
			<taSopDistribution>
				<SOPTYPE>3</SOPTYPE>
				<SOPNUMBE>REG00000013</SOPNUMBE>
				<SEQNUMBR>49152</SEQNUMBR>
				<DISTTYPE>2</DISTTYPE>
				<ACTNUMST>1-00-000-1101</ACTNUMST>
				<DEBITAMT>1388</DEBITAMT>
				<CUSTNMBR>001111</CUSTNMBR>
			</taSopDistribution>
		</taSopDistribution_Items>
		<taAnalyticsDistribution_Items>
			<taAnalyticsDistribution>
				<DOCNMBR>REG00000013</DOCNMBR>
				<DOCTYPE>3</DOCTYPE>
				<aaAssignedPercent>100</aaAssignedPercent>
				<DistSequence>16384</DistSequence>
				<ACTNUMST>1-00-000-2119</ACTNUMST>
				<DistRef>16384</DistRef>
				<aaTrxDim>TERM</aaTrxDim>
				<aaTrxDimCode>2015FA</aaTrxDimCode>
				<aaTrxDimID>3</aaTrxDimID>
				<aaTrxCodeID>8</aaTrxCodeID>
			</taAnalyticsDistribution>
			<taAnalyticsDistribution>
				<DOCNMBR>REG00000013</DOCNMBR>
				<DOCTYPE>3</DOCTYPE>
				<aaAssignedPercent>100</aaAssignedPercent>
				<DistSequence>32768</DistSequence>
				<ACTNUMST>1-07-000-5137</ACTNUMST>
				<DistRef>32768</DistRef>
				<aaTrxDim>TERM</aaTrxDim>
				<aaTrxDimCode>2015FA</aaTrxDimCode>
				<aaTrxDimID>3</aaTrxDimID>
				<aaTrxCodeID>8</aaTrxCodeID>
			</taAnalyticsDistribution>
		</taAnalyticsDistribution_Items>
		<taSopMultiBin_Items xsi:nil="true" />
		<taSopHdrIvcInsert>
			<SOPTYPE>3</SOPTYPE>
			<DOCID>REG</DOCID>
			<SOPNUMBE>REG00000013</SOPNUMBE>
			<DOCDATE>2014-03-19</DOCDATE>
			<CUSTNMBR>001111</CUSTNMBR>
			<CUSTNAME>Some customer</CUSTNAME>
			<ADDRESS1>Some street</ADDRESS1>
			<ADDRESS2></ADDRESS2>
			<CITY>Some city</CITY>
			<STATE>MB</STATE>
			<ZIPCODE>some zip</ZIPCODE>
			<COUNTRY>CA</COUNTRY>
			<SUBTOTAL>1388</SUBTOTAL>
			<DOCAMNT>1388</DOCAMNT>
			<BACHNUMB>20140319</BACHNUMB>
			<CREATEDIST>0</CREATEDIST>
			<DSCDLRAM>0</DSCDLRAM>
			<PRCLEVEL>GEN</PRCLEVEL>
		</taSopHdrIvcInsert>
		<taSopToPopLink xsi:nil="true" />
		<taSopUpdateCreateProcessHold xsi:nil="true" />
		<taCreateSOPTrackingInfo xsi:nil="true" />
		<taMdaUpdate_Items xsi:nil="true" />
	</SOPTransactionType>
</eConnect>

*This post is locked for comments

All responses (9)

Answers (1)

camt on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

Hi Shan, glad to hear that there is some progress!

I think you also need this:

analyticsCreditAudit.aaTrxDimID = some_integer;

analyticsCreditAudit.aaTrxDimIDSpecified = true;

To get the right Dim ID find the AA code in the AAG00401 table.

For additional debugging you can check the eConnect windows event log. You can also do some debugging on SQL Server itself. These might help:

blogs.msdn.com/.../how-to-configure-sql-profile-tracing-using-the-support-debugging-tool.aspx

support.microsoft.com/.../850996
Community Member Microsoft Employee on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

Hi CAMT,

I have tried slightly changing the AA nodes in passing and this time it integrated successfully. But, the only problem which I found inside GP in the Analytical General Transaction Entry, I could not find the TRX Dimension code,the field is empty, when I click the validation it failed with the message " Transaction Dimension XXXX is required but a code has not been entered" - account FLA6-0001. But, I have passed the dimension code in the xml node.

Did I miss something here?

Note: In the Accounting Class Maintenance, for the dimension the Analysis Type is set as "Required".

I am not sure what am I missing, here is the nodes for reference;

aaLine.aaTrxDimCode = Code;

aaLine.DOCNMBR = header.JRNENTRY.ToString();

aaLine.DistSequenceSpecified = true;

aaLine.DistSequence = lineSequence;

aaLine.DistRef = Reference;

aaLine.DOCTYPE = 0;

aaLine.ACTNUMST = Account;

aaLine.AMOUNTSpecified = true;

aaLine.AMOUNT = amount;

Here is the full xml file for your reference

<?xml version="1.0" encoding="utf-8"?><eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">

<GLTransactionType><eConnectProcessInfo xsi:nil="true" /><taRequesterTrxDisabler_Items xsi:nil="true" />

<taGLTransactionLineInsert_Items><taGLTransactionLineInsert>

<BACHNUMB>test7</BACHNUMB>

<JRNENTRY>16506</JRNENTRY>

<SQNCLINE>16384</SQNCLINE>

<CRDTAMNT>0</CRDTAMNT>

<DEBITAMT>5</DEBITAMT>

<ACTNUMST>FLA6-0000</ACTNUMST>

<DSCRIPTN>cash</DSCRIPTN>

</taGLTransactionLineInsert><taGLTransactionLineInsert>

<BACHNUMB>test7</BACHNUMB>

<JRNENTRY>16506</JRNENTRY>

<SQNCLINE>32768</SQNCLINE>

<CRDTAMNT>5</CRDTAMNT>

<DEBITAMT>0</DEBITAMT>

ACTNUMST>FLA6-0001</ACTNUMST>

<DSCRIPTN>cash</DSCRIPTN>

</taGLTransactionLineInsert></taGLTransactionLineInsert_Items>

<taAnalyticsDistribution_Items><taAnalyticsDistribution>

<DOCNMBR>16506</DOCNMBR>

<AMOUNT>5</AMOUNT>

<DistSequence>16384</DistSequence>

<ACTNUMST>FLA6-0000</ACTNUMST>

<DistRef>cash</DistRef>

<aaTrxDimCode>TESTDIMCODE</aaTrxDimCode>

</taAnalyticsDistribution><taAnalyticsDistribution>

<DOCNMBR>16506</DOCNMBR>

<AMOUNT>5</AMOUNT>

<DistSequence>32768</DistSequence>

<ACTNUMST>FLA6-0001</ACTNUMST

><DistRef>cash</DistRef>

<aaTrxDimCode>TESTDIMCODE1</aaTrxDimCode>

</taAnalyticsDistribution></taAnalyticsDistribution_Items>

<taGLTransactionHeaderInsert>

<BACHNUMB>test7</BACHNUMB>

<JRNENTRY>16506</JRNENTRY>

<REFRENCE>Import</REFRENCE>

<TRXDATE>4/22/2014 12:00:00 AM</TRXDATE>

<TRXTYPE>0</TRXTYPE>

<SOURCDOC>GJ</SOURCDOC>

<USRDEFND1>FLA6</USRDEFND1>

<USRDEFND2>0</USRDEFND2>

</taGLTransactionHeaderInsert><taMdaUpdate_Items xsi:nil="true" /></GLTransactionType></eConnect>

thanks,

Shan
Community Member Microsoft Employee on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

Hi CAMT,

For testing purpose,I have followed the below steps:

1. I have newly created a Dimension

2. created new Dimension codes and assinged the codes to the dimension

3. checked the code validation( the newly created dimension codes were listed in the Trx Dimension Section)

4. In the Accounting Class Maintenance, created the new class and for the newly created dimension, the Analysis Type field is set to "Required" and the show field is selected.

5. In the Account Class Link, selected the newly created class specific to the new dimension and linked the GL accounts to the class(Note: created two new accounts for testing)

6. In the user Action Dimension section, assigned the user distribute, Adjust fields for the newly created diension & class.

Finally run the integration with the above mentioned parameters, but it failed. Here with attached the xml nodes for your reference.

Kindly advice,

Thanks,

Shan

<?xml version="1.0" encoding="utf-8"?><eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">

<GLTransactionType><eConnectProcessInfo xsi:nil="true" /><taRequesterTrxDisabler_Items xsi:nil="true" />

<taGLTransactionLineInsert_Items><taGLTransactionLineInsert>

<BACHNUMB>test7</BACHNUMB>

<JRNENTRY>16505</JRNENTRY>

<SQNCLINE>16384</SQNCLINE>

<CRDTAMNT>0</CRDTAMNT>

<DEBITAMT>5</DEBITAMT>

<ACTNUMST>FLA6-0000</ACTNUMST>

<DSCRIPTN>cash</DSCRIPTN>

</taGLTransactionLineInsert><taGLTransactionLineInsert>

<BACHNUMB>test7</BACHNUMB>

<JRNENTRY>16505</JRNENTRY>

<SQNCLINE>32768</SQNCLINE>

<CRDTAMNT>5</CRDTAMNT>

<DEBITAMT>0</DEBITAMT>

<ACTNUMST>FLA6-0001</ACTNUMST>

<DSCRIPTN>cash</DSCRIPTN>

</taGLTransactionLineInsert></taGLTransactionLineInsert_Items>

<taAnalyticsDistribution_Items><taAnalyticsDistribution>

<DOCNMBR>16505</DOCNMBR>

<AMOUNT>5</AMOUNT>

<DistSequence>16384</DistSequence>

<DistRef>cash</DistRef>

<aaTrxDimCode>TESTDIMCODE</aaTrxDimCode>

<aaTrxDimID>6</aaTrxDimID>

</taAnalyticsDistribution><taAnalyticsDistribution>

<DOCNMBR>16505</DOCNMBR>

<AMOUNT>5</AMOUNT>

<DistSequence>32768</DistSequence>

<DistRef>cash</DistRef>

<aaTrxDimCode>TESTDIMCODE1</aaTrxDimCode>

<aaTrxDimID>6</aaTrxDimID>

</taAnalyticsDistribution></taAnalyticsDistribution_Items>

<taGLTransactionHeaderInsert>

<BACHNUMB>test7</BACHNUMB>

<JRNENTRY>16505</JRNENTRY>

<REFRENCE>Import</REFRENCE>

<TRXDATE>4/22/2014 12:00:00 AM</TRXDATE>

<TRXTYPE>0</TRXTYPE>

<SOURCDOC>GJ</SOURCDOC>

<USRDEFND1>FLA6</USRDEFND1>

<USRDEFND2>0</USRDEFND2>

</taGLTransactionHeaderInsert><taMdaUpdate_Items xsi:nil="true" /></GLTransactionType></eConnect>
Emily H 472 on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

With eConnect, it can be helpful to try and enter the (GL) transaction in the GP windows to verify your setup and other data.

The windows sometimes provide different or more interactive assistance than eConnect is able to with the error messages.
camt on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

And the AA codes have been assigned to the right GL accounts?

Could you post your complete XML eConnect?

I'd recommend going through the AA setup documentation.
Community Member Microsoft Employee on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

Hi CAMT,

Thanks for your quick reply. I have tried the integration again by passing the above mentioned parameters in my code. But, I am still facing the same error.

I have checked the user permission and the user got the access to those AA codes.

Kindly advice.
camt on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

Hi Shan,

Here is the AA stuff I defined:

analyticsCreditAudit.aaTrxDimID = some_integer;

analyticsCreditAudit.aaTrxDimIDSpecified = true;

analyticsCreditAudit.aaTrxCodeIDSpecified = false;

analyticsCreditAudit.aaTrxDimCode = "THE AA CODE";

analyticsCreditAudit.DOCNMBR = some_salenumber;

analyticsCreditAudit.DistSequence = sequenceNumber;

analyticsCreditAudit.DistSequenceSpecified = true;

analyticsCreditAudit.DOCTYPE = docType;

analyticsCreditAudit.AMOUNT = salesItemAmount;

analyticsCreditAudit.AMOUNTSpecified = true;

Make sure that your user is allowed to use those AA codes, and that they can be assigned to those GL accounts. Dynamics may not tell you that's the problem - it just says you didn't pass in the AA code.

In your scenario 1 above I see "<aaTrxDim>J</aaTrxDim>". I didn't need to define that.
Community Member Microsoft Employee on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

Hi CAMT,

I am facing the same problem, issue with Integrating General Ledger with Analytical Accounting Information using eConnect tool into Microsoft Dynamics GP.

The below given is the exact error message. In fact, I am passing the parameter "aaTrxDimID" and set the aaTrxDimID.specified to true, the field appears in the XML but still it pops the error saying "aaTrxDimID" parameter was not passed in.

When I manually create the entries in Microsoft Dynamics GP with the same data, it was creating without any errors.

Version:

The GP version is 2013 SP2

eConnect version is 2013 SP2

The following scenarios explain the issue:

Scenario 1:

If we pass the AA distribution parameter in econnect with Dimension and the Dimension code, the integration fails with the message “aaTrxDimID = Note: This parameter was not passed in, no value for the parameter will be returned”. Please find attached the error log message (errorlog.txt).

Note: I have checked the XML file and it does contain all the parameters including the aaTrxDimID.

AA distribution parameters:

<DOCNMBR>16409</DOCNMBR>

<DistSequence>16384</DistSequence>

<ACTNUMST>1810</ACTNUMST>

<DistRef>Purchases</DistRef>

<aaTrxDim>J</aaTrxDim>

<aaTrxDimCode>FLA1</aaTrxDimCode>

<aaTrxDimID>1</aaTrxDimID>

Scenario 2:

If we pass the AA distribution parameter in econnect with just the Dimension code, the integration is successful. But when validating the Analytical Accounting in GP we get a message: “Analytical Accounting code does not exist for the dimension”.

Note: When I checked the backend SQL AA tables, I noticed these tables were not populated in GP (AAG10001, AAG10002, AAG10003).

AA distribution parameters:

<DOCNMBR>16409</DOCNMBR>

<DistSequence>16384</DistSequence>

<ACTNUMST>1815</ACTNUMST>

<DistRef>Purchases</DistRef>

<aaTrxDimCode>FLA1</aaTrxDimCode>

<aaTrxDimID>1</aaTrxDimID>

Error Message:

Exception type:

Microsoft.Dynamics.GP.eConnect.eConnectException

Exception message:

Sql procedure error codes returned:

Error Number = 9398 Stored Procedure= taProcessAnalytics Error Description = error processing taAnalyticsDistribution

Node Identifier Parameters: taProcessAnalytics

Error Number = 9414 Stored Procedure= taAnalyticsDistribution Error Description = Transaction Dimension assignment does not exist

Node Identifier Parameters: taAnalyticsDistribution

Related Error Code Parameters for Node : taAnalyticsDistribution

aaTrxDimID = Note: This parameter was not passed in, no value for the parameter will be returned.

Error Number = 9436 Stored Procedure= taGLTransactionHeaderInsert Error Description = Could not process analytics

Node Identifier Parameters: taGLTransactionHeaderInsert

BACHNUMB = test1

JRNENTRY = 16410

REFRENCE = .net Import

TRXDATE = 1/15/2014 12:00:00 AM

TRXTYPE = 0

<taGLTransactionHeaderInsert>

<BACHNUMB>test1</BACHNUMB>

<JRNENTRY>16410</JRNENTRY>

<REFRENCE>.net Import</REFRENCE>

<TRXDATE>1/15/2014 12:00:00 AM</TRXDATE>

<TRXTYPE>0</TRXTYPE>

<USRDEFND1>FLA6</USRDEFND1>

<USRDEFND2>0</USRDEFND2>

</taGLTransactionHeaderInsert>

Kindly advice.

Thanks,

Shan
Verified answer

camt on at

Like (0)

Report

RE: eConnect taAnalyticsDistribution

The dimensions were not assigned to the GL accounts in question (support.microsoft.com/.../2687958)