Dynamics Community Forum Thread Details

Cannot Create purchase requisition through x++ haing a error that the data already exists.

Hi,

I was trying to enter a PR after uploading a excel file in D365FO but I am getting an error that the record is already exists.

Here is my snippet of code that I am using.

ttsbegin;

using (ExcelPackage package = new ExcelPackage(Stream))
{
Package.Load(Stream);



worksheet = Package.get_Workbook().get_Worksheets().get_Item(1);
Range = worksheet.Cells;
rowCount = (worksheet.Dimension.End.Row);

//Header
purchReqTable.clear();
purchReqTable.initValue();
purchReqTable.PurchReqId = NumberSeq::newGetNum(PurchReqTable::numRefPurchReqId()).num();
purchReqTable.PurchReqName = range.get_item(4,2).value;
purchReqTable.insert();



if(purchReqTable.validateWrite())
{
//Lines
purchReqTable.insert();
for (row = 8; row <= rowCount;row  )
{
purchReqLine.clear();
purchReqLine.initValue();
purchReqLine.initFromPurchReqTable(purchReqTable);
purchReqLine.ItemId = range.get_item(row,1);
purchReqLine.BuyingLegalEntity = CompanyInfo::find().recId;
PurchReqLine.InventDimIdDataArea = curExt();
purchReqLine.PurchQty = (row,2);
PurchReqLine.modifiedField(fieldNum(purchReqLine,ItemId));



if(purchReqLine.validateWrite())
{
purchReqLine.insert();
}
else
{
throw Error("Requisition Line");
}


}



}
else
{
throw Error("Purchase Requisition Header");
}



info(strFmt("Total %1 purchase requisition(s) uploaded.", Row-1));



ttscommit;
}

Quick Links