Item table mirroring in different companies

monegronio

Hi,
We are working with just one database, but different companies and do not share any tables at all. But now I need to make a mirror to syncronize some item record fields in the different companies. We need to have nearly the same data in every company, at least the same records (item no., description, and so on).
I have never done this before. Please, I would like some help or a link for further information.

Thanks and regards.

Bgestel

you can use a property on the table called datapercompany

warning : if you change it to NO, and that is what you want to do, you cannot put it back to yes.


or there is also a buildin cal function called

CHANGECOMPANY (Record)
Use this function to redirect references to table data from one company to another.

[Ok :=] Record.CHANGECOMPANY([CompanyName])

hope this helps

DenSter

NEVER

EVER

EVER

set any master table with DataPerCompany = No. It is just an all out bad idea, for a variety of reasons too many to go into here.

If you want to know search mibuso, there's a lot of stuff about that.

Alex_Chow

Yes... You never should. Check out my blog on how to handle this:
http://dynamicsuser.net/blogs/alexchow/ ... n-5-0.aspx

David_Singleton

Bgestel wrote:

you can use a property on the table called datapercompany

warning : if you change it to NO, and that is what you want to do, you cannot put it back to yes.

...

NO NO NO NO

Don't even think of giving advise like this. Yes it can be done, but believe me if is someone is asking the question, and say they have never done it before, then this is NOT the solution for them.

:evil:

Bgestel

:shock: :shock: :shock: :shock: :shock:
Thunder lightning and some more thunder and lightning
:shock: :shock: :shock: :shock: :shock:

It looks like i got myself some attention in here

And their comments are all completely justified.

My appologies for exposing monegronio the the dangers of datapercompany :evil:

But look at it from the bright side, at least know he knows what not to do.

TrippyZ

All agreed. However I do like to use the option for Account Schedules, it saves having to recreate the same report in each of four companies....