Final year end : balance accounting currency not equal to zero

Hi @Ines,

When the fiscal year is closed finally, balance for assets and liabilities accounts must be equal to zero. 

I had this error message when balance for accounts of type ‘Statistics, incl. in Opening Balance’ wasn’t zero.

Please check if for this account type the balance is zero.

You can check it in the GL Balance Analysis window asking for account type.

BR,
Małgorzata

hi @Ines

Please check whether you have performed the  ‘Clear revenue/cost’ process. 

If yes, send me the results for the below query.

select account_api.get_accnt_type_db(company,account),sum(amount_balance),sum(third_currency_amount_balance)  from accounting_balance where company='xxx' and accounting_year=2018
Group by account_api.get_accnt_type_db(company,account)

Replace xxx with correct company id.

Thanks and regards,
Viraj

Hi Viraj,

see below the results

Process clear revenue cost

hi @Ines 

It seems like there is a balance in statistics accounts. you may have to transfer them to relevant accounts before running the final year end.

• Go to GL balance analysis window and  check the balances by account type.
• you can RMB on statistic accounts line and check the voucher information.

OR 

You can use below query to identify those voucher rows.

select voucher_type,voucher_no,row_no,account from gen_led_voucher_row_tab where company='XXX' and accounting_year=2018 and account_api.Get_Logical_Account_Type_Db(company,account)='S'

Replace XXX with company id.

BTW  send me the results for the following query as well.
select Distinct t.accnt_type from accounting_code_part_value_tab t where  code_part='A' and t.logical_account_type='S' and company='XXX';

Thanks and regards,
Viraj

Viraj

thanks

see below

Thanks Viraj

I don’t undertand well: I must have  on sum(amount balance) = 0 for each account type S , R , C ?

Accounts 999940 & 999941 have been used for migration from older application to ifs.

So  I don t know what type account to use

Thanks

hi @Ines ,

Requirement:

Balance of Assets and liability accounts should be equals to 0.

In your case, there is a balance of -13434.34 in the statistic accounts. that is the reason why Assets and liability balances are not equal to the zero. So you may have to transfer the balances of statistic account to correct account by creating a manual voucher first.

Thanks and regards,
Viraj

Hi Viraj,

Very thanks a lot for your help

Have a good year