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

All responses (3)

Answers (1)

Verified answer

Mounir M 37 on at

Like (1)

Report

CalcFormula

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
Suggested answer

Tech_BC_Gokul 331 on at

Like (1)

Report

CalcFormula

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;

}
Gerardo Rentería Ga... 20,891 Most Valuable Professional on at

Like (0)

Report

CalcFormula

Hi

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

BR

GR