BAQ to find Comments that were truncated to 1,000 characters by Epicor's latest upgrade error

@JasonMcD the query is to find Orders, Quotes, or Jobs affected by Epicor lasted upgrade.
I just checked the Query description and comment fields in Kinetic and they will hold x(10000) characters.

I saw Epicor said they would fix it, but another that stated it was working as designed!

I’ll add - there are 1900+ fields that are set as x(1000) - so what could go wrong?

At least they didn’t change the actual table scheme so prior long comments were not affected. (unless you try to edit them).

1 Like