Dynamics Community Forum Thread Details

Updating purch Price in purch line table from trade agreement journal

Trying to update the purch price in purch line table from trade agreement journal using batch job for bulk data update

below is the code used to update

public void processUpdateprice()
{

PriceDiscStorageTable priceDiscStorageTable; // storing the current price value in this table from trade agreement journals
PriceDiscAdmTrans priceDiscAdmTrans;
InventDim   inventDim;
InventTable   invetnatble;
PriceDiscTable   priceDiscTable;
PurchTable       purchTable;
PurchLine       purchLine;
vendtable   vendtable;
Amount   amount;
try
{
ttsbegin;
       update_recordset purchTable
            setting
            PurchStatus = PurchStatus::Backorder
                && purchTable.IFSECProcess == NoYes::No
                       join purchLine
            where purchLine.PurchId == purchTable.PurchId
                && purchLine.PurchPrice == 0
                       join priceDiscAdmTrans
            where priceDiscAdmTrans.ItemRelation == purchLine.ItemId
                           && priceDiscAdmTrans.AccountRelation == (purchTable.vendTable_OrderAccount().AccountNum);

select * from priceDiscStorageTable where priceDiscStorageTable.ItemNumber == priceDiscAdmTrans.ItemRelation;

           purchLine.PurchPrice = priceDiscStorageTable.CurrentPrice;
           purchTable.IFSECProcess   = NoYes::Yes;
           purchLine.doUpdate();
           purchTable.doInsert();
ttscommit;
}
catch (Exception::Error)
{
info(Exception error occurred);
}
}

priceDiscStorageTable by using this table trying to assign the current price value to purch price in purch line

But Im facing below issue

I have pointed the Debugger but it is not showing any thing it is directly tiggering to catch exception.
*
Please help me to fix this issue
Thanks in advance

Quick Links

Leaderboard