Sales Order Entry adding lines SC Help

Yahoo Archive
1
Got it you need to have the line desc field filled. With the part desc.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Thursday, March 11, 2010 5:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Entry adding lines SC Help





Does any one have a sc that they use to add lines to a Sales order they
could share with me?

~Charlie

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
How could I check to see if an order already exists based on the customers
PO number.



I know you can search based on PO Number but the search is doing a >=
search. I only want to know if a specific PO already exist.



~Charlie





[Non-text portions of this message have been removed]
3
Charlie,
If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: Charlie Wilson
To: vantage@yahoogroups.com
Sent: Wednesday, March 10, 2010 6:05 AM
Subject: [Vantage] Sales Order Entry SC Help



How could I check to see if an order already exists based on the customers
PO number.

I know you can search based on PO Number but the search is doing a >=
search. I only want to know if a specific PO already exist.

~Charlie

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.

~Charlie

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> Charlie,
> If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
> ----- Original Message -----
> From: Charlie Wilson
> To: vantage@yahoogroups.com
> Sent: Wednesday, March 10, 2010 6:05 AM
> Subject: [Vantage] Sales Order Entry SC Help
>
>
>
> How could I check to see if an order already exists based on the customers
> PO number.
>
> I know you can search based on PO Number but the search is doing a >=
> search. I only want to know if a specific PO already exist.
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/Result/SalesOrderDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.

Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.

Charles Carden
IT Manager
Manitex, Inc.
ccarden@...
Georgetown, Texas

----- Original Message -----
From: foamdesigncsw
To: vantage@yahoogroups.com
Sent: Wednesday, March 10, 2010 6:36 AM
Subject: [Vantage] Re: Sales Order Entry SC Help



How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.

~Charlie

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> Charlie,
> If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> Georgetown, Texas
> ----- Original Message -----
> From: Charlie Wilson
> To: vantage@yahoogroups.com
> Sent: Wednesday, March 10, 2010 6:05 AM
> Subject: [Vantage] Sales Order Entry SC Help
>
>
>
> How could I check to see if an order already exists based on the customers
> PO number.
>
> I know you can search based on PO Number but the search is doing a >=
> search. I only want to know if a specific PO already exist.
>
> ~Charlie
>
> [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]
6
In Service connect, I just use PONum='yournumber' in the concatenate
functoid, and feed it to the WhereClauseOrderHed node of my
GetRowsRequest. Then I set the rest of the where statements to "Force
Empty Node". I'll send you a screenshot off list.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, March 10, 2010 6:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Entry SC Help





How could I check to see if an order already exists based on the
customers
PO number.

I know you can search based on PO Number but the search is doing a >=
search. I only want to know if a specific PO already exist.

~Charlie

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
7
That makes sense to me but could you tell me how you set up the Getrows.

~Charlie

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/Result/SalesOrderDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.
>
> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> ccarden@...
> Georgetown, Texas
>
> ----- Original Message -----
> From: foamdesigncsw
> To: vantage@yahoogroups.com
> Sent: Wednesday, March 10, 2010 6:36 AM
> Subject: [Vantage] Re: Sales Order Entry SC Help
>
>
>
> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.
>
> ~Charlie
>
> --- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@> wrote:
> >
> > Charlie,
> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> > Georgetown, Texas
> > ----- Original Message -----
> > From: Charlie Wilson
> > To: vantage@yahoogroups.com
> > Sent: Wednesday, March 10, 2010 6:05 AM
> > Subject: [Vantage] Sales Order Entry SC Help
> >
> >
> >
> > How could I check to see if an order already exists based on the customers
> > PO number.
> >
> > I know you can search based on PO Number but the search is doing a >=
> > search. I only want to know if a specific PO already exist.
> >
> > ~Charlie
> >
> > [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]
>
8
Use the "whereClauseOrderHed" on the GetRowsRequest. Use the "concat" functioid and create a statement.

str1 will be CustNum = or you could use CustID = '
str2 will be the Customer number or customer id from your wfl/usr data.
str3 will be and PONum = '
str4 will be the PO Number from your wfl/usr data.
str5 will be a '

If you use the CustID be sure to include a single quote before the and PONum =, i.e. ' and PONum =

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: foamdesigncsw
To: vantage@yahoogroups.com
Sent: Wednesday, March 10, 2010 9:01 AM
Subject: [Vantage] Re: Sales Order Entry SC Help



That makes sense to me but could you tell me how you set up the Getrows.

~Charlie

--- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@...> wrote:
>
> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/Result/SalesOrderDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.
>
> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.
>
> Charles Carden
> IT Manager
> Manitex, Inc.
> ccarden@...
> Georgetown, Texas
>
> ----- Original Message -----
> From: foamdesigncsw
> To: vantage@yahoogroups.com
> Sent: Wednesday, March 10, 2010 6:36 AM
> Subject: [Vantage] Re: Sales Order Entry SC Help
>
>
>
> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.
>
> ~Charlie
>
> --- In vantage@yahoogroups.com, "Charles Carden" <shadowcar1449@> wrote:
> >
> > Charlie,
> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.
> >
> > Charles Carden
> > IT Manager
> > Manitex, Inc.
> > Georgetown, Texas
> > ----- Original Message -----
> > From: Charlie Wilson
> > To: vantage@yahoogroups.com
> > Sent: Wednesday, March 10, 2010 6:05 AM
> > Subject: [Vantage] Sales Order Entry SC Help
> >
> >
> >
> > How could I check to see if an order already exists based on the customers
> > PO number.
> >
> > I know you can search based on PO Number but the search is doing a >=
> > search. I only want to know if a specific PO already exist.
> >
> > ~Charlie
> >
> > [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]
>





[Non-text portions of this message have been removed]
9
Thanks,

You all are life savers again.

~C

--- On Wed, 3/10/10, Charles Carden <shadowcar1449@...> wrote:

From: Charles Carden <shadowcar1449@...>
Subject: Re: [Vantage] Re: Sales Order Entry SC Help
To: vantage@yahoogroups.com
Date: Wednesday, March 10, 2010, 4:14 PM







Â









Use the "whereClauseOrderHe d" on the GetRowsRequest. Use the "concat" functioid and create a statement.



str1 will be CustNum = or you could use CustID = '

str2 will be the Customer number or customer id from your wfl/usr data.

str3 will be and PONum = '

str4 will be the PO Number from your wfl/usr data.

str5 will be a '



If you use the CustID be sure to include a single quote before the and PONum =, i.e. ' and PONum =



Charles Carden

IT Manager

Manitex, Inc.

Georgetown, Texas

----- Original Message -----

From: foamdesigncsw

To: vantage@yahoogroups .com

Sent: Wednesday, March 10, 2010 9:01 AM

Subject: [Vantage] Re: Sales Order Entry SC Help



That makes sense to me but could you tell me how you set up the Getrows.



~Charlie



--- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ ...> wrote:

>

> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/ Result/SalesOrde rDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.

>

> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.

>

> Charles Carden

> IT Manager

> Manitex, Inc.

> ccarden@...

> Georgetown, Texas

>

> ----- Original Message -----

> From: foamdesigncsw

> To: vantage@yahoogroups .com

> Sent: Wednesday, March 10, 2010 6:36 AM

> Subject: [Vantage] Re: Sales Order Entry SC Help

>

>

>

> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.

>

> ~Charlie

>

> --- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ > wrote:

> >

> > Charlie,

> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.

> >

> > Charles Carden

> > IT Manager

> > Manitex, Inc.

> > Georgetown, Texas

> > ----- Original Message -----

> > From: Charlie Wilson

> > To: vantage@yahoogroups .com

> > Sent: Wednesday, March 10, 2010 6:05 AM

> > Subject: [Vantage] Sales Order Entry SC Help

> >

> >

> >

> > How could I check to see if an order already exists based on the customers

> > PO number.

> >

> > I know you can search based on PO Number but the search is doing a >=

> > search. I only want to know if a specific PO already exist.

> >

> > ~Charlie

> >

> > [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]

>



[Non-text portions of this message have been removed]






















[Non-text portions of this message have been removed]
10
I'm having a tough time getting the Order Line to Add? I have something going into all the fields except the custom fields. I set the rowmod field to A. Any suggestions?

~Charlie

--- On Wed, 3/10/10, Charles Carden <shadowcar1449@...> wrote:

From: Charles Carden <shadowcar1449@...>
Subject: Re: [Vantage] Re: Sales Order Entry SC Help
To: vantage@yahoogroups.com
Date: Wednesday, March 10, 2010, 4:14 PM







Â









Use the "whereClauseOrderHe d" on the GetRowsRequest. Use the "concat" functioid and create a statement.



str1 will be CustNum = or you could use CustID = '

str2 will be the Customer number or customer id from your wfl/usr data.

str3 will be and PONum = '

str4 will be the PO Number from your wfl/usr data.

str5 will be a '



If you use the CustID be sure to include a single quote before the and PONum =, i.e. ' and PONum =



Charles Carden

IT Manager

Manitex, Inc.

Georgetown, Texas

----- Original Message -----

From: foamdesigncsw

To: vantage@yahoogroups .com

Sent: Wednesday, March 10, 2010 9:01 AM

Subject: [Vantage] Re: Sales Order Entry SC Help



That makes sense to me but could you tell me how you set up the Getrows.



~Charlie



--- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ ...> wrote:

>

> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/ Result/SalesOrde rDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.

>

> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.

>

> Charles Carden

> IT Manager

> Manitex, Inc.

> ccarden@...

> Georgetown, Texas

>

> ----- Original Message -----

> From: foamdesigncsw

> To: vantage@yahoogroups .com

> Sent: Wednesday, March 10, 2010 6:36 AM

> Subject: [Vantage] Re: Sales Order Entry SC Help

>

>

>

> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.

>

> ~Charlie

>

> --- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ > wrote:

> >

> > Charlie,

> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.

> >

> > Charles Carden

> > IT Manager

> > Manitex, Inc.

> > Georgetown, Texas

> > ----- Original Message -----

> > From: Charlie Wilson

> > To: vantage@yahoogroups .com

> > Sent: Wednesday, March 10, 2010 6:05 AM

> > Subject: [Vantage] Sales Order Entry SC Help

> >

> >

> >

> > How could I check to see if an order already exists based on the customers

> > PO number.

> >

> > I know you can search based on PO Number but the search is doing a >=

> > search. I only want to know if a specific PO already exist.

> >

> > ~Charlie

> >

> > [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]

>



[Non-text portions of this message have been removed]






















[Non-text portions of this message have been removed]
11
Are you getting any errors?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Thursday, March 11, 2010 5:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Sales Order Entry SC Help





I'm having a tough time getting the Order Line to Add? I have something going into all the fields except the custom fields. I set the rowmod field to A. Any suggestions?

~Charlie

--- On Wed, 3/10/10, Charles Carden <shadowcar1449@... <mailto:shadowcar1449%40sbcglobal.net> > wrote:

From: Charles Carden <shadowcar1449@... <mailto:shadowcar1449%40sbcglobal.net> >
Subject: Re: [Vantage] Re: Sales Order Entry SC Help
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wednesday, March 10, 2010, 4:14 PM



Use the "whereClauseOrderHe d" on the GetRowsRequest. Use the "concat" functioid and create a statement.

str1 will be CustNum = or you could use CustID = '

str2 will be the Customer number or customer id from your wfl/usr data.

str3 will be and PONum = '

str4 will be the PO Number from your wfl/usr data.

str5 will be a '

If you use the CustID be sure to include a single quote before the and PONum =, i.e. ' and PONum =

Charles Carden

IT Manager

Manitex, Inc.

Georgetown, Texas

----- Original Message -----

From: foamdesigncsw

To: vantage@yahoogroups .com

Sent: Wednesday, March 10, 2010 9:01 AM

Subject: [Vantage] Re: Sales Order Entry SC Help

That makes sense to me but could you tell me how you set up the Getrows.

~Charlie

--- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ ...> wrote:

>

> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/ Result/SalesOrde rDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.

>

> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.

>

> Charles Carden

> IT Manager

> Manitex, Inc.

> ccarden@...

> Georgetown, Texas

>

> ----- Original Message -----

> From: foamdesigncsw

> To: vantage@yahoogroups .com

> Sent: Wednesday, March 10, 2010 6:36 AM

> Subject: [Vantage] Re: Sales Order Entry SC Help

>

>

>

> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.

>

> ~Charlie

>

> --- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ > wrote:

> >

> > Charlie,

> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.

> >

> > Charles Carden

> > IT Manager

> > Manitex, Inc.

> > Georgetown, Texas

> > ----- Original Message -----

> > From: Charlie Wilson

> > To: vantage@yahoogroups .com

> > Sent: Wednesday, March 10, 2010 6:05 AM

> > Subject: [Vantage] Sales Order Entry SC Help

> >

> >

> >

> > How could I check to see if an order already exists based on the customers

> > PO number.

> >

> > I know you can search based on PO Number but the search is doing a >=

> > search. I only want to know if a specific PO already exist.

> >

> > ~Charlie

> >

> > [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]

>

[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]
12
HAHA of course not...

It just doesn't show up.

~C

--- On Thu, 3/11/10, Matt Caldwell <matt@...> wrote:

From: Matt Caldwell <matt@...>
Subject: RE: [Vantage] Re: Sales Order Entry SC Help
To: vantage@yahoogroups.com
Date: Thursday, March 11, 2010, 2:20 PM







Â









Are you getting any errors?







From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Charlie Wilson

Sent: Thursday, March 11, 2010 5:41 AM

To: vantage@yahoogroups .com

Subject: Re: [Vantage] Re: Sales Order Entry SC Help











I'm having a tough time getting the Order Line to Add? I have something going into all the fields except the custom fields. I set the rowmod field to A. Any suggestions?



~Charlie



--- On Wed, 3/10/10, Charles Carden <shadowcar1449@ sbcglobal. net <mailto:shadowcar14 49%40sbcglobal. net> > wrote:



From: Charles Carden <shadowcar1449@ sbcglobal. net <mailto:shadowcar14 49%40sbcglobal. net> >

Subject: Re: [Vantage] Re: Sales Order Entry SC Help

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>

Date: Wednesday, March 10, 2010, 4:14 PM







Use the "whereClauseOrderHe d" on the GetRowsRequest. Use the "concat" functioid and create a statement.



str1 will be CustNum = or you could use CustID = '



str2 will be the Customer number or customer id from your wfl/usr data.



str3 will be and PONum = '



str4 will be the PO Number from your wfl/usr data.



str5 will be a '



If you use the CustID be sure to include a single quote before the and PONum =, i.e. ' and PONum =



Charles Carden



IT Manager



Manitex, Inc.



Georgetown, Texas



----- Original Message -----



From: foamdesigncsw



To: vantage@yahoogroups .com



Sent: Wednesday, March 10, 2010 9:01 AM



Subject: [Vantage] Re: Sales Order Entry SC Help



That makes sense to me but could you tell me how you set up the Getrows.



~Charlie



--- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ ...> wrote:



>



> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/ Result/SalesOrde rDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.



>



> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.



>



> Charles Carden



> IT Manager



> Manitex, Inc.



> ccarden@...



> Georgetown, Texas



>



> ----- Original Message -----



> From: foamdesigncsw



> To: vantage@yahoogroups .com



> Sent: Wednesday, March 10, 2010 6:36 AM



> Subject: [Vantage] Re: Sales Order Entry SC Help



>



>



>



> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.



>



> ~Charlie



>



> --- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ > wrote:



> >



> > Charlie,



> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.



> >



> > Charles Carden



> > IT Manager



> > Manitex, Inc.



> > Georgetown, Texas



> > ----- Original Message -----



> > From: Charlie Wilson



> > To: vantage@yahoogroups .com



> > Sent: Wednesday, March 10, 2010 6:05 AM



> > Subject: [Vantage] Sales Order Entry SC Help



> >



> >



> >



> > How could I check to see if an order already exists based on the customers



> > PO number.



> >



> > I know you can search based on PO Number but the search is doing a >=



> > search. I only want to know if a specific PO already exist.



> >



> > ~Charlie



> >



> > [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]



>



[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]






















[Non-text portions of this message have been removed]
13
There is a SC that does order entry in the files section. Does any one know if it works?

According to it i need to set up the Release too when i add the line is that true?

~C

--- On Thu, 3/11/10, Charlie Wilson <foamdesigncsw@...> wrote:

From: Charlie Wilson <foamdesigncsw@...>
Subject: RE: [Vantage] Re: Sales Order Entry SC Help
To: vantage@yahoogroups.com
Date: Thursday, March 11, 2010, 2:50 PM







Â









HAHA of course not...



It just doesn't show up.



~C



--- On Thu, 3/11/10, Matt Caldwell <matt@kerusso. com> wrote:



From: Matt Caldwell <matt@kerusso. com>

Subject: RE: [Vantage] Re: Sales Order Entry SC Help

To: vantage@yahoogroups .com

Date: Thursday, March 11, 2010, 2:20 PM



Â



Are you getting any errors?



From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf Of Charlie Wilson



Sent: Thursday, March 11, 2010 5:41 AM



To: vantage@yahoogroups .com



Subject: Re: [Vantage] Re: Sales Order Entry SC Help



I'm having a tough time getting the Order Line to Add? I have something going into all the fields except the custom fields. I set the rowmod field to A. Any suggestions?



~Charlie



--- On Wed, 3/10/10, Charles Carden <shadowcar1449@ sbcglobal. net <mailto:shadowcar14 49%40sbcglobal. net> > wrote:



From: Charles Carden <shadowcar1449@ sbcglobal. net <mailto:shadowcar14 49%40sbcglobal. net> >



Subject: Re: [Vantage] Re: Sales Order Entry SC Help



To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>



Date: Wednesday, March 10, 2010, 4:14 PM



Use the "whereClauseOrderHe d" on the GetRowsRequest. Use the "concat" functioid and create a statement.



str1 will be CustNum = or you could use CustID = '



str2 will be the Customer number or customer id from your wfl/usr data.



str3 will be and PONum = '



str4 will be the PO Number from your wfl/usr data.



str5 will be a '



If you use the CustID be sure to include a single quote before the and PONum =, i.e. ' and PONum =



Charles Carden



IT Manager



Manitex, Inc.



Georgetown, Texas



----- Original Message -----



From: foamdesigncsw



To: vantage@yahoogroups .com



Sent: Wednesday, March 10, 2010 9:01 AM



Subject: [Vantage] Re: Sales Order Entry SC Help



That makes sense to me but could you tell me how you set up the Getrows.



~Charlie



--- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ ...> wrote:



>



> Insert a choice after the query runs. Create two paths leading from the choice, one labled Yes and the other No. Modify the choice rules and create an XPath expression. Configure both expressions. From the GetRowsResponse/ Result/SalesOrde rDataSet draw a line from the OrderHed to the XPath. For the Yes choice set the Admit Value to True and for the No choice set the Admit value to False.



>



> Sorry if that is clear as mud. If it is not clear email me and I will send you some print screens that will show you the logic.



>



> Charles Carden



> IT Manager



> Manitex, Inc.



> ccarden@...



> Georgetown, Texas



>



> ----- Original Message -----



> From: foamdesigncsw



> To: vantage@yahoogroups .com



> Sent: Wednesday, March 10, 2010 6:36 AM



> Subject: [Vantage] Re: Sales Order Entry SC Help



>



>



>



> How do you do the search in SC and then test the results of the search. I looked through all the methods and i didn't seem to find one that allowed me to do a lookup based on PO Number.



>



> ~Charlie



>



> --- In vantage@yahoogroups .com, "Charles Carden" <shadowcar1449@ > wrote:



> >



> > Charlie,



> > If you are referring to service connect I do a search based on the customer and the PO number with both being equal. We have to do this when processing sales orders because of the customer being set to not allow duplicate POs. If you are referring to Vantage then just create a quick search with an equal condition on the PO number field.



> >



> > Charles Carden



> > IT Manager



> > Manitex, Inc.



> > Georgetown, Texas



> > ----- Original Message -----



> > From: Charlie Wilson



> > To: vantage@yahoogroups .com



> > Sent: Wednesday, March 10, 2010 6:05 AM



> > Subject: [Vantage] Sales Order Entry SC Help



> >



> >



> >



> > How could I check to see if an order already exists based on the customers



> > PO number.



> >



> > I know you can search based on PO Number but the search is doing a >=



> > search. I only want to know if a specific PO already exist.



> >



> > ~Charlie



> >



> > [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]



>



[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]



[Non-text portions of this message have been removed]






















[Non-text portions of this message have been removed]
14
Does any one have a sc that they use to add lines to a Sales order they
could share with me?



~Charlie



[Non-text portions of this message have been removed]