DynDeveloper.com

i am attempting to create a/r transactions that include analytic distributions via econnect. 
the taRMTransaction successfully creates the transaction.
four taRMDistribution transactions successfully create the accounting distribution records for the transaction.
two taAnalyticsDistribution transactions return as successful, but the analytics distributions are not assigned to the account in question.  i have verified that dimension codes exist and appropriate permissions are granted - in fact, i can use GP UI to view the receivables transaction (just created by my interface) and assign the dimension codes to the accounts.

has anyone used taAnalyticsDistribution?  is there any trick to it?
elements i am sending are DOCNMBR, DOCTYPE, ACTNUMST, aaTrxDim, aaTrxDimCode, and UpdateIfExists=1.  among the many combinations/ permutations i've tried are setting AMOUNT or leaving it null, setting SEQNUMBR in the taRMdistribution entries and using the corresponding values for DistSequence in taAnalytics.

any suggestions or advice is more than appreciated.

thanks
   jim
   

Hi Guys,

Have you ever encountered GPaddin forms not centering even if you already set the property to centerscreen? Does anybody encountered this also or it's just me? If so, does anybody know how to resolve this issue?

Hello.  First, I wanted to say great site!

I'm just getting started with eConnect and am trying to work through the examples in the eConnect Programmer's Guide and Reference.  Specifically, I am working on the eConnectOut Serialization Example.  I am able to get it working if I create a VB project, but cannot get it to work for C# (I only know C#).  I have been able to convert pretty much the entire code to C# except for the 'ReDim Preserve' statement.  Since there isn't an equivalent statement in C#, I have no idea how to go about converting it from VB.  I have googled it and worked through many suggestions on how to convert it without any luck.  It's probably something simple, but I cannot figure it out and was hoping someone here could shed a little insight.  Any help or information you could provide would be extremely helpful.  I will post the entire code below for your reference, but I will highlight the section I am having trouble with.  Thank you so much in advance!

Imports System
Imports System.Xml
Imports System.Xml.Serialization
Imports System.IO
Imports System.EnterpriseServices
Imports System.Text
Imports Microsoft.Dynamics.GP.eConnect
Imports Microsoft.Dynamics.GP.eConnect.Serialization
Module Module1
    Sub Main()
        Dim serializer As New XmlSerializer(GetType(eConnectType))
        Dim eConnect As New eConnectType()
        Dim eConnectouttype As New RQeConnectOutType()
        Dim eConnectOut As New eConnectOut()
        Dim entrypoint As New eConnectMethods()
        Dim requesterDoc As String
        Dim sConnectionString As String
        Try
            'Populate the eConnectOut object to specify the data request
            With eConnectOut
                .DOCTYPE = "Customer"
                .OUTPUTTYPE = 1
                .INDEX1FROM = "AARONFIT0001"
                .INDEX1TO = "AARONFIT0001"
                .FORLIST = 1
            End With

            'Create an XML document for the request
            eConnectouttype.eConnectOut = eConnectOut
            ReDim Preserve eConnect.RQeConnectOutType(0)
            eConnect.RQeConnectOutType(0) = eConnectouttype

            'Serialize the eConnect object to a memory stream
            Dim memStream As New MemoryStream()
            serializer.Serialize(memStream, eConnect)
            memStream.Position = 0
            'Use the memory stream to load an Xml document
            Dim xmlDoc As New XmlDocument()
            xmlDoc.Load(memStream)
            memStream.Close()
            'Create a connection string to Microsoft Dynamics GP
            sConnectionString = "data source=MyServer;" _
                & "initial catalog=TWO; integrated security=SSPI;" _
                & "persist security info=False; packet size=4096"
            'Request the data from the server
            requesterDoc = entrypoint.eConnect_Requester(sConnectionString, _
                EnumTypes.ConnectionStringType.SqlClient, xmlDoc.OuterXml)
            'Write the customer XML to a file
            Dim fs As New FileStream("Customer.xml", FileMode.Create)
            Dim writer As New StreamWriter(fs, New UTF8Encoding)
            writer.Write(requesterDoc)
            writer.Close()
        Catch exp As eConnectException
            Debug.Write(exp.ToString)
        Catch ex As System.Exception
            Debug.Write(ex.Message & vbCrLf & ex.StackTrace)
        End Try
    End Sub
End Module

Has anyone managed to successfully create a multi-currency transaction using the PMTransaction schema when you need to also pass in the distributions.

It always seems to put my originating amounts into the functional amount fields and therefore the document will never post in GP.

This is for GP10 by the way...

Fabrikam Sample:

<!-- payables invoice creation with taxes, MC, and has Freight and Mics Charges -->
<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
    <PMTransactionType>
        <taPMTransactionInsert>
            <BACHNUMB>SAVE</BACHNUMB>
            <VCHNUMWK>00000000000038444</VCHNUMWK>
            <VENDORID>DOLECKIC0001</VENDORID>
            <DOCNUMBR>29</DOCNUMBR>
            <DOCTYPE>1</DOCTYPE>
            <DOCAMNT>500</DOCAMNT>
            <DOCDATE>2007-02-12</DOCDATE>
            <PSTGDATE>2007-02-12</PSTGDATE>
            <VADDCDPR>PRIMARY</VADDCDPR>
            <PYMTRMID>Due 20th</PYMTRMID>
            <TAXSCHID>COMPANYPUR</TAXSCHID>
            <DUEDATE>2007-03-20</DUEDATE>
            <DSCDLRAM>0</DSCDLRAM>
            <PRCHAMNT>500.00</PRCHAMNT>
            <CHRGAMNT>500.00</CHRGAMNT>
            <TRXDSCRN>Multi-Currency Test</TRXDSCRN>
            <PORDNMBR>101</PORDNMBR>
            <SHIPMTHD>DROP SHIP</SHIPMTHD>
            <CURNCYID>Z-C$</CURNCYID>
            <XCHGRATE>3.1722000</XCHGRATE>
            <EXPNDATE>2007-02-12</EXPNDATE>
            <EXCHDATE>2007-02-12</EXCHDATE>
            <EXGTBDSC>Canadian-Sell</EXGTBDSC>
            <EXTBLSRC>CompuServe</EXTBLSRC>
            <RATEEXPR>6</RATEEXPR>
            <DYSTINCR>0</DYSTINCR>
            <RATEVARC>.0500000</RATEVARC>
            <TRXDTDEF>1</TRXDTDEF>
            <RTCLCMTD>0</RTCLCMTD>
            <PRVDSLMT>1</PRVDSLMT>
            <DATELMTS>1</DATELMTS>
            <CREATEDIST>0</CREATEDIST>
        </taPMTransactionInsert>
    <taPMDistribution_Items>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VENDORID>DOLECKIC0001</VENDORID>
        <VCHRNMBR>00000000000038444</VCHRNMBR>
        <BACHNUMB>SAVE</BACHNUMB>
        <DISTTYPE>6</DISTTYPE>
        <ACTNUMST>000-1100-00</ACTNUMST>
        <DEBITAMNT>500</DEBITAMNT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VENDORID>DOLECKIC0001</VENDORID>
        <VCHRNMBR>00000000000038444</VCHRNMBR>
        <BACHNUMB>SAVE</BACHNUMB>
        <DISTTYPE>2</DISTTYPE>
        <ACTNUMST>000-1100-00</ACTNUMST>
        <CRDTAMNT>500</CRDTAMNT>
      </taPMDistribution>
    </taPMDistribution_Items>
    </PMTransactionType>
</eConnect>

Thanks,

Jon.

Here is some example code that will show how to take an XMLDocument and see if a particular node exists. If not, we need to add the node.

I'm getting this error from Econnect:

 - Sql procedure error codes returned:
Error Number = 712  Stored Procedure taRMTransaction  Error Description = Tax amount (TAXAMNT) does not equal tax details in RM10601
Node Identifier Parameters: taRMTransaction                                   
RMDTYPAL = 1
DOCNUMBR = 999-99999-112007-R2
DOCDATE = 03-12-2008
BACHNUMB = GEM200711013600
CUSTNMBR = 999-99999
Related Error Code Parameters for Node : taRMTransaction                                   
TAXAMNT = 1892.73000

<taRMTransaction><RMDTYPAL>1</RMDTYPAL><DOCNUMBR>999-99999-112007-R2</DOCNUMBR>

<DOCDATE>03-12-2008</DOCDATE><BACHNUMB>GEM200711013600</BACHNUMB>
<CUSTNMBR>999-99999</CUSTNMBR><DOCAMNT>34941.00000</DOCAMNT><SLSAMNT>25530.34000</SLSAMNT>
<FRTAMNT>7517.93000</FRTAMNT><TAXAMNT>1892.73000</TAXAMNT><LSTUSRED>239</LSTUSRED></taRMTransaction>

I've checked, and in my xml I'm sending econnect the taxamnt fields have the same number, so I don't think it's the xml I'm sending econnect.  Also it only happens on 2 customers and works fine on others.  Is there something I'm missing?

Brad

 Hi here,

I am using Visual Studio Tool to do integration with Ms Dynamic GP 10.0.

My problem is, in side [Dynamics.Forms.PmTransactionEntryDistribution.PmTransactionEntryDistribution.DistributionScroll]
I try to populate value of [AccountNumberString] field by using the following code:
AccountNumberString.Value = "400-652-000";

but I still not see this string in the Account column. Anyone could help me out please.

Thank you

Tola
 

PS: One more thing, anyone know how to populate multiple rows?