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

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) / IM Not Integrating All...
Microsoft Dynamics GP (Archived)

IM Not Integrating All Fields

(0) ShareShare
ReportReport
Posted on by NickAtPI 180

We've got an integration to add new items to the inventory tables but it isn't integrating all the fields which it should be; in particular the 6 custom fields on the options card and the item notes. All the integrations report as being successful.

The source is an SQL table.

*This post is locked for comments

I have the same question (0)
  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    What do you mean custom fields?

  • NickAtPI Profile Picture
    NickAtPI 180 on at

    The 6 custom/user defined fields, columns [USCATVLS_1] - [USCATVLS_6] in IV00101

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    Worked for me. I had to first make sure those types existed. For example I had to go into the options window in GP and a Test1 for the first Category and I was prompted to add this category value.

    In the mapping if you click on the Options folder and then on the right side next to the Fields tab click the Options tab, does it say Use Field Rules or Use Default?

  • NickAtPI Profile Picture
    NickAtPI 180 on at

    It was set to 'use default'. Now that it is set to 'use field rules', it works. Thx!

    However, the notes still aren't working...

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    Mine worked as well. What are you mapping the note to in your source? Is it a lot of characters?

  • NickAtPI Profile Picture
    NickAtPI 180 on at

    It comes from a custom system which we use to manage the addition of new items. The average length of the history field is 300-600 characters, well within the max of 32,000.

  • Redbeard Profile Picture
    Redbeard 12,931 on at

    What is the format of the data coming from your custom system?  From the looks of your integration layout, this should work.

  • NickAtPI Profile Picture
    NickAtPI 180 on at

    Its an nvarchar(2000).

    I just tried integrating it with "test" in the history source field (to the notes destination field), and it didn't work. Prompted by what you said I thought it could be some of the line breaks, but apparently not or it would have worked with "test".

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    Instead of mapping it set it to use constant just as a test.

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    I just mapped mine and it worked as well. Not sure what is going on with yours. If you preview the source in IM do you see the notes?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
CP04-islander Profile Picture

CP04-islander 1

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans