Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / taAnalyticsDistribution
Microsoft Dynamics GP (Archived)

taAnalyticsDistribution

(0) ShareShare
ReportReport
Posted on by Arunsh 606

guys,

Im facing a pbm in taAnalyticsDistribution  procedure. Im trying to create GL transaction and its analytical distribution through econnect. Im passing all required values, but finally im getting an error saying

procedure or function taAnalytiucsDistribution expects a pramater @I_vDOCNMBR which was not passed.

Though i have passed those values, i dont know why this error is coming. Please help me sort out this issue.Its bit urgent.

XML schema obtained:

  <?xml version="1.0" encoding="utf-8" ?>
- <eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
- <GLTransactionType>
  <eConnectProcessInfo xsi:nil="true" />
  <taRequesterTrxDisabler_Items xsi:nil="true" />
- <taGLTransactionLineInsert_Items>
- <taGLTransactionLineInsert>
  <BACHNUMB>TestBatch</BACHNUMB>
  <JRNENTRY>9999</JRNENTRY>
  <SQNCLINE>500</SQNCLINE>
  <ACTINDX>3</ACTINDX>
  <CRDTAMNT>0</CRDTAMNT>
  <DEBITAMT>1000</DEBITAMT>
  <ACTNUMST>000-1120-00</ACTNUMST>
  </taGLTransactionLineInsert>
- <taGLTransactionLineInsert>
  <BACHNUMB>TestBatch</BACHNUMB>
  <JRNENTRY>9999</JRNENTRY>
  <SQNCLINE>1000</SQNCLINE>
  <ACTINDX>1</ACTINDX>
  <CRDTAMNT>1000</CRDTAMNT>
  <DEBITAMT>0</DEBITAMT>
  <ACTNUMST>000-1100-00</ACTNUMST>
  </taGLTransactionLineInsert>
  </taGLTransactionLineInsert_Items>
- <taAnalyticsDistribution_Items>
  <taAnalyticsDistribution xsi:nil="true" />
- <taAnalyticsDistribution>
  <DOCNMBR>9999</DOCNMBR>
  <AMOUNT>1000</AMOUNT>
  <aaAssignedPercent>100</aaAssignedPercent>
  <DistSequence>500</DistSequence>
  <ACTNUMST>000-1120-00</ACTNUMST>
  <ACTINDX>3</ACTINDX>
  <aaTrxDimCode>EMPLOYEES</aaTrxDimCode>
  </taAnalyticsDistribution>
  </taAnalyticsDistribution_Items>
- <taGLTransactionHeaderInsert>
  <BACHNUMB>testbatch</BACHNUMB>
  <JRNENTRY>9999</JRNENTRY>
  <REFRENCE>testreference</REFRENCE>
  <TRXDATE>02/03/2015</TRXDATE>
  <TRXTYPE>0</TRXTYPE>
  </taGLTransactionHeaderInsert>
  <taMdaUpdate_Items xsi:nil="true" />
  </GLTransactionType>
  </eConnect>
C# code:

AADetailLine.DOCNMBR = Convert.ToString(9999);
AADetailLine.DOCNMBR = Convert.ToString(9999);
AADetailLine.DOCTYPE = 0;
AADetailLine.AMOUNT = 1000;
AADetailLine.AMOUNTSpecified = true;
AADetailLine.ACTNUMST = "000-1120-00";
AADetailLine.ACTINDX = 3;
AADetailLine.ACTINDXSpecified = true;
AADetailLine.DistSequence = 500;
AADetailLine.DistSequenceSpecified = true;
AADetailLine.aaAssignedPercent = 100;
AADetailLine.aaAssignedPercentSpecified = true;
AADetailLine.UpdateIfExists = 1;
AADetailLine.aaTrxDimID = 8004;
AADetailLine.aaTrxDim ="";
AADetailLine.aaTrxDimCode ="EMPLOYEES";

 

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,408 on at
    RE: taAnalyticsDistribution

    Yes. I saw it your coding. But, something is problem with your coding(passing parameter values). Try to debug your source code or share the full coding to us.

    Hope this helps!!!

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: taAnalyticsDistribution

    Hi soma,

    You are correct. there is no doctype node in XMl. but i am passing doctype in code, but its not creating in xml file.

    Arun

  • Suggested answer
    soma Profile Picture
    soma 24,408 on at
    RE: taAnalyticsDistribution

    You should pass DOCTYPE in taAnalyticsDistribution node. Doctype is not available in the below xml node. Please check and try again.

    <taAnalyticsDistribution>

     <DOCNMBR>9999</DOCNMBR>

     <AMOUNT>1000</AMOUNT>

     <aaAssignedPercent>100</aaAssignedPercent>

     <DistSequence>500</DistSequence>

     <ACTNUMST>000-1120-00</ACTNUMST>

     <ACTINDX>3</ACTINDX>

     <aaTrxDimCode>EMPLOYEES</aaTrxDimCode>

    </taAnalyticsDistribution>

    It should be like as below.

    <taAnalyticsDistribution>

      <DOCTYPE >0</DOCTYPE >

     <DOCNMBR>9999</DOCNMBR>

     <AMOUNT>1000</AMOUNT>

     <aaAssignedPercent>100</aaAssignedPercent>

     <DistSequence>500</DistSequence>

     <ACTNUMST>000-1120-00</ACTNUMST>

     <ACTINDX>3</ACTINDX>

     <aaTrxDimCode>EMPLOYEES</aaTrxDimCode>

    </taAnalyticsDistribution>

    Hope this helps!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans