RE: Formula in saved search

Hello,

I have created a saved search that in the criteria I have all the bank accounts with multiple currencies, in the results I have a column that calculate the amount (account currency) using this formula:

CASE WHEN {account.number} IN (‘10003′,’10005′,’10007′,’10008′,’10009′,’10010′,’10011′,’10012′,’10013′,’10101′,’10102′,’10103′,’10104′,’10105′,’10106’) THEN {amount} ELSE {fxamount} END

I need to add another column that calculate the accumulated balance for each day , according to the account currency, the same way it appears in the trail balance netsuite report.

for example if the first transaction on 01/01/2021 in BANK USD is 100 so I want the value in the new column will be 100, if on 02/01/2021 I have payment of -45 USD then I want the value will be 55 (100-45) etc…

I hope its clear enough, please advise !

 

thanks

Brunolit57 Rookie Asked on November 16, 2021 in How To's.
Add Comment
1 Answers

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.