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