Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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... 4,029 Super User 2024 Season 2 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

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