SalesRepList breakout formula

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:

image

1 Like

Thank you Mark.

DaveO

You can use this too. Just replace the number with the rep you want.

[Ice].entry(1,SalesRepList,’~’)

1 Like

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,

2 Likes

Thank you everyone - Entry IS! the magic bullet. It works perfectly.

You guys Rock!
Thank you again,
DaveO