I'm getting a weird error with both of those options
The field ttQuoteDtl.AnalysisCdDescription does not have a valid data type.
and when i type in the part number and tab it won't autopopulate with information. The above error message comes up when I try to save the line.
The field ttQuoteDtl.AnalysisCdDescription does not have a valid data type.
and when i type in the part number and tab it won't autopopulate with information. The above error message comes up when I try to save the line.
--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> for each ttQuoteDtl, first Part where ttQuoteDtl.Company = Part.Company and ttQuoteDtl.PartNum = Part.PartNum and Part.Checkbox02 = False and ( ttQuoteDtl.RowMod = 'A' or ttQuoteDtl.RowMod = 'U' ) no-lock
>
> You'd put this as the Designed Query for the BPM condition.
>
> The action would be to publish an information message.
>
> Alternatively, you can do what you suggest below as a BPM 4GL action with no conditions and use a find statement:
>
> find each ttQuoteDtl, first Part where ttQuoteDtl.Company = Part.Company and ttQuoteDtl.PartNum = Part.PartNum and Part.Checkbox02 = False and ( ttQuoteDtl.RowMod = 'A' or ttQuoteDtl.RowMod = 'U' ) no-lock no-error.
>
> If available ttQuoteDtl then do:
>
> {lib/PublishInfoMsg.i&InfoMsg="'This part?s costs have not been reviewed and thus is not ready for quoting. Please see production for pricing'"}
>
> End.
>
> I think that will work.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of emverbeke
> Sent: Monday, July 27, 2009 1:42 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Alert when quoting if checkbox is true in part table
>
> I tried this but I'm getting errors
>
> for each ttQuoteDtl where ttQuoteDtl.RowMod = 'A' or ttQuoteDtl.RowMod = 'U' no-lock :
> for first Part where ( Part.CheckBox02 = FALSE) and (ttQuoteDtl.Company = Part.Company and ttQuoteDtl.PartNum = Part.PartNum) no-lock :
> {lib/PublishInfoMsg.i&InfoMsg="'This part?s costs have not been reviewed and thus is not ready for quoting. Please see production for pricing'"}
> return.
> end.
> end.
>
>
>
> --- In vantage@yahoogroups.com, "emverbeke" <emverbeke@> wrote:
> >
> > I want to write a BAM or BPM (probably BPM from what I know) that goes and looks at part maintenance to see if checkbox01 is true when the sales person enters the part number in the quote. If anyone has a BPM currently doing something like this whether it references quoteDtl or not could you email me some screen shots? I'm getting tripped up with writing query conditions and/or writing just 4GL code? Thanks in advance!
> >
> > Emily
> >
>
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>