Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / dynamics nav object id...
Small and medium business | Business Central, N...
Suggested answer

dynamics nav object id and data model

(0) ShareShare
ReportReport
Posted on by HarpreetSethi 15

I have a requirement on my project that I need to create a query/ report which needs to be generic in nature so that if I run it on other NAV environments, it should work without changing anything (of course on default objects not on custom objects). Also I need to be able to export the definition and import it into any other NAV and should be able to run it. 

For example I create a query that generates Trial Balance for company X, in one NAV environment, I should be able to reuse the same query to generate trial balances on any other NAV environment. 

If this is possible then the question is:

1. Does NAV have same object model for all the companies that we create?

2. Does it retain the same object id for all default set of objects (obviously new/ custom objects will different id)?

  • Suggested answer
    Jyotsna NAV Profile Picture
    Jyotsna NAV 585 on at
    RE: dynamics nav object id and data model

    Yes.

    You have to set it in the Table Properties.

    Regards

    Jyotsna Oberai

    jyotsnanav.blogspot.com

    Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.

  • HarpreetSethi Profile Picture
    HarpreetSethi 15 on at
    RE: dynamics nav object id and data model

    Thanks Jyotsana

    So if I have a customer who also has NAV, will same object Id work for them?

    Also where do I set the DataPerCompany to No?

  • Suggested answer
    Jyotsna NAV Profile Picture
    Jyotsna NAV 585 on at
    RE: dynamics nav object id and data model

    Yes.

    Objects are going to be same. The Data will vary according to DataPerCompany property. In your case, set DataPerCompany as No. 

    Regards

    Jyotsna Oberai

    https://jyotsnanav.blogspot.com

    Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.

  • HarpreetSethi Profile Picture
    HarpreetSethi 15 on at
    RE: dynamics nav object id and data model

    thanks for the response. So just to clarify if I have a report (lets say GL Accounting report) with ID 100. Can I run it for different companies like run report 100 for Company A and run report 100 for company B etc? 

  • Suggested answer
    Jyotsna NAV Profile Picture
    Jyotsna NAV 585 on at
    RE: dynamics nav object id and data model

    Hello,

    Welcome to the community.

    To answer your questions,

    1. NAV objects will be the same for all companies, for the data make DataPerCompany property of the same as 'No', to have the same data in all companies.

    2. Yes, it will clash in case the other environment has the same Object ID.

    Regards

    Jyotsna Oberai

    https://jyotsnanav.blogspot.com

    Don't forget to help the community by verifying my answer or at least like the suggestion if it did help in any way. It will let others know that the topic has a verified answer and was beneficial to you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans