Pulling Most Recent Quote by QuoteHdr.EntryDate

Epicor ERP 10
1

I have a BAQ that needs to pull quote information based on the date the Quote was entered (I cannot use the most recent Quote Number).

I receive the error:
Severity: Error, Table: , Field: , RowID: , Text: Operand type clash: date is incompatible with int

Any Help would be much appreciated. I have looked through Topic’s and either I can’t find what I’m looking for or I am not understanding what I need to do.

I do not know how to fix this. I am not SQL savvy so please be aware that you may be explaining something way over my head! Please keep it simple!

Thank you!

1 Like
2

No worries Judy! So can you show me (screenshot) where you have this condition set up? the condition with the date? Like date = today or whatever?

3

Judy, can you show us the BAQ in a screenshot?

Like show us how you have this written and where? Is this a condition you are writing in your BAQ or a calculated field? etc?