Epicor 9.05.701 See the screenshot below, (a BAQ that is looking at the table INVCHEAD) [image] When there is only one sales rep, I can easily edit the report and put in a commission calculation and search by that sales rep. However, the problem comes when there is 2 or 3 sales reps, as you can…

Can you expand the SalesPerson field in your BAQ to show the full value?

Calculated field for each SalesRep in the list… SalesRep1 = [Ice].entry(1, InvcHead.SalesRepList, ‘~’) SalesRep2 = [Ice].entry(2, InvcHead.SalesRepList, ‘~’) etc…

While our BAQ is a little more complicated because we use bookings as one of the commission ingredients, here’s the link for OrderHed to SalesRep which will give you one record for each sales rep on an order. [SalesRep] I don’t recall who provided that link originally but it’s here in the forum s…

Thanks for the feedback guys…nailed it

Sales rep commission

Epicor ERP 9

Rowley150 (Mark Rowley) September 11, 2017, 3:04pm 6

change the 1 and 1 below to a 2 and 2 and 3 and 3 for each added calc field (all the way to 5)

Topic		Replies	Views
Trying to create a BAQ that lists sales by salesperson. Problem is SalesRepList can hold multiple. Help! Epicor ERP 10 e10	32	4177	February 6, 2026
Updatable BAQ/ Dashboard for OrderHed.SalesRepCode1? Epicor ERP 10 baq , dashboard	3	421	February 29, 2024
BAQ / SQL Question Epicor ERP 10 sql , baq	3	1332	January 12, 2021
How to make a monthly booking by rep BAQ Epicor ERP 10 baq	53	4471	August 25, 2023
Display SalesRep Name in BAQ Calculated Field Epicor ERP 10 epicor , baq , dashboard	7	1263	August 16, 2022

Sales rep commission

Related topics