I have a requirement to syncronize items betwen two companies. Just the list of items and their configurations. The idea is that company B will purchase everything from Company A but they will share the same list of products which Company A will purchase and warehouse.
I've seen various approaches to this mentioned. One is to share the table - something which doesn't seem to come highly recommended. Another is to write code to do the job.
Anyone care to comment? Does a commercial addon exist to do this type of thing?
No point in reinventing the wheel.
Regards
Ian Murphy
0
Comments
Just look for DataPerCompany property of the tables
Certainly replicating a table is less risky than sharing since you are always working against a copy.
Has anyone reading ever actually done this sort of thing. Can't imagine its something unusual.
Ian
should of course read
'Do you know what sort of side effects this would cause?'
In my opinion there are two valid approaches:
1 - you create a separate global table that is a copy of the master table from which each company draw records from
2 - you write code to synchronize records between companies using CHANGECOMPANY logic
RIS Plus, LLC
A solution from a different angle is to use the responsibility centre functionality to acheive your goal. You can then filter the chart of accounts / statement by responsibility centre. It's a trade off the amount of Dev you need to do on sync'ing verses splitting reporting/form. I have been involved in implementations with multiple trading companies on one database company and use the responsibility centre split for addresses / logo.
It depends how indepentant the companies are and the overlap of customers (your other post) - e.g. two statements or grouping on one.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
The data director was designed for a retail environment in which separate databases (the store and the headquarters) had to share master data (in particular items).
For replicating Items between the two databases, it would work really well.
It has a number of advantages over SQL Server replication - but the best one is that with this method, you can change the schema (add fields) of the table relatively easily without having to rebuild your replication (unless you want the fields to come across). This situation makes standard SQL replication just fall down.
In fact, your problem is part of any standard LS implementation.
Typically, in LS, you create Template company in the Head Office that contains all of the master data. It is updated automatically with the Data Director whenever master information is entered in the Head Office. This would satisfy your requirement.
The purpose of the template company is to more easily deploy databases at the Stores, but otherwise it functions quite well simple as its own company.
It's simple enough to solve using the proper code. I can finish it by the end of day Friday if you're interested.
http://www.SobyLand.com
651-815-0698
You never know we may take you up on the offer - but I wouldn't hold my breath.
Data transfer wizard
http://www.mibuso.com/dlinfo.asp?FileID=751
Or perhaps Sql Syncro
http://www.mibuso.com/dlinfo.asp?FileID=883
http://www.BiloBeauty.com
http://www.autismspeaks.org