I need to assign an item message to a large number of items all of which belong to a specific category. Is there a way of doing this without going into each item individually? Can I somehow do it on a category basis? The message will apply to about 2,000 items so you can see the scale of the problem!
Item Message
Aug 20, 2007
3 Replies
Alastair, The only way to accomplish this without a customization is through direct SQL. The script below will allow you to set an item message to items given an item message title and a category code:
DECLARE @ItemMessageTitle nvarchar(30)
DECLARE @CategoryCode nvarchar(17)
/*Set variables here */
SET @ItemMessageTitle = '' --Set the ItemMessage title to be used
SET @CategoryCode = '' --Set the Category Code to be used
UPDATE ITEM
SET Item.MessageID = (
SELECT ID
FROM ItemMessage
WHERE Title = @ItemMessageTitle
)FROM Item
LEFT JOIN Category
ON Item.CategoryID = Category.ID
WHERE Category.Code = @CategoryCode
This script is provided as is with no implied or expressed warranty. Please make sure you always backup your database.
Thanks very much Ryan. I'll give it a go.
Maybe MS could look at this for future releases > Alastair,
Alastair, We are actually working on an add-in that extends the capabilities of the Inventory Wizard, I will suggest to our product developers that this be included.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required