Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Integration Vendor Address Import ...

Posted on by 215

Attempting to load Vendor Addresses but the PRIMARY address will not import. ... not sure what the issue is.

Any thoughts?

*This post is locked for comments

  • Bullsai Profile Picture
    Bullsai on at
    Re: Re: Re: Re: Re: Re: Integration Vendor Address Import ...

    If you're filling out the information in the Addresses area within IM, then I'm not sure what the issue is.  I can say that I have experienced what you're indicating and was unsuccessful at finding a resolution.

    To be honest, I go Old School on Vendor and Customer imports because of that issue.  I use the Table Import functionality within GP itself located at Microsoft Dynamics GP-->Tools-->Integrate-->Table Import.  The only caveat to using that is to make sure you run Check Links afterward: Microsoft Dynamics GP-->Maintenance-->Check Links.

    I hope that helps! :^)

    Todd M Bowlsby

  • Billy AY Profile Picture
    Billy AY 290 on at
    Re: Re: Re: Re: Re: Integration Vendor Address Import ...

    Does it work on importing customer addresses?  I tried but the IM only creates the customer account without the address.  Do you know how to do that?  Thanks

  • Bullsai Profile Picture
    Bullsai on at
    Re: Re: Re: Re: Integration Vendor Address Import ...

    Billy:

    If you're inquiring about Integration Manager, it's actually in a pane that most of the time gets hidden unless you either pull it down or maximize the window when you go into Destination Mapping.  The pane I'm speaking of is located in the upper left-hand corner just above the Name and Value columns.  There are additional details located under the pane that has the Name and Value columns, which you can easily see if you maximize the entire Integration Mapping window.

    At that point there is an Options selection below the Addresses folder, as well as an Options tab in the right-hand pane under the Fields tab.

    I hope that helps you out.

    T

  • Billy AY Profile Picture
    Billy AY 290 on at
    Re: Re: Re: Integration Vendor Address Import ...

    Where is the options tab for address detail located?  I have the same problem.  Thanks.

  • Ross Graham Profile Picture
    Ross Graham 215 on at
    Re: Re: Integration Vendor Address Import ...

    Hi Todd,

    The challenge was that there were no errors given. ... no truncation, no this or that so it was hard to get a grasp on the problem.

    It turned out to be a recordset issue. The Main Vendor informatoin came from the import file but the Address would not populate. On the options tab for Address Detail there is a flag for alternate recordset. I set the source file/query as the alternate recordset for the Address information. It worked. 

    Thanks.

  • Todd Bowlsby Profile Picture
    Todd Bowlsby 280 on at
    Re: Integration Vendor Address Import ...

    Ross:

     Are you using Integration Manager?  Integration Manager has exception reporting, which would probably tell you the reason.

     Todd Bowlsby

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans