John,

I think you need to distinguish when the "main office" is acting as an "office" and when it is acting as "Headquarters."

The Main office is like any other branch office (like South) with regard to stock and sales. Sales made by Main subtract from Main's inventory, just like sales made by South subtract from South's inventory.

But Headquarters will get sales reports from Main, South, etc. even though Main is just down the hall.



>Hi,
> I am developing a multiuser application, POS and inventory.
> This application will be sold to a company which has branches. According to client, head quarter and branches will take care of their own stock, and sales. It is fine since they will not "cross" to other database in different location.
> However, they have a requirement that, headquarter should able to collect all of the data from branches for strategic planning and may be other checking purposes. Therefore, they need to know where do the invoices, PO, and etc being issued.
> How would you design it in order to recognize those records?
>
>Thank you