Foreign key views in 8.03.305I

Thank you both ("Fons van der Beek" fons.vanderbeek@... & "bw2868bond" bwalker@...) VERY much!

The plant > plant parent child (over)mapping was the problem.

Works like a charm now!

All the best to you.

Rob Brown


bw2868bond <bwalker@...> wrote:
Try removing the plant > plant mapping ?

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Yes. Also (perhaps incorrectly?) I set plant > plant as a 3rd
parent to child mapping.
>
> The Job(s) I tried it on (several dozen) are all for valid Parts
with non-null values in the respect fields.
>
> Any ideas?
>
> bw2868bond <bwalker@...> wrote:
> Did you set company > company and partnum > partnum as
parent to
> child mappings?
>
> And the job you are opening is a valid part?
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> wrote:
> >
> > You must be psychic (or darn smart). I did just that after
sending
> the email to the group and was able to do so with no errors.
> >
> > I then was able to assign my 3 nedEpiCustom (numeric editor)
> fields to PartPlant.LeadTime, PartPlant.MinMfgLotSize and
> PartPlant.MfgLotMultiple respectively.
> >
> > However, after saving the customized form and reopening to test,
> the fields aren't being populated when I select a Job.
> >
> > Do I now also need to use form, sheet or event wizard to generate
> code to retrieve and populate this data?
> >
> > Thanks for the help.
> >
> >
> >
> >
> > bw2868bond <bwalker@> wrote:
> > What happens if you make a FKV From JobHead to the Part
> Table
> > Then Make a SubTable view from the FKV you created to PartPlant?
> >
> > --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> > wrote:
> > >
> > > I anyone out there knowledgable in adding foreign key views
when
> > customizing applications?
> > >
> > > Even with the 8.03 Epicor Tools User Guide in hand I have been
> > confounded in accomplishing what should be a realtively simple
> > customization task:
> > >
> > > I simply want to make PartPlant table data
> > (specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
> > available for viewing in JobEntry (for the Part being
manufactured
> on
> > the Job).
> > >
> > > The minimum necessary keys for PartPlant are Company, PartNum
and
> > Plant.
> > >
> > > The existing NK view 'JobPart' contains the needed keys but
> > errors out when I try to create a custom foreign key subview (or
> > standalone view) view calling PartPlantSearchAdapter.
> > >
> > > I get similar failed results trying to create custom multi
> > foreign key view (no matter what combination or order of "like"
> > fields I define).
> > >
> > > My frustration is compounded when I look at Part maintenance
that
> > has an NK PartPlant view available (but no apparent way to export
> it
> > for use in Job Entry).
> > >
> > > What I DID notice in Part Maintenance is that there are not any
> > Assemblies that seem to be specific to PartPlant. Only IPart,
Part
> > and PartPlantWhse exist as either UI or AD assemblies.
> > >
> > > I'm beginning to wonder if simply through trial end error (as
> > assemblies are not documented), I should simply start copying the
> > Part Maintenance assembly info one at a time into JobEntry as
> custom
> > assemblies (until I stumble upon the correct one that enables me
to
> > create the PartPlant FK view I desire).
> > >
> > > Any help out there?
> > >
> > > Much appreciated if someone come lead me down the right path.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Yahoo! oneSearch: Finally, mobile search that gives answers,
not
> > web links.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Take the Internet to Go: Yahoo!Go puts the Internet in your
pocket:
> mail, news, photos & more.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ---------------------------------
> Be a better Globetrotter. Get better travel answers from someone
who knows.
> Yahoo! Answers - Check it out.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

[Non-text portions of this message have been removed]
I anyone out there knowledgable in adding foreign key views when customizing applications?

Even with the 8.03 Epicor Tools User Guide in hand I have been confounded in accomplishing what should be a realtively simple customization task:

I simply want to make PartPlant table data (specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple) available for viewing in JobEntry (for the Part being manufactured on the Job).

The minimum necessary keys for PartPlant are Company, PartNum and Plant.

The existing NK view 'JobPart' contains the needed keys but errors out when I try to create a custom foreign key subview (or standalone view) view calling PartPlantSearchAdapter.

I get similar failed results trying to create custom multi foreign key view (no matter what combination or order of "like" fields I define).

My frustration is compounded when I look at Part maintenance that has an NK PartPlant view available (but no apparent way to export it for use in Job Entry).

What I DID notice in Part Maintenance is that there are not any Assemblies that seem to be specific to PartPlant. Only IPart, Part and PartPlantWhse exist as either UI or AD assemblies.

I'm beginning to wonder if simply through trial end error (as assemblies are not documented), I should simply start copying the Part Maintenance assembly info one at a time into JobEntry as custom assemblies (until I stumble upon the correct one that enables me to create the PartPlant FK view I desire).

Any help out there?

Much appreciated if someone come lead me down the right path.













---------------------------------
Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

[Non-text portions of this message have been removed]
What happens if you make a FKV From JobHead to the Part Table
Then Make a SubTable view from the FKV you created to PartPlant?

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> I anyone out there knowledgable in adding foreign key views when
customizing applications?
>
> Even with the 8.03 Epicor Tools User Guide in hand I have been
confounded in accomplishing what should be a realtively simple
customization task:
>
> I simply want to make PartPlant table data
(specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
available for viewing in JobEntry (for the Part being manufactured on
the Job).
>
> The minimum necessary keys for PartPlant are Company, PartNum and
Plant.
>
> The existing NK view 'JobPart' contains the needed keys but
errors out when I try to create a custom foreign key subview (or
standalone view) view calling PartPlantSearchAdapter.
>
> I get similar failed results trying to create custom multi
foreign key view (no matter what combination or order of "like"
fields I define).
>
> My frustration is compounded when I look at Part maintenance that
has an NK PartPlant view available (but no apparent way to export it
for use in Job Entry).
>
> What I DID notice in Part Maintenance is that there are not any
Assemblies that seem to be specific to PartPlant. Only IPart, Part
and PartPlantWhse exist as either UI or AD assemblies.
>
> I'm beginning to wonder if simply through trial end error (as
assemblies are not documented), I should simply start copying the
Part Maintenance assembly info one at a time into JobEntry as custom
assemblies (until I stumble upon the correct one that enables me to
create the PartPlant FK view I desire).
>
> Any help out there?
>
> Much appreciated if someone come lead me down the right path.
>
>
>
>
>
>
>
>
>
>
>
>
>
> ---------------------------------
> Yahoo! oneSearch: Finally, mobile search that gives answers, not
web links.
>
> [Non-text portions of this message have been removed]
>
You must be psychic (or darn smart). I did just that after sending the email to the group and was able to do so with no errors.

I then was able to assign my 3 nedEpiCustom (numeric editor) fields to PartPlant.LeadTime, PartPlant.MinMfgLotSize and PartPlant.MfgLotMultiple respectively.

However, after saving the customized form and reopening to test, the fields aren't being populated when I select a Job.

Do I now also need to use form, sheet or event wizard to generate code to retrieve and populate this data?

Thanks for the help.




bw2868bond <bwalker@...> wrote:
What happens if you make a FKV From JobHead to the Part Table
Then Make a SubTable view from the FKV you created to PartPlant?

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> I anyone out there knowledgable in adding foreign key views when
customizing applications?
>
> Even with the 8.03 Epicor Tools User Guide in hand I have been
confounded in accomplishing what should be a realtively simple
customization task:
>
> I simply want to make PartPlant table data
(specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
available for viewing in JobEntry (for the Part being manufactured on
the Job).
>
> The minimum necessary keys for PartPlant are Company, PartNum and
Plant.
>
> The existing NK view 'JobPart' contains the needed keys but
errors out when I try to create a custom foreign key subview (or
standalone view) view calling PartPlantSearchAdapter.
>
> I get similar failed results trying to create custom multi
foreign key view (no matter what combination or order of "like"
fields I define).
>
> My frustration is compounded when I look at Part maintenance that
has an NK PartPlant view available (but no apparent way to export it
for use in Job Entry).
>
> What I DID notice in Part Maintenance is that there are not any
Assemblies that seem to be specific to PartPlant. Only IPart, Part
and PartPlantWhse exist as either UI or AD assemblies.
>
> I'm beginning to wonder if simply through trial end error (as
assemblies are not documented), I should simply start copying the
Part Maintenance assembly info one at a time into JobEntry as custom
assemblies (until I stumble upon the correct one that enables me to
create the PartPlant FK view I desire).
>
> Any help out there?
>
> Much appreciated if someone come lead me down the right path.
>
>
>
>
>
>
>
>
>
>
>
>
>
> ---------------------------------
> Yahoo! oneSearch: Finally, mobile search that gives answers, not
web links.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more.

[Non-text portions of this message have been removed]
Did you set company > company and partnum > partnum as parent to
child mappings?

And the job you are opening is a valid part?

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> You must be psychic (or darn smart). I did just that after sending
the email to the group and was able to do so with no errors.
>
> I then was able to assign my 3 nedEpiCustom (numeric editor)
fields to PartPlant.LeadTime, PartPlant.MinMfgLotSize and
PartPlant.MfgLotMultiple respectively.
>
> However, after saving the customized form and reopening to test,
the fields aren't being populated when I select a Job.
>
> Do I now also need to use form, sheet or event wizard to generate
code to retrieve and populate this data?
>
> Thanks for the help.
>
>
>
>
> bw2868bond <bwalker@...> wrote:
> What happens if you make a FKV From JobHead to the Part
Table
> Then Make a SubTable view from the FKV you created to PartPlant?
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> wrote:
> >
> > I anyone out there knowledgable in adding foreign key views when
> customizing applications?
> >
> > Even with the 8.03 Epicor Tools User Guide in hand I have been
> confounded in accomplishing what should be a realtively simple
> customization task:
> >
> > I simply want to make PartPlant table data
> (specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
> available for viewing in JobEntry (for the Part being manufactured
on
> the Job).
> >
> > The minimum necessary keys for PartPlant are Company, PartNum and
> Plant.
> >
> > The existing NK view 'JobPart' contains the needed keys but
> errors out when I try to create a custom foreign key subview (or
> standalone view) view calling PartPlantSearchAdapter.
> >
> > I get similar failed results trying to create custom multi
> foreign key view (no matter what combination or order of "like"
> fields I define).
> >
> > My frustration is compounded when I look at Part maintenance that
> has an NK PartPlant view available (but no apparent way to export
it
> for use in Job Entry).
> >
> > What I DID notice in Part Maintenance is that there are not any
> Assemblies that seem to be specific to PartPlant. Only IPart, Part
> and PartPlantWhse exist as either UI or AD assemblies.
> >
> > I'm beginning to wonder if simply through trial end error (as
> assemblies are not documented), I should simply start copying the
> Part Maintenance assembly info one at a time into JobEntry as
custom
> assemblies (until I stumble upon the correct one that enables me to
> create the PartPlant FK view I desire).
> >
> > Any help out there?
> >
> > Much appreciated if someone come lead me down the right path.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! oneSearch: Finally, mobile search that gives answers, not
> web links.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ---------------------------------
> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket:
mail, news, photos & more.
>
> [Non-text portions of this message have been removed]
>
Yes. Also (perhaps incorrectly?) I set plant > plant as a 3rd parent to child mapping.

The Job(s) I tried it on (several dozen) are all for valid Parts with non-null values in the respect fields.

Any ideas?

bw2868bond <bwalker@...> wrote:
Did you set company > company and partnum > partnum as parent to
child mappings?

And the job you are opening is a valid part?

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> You must be psychic (or darn smart). I did just that after sending
the email to the group and was able to do so with no errors.
>
> I then was able to assign my 3 nedEpiCustom (numeric editor)
fields to PartPlant.LeadTime, PartPlant.MinMfgLotSize and
PartPlant.MfgLotMultiple respectively.
>
> However, after saving the customized form and reopening to test,
the fields aren't being populated when I select a Job.
>
> Do I now also need to use form, sheet or event wizard to generate
code to retrieve and populate this data?
>
> Thanks for the help.
>
>
>
>
> bw2868bond <bwalker@...> wrote:
> What happens if you make a FKV From JobHead to the Part
Table
> Then Make a SubTable view from the FKV you created to PartPlant?
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> wrote:
> >
> > I anyone out there knowledgable in adding foreign key views when
> customizing applications?
> >
> > Even with the 8.03 Epicor Tools User Guide in hand I have been
> confounded in accomplishing what should be a realtively simple
> customization task:
> >
> > I simply want to make PartPlant table data
> (specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
> available for viewing in JobEntry (for the Part being manufactured
on
> the Job).
> >
> > The minimum necessary keys for PartPlant are Company, PartNum and
> Plant.
> >
> > The existing NK view 'JobPart' contains the needed keys but
> errors out when I try to create a custom foreign key subview (or
> standalone view) view calling PartPlantSearchAdapter.
> >
> > I get similar failed results trying to create custom multi
> foreign key view (no matter what combination or order of "like"
> fields I define).
> >
> > My frustration is compounded when I look at Part maintenance that
> has an NK PartPlant view available (but no apparent way to export
it
> for use in Job Entry).
> >
> > What I DID notice in Part Maintenance is that there are not any
> Assemblies that seem to be specific to PartPlant. Only IPart, Part
> and PartPlantWhse exist as either UI or AD assemblies.
> >
> > I'm beginning to wonder if simply through trial end error (as
> assemblies are not documented), I should simply start copying the
> Part Maintenance assembly info one at a time into JobEntry as
custom
> assemblies (until I stumble upon the correct one that enables me to
> create the PartPlant FK view I desire).
> >
> > Any help out there?
> >
> > Much appreciated if someone come lead me down the right path.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! oneSearch: Finally, mobile search that gives answers, not
> web links.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ---------------------------------
> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket:
mail, news, photos & more.
>
> [Non-text portions of this message have been removed]
>






---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.

[Non-text portions of this message have been removed]
Try to remove the 3rd parent........ "Plant"

Robert Brown schreef:
> Yes. Also (perhaps incorrectly?) I set plant > plant as a 3rd parent to child mapping.
>
> The Job(s) I tried it on (several dozen) are all for valid Parts with non-null values in the respect fields.
>
> Any ideas?
>
> bw2868bond <bwalker@...> wrote:
> Did you set company > company and partnum > partnum as parent to
> child mappings?
>
> And the job you are opening is a valid part?
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
> wrote:
>
>> You must be psychic (or darn smart). I did just that after sending
>>
> the email to the group and was able to do so with no errors.
>
>> I then was able to assign my 3 nedEpiCustom (numeric editor)
>>
> fields to PartPlant.LeadTime, PartPlant.MinMfgLotSize and
> PartPlant.MfgLotMultiple respectively.
>
>> However, after saving the customized form and reopening to test,
>>
> the fields aren't being populated when I select a Job.
>
>> Do I now also need to use form, sheet or event wizard to generate
>>
> code to retrieve and populate this data?
>
>> Thanks for the help.
>>
>>
>>
>>
>> bw2868bond <bwalker@...> wrote:
>> What happens if you make a FKV From JobHead to the Part
>>
> Table
>
>> Then Make a SubTable view from the FKV you created to PartPlant?
>>
>> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
>> wrote:
>>
>>> I anyone out there knowledgable in adding foreign key views when
>>>
>> customizing applications?
>>
>>> Even with the 8.03 Epicor Tools User Guide in hand I have been
>>>
>> confounded in accomplishing what should be a realtively simple
>> customization task:
>>
>>> I simply want to make PartPlant table data
>>>
>> (specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
>> available for viewing in JobEntry (for the Part being manufactured
>>
> on
>
>> the Job).
>>
>>> The minimum necessary keys for PartPlant are Company, PartNum and
>>>
>> Plant.
>>
>>> The existing NK view 'JobPart' contains the needed keys but
>>>
>> errors out when I try to create a custom foreign key subview (or
>> standalone view) view calling PartPlantSearchAdapter.
>>
>>> I get similar failed results trying to create custom multi
>>>
>> foreign key view (no matter what combination or order of "like"
>> fields I define).
>>
>>> My frustration is compounded when I look at Part maintenance that
>>>
>> has an NK PartPlant view available (but no apparent way to export
>>
> it
>
>> for use in Job Entry).
>>
>>> What I DID notice in Part Maintenance is that there are not any
>>>
>> Assemblies that seem to be specific to PartPlant. Only IPart, Part
>> and PartPlantWhse exist as either UI or AD assemblies.
>>
>>> I'm beginning to wonder if simply through trial end error (as
>>>
>> assemblies are not documented), I should simply start copying the
>> Part Maintenance assembly info one at a time into JobEntry as
>>
> custom
>
>> assemblies (until I stumble upon the correct one that enables me to
>> create the PartPlant FK view I desire).
>>
>>> Any help out there?
>>>
>>> Much appreciated if someone come lead me down the right path.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> ---------------------------------
>>> Yahoo! oneSearch: Finally, mobile search that gives answers, not
>>>
>> web links.
>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>
>>
>>
>>
>> ---------------------------------
>> Take the Internet to Go: Yahoo!Go puts the Internet in your pocket:
>>
> mail, news, photos & more.
>
>> [Non-text portions of this message have been removed]
>>
>>
>
>
>
>
>
>
> ---------------------------------
> Be a better Globetrotter. Get better travel answers from someone who knows.
> Yahoo! Answers - Check it out.
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>



[Non-text portions of this message have been removed]
Try removing the plant > plant mapping ?

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> Yes. Also (perhaps incorrectly?) I set plant > plant as a 3rd
parent to child mapping.
>
> The Job(s) I tried it on (several dozen) are all for valid Parts
with non-null values in the respect fields.
>
> Any ideas?
>
> bw2868bond <bwalker@...> wrote:
> Did you set company > company and partnum > partnum as
parent to
> child mappings?
>
> And the job you are opening is a valid part?
>
> --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> wrote:
> >
> > You must be psychic (or darn smart). I did just that after
sending
> the email to the group and was able to do so with no errors.
> >
> > I then was able to assign my 3 nedEpiCustom (numeric editor)
> fields to PartPlant.LeadTime, PartPlant.MinMfgLotSize and
> PartPlant.MfgLotMultiple respectively.
> >
> > However, after saving the customized form and reopening to test,
> the fields aren't being populated when I select a Job.
> >
> > Do I now also need to use form, sheet or event wizard to generate
> code to retrieve and populate this data?
> >
> > Thanks for the help.
> >
> >
> >
> >
> > bw2868bond <bwalker@> wrote:
> > What happens if you make a FKV From JobHead to the Part
> Table
> > Then Make a SubTable view from the FKV you created to PartPlant?
> >
> > --- In vantage@yahoogroups.com, Robert Brown <robertb_versa@>
> > wrote:
> > >
> > > I anyone out there knowledgable in adding foreign key views
when
> > customizing applications?
> > >
> > > Even with the 8.03 Epicor Tools User Guide in hand I have been
> > confounded in accomplishing what should be a realtively simple
> > customization task:
> > >
> > > I simply want to make PartPlant table data
> > (specifically .LeadTime, .MinMfgLotSize and .MfgLotMultiple)
> > available for viewing in JobEntry (for the Part being
manufactured
> on
> > the Job).
> > >
> > > The minimum necessary keys for PartPlant are Company, PartNum
and
> > Plant.
> > >
> > > The existing NK view 'JobPart' contains the needed keys but
> > errors out when I try to create a custom foreign key subview (or
> > standalone view) view calling PartPlantSearchAdapter.
> > >
> > > I get similar failed results trying to create custom multi
> > foreign key view (no matter what combination or order of "like"
> > fields I define).
> > >
> > > My frustration is compounded when I look at Part maintenance
that
> > has an NK PartPlant view available (but no apparent way to export
> it
> > for use in Job Entry).
> > >
> > > What I DID notice in Part Maintenance is that there are not any
> > Assemblies that seem to be specific to PartPlant. Only IPart,
Part
> > and PartPlantWhse exist as either UI or AD assemblies.
> > >
> > > I'm beginning to wonder if simply through trial end error (as
> > assemblies are not documented), I should simply start copying the
> > Part Maintenance assembly info one at a time into JobEntry as
> custom
> > assemblies (until I stumble upon the correct one that enables me
to
> > create the PartPlant FK view I desire).
> > >
> > > Any help out there?
> > >
> > > Much appreciated if someone come lead me down the right path.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Yahoo! oneSearch: Finally, mobile search that gives answers,
not
> > web links.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Take the Internet to Go: Yahoo!Go puts the Internet in your
pocket:
> mail, news, photos & more.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ---------------------------------
> Be a better Globetrotter. Get better travel answers from someone
who knows.
> Yahoo! Answers - Check it out.
>
> [Non-text portions of this message have been removed]
>