RE: Debit – Credit SQL Formula

I am trying to write what I thought would be a pretty simple formula for a transaction search


It is just coming up blank.

I am trying to get  both invoices and journals onto a single search and do a summary total, which I cannot do using the transaction total since that doesn’t exist for a journal.

Anyone know a trick to get this to work?


I’d also like to get this to work in an Analytics dataset as well.


laurieann26 Rookie Asked on July 25, 2023 in SuiteAnalytics.
Add Comment
7 Answers

this is the error I’m getting in analytics

You have syntax error in your formula (Unsupported element: syntax error, state:598 at the end of formula). Please see the documentation for supported syntax. (Error on line 1 column 137.)

Rookie Answered on July 25, 2023.
Add Comment

Your Answer

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