Hi,
We are getting below error while performing year end process.
The balance in accounting currency and parallel currency for assets and liabilities must be equal to zero for 2022 before final year closing can be performed.
This customer is in IFSCloud and upgraded from 7.5 to IFSCloud 23R2 recently. we referred to IFS community post relating to similar issue and executed below SQL query as suggested in one of the post.
select account_api.get_accnt_type_db(company.account).sum(amount_balance).sum(third_currency_amount_balance) from accounting_balance where company=’X’ and accounting_year=2022
Group by account_api.get_accnt_type_db(company.account)
It's got below SQL result and stat account have balance only for parallel currency. How can we resolve this.
| ACCOUNT_API.GET_ACCNT_TYPE_DB(COMPANY,ACCOUNT) | SUM(AMOUNT_BALANCE) | SUM(THIRD_CURRENCY_AMOUNT_BALANCE) |
| C | 0.0000 | 0.0000 |
| L | -3586593003.9300 | -817116585.5146 |
| A | 3586593003.9300 | 817116585.5134 |
| R | 0.0000 | 0.0000 |
| S | 0.00 | 64299510191.85 |