Microsoft Dynamics AX (Archived)

How to get Lookup in AOT query range field value in Inquiry form + AX 2012

(0) Share

Report

Posted on by Karthik Desappan

5,680

Hi all,

I have created one query in AOT and setting the range field for the same.

for e.g. Created query in AOT name 'AX_Query' data source is Vendtable table and set the range for 'AX_Query" ranges are Vendor Account, Currency see below screen shot,

Now, when using this query into Report the report parameter form having select button to set the ranges in report inquiry form.

like below screen shot.

after that, when clicking a vendor account field criteria to display all type of vendor in lookup,

In Standard scenario:

vendor account criteria lookup value:

Accnum - group

A001 10

A002 20

A00 30

but, my requirement is when clicking a vendor account field criteria to display only particular type of vendor in lookup.

My requirement vendor account criteria lookup value :(only vendor group 10)

Accnum - group

A001 10

if this is possible in query inquiry form please let me know. I have struggling how to do it.

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

Luan Nguyen 689 on at

Like (0)

Report

RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

This is a simple way to get range for report, but in some case you can put fields above to parm and write lookup method for it
Karthik Desappan 5,680 on at

Like (0)

Report

RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

Hi ivan,

I have using query and write some coding init method using query filter class but how we get lookup based one query range field from another.

if u know anything abt query related filter criteria pla let me know......
Suggested answer

Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

Well, as I said, it's software, so anything is possible. So yes, you can achieve through customization of larger scale.

But I'd suggest that you add a field for specifying the vendor account directly on the report dialog. This way, you'll be able to easily override the lookup for it.

Upd. Oops, took my bloody time replying :) You already have the same reply above...
Suggested answer

Martin Dráb 230,445 Most Valuable Professional on at

Like (1)

Report

RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

As Ivan already said, it would be possible with some customizations. But don't do that - instead, add a normal field to the report dialog.
Karthik Desappan 5,680 on at

Like (0)

Report

RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

Hi ivan,

if this scenario simply possible or not?
Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: How to get Lookup in AOT query range field value in Inquiry form + AX 2012

Without a number of customizations - you can't filter the looking values displayed in SysQueryForm.