Change in Account type is not working correctly

Summary:

Hi all,

We are having an account tagged as Asset account type. Now, as per the requirement, we want to change the account type to Expense as the same account should behave like a P&L account. It is a non-currency account having some statistical information but comes under the FCCS_Balance Sheet hierarchy and out of the FCCS_Total Balance Sheet-Traditional Approach hierarchy.

We changed the account type from Asset to Expense and Variance Reporting from Non-Expense to Expense and did the DB Refresh. We tried to run ForceConsolidation; we deleted the data and loaded again. But even after all these trials, this Expense account is carrying Opening balance.