You’re offline. This is a read only version of the page.
Hi, everyone
I am trying to create a web service for the 'G/L Balance/Budget' page 422 in Business Central, but I am having trouble filtering by fields that are not part of the underlying table for that page.
I have tried using the filters that are part of the G/L table
Same thing I cannot do for the PeriodType
they only work for the fields that exist in the table. Is there a way to filter by fields that are added to the page but not part of the table? Any suggestions or guidance would be greatly appreciated!
YOU HAVE TO CREATE NEW FIELDS USING TABLE EXTENSIONS THEN FILTER WITH IT
You need to add data first on newly created field, and then you can use this field as a filter in your API url
Thank you for your suggestion, Nitin Verma. Can you please clarify how to use my field to filter data on the G/L Balance/Budget page? Thank you again.
Unfortunately it will no work, you have create a field using Table extension, and use that in filter the data.
Thanks, Nitin Verma.
I understand that the filters will only work for the fields that are part of the table, but in my case, I need to filter by fields that are added to the page but not part of the table. My requirement is to create a flow in Power Automate to pass the necessary parameters to that page and get the filtered data in response, which I have to email to someone. Do you have any suggestions or guidance for me?
Regards
Hi,
If the fields are not in table only in page, and then It will not filter the data, if the fields already available in the Table, you can try with option's index value if its not working with option's text value.
Thanks.
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (