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) / Consolidating item Num...
Microsoft Dynamics GP (Archived)

Consolidating item Numbers

(0) ShareShare
ReportReport
Posted on by silvestre 170

Hi,

I have a supplier that has different items numbers depending on manufacturing sites.  This creates problems with inventory control and planning.  The question is, could I have a single item number for those items?  

I was told that Dynamics GP can record two different item numbers:  a manufacturer item number and your own item number.  Is this true?  If so when I would guess that when I purchase two equal items with different item numbers, I would be able to have them under my own item with a single consolidated inventory count?  Are there any implications to this?

Thanks in advance.

*This post is locked for comments

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

    Yes, GP has a Manufacturer Item Number.  I suggest you read the Help files for Manufacturer’s Item Number Maintenance and also for Item Vendor Maintenance (Vendor Item)  to determine which will work best for your situation.

    Let us know if you have more questions.

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

    You should, in the item master table, have only one item number for any item.  Otherwise quantities on hand get split and hard to manage.  Also, knowing when to reorder is a problem.

    GP maintains an Item Vendor as well as a Customer Item Number table.  The first allows you to record the manufacturer's item for each and every vendor you purchase the item from.  The second allows you to record the customer's item number for each and every customer that purchases the item from you (if they order by their own part number)

    These tables are covered in detail in our Understanding Purchase Order Processing for the Item/Vendor table and Understanding Sales Order Processing for the Customer Item table.  Check them out on our web site or on Amazon.com

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I'm going to take another pass at this. I read that you acquire these items from a single vendor, but that vendor acquires these items from different  manufacturers. So, let's say your inventory's item number is 456 no matter which Mfgr the vendor uses. If you want to keep track of which manufacturer it is while not having a different item number yourselves, consider using Lots. You could have a lot number for each mfgr, yet maintain a single item number.

    kind regards

    leslie

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans