Import Fixed asset Master Data From Microsoft Excel

[Former Member]

Hi

I'm trying to import fixed master data throught .txt file but it shows me the folowing error "The depreciation start date of asset "A2" for depreciation area "COLGAP" cannot be in the import fiscal year"

Where A2 is Fixed Asset Code and COLGAP is "Depreciation Area"

I attach some images with fixed assets setups and data template

Do you have any idea what is the error?

Thank you so much

[former_member196081]

one more thing i notice. for which fiscal year you are importing the FA ? If the same is not for current fiscal year (most probably you are importing for last fiscal year) then you have to run the fiscal year change functionality first before import the item.

Try and revert if not success..

[Former Member]

Hi Deepak

Thanks for your answer.  I checked your document and I followed it step by step, but I have another issue when I tried to import.  It says "Cannot import "A2"; its active depreciation areas must be the same as those defined in the corresponding asset class"

I attach again the images.  Can you tell me what is my problem?

Thank you

[former_member196081]

please check the dephreciation area you mentioned in txt file. it should be the same as you defined for the asset class.

[Former Member]

I checked and It's ok

I don't know what the problem is

[former_member196081]

if item master is already configured, then try with only two fields with DTW template (Item no., APC). No need of other fields.

[former_member196081]

sorry friend. its not possible to update the FA through DTW template.

[former_member196081]

you may check below document

[jitin_chawla]

Hi,

Please check the Note 1963711 regarding the issue mentioned by you.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Jitin

Thanks for your answer.  I checked the note but I think so it doesn't aplly for me.  My sap version is 9.0 PL11.  The patches were launched in January 2014 to fix the problem.  That means my sap version would have this patches.