跳至内容
此问题已终结
reconciliationbankpaymentsstatement
4 回复
9951 查看
形象
Fabio

Hello, I am trying to figure out the proper way to operate a bank reconciliation in OpenERP, but I don't seem to be on the right path.

I use OpenERP 6.1 (and plan to migrate to 7.0 in a few months)

I read quite a few conversations in Q&A and Forum, but I get more and more confused and sometimes I do not know to which version of OpenERP they refer to. If someone had a pointer to a document or brief explanation on how to do that properly, I'd be very grateful.

I now have entered all supplier invoices, customer invoices, and Journal entries (for those operations that are not coming from invoices). I paid directly, with the Pay Invoice button, those invoices that were payed in cash and used the Payment button for those customer invoices that were paid to me in cash.

I did not enter any other payment explicitly, because I planned to do that directly while treating the Bank Statements. Does that make sense?

Now I have to treat the bank statements manually (since I don't manage to import automatically). I have been trying to use the two interfaces (Bank and Cash > Bank Statements and Periodical Processing > Statements > Statements Reconciliation) but I am afraid I am missing the point. I don't quite get in which context each one of those is supposed to be used.

Thank you.

形象
丢弃
形象
Fabrice Henrion (fhe)
最佳答案

There is a fundamental problem with bank reconciliation in v7 because it doesn't let you build a bank statement out of posted payments (just like what you expected). The mechanism had been designed differently (I'm not gonna go in the details here) but it is confusing to users and we have recognized that. This is why bank statement reconciliation as well as bank statement import (OFX, QBI,...) are part of the v8 roadmap as described on slide 17 here: http://bit.ly/15UuGHs.

At this point, the best way to use bank statement reconciliation in v7 is to pay invoices from the bank statement reconciliation screen and to therefore create small statements of 1 or a few transactions.

形象
丢弃
Lawrence

Hello Fabrice, I know you said it is on the V8 roadmap but I just wanted to check if there are in-fact now any plans to implement this in V7? (I notice this post is quite old and I can imagine that there are lots of people having issues here so perhaps there has been a fix?). It is frustrating that if one uses the "pay invoice" feature on the supplier invoice there is no way to later reconcile it to a bank statement! Thanks for any help!

Fabrice Henrion (fhe)

Hello. No there is no plan to backport this to v7. There are 2 remarks in that regard: 1) This is not a "bug" that needs to be "fixed". This is a feature. 2) When working on new features, we work in trunk, not on the latest stable version. A stable version can not receive new features. See release policy for more info https://doc.openerp.com/contribute/14_release_cycle/ If you are interested in this reconciliation feature for v7, you should contact Jon Wilson from WillowIT who developed that and even more on reconciliation: https://www.openerp.com/partners/directory/1439/Willow+IT

形象
Sandro Regis
最佳答案

Hello, in the past i face the same problem and my hint to you is to find some good Accounting Patterns Tutorial and try to understand and apply step by step on your OpenERP system. Take a note that, before u do one reconciliation process we have the conciliation process as it is. For sure, if you do this kind of self training you will solve your doubts. It is just a hint! (y)

Regards,

形象
丢弃
形象
Acespritech Solutions Private Limited
最佳答案

Hello !

May be this blog can be helpful.
acespritechblog.wordpress.com/2012/12/13/bank-reconciliation-in-openerp/

Thanks,
Acespritech Solutions Pvt. Ltd.
Mail: info@acespritech.com
Skype: acespritech
Blog: acespritechblog.wordpress.com

形象
丢弃
形象
Fabio
编写者 最佳答案

Hi. I read about this problem of posted payments in v7 and apparently there are discussions (question 4377) and bugs (bug 115497 in launchpad) open on it.

Yet, I am now on v6.1 and I feel a little lost understanding which of the two interfaces I mentioned I should use and when. Is it the normal process to create a new statement using the "Periodical Processing > Statements > Statements Reconciliation" and import there all the already reconciled entries (payed invoices and other entries not resulting from invoices) and then open the same statement in the other interface "Bank and Cash > Bank Statements" and complete it? Are there other better ways?

Thanks

形象
丢弃
相关帖文 回复 查看 活动
Reconciliation of part of the account is blocking any further reconciliation
reconciliation bank statement
形象
1
3月 15
4417
How to reconcile bank operations from statements of 2 different bank accounts ? V13
reconciliation bank statement V13
形象
形象
1
9月 21
4550
wrong transaction in bank reconciliation 已解决
reconciliation bank
形象
形象
1
1月 23
4288
Select supplier invoice number on bank statement to reconcile
bank statement
形象
1
10月 24
3329
Problem Reconciliation Bank
reconciliation bank
形象
形象
1
3月 15
5951