Trying to create a BAQ that lists sales by salesperson. Problem is SalesRepList can hold multiple. Help!

Epicor ERP 10
21

I feel the same way, but we miss stuff too lol.

1 Like
22

It shows up in BAQ is just a couple of new views
InvcHeadSalesRepView
OrderHedSalesRepView

image
image577×457 8.03 KB

3 Likes
23

You create a BAQ that links the OrderHed to the OrderHedSalesRepView

image
image1219×804 63.7 KB

then you can select the fields in teh salesrepview to be displayed… they are already split out for you. If there is one rep, then you will get one record. if there are 3, then you will get 3 entries. no need for complicated query anymore. it “looks” like a separate table with this view, even though it is still stored in the table the old way. We did this so that anyone who had already created BAQs/Reports to handle it the old way was still supported, but anyone new can do it easier.

image
image1179×592 39.6 KB

3 Likes
24

@josecgomez beat ya to it. :wink:

1 Like
25

Yup… but mine was more detailed. :wink:

2 Likes
26

You are assuming that’s what we wanted.. :rofl:

4 Likes