ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Batch Location Adjustments
http://www.istechforum.com/YaBB.pl?num=1231367763

Message started by PaulG on 01/07/09 at 15:36:03

Title: Batch Location Adjustments
Post by PaulG on 01/07/09 at 15:36:03

I am looking for a way to quickly transfer all inventory from one location to another.

A few sales orders were accidentally entered under the "blank" default location. The BOM for these parts is quite extensive so it resulted in hundreds of parts being pulled from the wrong location. I have messed with IN-L-M on a test database but it requires you manually type every single part number and quantity you want to transfer, rendering it only mildly more efficient then using the standard IN-L-J.

Is there any way to transfer all items from a single location to another location? Also is there a way to prevent any transactions on the "blank" location.

Sorry if this is a redundant post. I searched thoroughly and did not find anything that answered this question.

Title: Re: Batch Location Adjustments
Post by Kelloggs on 01/08/09 at 10:25:43

Try this on you Test Company!!!!

Use your Pervasive Control Panel

To move all items from Blank Location to The Proper Location run the following query
UPDATE BKICLOC SET BKIC_LOC_CODE = 'The Proper Location' WHERE LENGTH(BKIC_LOC_CODE) = 0
Or
To move all items from wrong location to The Proper Location run the following query
UPDATE BKICLOC SET BKIC_LOC_CODE = 'The Proper Location' WHERE BKIC_LOC_CODE = 'Wrong Location'

These queries will move all items from on location to another

Or

To move some items from one location to another location run the following query
UPDATE BKICLOC SET BKIC_LOC_CODE = 'The Proper Location' WHERE BKIC_LOC_PROD = 'ABC%'

This query will move all items that start with ABC from on location to another

Then

On DBA Run SM-J-C use: Y-Y-N-B.

This utility will "consolidate" UHO with the same location

:)

Kelloggs

Title: Re: Batch Location Adjustments
Post by PaulG on 01/08/09 at 14:54:48

Great thanks!

Title: Re: Batch Location Adjustments
Post by PaulG on 01/08/09 at 15:54:33

One more silly question. I am aware how to create and manipulate test companies in DBA but how do I specify a company in the Pervasive Control Center? There is only the "DEMODATA" and our company database.

Thanks.

Title: Re: Batch Location Adjustments
Post by GasGiant on 01/08/09 at 16:26:29

you need to add it