Service Connect Workflow

The data would be updated with the SalesOrder.OnChangePart method. Using the UpdateExt to update the lines would not do the pricing updates. I would use the getnewline and insert the line information there. That should populate the unit price after the get new is populated.

 

Charlie Smith

CTCharlie@...

Cell: 860-919-1708

Office: 817-862-9862

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 04, 2015 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Workflow

 

 

We have a Service Connect Workflow that gets a list of parts from a third party database and creates new Sales Order Lines in an existing Sales Order.  The workflow is called by BPM when certain conditions exist and uses the SalesOrder.UpdateExt method to add the new lines.  The new lines  added by the workflow do not retrieve the UnitPrice, or any other information, from the Part table as would be expected.  Is there a step I'm missing in the workflow to tell Epicor to retrieve that info?

 

Thanks in advance.

 

Hi Service Connect Gurus! I need a little help. I would like to use SC to create a Transfer Order from a .csv file. My question is, how do I cycle on each line without creating separate transfer order headers for each line? Below is a sample of data:

Company Requesting Plant Shipping Plant Part Description Quantity Entry Person
CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor

In this case we have a transfer order with 30 lines and I want to create one transfer order with thirty lines.

Any help would be greatly appreciated.

Michelle the "I thought I knew Service Connect" woman

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@...6E5D50]



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



I almost do something similar in a sales order work flow where I want
multiple lines under one header (the commonality being 'shipto'). In
that instance I took the approach of using either a getbyid function or,
that not being appropriate for that particular BO, use a getrows or
getlist and use the where clause functionality to pick that header back
up. You may or may not (since I don't have a work flow for your
scenario im using generalities) need to flow some information to process
variables or message extensions to be used in your where clause. So
your work flow would be to cycle execution to a sub work flow by line,
run your getlist/rows to pick your header up, as an aside, youll need a
choice element in there for when it doesn't find an existing header to
create a new header and flow the data in a different path to create a
new header and add a line. The next cycle should then find that header
and then youll add another line etc..



Of course im assuming that within your dataset you may have to create
more than one header/transfer order with multiple lines. If your
dataset is such that it will only ever contain just one transfer order
then it would simplify your workflow considerably.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michelle de la Vega
Sent: Wednesday, June 23, 2010 1:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Workflow





Hi Service Connect Gurus! I need a little help. I would like to use SC
to create a Transfer Order from a .csv file. My question is, how do I
cycle on each line without creating separate transfer order headers for
each line? Below is a sample of data:

Company Requesting Plant Shipping Plant Part Description Quantity Entry
Person
CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5
Dtaylor
CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor

In this case we have a transfer order with 30 lines and I want to create
one transfer order with thirty lines.

Any help would be greatly appreciated.

Michelle the "I thought I knew Service Connect" woman

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@...6E5D50
<mailto:image001.jpg%4001CB12DB.BF6E5D50> ]

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





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



There are some things that are easy to do in SC, and others that make you
pull your hair out. Having a main workflow create an object header
(transfer order) and sub-workflow create the detail (the lines) is usually
pretty easy. When you have the sub-workflow have to determine whether the
header (transfer order) is already created is not impossible, but it does
make you pull out your SC bag of tricks.



My recommendation when faced with this is usually to go back to the code
that created the CSV in the first place. Usually, it is much easier to
create multiple CSV files from the creating procedure, then use the main
workflow for creating the transfer order, and the sub-workflows for creating
the lines. If you've got a case then where you would normally have 30 lines
but you'd want them on 3 different transfer orders, you'd just have three
csv files, and you'd invoke the workflow three times.



HTH.

Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michelle de la Vega
Sent: Wednesday, June 23, 2010 2:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect Workflow





Hi Service Connect Gurus! I need a little help. I would like to use SC to
create a Transfer Order from a .csv file. My question is, how do I cycle on
each line without creating separate transfer order headers for each line?
Below is a sample of data:

Company Requesting Plant Shipping Plant Part Description Quantity Entry
Person
CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor

In this case we have a transfer order with 30 lines and I want to create one
transfer order with thirty lines.

Any help would be greatly appreciated.

Michelle the "I thought I knew Service Connect" woman

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@...6E5D50
<mailto:image001.jpg%4001CB12DB.BF6E5D50> ]

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





[Non-text portions of this message have been removed]
No SC help to offer, but whether it is a single trans order w/ 30 lines, or 30 one line trans orders, does it really matter? (Really? - from a long term process ease of execution standpoint in this age of barcode driven apps?)
I ask as MRP would generate 30 transfer order suggestions or, if you use KanBan Monitor and related apps/processes - you'd likely have 30 tranfer order headers w/ one line per.

Is it a 'want' (perhaps to mimic 'the way we have always done it' on a legacy system?

Or is it a true need (or at least a true 'big picture' benefit)?

(Sorry - I'm an IE so I ask 'why' (repeatedly! ) a LOT!)
/:o

I've found it best to bend & live within what a system does best (and not try and get systems to do things that we're handled just fine - often better than under today's crop of sofware offerings) BEFORE there were systems.
Rob
--- Original Message ---
From:"Michelle de la Vega" <mdelavega@...>
Sent:Wed 6/23/10 2:03 pm
To:"vantage@yahoogroups.com" <vantage@yahoogroups.com>
Subj:[Vantage] Service Connect Workflow

Hi Service Connect Gurus! I need a little help. I would like to use SC to create a Transfer Order from a .csv file. My question is, how do I cycle on each line without creating separate transfer order headers for each line? Below is a sample of data:

Company Requesting Plant Shipping Plant Part Description Quantity Entry Person
CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor

In this case we have a transfer order with 30 lines and I want to create one transfer order with thirty lines.

Any help would be greatly appreciated.

Michelle the "I thought I knew Service Connect" woman

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA
+1 513-716-6400 (office)
+1 513-382-3281 (mobile)
+1 513-831-1209 (fax)
www.coldjet.com<http://www.coldjet.com>
[cid:image001.jpg@...6E5D50]



[Non-text portions of this message have been removed]
I am trying to mimic the attachment process Epicor does when adding an attachment to a PO Line. I did a trace and then used the Epicor Log Converter tool. My workflow is Start -> Conversion -> .Net Call -> conversion -> .Net call -> finish. For the first conversion the input schema is my csv file that was converted to .xsd and output is GetNewPODetailAttch_Request. For the conversion I am linking from the dta/table/row/PONum and POLine to dta/GetNewPODetailAttch_Request/poNUM and poLine. It throws an error on the .net call saying Object reference not set to an instance of an object. Not the most descriptive message. According to the trace log the GetNewPODetailAttch method looks for the poNUM and poLine parameters and then continues on to the Update method.

This is one of my first workflows that has more than one .net call in it and more than one conversion. Any help greatly appreciated.

Thanks,
Ted
As mentioned already, you need a main workflow that will create the header and then a sub-workflow to cycle through the lines.

I've done this with creating Sales Orders from information exported from a legacy system. I doubt the .csv format will work for you unless you are dropping multiple files (one for the header and another for the lines). I found that exporting the data to .xml files worked much better.

If you'd like I can package up the Sales Order workflow and some sample data so you can look it over, just shoot me an email.

Sean

--- In vantage@yahoogroups.com, Michelle de la Vega <mdelavega@...> wrote:
>
> Hi Service Connect Gurus! I need a little help. I would like to use SC to create a Transfer Order from a .csv file. My question is, how do I cycle on each line without creating separate transfer order headers for each line? Below is a sample of data:
>
> Company Requesting Plant Shipping Plant Part Description Quantity Entry Person
> CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
> CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
> CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor
>
> In this case we have a transfer order with 30 lines and I want to create one transfer order with thirty lines.
>
> Any help would be greatly appreciated.
>
> Michelle the "I thought I knew Service Connect" woman
>
> Michelle de la Vega
> Business Applications Manager
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
> +1 513-716-6400 (office)
> +1 513-382-3281 (mobile)
> +1 513-831-1209 (fax)
> www.coldjet.com<http://www.coldjet.com>
> [cid:image001.jpg@...]
>
>
>
> [Non-text portions of this message have been removed]
>
The csv files will work. The trick is to have the same schema for each one.
That means that you need at minimum header information on each record. You
use the first record to create the header, but the rest of the records is
just a place holder. Either of the following would work:



Company,OrdDate,CustID,PartNum,Qty

ABCD,2011-11-03,ACME,PART1234,100

ABCD,2011-11-03,ACME,PART5678,200

ABCD,2011-11-03,ACME,PART9999,300



Or.

Company,OrdDate,CustID,PartNum,Qty

ABCD,2011-11-03,ACME,PART1234,100

, , ,PART5678,200

, , ,PART9999,300





HTH



Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sbraudrick@...
Sent: Wednesday, November 02, 2011 2:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Workflow





As mentioned already, you need a main workflow that will create the header
and then a sub-workflow to cycle through the lines.

I've done this with creating Sales Orders from information exported from a
legacy system. I doubt the .csv format will work for you unless you are
dropping multiple files (one for the header and another for the lines). I
found that exporting the data to .xml files worked much better.

If you'd like I can package up the Sales Order workflow and some sample data
so you can look it over, just shoot me an email.

Sean

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Michelle
de la Vega <mdelavega@...> wrote:
>
> Hi Service Connect Gurus! I need a little help. I would like to use SC to
create a Transfer Order from a .csv file. My question is, how do I cycle on
each line without creating separate transfer order headers for each line?
Below is a sample of data:
>
> Company Requesting Plant Shipping Plant Part Description Quantity Entry
Person
> CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
> CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
> CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor
>
> In this case we have a transfer order with 30 lines and I want to create
one transfer order with thirty lines.
>
> Any help would be greatly appreciated.
>
> Michelle the "I thought I knew Service Connect" woman
>
> Michelle de la Vega
> Business Applications Manager
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
> +1 513-716-6400 (office)
> +1 513-382-3281 (mobile)
> +1 513-831-1209 (fax)
> www.coldjet.com<http://www.coldjet.com>
> [cid:image001.jpg@...]
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I guess I'm getting lost what it is asking me for in the header information. What exactly is it looking for? Is it because I am updating a child table, I have to give the parent table the same information so it knows what to do or am I wrong?



________________________________
From: Kevin Simon <simstrak@...>
To: vantage@yahoogroups.com
Sent: Thursday, November 3, 2011 12:24 AM
Subject: RE: [Vantage] Re: Service Connect Workflow

The csv files will work. The trick is to have the same schema for each one.
That means that you need at minimum header information on each record. You
use the first record to create the header, but the rest of the records is
just a place holder. Either of the following would work:



Company,OrdDate,CustID,PartNum,Qty

ABCD,2011-11-03,ACME,PART1234,100

ABCD,2011-11-03,ACME,PART5678,200

ABCD,2011-11-03,ACME,PART9999,300



Or.

Company,OrdDate,CustID,PartNum,Qty

ABCD,2011-11-03,ACME,PART1234,100

, , ,PART5678,200

, , ,PART9999,300





HTH



Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sbraudrick@...
Sent: Wednesday, November 02, 2011 2:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Workflow



Â

As mentioned already, you need a main workflow that will create the header
and then a sub-workflow to cycle through the lines.

I've done this with creating Sales Orders from information exported from a
legacy system. I doubt the .csv format will work for you unless you are
dropping multiple files (one for the header and another for the lines). I
found that exporting the data to .xml files worked much better.

If you'd like I can package up the Sales Order workflow and some sample data
so you can look it over, just shoot me an email.

Sean

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Michelle
de la Vega <mdelavega@...> wrote:
>
> Hi Service Connect Gurus! I need a little help. I would like to use SC to
create a Transfer Order from a .csv file. My question is, how do I cycle on
each line without creating separate transfer order headers for each line?
Below is a sample of data:
>
> Company Requesting Plant Shipping Plant Part Description Quantity Entry
Person
> CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
> CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
> CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor
>
> In this case we have a transfer order with 30 lines and I want to create
one transfer order with thirty lines.
>
> Any help would be greatly appreciated.
>
> Michelle the "I thought I knew Service Connect" woman
>
> Michelle de la Vega
> Business Applications Manager
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
> +1 513-716-6400 (office)
> +1 513-382-3281 (mobile)
> +1 513-831-1209 (fax)
> www.coldjet.com<http://www.coldjet.com>
> [cid:image001.jpg@...]
>
>
>
> [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/.%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]
Ted,
Have you run a trace? "Most" of the time, a trace will give you all the info you need.

--Matt

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> I guess I'm getting lost what it is asking me for in the header information. What exactly is it looking for? Is it because I am updating a child table, I have to give the parent table the same information so it knows what to do or am I wrong?
>
>
>
> ________________________________
> From: Kevin Simon <simstrak@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, November 3, 2011 12:24 AM
> Subject: RE: [Vantage] Re: Service Connect Workflow
>
> The csv files will work. The trick is to have the same schema for each one.
> That means that you need at minimum header information on each record. You
> use the first record to create the header, but the rest of the records is
> just a place holder. Either of the following would work:
>
>
>
> Company,OrdDate,CustID,PartNum,Qty
>
> ABCD,2011-11-03,ACME,PART1234,100
>
> ABCD,2011-11-03,ACME,PART5678,200
>
> ABCD,2011-11-03,ACME,PART9999,300
>
>
>
> Or.
>
> Company,OrdDate,CustID,PartNum,Qty
>
> ABCD,2011-11-03,ACME,PART1234,100
>
> , , ,PART5678,200
>
> , , ,PART9999,300
>
>
>
>
>
> HTH
>
>
>
> Kevin Simon
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> sbraudrick@...
> Sent: Wednesday, November 02, 2011 2:31 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Service Connect Workflow
>
>
>
> Â
>
> As mentioned already, you need a main workflow that will create the header
> and then a sub-workflow to cycle through the lines.
>
> I've done this with creating Sales Orders from information exported from a
> legacy system. I doubt the .csv format will work for you unless you are
> dropping multiple files (one for the header and another for the lines). I
> found that exporting the data to .xml files worked much better.
>
> If you'd like I can package up the Sales Order workflow and some sample data
> so you can look it over, just shoot me an email.
>
> Sean
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Michelle
> de la Vega <mdelavega@> wrote:
> >
> > Hi Service Connect Gurus! I need a little help. I would like to use SC to
> create a Transfer Order from a .csv file. My question is, how do I cycle on
> each line without creating separate transfer order headers for each line?
> Below is a sample of data:
> >
> > Company Requesting Plant Shipping Plant Part Description Quantity Entry
> Person
> > CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
> > CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
> > CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor
> >
> > In this case we have a transfer order with 30 lines and I want to create
> one transfer order with thirty lines.
> >
> > Any help would be greatly appreciated.
> >
> > Michelle the "I thought I knew Service Connect" woman
> >
> > Michelle de la Vega
> > Business Applications Manager
> > Cold Jet, LLC
> > 455 Wards Corner Road
> > Loveland, Ohio 45140
> > USA
> > +1 513-716-6400 (office)
> > +1 513-382-3281 (mobile)
> > +1 513-831-1209 (fax)
> > www.coldjet.com<http://www.coldjet.com>
> > [cid:image001.jpg@]
> >
> >
> >
> > [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/.%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]
>
Yes I ran a trace. The trace returned Epicor.Mfg.BO.PO GetNewPODetailAttch and Epicor.Mfg.BO.PO Update. I used the epicor log converter tool to build a workflow from the trace. I guess I'm not sure what information it is asking for. The GetNewPODetailAttch method shows this at the end of it:

</PODataSet></parameter>
   <parameter name='poNUM' type='System.Int32' ><![CDATA[369]]></parameter>
   <parameter name='poLine' type='System.Int32' ><![CDATA[2]]></parameter>
   </parameters>
   <paramDataSetChanges>
      <paramDataSet name='cc' useDataSetNbr='0' >
      </paramDataSet>
   </paramDataSetChanges>
</tracePacket>

Then after the update it shows the row that has been added.

</PODataSet></parameter>
   </parameters>
   <paramDataSetChanges>
      <paramDataSet name='cc' useDataSetNbr='0' >
      </paramDataSet>
      <paramDataSet name='ds' useDataSetNbr='0' >
         <changedValue tableName='PODetail' rowState='Modified' rowNum='1' colName='DBRowIdent' ><![CDATA[System.Byte[]]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='Company' ><![CDATA[100]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='PONUM' ><![CDATA[369]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='POLine' ><![CDATA[2]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='DrawingSeq' ><![CDATA[0]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='XFileRefNum' ><![CDATA[0]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='DrawDesc' ><![CDATA[51415K45.jpg]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='FileName' ><![CDATA[C:\Users\Theodore Koch\Desktop\partpics\51415K45.jpg]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='PDMDocID' ><![CDATA[]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='DocTypeID' ><![CDATA[]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='RowIdent' ><![CDATA[]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='RowMod' ><![CDATA[A]]></changedValue>
         <changedValue tableName='PODetailAttch' rowState='Added' rowNum='5' colName='DBRowIdent' ><![CDATA[]]></changedValue>
      </paramDataSet>
   </paramDataSetChanges>
</tracePacket>



________________________________
From: mattcald_73 <matt@...>
To: vantage@yahoogroups.com
Sent: Thursday, November 3, 2011 8:27 AM
Subject: [Vantage] Re: Service Connect Workflow

Ted,
Have you run a trace? "Most" of the time, a trace will give you all the info you need.

--Matt

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> I guess I'm getting lost what it is asking me for in the header information. What exactly is it looking for? Is it because I am updating a child table, I have to give the parent table the same information so it knows what to do or am I wrong?
>
>
>
> ________________________________
> From: Kevin Simon <simstrak@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, November 3, 2011 12:24 AM
> Subject: RE: [Vantage] Re: Service Connect Workflow
>
> The csv files will work. The trick is to have the same schema for each one.
> That means that you need at minimum header information on each record. You
> use the first record to create the header, but the rest of the records is
> just a place holder. Either of the following would work:
>
>
>
> Company,OrdDate,CustID,PartNum,Qty
>
> ABCD,2011-11-03,ACME,PART1234,100
>
> ABCD,2011-11-03,ACME,PART5678,200
>
> ABCD,2011-11-03,ACME,PART9999,300
>
>
>
> Or.
>
> Company,OrdDate,CustID,PartNum,Qty
>
> ABCD,2011-11-03,ACME,PART1234,100
>
> , , ,PART5678,200
>
> , , ,PART9999,300
>
>
>
>
>
> HTH
>
>
>
> Kevin Simon
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> sbraudrick@...
> Sent: Wednesday, November 02, 2011 2:31 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Service Connect Workflow
>
>
>
> Â
>
> As mentioned already, you need a main workflow that will create the header
> and then a sub-workflow to cycle through the lines.
>
> I've done this with creating Sales Orders from information exported from a
> legacy system. I doubt the .csv format will work for you unless you are
> dropping multiple files (one for the header and another for the lines). I
> found that exporting the data to .xml files worked much better.
>
> If you'd like I can package up the Sales Order workflow and some sample data
> so you can look it over, just shoot me an email.
>
> Sean
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Michelle
> de la Vega <mdelavega@> wrote:
> >
> > Hi Service Connect Gurus! I need a little help. I would like to use SC to
> create a Transfer Order from a .csv file. My question is, how do I cycle on
> each line without creating separate transfer order headers for each line?
> Below is a sample of data:
> >
> > Company Requesting Plant Shipping Plant Part Description Quantity Entry
> Person
> > CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
> > CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
> > CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor
> >
> > In this case we have a transfer order with 30 lines and I want to create
> one transfer order with thirty lines.
> >
> > Any help would be greatly appreciated.
> >
> > Michelle the "I thought I knew Service Connect" woman
> >
> > Michelle de la Vega
> > Business Applications Manager
> > Cold Jet, LLC
> > 455 Wards Corner Road
> > Loveland, Ohio 45140
> > USA
> > +1 513-716-6400 (office)
> > +1 513-382-3281 (mobile)
> > +1 513-831-1209 (fax)
> > www.coldjet.com<http://www.coldjet.com>
> > [cid:image001.jpg@]
> >
> >
> >
> > [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/.%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]
>




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

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]

We have a Service Connect Workflow that gets a list of parts from a third party database and creates new Sales Order Lines in an existing Sales Order.  The workflow is called by BPM when certain conditions exist and uses the SalesOrder.UpdateExt method to add the new lines.  The new lines  added by the workflow do not retrieve the UnitPrice, or any other information, from the Part table as would be expected.  Is there a step I'm missing in the workflow to tell Epicor to retrieve that info?


Thanks in advance.