BAQ - Criteria

Epicor ERP 10
1

I am trying to create a dashboard with information for my customer service team on RMA’s. I have created the BAQ; however cannot get it to work properly. I only want results for RMA’s however I have things like invoice number and credit memo on the BAQ, so it returns all invoices. So, I am trying to put in a criteria that limits the BAQ to only RMA’s. Hope that makes sense and I appreciate any help.

Stuart

2

If you use inner joins to the RMADtl table, that should filter out records not tied to an RMA. Can you post images of your query so far?

3

Annotation 2020-08-18 161640
Annotation 2020-08-18 1616401254×877 119 KB
Annotation 2020-08-18 161736
Annotation 2020-08-18 1617361476×921 95.8 KB

4

Thanks Adam, I will give that a try…

5

No problem! Yeah I think if you join the InvcDtl table to the RMADtl table, rather than InvcHead to Customer table, that should get rid of those extra invoice records.

6

Thanks Adam, that worked…

1 Like