Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to filter when cre...
Small and medium business | Business Central, N...
Suggested answer

How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

(0) ShareShare
ReportReport
Posted on by Govinda Kumar 2,198 Super User 2024 Season 1

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.

43000.png

I have tried using the filters that are part of the G/L table
63108.png

Same thing I cannot do for the PeriodType
57.png

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!

  • Hammed Rildwan Bolaji Profile Picture
    Hammed Rildwan Bolaji 15 on at
    RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

    YOU HAVE TO CREATE NEW FIELDS USING TABLE EXTENSIONS THEN FILTER WITH IT

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

    You need to add data first on newly created field, and then you can use this field as a filter in your API url

  • Govinda Kumar Profile Picture
    Govinda Kumar 2,198 Super User 2024 Season 1 on at
    RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

    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.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

    Unfortunately it will no work, you have create a field using Table extension, and use that in filter the data.

  • Govinda Kumar Profile Picture
    Govinda Kumar 2,198 Super User 2024 Season 1 on at
    RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

    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

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans