Service Connect - Determining which row is being added

Yahoo Archive
1
Ahmed,

Worked like a charm. Thanks!

Kevin

--- In vantage@yahoogroups.com, Ahmed <servconnsup@...> wrote:
>
> Kevin,
> When calling GetNewInvcMisc method, just don't Map anything to the invcmisc record. The result will be a single row. You will then be able to manipulate the data prior to calling the final update update method.
>
> Happy Service Connecting!
> Ahmed
>
>
> Â
>
>
>
> ________________________________
> From: alfe_ksimon <alfe_ksimon@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, September 23, 2009 10:50:08 AM
> Subject: [Vantage] Re: Service Connect - Determining which row is being added
>
> Â
> Lorraine, the problem I have is in changing the data on the correct InvcMisc record. I'll give an example. Suppose I have an invoice with one line that already has one InvcMisc record. I pass to the workflow a document that has the invoice number and line number I want to add it to, but at the time, I don't know whether it's got any misc charges (or another app may apply them).
>
> In the workflow, I call GetByID to get the ARInvoiceDataSet. I pass that dataset into the call of GetNewInvcMisc. The resulting dataset for that includes the InvcHead data, InvcDtl data, etc. It also includes the InvcMisc data, which has my original misc charge prior to the application, plus a new InvcMisc record (SeqNum) = 2.
>
> The next step is to call the OnChangeOfMiscCode and the OnChangeOfMiscAmt services, passing the ARInvoiceDataSet along, and setting the parameters which include Company, InvoiceNum, InvoiceLine and SeqNum. I have the Company, InvoiceNum and InvoiceLine from the original document (passed from the channel info), but I don't know what the SeqNum is.
>
> The root of the problem is that when you get an entire dataset, you get all the data that is part of that dataset, not just the rows you want to deal with. So, if I were to set, for example, the escription, for example, InvcMisc.Descriptio n field by dragging something from the incoming channel, it affects every InvcMisc record in the dataset, not just the one that I'm adding.
>
> I must be missing a fairly key concept here.
>
> Thanks for your help.
>
> Kevin
>
> --- In vantage@yahoogroups .com, Lorraine Aiello <lorraine.aiello@ ...> wrote:
> >
> > I haven't worked with this particular service but I've struggled with Service Connect before.
> > What are you going to use the sequence number for?
> > I assume you're following this conversion with an Update conversion. That might be the place to get your sequence number from.
> >
> > Lorraine Aiello
> > Senior Programmer Analyst
> > Gloucester Engineering Co., Inc.
> > aiello.l@
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: alfe_ksimon <alfe_ksimon@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, September 22, 2009 2:40:49 PM
> > Subject: [Vantage] Service Connect - Determining which row is being added
> >
> > Â
> > I have a Service Connect workflow that is adding a miscellaneous charge to an invoice. After I call the GetNewInvcMisc service, it returns the entire ARInvoiceDataSet with my new miscellaneous charge included as one of the InvcMisc rows.
> >
> > Here's where my problem lies. In calling the GetNewInvcMisc service, I pass it the company, InvoiceNum, and InvoiceLine. However, the response doesn't give me the SeqNum of the InvcMisc row that it added. If the invoice line already has one or more miscellaneous charges, I don't necessarily know which sequence was added.
> >
> > I suppose within the dataset, I could search the RowMod on the InvcMisc data, but I'm not sure exactly how to do that.
> >
> > How has anyone else handled this?
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I have a Service Connect workflow that is adding a miscellaneous charge to an invoice. After I call the GetNewInvcMisc service, it returns the entire ARInvoiceDataSet with my new miscellaneous charge included as one of the InvcMisc rows.

Here's where my problem lies. In calling the GetNewInvcMisc service, I pass it the company, InvoiceNum, and InvoiceLine. However, the response doesn't give me the SeqNum of the InvcMisc row that it added. If the invoice line already has one or more miscellaneous charges, I don't necessarily know which sequence was added.

I suppose within the dataset, I could search the RowMod on the InvcMisc data, but I'm not sure exactly how to do that.

How has anyone else handled this?
3
I haven't worked with this particular service but I've struggled with Service Connect before.
What are you going to use the sequence number for?
I assume you're following this conversion with an Update conversion. That might be the place to get your sequence number from.

Lorraine Aiello
Senior Programmer Analyst
Gloucester Engineering Co., Inc.
aiello.l@...




________________________________
From: alfe_ksimon <alfe_ksimon@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 22, 2009 2:40:49 PM
Subject: [Vantage] Service Connect - Determining which row is being added

Â
I have a Service Connect workflow that is adding a miscellaneous charge to an invoice. After I call the GetNewInvcMisc service, it returns the entire ARInvoiceDataSet with my new miscellaneous charge included as one of the InvcMisc rows.

Here's where my problem lies. In calling the GetNewInvcMisc service, I pass it the company, InvoiceNum, and InvoiceLine. However, the response doesn't give me the SeqNum of the InvcMisc row that it added. If the invoice line already has one or more miscellaneous charges, I don't necessarily know which sequence was added.

I suppose within the dataset, I could search the RowMod on the InvcMisc data, but I'm not sure exactly how to do that.

How has anyone else handled this?







[Non-text portions of this message have been removed]
4
Lorraine, the problem I have is in changing the data on the correct InvcMisc record. I'll give an example. Suppose I have an invoice with one line that already has one InvcMisc record. I pass to the workflow a document that has the invoice number and line number I want to add it to, but at the time, I don't know whether it's got any misc charges (or another app may apply them).

In the workflow, I call GetByID to get the ARInvoiceDataSet. I pass that dataset into the call of GetNewInvcMisc. The resulting dataset for that includes the InvcHead data, InvcDtl data, etc. It also includes the InvcMisc data, which has my original misc charge prior to the application, plus a new InvcMisc record (SeqNum) = 2.

The next step is to call the OnChangeOfMiscCode and the OnChangeOfMiscAmt services, passing the ARInvoiceDataSet along, and setting the parameters which include Company, InvoiceNum, InvoiceLine and SeqNum. I have the Company, InvoiceNum and InvoiceLine from the original document (passed from the channel info), but I don't know what the SeqNum is.

The root of the problem is that when you get an entire dataset, you get all the data that is part of that dataset, not just the rows you want to deal with. So, if I were to set, for example, the escription, for example, InvcMisc.Description field by dragging something from the incoming channel, it affects every InvcMisc record in the dataset, not just the one that I'm adding.

I must be missing a fairly key concept here.

Thanks for your help.

Kevin


--- In vantage@yahoogroups.com, Lorraine Aiello <lorraine.aiello@...> wrote:
>
> I haven't worked with this particular service but I've struggled with Service Connect before.
> What are you going to use the sequence number for?
> I assume you're following this conversion with an Update conversion. That might be the place to get your sequence number from.
>
> Lorraine Aiello
> Senior Programmer Analyst
> Gloucester Engineering Co., Inc.
> aiello.l@...
>
>
>
>
> ________________________________
> From: alfe_ksimon <alfe_ksimon@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, September 22, 2009 2:40:49 PM
> Subject: [Vantage] Service Connect - Determining which row is being added
>
> Â
> I have a Service Connect workflow that is adding a miscellaneous charge to an invoice. After I call the GetNewInvcMisc service, it returns the entire ARInvoiceDataSet with my new miscellaneous charge included as one of the InvcMisc rows.
>
> Here's where my problem lies. In calling the GetNewInvcMisc service, I pass it the company, InvoiceNum, and InvoiceLine. However, the response doesn't give me the SeqNum of the InvcMisc row that it added. If the invoice line already has one or more miscellaneous charges, I don't necessarily know which sequence was added.
>
> I suppose within the dataset, I could search the RowMod on the InvcMisc data, but I'm not sure exactly how to do that.
>
> How has anyone else handled this?
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Kevin,

Have you ever heard of WS-Tester.exe? Epicor Support turned me on to it. On my server, it's located at C:\Program Files (x86)\Epicor Software\WS-Tester (.Net 2.0 Edition). This allows you to test your method. You key in your access values and it will return the result set. Perhaps that would help you find your sequence number.

Also, I've seen some inelegant games played in some sample workflows that use what they call an "init" conversion. All it does is read in the record and put it out to the user area. You might be able to add this in and get at your sequence number this way.

My ideas are just stabs in the dark, really. I can't say I've ever run into this problem.

Lorraine




________________________________
From: alfe_ksimon <alfe_ksimon@...>
To: vantage@yahoogroups.com
Sent: Wednesday, September 23, 2009 1:50:08 PM
Subject: [Vantage] Re: Service Connect - Determining which row is being added

Â
Lorraine, the problem I have is in changing the data on the correct InvcMisc record. I'll give an example. Suppose I have an invoice with one line that already has one InvcMisc record. I pass to the workflow a document that has the invoice number and line number I want to add it to, but at the time, I don't know whether it's got any misc charges (or another app may apply them).

In the workflow, I call GetByID to get the ARInvoiceDataSet. I pass that dataset into the call of GetNewInvcMisc.. The resulting dataset for that includes the InvcHead data, InvcDtl data, etc. It also includes the InvcMisc data, which has my original misc charge prior to the application, plus a new InvcMisc record (SeqNum) = 2.

The next step is to call the OnChangeOfMiscCode and the OnChangeOfMiscAmt services, passing the ARInvoiceDataSet along, and setting the parameters which include Company, InvoiceNum, InvoiceLine and SeqNum. I have the Company, InvoiceNum and InvoiceLine from the original document (passed from the channel info), but I don't know what the SeqNum is.

The root of the problem is that when you get an entire dataset, you get all the data that is part of that dataset, not just the rows you want to deal with. So, if I were to set, for example, the escription, for example, InvcMisc.Descriptio n field by dragging something from the incoming channel, it affects every InvcMisc record in the dataset, not just the one that I'm adding.

I must be missing a fairly key concept here.

Thanks for your help.

Kevin

--- In vantage@yahoogroups .com, Lorraine Aiello <lorraine.aiello@ ....> wrote:
>
> I haven't worked with this particular service but I've struggled with Service Connect before.
> What are you going to use the sequence number for?
> I assume you're following this conversion with an Update conversion. That might be the place to get your sequence number from.
>
> Lorraine Aiello
> Senior Programmer Analyst
> Gloucester Engineering Co., Inc.
> aiello.l@...
>
>
>
>
> ____________ _________ _________ __
> From: alfe_ksimon <alfe_ksimon@ ...>
> To: vantage@yahoogroups .com
> Sent: Tuesday, September 22, 2009 2:40:49 PM
> Subject: [Vantage] Service Connect - Determining which row is being added
>
> Â
> I have a Service Connect workflow that is adding a miscellaneous charge to an invoice. After I call the GetNewInvcMisc service, it returns the entire ARInvoiceDataSet with my new miscellaneous charge included as one of the InvcMisc rows.
>
> Here's where my problem lies. In calling the GetNewInvcMisc service, I pass it the company, InvoiceNum, and InvoiceLine. However, the response doesn't give me the SeqNum of the InvcMisc row that it added. If the invoice line already has one or more miscellaneous charges, I don't necessarily know which sequence was added.
>
> I suppose within the dataset, I could search the RowMod on the InvcMisc data, but I'm not sure exactly how to do that.
>
> How has anyone else handled this?
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
6
Kevin,
When calling GetNewInvcMisc method, just don't Map anything to the invcmisc record. The result will be a single row. You will then be able to manipulate the data prior to calling the final update update method.

Happy Service Connecting!
Ahmed


Â



________________________________
From: alfe_ksimon <alfe_ksimon@...>
To: vantage@yahoogroups.com
Sent: Wednesday, September 23, 2009 10:50:08 AM
Subject: [Vantage] Re: Service Connect - Determining which row is being added

Â
Lorraine, the problem I have is in changing the data on the correct InvcMisc record. I'll give an example. Suppose I have an invoice with one line that already has one InvcMisc record. I pass to the workflow a document that has the invoice number and line number I want to add it to, but at the time, I don't know whether it's got any misc charges (or another app may apply them).

In the workflow, I call GetByID to get the ARInvoiceDataSet. I pass that dataset into the call of GetNewInvcMisc. The resulting dataset for that includes the InvcHead data, InvcDtl data, etc. It also includes the InvcMisc data, which has my original misc charge prior to the application, plus a new InvcMisc record (SeqNum) = 2.

The next step is to call the OnChangeOfMiscCode and the OnChangeOfMiscAmt services, passing the ARInvoiceDataSet along, and setting the parameters which include Company, InvoiceNum, InvoiceLine and SeqNum. I have the Company, InvoiceNum and InvoiceLine from the original document (passed from the channel info), but I don't know what the SeqNum is.

The root of the problem is that when you get an entire dataset, you get all the data that is part of that dataset, not just the rows you want to deal with. So, if I were to set, for example, the escription, for example, InvcMisc.Descriptio n field by dragging something from the incoming channel, it affects every InvcMisc record in the dataset, not just the one that I'm adding.

I must be missing a fairly key concept here.

Thanks for your help.

Kevin

--- In vantage@yahoogroups .com, Lorraine Aiello <lorraine.aiello@ ...> wrote:
>
> I haven't worked with this particular service but I've struggled with Service Connect before.
> What are you going to use the sequence number for?
> I assume you're following this conversion with an Update conversion. That might be the place to get your sequence number from.
>
> Lorraine Aiello
> Senior Programmer Analyst
> Gloucester Engineering Co., Inc.
> aiello.l@...
>
>
>
>
> ____________ _________ _________ __
> From: alfe_ksimon <alfe_ksimon@ ...>
> To: vantage@yahoogroups .com
> Sent: Tuesday, September 22, 2009 2:40:49 PM
> Subject: [Vantage] Service Connect - Determining which row is being added
>
> Â
> I have a Service Connect workflow that is adding a miscellaneous charge to an invoice. After I call the GetNewInvcMisc service, it returns the entire ARInvoiceDataSet with my new miscellaneous charge included as one of the InvcMisc rows.
>
> Here's where my problem lies. In calling the GetNewInvcMisc service, I pass it the company, InvoiceNum, and InvoiceLine. However, the response doesn't give me the SeqNum of the InvcMisc row that it added. If the invoice line already has one or more miscellaneous charges, I don't necessarily know which sequence was added.
>
> I suppose within the dataset, I could search the RowMod on the InvcMisc data, but I'm not sure exactly how to do that.
>
> How has anyone else handled this?
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







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