Create Sales Order from EDI / Demand BPMs

Epicor ERP 10
1

We have EDI and a few customers want static Order Comments on all their EDI order yet they do not send said comments in their EDI. I need to make a BPM that appends the stock comments onto the comments that do come via EDI/Demand. These stock comments are stored in Customer.Comments (table/field).

I’ve tried Trace Logs but I can’t find the Methods I need to make this BPM. When I tried the very first section of the trace is post when the order was created:

<tracePacket>
  <businessObject>Erp.Proxy.BO.DemandEntryImpl</businessObject>
  <methodName>ProcessDemand</methodName>
  <appServerUri>net.tcp://hqse3001/ERP10.1-PreProd/</appServerUri>
  <returnType>System.Void</returnType>
  <localTime>8/31/2017 11:22:29:1681950 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="2213" roundTrip="2187" channel="0" bpm="0" other="26" />
  <retries>0</retries>
  <parameters>
    <parameter name="iDemandContractNum" type="System.Int32"><![CDATA[2]]></parameter>
    <parameter name="iDemandHeadSeq" type="System.Int32"><![CDATA[3287]]></parameter>
    <parameter name="cReturnMessage" type="System.String"><![CDATA[]]></parameter>
    <parameter name="cRejectFlag" 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="cReturnMessage" type="System.String"><![CDATA[Processing complete.  View the Demand Log for information on records that were bypassed or have warnings.]]></returnParameter>
    <returnParameter name="cRejectFlag" type="System.Boolean"><![CDATA[False]]></returnParameter>
  </returnValues>
  <serverTrace>
    <Op Utc="2017-08-31T16:22:29.1707718Z" act="Erp:BO:DemandEntry/DemandEntrySvcContract/ProcessDemand" dur="2180.2033" cli="172.20.7.102:60596" usr="rstulce" machine="HQSE3001" pid="10312" tid="75" xmlns="" />
  </serverTrace>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.DemandEntryImpl</businessObject>
  <methodName>GetByID</methodName>
  <appServerUri>net.tcp://hqse3001/ERP10.1-PreProd/</appServerUri>
  <returnType>Erp.Tablesets.DemandEntryTableset</returnType>
  <localTime>8/31/2017 11:22:31:3965504 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="76" roundTrip="68" channel="0" bpm="0" other="8" />
  <retries>0</retries>
  <parameters>
    <parameter name="demandContractNum" type="System.Int32"><![CDATA[2]]></parameter>
    <parameter name="demandHeadSeq" type="System.Int32"><![CDATA[3287]]></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.DemandEntryDataSet">
      <DemandEntryDataSet xmlns="http://www.epicor.com/Ice/300/BO/DemandEntry/DemandEntry">
        <DemandHead>
          <Company>SI</Company>
          <DemandContractNum>2</DemandContractNum>
          <DemandHeadSeq>3287</DemandHeadSeq>
          <OrderNum>10776</OrderNum>
          <CustNum>1157</CustNum>
          <PONum>4101454736</PONum>
          <FOB>EXW</FOB>
          <ShipViaCode>CUS</ShipViaCode>
          <TermsCode>N30</TermsCode>
          <AllocPriorityCode></AllocPriorityCode>
          <ReservePriorityCode>WALMAR</ReservePriorityCode>
          <ShipOrderComplete>false</ShipOrderComplete>
          <OrderComment> CONTACT: ROBERT DAVIS </OrderComment>
          <InvoiceComment></InvoiceComment>
          <AutoOrderBasedDisc>true</AutoOrderBasedDisc>
          <TestRecord>false</TestRecord>
          <POType>ORIGINAL</POType>
          <AcknowledgementType></AcknowledgementType>
          <AcceptType>ASD</AcceptType>
          <ScheduleNumber></ScheduleNumber>
          <ScheduleNumberSeq>1</ScheduleNumberSeq>
          <CurrencyCode>USD</CurrencyCode>
          <LockRate>false</LockRate>
          <Accepted>true</Accepted>
          <RejectedByUser>false</RejectedByUser>
          <OpenDemand>true</OpenDemand>
          <Posted>true</Posted>
          <RejectedBySystem>false</RejectedBySystem>
          <OverrideSystemReject>false</OverrideSystemReject>
          <DemandCharacter01></DemandCharacter01>
          <DemandCharacter02></DemandCharacter02>
          <DemandCharacter03></DemandCharacter03>
          <DemandCharacter04></DemandCharacter04>
          <DemandNumber01>0.00000000</DemandNumber01>
          <DemandNumber02>0.00000000</DemandNumber02>
          <DemandNumber03>0.00000000</DemandNumber03>
          <DemandNumber04>0.00000000</DemandNumber04>
          <DemandLogical01>false</DemandLogical01>
          <DemandLogical02>false</DemandLogical02>
          <DemandLogical03>false</DemandLogical03>
          <DemandLogical04>false</DemandLogical04>
          <BTCustNum>1157</BTCustNum>
          <EDIOrder>true</EDIOrder>
          <SelectedForProcessing>false</SelectedForProcessing>
          <SCProcessing>false</SCProcessing>
          <ShipToNum>000686</ShipToNum>
          <ReadyToProcess>true</ReadyToProcess>
          <ResetCums>false</ResetCums>
          <ERSOrder>false</ERSOrder>
          <CancelPO>false</CancelPO>
          <CreateNewOrder>false</CreateNewOrder>
          <LinkedOrders>10776</LinkedOrders>
          <TCtrlNum></TCtrlNum>
          <BatchNum>0002</BatchNum>
          <QuoteNum>0</QuoteNum>
          <DemandProcessTime>0</DemandProcessTime>
          <SysRevID>22850311</SysRevID>
          <SysRowID>086eb205-15cd-48a4-a22f-b4873b428845</SysRowID>
          <UserChar1></UserChar1>
          <UserChar2></UserChar2>
          <UserChar3></UserChar3>
          <UserChar4></UserChar4>
          <UserDecimal1>0.00</UserDecimal1>
          <UserDecimal2>0.00</UserDecimal2>
          <UserInteger1>0</UserInteger1>
          <UserInteger2>0</UserInteger2>
          <ShipByTime>0</ShipByTime>
          <OTSName></OTSName>
          <OTSAddress1></OTSAddress1>
          <OTSAddress2></OTSAddress2>
          <OTSAddress3></OTSAddress3>
          <OTSCity></OTSCity>
          <OTSState></OTSState>
          <OTSZIP></OTSZIP>
          <OTSResaleID></OTSResaleID>
          <OTSContact></OTSContact>
          <OTSFaxNum></OTSFaxNum>
          <OTSPhoneNum></OTSPhoneNum>
          <OTSCountryNum>0</OTSCountryNum>
          <OTSTaxRegionCode></OTSTaxRegionCode>
          <OTSCustSaved>false</OTSCustSaved>
          <OTSSaveAs></OTSSaveAs>
          <OTSSaveCustID></OTSSaveCustID>
          <OTSSaved>false</OTSSaved>
          <OTSShipToNum></OTSShipToNum>
          <UseOTS>false</UseOTS>
          <ShipToCustNum>1157</ShipToCustNum>
          <BaseCurrencyCode>USD</BaseCurrencyCode>
          <CurrencySwitch>true</CurrencySwitch>
          <EnableProcess>false</EnableProcess>
          <EnableReject>false</EnableReject>
          <EnableUnreject>false</EnableUnreject>
          <ERSOverride>false</ERSOverride>
          <OpenContract>true</OpenContract>
          <OrderHoldForReview>true</OrderHoldForReview>
          <OTSAllowed>true</OTSAllowed>
          <OTSCountryDescription></OTSCountryDescription>
          <OTSTaxRegionCodeDescription></OTSTaxRegionCodeDescription>
          <ReadOnly>false</ReadOnly>
          <ShipToAddressList>WAL-MART STORE # 686~120 BENJAMIN H HILL DR W~FITZGERALD GA 31750~USA</ShipToAddressList>
          <ShipToCustID>WX0000</ShipToCustID>
          <AvailBTCustList>WX0000`Same as Sold To</AvailBTCustList>
          <BillToCustomerName>Same as Sold To</BillToCustomerName>
          <BTAddressList>WAL-MART~2001 S.E. 10TH STREET~BENTONVILLE AR 72712-6489~USA</BTAddressList>
          <BTCustID>WX0000</BTCustID>
          <CustAddrList>WAL-MART~2001 S.E. 10TH STREET~BENTONVILLE AR 72712-6489~USA</CustAddrList>
          <CustNumAllowShipTo3>false</CustNumAllowShipTo3>
          <DemandContract>WALMART</DemandContract>
          <DemandSchedAvail>true</DemandSchedAvail>
          <EDI_OTSCountry></EDI_OTSCountry>
          <EDITran_Type></EDITran_Type>
          <EnableGetLines>true</EnableGetLines>
          <EnableLog>true</EnableLog>
          <BitFlag>0</BitFlag>
          <CurrencyCurrSymbol>USD</CurrencyCurrSymbol>
          <CurrencyCurrencyID>USD</CurrencyCurrencyID>
          <CurrencyCurrDesc>US Dollar</CurrencyCurrDesc>
          <CurrencyCurrName>USD</CurrencyCurrName>
          <CurrencyDocumentDesc></CurrencyDocumentDesc>
          <CustomerCustID>WX0000</CustomerCustID>
          <CustomerName>WAL-MART</CustomerName>
          <CustomerBTName>WAL-MART</CustomerBTName>
          <DemandContractHdrDemandContract>WALMART</DemandContractHdrDemandContract>
          <FOBDescription>EXW - Pick up at Factory</FOBDescription>
          <ReservePriDescription>Wal-mart Order</ReservePriDescription>
          <ShipViaCodeWebDesc></ShipViaCodeWebDesc>
          <ShipViaCodeDescription>Customer Pick-up</ShipViaCodeDescription>
          <TermsDescription>Net 30 Days</TermsDescription>
          <RowMod></RowMod>
          <UD_SysRevID>AAAAAAFZeJI=</UD_SysRevID>
          <Character01></Character01>
          <Character02></Character02>
          <Character03></Character03>
          <Character04></Character04>
          <Character05></Character05>
          <Character06></Character06>
          <Character07></Character07>
          <Character08></Character08>
          <Character09></Character09>
          <Character10></Character10>
          <CheckBox01>false</CheckBox01>
          <CheckBox02>false</CheckBox02>
          <CheckBox03>false</CheckBox03>
          <CheckBox04>false</CheckBox04>
          <CheckBox05>false</CheckBox05>
          <CheckBox06>false</CheckBox06>
          <CheckBox07>false</CheckBox07>
          <CheckBox08>false</CheckBox08>
          <CheckBox09>false</CheckBox09>
          <CheckBox10>false</CheckBox10>
          <CheckBox11>false</CheckBox11>
          <CheckBox12>false</CheckBox12>
          <CheckBox13>false</CheckBox13>
          <CheckBox14>false</CheckBox14>
          <CheckBox15>false</CheckBox15>
          <CheckBox16>false</CheckBox16>
          <CheckBox17>false</CheckBox17>
          <CheckBox18>false</CheckBox18>
          <CheckBox19>false</CheckBox19>
          <CheckBox20>false</CheckBox20>
          <Date01>2017-08-30T00:00:00-05:00</Date01>
          <Number01>0.00</Number01>
          <Number02>0.00</Number02>
          <Number03>0.00</Number03>
          <Number04>0.00</Number04>
          <Number05>0.00</Number05>
          <Number06>0.00</Number06>
          <Number07>0.00</Number07>
          <Number08>0.00</Number08>
          <Number09>0.00</Number09>
          <Number10>0.00</Number10>
          <Number11>0.00</Number11>
          <Number12>0.00</Number12>
          <Number13>0.00</Number13>
          <Number14>0.00</Number14>
          <Number15>0.00</Number15>
          <Number16>0.00</Number16>
          <Number17>0.00</Number17>
          <Number18>0.00</Number18>
          <Number19>0.00</Number19>
          <Number20>0.00</Number20>
          <ShortChar01></ShortChar01>
          <ShortChar02></ShortChar02>
          <ShortChar03></ShortChar03>
          <ShortChar04>ZNAN</ShortChar04>
          <ShortChar05>000999</ShortChar05>
          <ShortChar06>NOT SCOPED OR NOT REUSABLE</ShortChar06>
          <ShortChar07>W13</ShortChar07>
          <ShortChar08></ShortChar08>
          <ShortChar09></ShortChar09>
          <ShortChar10></ShortChar10>
        </DemandHead>
        <DemandDetail>
          <Company>SI</Company>
          <DemandContractNum>2</DemandContractNum>
          <DemandHeadSeq>3287</DemandHeadSeq>
          <DemandDtlSeq>1</DemandDtlSeq>
          <DemandContractLine>246</DemandContractLine>
          <TestRecord>false</TestRecord>
          <OrderNum>10776</OrderNum>
          <OrderLine>1</OrderLine>
          <DemandReference></DemandReference>
          <LineDesc>DISPLAY FORNT&amp;BACK TIREWALL 48IN D10 RS</LineDesc>
          <IUM>EA</IUM>
          <SalesUM>EA</SalesUM>
          <DiscountPercent>0.00</DiscountPercent>
          <UnitPrice>89.85000</UnitPrice>
          <PricePerCode>E</PricePerCode>
          <ProjectID></ProjectID>
          <PriceGroupCode></PriceGroupCode>
          <QuoteNum>0</QuoteNum>
          <QuoteLine>0</QuoteLine>
          <POType>ORIGINAL</POType>
          <AcknowledgementType></AcknowledgementType>
          <ScheduleType></ScheduleType>
          <CustNum>1157</CustNum>
          <PONum>4101454736</PONum>
          <RejectedByUser>false</RejectedByUser>
          <PartNum>100561155</PartNum>
          <XPartNum>100561155</XPartNum>
          <UsePriceList>false</UsePriceList>
          <Posted>true</Posted>
          <RejectedBySystem>false</RejectedBySystem>
          <OverrideSystemReject>false</OverrideSystemReject>
          <Plant>Rockford</Plant>
          <OpenLine>true</OpenLine>
          <POLine>00001</POLine>
          <DemandCharacter01></DemandCharacter01>
          <DemandCharacter02></DemandCharacter02>
          <DemandCharacter03></DemandCharacter03>
          <DemandCharacter04></DemandCharacter04>
          <DemandNumber01>0.00000000</DemandNumber01>
          <DemandNumber02>2.00000000</DemandNumber02>
          <DemandNumber03>0.00000000</DemandNumber03>
          <DemandNumber04>0.00000000</DemandNumber04>
          <DemandLogical01>false</DemandLogical01>
          <DemandLogical02>false</DemandLogical02>
          <DemandLogical03>false</DemandLogical03>
          <DemandLogical04>false</DemandLogical04>
          <DeleteCurrentReleases>false</DeleteCurrentReleases>
          <MktgCampaignID>EXISTCUS</MktgCampaignID>
          <MktgEvntSeq>1</MktgEvntSeq>
          <XRefPartNum>100561155</XRefPartNum>
          <XRefPartType>C</XRefPartType>
          <XRefCustNum>0</XRefCustNum>
          <RevisionNum>B</RevisionNum>
          <XRevisionNum></XRevisionNum>
          <EDIUnitPrice>89.85000</EDIUnitPrice>
          <CumulativeQty>0.00</CumulativeQty>
          <StartCumQty>0.00</StartCumQty>
          <LastShipmentID>0</LastShipmentID>
          <LastShipmentQty>0.00</LastShipmentQty>
          <ScheduleNumber></ScheduleNumber>
          <LastMasterPack>0</LastMasterPack>
          <DocUnitPrice>89.85000</DocUnitPrice>
          <DocEDIUnitPrice>89.85000</DocEDIUnitPrice>
          <InternalPrice>89.85000</InternalPrice>
          <DocInternalPrice>89.85000</DocInternalPrice>
          <SmartStringProcessed>false</SmartStringProcessed>
          <SmartString></SmartString>
          <BasePartNum></BasePartNum>
          <LastConfigTime>0</LastConfigTime>
          <LastConfigUserID></LastConfigUserID>
          <ConfigUnitPrice>0.00000</ConfigUnitPrice>
          <ConfigBaseUnitPrice>0.00000</ConfigBaseUnitPrice>
          <BaseRevisionNum>B</BaseRevisionNum>
          <TPQuoteNum>0</TPQuoteNum>
          <TPQuoteLine>0</TPQuoteLine>
          <GroupSeq>0</GroupSeq>
          <SysRevID>22850245</SysRevID>
          <SysRowID>07644b99-8c13-4f91-bbcd-f2cbd2c3717e</SysRowID>
          <Rpt1UnitPrice>0.00000</Rpt1UnitPrice>
          <Rpt2UnitPrice>0.00000</Rpt2UnitPrice>
          <Rpt3UnitPrice>0.00000</Rpt3UnitPrice>
          <Rpt1InternalPrice>0.00000</Rpt1InternalPrice>
          <Rpt2InternalPrice>0.00000</Rpt2InternalPrice>
          <Rpt3InternalPrice>0.00000</Rpt3InternalPrice>
          <Rpt1EDIUnitPrice>0.00000</Rpt1EDIUnitPrice>
          <Rpt2EDIUnitPrice>0.00000</Rpt2EDIUnitPrice>
          <Rpt3EDIUnitPrice>0.00000</Rpt3EDIUnitPrice>
          <BlockProcLine>false</BlockProcLine>
          <POLineRef></POLineRef>
          <PCLinkRemoved>false</PCLinkRemoved>
          <CUMMSetting>NONE</CUMMSetting>
          <CurrencyCode>USD</CurrencyCode>
          <CurrencySwitch>true</CurrencySwitch>
          <EnableCreateSchedule>true</EnableCreateSchedule>
          <EnableDeleteReleases>false</EnableDeleteReleases>
          <EnableDeleteSchedule>false</EnableDeleteSchedule>
          <EnableLog>true</EnableLog>
          <EnableOnlyPart>true</EnableOnlyPart>
          <EnableOverrideReject>false</EnableOverrideReject>
          <EnableReject>false</EnableReject>
          <EnableRevMatch>false</EnableRevMatch>
          <EnableUnreject>false</EnableUnreject>
          <MultipleXRef>false</MultipleXRef>
          <PriceDiscrepancy>false</PriceDiscrepancy>
          <ReadOnly>false</ReadOnly>
          <Configured></Configured>
          <BitFlag>0</BitFlag>
          <CustomerBTName>WAL-MART</CustomerBTName>
          <CustomerName>WAL-MART</CustomerName>
          <CustomerCustID>WX0000</CustomerCustID>
          <DemandContractDtlSalesUM>EA</DemandContractDtlSalesUM>
          <DemandContractHdrCUMMSetting>NONE</DemandContractHdrCUMMSetting>
          <DemandContractHdrDemandContract>WALMART</DemandContractHdrDemandContract>
          <MktgCampaignIDCampDescription>Existing Customer Campaign</MktgCampaignIDCampDescription>
          <MktgEvntEvntDescription>Existing Customer Campaign</MktgEvntEvntDescription>
          <PlantName>Rockford</PlantName>
          <PriceGroupDescription></PriceGroupDescription>
          <ProjectDescription></ProjectDescription>
          <RowMod></RowMod>
          <UD_SysRevID>AAAAAAFZeJY=</UD_SysRevID>
          <Character01></Character01>
          <Character02></Character02>
          <Character03></Character03>
          <Character04></Character04>
          <Character05></Character05>
          <Character06></Character06>
          <Character07></Character07>
          <Character08></Character08>
          <Character09></Character09>
          <Character10></Character10>
          <CheckBox01>false</CheckBox01>
          <CheckBox02>false</CheckBox02>
          <CheckBox03>false</CheckBox03>
          <CheckBox04>false</CheckBox04>
          <CheckBox05>false</CheckBox05>
          <CheckBox06>false</CheckBox06>
          <CheckBox07>false</CheckBox07>
          <CheckBox08>false</CheckBox08>
          <CheckBox09>false</CheckBox09>
          <CheckBox10>false</CheckBox10>
          <CheckBox11>false</CheckBox11>
          <CheckBox12>false</CheckBox12>
          <CheckBox13>false</CheckBox13>
          <CheckBox14>false</CheckBox14>
          <CheckBox15>false</CheckBox15>
          <CheckBox16>false</CheckBox16>
          <CheckBox17>false</CheckBox17>
          <CheckBox18>false</CheckBox18>
          <CheckBox19>false</CheckBox19>
          <CheckBox20>false</CheckBox20>
          <Number01>0.00</Number01>
          <Number02>0.00</Number02>
          <Number03>0.00</Number03>
          <Number04>0.00</Number04>
          <Number05>0.00</Number05>
          <Number06>0.00</Number06>
          <Number07>0.00</Number07>
          <Number08>0.00</Number08>
          <Number09>0.00</Number09>
          <Number10>0.00</Number10>
          <Number11>0.00</Number11>
          <Number12>0.00</Number12>
          <Number13>0.00</Number13>
          <Number14>0.00</Number14>
          <Number15>0.00</Number15>
          <Number16>0.00</Number16>
          <Number17>0.00</Number17>
          <Number18>0.00</Number18>
          <Number19>0.00</Number19>
          <Number20>0.00</Number20>
          <ShortChar01>EA</ShortChar01>
          <ShortChar02></ShortChar02>
          <ShortChar03></ShortChar03>
          <ShortChar04></ShortChar04>
          <ShortChar05></ShortChar05>
          <ShortChar06></ShortChar06>
          <ShortChar07></ShortChar07>
          <ShortChar08></ShortChar08>
          <ShortChar09></ShortChar09>
          <ShortChar10></ShortChar10>
        </DemandDetail>
      </DemandEntryDataSet>
    </returnParameter>
  </returnValues>
  <serverTrace>
    <Op Utc="2017-08-31T16:22:31.3894957Z" act="Erp:BO:DemandEntry/DemandEntrySvcContract/GetByID" dur="60.8326" cli="172.20.7.102:60596" usr="rstulce" machine="HQSE3001" pid="10312" tid="49" xmlns="" />
  </serverTrace>
</tracePacket>
2

Hey Randy (Its been a while since I saw you)…
Anyway, The easiest way for this may be to simply put a DATA BPM in, and trigger it when the ROWMOD = “A”… then you only add the comments when the new record is added. You don’t need to worry about what method actually does the creation.

3

Hey there Tim, glad to see you around these parts. :wink: Thanks for reminding me I never updated this with the solution we came up with.

We had a customer that wanted specific comments only if they ordered via EDI, they also use the same CustID to make non-EDI orders. So we put the EDI specific comments into the Demand Contract “comment” field and created this Data BPM using your suggest trigger.

image
image.png755×552 26.2 KB

1 Like
4

Do you use Tie Kinetix? on premise or hosted?

We have Tie on premise, so i am not sure about hosted, but another solution could be to add the static comments to the map for the customer?

Jose

5

Glad you were able to resolve it. Will you be at Insights 2018? if so … would be good to see you again… I just realized we first met over 12 years ago. seems like only yesterday. :grinning:

1 Like
6

I wish! No, we have another product… at least I don’t have to do the outside of Epicor EDI stuff. :wink:

@timshuwy, OMG 12 years?! No it doesn’t seem that long ago at all. I can’t make Insights this year. :frowning: