No Depreciation with Quantity and amount equal to 1

[Former Member]

Hi Experts,

Can we import fixed asset with the value & quantity of 1 then no deprectiaion

Regards,

Amy

[Former Member]

Hi Amy,

It is not normal for assets that no depreciation. You may set them as manual depreciation though.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Then how come the no depreciation is included in the options? One more thing, Land has no deppreciation. but normally included in the Fixed asset master data if they own multiple properties

Regards,

Amy

[Former Member]

You can set them up in an asset class that has no depreciation as the depreciation type

[Former Member]

Hi Julie

I alreay have a depreciation type for No depreciation

The sample file that im trying to encode is posted below

Inventory Number;Item Code;Description;Short Description;Capitalization Date;Vendor Code;Vendor Name;Serial Number;User01;User02;User03;User04; APC ;Quantity; APCHist ;Depr 01;Depr Start date 01;Useful Life 01;Remaining Life 01;Depr Type 01;Ordinary Depr 01;Unplanned Depr 01;SpDpKey1 01;SpDpAcc1 01;SpDpKey2 01;SpDpAcc2 01;SpDpKey3 01;SpDpAcc3 01;Depr 02;Depr Start date 02;Useful Life 02;Remaining Life 02;Depr Type 02;Ordinary Depr 02;Unplanned Depr 02;SpDpKey1 02;SpDpAcc1 02;SpDpKey2 02;SpDpAcc2 02;SpDpKey3 02;SpDpAcc3 02;Depr 03;Depr Start date 03;Useful Life 03;Remaining Life 03;Depr Type 03;Ordinary Depr 03;Unplanned Depr 03;SpDpKey1 03;SpDpAcc1 03;SpDpKey2 03;SpDpAcc2 03;SpDpKey3 03;SpDpAcc3 03;Depr 04;Depr Start date 04;Useful Life 04;Remaining Life 04;Depr Type 04;Ordinary Depr 04;Unplanned Depr 04;SpDpKey1 04;SpDpAcc1 04;SpDpKey2 04;SpDpAcc2 04;SpDpKey3 04;SpDpAcc3 04

TCL-00-00008;999;1 Aircon-mitsubishi;1 Aircon-mitsubishi;2000-05-29;;;;;;;; 1.00 ;1; 1.00 ;100;2010-01-01;0;0;0000;0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

The error message is always below

2010-09-09 14:17:23.937 0 BA ER CFrmMasterDataTransfer::FormPutData Exception caught!

2010-09-09 14:17:40.593 0 BA ER CBAMasterDataParser::ConvertToParamAndValueCntr Invalid value of APC(Field Index = 12) in line data(TCL-00-00008).

2010-09-09 14:17:40.593 0 BA ER CBAMasterDataTransfer::doDataImport Data Conversion Error: TCL-00-00008;999;1 Aircon-mitsubishi;1 Aircon-mitsubishi;2000-05-29;;;;;;;; 1.00 ;1; 1.00 ;100;2010-01-01;0;0;0000;0;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

We tried changing the Dept Start date, APC and APC History as well as the useful and remaining life. the same error mesage in the log file

Regards,

Amy

[Former Member]

If you put bigger values, does it work? I am not aware of any restrictions on values, but have not used this scenario.

The other option would be to use a larger value as APC, then the same value -1 for depreciation, but you would then need to manipulate the useful life?

[Former Member]

Hi Julie,

I already tried manipulating the useful life.-same error

For the depreciation, did you mean negative 1? I dont think the system will accept negative values.

For APC, I only tried 1 and Zero amount. Same error

Regards,

Amy

[Former Member]

I was suggesting putting, for example, 500 in the APC and 499 in the depreciation, so the book value is calculated as 1?