I know there are SuiteAnswers for this but I have tried both #27228 and #37620 and get the same error: "Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit."
Here is a screenshot of the formula which is given in both SuiteAnswer #27228 and #37620 (except #37620 is specific to journals, whereas I want to see any transaction so I did not apply that as criteria), copied and pasted directly into the formula box. The only columns I have on the Results tab are Date, Period and Transaction Number. I am the NetSuite administrator so I know it is not a permissions issue.
I also tried SuiteAnswer #14806, which uses Formula (Text) as criteria and got the same error.
Please help!😟
Second screenshot just to show that I did "Add" the row:
Results tab, simple as can be:
No other filters applied: