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

Importing manufacturer's name and part number GP2013

(0) ShareShare
ReportReport
Posted on by Mike_Normal 480

We used Integration Manager with GP2013 to import our data into item cards, including the associated vendor and their part number. We didn't see a field in the Integration Manager to import our items' manufacturers' names and part numbers. For each of our items (part number), we need to control both the vendors/part numbers and the manufacturers/part numbers. We have multiple vendors and multiple manufacturers for many of our parts.

 

How do we import our manufacturer's names and their part numbers? I assume we have to use a SQL query? If so, what tables need to be loaded?

 

BTW, getting to the manufacturer's data is not very convenient in GP2013, unless I'm doing something wrong. I open the Item Maintenance card, then select "Go To" Item Purchasing Options Maintenance, then select the "Gears" to reach the Manufacturer's Item Number Maintenance dialog. Is there a short cut to reaching the manufacturer's data for an item? 

 

Your help is much appreciated

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at

    Mike, you should be able to use Table Import to update these values.  Import them to the 'Multiple Manufacture Items Master' table in the Manufacturing Series, 3rd Party tables.

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at

    Thanks for the tip. I found the Multiple Manufacturer Items Master Table in Dynamics GP Product List, Inventory Series. The import seemed to work, at least I can see the manufacturer/item number via the Item Card.

    I can't see the manufactures listed in Smart List when viewing Items. Do I need to refresh something for the imported manufacturer's data to appear in Smart List?

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    You may need to use SmartList Builder (extra cost feature but worth the bucks) to create a custom SmartList that included the multiple vendors/part numbers.

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at

    We purchased the GP2013 Extended Pack with "manufacturing to support and control the manufacturing environment". I would think that feature should include the capability to list an item's manufacturer(s). The only way I can find to view the item's manufacturer is to drill into several dialogs to reach the Manufacturer's Item Number Maintenance Dialog. The Inventory Item SmartList has columns for listing an item's manufacture, but no data populates that column.

    There must be an easier way to view an item's manufacturers??????

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at

    The SmartList Inventory Items List now includes the manufacturers and their part numbers. Don't know why this data didn't appear yesterday after loading it, but it's there now.

  • Community Member Profile Picture
    Community Member on at

    You have to mark one of the manufacturere items as primary for it to appear in the SmartList.  The table is a one-to-many releationship, but marking the primary creates a one-to-one that the SmartList can handle.  -Trevor

  • Mike_Normal Profile Picture
    Mike_Normal 480 on at

    Thank you, Trevor. We'll keep that in mind.

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
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans