cancel
Showing results for 
Search instead for 
Did you mean: 

Fixed Asset Importation Issue (Capitalisation Date)

0 Kudos

Hello experts,

I have an issue regarding fixed asset importation.

I've import the fixed asset master data correctly in the system, with it's correct capitalisation date, APC, depreciation cumulative value and everything else correctly in the master data. Under Administration --> Data Import/Export --> Data Import --> Import Fixed Asset Master Data from Microsoft Excel.

However, where the issue is, it's now on the fixed asset history sheet, where the capitalisation date, is defined as the first date of the fiscal year "01/01/2014". Where by none of these assets were purchased on that date. But everything else on the report is correct except the capitalisation date.

Due to this issue, it is hard to explain how an asset was purchased on 01/01/2014, which have a use full life of 4 years, has depreciate completely in 2015. But if I check in its master data, I find out the capitalisation date is like in 6 years ego.


Note: I'm using SAP Business One 9.0 PL11


Any suggestion, comment or help is highly appreciated.



Best Regards,

Cedric Kayitare

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Cedric,

Make sure you have selected 2015 as financial year when importing fixed asset. Also check your sheet of  mapping field. If you importing fixed asset from previous years then you need to run year transfer.

Regards,

Chintan

0 Kudos

Hi Chintan,

Thanks for your quick reply

I've imported fixed asset from previous years.
I've never run the year transfer before,
How do I run year transfer?

Best Regards

Cedric K

Former Member
0 Kudos

Hi,

Go to financial -> fixed Asset -> Fiscal year change.

This will enable sap to calculate depreciation. Do it in test database to see it's effect.

Regards,

Chintan

0 Kudos

Hi Chintan,

I've done the fiscal year change, for all fiscal years,but still the date are appearing the same as they was before.

Best regards,

Cedric K.

Former Member
0 Kudos

Hi Cedric,

Capitalization date won't change it self after import. Check your import sheet which capitalization date you have enter. you need to execute fiscal year change and then import sheet.

If you have capitalization date for different years then you should have all period created and then year transfer.

In that case you will have to run depreciation from SAP for all corresponding year.

Post your sheet with heading for more understanding.

Regards,

Chintan

Answers (0)