Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Consolidating item Numbers

    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

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Consolidating item Numbers

    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

  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at
    RE: Consolidating item Numbers

    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.

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

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans