Dynamics Community Forum Thread Details

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

Community site session details

Updating purch Price in purch line table from trade agreement journal

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > FastTrack for Dynamics 365

Featured topics

Product updates