Navigation:  SHOPKEEPER > INVENTORY >

RELOCATE.V8

Previous pageReturn to chapter overviewNext page

RELOCATE.V8

 

Important:

   These instructions are valid for versions 8.7 and lower.

   See separate instructions if you are have version 9 or

   higher.

 

To change location codes to "SR" where the code is currently set

to "AA".

 

(this is for the example of moving items in location AA to

location SR. Of course, you would change the numbers location

codes below in the instructions to match your from- and to-

locations.)

 

This also moves all items from major codes 1 to 999. If you want to

restrict that you could change the 1,999 parts to, say 95,95 for just major

code 95 or 500,510 for major codes 500 to 510

 

You should definitely make a data backup before running these

steps.

 

No other copies of the Shopkeeper/Shop-Pro may be open when you

do this.

 

From the Shop-Pro main menu, choose File, Miscellaneous Options,

Dot Prompt.

 

At the dot-prompt, type these lines, pressing Enter after each:

 

USE   INV   EXCLUSIVE

SET   FILT  TO  BETWEEN(VAL(LEFT(SKU_NO,3)),1,999)

REPLACE   ALL   LOC1   WITH   "SR"   FOR  LOC1="AA"

REPLACE   ALL   LOC2   WITH   "SR"   FOR  LOC2="AA"

REPLACE   ALL   LOC3   WITH   "SR"   FOR  LOC3="AA"

QUIT

 

Note where you see a double or triple space one is enough.

 

Note that you need to type the quote marks around the location

codes as shown above.

 

Note that there is an underscore in the middle of SKU_NO - not

a space.

 

Check some inventory numbers to verify that they moved in

accordance with your expectations.