Error while using CASE in formatted search
I am facing error 'Error (8180) Encountered' when I attach a formatted search to dynamically calculate some qty in the AR Invoice transaction. I have used a 'CASE' construct in the SQL Query.
Somewhere I remember reading that if the Query attaches FOR BROWSE at the end of a query which is having CASE construct then it wont work. What would be the workaround in this case.
Thanx in advance.
Ibai Peña replied
Trick for the FOR BROWSE issue:
You can´t eleminate it. But you can cheat SBO to make it think that you have already a FOR BROWSE clause.
Just put a --FOR BROWSE at the end of the query.
For SBO you have already the clause. For SQL is a comment.
Hope this helps,