Question

The Balance in Accounting Currency and Parallel Currency

  • 31 December 2021
  • 7 replies
  • 361 views

Userlevel 3
Badge +4
  • Sidekick (Partner)
  • 8 replies

IFS 10 App. 

 

The Balance in Accounting Currency and Parallel Currency for assets and Liabilities must equal to Zero for 2020 before final year closing can be performed.

 

 


This topic has been closed for comments

7 replies

Userlevel 5
Badge +10

Hi @Bayo 

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

 

Best regards

Zuha

Userlevel 3
Badge +4

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

 

Thank you

Userlevel 6
Badge +6

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

Userlevel 3
Badge +4

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

Userlevel 6
Badge +6

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

Userlevel 3
Badge +4

 

Userlevel 6
Badge +6

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