E9 BAQ with comments

Epicor ERP 9
1

I’m trying to make a char field in a BAQ to make it easier to send an RQ to a supplier - creating the text of the email such as:

Please confirm the following: (this is a calculated field)
The rest is data right-click copy
PODetail.PartNum PODetail.Qty
etc. The result will be pasted into Excel for more formatting or into an email.

My question is… Is there a way to put a line break in the calculated field?

2

I think you want to use Char(10) or Char (13). They are newline characters.

3

Thanks that worked but now I have a different issue with the same calculated field:

This works (just testing new line:
‘Hello - please confirm due dates on the following items:’ + chr(10) + ‘newline’

But this retuened an error:

‘Hello - please confirm due dates on the following items:’ + chr(10) + ‘newline’ + PORel.PONum

What is the syntax for appending a field?

4

Got it - had to convert the number to a string