Import FA master data from Excel - SAP B1 9.0

[Former Member]

Hi everyone,

I've tried to import FA master data from excel file to SAP B1 version 9.0 PL02.

I did searching through SAP Notes, delta training document and community network but I've not found any detail documents mention about this yet.

From the delta training document, the procedure sounds easily. In fact, I got something need help and answers as following:

1. What is the date format for datetime fields on the excel template?? I usually get the error message like "Capitalization date is not valid" even when succesfully importing cases

2. Is there any validation relating to fields: the first date of import fiscal year, capitalization date, remaining life, depreciation start date like we have to follow in the earlier version??? I sometimes get error message like: the useful life must be the same to the remaining life

3. How to import successfully FA master data with more than 1 depreciation area? I did successfully importing once but depreciation area was without derived area that should be included as default like creating new asset using main area

4. Is there any log file which I can find more detail about the error messages?

Thanks

Doan Ngoc

[former_member196081 · Accepted solution]

Hi,

Item code	Item Name	Asset Class	depreciation Group	Asset Group	Depreciation Type	Depreciation Area	Capitalization Date	DepreciationStart Date	Usefull Life	RemainLife
FA00001	Voltas Split 2.0 Tons	AIR CONDITIONER	A C	A C	SLM4.75	Main Books	10/10/07	10/10/07	252	252
FA00002	Voltas Split 2.0 Tons	AIR CONDITIONER	A C	A C	SLM4.75	Main Books	10/10/07	10/10/07	252	252

Made same format in notepad and save as .txt file.before importing the FA master, please defined these masters in SAP. Asset class,account determination , Depreciation group and asset group

[Former Member · Accepted solution]

Hi Deepak,

It works

The only mistake in my template is about the date format which I mentioned in the first question

I see you've resolved your problem like my question no. 3, please share me

Thanks

Doan Ngoc

[Former Member · Accepted solution]

Hi Deepak

i have Made same format in notepad which you tell but its shown following error.

" Can not Import "Item Code";"Item group" is not valid"

How to resolve this error.

My File contains following data:

Item code

Item Name

Asset Class

depreciation Group

Asset Group

Depreciation Type

Depreciation Area

Capitalization Date

DepreciationStart Date

Usefull Life

RemainLife

4301001    MICROMETER      Machine                        MC                          MC                   SLM20            Main Books  01/01/2013   04/05/2013  5  5       

Thanks,

Praful Rajyaguru

[former_member196081 · Accepted solution]

Sorry for late reply.

you are right. Date format should be yyyymmdd.

[former_member196081 · Accepted solution]

Change the date format as YYYYMMDD

[Former Member]

Hi Doan,

Please check:  http://scn.sap.com/community/business-one/blog/2013/05/29/fixed-assest-in-sap-business-one-90

Regards,

Marcelo Silva Santos

[kothandaraman_nagarajan]

Hi Doan Ngoc,

Please refer below link for complete information on Fixed asset.

http://help.sap.com/saphelp_sbo900/helpdata/EN/46/01c34d43d741b2e10000000a11466f/content.htm?framese...

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagarajan,

Thanks for reply.

For more information about what I mentioned:

1. The import template:

2. The excel file:

3. FA Class, Depreciation area, Depreciation type are available in the system already:

4. Import result

Hope that you can show me some mistakes I made

Thanks

Doan Ngoc