Customer Shipment BPM

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.


--- 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]
>
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]
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@yahoogroups.com] On Behalf
Of Bob Schnable
Sent: Thursday, December 03, 2009 4:24 PM
To: vantage@yahoogroups.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]
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, "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@yahoogroups.com] On Behalf
> Of Bob Schnable
> Sent: Thursday, December 03, 2009 4:24 PM
> To: vantage@yahoogroups.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]
>
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]