Thanks for the response Rob. We create shipping head and add lines manually. I used a little SQL writing to develop my query, and got it working. For anyone with a similiar question, here is what I used:
for each ttShipHead , each Customer , each terms where
Customer.CustNum = ttshiphead.custnum and customer.termscode = terms.termscode and customer.company = ttshiphead.company and customer.company = terms.company and shiphead.company =
terms.company and terms.termscode = 'CODC' no-lock
I assume that my previous query wasn't specific enough, and as such wasn't pulling just one record. Thanks again Matt for the tip on the actual code, as I'd still be stuck on that.
for each ttShipHead , each Customer , each terms where
Customer.CustNum = ttshiphead.custnum and customer.termscode = terms.termscode and customer.company = ttshiphead.company and customer.company = terms.company and shiphead.company =
terms.company and terms.termscode = 'CODC' no-lock
I assume that my previous query wasn't specific enough, and as such wasn't pulling just one record. Thanks again Matt for the tip on the actual code, as I'd still be stuck on that.
--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> What do you want your trigger to be? Are you operating from packout or
> do you ship via create shipping head and adding lines manually? If you
> ship by packout using the ship checkbox definitely try
> CustShip.validateShipped
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> 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 bobschnable
> Sent: Friday, December 04, 2009 9:56 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Customer Shipment BPM
>
>
>
>
>
> Thanks for the response Matt. Made sense, but it's still not picking up.
> I assume now that there is a problem in my logic, which being new to
> 4GL, I can't seem to figure out.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Matt Caldwell" <matt@> wrote:
> >
> > It looks like you need to look for the actual terms code, not the
> > description, possibly? Ex. "N60", not "Net 60"
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of Bob Schnable
> > Sent: Thursday, December 03, 2009 4:24 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Customer Shipment BPM
> >
> >
> >
> >
> >
> > Hi all,
> >
> > I'm rather new to Vantage and 4GL, still trying to get my bearings. I
> am
> > trying to create a BPM that will simply pop a message box and let
> users
> > know if the terms are COD for a customer.
> >
> > I have selected the CustShip BO and the Update method. I have a
> > condition, under preprocessing, that says "number of rows in the
> 'test'
> > query is equal to 1"
> >
> > My test query is as follows:
> >
> > for each ttShipHead , each OrderHed where ttShipHead.Company =
> >
> > OrderHed.Company and ttShipHead.OrderNum = OrderHed.OrderNum and
> >
> > OrderHed.TermsCode = 'COD - No Fax' no-lock
> >
> > Then my action is to display a message.
> >
> > Like I said, I am still new to 4GL, but the code syntax checks out. I
> > have a customer, who's terms are COD - No Fax, and when I save a
> > Shipment with that Customer nothing happens.
> >
> > What am I missing??
> >
> > Thanks in advance,
> >
> > Robert Schnable
> >
> > IT Applications and Business Support Associate
> >
> > 440-543-8157
> >
> > 440-543-4582 Fax
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>