Hello,
I want to modify the CalcFormula of the "Balance Due" field in the "Customer" Table. I know I can't do it directly.
So what I want to do is to create a new field with my own ClacFormula in the Table Ext "CustomerTableExt", and pasting the content of my new field in the standard "Balance Due" field.
Like this : "Balance Due := "MyNewField";
But I'm facing a problem : "Balance Due" is a Flowfield. Its value is not stored in the database. So I don't know if any trigger, in the Table "Customer" or in any Page like "Customer Card", can change its value.
For example, I've tried in the Table Ext of "Customer" :
modify("Balance Due (LCY)")
{
trigger OnAfterValidate()
begin
"Balance Due" := "MyNewField";
end;
}
}
Or in the Page Ext of "Customer List" :
trigger OnOpenPage()
"Balance Due" := "MyNewField";
end;
And nothing seems to modify the value of Balance Due when I check it on the page Customer List.
Do you have any ideas please ?
(I'm on Business Central 16 On Premise)
