Microsoft Dynamics AX (Archived)

Get the Current Active Company RecId in Dynamics AX.

(0) Share

Report

Posted on by Faran Baig

125

Any body tell me how to get the Current Active Company RecId in Dynamics AX 2012.

I want to set range in query data source on the base of RecId,but dont know how to do.

08021.Capture.PNG

In the value field,i want to pass current active company RecId.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (3)

Verified answer

udaY-ch 5,133 on at

Like (0)

Report

Hi,

You need to set the range in the init method of the query.

public void init()

{

LegalEntity legalEntity = CompanyInfo::find().RecId;

super();

this.query().dataSourceTable(tablenum(Yourtable)).findRange(fieldnum(YourTable,LegalEntity)).value(queryValue(legalEntity));

}

/Uday.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (1)

Report

You can't use curExt(), because normal X++ methods can't be used as query range values and it doesn't even return RecId.

But there is a solution - you can use methods from SysQueryRangeUtil class, you just have to wrap them in extra brackets. Therefore instead of curExt(), you could use (currentCompany()).

This still doesn't return RecId, but you can create a new method (e.g. currentCompanyRecId()) doing what you need.

Was this reply helpful? Yes No
Faran Baig 125 on at

Like (0)

Report

Martin ! Actually i want to restrict workers to company specific on Retail worker forms.Want to show the workers belonging to current legal entity only.As you can see in below attached screenshot,All workers are showing in case of USRT company,but i want only workers to be shown that belongs to USRT.

Was this reply helpful? Yes No
Faran Baig 125 on at

Like (0)

Report

Udhaya Just i need this in init method of query,no need of execute query method or any other?

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Yes. This would solve your issue.

Was this reply helpful? Yes No
Faran Baig 125 on at

Like (0)

Report

Udhaya i have used same query coming under Form HcmWorkerListPage Data Sources named as HcmWorkerListPage and added above method in init method,

but not getting desirable results.Means by logging from other user and assigning my role,it is still showing all workers in Retail>Workers in any company. Although i have removed System Administrative role.

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Try to clear the AUC files and clear usage data and try checking the same. It should work.

Was this reply helpful? Yes No
Faran Baig 125 on at

Like (0)

Report

Udhaya Facing an issue in line 5,query worked,but this time nothing is showing,may be due to this stack trace.

Was this reply helpful? Yes No
Verified answer

udaY-ch 5,133 on at

Like (0)

Report

HI,

You need to create a range. Take a look at the query KanbanMultiKanbanReceive

/Uday.

Was this reply helpful? Yes No
Faran Baig 125 on at

Like (0)

Report

Udhaya my role is working fine,but a single problem is that,query takes the RecId of first company when ax opens up first time,and showing correct data of that company,but when i changes the company,it is still showing the data filtered on the basis of previous company RecId,now how to refresh and pass the next company RecId(if i change company)?

Was this reply helpful? Yes No