Defining Warning Message at RMA Processing

Hi Michael,

I made that Foreign key, using PackNum from InvcDtl table but in new
rule, under that view "myview" I don't see any ShipDate field!!!
Would you please let me know if I did something wrong?
I do appreciate it.

Kam




--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> --- In vantage@yahoogroups.com, "kamvantage" <kkosari@> wrote:
> May or may not work.
> Have you tried doing a Foriegn Key View from the InvcDtl using
PackNum
> and then use the ShipDate in that FKView
> >
> > We have a requirement to prompt a message at RMA processing level
> based
> > on shipdate value, if its greater than 90 days.
> > When trying to define the trigger thru customization; the
shiphead
> > table is not accessable at the order or RMA level to define the
> trigger
> > or rule.
> > invcdtl table has shipdate, but it doesn't have the correct
value!!
> > We are on 8.00.809G
> >
> > Any assistance will be appreciated.
> >
> > Kam
> >
>
We have a requirement to prompt a message at RMA processing level based
on shipdate value, if its greater than 90 days.
When trying to define the trigger thru customization; the shiphead
table is not accessable at the order or RMA level to define the trigger
or rule.
invcdtl table has shipdate, but it doesn't have the correct value!!
We are on 8.00.809G

Any assistance will be appreciated.

Kam
--- In vantage@yahoogroups.com, "kamvantage" <kkosari@...> wrote:
May or may not work.
Have you tried doing a Foriegn Key View from the InvcDtl using PackNum
and then use the ShipDate in that FKView
>
> We have a requirement to prompt a message at RMA processing level
based
> on shipdate value, if its greater than 90 days.
> When trying to define the trigger thru customization; the shiphead
> table is not accessable at the order or RMA level to define the
trigger
> or rule.
> invcdtl table has shipdate, but it doesn't have the correct value!!
> We are on 8.00.809G
>
> Any assistance will be appreciated.
>
> Kam
>