Suggestions on Centralizing Database

[xloverboyx]

Hi To all Master jan,

Mga master jan bka pwd makahingi ng suggestions on how to make a centralize database in our inventory system. Meron kasi kaming dalawang Warehouse and both must operate the same transactions (e.g. Purchase Order, Inventory Transfers and Collections, Sales, etc.) Namely yung inventory system namin is RMS and integrated siya sa accounting software na QB.

One scenario were concerned of is regarding sa balance ng customers, since the both warehouse must operate the same transaction, yung first warehouse pwede siyang tumanggap ng orders ni customer at payments ni customer same as yung second warehouse. Ang problem is hindi na sila equal ng account balance since na yung data na nasa first warehouse is not updated to second warehouse or vice versa. Sana ma gets nu ibig kong sabihin.

I need an idea/concept paano kaya gagawin namin para maging synchronize ung data from warehouse 1 to 2. From network connectivity through software or programming tips. Considering also yung costing like VPN connection(mahal kasi yun ). Sana may makatulong sa amin. Malapit na kami mg up pero no idea pa ako.

Thank You and God Bless All,

 

[jhon1977]

Hi sir/mam i can help you.. txt me 09990465007

 

[okamoto01]

since may budget ang company nyo go for server mismo! dahil kita na ng company yan for auditing system! kaya dapat may server ang company nyo

 

[pakker]

TS pasabit. same project sakin. kaso lalagyan lang ng item, like kunwari mga png files lang. tapos lahat store dun, tapos may app lang na isearch tapos madadownload na. pwede iconnect sa sharepoint para online. pero kung may app sana na pwede. salamat sa help