Options

Customer and Vendor masters common across companies

VijaykumarVijaykumar Member Posts: 36
Hi,
I am using Navision 3.7. I want to know, is there a way where we can have the customer and vendor masters common across all the companies in a database. I mean, if we create a customer code in one company and it would be available throughout all the other companies. This is required bcos the customers and vendors are common across the group and we can avoid duplication of the same. And also the same codes can be used in all the companies. The master codes are generated at our head office. Pls suggest........
Thanks in advance.
The man who can own up to his error is greater than he who merely knows how to avoid making it.

Comments

  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Have you searched the site? There was a discussion about this last week.

    http://www.mibuso.com/forum/viewtopic.p ... highlight=
  • Options
    ara3nara3n Member Posts: 9,256
    You need a modification that will replicate the Customers and Vendors. I've done it for items across 20 something companies and it's works.
    I wouldn't suggest change the datapercompany to no.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    ArgonauteArgonaute Member Posts: 3
    ara3n,

    I also read some strong view from DenSter against setting DataPerCompany to no.

    I understand at least one reason: All the references the copied record makes to other tables (business posting group, payment terms...) must also exist in the target company.
    But is there anything else?

    In my case, I would like to share the item master table, and the following holds true:
    _ All fields of an item have the same value for the two companies (except, of course, for the flow fields)
    _ All tables the item table refers to (UOM, inventory posting group...) also have the same values in both company, and I could actually make them shared as well

    This being verified, would you still recommend forgetting about the DataPerCompany property?
  • Options
    VitVit Member Posts: 4
    Hi Vijay,

    I had the similar situation one long back. I did the following:

    Wrote a routine, when a CoA or Customer or Vendor or Item is created in one company, the data is replicated in all another companies.

    The same routine is used (using NAS) to check the data is same across all the companies. NAS runs once a day (night). If there is any distrubance, routine create a Log.

    All the best,
    Sudhakar
  • Options
    DenSterDenSter Member Posts: 8,304
    The biggest functional problem with setting the DataPerCompany property to No is that when someone in Company A changes something that is only relevant for Company A, that then is also modified for all other companies. Say an Item falls without Inventory Posting Group ONE, and the manager of company A decides to change that to TWO. The manager for company sees that the Inventory PG has changed, and will then change it back to ONE.

    As I have said many times before, you really need to think it through before you start messing around with the DataPreCompany property. In my opinion it is NOT worth it. Create a 'global' copy of the master tables and write functionality to copy from them. This way you have a set of master data that you can share, and all companies have some control as to the details.
  • Options
    ArgonauteArgonaute Member Posts: 3
    Denster,

    Thank you for confirming what the problem is.
    One condition for setting DataPerCompany to No would therefore be that one single company has ownership (maintenance rights) on the table, while the other(s) may only query/refer to its information.

    This is pretty much the situation I have at hand with Item Master, except for:
    _ Planning parameters
    _ Unit cost and Last Direct Cost
    ... which could be takled by using SKUs...

    All things considered, and as intriguing this feature is, it may effectively not be worth playing sorcerer apprentice. I'll confine my live experiments to system tables such as Manufacturer code and Product group code.

    Frederic _
Sign In or Register to comment.