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) / Multiple Vendor Item C...
Microsoft Dynamics GP (Archived)

Multiple Vendor Item Codes

(0) ShareShare
ReportReport
Posted on by mleinwohl 60

We are looking for a solution to using multiple vendor item codes associated with one Dynamics item code.  The optimal solution for us would be some sort of parent/child relationship between items.  Does anyone know of a solution within Dynamics, or a third party software solution.

*This post is locked for comments

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

    Do you mean multiple codes for one item from one Vendor?  If so, in what scenario would that happen?  If not, then you assign a Vendor Item for each Vendor associated with your item.

  • mleinwohl Profile Picture
    mleinwohl 60 on at

    It could be from one vendor when they change pack sizes, they change their vendor code.  We will just set up a different unit of measure.  We are importing our invoices through an integration, and the vendor code must match.  We also need to keep only one item number in order to do our usage reports, and not have to combine multiple items to see how much product we used in a store.

    According to our consultant, there can only be one vendor code per item.  I was hoping for some type of thrid party software that exists to help us with this.

  • Dencio Profile Picture
    Dencio 2,172 on at

    You are treating two SKUs from the same vendor as one inventory number/code in GP, thus two things may occur:

    • PO Issuance and PO Receiving and using your own item code, this is default and GP can handle it.
    • PO Issuance and PO Receiving and for one vendor with different item code for every packaging, in your integration tool, keep a translation table between different SKUs (for the same vendor) and your own item code (assuming you are treating each SKUs with matching unit of measure within the same item number in GP).

    Cheers,

    Dencio

     

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    You could always do a customization, which is sort of what Denzio is suggesting with the translation table.

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