openerp-community team mailing list archive

["Fabrice Henrion" <fhe@xxxxxxxxxxx>]

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: openerp-community-bounces+fhe=openerp.com@xxxxxxxxxxxxxxxxxxx
[mailto:openerp-community-bounces+fhe=openerp.com@xxxxxxxxxxxxxxxxxxx] On
Behalf Of Phil Frost
Sent: Friday, January 18, 2013 10:55 AM
To: openerp-community@xxxxxxxxxxxxxxxxxxx
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     : openerp-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp