Hi @Bayo 

Can you confirm if you’ve performed ‘Clear revenue/cost balances’ prior to running this.

Best regards

Zuha

Yes, The process was run - ‘Clear revenue/cost balances’

Thank you

hi @Bayo 

Could you please check the result for below query?

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


Thanks and regards,
Viraj

I got a Nill Balance on summation for the amount_balance=0 and Third_currency_Amount_Balance=0.

What Should I do Next.

Your kind advise

Hi Bayo

Have you used the correct company id?

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

Could you please send me a screen print of the results?

Thanks and regards,
Viraj

Hi Bayo,

As we checked, There was an account with mismatching logical account type and account type.

This has to be fixed via data repair to solve the issue.

Please let us know the feedback.

Thanks and regards,
Viraj