Hi, I am unable to browse through quotations with the below code - I get the following error (in the last line of code below): cannot use results from OQUT table with this object, however the exact same code using the BoObjectTypes.oOrders and using an ORDR selection works???
(I am using patch 29...)
SAPbobsCOM.IDocuments doc = (SAPbobsCOM.IDocuments)pCmp.GetBusinessObject(BoObjectTypes.oQuotations);
SAPbobsCOM.IDocument_Lines lines;
SAPbobsCOM.Recordset rs = (SAPbobsCOM.Recordset)pCmp.GetBusinessObject(BoObjectTypes.BoRecordset);
string quoteQuery = @"
select *
from OQUT
where DocEntry in (
select distinct DocEntry
from QUT1
where QUT1.LineStatus = 'O'
and QUT1.U_PriceUpd = 'Y'
and trgetEntry is null)
";
rs.DoQuery(quoteQuery);
doc.Browser.Recordset = rs;