Share
Report
2Trying 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);
{
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);
}
}
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
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
I have the same question (0)
All responses (
Answers (
