Issue/Return -- How to create a SelectedJobAsmbl table record for GetNewJobAsmblMultiple?

Kinetic ERP
1

Hey folks,

Trying to add a directive to an updatable query to issue materials. I’ve done a trace of the Material Issue process (below).

The method that gets the issue/return dataset for the job and assembly is IssueReturn.GetNewJobAsmblMultiple. One of the input parameters for said method is the dataset for SelectedJobAsmbl which is a list of job numbers (one in this case) and assemblies.

My problem is that I don’t see any way to create the record in this dataset/table. There is the tableset under IssueReturn, but I can’t find anything like a GetNewSelectedJobAsmbl method that would create the record.

Of course, it wouldn’t let me create a DataTable and pass it in.

Any ideas about how to create this record and stuff in the job number and assembly?

Thanks,

Joe

<tracePacket>
  <businessObject>Erp.Proxy.BO.JobEntryImpl</businessObject>
  <methodName>GetList</methodName>
  <appServerUri>https://elsppilotapp1.keystonesteel.com/Test/</appServerUri>
  <returnType>Erp.Tablesets.JobHeadListTableset</returnType>
  <localTime>3/10/2022 11:44:07:8486896 AM</localTime>
  <threadID>1</threadID>
  <correlationId>99862e06-302b-4a14-b0da-0cb0845c4b79</correlationId>
  <executionTime total="91" roundTrip="40" channel="2" bpm="0" bpmDataForm="0" other="49" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClause" type="System.String"><![CDATA[JobNum = '000004']]></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>
    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
      <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
        <BpmData>
          <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
        </BpmData>
      </ContextDataSet>
    </parameter>
  </parameters>
  <returnValues>
    <returnParameter name="returnDS" type="Erp.BO.JobHeadListDataSet">
      <JobHeadListDataSet xmlns="http://www.epicor.com/Ice/300/BO/JobEntry/JobHeadList">
        <JobHeadList>
          <Company>LSP</Company>
          <JobClosed>false</JobClosed>
          <JobComplete>false</JobComplete>
          <JobEngineered>true</JobEngineered>
          <JobReleased>true</JobReleased>
          <JobHeld>true</JobHeld>
          <JobNum>000004</JobNum>
          <PartNum>1008IQ</PartNum>
          <RevisionNum>A</RevisionNum>
          <DrawNum></DrawNum>
          <PartDescription>Grade 1008IQ</PartDescription>
          <ProdQty>80.00000000</ProdQty>
          <IUM>EA</IUM>
          <StartHour>0.00</StartHour>
          <DueHour>0.00</DueHour>
          <ReqDueDate>2022-03-10T00:00:00-06:00</ReqDueDate>
          <JobCode></JobCode>
          <QuoteNum>0</QuoteNum>
          <QuoteLine>0</QuoteLine>
          <ProdCode></ProdCode>
          <ExpenseCode></ExpenseCode>
          <InCopyList>false</InCopyList>
          <WIName></WIName>
          <WIStartHour>0.00</WIStartHour>
          <Candidate>false</Candidate>
          <SchedCode>NORMAL</SchedCode>
          <SchedLocked>false</SchedLocked>
          <ProjectID></ProjectID>
          <WIPCleared>false</WIPCleared>
          <JobFirm>true</JobFirm>
          <PersonList></PersonList>
          <PersonID></PersonID>
          <ProdTeamID></ProdTeamID>
          <QtyCompleted>2.00000000</QtyCompleted>
          <Plant>MfgSys</Plant>
          <TravelerReadyToPrint>false</TravelerReadyToPrint>
          <StatusReadyToPrint>false</StatusReadyToPrint>
          <CallNum>0</CallNum>
          <CallLine>0</CallLine>
          <JobType>MFG</JobType>
          <PhaseID></PhaseID>
          <AnalysisCode></AnalysisCode>
          <HDCaseNum>0</HDCaseNum>
          <EquipID></EquipID>
          <PlanNum>0</PlanNum>
          <IssueTopicID1></IssueTopicID1>
          <ExternalMES>false</ExternalMES>
          <SysRowID>2cf12939-a9e1-44c5-816a-2ac2b348e696</SysRowID>
          <SOExists>false</SOExists>
          <PartNumPartDescription>Grade 1008IQ</PartNumPartDescription>
          <PartNumTrackDimension>false</PartNumTrackDimension>
          <PartNumTrackLots>true</PartNumTrackLots>
          <PartNumTrackSerialNum>false</PartNumTrackSerialNum>
          <EquipOEM></EquipOEM>
          <EquipModel></EquipModel>
          <EquipTypeID></EquipTypeID>
          <EquipLocID></EquipLocID>
          <PMJob>false</PMJob>
          <EquipDescription></EquipDescription>
          <JobTypeName>Manufacturing</JobTypeName>
          <SmartString></SmartString>
          <SmartStringProcessed>false</SmartStringProcessed>
          <AttributeSetID>0</AttributeSetID>
          <AttrClassID></AttrClassID>
          <AttrDescription></AttrDescription>
          <ShortDescription></ShortDescription>
          <RowMod></RowMod>
        </JobHeadList>
      </JobHeadListDataSet>
    </returnParameter>
    <returnParameter name="morePages" type="System.Boolean"><![CDATA[False]]></returnParameter>
  </returnValues>
  <serverTrace>
    <Op Utc="2022-03-10T17:44:07.9003575Z" act="Erp:BO:JobEntry/JobEntrySvcContract/GetList" correlationId="99862e06-302b-4a14-b0da-0cb0845c4b79" dur="13.9693" cli="10.1.11.84:53765" usr="jtrent" machine="ELSPPILOTAPP1" pid="8732" tid="209" xmlns="" />
  </serverTrace>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.JobEntryImpl</businessObject>
  <methodName>GetList</methodName>
  <appServerUri>https://elsppilotapp1.keystonesteel.com/Test/</appServerUri>
  <returnType>Erp.Tablesets.JobHeadListTableset</returnType>
  <localTime>3/10/2022 11:44:07:9526901 AM</localTime>
  <threadID>1</threadID>
  <correlationId>2f093a84-026c-436e-aef8-456562aea781</correlationId>
  <executionTime total="24" roundTrip="20" channel="0" bpm="0" bpmDataForm="0" other="4" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClause" type="System.String"><![CDATA[JobNum = '000004']]></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>
    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
      <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
        <BpmData>
          <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
        </BpmData>
      </ContextDataSet>
    </parameter>
  </parameters>
  <returnValues>
    <returnParameter name="returnDS" type="Erp.BO.JobHeadListDataSet">
      <JobHeadListDataSet xmlns="http://www.epicor.com/Ice/300/BO/JobEntry/JobHeadList">
        <JobHeadList>
          <Company>LSP</Company>
          <JobClosed>false</JobClosed>
          <JobComplete>false</JobComplete>
          <JobEngineered>true</JobEngineered>
          <JobReleased>true</JobReleased>
          <JobHeld>true</JobHeld>
          <JobNum>000004</JobNum>
          <PartNum>1008IQ</PartNum>
          <RevisionNum>A</RevisionNum>
          <DrawNum></DrawNum>
          <PartDescription>Grade 1008IQ</PartDescription>
          <ProdQty>80.00000000</ProdQty>
          <IUM>EA</IUM>
          <StartHour>0.00</StartHour>
          <DueHour>0.00</DueHour>
          <ReqDueDate>2022-03-10T00:00:00-06:00</ReqDueDate>
          <JobCode></JobCode>
          <QuoteNum>0</QuoteNum>
          <QuoteLine>0</QuoteLine>
          <ProdCode></ProdCode>
          <ExpenseCode></ExpenseCode>
          <InCopyList>false</InCopyList>
          <WIName></WIName>
          <WIStartHour>0.00</WIStartHour>
          <Candidate>false</Candidate>
          <SchedCode>NORMAL</SchedCode>
          <SchedLocked>false</SchedLocked>
          <ProjectID></ProjectID>
          <WIPCleared>false</WIPCleared>
          <JobFirm>true</JobFirm>
          <PersonList></PersonList>
          <PersonID></PersonID>
          <ProdTeamID></ProdTeamID>
          <QtyCompleted>2.00000000</QtyCompleted>
          <Plant>MfgSys</Plant>
          <TravelerReadyToPrint>false</TravelerReadyToPrint>
          <StatusReadyToPrint>false</StatusReadyToPrint>
          <CallNum>0</CallNum>
          <CallLine>0</CallLine>
          <JobType>MFG</JobType>
          <PhaseID></PhaseID>
          <AnalysisCode></AnalysisCode>
          <HDCaseNum>0</HDCaseNum>
          <EquipID></EquipID>
          <PlanNum>0</PlanNum>
          <IssueTopicID1></IssueTopicID1>
          <ExternalMES>false</ExternalMES>
          <SysRowID>2cf12939-a9e1-44c5-816a-2ac2b348e696</SysRowID>
          <SOExists>false</SOExists>
          <PartNumPartDescription>Grade 1008IQ</PartNumPartDescription>
          <PartNumTrackDimension>false</PartNumTrackDimension>
          <PartNumTrackLots>true</PartNumTrackLots>
          <PartNumTrackSerialNum>false</PartNumTrackSerialNum>
          <EquipOEM></EquipOEM>
          <EquipModel></EquipModel>
          <EquipTypeID></EquipTypeID>
          <EquipLocID></EquipLocID>
          <PMJob>false</PMJob>
          <EquipDescription></EquipDescription>
          <JobTypeName>Manufacturing</JobTypeName>
          <SmartString></SmartString>
          <SmartStringProcessed>false</SmartStringProcessed>
          <AttributeSetID>0</AttributeSetID>
          <AttrClassID></AttrClassID>
          <AttrDescription></AttrDescription>
          <ShortDescription></ShortDescription>
          <RowMod></RowMod>
        </JobHeadList>
      </JobHeadListDataSet>
    </returnParameter>
    <returnParameter name="morePages" type="System.Boolean"><![CDATA[False]]></returnParameter>
  </returnValues>
  <serverTrace>
    <Op Utc="2022-03-10T17:44:07.9628311Z" act="Erp:BO:JobEntry/JobEntrySvcContract/GetList" correlationId="2f093a84-026c-436e-aef8-456562aea781" dur="12.9235" cli="10.1.11.84:53765" usr="jtrent" machine="ELSPPILOTAPP1" pid="8732" tid="246" xmlns="" />
  </serverTrace>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.IssueReturnImpl</businessObject>
  <methodName>GetNewJobAsmblMultiple</methodName>
  <appServerUri>https://elsppilotapp1.keystonesteel.com/Test/</appServerUri>
  <returnType>Erp.Tablesets.IssueReturnTableset</returnType>
  <localTime>3/10/2022 11:44:07:9786891 AM</localTime>
  <threadID>1</threadID>
  <correlationId>6a99d847-1a59-4fd8-89b8-23a758ac2b14</correlationId>
  <executionTime total="46" roundTrip="30" channel="0" bpm="0" bpmDataForm="0" other="16" />
  <retries>0</retries>
  <parameters>
    <parameter name="pcTranType" type="System.String"><![CDATA[STK-MTL]]></parameter>
    <parameter name="pcMtlQueueRowID" type="System.Guid"><![CDATA[00000000-0000-0000-0000-000000000000]]></parameter>
    <parameter name="pCallProcess" type="System.String"><![CDATA[IssueMaterial]]></parameter>
    **<parameter name="ds" type="Erp.BO.SelectedJobAsmblDataSet">**
**      <SelectedJobAsmblDataSet** xmlns="http://www.epicor.com/Ice/300/BO/IssueReturn/SelectedJobAsmbl">
        <SelectedJobAsmbl>
          <Company>LSP</Company>
          <JobNum>000004</JobNum>
          <AssemblySeq>0</AssemblySeq>
        </SelectedJobAsmbl>
      </SelectedJobAsmblDataSet>
    </parameter>
    <parameter name="pcMessage" type="System.String"><![CDATA[]]></parameter>
    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
      <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
        <BpmData>
          <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>

et cetera. . .
2

Try using GetNewIssueReturnToJob to populate your dataset after instantiating your new IssueReturn dataset. This would be if issuing to a single job, can’t say I have ever tried the method you mentioned above