Get current selected parameter in records to include query of vendor account statement

(0) Share

Report

Posted on by D365Explorer

Hello everyone,

I want to generate and send the vendor account statements to the selected vendor or vendor group specified in the 'Records to Include' parameter. While I understand that obtaining the RecId is possible in 'prePromptModifyContract' if the report is generated from a form, I am not sure about how to achieve the same in a standalone output report in controller class, particularly when dealing with the vendor or vendor group in the 'Records to Include' query . i want to get the parameter from contract class and records to include filter to generate and send the attachment Please suggest a way i can achieve this

Regards,

I have the same question (0)

All responses (4)

Answers (1)

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

You can call the query in the DP class ( records to include). On processReport method add the following code :

Query query = this.parmQuery();

QueryRun queryRun = new QueryRun(query);

while (queryRun.next())
{

// assume Vendor table is Table 1 and vend group is Table2
Table1 = queryRun.get(tableNum(Table1));
Table2 = queryRun.get(tableNum(Table2));

// insert in your temp table
}

Was this reply helpful? Yes No
D365Explorer 95 on at

Like (1)

Report

Hello Waed,

I know how to get the query in DP. However, my goal is to send vendor account statements as emails to the selected vendors directly specified in the 'Records to Include' query or to the vendors belonging to the vendor group selected in the same query. For the email logic, I have created a separate class where I pass the vendor and contract class. Now, I want to call this class from my controller class extension and iterate through the vendors obtained from the 'Records to Include' query. I am facing difficulty in accessing the 'Records to Include' query in my controller class, I'm not sure how to do that

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

You can call getFirstQuery() in the controller class.

Was this reply helpful? Yes No
Verified answer

D365Explorer 95 on at

Like (1)

Report
Hello Martin,

Thankyou for the suggestion. I'm able to get the record now by using bellow snippet.

protected void preRunModifyContract() { super(); VendTable VendTablelcl; Query query; QueryRun queryRun; query = this.getFirstQuery(); queryRun = new QueryRun(query); while (queryRun.next()) { VendTablelcl = queryRun.get(tableNum(VendTable)) as VendTable; } }

PS: I'm trying to mark Martin answer as verified but site keeps getting stuck on processing.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get current selected parameter in records to include query of vendor account statement

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Get current selected parameter in records to include query of vendor account statement

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates