Error closing final year end - balance in accounting & parallel currency must be zero
We have 3 companies in foreign currency that we cannot transfer year end balance. We get the error message that the balance in accounting currency and parallel currency for assets and liabilities must be equal to zero for 2023 before final year closing can be performed. When I look at the GL balance analysis for 2023 for the balance sheet accounts, in USD they are rounded to 4 decimals and in previous years they were all 2 decimals. Then when I look at 2024 period 0 there is a penny difference. As we cannot do a voucher under a penny, how do we fix this?
Page 1 / 1
Hi @DKK,
Hope you may already fix this issue since the issue raised 3 months back. if it is not you can create voucher like below and eliminate the parallel currency difference.
Account
Account Description
Debit Amount
Credit Amount
Debit Amount in Parallel Currency
Credit Amount in Parallel Currency
9999999
Exchange Gain/Loss
1.00
0.00
9999999
Exchange Gain/Loss
1.00
0.01
I ended up submitting a ticket with IFS and getting a script to round the third currency amount balance to two digits. When running the following SQL query I verified the rounding:
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=2023
Group by account_api.get_accnt_type_db(company.account)
I ended up submitting a ticket with IFS and getting a script to round the third currency amount balance to two digits. When running the following SQL query I verified the rounding:
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=2023
Group by account_api.get_accnt_type_db(company.account)
Hi @DKK,
We are experiencing the same issue with one of our customers. Can you please share the script to round the third currency amount balance to two digits? Thankyou.
Attached is the script. They’ll have to make sure that they update the sections below (highlighted in green) to reference their specific company, accounting year, accounting period. I don’t know where POSTING_COMBINATION_ID comes from, but I’m guessing they will have to update that value for their system as well.
Attached is the script. They’ll have to make sure that they update the sections below (highlighted in green) to reference their specific company, accounting year, accounting period. I don’t know where POSTING_COMBINATION_ID comes from, but I’m guessing they will have to update that value for their system as well.
Thank you very much @DKK. Highly appreciate your support on this
