Trying to add text to a field in BAQ syntax is not correct

Epicor ERP 10
1

I am trying to create a calculated field that will add a value to an existing field value.
I am taking the VendorID and adding a text onto the back of it. This is part of our tracking for reimplementation from E10 to Kinetic.

     case     When Vendor.KineticVendorID_c = null Then ' '  else Vendor.KineticVendorID_c & '-01'  end

What I am trying to do is to create a calculated field that takes a value and adds -01 to the end of it.

End result would like like this 112233-01
112233 to 112233-01

Any suggestions on how to add the ‘-01’ to a value?
If I use the + instead of the & it does a math calculation which is not what I am looking for
112233 turns into 112232 which is not what I want

2

What table is the BAQ on, if it is the VEndor table there is no need for the case statement as Vendor ID is a mandatory field, in which case a simple
Vendor.VendorID +‘-01’
gives the desired result.

However, from you post it sounds like you are looking at Vendornum, rather than ID, in which case it would be
convert(varchar, Vendor.VendorNum)+‘-01’

which will do what you want

1 Like
3

What is the format of your Vendor.KineticVendorID_c field? It seems like it is acting as a number, so Andy is correct that you need to convert it to a string to add the ‘-01’ at the end.

1 Like
4

Converting the field to a varchar - worked great. That is part that I was overlooking.
Thanks for looking at that - it was staring me right in the face.

1 Like