UpdateFixedAssetsConfiguration Spreadsheet not updating Dep Rate for Flat Rate Method

Summary:

Hello,

We have more than 600 asset categories having flat rate depreciation method. We use UpdateFixedAssetsConfiguration Spreadsheet to create those categories and at the time loading we mention "Life in Months" as 1. It give waring message but it creates the asset categories with Flat Rate Dep Method and Rates.

Now we have a requirement to update the Basic and Adjusted rate for these categories and since the voulme is high we are againg using same UpdateFixedAssetsConfiguration Spreadsheet to update the Basic and Adjusted Rates. But we are not able to update it as it gives the error- You must enter a valid value for the flat rate depreciation method. We are entering correct rate in correct format but still not able to change the rates.