web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

dynamics nav object id and data model

(0) ShareShare
ReportReport
Posted on by 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)?

I have the same question (0)
  • Suggested answer
    Jyotsna NAV Profile Picture
    585 on at

    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.

  • HarpreetSethi Profile Picture
    15 on at

    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
    585 on at

    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
    15 on at

    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
    585 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans