Sales Order Entry adding lines SC Help

system · March 11, 2010, 9:59pm

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]

system · March 10, 2010, 7:05am

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]

system · March 10, 2010, 7:33am

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]

system · March 10, 2010, 7:37am

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

system · March 10, 2010, 9:49am

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]

system · March 10, 2010, 10:04am

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]

system · March 10, 2010, 10:05am

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

system · March 10, 2010, 11:14am

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]

system · March 10, 2010, 11:25am

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]

system · March 11, 2010, 6:41am

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]

system · March 11, 2010, 9:21am

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]

system · March 11, 2010, 9:50am

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]

system · March 11, 2010, 10:28am

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]

system · March 11, 2010, 5:52pm

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]