I have a saved search that we use more or less weekly, and after the 2023.2 update while the search still runs we can't export it to a PDF file. When we try we get the dreaded Unexpected Error.
The search is somewhat complex, so I've tried removing a couple of things (in a test version of the search) I thought might be problematic but with no success. For completeness' sake these were:
- A formula for a field summarized as Minimum: (round(sum(case when {quantity} > {quantityshiprecv} and {closed} <> 'T' then nvl({custcol_so_line_qty_picked},0) else 0 end )/sum(case when {quantity} > {quantityshiprecv} and {closed} <> 'T' then nvl({quantity},0)-NVL({quantityshiprecv} ,0) else 0.000000001 end),3))
- A highlighting condition based on Line System Notes
Again, the search runs fine, and all other kinds of exporting - CSV, Excel (such as it is), and printing work fine. Only the PDF is affected, but of course that is the one we need. (This is because when we print we don't get all of the search results, but that is a separate issue.) I haven't found another search that is affected by this problem either, so clearly something about this search is contributing to the problem.
Was there some change to the way PDFs are generated in the 2023.2 update? Can anyone point me to what might cause a saved search to error on PDF export?
Thanks!