A Location Cal Problem

[Keiath]

I have a stock control system, and we have 2 warehouses

I have a Table called Stock control that has a sub form called Stock activity. This works fine. and in the footer calculates the stock in and stock out, giving me a 'free' stock.

But now I have 2 warehouses and I need to show where that stock is (could be in 1 or both) so let say i have 2 items of stock of which 1 is in 1 location and the other in the other

By stock data needs to show the following

Total Stock:- 2
Warehouse1:- 1
Warehouse2:- 1

Whats the best way to do this

 

[plog]

Create a Warehouse table, include an autonumber primary key, the name of the warehouse, an address, phone number, etc. Then, whichever table has stock information that you want to assign a location to, you add field for the Warehouse ID.

 

[Keiath]

Create a Warehouse table, include an autonumber primary key, the name of the warehouse, an address, phone number, etc. Then, whichever table has stock information that you want to assign a location to, you add field for the Warehouse ID.

As I have stock activity table would this not infer with that? or are you saying have two tables on a stock activity and another warehouse activity and populate both?

A little unsure here

 

[plog]

I have your file and it seems that you set it up correctly. You have a Location table that lists your locations and you put a field for the Location in the Stock Activity table.

What issue are you having/ what data are you trying to generate?

 

[Keiath]

I have your file and it seems that you set it up correctly. You have a Location table that lists your locations and you put a field for the Location in the Stock Activity table.

What issue are you having/ what data are you trying to generate?

1 how do i cal in the stock control file so that it shows what stock is in each location

and the other issue is why isnt the 'stock data' tab showing the total stock, free stock, as I think i have the cal in the footers correctly

Thanks again for looking at this

 

[plog]

I think you need to reconfigure your Stock Activity table. Instead of two seperate fields called 'StockIn' and 'StockOut', you should have one 'StockAmount' and use negative numbers when stock leaves. That way you can use the Stock Activity table and sum the StockAmount field to determine how much stock is at each location.

For the forms question, what Stock Code is in error? What do you expect those fields to be for that Stock Code?

 

[Keiath]

I think you need to reconfigure your Stock Activity table. Instead of two seperate fields called 'StockIn' and 'StockOut', you should have one 'StockAmount' and use negative numbers when stock leaves. That way you can use the Stock Activity table and sum the StockAmount field to determine how much stock is at each location.

For the forms question, what Stock Code is in error? What do you expect those fields to be for that Stock Code?

Yeah i thought about using a -1 but i dont want to have to leave that to people to remember to do.

as for the stock code just 'display' the results, so total stock. - allocated stock = free stock