Baq

Epicor ERP 10
,
1

Hello all,

Can anyone help me? I need to filter “OrderDate” in Sales Order by the last 7 days and “today”.

It will be two seperate BAQs one with last 7 days and one with today… I don’t know how to filter it. I just keep getting orders from 15 years ago…

Thanks
Aaron.

2

Hi Aaron,

Firstly a criteria on the OrderHed table where orderdate >= last 7 days

image
image829×392 12.3 KB

Then I’d create a calculated column returning Y for today’s orders

image
image939×607 26.4 KB

You can then create a subquery criteria against the calculayed column

image
image991×218 7.49 KB

Cheers,

Andrew.

1 Like
3

Hi Andrew,

That worked perfectly, thank you.

Do you know how to hide a PartBin from a BAQ?

We have a PartBin I wish to hide.

4

Hi Araron,

Can you not just exclude as a table critera, e.g. binnm <> ???

Cheers,

Andrew.

5

Or if this query goes into a dashboard, you can hide it during the dashboard design if you still wish to view it in the baq…

Pierre