web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect RM & PM t...
Microsoft Dynamics GP (Archived)

eConnect RM & PM technique

(0) ShareShare
ReportReport
Posted on by Community Member

Just completed PM integration and now working on RM - invoice integration to GP. Have got multiple invoices to integrate but my question is one of technique. With eConnect, if one of the invoices bombs, it bombs the whole lot. And., since you can post to the same batch over and over, wouldn't it make sense to do individual XML in memory, and post to the batch and trap any error? That way if it bombs, it just bombs one invoice not the whole batch of like 500 invoices?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Josh P Profile Picture
    Josh P 2,895 on at

    You can do it either way. I personally prefer an approach that includes the following sequence:

    - Get file info (csv, excel, xml, json, text, etc)

    - Map to objects (I use custom mapped objects for different purposes. These can be mapped to datatables, xml, generic lists, etc, and it allows you to manipulate the data in memory. The eConnect classes use fields instead of properties which do not work well with most mappers, and the names are not friendly, so I roll my own with attributes mapped to the field names in the eConnect classes)

    - Perform pre-eConnect validation (make sure items exist, fields are capitalized, customers not on hold, etc.)

    (The integration stops here if there is an issue, that way no records are committed to the database until      the validation is complete)

    - Serialize objects to SOPTransactionTypes

    - Process eConnect

    - Deserialize result

    - Process logs, update SOP Numbers assigned

    eConnect will be more efficient if you serialize all docs together instead of separate eConnect calls because of the SQL transactions created on the back-end to push the data.

  • Community Member Profile Picture
    Community Member on at

    We don't use SOP and I am checking for duplicate invoices and active/invalid accounts ahead of time.

    I'm just used to integration manager. If I had a credit memo but wanted to have a debit for the return freight (we still have to pay the hauler) it would bomb the integration.

    Don't know if it still works like that with eConnect.

    At most, I'll have 200-300 invoices and have to check about the time lag.

  • Josh P Profile Picture
    Josh P 2,895 on at

    If you are setting up IM to use the eConnect processor, then all the validation is done for you in IM, and it is lightning fast. The same is true for custom "roll-your-own" integration utility with respect to speed. It doesn't matter if you use SOP or Invoicing either; the process is the same. I have set up IM integrations using eConnect that will process thousands of invoices in minutes. 200-300 invoices will go into GP in about 20 seconds or less.

    Without knowing your resources committed to this though, if all you are doing is sales and purchasing documents for integration, IM might be more economical in terms of time and money spent to implement a custom integrator. You can use VBA scripting to perform all the pre-integration validating you need to without killing the entire batch of documents uploaded. There are also a couple very nice integration utilities out there for sale that will do everything for you.

    Most of these will save money over development costs unless you are building the integration utility to both use and learn the process.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans