BAQ Calculated field returns empty inconsistently

Epicor ERP 10
1

Hello,

I have a BAQ with the following calculated field:

‘’ + Part.PartNum + ’ - ’ + Part.PartDescription + ’ is a ’ + Type + ’ part within the ’ + PartClass.Description + ’ part class.

On Hand Qty: ’ + convert(varchar, PartBin.OnhandQty)

It returns a value when I pass the PartNum (which is criteria to the BAQ) of 1000021 but not when I pass 10000164. The BAQ is returning data as Part.PartNum is a field that is returned and it displays correctly.

It doesn’t make any sense to me. Anyone have any ideas?

2

In Part Tracker, does 10000164 have any bins? A null can really mess up character concatenation.

Mark W.

3

Hi Mark,

Thanks for the reply. My onhandqty is null, that must be it. Just need to figure out how to put that logic into the concatenation.

4

I was able to fix it by creating a user defined field for onhandqty that checks for null, supplies 0.00 if true, otherwise returns a converted string of the actual onhandqty value. The message field now displays the string.