News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Sad 650 on at

Like (0)

Report

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 ... 13,380 on at

Like (0)

Report

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!!!

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans