We are on 10.2.100.x and I am trying to create 5 formulas to capture the SalesRep codes from the SalesRepList. in the OrderHed table.
I guess the first question would be “is there another way?” I thought Epicor added some fields for us that broke out that field - but I don’t see any in the OrderHed.
I am struggling with how to do this - If someone out there has figured this out I would greatly appreciate a little help.
Thanks,
DaveO
In a BAQ? where are you trying to get it?
Mr. Jose: Yes - I am in the BAQ interface.
Sorry about that - I forgot to mention my context.
DaveO
These functions are your friends:
Thank you Mark.
DaveO
You can use this too. Just replace the number with the rep you want.
[Ice].entry(1,SalesRepList,’~’)
Mr. John: Can I use that syntax in the BAQ Formula Editor?
DaveO
It’s the same function Dave. If you double click on Entry, watch what it puts in the expression editor.
Mark W,
Thank you everyone - Entry IS! the magic bullet. It works perfectly.
You guys Rock!
Thank you again,
DaveO