I am trying to concatenate the first two characters from each remaining operation on a job.
What I would like to see in my BAQ is this:
Can anyone tell me how this could be done?
Thank you in advance for your time!
I tried to import CustOrder.baq but I am getting the following error: Can’t import query definition from version latter than current: 3.1.500.0 Query import finished with error(s) Anyway I can get around this?
You can’t if you are in an older version of EPicor. But if you follow the thread you should be able to reconstruct it without importing it.
You could try downloading this PDF and building manually.
Includes screen shots for the Inner subQuery and the Top Level subquery