How to launch Revenue Recognition process from dashboard with multiple projects?

Kinetic ERP
, , , , ,
5

Here is the trace from that:

<tracePacket>
  <businessObject>Ice.Proxy.BO.NamedSearchImpl</businessObject>
  <methodName>GetRows</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>Ice.Tablesets.NamedSearchTableset</returnType>
  <localTime>6/14/2022 13:29:52:9894215 PM</localTime>
  <threadID>1</threadID>
  <correlationId>3c3b449b-c5cf-45a3-8670-0e6a9f1d7b92</correlationId>
  <executionTime total="7" roundTrip="6" channel="0" bpm="0" bpmDataForm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClauseNamedSearch" type="System.String"><![CDATA[ProductID = 'EP' AND SearchForm = 'Project Search' AND CalledFrom = 'Erp.UIProc.CaptureRevenueCOS.dll' AND UserId = 'mmorgan']]></parameter>
    <parameter name="whereClauseControlSetting" type="System.String"><![CDATA[]]></parameter>
    <parameter name="whereClauseWhereClause" type="System.String"><![CDATA[]]></parameter>
    <parameter name="pageSize" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="absolutePage" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="morePages" type="System.Boolean"><![CDATA[False]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.QuickSearchImpl</businessObject>
  <methodName>GetBaseDefault</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>System.Void</returnType>
  <localTime>6/14/2022 13:29:53:0054277 PM</localTime>
  <threadID>1</threadID>
  <correlationId>17cd8de5-5101-4183-ab28-93d712185556</correlationId>
  <executionTime total="15" roundTrip="14" channel="0" bpm="0" bpmDataForm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="likeTableAndField" type="System.String"><![CDATA[Project.ProjectID]]></parameter>
    <parameter name="callFrom" type="System.String"><![CDATA[Erp.UIProc.CaptureRevenueCOS]]></parameter>
    <parameter name="baseSearchId" type="System.String"><![CDATA[]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.QuickSearchImpl</businessObject>
  <methodName>GetByID</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>Ice.Tablesets.QuickSearchTableset</returnType>
  <localTime>6/14/2022 13:29:53:0334238 PM</localTime>
  <threadID>1</threadID>
  <correlationId>51f43284-bd71-4c70-86b3-14057ad58931</correlationId>
  <executionTime total="14" roundTrip="13" channel="0" bpm="0" bpmDataForm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="glbCompany" type="System.String"><![CDATA[]]></parameter>
    <parameter name="quickSearchID" type="System.String"><![CDATA[DCS-Project]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.NamedSearchImpl</businessObject>
  <methodName>GetRows</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>Ice.Tablesets.NamedSearchTableset</returnType>
  <localTime>6/14/2022 13:29:53:1084388 PM</localTime>
  <threadID>1</threadID>
  <correlationId>953b4f10-f942-4c36-86d9-a2bf8051ccc9</correlationId>
  <executionTime total="7" roundTrip="6" channel="0" bpm="0" bpmDataForm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClauseNamedSearch" type="System.String"><![CDATA[ProductID = 'EP' AND SearchForm = 'Search Form' AND CalledFrom = 'Erp.UIProc.CaptureRevenueCOS.dll' AND UserId = 'mmorgan']]></parameter>
    <parameter name="whereClauseControlSetting" type="System.String"><![CDATA[]]></parameter>
    <parameter name="whereClauseWhereClause" type="System.String"><![CDATA[]]></parameter>
    <parameter name="pageSize" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="absolutePage" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="morePages" type="System.Boolean"><![CDATA[False]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.DynamicQueryImpl</businessObject>
  <methodName>GetByID</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>Ice.Tablesets.DynamicQueryTableset</returnType>
  <localTime>6/14/2022 13:29:54:5205121 PM</localTime>
  <threadID>1</threadID>
  <correlationId>ab667c72-87b1-459f-9edf-ce9eb550e93b</correlationId>
  <executionTime total="14" roundTrip="11" channel="0" bpm="0" bpmDataForm="0" other="3" />
  <retries>0</retries>
  <parameters>
    <parameter name="queryID" type="System.String"><![CDATA[DCS-ProjectQS]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.DynamicQueryImpl</businessObject>
  <methodName>GetQueryEmptyResultSet</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>System.Data.DataSet</returnType>
  <localTime>6/14/2022 13:29:54:5375159 PM</localTime>
  <threadID>1</threadID>
  <correlationId>66d126d6-c9eb-4dcd-b67c-17accbe1cbd2</correlationId>
  <executionTime total="19" roundTrip="13" channel="0" bpm="0" bpmDataForm="0" other="6" />
  <retries>0</retries>
  <parameters>
    <parameter name="queryDS" type="Ice.BO.DynamicQueryDataSet">
      <DynamicQueryDataSet xmlns="http://www.epicor.com/Ice/300/BO/DynamicQuery/DynamicQuery" />
    </parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.QuickSearchImpl</businessObject>
  <methodName>RunQuickSearchPaged</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>System.Data.DataSet</returnType>
  <localTime>6/14/2022 13:29:54:5685106 PM</localTime>
  <threadID>1</threadID>
  <correlationId>cc84652d-fafe-4558-9c13-3726b352cfd3</correlationId>
  <executionTime total="31" roundTrip="28" channel="0" bpm="0" bpmDataForm="0" other="3" />
  <retries>0</retries>
  <parameters>
    <parameter name="ds" type="Ice.BO.QuickSearchDataSet">
      <QuickSearchDataSet xmlns="http://www.epicor.com/Ice/300/BO/QuickSearch/QuickSearch" />
    </parameter>
    <parameter name="pageSize" type="System.Int32"><![CDATA[100]]></parameter>
    <parameter name="morePages" type="System.Boolean"><![CDATA[False]]></parameter>
  </parameters>
  <paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <deletedRow tableName="QuickSearchValueList" rowState="Deleted" rowNum="2" />
      <deletedRow tableName="QuickSearchValueList" rowState="Deleted" rowNum="3" />
      <deletedRow tableName="QuickSearchValueList" rowState="Deleted" rowNum="4" />
      <deletedRow tableName="QuickSearchValueList" rowState="Deleted" rowNum="5" />
    </paramDataSet>
  </paramDataSetChanges>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.ProjectImpl</businessObject>
  <methodName>GetList</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>Erp.Tablesets.ProjectListTableset</returnType>
  <localTime>6/14/2022 13:30:01:8739216 PM</localTime>
  <threadID>1</threadID>
  <correlationId>0c172071-2627-4a72-803f-26f9dcb1d280</correlationId>
  <executionTime total="10" roundTrip="8" channel="0" bpm="0" bpmDataForm="0" other="2" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClause" type="System.String"><![CDATA[(ProjectID = '400740' OR ProjectID = '400741') BY ProjectID]]></parameter>
    <parameter name="pageSize" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="absolutePage" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="morePages" type="System.Boolean"><![CDATA[False]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.BO.ReportMonitorImpl</businessObject>
  <methodName>GetRowsKeepIdleTimeWithBallonInfo</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>Ice.Tablesets.ReportMonitorTableset</returnType>
  <localTime>6/14/2022 13:30:07:5432433 PM</localTime>
  <threadID>18</threadID>
  <correlationId>02771975-47ab-4a57-9689-95f30d3ab0cc</correlationId>
  <executionTime total="8" roundTrip="6" channel="0" bpm="0" bpmDataForm="0" other="2" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClauseSysRptLst" type="System.String"><![CDATA[((PrintDriver='TEXT' AND (AutoAction='PRINT' OR AutoAction='PREVIEW')) OR (PrintDriver='CRYSTAL' AND (AutoAction='PRINT' OR AutoAction='AUTOPRT' OR AutoAction='PREVIEW' OR AutoAction='AUTOPRV' OR AutoAction='SSRSPREVIEW')) OR (PrintDriver='EPIFIN' AND (AutoAction='PRINT' OR AutoAction='PREVIEW')) OR (PrintDriver='BARTENDER' AND (AutoAction='AUTOPRT' OR AutoAction='AUTOPRV')) OR (PrintDriver='EDI' AND AutoAction<>'') OR (PrintDriver='SSRS' AND (AutoAction='PREVIEW' OR AutoAction='PRINT') AND LastAction='SSRSREADY')) AND (WorkStationID='TERMSRV 188' OR WorkStationID='web_mmorgan')]]></parameter>
    <parameter name="getBallonInfo" type="System.Boolean"><![CDATA[False]]></parameter>
    <parameter name="whereClauseSysTask" type="System.String"><![CDATA[history = true and startedon > 06/13/2022 and  SubmitUser = 'mmorgan']]></parameter>
    <parameter name="whereClauseSysTaskLog" type="System.String"><![CDATA[]]></parameter>
    <parameter name="sysMonitorData" type="System.Data.DataSet">
      <NewDataSet />
    </parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.Proc.CaptureRevenueCOSImpl</businessObject>
  <methodName>SubmitToAgent</methodName>
  <appServerUri>net.tcp://app1/Test/</appServerUri>
  <returnType>System.Void</returnType>
  <localTime>6/14/2022 13:30:17:3777874 PM</localTime>
  <threadID>1</threadID>
  <correlationId>47f4464e-4677-49ba-a295-e61b4e408f6b</correlationId>
  <executionTime total="245" roundTrip="225" channel="0" bpm="0" bpmDataForm="0" other="20" />
  <retries>0</retries>
  <parameters>
    <parameter name="ds" type="Erp.Proc.CaptureRevenueCOSDataSet">
      <CaptureRevenueCOSDataSet xmlns="http://www.epicor.com/Ice/300/Proc/CaptureRevenueCOS/CaptureRevenueCOS" />
    </parameter>
    <parameter name="agentID" type="System.String"><![CDATA[SystemAgent]]></parameter>
    <parameter name="agentSchedNum" type="System.Int64"><![CDATA[0]]></parameter>
    <parameter name="agentTaskNum" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="maintProgram" type="System.String"><![CDATA[Erp.UIProc.CaptureRevenueCOS]]></parameter>
  </parameters>
  <paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ACTType"><![CDATA[Revenue_Recognition]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AsOfDate"><![CDATA[6/14/2022 12:00:00 AM]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="CalledFrom"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="IsCaptureOT"><![CDATA[False]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="PrjList"><![CDATA[400740~400741]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="RecType"><![CDATA[ALL]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="StartingDate"><![CDATA[6/6/2022 12:00:00 AM]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="COSandWIPCall"><![CDATA[True]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="SysRowID"><![CDATA[00000000-0000-0000-0000-000000000000]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AutoAction"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="PrinterName"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AgentSchedNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AgentID"><![CDATA[SystemAgent]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AgentTaskNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="RecurringTask"><![CDATA[False]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="RptPageSettings"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="RptPrinterSettings"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="RptVersion"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ReportStyleNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="WorkstationID"><![CDATA[TERMSRV 188]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="TaskNote"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ArchiveCode"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="DateFormat"><![CDATA[m/d/yyyy]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="NumericFormat"><![CDATA[,.]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AgentCompareString"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ProcessID"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ProcessCompany"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ProcessSystemCode"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ProcessTaskNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="DecimalsGeneral"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="DecimalsCost"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="DecimalsPrice"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="GlbDecimalsGeneral"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="GlbDecimalsCost"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="GlbDecimalsPrice"><![CDATA[0]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="FaxSubject"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="FaxTo"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="FaxNumber"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="EMailTo"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="EMailCC"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="EMailBCC"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="EMailBody"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="AttachmentType"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ReportCurrencyCode"><![CDATA[USD]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="ReportCultureCode"><![CDATA[en-US]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="SSRSRenderFormat"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="UIXml"><![CDATA[]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="PrintReportParameters"><![CDATA[False]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="SSRSEnableRouting"><![CDATA[False]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="DesignMode"><![CDATA[False]]></changedValue>
      <changedValue tableName="CaptureRevenueCOS" rowState="Added" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
    </paramDataSet>
  </paramDataSetChanges>
</tracePacket>

What stands out to me are: the “whereClause” in the ProjectImp.GetList method (indicating the two projects I selected), and in the CaptureRevenueCOSImpl.SubmitToAgent method at the end, seeing the “PrjList” data column ([CDATA[400740~400741]]).

This makes me wonder: do I even need to call up the capture dialog at all from my customization - is it possible to code it such that the projects are passed directly to the SubmitToAgent method within?