Propagate Items between companies in the same database

a) Take a look at CHANGECOMPANY command and Data Per Company property of a table.
b) Search this forum for these keywords.

jannestig wrote:

You can do it by sharing the item table between the 3 companies by changing the property of the item company.

It has been done several times but you will need to be careful in planning it espically if each company is in a different country and will have different costs and prices involved.

If its all the same then you should be able to work it out
look up "datapercompany" field property on the tables

I would never recommend this method. There are so many dangers in this that it is just not worth the effort. I have had this request many times form clients, and in the end the best solution I have found is to replicate the item in each company. The code to do this is easily 1/10th of the code required to share the table. And with replicating the items the chance of a major bug are very minimal. Sharing the table is about 99% chance that it will at some stage in the future explode in a very big way.

As a customer who does have this (and other) tables shared across companies...don't.

Write the code.

It was that way when I came here, but I wish they had never done it. Granted it's not as bad as it could be. We don't have someone change an item/customer/vendor in company A and then someone complain in company B.

But they didn't share everything they should have and shared other things they shouldn't have. Default dimensions to name one.

Running on SQL, the back-end is confusing. Instead of Company$Table all the shared stuff is just Table. You get to the point where you just remember what tables are shared when you do queries and reports, but it's annoying.

Thankfully that mess will be no more once...I mean if...we upgrade.

Josetxo wrote:

Hello,

I'll have a look at the propertiesyou mentioned, thank you.

David Singleton, mattrax: thanks as well. You do not recommend sharing the Item table. I'm sure you have valid reasons for that but, how can I replicate the item via code instead? Where should I place it?

Josetxo

Did you check the link I provided?

The same discussion was also here:

viewtopic.php?f=23&t=32588

so, make it like Alex wrote in his BLOG

Regards

Josetxo wrote:

Alex, our version is 4.0. The restrictions you are talking about in your post do not apply to our DB, do they?

Thanks,
Josetxo

Josexto,

Alex's blog mentions average costing as ONE of many issues. In ALL versions of Navision back to 1.1 there are problems with sharing master tables. Just follow Alex's suggestion.