web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Create query method wi...

Finance | Project Operations, Human Resources, ...

Unanswered

Create query method with parameter condition

(0) Share

Report

Report

Posted on by Community member

2

I need to create a query method with parameter condition like the following

Select QTY from inventtrans where datefinancial <= @Startdate

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

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

Like (0)

Report

OK, so what do you need from us? Also, please give us some context.

And what's your version of Dynamics AX?

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

Dear @Martin

I'm working on a new report on Dynamics AX 2012 R3, I added parameters for the report like the start date.

Now I created a query in a method and need to add a condition to calculate the QTY before the start date of the report.

the query below that I created I need to refer the condition with the StartDate parameter.

I'm new on development and following some documents to create the report.

Was this reply helpful? Yes No
Martin Dráb 237,985 Most Valuable Professional on at

Like (0)

Report

There is no startDate variable in getAddedQty(). You have no such a variable declared in the method, no such a variable in the class header and also no such a variable was inherited from a parent class. Therefore the compiler is right when saying that such a variable doesn't exist.

You have it in another class - the contract class. You can access the variable directly from other classes, but it's exactly what parmStartDate() method is for.

By the way, running a separate query for every transaction would be very inefficient. You should try to create a query that calculates for all transactions at once.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

André Arnaud de Cal... 467 Super User 2025 Season 2

#2

Martin Dráb 420 Most Valuable Professional

#3

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans