I am trying to add a tab to the Supplier Tracker that will display all of the DMR details where the Vendor ID on the DMR equals the Vendor ID chosen in the Supplier Tracker. I am having difficulty with the FKV and sub table view. Specifically, I am not able to get to the DMRHead table. I create a …

So I got it to work. Trick was using the Subscribe Auto-Retrieve instead of Subscribe with Retrieve button. Thanks for all of the help.

Hi Michael, Any chance you have a vendornum vendorid problem? I have had these messed up before with queries and then realized the problem. It looks like you need to use Vendornum for your FKV tie. Nancy

The easiest way to do this and that I’ve done is the past is with an embedded Dashboard. It’s also much more upgrade compatible than custom code.

Great suggestion, Rick. I always forget about embedded dashboards. I have created a DB and added to the screen form, but I am having trouble filtering the dashboard to the supplier? I am using the “Subscribe to UI data (include Retrieve button)” option to filter the DMRs by supplier number (vendor…

That is odd. I know sometimes after saving the customization you have to close out and open it up in ‘non-customization’ mode. See if it shows up then. Unless you are missing a step. What version are you on?

Thanks everyone. I got it working.

Well I thought i had it working but now all records are showing. Followed the steps and still no luck. We are on version 10.2.200.24.

Adding DMR Data to Supplier Tracker

Epicor ERP 10

Nancy_Hoyt (Nancy Hoyt) May 29, 2020, 6:17pm 6

Hi Michael,

This post shows how to setup the browse, to check your steps: Embedded dashboard via Sheet Wizard

Nancy

Topic		Replies	Views
Adding a Dashboard to an Entry Screen Epicor ERP 9	13	8638	August 22, 2018
Pass information from NC to DMR Epicor ERP 9	7	1699	August 31, 2017
FKV like column value not updating Epicor ERP 10 customization	0	602	September 17, 2021
Dashboard Tracker View - Foreign Key and Sub Tables Epicor ERP 10 e10 , customization	0	1138	February 28, 2018
Foreign Key View - Quotes > Orders Epicor ERP 10 customization , fkv	3	1015	May 26, 2021

Adding DMR Data to Supplier Tracker

Related topics