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

[RogerioSST]

You must have all ACTIVE depreciation areas (COLGAP and NIIF) in your txt file. it's mean you will have two lines to the same item. Also there are  some prerequisites for the different types of assets you want to import. Please, have a look on this documentation: https://help.sap.com/saphelp_sbo900/helpdata/EN/94/7e131c04ca428d933f5375a98aef0e/content.htm?no_cac...

Also, ensure that the depreciation area ID does not contain any special characters. Use only alphanumeric characters. This was my case the code was "razão" and it supose to be "razao" or any other without special characteres. So, even I've had a unique depreciation area registered it was not recognized from the import file, because it assume you didn't select all the active areas of the asset class.  Unfortunately for me, it was already imported and run some process, so I had to register a ticket with SAP in order to fix it.
TIPS FOR SAP: SAP should not allow the user define any table id/code, and let them personalize their names only.

[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.