Location Quantity

One of the things that I like about this application is the we can do reorder tracking by location. However in working through my data imports during implementation I discovered that the Loc_Stock table has all of the right fields, except it appears to be missing an important field - Location_Qty.

This is concerning because we have a number of physically different locations that need to have a minimum stock quantity for each item in each location. We also do volume purchasing when special deals become available. The result of this is we have overstock quantities of items that will not fit in a single location. Is there an extension or method to handle these quantities in different locations requirements.