BPM :|: ChangePriceList

windowsmanager · December 6, 2019, 7:50pm

Can someone please help to understand how can I Invoke BO ChangePriceList. The issue is what when I change the BreakListCode field in the ttDetail table it will not force the re-calculation of the line. I have tried everything and it seems that when Erp:BO:SalesOrder/SalesOrderSvcContract/ChangePriceList runs the recalculation happens. Would someone please tell me how I can invoke it either with the “Invoke BO method” or call it with the CustomCode BPM widget.

Thanks

MAO

windowsmanager · December 6, 2019, 7:52pm

From the trace I can see this:

<paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="UnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocUnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="BreakListCode"><![CDATA[1036-30]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="ListPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocListPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="OrdBasedPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocOrdBasedPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="ExtPriceDtl"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocExtPriceDtl"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocDspUnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocTotalPrice"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="TotalPrice"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="UD_SysRevID"><![CDATA[System.Byte[]]]></changedValue>
    </paramDataSet>
  </paramDataSetChanges>
  <serverTrace>
    <Op Utc="2019-12-06T17:46:28.4174330Z" act="Erp:BO:SalesOrder/SalesOrderSvcContract/ChangePriceList" dur="1002.0233" cli="192.168.1.98:56341" usr="mtoloza" machine="PLSRV15" pid="776" tid="30" xmlns="">
      <Sql queries="92" cacheHits="35" time="909.038" qryTypeCount="54" />
    </Op>
  </serverTrace>
</tracePacket>

windowsmanager · December 6, 2019, 7:52pm

 </returnValues>
  <paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="UnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocUnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="BreakListCode"><![CDATA[1036-30]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="ListPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocListPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="OrdBasedPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocOrdBasedPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="ExtPriceDtl"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocExtPriceDtl"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocDspUnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocTotalPrice"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="TotalPrice"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="UD_SysRevID"><![CDATA[System.Byte[]]]></changedValue>
    </paramDataSet>
  </paramDataSetChanges>
  <serverTrace>
    <Op Utc="2019-12-06T17:46:28.4174330Z" act="Erp:BO:SalesOrder/SalesOrderSvcContract/ChangePriceList" dur="1002.0233" cli="192.168.1.98:56341" usr="mtoloza" machine="PLSRV15" pid="776" tid="30" xmlns="">
      <Sql queries="92" cacheHits="35" time="909.038" qryTypeCount="54" />
    </Op>
  </serverTrace>
</tracePacket>

windowsmanager · December 6, 2019, 7:54pm

 </returnValues>
  <paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="UnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocUnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="BreakListCode"><![CDATA[1036-30]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="ListPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocListPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="OrdBasedPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocOrdBasedPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="ExtPriceDtl"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocExtPriceDtl"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocDspUnitPrice"><![CDATA[12.37500]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="DocTotalPrice"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="TotalPrice"><![CDATA[618.75]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
      <changedValue tableName="OrderDtl" rowState="Modified" rowNum="0" colName="UD_SysRevID"><![CDATA[System.Byte[]]]></changedValue>
    </paramDataSet>
  </paramDataSetChanges>
  <serverTrace>
    <Op Utc="2019-12-06T17:46:28.4174330Z" act="Erp:BO:SalesOrder/SalesOrderSvcContract/ChangePriceList" dur="1002.0233" cli="192.168.1.98:56341" usr="mtoloza" machine="PLSRV15" pid="776" tid="30" xmlns="">
      <Sql queries="92" cacheHits="35" time="909.038" qryTypeCount="54" />
    </Op>
  </serverTrace>
</tracePacket>

hkeric.wci · December 6, 2019, 9:19pm

@josecgomez can you see any text on these posts?

josecgomez · December 6, 2019, 9:24pm

It was unformated XML (Fixed)