Hello guys, I created a code to delete a Quote Line by a BPM but got the below error, has anyone had this error before?
Thanks
Hello guys, I created a code to delete a Quote Line by a BPM but got the below error, has anyone had this error before?
Thanks
You have to select linked table as well.
QuoteDtl, QuoteCoPart, QuoteQty, Qtmmkup
int deletedLine = 2;
using(Erp.Contracts.QuoteSvcContract quoteService = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.QuoteSvcContract>(Db))
{
QuoteTableset quoteDataSet = quoteService.GetByID(1084);
if(quoteDataSet != null)
{
var quoteHead = quoteDataSet.QuoteHed.Where(QL => !QL.Quoted).FirstOrDefault();
if(quoteHead != null)
{
foreach(var quoteDtl in quoteDataSet.QuoteDtl.Where(QD => QD.QuoteLine == deletedLine))
{
quoteDtl.RowMod = "D";
}
foreach(var quoteCoPart in quoteDataSet.QuoteCoPart.Where(QCP => QCP.QuoteLine == deletedLine))
{
quoteCoPart.RowMod = "D";
}
foreach(var quoteQty in quoteDataSet.QuoteQty.Where(QQ => QQ.QuoteLine == deletedLine))
{
quoteQty.RowMod = "D";
}
foreach(var qtmmkup in quoteDataSet.Qtmmkup.Where(QU => QU.QuoteLine == deletedLine))
{
qtmmkup.RowMod = "D";
}
quoteService.Update(ref quoteDataSet);
}
}
}