Part Cost in SO Entry

Presuming you can get the part number from a data view, use the SearchFunctions.ListLookup

Code you will need:
Dim recordSelected As Boolean
Dim showSearch As Boolean = False

Dim whereClause As String = "partNum = '" & <your data view field containing part number here> & "' And costID = '1'"

Dim dsCost As DataSet = SearchFunctions.listLookup(SalesOrderForm, "PartCostSearchAdapter", recordSelected, showSearch, whereClause)

If recordSelected Then
<assign values to your controls>
txtMyStdCost.Text = dsCost.Tables(0).Rows(0)("StdMaterialCost")
End If


--- In vantage@yahoogroups.com, "jgiese1988" <jgiese@...> wrote:
>
> Need to bring in the current std material cost and std burden cost for a finished goods part into SO Entry. Not sure where to even start. I'm assuming I will need to create the code for the PartCostSearch adapter? I have my two fields added to the form already. Need some guidance :S
>
Need to bring in the current std material cost and std burden cost for a finished goods part into SO Entry. Not sure where to even start. I'm assuming I will need to create the code for the PartCostSearch adapter? I have my two fields added to the form already. Need some guidance :S