Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Data entities not returning data in ACC. Fine in DevBox

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

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at
    RE: Data entities not returning data in ACC. Fine in DevBox

    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.

  • Martin Dráb Profile Picture
    Martin Dráb 230,868 Most Valuable Professional on at
    RE: Data entities not returning data in ACC. Fine in DevBox

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

  • blom0344 Profile Picture
    blom0344 50 on at
    RE: Data entities not returning data in ACC. Fine in DevBox

    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

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,868 Most Valuable Professional on at
    RE: Data entities not returning data in ACC. Fine in DevBox

    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.

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at
    RE: Data entities not returning data in ACC. Fine in DevBox

    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 230,868 Most Valuable Professional on at
    RE: Data entities not returning data in ACC. Fine in DevBox

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

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at
    RE: Data entities not returning data in ACC. Fine in DevBox

    Thanks Martin,

    Nope; tried that with the same result:

    pastedimage1673450630558v1.png

    Cheers,

    Gerard

  • Martin Dráb Profile Picture
    Martin Dráb 230,868 Most Valuable Professional on at
    RE: Data entities not returning data in ACC. Fine in DevBox

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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans