Subscribing UI Data to Dashboard

Epicor ERP 10
1

I added a custom sheet dashboard to the capable to promise UI. As you can see, it is showing open orders that are not in Part Master.

image
image.png1292×524 45.1 KB

But it is showing all the orders, not just the order that is opened up in CTP

image
image.png757×527 14 KB

When I added the sheet via Sheet Wizard, there was an option to subscribe to the UI data. (I am familiar with publishing and subscribing in dashboards only).

image

I was able to pick the field that i wanted to subscribe to

image

The next step is to filter the dashboard by the subscribed data. This is where I am stuck. How do I do that. It is not quite the same with a normal dashboard.

Thanks!

2
3

I already looked into that. But the column drop down box is limited to the colums of the dashboard only. I also cannot manually type a value in there.

I am looking for the CapPromisDtl_OrderNum, which does not show up in the drop down.

4

You can’t type in that field? What version?
I’m not sure if it’s dependent on the underling query but this works in 10.2.200.3
image

Re-reading your question; yes, the dashboard filters will not have columns from a different dataview in them, only the query itself. In this case, as I understand it, you want your dashboard to be filtered to the CapPromiseDtl_OrderNum value. So in your dashboard, you set your query OrderNum field equal to DashboardBrowse. In your customization, you publish CapPromise_Dtl.OrderNum and then your dbd will be set up to subscribe to that value.

5

Okay i was typing in the wrong field. Doy!

But it did not work for me because there is no Browse drop down on the CTP form for the dashboard to pull from.

6

Ah gotcha.

7

I’m pretty sure it has to be an index field for the Dashboard browse to work.