Thanks a lot for the info Rob. You're a lifesaver.
--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Method/bo
>
> Salesorder.update
>
> Preprocess
>
> Condition: number of rows in the designed query is not less than one
>
>
>
> Query:
>
>
>
> For each ttorderdtl where ttorderdtl.rowmod = 'A' and
> ttorderdtl.xpartnum = '' and custnum = 'TUL525'
>
>
>
> Action : raise exception based on the designed template
>
>
>
> Note youll need to test this as its from the cuff.. youll need to go
> into the designed template and configure your message. If you want to
> include basic information from the dataset, this should be possible. I
> used custnum because usually in most datasets its what is used, you
> don't usually see them using custID.. I could be wrong there.. but..
> either way.. you can still define it, because its static.
>
>
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <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 mobilevox
> Sent: Monday, April 11, 2011 3:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BPM - Prevent Sales Order if customer part number is
> blank
>
>
>
>
>
> I only know a little bit of BPM and don't know much about 4GL coding so
> I hope someone out there will be able to help me on this.
>
> I would just like to prevent a sales order from completing if the
> customer part number is blank and the customer ID is for example TUL525.
> It would also pop up a message window to tell the user that he/she needs
> to input the customer part number.
>
> We are on 803.409C Progress DB.
>
> Thanks in advance.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>