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.
Thanks Adam, that’s the one!
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).