513
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
