E10 - Sales Order Backlog as of date

Epicor ERP 10
1

I have a dashboard that shows the Order Detail joined to Ship Detail and Ship Header. I want a BAQ/Dashboard in E10 that will evaluate, given a date parameter (as of date) that will look to see if that order line was shipped before or after that date parameter. If the ship date was before that given parameter then Order line = Closed, if the ship date was after the date parameter than order line = open as of that date

Can you use a date parameter then use a calculated field to compare against another field?

2

BAQ Parameters are perfect for this (not in the dashboard, but instead the BAQ).

3

Thanks. I just couldn’t remember how to write the calculated field to look at the parameter at the time they generate the Dashboard with a date value

4

In the calculated field editor, you can select parameters just like tables/fields.

Jason Woods
http://LinkedIn.com/in/jasoncwoods

5

Thanks Jason I must have overlooked it will give it a try