Open Forum

 View Only

Mass update a SKU on a sales line from allocated to back order

  • 1.  Mass update a SKU on a sales line from allocated to back order

    Posted 8 days ago
    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
    ------------------------------


If you've found this thread useful, dive deeper into User Group community content by role