Quote to order method

Epicor ERP 10
6

Some examples…

//Sets OrderDtl fields 
var OrderDtls = Db.OrderDtl.Where(o => o.Company == Session.CompanyID && o.OrderNum == orderNum).ToList();
if(OrderDtl != null)
{
  foreach( var OrderDtl in OrderDtls)
  {
    OrderDtl.field1Name = "value"; // or other reference
  }
}



//Sets SO detail fields from quoteDtls

var orderDtls = Db.OrderDtl.Where(o => o.Company == Session.CompanyID && o.OrderNum == orderNum).ToList();
if(orderDtls != null)
{
  foreach(var orderDtl in orderDtls)
  {
    var quoteDtl = Db.QuoteDtl.Where(qd => qd.Company == Session.CompanyID && qd.QuoteNum == orderDtl.QuoteNum  && qd.QuoteLine == orderDtl.QuoteLine).FirstOrDefault();  // this will pull all fields from quote detail you may want to limit this

    orderDtl.Fieldtoupdate = quoteDtl.fieldName;
  }
}
 

//Sets SO detail fields from quoteDtls (limited fields)

var orderDtls = Db.OrderDtl.Where(o => o.Company == Session.CompanyID && o.OrderNum == orderNum).ToList();
if(orderDtls != null)
{
  foreach( var orderDtl in orderDtls)
  {
    var quoteDtl = Db.QuoteDtl.Where(qd => qd.Company == Session.CompanyID && qd.QuoteNum == orderDtl.QuoteNum  && qd.QuoteLine == orderDtl.QuoteLine).Select(x => new{x.field1Name, x.field2Name}).FirstOrDefault();
   
    orderDtl.Field1toupdate = quoteDtl.field1Name;
    orderDtl.Field2toupdate = quoteDtl.field2Name;
  }
}

Also on Github