v6rc2 account_bank_statement for foreign curency banks

[Vadim - Enapps LTD]

Probably this is not a bug, but something that has not been implemented yet and I just would like to confirm either this will be done for the v6 release or not.

Currently the statement reconciliation does ignore the foreign curency bank balances for foreign banks and does all the computations in the base company curency instead.

Example:
base curency - EUR
Bank and bank journal curency - GBP

The bank reconciliation screen for this bank journal should present the entries and totals in GBP, not in EUR. EUR could be presented optionally for if you like to implement the additional feature of the monthly bank revaluation, yet this operation is normally done via a different module/screen.

This is the corect logic of all the other accounting systems that I came accross to date.

[Frederic Clementi - Camptocamp (frederic-clementi)]

100% agree...

[TeMPO (info-tempo-consulting)]

+1

Maurice @ TeMPO Consulting

[Colin MacMillan (colin-macmillan)]

+1

[Fabien (Open ERP) (fp-tinyerp)]

I tested and it works fine. (in r4229)

I don't know if it has been fixed two days ago or not, but the behaviour is correct.
If you pay in GBP, it shows all amounts in GPB, not in the base currency.

[Fabien (Open ERP) (fp-tinyerp)]

I mark it as "fix released", I don't know if it was a fix recently or a wrong bug report.

[Vadim - Enapps LTD (vadim-enapps)]

Thanks Fabien,
Just to make sure we refer to the same view:
Accounting>Periodical Processing>Statements> Statements Reconciliation

Please see attached screenshot:
the transactions tree view has no mention of any foreign currency balance - it shows the base currency value only - 42.66 is a base currency value, when we should be able to see in this view the foregin currency of HKD 258.70.

The account_move_line tree view has some restrictions as far as modifications go - asked the question here about that - https://answers.launchpad.net/openobject-addons/+question/140541

Now when I said the computations are done in base currency, this is why I said that:
- The statement total shown is 258.68, yet it should be 258.70 whcih is the value of the payment as entered by the operator. I presumre that for computing the totals, the module uses base currency and translate it into the foreign currency at the date of the transaction, which is not right. You will have a lot of rounding problems, which is not acceptable from the accounting point of view. We, accountants demand farmacy grade precision, and if the system cant offer that, then we have a problem.

  - similar issue with this bug I reported in the accounting_voucher described here https://bugs.launchpad.net/openobject-addons/+bug/699872.

I would be happy to help as much as I can with feedback to help iron these issues out to perfection as I understand that a lot of developers are not accountants and not many accountants have any ideas about the database structure of the accounting systems.

[TeMPO (info-tempo-consulting)]

Dear Vadim and Fabien

I guess the confusion comes from the titel "of the bug"
If you make the renconciliation when you are entering the bank statement and use the Import Invoices wizard then
it is correct as described by Fabien
But with the other way mentionned by Vadim it seems that it is not working correctly even that I had some difficulties
unterstanding the correct sequence your are followilng
maybe you could put some more details

regards

maurice

[Vadim - Enapps LTD (vadim-enapps)]

Thanks Maurice, you have a good point.
Well, the bank statement with 'import invoices' wizzard is not very useful to me unfortunatelly - I cant seem to get the practical point of it from the accounting point of view. Bank reconciliation should the the place where you go and select the bank transactions you made during the month and mark them as reconciled, giving them a reference, which normally is the same as the bank statement pages.

This is exactly what Accounting>Periodical Processing>Statements> Statements Reconciliation does

[TeMPO (info-tempo-consulting)]

Hello Vadim

IMHO the Import invoices was designed to ease the reconciliation process at the same time you are
entering your bank statement; so you enter (or import) your bank statement as you get it on the paper
coming from your bank and then you use the import invoice wizard to make the reconciliation

You are doing this in two steps

[Vadim - Enapps LTD (vadim-enapps)]

Sorry, will this be looked at?

[qdp (OpenERP) (qdp)]

Hello Vadim,

i read you bug description carefully and i agree that we have a lack in the statement reconciliation process for mutli-currency use cases... Nevertheless, it hasn't been planned yet in our roadmap (no chance it could be done for the v6, which is already released: new features are done in new versions only). That's the reason i setting this bug as "won't fix": it means we won't do it for the v6, but it doesn't mean that we will never implement it.

I suggest you to create a poll for that idea on http://feedback.openerp.com/forums/87921-accounting whereas we will choose the best ideas to implement for the next version.

Thanks for your contribution,
Quentin

[qdp (OpenERP) (qdp)]

you can vote for the suggestion of Vadim following this link: http://feedback.openerp.com/forums/87921-accounting/suggestions/1395229-account-bank-statement-for-foreign-curency-banks?ref=title

thanks,

[Vadim - Enapps LTD (vadim-enapps)]

In case anyone needs this functionality, we released a module to address this - http://www.smartmode.co.uk/site/content/bank-reconciliation-modifications-openerp