openerp-expert-accounting team mailing list archive

["pap\(openerp\)" <395194@xxxxxxxxxxxxxxxxxx>]

Hello John,

Currently "paid/reconciled" checkbox is checked when all move lines(in current invoice move) on invoice account are reconciled.i.e. consider 3 lines on an invoice SAJ/2010/001 with invoice account 'Debtors Account':
                 1) line 'Basic PC' with account 'product sales(type=regular)'
                 2) line 'Medium PC' with account 'product sales(type=regular)'
                 3) line 'Test Invoice' with 'Debtors Account(type=receivable)

when line 3, i.e. a line with account as invoice account('Debtors
Account') is reconciled, the invoice will be reconciled and paid i.e.
"paid/reconciled" checkbox will be checked.

We have two cases:
1) invoice account is not same as partner receivable account:
        In trunk the payment is done using account voucher, which uses move line account(not the partner account) to make payment, hence reconciling line 3 and thus the invoice. So there is no issue for now.

2) cancel and change the account in posted entry 3(we change account to some other receivable account say 'Account X'):
       In this case, though voucher payment will reconcile move line 3, but as its account(Account X) is not same as invoice account(Debtors Account), invoice will not be reconciled. The patch attached will resolve this issue. It will return the receivable and payable move lines and not the invoice account lines of the invoice. If all receivable and payable move lines of an invoice are reconciled, the invoice state will change to Paid/Reconciled.

I hope you getting the logic implemented for Paid/Reconciled state. 
Need expert comments/suggestions.

Thanks.

-- 
account invoice reconcile (paid state)
https://bugs.launchpad.net/bugs/395194
You received this bug notification because you are a member of OpenERP
Accounting Experts, which is a direct subscriber.

Status in OpenObject Addons Modules: New

Bug description:
"paid & reconcile" checkbox on invoices is marked if account lines are based on the same account number that invoice (come form partner).
But after invoice is done and accounted, we cant still change account number (for customer ; due to parameters mistakes).

The trouble is that python code is look for the "old" account number. So event if the customer had already paid the invoice and bank account move line is correctly reconciled, the corresponding checkbox isn't marked.

We should look at accounts types instead of account numbers.

Another way to retrieve account move line corresponding to the total amount of invoice is to use 'payable' and 'receivable' types of accounts. This are the only ones that can be linked to partners.