Warning mesage for a Part List that expires?

Yahoo Archive
1
Bingo. You'll want 'specified query returns >0 rows' (or something very
similar, I can never remember the exact verbiage).
You'll need to insert a query written in 4gl that finds expired price
lists. Something like:

FOR EACH ttQuoteDtl WHERE ttQuoteDtl.Rowmod <> '',
EACH PriceLstParts WHERE PriceLstParts.PartNum = ttQuoteDtl.PartNum,
EACh PriceLst WHERE PriceLst.ListCode = PriceLstParts.ListCode AND
PriceList.EndDate < TODAY.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Thu, Feb 28, 2013 at 11:13 AM, sanfranc415 <sanfranc415@...> wrote:

> **
>
>
>
> Okay, that sounds logically. I've created a "method directive" with the
> "method code" "Quote.Update," so now create a new "Pre-Processing" with a
> "Condition" that runs a query?
>
> Thanks,
>
> --sf
> --- In vantage@yahoogroups.com, John Driggers wrote:
> >
> > Are you referring to price lists? You could do this pretty easily with a
> > BPM. Set a pre-proc directive on Quote.Update. Use a query condition to
> > find the expired pricelists and a 'display message' action.
> >
> > *John Driggers*
> > **
> > *Chief Data Wrangler*
> > *
> > *
> > *I have an Epicor blog http://usdoingstuff.com/>. How useful is that?*
> > *
> > *:: 904.404.9233
> > :: waffqle@...
> > :: http://www.usdoingstuff.com http://www.usdoingstuff.com/>
> >
> > *
> >
> > *
> >
> >
> > On Wed, Feb 27, 2013 at 4:28 PM, sanfranc415 wrote:
> >
> > > **
>
> > >
> > >
> > > Is it possible to setup an alert if a Part List has expired when
> bringing
> > > into a Quote.
> > >
> > > --sf
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
2
Are you referring to price lists? You could do this pretty easily with a
BPM. Set a pre-proc directive on Quote.Update. Use a query condition to
find the expired pricelists and a 'display message' action.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*


On Wed, Feb 27, 2013 at 4:28 PM, sanfranc415 <sanfranc415@...> wrote:

> **
>
>
> Is it possible to setup an alert if a Part List has expired when bringing
> into a Quote.
>
> --sf
>
>
>


[Non-text portions of this message have been removed]
3
Okay, that sounds logically. I've created a "method directive" with the "method code" "Quote.Update," so now create a new "Pre-Processing" with a "Condition" that runs a query?

Thanks,

--sf
--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> Are you referring to price lists? You could do this pretty easily with a
> BPM. Set a pre-proc directive on Quote.Update. Use a query condition to
> find the expired pricelists and a 'display message' action.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
> On Wed, Feb 27, 2013 at 4:28 PM, sanfranc415 <sanfranc415@...> wrote:
>
> > **
> >
> >
> > Is it possible to setup an alert if a Part List has expired when bringing
> > into a Quote.
> >
> > --sf
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>