Hello, We are aware that there is a limitation with OpenERP 7 on these operations. We have identified it and we are working on it (no ETA though). We also acknowledge that certain misleading terms might need to be changed in this context. As you have pointed out, some process flows require 2 steps when "reconciling". The first step reconciles customer invoices with customer payments, and the 2nd step reconciles (or should I say "compares" or "cross-checks") a bank statement that you create in OpenERP by importing "things" with the paper statement you receive in the mail from your bank.
In OpenERP 6.1, these "things" can be: - customer invoices, in which case a customer payment will be created and a journal entry will take place at the time of import. This is done through Accounting > bank & Cash > Bank statements, or - customer payments. This is done through Accounting > Periodical processing > Statements > Statements reconciliation The problem is that it can be either one of these, not both on the same view, which makes it impossible to compare the starting and ending balance of the OpenERP statement vs. the paper statement if you are dealing with both open invoices and posted payments. In OpenERP 7.0, for some reason the import of customer payments has been removed. Also be aware that in OpenERP 6.1 and 7.0, the concept of deposit ticket for customer payments doesn't exist. However it exists for supplier payments but this is another topic. We have started a new module called account_deposit that allows to manage deposit tickets for checks and cash, or credit cards transaction batches. This is still in development stage and the branch is here: https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-account_depo sit-jam In my opinion, we need to solve the following issues to have a working bank statement reconciliation flow: - introduce the concept of deposit ticket (with account_deposit). - have only one view for the bank statements reconciliation that allows to import open customer invoices, posted payments, or posted deposit tickets. This view will allow to compare the starting and ending balances. - probably improve the matching algorithm between the csv downloaded from the bank website and the records in OpenERP (based on amounts comparison and string distance). - reuse the conflict management mechanisms of the interactive reconciliation of the banking-addons (from http://www.youtube.com/watch?v=qJ5YYBJOeHM ). - change the terms to make them more meaningful according to en_US practices. Best, __ Fabrice Henrion Director of Business Development Americas OpenERP Inc. 260 Main Street - Suite 203 Redwood City, CA 94063 Tel: +1 (650) 307-6736 http://www.openerp.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Phil Frost Sent: Friday, January 18, 2013 10:55 AM To: [email protected] Subject: Re: [Openerp-community] Seeking clarification on reconciliation functionality in 7.0 I thought it might help to have a specific example of the sort of error I'm trying to catch. Say I invoice a customer for $100. Then, I receive a check for $100 in the mail. I register a payment against the invoice, and now the invoice is reconciled. Later, I take that check to the bank. But, accidentally I write the amount to deposit as "$10" instead of "$100" at the bank, but I enter the correct amount of "$100" in our accounting system. Now, my records don't match the bank records of the same account. How do I audit the bank statement from the bank to catch this error? _______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
