Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect Schema

Posted on by

Dear All,

I am in process of testing new integration of receiving transactions.  We have the data for receiving transaction entry in a outbound table.  And the following are the fields will be taken from that table.  Can anyone suggest sample eConnect Schema to take the data from the table and fetch it in GP by creating these transactions in batch.  Basically I am learning to integrate the data from a table to GP using eConnect.  We are in GP 2013 and web service installed.

1) Receipt Number

2) Creditor Doc. No.

3) Date

4) Batch ID

5) Creditor ID

6) Item

7) Qty Shipped

8) Unit Cost

9) UOM

10) Site ID

Thanks,

Babu

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect Schema

    Hi santhos,

         Have you find any alternate for return transaction entry.

  • Santosh Profile Picture
    Santosh 766 on at
    RE: eConnect Schema

    Hi,

    Thanks for this... But what is the way or schema we need to refer in case we need to return the GRN (Shipment). I have gone through the schema .chm file but didn't find anything.

    If the schema is not available then is there any way to create return entry in Great Plains.

    Thanks,

    Santosh

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect Schema

    Hi Somakarpagamoorthy K,

    I am trying to import a purchase Receipt to GP 2013 using eConnect, but my client wants to be able to set the posting date located in the batch to the date of import.

    I found the class for the batch <taCreateUpdateBatchHeaderRcd> but I wan't able to add to the transaction POPReceivingsType

    Do you have any idea on how can I accomplish that?

    Thanks in advance

    Ricardo

  • RE: eConnect Schema

    Any update on the resolution? This is a post that is getting a large number of views so we would like to get a confirmed resolution.

  • RE: eConnect Schema

    Hi Soma,

    Thanks for your follow-up.    I have older version of visual studio so I am not able use the code so waiting for the new cd to install and try this.  I will let you know as soon as I test this.

    Thanks,

    Babu

  • soma Profile Picture
    soma 24,406 on at
    RE: eConnect Schema

    Babu, any updates?

  • RE: eConnect Schema

    Hi Soma,

    Thanks a lot for your kind help.  I will try this and let you know my outcome.

    Thanks,

    Babu

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: eConnect Schema

    Here I have pasted the sample code for creating purchasing receiving transaction entry. Have a look on this.

    // Create the eConnect document and store it in a file

                       SerializeReceivingOrderObject("ReceivingOrder.xml");

                       // Load the eConnect XML document from the file into

                       // and XML document object

                       XmlDocument xmldoc = new XmlDocument();

                       xmldoc.Load("ReceivingOrder.xml");

                       // Create an XML string from the document object

                       string receivingOrderDocument = xmldoc.OuterXml;

                       // Create a connection string

                       // Integrated Security is required. Integrated security=SSPI

                       // Update the data source and initial catalog to use the names of

                       // data server and company database

                       string sConnectionString = "data source=localhost;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096";

                       string receivingOrder = eConCall.CreateTransactionEntity(sConnectionString, receivingOrderDocument);

    private void SerializeReceivingOrderObject(string filename)

           {

                  // Here you need to get the input values from your table to assign to the DataRow and DataTable

                 // Line_Count= pass the row count values to this variable

                integer Line_Count = dt.rows.count;

                   taPopRcptLineInsert_ItemsTaPopRcptLineInsert[] LineItems = taPopRcptLineInsert_ItemsTaPopRcptLineInsert[Line_Count];

                   int Linerecord = 0;

                   // Loop through the records in the grid

                   foreach (DataRow dr in dt.Rows)

                   {

                           lineNo++;

                           taPopRcptLineInsert_ItemsTaPopRcptLineInsert PL1 = new taPopRcptLineInsert_ItemsTaPopRcptLineInsert();

                           // Values for PO Line

                          // here pass your line parameters

                           PL1.

                           PL1.

                           LineItems[Linerecord] = PL1;

                           Linerecord++;

                   }

                       taPopRcptHdrInsert PHdr = new taPopRcptHdrInsert();

                       // Header Line data

                       // here pass your header parameters

                       PHdr.

                       PHdr.

                       POPReceivingsType ReceivingOrder = new POPReceivingsType();

                       ReceivingOrder.taPopRcptLineInsert_Items = LineItems;

                       ReceivingOrder.taPopRcptHdrInsert = PHdr;

                       POPReceivingsType[] MyPopTransactionType = { ReceivingOrder };

                       eConnectType eConnect = new eConnectType();

                       eConnect.POPReceivingsType = MyPopTransactionType;

                       // Create a file to hold the serialized eConnect XML document

                       FileStream fs = new FileStream(filename, FileMode.Create);

                       XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());

                       // Serialize the eConnect document object to the file using the XmlTextWriter

                       XmlSerializer serializer = new XmlSerializer(eConnect.GetType());

                       serializer.Serialize(writer, eConnect);

                       writer.Close();

    }

    Note: This is not a full code for receiving transaction entry. You should go through this code and create your own coding based on this sample code.

    Hope this helps!!!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect Schema

    Hi Babu,

    once you pass all the 3rd party table parameters to respective schema variables, add all the variables to the respective array list.

    using filestream, XmlTextWriter, XmlSerializer class, you can create a new XML file and write the respective eConnect nodes with parameters.  

    using CreateEntity, CreateTransactionEntity, eConnect_EntryPoint or other methods, you can integrate the particular transaction into GP.

    Please refer eConnect Samples from eConnect installation folder that will give idea for creating custom integration into GP.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: eConnect Schema

    Give me time. I will create a sample econnect coding and provide you the same.

    For your reference: You can find some sample integration programs from your eConnect installation path(under sample folder).

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans