Error updating UsefulLife field by DTW

[prmendoza_a]

Hi Experts,

I'm trying to import ITM7 template by DTW and it returns the following error message: "242000115 - Asset class has not changed, you can not add or remove depreciation area directly."

The fixed asset that I want to update has Percentage for salvage value.

When I do the same through the interface there is no error.

I'm using SAP Business One for HANA 9.2 PL 7 Hotfix 1.

Thanks for your time and your answers.

[IanT]

import-template-itm7.pngitm7-example.pngHi Paola and Daniel

Not sure if you have managed to win with this issue, I had a similar issue and it came down to the LineNum field on the template that needs to be the exact LineNum of the asset in table ITM7 that you require to update.

In my example I wanted to update my GAAP DprArea in 2021 seeing that I have two areas per asset. The line number in the table for that data set was 6 for the first asset and 4 for the second asset (Start counting from 0).

Please see attached

I completed the import template as follows and the update went through:

MV0001,6,,,,120,

MV0002,4,,,,95,

Hope this helps.

Ian

[former_member1141094]

Hi Ian,

This has worked for me. I was getting the same error.

Thanks

[Samudra]

Very Well,

I understood that I had to update the line item and only change the Useful life(for my case)

Thanks,

Samudra

[ANKIT_CHAUHAN]

Hi sumama92 ,

ITM7 template should be used to update Depreciation Type. The issue is caused by incorrect LineNum value (no value) in ITM7 template.

When we update the existing data in ITM7, we need to put the correct LineNum value in ITM7 template.

To get the correct LineNum, please run below mentioned query:

Select * from ITM7 where "ItemCode"='ItemCode' order by "PeriodCat", "DprArea";

where first row refers to LineNum 0, second row refers to LineNum 1 and so on.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[sumama92]

Please tell me the solution. I am facing same error, but I don't understant as per upper given line number concept.

[cezary_marchwicki72]

Great advice Ian!

It worked liek a charm for me.

Thanks a lot!

[former_member426707]

Hello Paola,

Just wondering if you found the solution for this?

I am having the same problem, but it's only on a customer's environment, if I do it on my internal environment it works fine.

Thanks

Daniel