BAQ for customer x month

Epicor ERP 10
1

Good afternoon my fellows, I´m developing a BAQ to know how much I sell to all my customers per month. Now, I have a little bit of an Issue, when I analyze my BAQ, this one displays all my invoices, what can I do to summarize all the invoices per client?

2

You’ll have to use a group by

Look up SQL Group By this is also outlined in the epicor Help system as well as the ICE Tool Guide

3

But is it possible in Epicor in the Cloud? Because I can only use BAQ Designer.

4

Yeah group by is available on BAQ designer

1 Like
5

Ok, I don´t know how to use Group By, is it on the ICE Tool Guide that Epicor gave me?

6

Yes or the help F1

1 Like
7

Thanks, let me dig into it!

8

Done, awesome! Thanks!

9

Any ideas on how to define parameter for the date? I mean, so I can search just month to month?

10

Also in the guide… Or help search for parameters.
I recommend a cursory reading of the whole section lots of neat tricks

1 Like