Feel really stupid now. Should have been VendPart.EffectiveDate < TODAY.... thanks!
--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> effective date greater than today ?
>
> --- In vantage@yahoogroups.com, "tracy.tmat" <tracy.smith@> wrote:
> >
> > I thought that I should be able to and have the code below but the message showing the VendPart table has been found isn't coming up even though the message after to count the orders is... are you able to tell me what I'm missing? Thanks.
> >
> >
> > def var totqty as decimal no-undo.
> > find first ttPODetail where ttPODetail.Company = CUR-COMP and ttPODetail.RowMod <> "" no-lock no-error.
> >
> > if Available ttPODetail then
> > DO:
> > FOR EACH PODetail where PODetail.Company = ttPODetail.Company
> > and PODetail.VendorNum = ttPODetail.VendorNum
> > and PODetail.PartNum = ttPODetail.PartNum No-Lock :
> >
> > Find VendPart where VendPart.Company = ttPODetail.Company
> > and VendPart.VendorNum = ttPODetail.VendorNum
> > and VendPart.PartNum = ttPODetail.PartNum
> > and VendPart.EffectiveDate > TODAY
> > no-lock no-error.
> >
> > if Available VendPart then
> > DO:
> > message "BPM - Found VendPart".
> > END.
> >
> > totqty = totqty + PODetail.OrderQty.
> > message "BPM - found PO Qty" + string(totqty).
> > END.
> >
> > --- In vantage@yahoogroups.com, Rob Bucek <rbucek@> wrote:
> > >
> > > No reason you shouldn't be able to link to it in a post or pre process bpm with the right query logic..
> > >
> > > Rob Bucek
> > > Production Control Manager
> > > PH: (715) 284-5376 ext 311
> > > Mobile: (715)896-0590
> > > FAX: (715)284-4084
> > > [Description: cid:1.234354861@]<http://www.dsmfg.com/>
> > > (Click the logo to view our site)<http://www.dsmfg.com/>
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tracy.tmat
> > > Sent: Tuesday, June 19, 2012 2:37 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] BPM to Check Supplier Price List when raising PO
> > >
> > >
> > >
> > > We sometimes have prices from Suppliers for amortised costs where the price is different for an agreed quantity until we have covered tooling costs, etc.
> > >
> > > We need a way to track this so I figured the best way would be UD fields on Supplier Price List against Supplier and Part Number but the VendPart table isn't available when writing the actions in my BPM. Any suggestions (we're on 8.03.409a)? Thanks.
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>