Inventory transfer SQL

from offline to online or from a store to another store?

cod

Hi Lax Guy - before trying it with a sql statement, try it using a worksheet

create it with the following settings: from store to deplete, to store to receive all items in all depts transfer all items at qty 1 of ea go to contents tab of newly created worksheet select first row last col "qty to Xfer", click on it so formula button is enabled click on "formula" and set formula "qty at source" plus zero select apply formula to all rows in this column on bottom of formula window click ok approve and process

This should create a transfer for all items and qties at source to the store of your choosing - hope this helps....

"Married women usually weigh more than single women; single women come home from work, open the fridge, sigh and go to bed; married women come home from work, open the bed, sigh and go to the fridge"

"lax guy" wrote: