I know I’m doing something dumb here, but don’t see it. I googled around and others seem to be using this same syntax. The idea being I have a subquery that lists all customers on credit hold and open invoices I have a calculated field indicating if the the particular invoice is late. Then at the top level I sum up late invoices and return a list of customers on credit hold that don’t have any late invoices as a suggestion to take them off credit hold. Problem is I can return a string but not an int from this calculated field…?
The first thing I would change is:
InvcHead.OpenInvoice = ‘true’
to
InvcHead.OpenInvoice = 1
Can you then show a picture of your general tab? My guess is that something else is causing the error.
1 Like
Instead of using GETDATE(), try one of the BAQ Constants