Service Connect Process Variables in subworkflows

Yahoo Archive
1
You can also use the sort and unique options as a possibility...Sort by Company?, Customer?, then PO?...Then get a list of unique POs...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of simstrak
Sent: Tuesday, February 12, 2013 10:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Process Variables in subworkflows



Rob,

That's one way to git'r'done.

Here's my problem. I've got a file that I need to create sales orders from. There's a customer PO number on the file, and every time it changes, I need to create a new PO. The way I've done it in the past is ran the file through a script outside of Service Connect to break it into one file for each sales order. I'm trying to eliminate the front-end script.

Kevin

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek wrote:
>
> Kevin,
>
> I've hit that same challenge in the past as well.. I haven't found a cool or sophisticated solution yet either... but instead just to gain traction I jammed the value into an user defined field in the company table and just did a quick query to grab it and go...when it changes I overwrite the last value.. not sure if that's helpful, but it worked for me..
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-4832
> FAX: (715)284-4084
> [cid:1.234354861@...]
> (Click the logo to view our site)
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Kevin Simon
> Sent: Tuesday, February 12, 2013 7:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Service Connect Process Variables in subworkflows
>
>
>
> I'm using Service Connect, and I've got a challenge I've never been able to
> solve. I'm trying to set the value of a process variable from within the
> sub-workflow, and have that new value be available to the next time a record
> is processed through the sub-workflow.
>
> It appears that the process variable takes the value it was set to in the
> main workflow and uses that value for each subworkflow it calls, even if the
> sub-workflow changes it. I am running my sub-workflows synchronously.
>
> So, say I have a process variable and I set it to a value of "1" in the main
> workflow, then call the subworkflow where I'm going to process three records
> through. When the first record is getting processed in the sub-workflow, I
> then set the value of that process variable to "2". Service Connect
> finishes processing that record, then runs the second record through the
> sub-workflow. At this point, the value of the process variable is again set
> to "1". Is there any way I can pick up that value of "2" that the first
> sub-workflow was setting?
>
> Thanks.
>
> Kevin Simon
>
> [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]
2
I'm using Service Connect, and I've got a challenge I've never been able to
solve. I'm trying to set the value of a process variable from within the
sub-workflow, and have that new value be available to the next time a record
is processed through the sub-workflow.



It appears that the process variable takes the value it was set to in the
main workflow and uses that value for each subworkflow it calls, even if the
sub-workflow changes it. I am running my sub-workflows synchronously.



So, say I have a process variable and I set it to a value of "1" in the main
workflow, then call the subworkflow where I'm going to process three records
through. When the first record is getting processed in the sub-workflow, I
then set the value of that process variable to "2". Service Connect
finishes processing that record, then runs the second record through the
sub-workflow. At this point, the value of the process variable is again set
to "1". Is there any way I can pick up that value of "2" that the first
sub-workflow was setting?



Thanks.

Kevin Simon



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

I've hit that same challenge in the past as well.. I haven't found a cool or sophisticated solution yet either... but instead just to gain traction I jammed the value into an user defined field in the company table and just did a quick query to grab it and go...when it changes I overwrite the last value.. not sure if that's helpful, but it worked for me..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<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 Kevin Simon
Sent: Tuesday, February 12, 2013 7:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Process Variables in subworkflows



I'm using Service Connect, and I've got a challenge I've never been able to
solve. I'm trying to set the value of a process variable from within the
sub-workflow, and have that new value be available to the next time a record
is processed through the sub-workflow.

It appears that the process variable takes the value it was set to in the
main workflow and uses that value for each subworkflow it calls, even if the
sub-workflow changes it. I am running my sub-workflows synchronously.

So, say I have a process variable and I set it to a value of "1" in the main
workflow, then call the subworkflow where I'm going to process three records
through. When the first record is getting processed in the sub-workflow, I
then set the value of that process variable to "2". Service Connect
finishes processing that record, then runs the second record through the
sub-workflow. At this point, the value of the process variable is again set
to "1". Is there any way I can pick up that value of "2" that the first
sub-workflow was setting?

Thanks.

Kevin Simon

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



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

That's one way to git'r'done.

Here's my problem. I've got a file that I need to create sales orders from. There's a customer PO number on the file, and every time it changes, I need to create a new PO. The way I've done it in the past is ran the file through a script outside of Service Connect to break it into one file for each sales order. I'm trying to eliminate the front-end script.

Kevin

--- In vantage@yahoogroups.com, Rob Bucek wrote:
>
> Kevin,
>
> I've hit that same challenge in the past as well.. I haven't found a cool or sophisticated solution yet either... but instead just to gain traction I jammed the value into an user defined field in the company table and just did a quick query to grab it and go...when it changes I overwrite the last value.. not sure if that's helpful, but it worked for me..
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-4832
> FAX: (715)284-4084
> [cid:1.234354861@...]
> (Click the logo to view our site)
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kevin Simon
> Sent: Tuesday, February 12, 2013 7:10 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Service Connect Process Variables in subworkflows
>
>
>
> I'm using Service Connect, and I've got a challenge I've never been able to
> solve. I'm trying to set the value of a process variable from within the
> sub-workflow, and have that new value be available to the next time a record
> is processed through the sub-workflow.
>
> It appears that the process variable takes the value it was set to in the
> main workflow and uses that value for each subworkflow it calls, even if the
> sub-workflow changes it. I am running my sub-workflows synchronously.
>
> So, say I have a process variable and I set it to a value of "1" in the main
> workflow, then call the subworkflow where I'm going to process three records
> through. When the first record is getting processed in the sub-workflow, I
> then set the value of that process variable to "2". Service Connect
> finishes processing that record, then runs the second record through the
> sub-workflow. At this point, the value of the process variable is again set
> to "1". Is there any way I can pick up that value of "2" that the first
> sub-workflow was setting?
>
> Thanks.
>
> Kevin Simon
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
5
Ok, so if i pick up what you're laying down, could you, in the sub that is creating your orders, do a get rows by the customer PO (here I'm assuming you're putting that PO somewhere in the SO header) and if you find it, add a new line, if you don't, use a choice element to path it to create a new order. I do something similar where i want to limit the number of lines on a SO to thirty for a given shipto location..

Sent from my Verizon Wireless 4G LTE DROID


simstrak <simstrak@...> wrote:



Rob,

That's one way to git'r'done.

Here's my problem. I've got a file that I need to create sales orders from. There's a customer PO number on the file, and every time it changes, I need to create a new PO. The way I've done it in the past is ran the file through a script outside of Service Connect to break it into one file for each sales order. I'm trying to eliminate the front-end script.

Kevin

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek wrote:
>
> Kevin,
>
> I've hit that same challenge in the past as well.. I haven't found a cool or sophisticated solution yet either... but instead just to gain traction I jammed the value into an user defined field in the company table and just did a quick query to grab it and go...when it changes I overwrite the last value.. not sure if that's helpful, but it worked for me..
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-4832
> FAX: (715)284-4084
> [cid:1.234354861@...]
> (Click the logo to view our site)
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Kevin Simon
> Sent: Tuesday, February 12, 2013 7:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Service Connect Process Variables in subworkflows
>
>
>
> I'm using Service Connect, and I've got a challenge I've never been able to
> solve. I'm trying to set the value of a process variable from within the
> sub-workflow, and have that new value be available to the next time a record
> is processed through the sub-workflow.
>
> It appears that the process variable takes the value it was set to in the
> main workflow and uses that value for each subworkflow it calls, even if the
> sub-workflow changes it. I am running my sub-workflows synchronously.
>
> So, say I have a process variable and I set it to a value of "1" in the main
> workflow, then call the subworkflow where I'm going to process three records
> through. When the first record is getting processed in the sub-workflow, I
> then set the value of that process variable to "2". Service Connect
> finishes processing that record, then runs the second record through the
> sub-workflow. At this point, the value of the process variable is again set
> to "1". Is there any way I can pick up that value of "2" that the first
> sub-workflow was setting?
>
> Thanks.
>
> Kevin Simon
>
> [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
Keep in mind I'm looking at this through my phone..on the main hand held menu, you have two new entries, there should be only one, job tracker and Wip tracker are one in the same..whey you call it doesn't matter..the layout screen for the wip tracker doesn't exist for us..what you have labeled as the job tracker does..the asm tab is the view from the part location tab on the Main epicor application job tracker form..when a user highlights a given line on that grid view, the application finds the most recent material move request from the material queue and then upon clicking a button to process the queue, brings up a screen analogous to the process queue form I'm the material queue form to process the queue. We never accept jobs to inventory. Hope this helps, it certainly reduces the scope..

Sent from my Verizon Wireless 4G LTE DROID


Rob Bucek <rbucek@...> wrote:



Kevin,

I've hit that same challenge in the past as well.. I haven't found a cool or sophisticated solution yet either... but instead just to gain traction I jammed the value into an user defined field in the company table and just did a quick query to grab it and go...when it changes I overwrite the last value.. not sure if that's helpful, but it worked for me..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]http://www.dsmfg.com/>
(Click the logo to view our site)http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Kevin Simon
Sent: Tuesday, February 12, 2013 7:10 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect Process Variables in subworkflows

I'm using Service Connect, and I've got a challenge I've never been able to
solve. I'm trying to set the value of a process variable from within the
sub-workflow, and have that new value be available to the next time a record
is processed through the sub-workflow.

It appears that the process variable takes the value it was set to in the
main workflow and uses that value for each subworkflow it calls, even if the
sub-workflow changes it. I am running my sub-workflows synchronously.

So, say I have a process variable and I set it to a value of "1" in the main
workflow, then call the subworkflow where I'm going to process three records
through. When the first record is getting processed in the sub-workflow, I
then set the value of that process variable to "2". Service Connect
finishes processing that record, then runs the second record through the
sub-workflow. At this point, the value of the process variable is again set
to "1". Is there any way I can pick up that value of "2" that the first
sub-workflow was setting?

Thanks.

Kevin Simon

[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]
7
Oops, let this be a lesson to all you kids out there about the dangers of alcohol..

Sent from my Verizon Wireless 4G LTE DROID


Rob Bucek <rbucek@...> wrote:

Keep in mind I'm looking at this through my phone..on the main hand held menu, you have two new entries, there should be only one, job tracker and Wip tracker are one in the same..whey you call it doesn't matter..the layout screen for the wip tracker doesn't exist for us..what you have labeled as the job tracker does..the asm tab is the view from the part location tab on the Main epicor application job tracker form..when a user highlights a given line on that grid view, the application finds the most recent material move request from the material queue and then upon clicking a button to process the queue, brings up a screen analogous to the process queue form I'm the material queue form to process the queue. We never accept jobs to inventory. Hope this helps, it certainly reduces the scope..

Sent from my Verizon Wireless 4G LTE DROID


Rob Bucek <rbucek@...> wrote:



Kevin,

I've hit that same challenge in the past as well.. I haven't found a cool or sophisticated solution yet either... but instead just to gain traction I jammed the value into an user defined field in the company table and just did a quick query to grab it and go...when it changes I overwrite the last value.. not sure if that's helpful, but it worked for me..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]http://www.dsmfg.com/>
(Click the logo to view our site)http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Kevin Simon
Sent: Tuesday, February 12, 2013 7:10 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect Process Variables in subworkflows

I'm using Service Connect, and I've got a challenge I've never been able to
solve. I'm trying to set the value of a process variable from within the
sub-workflow, and have that new value be available to the next time a record
is processed through the sub-workflow.

It appears that the process variable takes the value it was set to in the
main workflow and uses that value for each subworkflow it calls, even if the
sub-workflow changes it. I am running my sub-workflows synchronously.

So, say I have a process variable and I set it to a value of "1" in the main
workflow, then call the subworkflow where I'm going to process three records
through. When the first record is getting processed in the sub-workflow, I
then set the value of that process variable to "2". Service Connect
finishes processing that record, then runs the second record through the
sub-workflow. At this point, the value of the process variable is again set
to "1". Is there any way I can pick up that value of "2" that the first
sub-workflow was setting?

Thanks.

Kevin Simon

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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
8
Actually, that's a great idea! It adds an additional web service/.net call
- which I try to limit for performance reasons. But it eliminates having to
break my input into multiple files. I think I'll go that route. Thanks for
the feedback!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, February 13, 2013 12:09 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Service Connect Process Variables in subworkflows

Ok, so if i pick up what you're laying down, could you, in the sub that is
creating your orders, do a get rows by the customer PO (here I'm assuming
you're putting that PO somewhere in the SO header) and if you find it, add a
new line, if you don't, use a choice element to path it to create a new
order. I do something similar where i want to limit the number of lines on
a SO to thirty for a given shipto location..

Sent from my Verizon Wireless 4G LTE DROID


simstrak <simstrak@...> wrote:



Rob,

That's one way to git'r'done.

Here's my problem. I've got a file that I need to create sales orders from.
There's a customer PO number on the file, and every time it changes, I need
to create a new PO. The way I've done it in the past is ran the file through
a script outside of Service Connect to break it into one file for each sales
order. I'm trying to eliminate the front-end script.

Kevin

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek
wrote:
>
> Kevin,
>
> I've hit that same challenge in the past as well.. I haven't found a cool
or sophisticated solution yet either... but instead just to gain traction I
jammed the value into an user defined field in the company table and just
did a quick query to grab it and go...when it changes I overwrite the last
value.. not sure if that's helpful, but it worked for me..
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-4832
> FAX: (715)284-4084
> [cid:1.234354861@...]
> (Click the logo to view our site)
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
> Behalf Of Kevin Simon
> Sent: Tuesday, February 12, 2013 7:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Service Connect Process Variables in subworkflows
>
>
>
> I'm using Service Connect, and I've got a challenge I've never been
> able to solve. I'm trying to set the value of a process variable from
> within the sub-workflow, and have that new value be available to the
> next time a record is processed through the sub-workflow.
>
> It appears that the process variable takes the value it was set to in
> the main workflow and uses that value for each subworkflow it calls,
> even if the sub-workflow changes it. I am running my sub-workflows
synchronously.
>
> So, say I have a process variable and I set it to a value of "1" in
> the main workflow, then call the subworkflow where I'm going to
> process three records through. When the first record is getting
> processed in the sub-workflow, I then set the value of that process
> variable to "2". Service Connect finishes processing that record, then
> runs the second record through the sub-workflow. At this point, the
> value of the process variable is again set to "1". Is there any way I
> can pick up that value of "2" that the first sub-workflow was setting?
>
> Thanks.
>
> Kevin Simon
>
> [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]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
9
Let me know how it turns out, i hear you on limiting calls!

Sent from my Verizon Wireless 4G LTE DROID


Kevin Simon <simstrak@...> wrote:



Actually, that's a great idea! It adds an additional web service/.net call
- which I try to limit for performance reasons. But it eliminates having to
break my input into multiple files. I think I'll go that route. Thanks for
the feedback!

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Rob Bucek
Sent: Wednesday, February 13, 2013 12:09 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Service Connect Process Variables in subworkflows

Ok, so if i pick up what you're laying down, could you, in the sub that is
creating your orders, do a get rows by the customer PO (here I'm assuming
you're putting that PO somewhere in the SO header) and if you find it, add a
new line, if you don't, use a choice element to path it to create a new
order. I do something similar where i want to limit the number of lines on
a SO to thirty for a given shipto location..

Sent from my Verizon Wireless 4G LTE DROID

simstrak simstrak@...<mailto:simstrak%40gmail.com>> wrote:

Rob,

That's one way to git'r'done.

Here's my problem. I've got a file that I need to create sales orders from.
There's a customer PO number on the file, and every time it changes, I need
to create a new PO. The way I've done it in the past is ran the file through
a script outside of Service Connect to break it into one file for each sales
order. I'm trying to eliminate the front-end script.

Kevin

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek
wrote:
>
> Kevin,
>
> I've hit that same challenge in the past as well.. I haven't found a cool
or sophisticated solution yet either... but instead just to gain traction I
jammed the value into an user defined field in the company table and just
did a quick query to grab it and go...when it changes I overwrite the last
value.. not sure if that's helpful, but it worked for me..
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-4832
> FAX: (715)284-4084
> [cid:1.234354861@...]
> (Click the logo to view our site)
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
> Behalf Of Kevin Simon
> Sent: Tuesday, February 12, 2013 7:10 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Service Connect Process Variables in subworkflows
>
>
>
> I'm using Service Connect, and I've got a challenge I've never been
> able to solve. I'm trying to set the value of a process variable from
> within the sub-workflow, and have that new value be available to the
> next time a record is processed through the sub-workflow.
>
> It appears that the process variable takes the value it was set to in
> the main workflow and uses that value for each subworkflow it calls,
> even if the sub-workflow changes it. I am running my sub-workflows
synchronously.
>
> So, say I have a process variable and I set it to a value of "1" in
> the main workflow, then call the subworkflow where I'm going to
> process three records through. When the first record is getting
> processed in the sub-workflow, I then set the value of that process
> variable to "2". Service Connect finishes processing that record, then
> runs the second record through the sub-workflow. At this point, the
> value of the process variable is again set to "1". Is there any way I
> can pick up that value of "2" that the first sub-workflow was setting?
>
> Thanks.
>
> Kevin Simon
>
> [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]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





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