Table Level

(0) Share

Report

Posted on by jsshivalik

3,099

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

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (1)

Report

you have to use CALCFIELDS for flow fields before using

CALCFIELDS(CAmount);

"Balance Amount" := Amount - CAmount;

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

I have written like this but still not working . Do i need to write Modify also.

Thanks

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

Since this code is written on Table Trigger it will Update all records

Thanks

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

If it's in OnInsert or OnModify, it will update the record where you're working on.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (1)

Report

Add your code in OnInsert trigger.

Was this reply helpful? Yes No
Verified answer

Olister Rumao 3,967 on at

Like (1)

Report

Try using

Rec.CALCFIELDS("CAmount");

Rec."Balance" := Rec."SAmount"-Rec."CAmount";

MESSAGE('%1',"Balance");

Rec.MODIFY;

Was this reply helpful? Yes No