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,682

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)

Sort by

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Without a number of customizations - you can't filter the looking values displayed in SysQueryForm.
Karthik Desappan 5,682 on at

Like (0)

Report
Copy link

Link copied!

Hi ivan,

if this scenario simply possible or not?
Suggested answer

Martin Dráb 240,744 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.
Suggested answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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...
Karthik Desappan 5,682 on at

Like (0)

Report
Copy link

Link copied!

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

Luan Nguyen 689 on at

Like (0)

Report
Copy link

Link copied!

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