Hi guys,

I have a current dBase functioning perfectly, but need to allow 'multiple' locations for stock? (Inventory management).

So one item can be in one of 8 locations, and the total of the stock at all 8 locations is the total group stock.

Any ideas to the easiest way?

Cheers

assuming you get the total stock/inventory by adding transactions then all you need to do is add a location field to each inventory movement.

then you get the total per product by summing movements for the item

but you also get total by product by location by summing, including the location.

still a fair bit of work to do in terms of changing all your input forms, all your reports etc.

you still can get real world issues, such as when selling stock etc, the location has to be taken into account, and the despatch location may not reflect movements from a storage location to the despatch area.

Ok - Sounds easy enough.

How would I make it so that one form would do the following:

Remove x from LOCATION 1
Add x to LOCATION 2
Reference field 'TRANSFER OUT' to LOCATION 1
TRASNFER IN to LOCATION 2?

For the history table?

Cheers....