Navigation:  SHOPKEEPER > INVENTORY >

RELOCATE.V9B

Previous pageReturn to chapter overviewNext page

RELOCATE.V9B

 

Important:

   These instructions are valid for versions 9 and higher

   See separate instructions if you are have version 8.7 or

   lower.

 

To change location codes to "ZZ"

 

(this is for the example of moving items to

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

codes below in the instructions to match your to- location.)

 

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 5ZZ,510 for major codes 5ZZ 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   "ZZ"

USE INV_LOC EXCLUSIVE

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

REPLACE   ALL   LOC   WITH   "ZZ"

QUIT

 

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 INV_LOC and SKU_NO - not

a space.

 

Next you need to run a utility called INVLOC - choose File, Misc,

Utilities and pick INVLOC. If you don't have this new utility ask

Compulink to e-mail it to you.

 

Check some inventory numbers to verify that they moved in

accordance with your expectations.