Add Column to Part Transaction History Tracker - V8.03

Yahoo Archive
9
You know how to write a BAQ I assume? Write a BAQ that looks at part tran and does the Job Employee Linkn
Give the BAQ a condition WHERE PartNum='MYPART' (hard code) then you can use this code to excecute the BAQ and replace 'MYPART' with whichever part you want
Dim dq As New Epicor.Mfg.BO.DynamicQuery(_session.ConnectionPool)
Dim qds As Epicor.Mfg.BO.QueryDesignDataSet = dq.GetByID("YourQuery")
Dim dqds As Epicor.Mfg.BO.DynamicQueryDataSet = New Epicor.Mfg.BO.DynamicQueryDataSet()
dqds.Merge(qds, True, MissingSchemaAction.Ignore)

dqds.QueryWhereItem(0).RValue = "Myval"

Dim ds AS DataSet = dq.Execute(dqds)


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Jun 16, 2016 at 8:30 AM, tracy.smith@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Thanks Jose.  Think that might be a bit beyond me... I appreciate the advice though.</p>

</div><span class="ygrps-yiv-1837702650">
 


<div style="color:#fff;min-height:0;"></div>