I’m needing to implement a search button that will return the BinNum for a given part within a specific Warehouse. I’ve had made simple search buttons in the past for Parts using ListLookup, but I’m not having any success here.
I tried using PartBinSearchAdapter but get no results when searching (I’m assuming because the result set doesn’t include WarehouseCode or PartNum?). This seems like the correct Adapter to use, but I cannot get it to work. My code is:
string whereClause = "WarehouseCode='WAREHOUSE' and PartNum='PARTNUMBER'";
DataSet dsPartBinSearchAdapter = SearchFunctions.listLookup(this.oTrans, "PartBinSearchAdapter", out recSelected, true, whereClause);
I’ve also tried using the WhseBinAdapter which got me closer, but I cannot get an “IN” clause to work. I get a server error, but we are cloud based, so I’m not sure how to see that. Code is:
string whereClause = "WarehouseCode='WAREHOUSE' and BinNum in (Select BinNum from Erp.PartBin where PartNum='PARTNUM')";
DataSet dsWhseBinAdapter = SearchFunctions.listLookup(this.oTrans, "WhseBinAdapter", out recSelected, true, whereClause);
Suggestions?