523
Hi All,
I've trail balance report, I want to get report based on ledger account & Posting layers like Current, Operations, Tax, Only Operations, Only tax, Total
Technically, how to pass more than two Enum parameter value to retrieve the trail balance report.
Thanks
You can input multiple values in the query dialog. Most likely your issue is somewhere else.
I just tested this with AX2009 with Customers report and it works.
I have two customers, A and B. I set the "Stopped" value (on General tab page") to "Invoice" for the other customer. For the other one I left the default value "No".
Then I printed Customers report, and selected these two customer accounts in the account number criteria.
Then I added filter for "Stopped" field, adding two values: "No" and "Invoice". Both customers were printed.
I changed the filter for "No" and "All". Only one of the customers was printed on the report.
So it definetely works, and your problem is explained by something else than not being able to pass multiple enum values in the query dialog.
Hi,
I've added new data source(Ledger trans) into report and but ledger trans table was already used in X++ query.
In few conditions, enum is assigned as static value. so , I've changed it. Now, it is working if we pass different enum values.
But, if we pass multiple enum value, it is considering only first value of base enum and retrieving records.
Kindly suggest if you have any idea.
You can do it with the standard query dialog (the one that you can open with Select button if your batch / report has a query), no need for x++ development
In normal dialog field it's possible to select only one enum value.
Pass from where? From query dialog? Or x++ code?
You can pass many enum value ranges in a query dialog by providing many values separated by comma.
And in x++ you can add many ranges for the same field (also for enum field) and the ranges will be considered as OR.
#1
André Arnaud de Cal...
292,892
Super User 2025 Season 1
#2
Martin Dráb
231,772
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
