Finance | Project Operations, Human Resources, ...

Cannot edit a record in Fixed asset book (AssetBook). The record has never been selected.

(0) Share

Report

Posted on by Nsb

Hi All,

I am trying to update the table AssetBook. and getting the following error message:

Cannot edit a record in Fixed asset book (AssetBook). The record has never been selected.

Here is a snippet of my code:

assest = strRTrim(strLTrim(conPeek(record,1))); //Column 1
Info(assest);
acquisitionDt = conPeek(record,2); //Column 2
depricationProfile = conPeek(record,3); //Column 3
isDepricate = conPeek(record,4); //Column 4
costCentre = conPeek(record,5); //Column 5

assetBookTbl.clear();
ttsbegin;
select forupdate assetBookTbl where assetBookTbl.AssetId == assest;
if(assetBookTbl)
{
assetBookTbl.AcquisitionDate = str2Date(acquisitionDt,123);
assetBookTbl.DepreciationProfile = depricationProfile;
if(isDepricate == "Yes")
assetBookTbl.Depreciation = NoYes::Yes;
else
assetBookTbl.Depreciation = NoYes::No;
assetBookTbl.update();

}

ttscommit;

I am reading data from a .csv file and updating the table. I used infolog to check and data is being read correctly.

Plz help me understand my mistake in code.

Thank you.

All responses (3)

Answers (0)

Suggested answer

Nsb 5 on at

Like (0)

Report

RE: Cannot edit a record in Fixed asset book (AssetBook). The record has never been selected.

The issue got resolved.

There was issue with converting str to date.

I replaced assetBookTbl.AcquisitionDate = str2Date(acquisitionDt,123);

with assetBookTbl.AcquisitionDate = any2Date(acquisitionDt);

This worked for me.
Nsb 5 on at

Like (0)

Report

RE: Cannot edit a record in Fixed asset book (AssetBook). The record has never been selected.

Hi Gunjan,

Thank you for the response. There has been no customization on the table or its methods. I will use a debugger on the update method and check.

Thank you.
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Cannot edit a record in Fixed asset book (AssetBook). The record has never been selected.

Hi Nsb,

I don't see anything wrong in the code you have given here. Is there any existing customization to AssetBook\update method that might be causing the issue? Have you debugged update method to check which line of code is causing the issue?