Data entity range

(0) Share

Report

Posted on by Waed Ayyad

8,972 Super User 2025 Season 2

Hi All,

I am trying to add range to data entity the range is for Legal entity field, but it does not work. It always returns the data from DAT legal entity.

Any hint?

I have the same question (0)

All responses (6)

Answers (0)

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

Data entity range

Hi Waed, Are you trying to add range in OData? If yes then please share the url.

1 people found this reply helpful.

Was this reply helpful? Yes No
Martin Dráb 236,513 Most Valuable Professional on at

Like (1)

Report

Data entity range

Entities are normally filtered by the current legal entity. To be able to filter by legal entity and show data for a different than the current one, you need to make a query across companies. Is it the case?

In short, we need to know what you're doing and how you tried to add the filter.

Was this reply helpful? Yes No
Waed Ayyad 8,972 Super User 2025 Season 2 on at

Like (0)

Report

Data entity range

Hi Martin, Mohit,

Yes, I am trying to return data from shared table based on current legal entity. I want to add like this lookup when I open General journal using Excel Add ins. currently all the values for financial dimension are appear. I want to exclude the suspended values. How can I achieve this.

Any hint?

Was this reply helpful? Yes No
Martin Dráb 236,513 Most Valuable Professional on at

Like (0)

Report

Data entity range

I'm sorry, but I still didn't tell us how you tried to add the filter, so I'm unable to say what's wrong with it. You also didn't tell us whether you tested your entity before using it in Excel. Please be more specific.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,415 Super User 2025 Season 2 on at

Like (1)

Report

Data entity range

Hi Waed,

This question seems to be a continuation of your previous question. Journal template Export - Dynamics Community Forum Thread Details

You first would need to have a data entity being able to handle the dimension values as per your requirement. Like mentioned before, the dimension values is stored in a global data. You would need to link several tables in an entity to get a list of active dimensions for a particular legal entity. I have no experience with this specific requirement, so providing some thoughts only.

Once that entity is working, you can check to extend the current dimension values entity used for the lookup or override the settings to link your entity to be used for the lookup. Also mentioned before, it isn't the easiest topic to work on. Instead of focusing on the lookup, you can also rely on the validations when records are published to the journal lines.

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (1)

Report
Data entity range

Hi,

Depending on the issue you described, we recommend that you follow the steps below to troubleshoot the issue:

Confirm the Legal Entity field: First, ensure that the query of the data entity includes the Legal Entity field. Make sure the field is properly set in the query and associated with the relevant data source.

Add the range: In the range field property of the data entity, configure the correct range for the Legal Entity field. Ensure that you use the correct operator (e.g., "==", ">", "<", etc.) and value (such as the legal entity code) to define the range.

Validate the range: Test and validate the data entity using the defined range and check if the returned data complies with the defined Legal Entity range.

Best regards,

Kevin

Was this reply helpful? Yes No