Service Connect Help

Yahoo Archive
1
Someone else on here had suggested a DB operation, that is a very legitimate solution as well. If you’re really comfortable with SQL queries (and you really can’t swing a dead cat without hitting resources out there for that stuff) you could get it done that way as well. Note that you’ll still have to re-route your data because SC is only capable of handling one schema per operation in the dta section unfortunately… so in the end it’s somewhat of a wash.

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
www.dsmfg.com<http://www.dsmfg.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, November 19, 2015 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Help



I was afraid it was going to be that extensive. I will give it a shot though. I'm sure I will jack it up, but I will back it up before I destroy it.



[Non-text portions of this message have been removed]
2
Can anyone give me an idea how to get the material sequence number I created using GetNewJobMtl method. My workflow is creating the material for me, now I want to add an attachment to the material after the material has been created in the same workflow. It keeps returning the top most sequence number and not the one i created in the workflow. Any help would be great.

Thanks,

Ted
3
If youre doing it immediately after you created the new material, chances are the sequence number isn't available yet until you commit the record, if you do an update, then do a jobmtlsearch and pick it up again that might work, or, if im wrong and it is there, just not in the current dataset, use a functoid and add 10 to the sequence number it is returning... try either one of those...

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: 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 tkoch77
Sent: Friday, November 11, 2011 9:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Help



Can anyone give me an idea how to get the material sequence number I created using GetNewJobMtl method. My workflow is creating the material for me, now I want to add an attachment to the material after the material has been created in the same workflow. It keeps returning the top most sequence number and not the one i created in the workflow. Any help would be great.

Thanks,

Ted



[Non-text portions of this message have been removed]
4
I got it to work, in the first conversion I had an output schema of GetNewJobMtl_Request which was correct, but in it I was assigning data to the JobMtl table at this point, so it was getting two sets of data for the JobMtl table. I deleted all links to the JobMtl table and the next conversion saved the MtlSeq number from the response to a process variable to use later when i assigned the attachment and that fixed it.



________________________________
From: Rob Bucek <rbucek@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, November 11, 2011 11:24 AM
Subject: RE: [Vantage] Service Connect Help

If youre doing it immediately after you created the new material, chances are the sequence number isn't available yet until you commit the record, if you do an update, then do a jobmtlsearch and pick it up again that might work, or, if im wrong and it is there, just not in the current dataset, use a functoid and add 10 to the sequence number it is returning... try either one of those...

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: 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 tkoch77
Sent: Friday, November 11, 2011 9:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Help



Can anyone give me an idea how to get the material sequence number I created using GetNewJobMtl method. My workflow is creating the material for me, now I want to add an attachment to the material after the material has been created in the same workflow. It keeps returning the top most sequence number and not the one i created in the workflow. Any help would be great.

Thanks,

Ted



[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/.%c2%a0
(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]
5

I have a separate Order Management system that feeds through Service Connect to add the Order (Drop Ship Order) into Epicor.  The workflow creates the Sales Order then creates the Purchase Order for the Drop Ship.  


I want to modify the workflow to include a User Defined field from the Part Table.  The workflow doesn't have the Part table as a reference.  I have the Unit Price being dropped into Part.Number20 field and want to feed that to the PODetail.DocUnitCost in the section of the workflow that creates the Purchase Order.  


Can someone help?

6

What version are you on? E9 has UD fields and E10 you can add your own UD fields.

 

Thanks,

 

Steve

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 18, 2015 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Help

 

 

I have a separate Order Management system that feeds through Service Connect to add the Order (Drop Ship Order) into Epicor.  The workflow creates the Sales Order then creates the Purchase Order for the Drop Ship.  

 

I want to modify the workflow to include a User Defined field from the Part Table.  The workflow doesn't have the Part table as a reference.  I have the Unit Price being dropped into Part.Number20 field and want to feed that to the PODetail.DocUnitCost in the section of the workflow that creates the Purchase Order.  

 

Can someone help?

7
Bring in the Part BO as a reference, then to a getbyid call to the part table

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
www.dsmfg.com<http://www.dsmfg.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 18, 2015 8:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Help


What version are you on? E9 has UD fields and E10 you can add your own UD fields.

Thanks,

Steve

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 18, 2015 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Help



I have a separate Order Management system that feeds through Service Connect to add the Order (Drop Ship Order) into Epicor. The workflow creates the Sales Order then creates the Purchase Order for the Drop Ship.



I want to modify the workflow to include a User Defined field from the Part Table. The workflow doesn't have the Part table as a reference. I have the Unit Price being dropped into Part.Number20 field and want to feed that to the PODetail.DocUnitCost in the section of the workflow that creates the Purchase Order.



Can someone help?



[Non-text portions of this message have been removed]
8
I am on 9.05.702.

I tried adding the Reference, but right clicking and adding a reference, but it is asking for the Service URL and I am inputting http://localhost/EpicorServices/part.asmx, but it fails when I try to add it.  Is the URL I am inputting incorrect?
 
9
If the only thing you need is Part.Number20 (not the rest of the dataset), it might be easier to just do a DBOperation within your Conversion step. Â Using a DBOperation, you can point to your Epicor database via odbc connection and return just the field you need. Â


Ivan

On Wed, Nov 18, 2015 at 6:31 AM, ahsalloum@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span>I have a separate Order Management system that feeds through Service Connect to add the Order (Drop Ship Order) into Epicor.  The workflow creates the Sales Order then creates the Purchase Order for the Drop Ship.  </span></p><p><span><br></span></p><p><span>I want to modify the workflow to include a User Defined field from the Part Table.  The workflow doesn&#39;t have the Part table as a reference.  I have the Unit Price being dropped into Part.Number20 field and want to feed that to the PODetail.DocUnitCost in the section of the workflow that creates the Purchase Order.  </span></p><p><span><br></span></p><p><span>Can someone help?</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>



--

Thanks,

Ivan A. Wright | Systems Interface Development SpecialistÂ

NRS -- 100% Employee OwnedÂ

Â

2009 S. Main St. Moscow, ID 83843

ivan@... | www.nrs.com

p: 208.892.5962 | f: 208.882.1744

10
Use the .net references, I don’t ever advise using WSE or WCF if you’re on 9 and on…even if your workflow is using web services, you can mix and match. You just need to point to the assembly on your server.

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
www.dsmfg.com<http://www.dsmfg.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 18, 2015 12:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Help



I am on 9.05.702.

I tried adding the Reference, but right clicking and adding a reference, but it is asking for the Service URL and I am inputting http://localhost/EpicorServices/part.asmx, but it fails when I try to add it. Is the URL I am inputting incorrect?




[Non-text portions of this message have been removed]
11
OK, so I added the Part Reference under the .net.  how do I point to it in the assembly as you mentioned?  I believe that is what is why i can't see it in the workflow designer.
12
Did you do something along these lines?

http://imgur.com/5RKlaHh


Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
www.dsmfg.com<http://www.dsmfg.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 18, 2015 1:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Help



OK, so I added the Part Reference under the .net. how do I point to it in the assembly as you mentioned? I believe that is what is why i can't see it in the workflow designer.



[Non-text portions of this message have been removed]
13
Rob, Yes i did all that except the last step.  I think that is what i am missing.  Your images move to quick for me to see where you are doing that.  Do I need to add another link in the workflow to have the Part Reference show up in the mapping?

Could you explain in detail what I need to do to have the reference show up when mapping the PO Line creation?
14
Now were getting deeper in to work flow development… so somewhere in your workflow..prior to needing that info, you’ll want to insert a conversion element followed by a .net element. The inbound schema of your conversion element will contain the outbound schema of whatever is previous to it and the outbound schema will be your getbyid request for the .net element that follows. Most likely you’ll need to pass your current data down the the wfl:usr section in a container to store it while you are getting your part data. Depending on how your workflow is constructed or how you want to do things, once it brings back your part data, you’ll either plug in your data right into your original schema as you bring it back up from the wfl:usr section or store it as a variable and use it later. I’ve provided a couple high level screen shots that explain one way you could go about this…


http://jcg.pictures/gd6JVnatjgje.png

http://jcg.pictures/gd6JVIujjX7.png

http://jcg.pictures/gd6JVZSghX8.png

http://jcg.pictures/gd6JVihifFhbhj.png



Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
www.dsmfg.com<http://www.dsmfg.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, November 19, 2015 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect Help



Rob, Yes i did all that except the last step. I think that is what i am missing. Your images move to quick for me to see where you are doing that. Do I need to add another link in the workflow to have the Part Reference show up in the mapping?

Could you explain in detail what I need to do to have the reference show up when mapping the PO Line creation?



[Non-text portions of this message have been removed]
15
I was afraid it was going to be that extensive.  I will give it a shot though.  I'm sure I will jack it up, but I will back it up before I destroy it.