Create AP invoice From UD Table

Epicor ERP 10
1

Dear Team,

While creating AP invoice line details from UD table i am getting below error , Kindly inform how to resolve .

error
error.JPG1006×428 111 KB

Source Code

foreach (var ud12_iterator in (from ud12_Row in Db.UD12
where ud12_Row.Company == Session.CompanyID
select ud12_Row))
{
ud12 = ud12_iterator;
Erp.Contracts.APInvoiceSvcContract bo_ApInvDt = null;
bo_ApInvDt = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.APInvoiceSvcContract>(Db);
var bo_ApInvDtds = new Erp.Tablesets.APInvoiceTableset();
if (bo_ApInvDt != null)
{
bo_ApInvDt.GetByID(VendorNum, APInvoiceNum );
bo_ApInvDt.GetNewAPInvDtlMiscellaneous(ref bo_ApInvDtds, VendorNum, APInvoiceNum);
bo_ApInvDt.ChangePartNum(ud12.ShortChar11 , ref bo_ApInvDtds);
bo_ApInvDt.ChangeVendorQty(1, ref bo_ApInvDtds);
bo_ApInvDt.ChangeUnitCost(uCost, ref bo_ApInvDtds);

					var ttAPInvHed_xRow = (from ttAPInvHed_Row in Db.APInvHed
					where ttAPInvHed_Row.InvoiceNum == APInvoiceNum
					select ttAPInvHed_Row).FirstOrDefault();
					
					if (ttAPInvHed_xRow != null)
					{
						var ttAPInvDtl_xRow = (from ttAPInvDtl_xRow1 in bo_ApInvDtds.APInvDtl where ttAPInvDtl_xRow1.RowMod == "A" select ttAPInvDtl_xRow1).FirstOrDefault(); 
						if (ttAPInvDtl_xRow != null)
						{
							ttAPInvDtl_xRow.Description =  ud12.ShortChar17; 
							ttAPInvDtl_xRow["Number06"] = ud12.Number06;    
							ttAPInvDtl_xRow["Character05"] =  ud12.ShortChar15 ;  
							ttAPInvDtl_xRow.DocExtCost = 500;
							bo_ApInvDt.UpdateMaster(ref bo_ApInvDtds, GroupID, "APInvDtl",true, false, true, false, out grpTotalInvAmt, out requiresUserInput, out opMessage, out opMsgChkBankRef, out opChkRevMsg, out lEnableGenLegalNum, out lUpdateRan , out opMessage1);
						}
					} 
				} 
	}

because of For Each i think error is coming , kindly inform how to resolve,

2

Use this

using (var txScope = IceContext.CreateDefaultTransactionScope())
{
foreach (var ud12_iterator in (from ud12_Row in Db.UD12
where ud12_Row.Company == Session.CompanyID
select ud12_Row))
{
ud12 = ud12_iterator;
Erp.Contracts.APInvoiceSvcContract bo_ApInvDt = null;
bo_ApInvDt = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.APInvoiceSvcContract>(Db);
var bo_ApInvDtds = new Erp.Tablesets.APInvoiceTableset();
if (bo_ApInvDt != null)
{
bo_ApInvDt.GetByID(VendorNum, APInvoiceNum );
bo_ApInvDt.GetNewAPInvDtlMiscellaneous(ref bo_ApInvDtds, VendorNum, APInvoiceNum);
bo_ApInvDt.ChangePartNum(ud12.ShortChar11 , ref bo_ApInvDtds);
bo_ApInvDt.ChangeVendorQty(1, ref bo_ApInvDtds);
bo_ApInvDt.ChangeUnitCost(uCost, ref bo_ApInvDtds);

					var ttAPInvHed_xRow = (from ttAPInvHed_Row in Db.APInvHed
					where ttAPInvHed_Row.InvoiceNum == APInvoiceNum
					select ttAPInvHed_Row).FirstOrDefault();
					
					if (ttAPInvHed_xRow != null)
					{
						var ttAPInvDtl_xRow = (from ttAPInvDtl_xRow1 in bo_ApInvDtds.APInvDtl where ttAPInvDtl_xRow1.RowMod == "A" select ttAPInvDtl_xRow1).FirstOrDefault(); 
						if (ttAPInvDtl_xRow != null)
						{
							ttAPInvDtl_xRow.Description =  ud12.ShortChar17; 
							ttAPInvDtl_xRow["Number06"] = ud12.Number06;    
							ttAPInvDtl_xRow["Character05"] =  ud12.ShortChar15 ;  
							ttAPInvDtl_xRow.DocExtCost = 500;
							bo_ApInvDt.UpdateMaster(ref bo_ApInvDtds, GroupID, "APInvDtl",true, false, true, false, out grpTotalInvAmt, out requiresUserInput, out opMessage, out opMsgChkBankRef, out opChkRevMsg, out lEnableGenLegalNum, out lUpdateRan , out opMessage1);
						}
					} 
				} 
	} 
}