Filter for CuePages

(0) Share

Report

Posted on by Satish

Hi All,

we have a custom page with pdc ledger here all the details are same expect the entry No, it is the primary key, In the cue i want to show the count of the records it should show the count as based on the doucment No. and maturity date the maturity date filter is working fine for me only i want to know how to count based on the same document No. is same for more records how can we achieve it i am sharing my code for the cue field, thanks for your advices.

field(2; /PDC Maturity Date/; Integer)

{

FieldClass = FlowField;

Caption = 'PDC Maturity Date';

CalcFormula = count( PDC Ledger where(PDC Maturity Date = field(Maturity Date Filter), PDC Cheque No. = filter(<> '')));

}

Thanks & Regards

Satish

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (0)

Report

As far as I know, if you don't have a Document No field on your current table, you can't do it with FlowField. You need to consider other methods, such as using variables and then collecting data in the program, or Query to collect data.

Hopefully other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No