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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data entities not retu...
Finance | Project Operations, Human Resources, ...
Answered

Data entities not returning data in ACC. Fine in DevBox

(0) ShareShare
ReportReport
Posted on by g.verbruggen 23

Hi All,

I'm working on an integration between NetSuite, SalesForce and D365FO (V29).

Created new data entities etc. and on my DevBox I have everything working as expected. After I moved my changes to the TEST and ACC environments, I noticed that the Queries did not return any data in these environments. Part of the integration is creating sales orders in D365FO. This works Ok, so the security, client id's etc. are OK. It's only querying the data that gives issues.

I'm using Boomi to integrate all the data. After I discovered the above I started testing the same with Postman. In Postman I have the same issues. Data is not returned from TEST and ACC. Not for custom data entities, but also not for standard D365FO entities.

Example (with a standard D365FO entity):

pastedimage1673449463034v1.png

Executed on my Dev box and you see I have a result.

When I execute it on ACC:

pastedimage1673449575789v2.png

and empty result as you can see. 

Tried several things like giving the service account user System Administrator privileges in ACC, truncate and refresh the data entities list in D365FO. Using cross-company=true etc., But without any result. 

I have no idea what it is I'm missing here. Any thoughts ?

Thanks a lot !!!

Cheers,

Gerard

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,803 Most Valuable Professional on at

    Will the result change if you add cross-company=true parameter to the URL?

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at

    Thanks Martin,

    Nope; tried that with the same result:

    pastedimage1673450630558v1.png

    Cheers,

    Gerard

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,803 Most Valuable Professional on at

    Please try it once more without the dollar sign ($).

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at

    That did the trick Martin !

    Can you explain to me why I need this in ACC/TEST and not in my DevBox ? Or point me to some documentation regarding this ? I have to go offline now, but will see your reply tomorrow.

    Thanks a lot !!

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,803 Most Valuable Professional on at

    You aren't done yet.

    Most tables in F&O can store data "per company". You're logged in a particular company (e.g. USMF in the demo data) and what you see in forms and reports is data related just to this company. For example, not all records in CustGroup table, but just those with DataAreaId = "USMF".

    The same happens with OData. By default, you see only data from the default company associated with the user making the request.

    With cross-company=true, you're getting data from all companies, i.e. regardless of the value in DataAreaId field. But you typically don't want that; you want data from a single company. If that's the case, you can either use cross-company=true and filter by a particular DataAreaId, or change the default company of the user.

  • blom0344 Profile Picture
    blom0344 52 on at

    Check Framework Parameters from The Data Management module. On one of the tabs there is a general setting (a toggle) that activates export for all companies.

    This however does not work for MSFT entities of the 'master' type. You still need to export across companies, but you can set this in the export group definition

  • Martin Dráb Profile Picture
    Martin Dráb 237,803 Most Valuable Professional on at

    This thread is about OData services, not about export through data management.

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at

    Indeed Martin: In my dev box the service account had a default company set. In ACC it didn't.

    Much obliged ! I can proceed with further testing.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans