Dynamics Community Forum Thread Details

Transfer purchase requisition lines from old purchase requistion to new one.

I am trying to insert all purchase requisition lines of my older purchase requisition to a new purchase requisition i have written the code which is below but i am getting logical error my product category field and purch price fields are not getting populated it remains empty in the new Purch requisition but it is populated in the older one..

select * from purchReqLine
where purchReqLine.purchreqtable == purchReqTable.RecId // older purchreqID
{
//Purchase requisition lines
purchReqLineNew.initValue();
purchReqLineNew.initFromPurchReqTable(purchReqTableNew);
purchReqLineNew.ItemId = purchReqLine.ItemId; //Replace ItemId according to your system's data
purchReqLineNew.BuyingLegalEntity = purchReqLine.BuyingLegalEntity;
purchReqLineNew.SequenceNumber = purchReqLine.SequenceNumber;
purchReqLineNew.InventDimIdDataArea = purchReqLine.InventDimIdDataArea;
purchReqLineNew.PurchQty = purchReqLine.PurchQty;
purchReqLineNew.Requisitioner = purchReqLine.Requisitioner ;
purchReqLineNew.BuyingLegalEntity = purchReqLine.BuyingLegalEntity;
purchReqLineNew.ProcurementCategory = purchReqLine.ProcurementCategory;
purchReqLineNew.InventDimIdDataArea = purchReqLine.InventDimIdDataArea;
purchReqLineNew.InventDimId = purchReqLine.InventDimId ;
purchReqLineNew.PurchUnitOfMeasure = purchReqLine.PurchUnitOfMeasure ;
purchReqLineNew.LineAmount = purchReqLine.LineAmount;
purchReqLineNew.CurrencyCode = purchReqLine.CurrencyCode;
purchReqLineNew.CurrentStep = purchReqLine.CurrentStep ;
purchReqLineNew.VendAccount = purchReqLine.VendAccount;
purchReqLineNew.PurchReqTable = purchReqTableNew.RecId;
purchReqLineNew.modifiedField(fieldNum(purchReqLine,ItemId));
purchReqLineNew.insert();

}
ttscommit;

Quick Links