Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Integration Manager - Import customers and invoices at the same time

Posted on by 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

  • davidf. Profile Picture
    davidf. on at
    RE: Integration Manager - Import customers and invoices at the same time

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Integration Manager - Import customers and invoices at the same time

    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.

  • GloriaB Profile Picture
    GloriaB 981 on at
    RE: Integration Manager - Import customers and invoices at the same time

    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.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans