I am trying to get a Part custom field into a customization and haven’t seen exactly how. The field is bool (Serialized_c). I did see some discussion on it using BOReader and I can get it to work either.
Ilearned the ListLookup can’t include the UD fields.
Here is my code that doesn’t work.
Ice.Core.Session ssn;
ssn = oTrans.Session as Ice.Core.Session;
string sPart = QJ_Row.dataView[QJ_Row.Row]["PartNum"].ToString();
// Define a variable that will easily let us know if any results were found
bool recSelected = false;
// Define the whare clause for the lookup. Whatever would work in a standard
// SQL where clause will work here.
string whereClause = "PartNum = '" + sPart + "' and Company = '" + ssn.CompanyID + "'";
// Here is where we actually call listLookup. The only thing you need to
// ever change here is where we have "PartAdapter".
DataSet dsPart = SearchFunctions.listLookup(
oTrans,
"PartAdapter",
out recSelected,
false,
whereClause
);
if (recSelected) {
// dsPart will be filled here and you can loop through the rows in
//dsPart.Tables[0].Rows
if (dsPart.Tables[0].Rows.Count > 0)
{
if (Convert.ToBoolean(dsPart.Tables[0].Rows[0]["Serialized_c"]) == true )
{
MessageBox.Show("Serialized Test");
}
}
}
Where are you trying to show the Part UD field? If it is on Part then you can just add it and Epicor does all of the rest. If it is on another table I would also add it there and then when the part is added to that data then post processing get the field. These are both simple to do and will carry forward in the new UX.
I’m customizing the handheld Job Entry and don’t need to show the field just use it to validate if the checkbox is true and the quantity is more than one display an error message. I just can’t seen to look the field up.