Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Integration Manager: Allow Updates to Fields when Importing Sales Invoices

(0) ShareShare
ReportReport
Posted on by

I have a client running GP 2010.  They are using integration manager when importing sales invoices and having issues importing user defined fields. This is what she is telling me:

The integration requires a header file and a detail file. The header file has the following columns:

Invoice Number, Client ID, Date, PO Number, Claimant, Claimant ID#, DOB, SSN, DOI, DOS, Case Manager, Adjuster

Here’s the issue: if the case manager and/or adjuster values are not already in Great Plains, the invoice record is rejected, and then there is a manual process to enter the invoice. Is there any way to set up the integration to accept a new, unrecognized value in these columns (insert the value, so to speak), and then be recognized on future invoice header records? It would save a lot of time and hassle if this were a possibility.

Does anyone have any experience with this or have any suggestions?

Thank you in advance,

Dawn

*This post is locked for comments

  • RE: Integration Manager: Allow Updates to Fields when Importing Sales Invoices

    I couldn't reproduce this at all. but I am testing on GP 2013 R2 and IM 2013. When I map information in the it brings it in on that transaction. What is the error they receive when running the integration?

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Integration Manager: Allow Updates to Fields when Importing Sales Invoices

    I am guessing from the description of your integration the Manager and Adjuster fields are using a list of possible values.  Perhaps corresponding to the Rep and Territory ID in the Sales Series.

    If so, you need a query which matches inbound values to existing values in GP, so a user can validate and input the possible values before running the integration.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans