Small and medium business | Business Central, N...

SETFILTER DATE

(0) Share

Report

Posted on by aaaaaaaaaaaaa

hello I'm sorry for the inconvenience I hope you're okay I will try to explain to you a case in navision I have a flowfield field in the vendor card which calculates the evaluation of each vendor by each reception until everything is fine after a meeting with the client, he wants this field to display the vendor’s average per semester (1st semester of 01/01-->06/30)(2nd semester of 07/01-->12/31) but by example we are on 04/17/2022 the average grade that must be displayed is from the 2nd semester of the year 2021 roughly this average must display the average grade of the semester - 1. I added another date type field in the vendor table a flowfilter and I integrated it into the average rating field in the same table and in the page vendor I added a function scorevendor which will have a setfilter of the field but I don't know how to give it in the parameters especially I don't know how to write a code to calculate the score for semester-1 . I hope you understand my case. while waiting for your return, I wish you a good day

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 81,415 Super User 2025 Season 1 on at

Like (0)

Report

RE: SETFILTER DATE

Hi, You can use FlowFilter in FlowField, so that you can filter on dates.

https://docs.microsoft.com/en-us/dynamics-nav/flowfilter-overview

For example, in table 15 "G/L Account"

But for such complex cases, I recommend creating a variable that updates the data in OnOpenPage (Page) Trigger or OnAfterGetRecord triggers.

Hope this also helps.

Thanks.

ZHU
matthias_rabus 160 on at

Like (0)

Report

RE: SETFILTER DATE

Can you show as a bit of your code? Especially the function ScoreVendor would be great.

You can find a good example for Setfilter in the Docs:

docs.microsoft.com/.../setfilter-function--record-

Furthermore, I think you need to calculate the start and end date of your semester and then set these dates as your date filter
Suggested answer

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

RE: SETFILTER DATE

What data is your score based on?

Your vendors ability to deliver on time and on quantity?

What is the datasource for your flowdfields?