Foriegn key view

Dear Ennio:

Referencing the data dictionary, neither of these values actually
exist in the OrderDtl table.

The On Hand Qty exists in the PartWhse table, you should be able to
bring it to the Quote lines maintenance screen via another FKV + STV,
like this:

In your customization for the Lines tab in quote maintenance, add a
New Custom View:
View Name = PartView (or whatever you want to name it)
Parent = QuoteDtl
Column Name = PartNum

After you add this view, then add a second New Custom View:
View Name = PartWhseView (or whatever you want to name it)
Parent = PartView (the name you gave the first view above)
View Type = Sub Table View
Sub Table Name = PartWhse
Then you need to add these linking fields:
parent.Company = child.Company
parent.PartNum = child.PartNum

Now you will have the PartWhse.OnHandQty field available to add to
any control on your customization.

The Available Quantity is a calculated value. [(Available Quantity)
= (Total Qty On Hand) - (Total Allocated On Current Orders)] I don't
know enough about the system to know how to obtain the total pieces
allocated on all current orders, so I can't help you with this one.
Sorry.

Have fun & good luck!

Lynn



--- In vantage@yahoogroups.com, "Ennio Verderese" <ennio@...> wrote:
>
> Can someone give me direction
>
> On the Sales order menu under the Line tab it show "On Hand Qty" and
> "Available" I would like to show these fields when I create a quote
at the
> line level.
>
>
>
> Best regards,
>
> Ennio Verderese
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Can someone give me direction on foreign key I am trying to add lead time
from the partplant table to order line .



Best regards,

Ennio Verderese







This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.







[Non-text portions of this message have been removed]
If I understand correctly, you are doing a customization to the Lines
sheet in Sales Order Entry, right?

If so, what you want seems to be possible by first creating a FKV to
the Part table, then creating a Sub Table View to the PartPlant table.

In your customization, create a FKV by choosing Data Tools, New
Custom View. Name your new view something like, "PartView". Your
parent table is OrderDtl and your column name is OrderDtl.PartNum and
your Like Column value is Part.PartNum.

After you Add that view, then click on New Custom View again. Name
your new view something like, "PartPlantView". The Parent View Name
will be the name you gave the view you previously created
(PartView). The view type will be a Sub Table View. The sub table
name is PartPlant. The Link Columns view will read PartView (or
whatever you named it previously).

Then add your linking fields for the Parent and Child views: Company
= Company and PartNum = PartNum.

When you are finished with both the FKV and the STV, then your newly
named views will be available as Datasources in your customization
and you can choose LeadTime from the PartPlantView.

I hope that works for you.

Lynn



--- In vantage@yahoogroups.com, "Ennio Verderese" <ennio@...> wrote:
>
> Can someone give me direction on foreign key I am trying to add
lead time
> from the partplant table to order line .
>
>
>
> Best regards,
>
> Ennio Verderese
>
>
>
>
>
>
>
> This e-mail may contain confidential and/or privileged information.
If you
> are not the intended recipient (or have received this e-mail in
error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in
this
> e-mail is strictly forbidden.
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
1 Like
Can someone give me direction

On the Sales order menu under the Line tab it show "On Hand Qty" and
"Available" I would like to show these fields when I create a quote at the
line level.



Best regards,

Ennio Verderese







[Non-text portions of this message have been removed]