OK - Thanks to all for your suggestions. Here's the deal on how this works:
The CustomerService method, while capable of updating the shipto record doesn't work well for that purpose, in fact, it will not update the default shipto record (shipto=""), there is business logic that forces that record to be updated from updates to the customer table. Not sure which fields are involved, but certainly the address fields, but definitely not the UDF's which is the whole purpose of my workflow. So Epicor created another service that is not in the trace called ShipToService that is designed to update the shipto table. This service allows updates to all shipto records including the default records, so it is possible to get the customer table and the default shipto out of sync. Therefore, I included an update to the customer address when the default shipto is updated to keep it in sync.
Thanks to Ahmed at Epicor for his knowledge and enthusiasm.
Best Regards,
Jim Pratt
The CustomerService method, while capable of updating the shipto record doesn't work well for that purpose, in fact, it will not update the default shipto record (shipto=""), there is business logic that forces that record to be updated from updates to the customer table. Not sure which fields are involved, but certainly the address fields, but definitely not the UDF's which is the whole purpose of my workflow. So Epicor created another service that is not in the trace called ShipToService that is designed to update the shipto table. This service allows updates to all shipto records including the default records, so it is possible to get the customer table and the default shipto out of sync. Therefore, I included an update to the customer address when the default shipto is updated to keep it in sync.
Thanks to Ahmed at Epicor for his knowledge and enthusiasm.
Best Regards,
Jim Pratt
--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> Are you setting the rowmod field?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jmpratt7
> Sent: Monday, August 10, 2009 1:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Service Connect Customer ShipTo Update
>
>
>
>
>
> Karen,
>
> You are correct that the data can be traced through the conversions and
> various method calls in the inbound documents trace. This it the technique I
> am using, and while I see good data on the conversion side of the call, the
> response side does not reflect the changes I am trying to make. Usually this
> is because there is an undocumented field that needs to be included in the
> call but is not. Normally when this happens, there is an eror message,
> however, I am getting no error message, so I am unclear where to go next.
>
> Thanks,
>
> Jim Pratt
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Karen
> Schoenung" <kschoenung@> wrote:
> >
> > Jim,
> >
> >
> > You can check the data along the way at each step by viewing the details
> > in Service Connect tracing (inbound documents)...Open each conversion
> > step and look at the dta sections to see what data is sent...This should
> > narrow it down to which step you are missing - before or after the step
> > where you do not see the data for ShortChar01...
> >
> >
> >
> > Karen
> >
> >
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf
> > Of jmpratt7
> > Sent: Monday, August 10, 2009 6:40 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Service Connect Customer ShipTo Update
> >
> >
> >
> >
> >
> > I am trying to write a workflow to update udf's on the customer shipto
> > table, and so far am unsuccessful.
> >
> > Updates to the customer record work fine. I suspect there's an issue
> > with how I'm specifying the shipto record, but I can't figure out what
> > I'm doing wrong. I've specified the company, custnum, and shipto, as
> > well as the name and address fields. I have tried mapping data to
> > ShortChar01, I've set literals on it and nothing is working. I'm using
> > the CustomerService.Update method. Of course there are no error
> > messages.
> >
> > Any suggestions would be appreciated.
> >
> > Regards,
> >
> > Jim Pratt
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>