/Joe

I have a lot of different currency accounts and at least once a year I need to revaluate the accounts to match the year end exchange rates. I have posted a journal entry to the GL account concerned-  as I normally would in most other software, but have recently found that this actually affects at least one of the currency accounts. Later I found there is a  'Revaluation of Currency Accounts' option in the 'Banking and General Ledger' section. This, however, doesn't work.

Using the 'Revaluation of Currency Accounts' I get this error:

DATABASE ERROR : could not test for unique reference
error code : 1054
error message : Unknown column '0_refs' in 'field list'
sql that failed was : SELECT 0_refs FROM 0_gl_trans LEFT JOIN 0_voided v ON 0_gl_trans.type=v.type AND 0_gl_trans.id=v.id WHERE 0_gl_trans.0_refs='185' AND ISNULL(v.id) AND 0_gl_trans.type='0'

I have posted this to the bug tracker.

How can I adjust the value of my GL accounts related to Bank Accounts without affecting the bank account? And why does a journal entry to a GL account affect a Bank Account?

Thank you.