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!
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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.