QuoteHed SalesRepCode in BAQ

,

I am trying to capture the SalesRepCode in a BAQ on the QuoteHed. I have searched everywhere but I cannot find it. Does anyone know how to use this field in a BAQ?

The Ice.ZDataField table claims it’s on the QuoteHed table, but I don’t see it there either. The QSalesRP.SalesRepCode looks promising though, looks like it may have gotten moved to its own table.

1 Like

Thanks Adam, that’s the one!

1 Like

As Adam said. Sales reps are not stored on QuoteHed but in a separate, linked table: QSalesRP. It’s kind of odd it’s done that way, and then for order and invoice you get five sales rep codes in one field separated by a tilde (~) (OrderHed.SalesRepList and InvcHead.SalesRepList I believe).

1 Like