Import fixed Asset

[former_member657107]

Dear All,8

I cannot import fixed asset to SAP Business One ( Hanna) PL8, the following message appear

The Remaining life of fixed asset for depreciation area GAAP is incorrect

how i can solve this issue ?

Regards,

Abdualla Fatayer

[kothandaraman_nagarajan]

Hi,

Please check SAP note:

2001876 - The system does not consider the Salvage Value nor the
Remaining Book Value when you impor...

Thanks & Regards,

Nagarajan

[Former Member]

Dear Abdualla,

You may only import the FA item as their current value and start depreciation in current year.

Thanks,

Gordon

[former_member196081]

Hi

Please provide the details which you are trying to upload for FA and screen shot of error too . You can check below link too for FA import.

[former_member657107]

Dear All,

the data that i want to import them to SAP B1 is:

Item code, Description, Capitalization date, APC , Historical APC, Asset Quantity, Asset Class, Asset Group, Depreciation Area, Depreciation type, useful life, Starting depreciation date and Accum depreciation

[former_member196081]

firstly as per error message, Define the numbering series for FA Item Master data.

Can you share your template, which you are trying to upload?

[Former Member]

Hi Abdullah Fatayer,

Please indicate also the remainig life on your Fixed Asset Template for importing.

Regards,

Lean

[Former Member]

show us the excel sheet you are trying to import...

[former_member657107]

Dear Sandy and John,

kindly find the excel sheet that  i am trying to import.

[former_member196081]

change the cell format for C & D column. there should not be comma. format should be like M & N column.

[Former Member]

Form 8.82 at-least, i know the remaining & useful file should be same, I think you should also adjust the decimal values. put start depreciation to first day of the current fiscal year in which you are importing. also remove ","s

Cheers

[Former Member]

Which formula you used for Calculate Remaining life of an asset

[former_member657107]

the formalla is :

remaining useful life = ( date of fixed asset that will be imported to SAP - starting depreciation date)\30 day.

and the result from this equation is subtracted from useful life of fixed asset.

note:

starting depreciation date =Dec 31 from the year that customer acqustion fixed asset.

example:

the capitalization date of an asset is 5/2/2012

I will consider starting depreciation date will be 31/12/2012

I will import the fixed asset on 1/1/2014

asset useful life is 80 Month.

then i will use the equation above to calculate remaining useful life

regards

[kothandaraman_nagarajan]

Hi,

Please post screen shot of above error message.

Thanks & Regards,

Nagarajan

[Former Member]

Could you add more details of this Asset please

APC, Useful & Remaining Life, Capitalization date etc

Sandy