Hello
Our company uses Microsoft dynamic GP and recently we have opened a new branch and we want to use the same company there.
I know its possible to connect branch with main office through VPN or
similar technologies but we tried them all and they are very slow.
So we want to install a new server in branch and install GP on the
server and load same database which we use in main office to branch
server, this way branch users will be accessing there own local server.
Now, we want to know is there a way sync both databases (branch &
main office) over night so both sites will be updated? of course I dont
want to overwrite any database over the other one, I just want update
all records so they will representing correct information.
For example:
Item A has a stock of 7Pcs in location 1
item A has a stock of 10Pcs in location 2
Lets say 2Pcs sold from location 1 and 6Pcs from location 2
after syncing I want Item A overall QTY to be 9Pcs (loc1 = 5, loc2 = 4 so total is 9)
Same effect should happen in all the modules (inventory, financial, sales, etc)
Thank you
*This post is locked for comments