Different Objects for different Companies in one DB

AsiriAsiri Member Posts: 26
Hi,

In Navision within one DB can create multiple Companies. If we do any change into one object (ex. Customer Card, add a new field) in one Company it will effect to the other Companies also (it can see in the other companies Customer Card also). Is there any way to handle this situation by not appearing one company object changes to other companies.

Your response is highly appreciated.
Warm Regds,
Asiri

Comments

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    The only way to handle this is to create two objects and create AL code to handle the call's. However this is not recomended. Recommended is to keep the same objects.

    For very small changes you can influence the apearance of a form by AL code like currform.control.visible or currform.control.xpos/ypos.

    Sorry.
  • ta5ta5 Member Posts: 1,164
    I share the opinion of Mark. Only very small adjustments should be made. Sales documents, etc. is a an exception.
    By the way, you can distinguish the companies with the system constant COMPANYNAME.

    Thomas
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Yes, most reports can be controled using the report selections. This way you can change the invoice layout per company. Make one report in the object designer for each layout.
  • strykstryk Member Posts: 645
    Just briefly: If you run on SQL Server it is technically possible to have multiple sets of objects in the database; e.g. a different versions of table 36 without adding a new table with "Object Designer".

    The trick is to copy the "Object" table - as many times as you wish - and then point to the different sets (Object tables) on demand, by modifying the "identifiers" in table $ndo$dbproperty ...

    But implementing this properly is really tricky business, and if done wrong you'll definitely screw up your system ...

    Just for "inspiration" :-k

    So, you should stick to the options mentioned by Mark and Thomas!
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • AsiriAsiri Member Posts: 26
    Hi Thks a lot for your comments, it's greatly appreciate.

    Thks again, Mark, Thomas & Jorg.

    Best Regds,
    Asiri
  • AsiriAsiri Member Posts: 26
    One table can link with only one "LookupFormID", even if we create seperate objects same lookup form will popup if the user press F5. (Ex. Customer table "LookupFormID" link with "Customer List". if we create seperate Customer Cards even if the user press F5 in Customer card same "Customer List" will popup).
    Can we customize this table "LookupFormID" property?
  • kinekine Member Posts: 12,562
    No, you cannot, but you can add your own C/AL code into OnLookup trigger and call what you want...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.