I have over 22,000 fixed asset records with service lives greater than 99 years.
Our in-house super-user updated the "Original Life Year" field on the Book card to 3 digits,
When I manually create an asset record in GP that has a service life of eiher 100, 110 or 120 years, the field accepts the 3-digit service life.
When I run depreciation on those manually created assets, the resulting depreciation expense, acc depreciation, remailing service life, NBV are all correct.
Here's my problem: When I try to "Import" the Book data via Excel, GP halts because it does not recognize a service life with 3 digits.
Is there something in the import function that needs to be tweaked? An issue with the macro?
HELP!