I would. Just adjust your “Ostring†to send Service Connect the additional value (see example). I am a bit of a control freak, so I like to pass as much as possible to SC as well as I think it is less expensive to do the searching with the ABL.
HEADER RECORD:
OString = "CompanyID,CustNum".
PUT UNFORMATTED Ostring SKIP(0).
CODE & DETAIL RECORDS:
FOR EACH ttCustomer WHERE (ttCustomer.Company = CUR-COMP) no-lock.
DO.
Ostring = trim(ttCustomer.Company) + "," + trim(string(ttCustomer.CustNum)) .
PUT UNFORMATTED Ostring SKIP(0).
END. END.
Brenda
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of wayne.welsch@...
Sent: Thursday, October 24, 2013 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] RE: BPM to Service Connect
First of all, thanks for the feedback - I have Service Connect picking up info from a BPM. Awesome!
In light of your suggestions that getting the BPM to pull the ProjectID from the OrderDtl table may be the better route to go, how do you accomplish that? ABL/4GL code?
---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:
absolutely
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
wayne.welsch@...
Sent: Wednesday, September 25, 2013 9:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BPM to Service Connect
Could a Customer Shipment BPM alert pull fields from the OrderDtl table? Bottom line, I need the shipment alert to include a ProjectID.
Thanks
---In vantage@yahoogroups.com, <brenda@...> wrote:
I use the BPM, to create a .csv file for the Service Connect Drop Folder. So essentially the BPM identifies the record to act on and service connect looks it up and acts on it. I use this basic template for a lot of different things:
DEF VAR Outfile AS CHAR format 'X(1000)' no-undo.
DEF VAR OString AS CHAR format 'X(1000)' no-undo.
Outfile = "\\humservcon\SCWork\ARInvTrans\Drop\InvApp.csv".
OUTPUT TO VALUE(Outfile).
OString = "Invoice".
PUT UNFORMATTED Ostring SKIP(0).
FOR EACH ttInvcHead WHERE (ttInvcHead.Company = CUR-COMP) no-lock.
IF AVAILABLE ttInvcHead THEN DO:
Ostring = trim(string(ttInvcHead.InvoiceNum,">>>>9")).
PUT UNFORMATTED Ostring SKIP(0).
END. END. /*** ttInvcHead ***/
Brenda
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Monday, September 23, 2013 8:09 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM to Service Connect
I definitely concur here, keep it simple.
But to answer your original question, the bpm sends a schema populated with data (specifically the request side) of the method invoked. Use the advanced button to export this schema then simply drop that into the scs\schemas\userschemas and you can assign them
from there in your conversion elements.
Sent from my Verizon Wireless 4G LTE DROID
Ted Koch <tkoch77@...<mailto:tkoch77@...>> wrote:
Why not use the BPM to send the email rather than service connect?
________________________________
From: "wayne.welsch@...<mailto:wayne.welsch@...>" <wayne.welsch@...<mailto:wayne.welsch@...>>
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Sent: Monday, September 23, 2013 4:16 PM
Subject: [Vantage] BPM to Service Connect
I am a new participant to this forum.
I am trying to program Service Connect to email an alert for customer shipments via a call from a BPM. So far I have been able to get Service Connect to send a simple "test alert" but have not been able to get it to retrieve information from the customer current
shipment record. How does Service Connect pick up records when it a workflow is called by a BPM? Thus far, my only experience is in feeding .xls files to Service Connect.
Epicor Version: Vista 8.03.409c
Service Connect Version: 9.05
[Non-text portions of this message have been removed]