Can you have a field in Dashboard send it's value to a BAQ to filter with and show new result?

Epicor ERP 10
1

Hello,

I found a logical flaw in a dashboard/BAQ I put together. The BAQ returns the newest row for each PartNum filtered by max(TranNum).

The dashboard is supposed to let you filter by date to show the state of the parts as of that time.

As you can guess, it only shows the parts that have a date earlier than the filter instead of all the parts with the transaction date as the starting point.

I need a way, if possible, to let the employee select a date, then send that date to a BAQ to be used as a filter on the PartTran table TranDate field.

Is this possible? Any help is appreciated.

Thanks,
Shawn

2

It sounds like you want a parameter for this. You can add a parameter to the BAQ from the Action menu. Then, you can filter the PartTran table by that parameter. It will pop up a message asking for the date each time you run the dashboard.

3

@Jason_Woods,

That is exactly it!

I am restructuring my BAQ and it looks like that did the work I needed.

You are the man!!

Thanks,

Shawn