web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Multiple Vendor Item Codes

(0) ShareShare
ReportReport
Posted on by

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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    on at
    Re: Multiple Vendor Item Codes

    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
    on at
    Re: Re: Multiple Vendor Item Codes

    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
    on at
    Re: Re: Re: Multiple Vendor Item Codes

    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
    on at
    Re: Re: Re: Re: Multiple Vendor Item Codes

    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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans