AnsweredAssumed Answered

Updating Account Balance Object

Question asked by ghard123 on Mar 1, 2018
Latest reply on Mar 1, 2018 by philmodjunk

Hi and sorry if this is a basic question.

 

I wish to track the purchase and sale of shares.  I want the cash account to add the transaction amount if it is a SELL of shares, and to subtract the transaction amount if it is a BUY.

 

I was thinking of an 'OnObjectExit' script trigger in the 'Total Amount' object which goes something like this;

 

If (Action = "Buy" ?????  Not sure what to put after this???

 

'Action' is the name of the BUY/SELL field.

'Total Amount' is the name of the transaction amount.

'Account' is the name of the ongoing account balance.

 

Any assistance would be appreciated.

Outcomes