Hi John,

You might want to address "warehouses" when it comes to inventory. Make them UNRELATED to the store locations, but assign each store a "preferred warehouse" from where to take the item that is sold.

Example:
StoreA. PrefWarehouse=1
StoreB. PrefWarehouse=2
StoreC. PrefWarehouse=3

If you sell the TV at storeA, the software will look for the item in the preferred warehouse. If it doesn't have it there, the user is presented with choices on where to get the TV from.

This design will allow you to have a Main Warehouse that's located elsewhere and also allow you to transfer items from one store to another while keeping track of these transfer transactions as well as inventory up at the company level and down at the store level.

This is how I handled an inventory app that I created about 10 years ago and has been working perfectly. (They have service trucks with a stockpile of commonly used parts for their Air Conditioning repairs and this way we can tell when a truck needs to get more of a particular item while they're at the office as opposed to needing something when they're in the field.)

Hope this helps!

Alex




>Hi,
> I am developing Inventory/POS System small/medium company. I get a requirement from my new client that need my program to handle case as below:
>
>1. My client has couple of branches around my country.
>
>2. Once any customer come to any of his shops to purchase, e.g. purchase TV frm shop A. If the TV is out of stock in Shop A, shop A may request other shop which have TV on hand to deliver TV to customer. Assume shop B got TV
>
>3. Deposit will be received from shop A.
>
>4. TV will be delivered by shop B, the balance amount will be collected by shop B either.
>
>Any ideas on how to do this?
>How to handle the stock and the amount collected?
>and etc
>
>For your info, my client have web hosting.
>
>Please advice. Thank you