Error closing final year end - balance in accounting & parallel currency must be zero

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.

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.

DKK wrote:

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