mibuso.com
Home› NAV/Navision Classic Client

Vendor Master Data Consolidation

vinagoinvinagoin Member Posts: 2
edited 2006-08-11 in NAV/Navision Classic Client
A customer with around 40 Navision-Companies in one NAV 4.00-database wants to

consolidate their Vendor Master Data. All companies should use the same Vendor Data. As this is the first time I have to do this work I'm very interested to know anybody's experiences and issues I may encounter by realising that.

I thought to approximatively proceed the following way:

- Setup a new company "Vendor Master Data".
- Define a Master-company which will be the basis for the other companies.
- Define rules to find same Vendor.
- Consolidation-Job will be started for each company separately.
- Once the Master Data is created and available, all related tables (e.g. Ledger Entry) in the companies have to be updated with the new Vendor No. (?).
- Delete data in Vendor-Tables in the companies.
- Set "DataPerCompany" of the related Vendor-tables to "No" in the new company.


Is this a practicable way? Thank you for any suggestion.

Regards,
vinagoin

Comments

  • DenSterDenSter Member Posts: 8,307
    I think you should not set the DataPerCompany of the actual Vendor table to No. What I think you shold do is create a new table, which is a copy of the Vendor table and call it 'Master Vendor' and set THAT table to DataPerCompany to no. Make sure you also make copies of all needed subsidiary tables and set those to datapercompany=no. Then you would have a master list of vendors that is visible in all companies (you wouldnt even have to create a new company), and now you can write functionality that allows users to copy the Master Vendor into the Vendor table.

    This way every company would use the same Vendor information, and would still be able to modify certain fields.

    In my opinion it is an all out BAD idea to make any master table a global table.
    Daniel Rimmelzwaan
    RIS Plus, LLC
Sign In or Register to comment.