Greetings, I am looking for a SQL statement that will transfer all inventory from one location to another. We run RMS 2.0. Thanks in advance. Lax Guy
- posted
15 years ago
Inventory transfer SQL
Loading thread data ...
- Vote on answer
- posted
15 years ago
from offline to online or from a store to another store?
cod
- Vote on answer
- posted
15 years ago
- Vote on answer
- posted
15 years ago
Hi Lax Guy - before trying it with a sql statement, try it using a worksheet
330: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: