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) / How can i add specifi...
Microsoft Dynamics RMS (Archived)

How can i add specific "tag along item" to all items in specific category or using filter

(0) ShareShare
ReportReport
Posted on by wojak138 165

How can i  add specific "tag along item" to all items in specific category ?

How can i add  filter for item description ?

 

thank you

 

 

 

*This post is locked for comments

  • Sad Profile Picture
    Sad 650 on at
    Re: How can i add specific "tag along item" to all items in specific category or using filter

    Hi,

    You need also to update " TagAlongQuantity " , with the same query

    Update Item

    SET TagAlongQuantity = 1 WHERE CategoryID = xxx and press F5  

    note : 1 is your quantity.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: How can i add specific "tag along item" to all items in specific category or using filter

    Wojack138,

    This has to be done using SQL commands.  Backup first!!!

    Go into SO/HQ Admin | File | Connect | type in your SQL password and press <Enter>

     

    Next, Identify the Category ID that you want to use.

    Query | New | type Category and press the F5 button | note the ID that you want, call it xxx

     

    Next, open a new query to find the Tag along Item you want to use

    Select Description, ItemID from Item WHERE Description = <enter your Item description> and press F5  note the ID that you want,call it yyy

     

    Next, open a new Query and type

    Update Item

    SET TagAlongItem = yyy WHERE CategoryID = xxx and press F5 

     

    Close the queries and do not save.

    Backup First!!!

     

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans