Hello -
We deal with live product and sometimes we need to put a SKU on hold after it has been allocated to a sales order. If it is only a couple orders we will manually go in and change the line to back order. Most of the time it happens on a sku that we have hundreds of sales lines allocated. The best way to handle this would be with a SQL script. Does anyone know of one that is available? The script would need to handle any triggers involved with recalculation of the quantity on hand of the sku.
I checled Victora Yudin's site and didn't find anything, Thanks!
#Inventory
------------------------------
Sue Hall
VP - Production/Inventory
Garden Trends, Inc.
Rochester NY
------------------------------