3,027
Hi
I have 3 fields Amount,CAmount,Balance. CAmount is Flowfield . Is it possible to define Balance = Amount - CAmount at Table level.
I have written below code at Table Level but not working. Do i need to write Modify also.
CAmount - OnValidate()
"Balance Amount" := Amount - CAmount;
Thanks
*This post is locked for comments
Try using
Rec.CALCFIELDS("CAmount");
Rec."Balance" := Rec."SAmount"-Rec."CAmount";
MESSAGE('%1',"Balance");
Rec.MODIFY;
Add your code in OnInsert trigger.
Hi
I have written the below code on Table Modify Trigger . It displays message but does not Update balance
OnModify()
CALCFIELDS("CAmount");
Balance := "SAmount" - "CAmount";
MESSAGE('%1',"Balance");
Thanks
If it's in OnInsert or OnModify, it will update the record where you're working on.
Hi
Since this code is written on Table Trigger it will Update all records
Thanks
The correct code is what Mohana as suggested you:
CALCFIELDS(CAmount);
"Balance Amount" := Amount - CAmount;
But you can't place that code in the CAmount - OnValidate trigger (because CAmount is a flowfield, so automatically calculated).
The calculation must be triggered in a different place, for example in Amount - OnValidate trigger.
Hi
I have written like this but still not working . Do i need to write Modify also.
Thanks
you have to use CALCFIELDS for flow fields before using
CALCFIELDS(CAmount);
"Balance Amount" := Amount - CAmount;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (