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 Viraj,

see below the results

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

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