Microsoft Dynamics AX (Archived)

Lookup not work when Changing Company

(0) Share

Report

Posted on by ALAhmed

916

Hello,

We added a lookup based on EDT relation in a form , everything works fine with admin.

Now , for the usr1 we added the "system user" role and another specific role "role2".For both role we have assigned organisation as :

1346.Capture.JPG

Now ,everything works fine when we connect with usr1 to company1 for the first time , so when we switch to company2 the lookup don't get data.

But when we start to connect for the first time with the company2 it works but in the company1 does not works.

the problem is when we switch the company to another , but i can't identify why is not work

Any idea for this issue?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Make sure your user has System User security role as well, that is needed for a lot of basic functionality in AX.

Did you try to have a look in a Trace to see what SQL statement is executing to fetch the values for the lookup? That might reveal the issue if it is access rights related or something similar (virtual company account, table perspective, shared vs. company-specific table, etc.)

Was this reply helpful? Yes No
Suggested answer

Andrew Xu 3,877 on at

Like (0)

Report
Copy link

Link copied!

Alex,

This sounds weird, but did you test with a table relation instead of keeping using the EDT relation?

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply.

I tried to create field control on the form with lookup method , but i have the same result.

still looking for asolution

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report
Copy link

Link copied!

I was able to identify the reason why is not work ,the client has implimented the XDS framwrok.

Here i look for undersanding why is not work with XDS security policies

Was this reply helpful? Yes No
Andrew Xu 3,877 on at

Like (0)

Report
Copy link

Link copied!

The XDS your client implemented only works when user changes company? What happens if you disable the XDS for that user?

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your reply so far, much appreciated.

The client has created a query lik this :

In the method we have :

public static RecId CostCenterDimensionAttribute() { return DimensionAttribute::findByName("XXX").RecId; }

And the security policies was created as :

When i make constrainedTable property on No , everyThing works fine.

How can i let this property on yes and the user can view the data in the lookup when changing company.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

You could set XDS state on or off for specific piece of code, we do that to lift up security for certain areas to get over the framework knowingly. It is possible through the XDSServices class, have a search on it.

msdn.microsoft.com/.../xdsservices.setxdsstate.aspx

Was this reply helpful? Yes No
ALAhmed 916 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply.
Current lookup on standard Form is because of realationship EDT

I overridied lookup method on form DataSource.The custom lookup implement XDSServices.setXDSState(0) as :

It still not working if i change the company

Was this reply helpful? Yes No