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) / Integration Manager - ...
Microsoft Dynamics GP (Archived)

Integration Manager - Import customers and invoices at the same time

(0) ShareShare
ReportReport
Posted on by regrap 80

I'm starting to put together a new integration that will be importing all the customers, sales, and cash receipts into GP.  My main question is, would it be possible to integrate customers and invoices in the same integration?  I would really like to have one file that is pulled in that would add customers that are not in GP while also pulling the invoices in.  Basically it would have to look to see if there was a customer, if so just add the invoice, if not add the customer and invoice.  Any advice would be appreciated.

Thanks.

*This post is locked for comments

I have the same question (0)
  • GloriaB Profile Picture
    GloriaB 981 on at

    It's possible as long as you integrate customers first. We have a huge integration of new customers, updated customers, SOP Trx then cash receipts. However, we used a staging database and eConnect rather than integration manager.  We encountered too many exceptions with the fine lines between a new customer and an existing customer and with a new address plus returns and credits.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    I would agree. You would have to have the customers in GP first. There is no way to setup an integration that would look for a  valid customer first and then create if needed. You would one integration to bring in the customers and then another to bring in the orders. So you can use Integration Manager for both or use eConnect and create your own customer import. It would all depend on how automatic you need this to be as well as how much customer data validation is needed.

  • davidf. Profile Picture
    davidf. on at

    You can set up an IM Group that runs the Integration in stages.

    First create an "Insert Only" integration to set up new Customers. If the Customer Number already exists, it will just reject. Next create the Invoice Integration.

    Then select "New Integration Group". Add the New Customer integration and the Invoice Integration to the Group.

    Now when you kick off the Integration Group, it will chain from one Integration to the next.

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