Community mailing list archives

community@mail.odoo.com

Re: Reconciling credit card processing deposits

by
Fabrice Henrion (fhe)
- 10/31/2014 21:27:15
Hello,
This is a known limitation.

I've added the concept of deposit ticket to the v9 accounting spec.

We had spec'd deposit tickets last year on v7:
Functional spec: https://drive.google.com/file/d/0B13bY1DPCeBqUk5qMmJheDlmRDA/view?usp=sharing
Technical spec: https://pad.odoo.com/p/r.h0nPfCv9zimYlkCT
Branch: https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-account-deposit

This branch was on trunk so you might have to update it.

Even if it doesn't work, it's probably the closest to what you want and what you might want to start from if you intend to develop a custom module.

Best,

__
Fabrice Henrion
Director Americas

Odoo Inc.
51 Federal Street – Suite 401
San Francisco, CA 94107
Tel: +1 (650) 307-6736

On Thu Oct 30 12:42 PM, Chris Jones wrote:
<blockquote cite="mid:CAK1zTiad3WwP8ESobTr0jsKhu1-Kj9MGSAkhTnZX=YTzgPKR2A@mail.gmail.com" type="cite">
I've been struggling with this issue for 9 months now, talked to a half dozen developers and read every inch of documentation and have tried a ton of different addons and still can't find a good solution. It's getting to the point where I might just integrate with Xero and ditch OpenERP for accounting. 

Here's the scenario.

Credit Card processor sends over nightly batches for all processed transactions for that day. Let's say there are two credit card payments processed, $400 and $600. They wire a $1000 deposit. 

As soon as the payments are received the Customer Invoices are marked as paid using the Register Payment button. 

At the end of the month the bank statement is imported and the $1000 deposit shows up. 

If I leave the $1000 deposit in the bank statement I end up with double income. Otherwise I have to delete the $1000 deposit from the bank account and replace it with the two invoices using the Import Invoices function. But for that to work I have to go back and delete the Customer Payments so that the Invoices are Open again. 

If I don't use Register Payments it's difficult to keep track of which invoices have been paid until the end of the month. 

I've built a module that automates invoice reconciliation for credit card payments but it only works with the credit card processor Bluepay. I'm looking for a solution for those not using Bluepay. 

I tried the npg_account_make_deposit and npg_bank_account_reconciliation addons but they didn't seem to solve the issue. 

Thoughts? 

--
Chris Jones
SaaSier.com
Open Source ERP Solutions
310-400-0256

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe