BAQ subquery -- error on filter with calculated field

Epicor ERP 10
1

Hey there,

This BAQ runs okay on one test environment, but when I go to a newer test environment it stops working.

It takes the later of the last ship date on an order or OrderHed.ChangeDate and puts it in the field “CollectiveOrderChangeDate” – a calculated field on Subquery1 – the top level subquery.

When unfiltered at the subquery criteria (subquery1) I get this output:

image
image776×471 108 KB

But if I try even a simple filter like this:

image
image667×593 150 KB

I get this error:

image

I thought maybe I had a data error in the date field calculation somewhere, but every row seems to have a valid date populated when it runs unfiltered. There are no non-blank fields in the unfiltered output.

CollectiveOrderChangeDate is a Date field and should be either null or contain a valid date. And they all contain dates.

Both environments are running 10.2.300.15.

Seen this before?

Thanks,

Joe

2

Do you have access to server, Event log should contain more info about the error.

3

Would you be able to post the query phrase. That would help to troubleshoot.

Thanks.