BAQ Query Parameter - Type mismatch error

Epicor ERP 10
,
1

I have an external BAQ that has been working for the past year. Today I make a change to the query and get the following error:

Data type mismatch in subquery 'SubQuery1' criteria between 'SalesDetail.ShipDate' field of type 'date' and 'StartDate' parameter of type 'int'. This may cause query execution errors.

The SalesDetail.ShipDate field is type date and the parameter StartDate is defined as date. Not sure when the int is coming from. I have had this happen on a couple other BAQs with Date parameters. Any ideas?

2

For whatever reason, it sees your parameter ā€œStartDateā€ as an int. Have you deleted it and recreated the parameter to see if that changes anything?

3

That worked. Thanks. Is this a known issue?

1 Like
4

Iā€™ve never seen it personally. What version are you on?

5

10.2.300.4