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 RMS (Archived) / Need to add supplier i...
Microsoft Dynamics RMS (Archived)

Need to add supplier in all the items

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

I am using HQ i just created a supplier that i want to add in all items in my hq database. What query do i need to run ?

I have tested many queries but i dont know where that value is being update in the Supplier table. I understand that when you create a supplier an automated Supplier ID get generated and when you add that supplier to the item , then that item saves the supplier using supplier id in the database. So if i write the query , for example supplier id is 1 for the supplier i created

update item set supplier id = 1

Then this value gets updated in every item in the supplierid colum but that supplier does not show up in any item in HQ Manager. So it mean i am triggering the wrong table. I also checked the Supplier Properties in HQ Manager. Under the supplier properties there is another head names supplier item. This head contains all the items that being supplied by this supplier. Now i dont know where this SupplierItem is in the database. If i know that then i can work with.

I would really appreciate if someone can help me and guide me thorough. Please write you suggesstions or solutions in detail please.

Thanks

Syed

*This post is locked for comments

  • ShabbirEzzi Profile Picture
    ShabbirEzzi 75 on at
    Re: Need to add supplier in all the items

    Hi Ron,

    When i use the following

    /*

    update SupplierList set supplierid = item.supplierid

    where item.id in (select itemid from supplierlist)

    I get this error

    /*

    An error occurred while executing query:

    The multi-part identifier "item.id" could not be bound.

    Can you tell me what i am might be doing wrong...

  • Ron Rahhal Profile Picture
    Ron Rahhal 545 on at
    Re: Need to add supplier in all the items

    You're welcome!  Glad it was useful.

  • Community Member Profile Picture
    Community Member on at
    Re: Need to add supplier in all the items

    Thanks alot Ron you have done all. Thanks again.

  • Verified answer
    Ron Rahhal Profile Picture
    Ron Rahhal 545 on at
    Re: Need to add supplier in all the items

    You need to update a related table called SupplierList.  Assuming you have already run the query to update the item table (update item set supplierid = 1), then you need to run the following query:

    update SupplierList set supplierid = item.supplierid

    where item.id in (select itemid from supplierlist)

    This will update items with a different supplier to your new supplier.  Then you need to add the rest of the items by running this query:

    insert into SupplierList(ItemID,SupplierID,Cost)

    select id,supplierid,cost

    from item

    where id not in

    (select itemid from supplierlist)

    and supplierid<>0

    When finished, you need to run a Worksheet 250 tocommunicate the changes to all the stores.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans