CalcFormula

(1) Share

Report

Posted on by Mounir M

Hello ,

I have create flowfield in table customer to calculate the number of elements in the Cust table. Ledger

field(50001; "Nb doc over 30d"; Integer)
{
FieldClass = FlowField;
CalcFormula = count ("Cust. Ledger Entry" where ("Posting Date" <= (Today()-30D) ) );
}

My Issue is CalcFormula doesn't work ?

the issur is :

Thanks for any help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Gerardo Rentería Ga... 27,024 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Do you get an error? Or do you get a wrong quantity?

BR

GR

Was this reply helpful? Yes No
Suggested answer

Dynamics_Decoded_Gokul 487 on at

Like (1)

Report
Copy link

Link copied!

Hi

Please flowfilter concept to avoid this error

1. Create a flowfilter for date add that to your calcformula.

2. Where ever you require page. OnOpen and onAftergetrecord trigger add the code for passing the values to the flowfilter.

3. which will result you the Required output

field(50001; "Nb doc over 30d"; Integer)

{

FieldClass = FlowField;

CalcFormula = count("Cust. Ledger Entry" where("Posting Date" = Field("Date Filter")));

}

field(50002; "Date Filter"; Date)

{

FieldClass = FlowFilter;

}

Was this reply helpful? Yes No
Verified answer

Mounir M 79 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your answer

I have declared 3 FlowField fileds like this in table Customer:

after I have add trigger OnAfterGetRecord on page Customer List :

the calculation is perfect

my issue is : in the details when i click on "Nb doc over 30d" or "Nb doc over 60d" or "Nb doc over 90d" it show the same filter

it take the last data filter passed (Rec.SetFilter("Date Filter", '<=%1', DMY2DATE(01, 02, 2022));)

the Document date must be show the date passed in argumnet

Any idea

Thanks

Was this reply helpful? Yes No