Hello everyone,
I’m trying to create the new report using BAQ. And i want to add a new column there where i can write texts. The information i want to include is completely new information that does not exist in other menu.
How do i add new information like this? I tried using the Calculated Field SQL Editor, but it could only use existing information.
Thanks in advance!
Text that will appear next to every line?
Calculated Field = ‘Your text’
Data pulled from epicor for the related information you’re creating a BAQ report for? Then a UD Field on the related table.
XXX_UD.MyColumn It will appear as Column_c on the BAQ
Yes. The text lines are necessary for every line.
If these are just lines on the report for someone to enter then add the calculated field with the width you want then put two single quotes.
Yes, I do that all of the time. The X(8) format probably should be much larger.
I tried this, but a field that cannot be entered appears.
To enter data it will need to be updateable. If you are entering data in a field and you want it saved then it would not be a calculated field, but a field on the table.
What is the purpose of this field?
The screen above is the test BAQ, and the purpose of the field I am trying to create is that
Our CS team would like to enter a VOC number and a brief description of that VOC in each part.
Assuming you want to save that then it needs to be an actual field in the table. Then when they type the data can be saved.
What I want is a field where I can simply enter text.
Based on what you said, it seems like this feature is not possible in BAQ.
It is, but I am confused why you would make a field updatable and then not save it anywhere.
Actually, I’m not familiar with Epicor customization, so I can’t create uptable fields.
I would put null, or ‘’, but what you have should be fine.
