Customizing a Print Dialog / Foreign Key Vew E10

Epicor ERP 10
1

Hi there,

I’m adding a new filter to the Job Traveler print dialog. I’ve added a sheet and some controls to look up a Person list from the Person table.

Of course, the available list of tables/columns for the EpiBinding is limited to a few foreign key view lists at this point.

I’ve tried creating a new FKV usting the PersonAdapter. But I’m not using a Parent View Name because I don’t want to bind the Person list to another field in the available list. I just want a list from the Person table.

So, I can add something like:

View Name: personList
Parent View Name:
View Type: Foreign Key View
Column Name:
Adapter Name: PersonAdapter
Get By Type: StringGetByID
Validation Adapters:

The “Add” button is greyed out until I add a Parent View Name and Column Name.

Is it even possible to use a FKV without a parent view?

Should I look at something like an EpiDataView instead?

Thanks,

Joe

2

Can you use a BAQ based search instead?
That is what I usually do when I need more lookup options in a report form.

1 Like
3

Bruce,

I need to allow muliple selection like on a regular print dialog filter.
Hmm.

Something to think about.

Thanks,

Joe

4

Unless I am misunderstanding, even if you are able to add the FKV filtering there won’t affect the filtering in the RDD
To modify standard RDD you need generally the SDK
Again unless I’m misunderstanding

Jos? C Gomez
Senior Software Engineer

5

I’m hoping to pass the list in a parameter.

6

You can use a little trick here:

Use an UD table like temp table to store data of your new filter .

  1. Add an UD table as Child, using the customization wizard, this will create a new UDdataView with JobList dataview like his parent, you can use the UD table to store primary key, in this case the JobNum, and the other data of your new filter.
  2. Create a custom copy of Report Data Definition of Job Traveler Report, and add to this the same UD table.
    NOTE: Rememmber, Allways you must clean the UD table every time you start the report parameters window
    image.png506×513 19.6 KB
7

Cool. Thanks, Jaiker.

Joe

8

You are welcome, if this helped to solve your problem, remember to mark the post like “solved”, also to help another members