Item table mirroring in different companies

monegronio
monegronio Member Posts: 2
edited 2008-06-20 in NAV/Navision Classic Client
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.

Comments

  • Bgestel
    Bgestel Member Posts: 136
    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
    **********************
    ** SI ** Bert Van Gestel **
    **********************
  • DenSter
    DenSter Member Posts: 8,307
    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Yes... You never should. Check out my blog on how to handle this:
    http://dynamicsuser.net/blogs/alexchow/ ... n-5-0.aspx
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • David_Singleton
    David_Singleton Member Posts: 5,479
    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:
    David Singleton
  • Bgestel
    Bgestel Member Posts: 136
    :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 :D

    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.
    **********************
    ** SI ** Bert Van Gestel **
    **********************
  • TrippyZ
    TrippyZ Member Posts: 87
    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....
    Professional Navision Developer

Categories