Hi,
I am developing Multi-user POS/Inventory Application. I faced a problem, that my client hope the application to able to be run in multi-location (branches).
After couples of discussion among our developers, we decide to recommend my client to manage their sales and stock individually by branch. Eveery branch will have their database and manage/update on the branch's server. Every record of each table will have a unique branch code. Is it acceptable?
I have a problem, to generate reports which will reporting stock, and sales for more than one branches at the same time. E.g, my client wish to view all of the summary sales transactions which group by branch within a SINGLE report in Headquater.
How could I send the branchs' transactions to headquater? It may be expensive and time comsuming if request every branches to send their updated data every days or period of time. Any suggestions ?

Pls advise!

Thank you