The form datasource query object does not support changing its AllowCrossCompany property

(0) Share

Report

Posted on by saman0suke

2,894

Hi, I'm working in AX 2012 R2, and I need to display records from different companies so I set the property on each datsource to allow crossCompany, however I'm getting the error as soon as the executeQuery gets is called:

The form datasource query object does not support changing its AllowCrossCompany property after the form has executed the query.

I would appreciate your help on fixing this issue. The records are retrieved fine but the error is showing up. Thanks.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Ivan (Vanya) Kashperuk on at

Like (0)

Report

Check to see if you are also trying to update this property from code?

Was this reply helpful? Yes No
saman0suke 2,894 on at

Like (0)

Report

Maybe someone else is doing it, I will take a look at it, what if that's not the case? Thanks!

Regards.

Was this reply helpful? Yes No
saman0suke 2,894 on at

Like (0)

Report

I just checked and no one else is trying to set that on code, what else should I check? thanks.

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report

Hi

Have you modified the code in excuteQuery method? if so, can you put the code before super()?

Was this reply helpful? Yes No
Amir Nazim 5,994 on at

Like (0)

Report

how u set the allowcrosscompany property . through code ?

Was this reply helpful? Yes No
saman0suke 2,894 on at

Like (0)

Report

The code after super() does not make any reference to crossCompany, just regular code, and the property is being set on the datasource by using the property CrossCompanyAutoQuery. Thanks.

Was this reply helpful? Yes No
Suggested answer

Jonathan Halland 11,310 on at

Like (0)

Report

Hi.

Try set the "SetCompany" property on your form's design node to "No"

Was this reply helpful? Yes No
saman0suke 2,894 on at

Like (0)

Report

Did not work, any other idea? thanks for the help.

Was this reply helpful? Yes No
Mic Kan on at

Like (0)

Report

You are right, I faced with this problem lastly and followed Your suggesion with overwrite DS executeQuery method:

public void executeQuery()
{;

this.query().allowCrossCompany(true); //this is literal for this example, change in practice to sth more functionally
//
super();

}

You don't need change CrossCompanyAutoQuery properies at form at all.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi saman0suke,

Please share the answer. i am also getting the same error but now on Dynamics 365.

Please reply me at earliest.

Thanks

Was this reply helpful? Yes No