[12.0] How to allow to mix accounts receivable and payable in bank reconciliation?

Hello,
I need to get receivable and payable accounts in bank reconciliation, for example, to "confirming" operations where the banks advance the invoice and at the same time I must pay to the bank expenses and bank interest.

Salut,
Josep M

[11.0] 'account.reconciliation' widget no longer exists

Hi,
as I wrote in the title, the account.reconciliation widget doesn't exist anymore in Odoo 11.0.

account-reconcile/base_transaction_id/static/src/js/account_widgets.js

Line 3 in 8e2b506

var AccountReconciliation = require('account.reconciliation');

For this reason, the base_transaction_id.base_transaction_id widget is never loaded and sometimes, under certain conditions, you'll get a blank page.

It might be useful?

let ReconciliationClientAction = require('account.ReconciliationClientAction');
let ReconciliationModel = require('account.ReconciliationModel');
let ReconciliationRenderer = require('account.ReconciliationRenderer');

Off-topic...

You should add account to the module's dependencies...

account-reconcile/base_transaction_id/__manifest__.py

Line 8 in 8e2b506

'depends': [

FileParser default value for extra_fields

#23 Introduced a problem in file_parser.py:

https://github.com/OCA/bank-statement-reconcile/blob/7.0/account_statement_base_import/parser/file_parser.py#L43

The parameter extra_fields is in fact mandatory as it is now, since it defines the conversion_dict and the keys_to_validate fields. Thus, it should not be named extra_fields anymore, but fields and should not take a None default value. If no value is passed, line 62 will raise an AttributeError (NoneType has no keys)

No bank list on res.partner.bank form from company form

On branch 7.0 with l10n_ch, l10n_ch_bank, l10n_ch_base_bank, l10n_ch_payment_slip installed, there is no more bank selectable in the bank field (but there is banks imported by l10n_ch_bank in the res_bank table in database).

Bank Statement reports have all Zero values - Odoo11 CE

Bank Statement reports have all Zero values except for Initial Balance in the Detail Report.

Recently upgraded client to Odoo11 CE. The bank reconciliation process works fine. It's just that the reports are blank in terms of amount. The detail report has every item, but zero values.

Install version of addon - 11.0.1.0.0

build broken in 7.0 since 2015

The 7.0 build is broken because of a missing 2014 fiscal year. I restarted the 7.0 build to show this.

Migration to version 9.0

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-9.0

Modules to migrate (alphabetically)

[9.0] account_mass_reconcile_transaction_ref broken since recent commit

The module won't work since this commit :
91a1aaf

The problem is that now, base_mass_reconcile call the method _base_columns on mass.reconcile.base but account_mass_reconcile_transaction_ref override _base_columns on mass.reconcile.advanced.
So the code of account_mass_reconcile_transaction_ref is not used anymore.

I don't get why it has changed?
@mreficent @mdietrichc2c

[ADD] account_reconcile_reconciliation_date

This module allows you to show the reconciliation date on the payment and the credit notes.

Usage

Create an invoice on 6/1 for 1,000$
Create a refund on 7/1 for 500$
Create a payment on 8/1 for 500$
Check the Aged Receivable report to make sure everything shows up in the right columns
Reconcile the invoice, refund and payment on 9/1
The reconciliation date (create_date of account.full.reconcile) shows up on the refund and payment.

Technical Specifications

account.invoice

Add a date field "Reconciliation Date" (reconciliation_date)
Show the field only if it is set

account.payment

Add a date field "Reconciliation Date" (reconciliation_date)
Show the field only if it is set

account.full.reconcile

Add a date field "Reconciliation Date" (reconciliation_date) with a default value set to now()
Extend the create method to set the reconciliation_date value on the same field in the related invoices and payments (using reconcile_line_ids).

[12.0][BUG] account_skip_bank_reconciliation?

On runbot, create Reconciliation Model:

Open reconcile mode, and observe:

Error:
Odoo Server Error

Traceback (most recent call last):
  File "/.repo_requirements/odoo/odoo/http.py", line 656, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/.repo_requirements/odoo/odoo/http.py", line 314, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/.repo_requirements/odoo/odoo/tools/pycompat.py", line 87, in reraise
    raise value
  File "/.repo_requirements/odoo/odoo/http.py", line 698, in dispatch
    result = self._call_function(**self.params)
  File "/.repo_requirements/odoo/odoo/http.py", line 346, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/.repo_requirements/odoo/odoo/service/model.py", line 98, in wrapper
    return f(dbname, *args, **kwargs)
  File "/.repo_requirements/odoo/odoo/http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "/.repo_requirements/odoo/odoo/http.py", line 941, in __call__
    return self.method(*args, **kw)
  File "/.repo_requirements/odoo/odoo/http.py", line 519, in response_wrap
    response = f(*args, **kw)
  File "/home/odoo/OCB-12.0/addons/web/controllers/main.py", line 962, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/home/odoo/OCB-12.0/addons/web/controllers/main.py", line 954, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/.repo_requirements/odoo/odoo/api.py", line 755, in call_kw
    return _call_kw_model(method, model, args, kwargs)
  File "/.repo_requirements/odoo/odoo/api.py", line 728, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "/home/odoo/OCB-12.0/addons/account/models/reconciliation_widget.py", line 210, in get_bank_statement_data
    results = self.get_bank_statement_line_data(bank_statement_lines.ids)
  File "/home/odoo/build/OCA/account-reconcile/account_reconcile_payment_order/models/account_reconciliation_widget.py", line 55, in get_bank_statement_line_data
    st_line_ids, excluded_ids=excluded_ids,
  File "/home/odoo/OCB-12.0/addons/account/models/reconciliation_widget.py", line 148, in get_bank_statement_line_data
    matching_amls = reconcile_model._apply_rules(bank_statement_lines, excluded_ids=excluded_ids, partner_map=partner_map)
  File "/home/odoo/OCB-12.0/addons/account/models/account_reconcile_model.py", line 624, in _apply_rules
    self._cr.execute(query, params)
  File "/.repo_requirements/odoo/odoo/sql_db.py", line 148, in wrapper
    return f(self, *args, **kwargs)
  File "/.repo_requirements/odoo/odoo/sql_db.py", line 225, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: missing FROM-clause entry for table "account"
LINE 20: ...id IN (7) AND st_line.name ILIKE '%Bank Fee%' AND account.ex...
                                                              ^

account.bank.statement.form show "Journal Entries" should be "Journal Items"

Hi, this is my first bug report so I hope I put it in the right place ...

When going to Accounting >> Dashboard >> Bank Statements and entering bank statement a quick button is on the top right corner taking you to the journal entries.

This button will be confusing / misleading if as example you have 2 entries in the bank to reconcile, income +200 and costs -100 the Journal Entries will show two lines with a sum of 300. Which is not correct. Either

one should see the balance amount of debit - credit on the bank account
one should see the balance of debit - credit but using the contra account (this is a form of display which is very helpful! as it does not show just a copy of the entries to the account, but how you actually reconciled the account).
The account journal lines (debits and credits) that were posted for that journal entry.

example link:
http://227775-10-0-c91c37.runbot9.odoo.com/web?debug#id=2&view_type=form&model=account.bank.statement&action=331&active_id=84

[7.0] Incompatibility between account_statement_ext and account_banking

I cannot install the module account_statement_ext together with the account_banking module, because both modules replace the field period_id in the view account.view_bank_statement_tree.

account_reconcile_reconciliation_date - Module description could be more precise

Hi everybody!

Module : account_reconcile_reconciliation_date
Version : 12

The general purpose is described as following : "This module is designed to help users track when invoices and payments are reconciled"

But what does that module actually do?

In what view can we see it in action? What information does it display? And where? Does it add some menu?

I tried running a runbot and it's still not clear. I noticed there is now a Reconciliation Date in the account.invoice form view. Would it be that? Or is there anything else?

If it's its only purpose, I would recommend the following description :
"This module is designed to help users track when invoices and payments are reconciled by adding a Reconciliation Date field in Invoice form view"

Thanks for you help!

Migration to version 10.0

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-10.0

Modules to migrate

Odoo (V13E) is not handling to mass reconcile records of 250k with account_mass_reconcile

I've got more than 250k of records which I'm trying to do a mass reconciliation, but it's not happening due to timeout. Is there any way to process it by batches?

Bug: account_partner_reconcile [12.0]

The modules is on my fresh and used intance not functionable.
I klick on "match payment" and i get only the smily face, nothing to do ...

How could i start a runbot-instance with this module to test ?

Cron for easy reconcile fails when a reconcile profile never ran

account_easy_reconcile.run_scheduler() fails when a reconcile profile has no history, because it tries to convert a None value to a date.

2014-08-24 19:01:23,878 23112 ERROR openerp openerp.addons.base.ir.ir_cron: Call of self.pool.get('account.easy.reconcile').run_scheduler(cr, uid, *()) failed in Job 52
Traceback (most recent call last):
  File "/srv/openerp/instances/openerp/parts/server/openerp/addons/base/ir/ir_cron.py", line 136, in _callback
    method(cr, uid, *args)
  File "/srv/openerp/instances/openerp/parts/bank-statement-reconcile/account_easy_reconcile/easy_reconcile.py", line 384, in run_scheduler
    reconciles.sort(key=_get_date)
  File "/srv/openerp/instances/openerp/parts/bank-statement-reconcile/account_easy_reconcile/easy_reconcile.py", line 376, in _get_date
    DEFAULT_SERVER_DATETIME_FORMAT)
TypeError: must be string, not None

[12.0] account_skip_bank_reconciliation breaks matching on payments

See video on runbot:
https://drive.google.com/file/d/141WuxkUkqNFjcALDnAzfmKtrhlqlEpGQ/view

When installing account_skip_bank_reconciliation payments are not matched anymore in bank statements.

@MiquelRForgeFlow @JordiBForgeFlow

allow_reconciliation on account with move_lines?

Would anybody know if there is an existing module, that makes it possible to switch allow_reconciliation on for accounts with existing move_lines.
If not would this be as simple as running the _amount_residual method for move_lines with this account? Or should I think of other things as well?

V8 migration

Hello,

We suggest to start the migration by this way :

merge of branch 7.0 with 8.0
fix conflicts and commit
start modules migration one by one

Any other suggestions ?

Cédric

EDIT current migration status:

Mistake in reconciliation

I created payment from customer = 500 usd
I created invoice to the same customer = 1000 usd
I did manual reconciliation, it works fine
but still the invoice not reconciled even balance equal to 500 (balance after manual reconciliation = 1000-500)
still outstanding payment appear in the invoice which is wrong

Automatic reconcile delete and replace some partial reconcile done by user manually

To reproduce:

Create a customer invoice for 10000 € to Customer X (customer account: 4110000) - Add a reference : ABC1234 and validate the invoice to book it into ledger
Pay partialy that invoice (8000€) using the bank statement...but fill in a different reference (XYZ789) - Confirm the bank statement - the payment entry will be posted.
Reconcile manually the invoice and the partial payment
Create a new bank statement to record a 2nd partial payment for that invoice (1500€) but this time the reference is the same than the one use on the invoice entry (ABC1234) .
Lauch the automatic reconcile on the receivable account

The bug is the following:

The system will create a partial reconcile between the invoice and 2nd payment without including the 1st payment done manualy reconciled (because this one do not have the same reference).
the initial partial reconcile is broken because linked to only 1 account move line (the other one being now reconciled with the 2nd payment)

[14.0] account-reconcile-widget Progressbar not visible

on runbot V14

expected result as on runbot V13:

From debugging in the browser:
V14 broken bar:

<div aria-valuemin="0" aria-valuenow="0" aria-valuemax="1" class="progress-bar" role="progressbar" style="width: 0%;"><span class="valuenow">0</span> / <span class="valuemax">1</span></div>

V13 bar:

<div aria-valuemin="0" aria-valuenow="0" aria-valuemax="1" class="progress-bar" role="progressbar" style="**width: 16.6667%**;"><span class="valuenow">0</span> / <span class="valuemax">1</span></div>

and

V14 broken bar:

<div role="search" class="o_cp_pager" role="search">

V13 bar:

<div role="search" class="o_cp_pager" role="search" **aria-label="Pager" style="width: 100%; padding-left: 0px;"**>

Provide bank statement reconciliation like Quickbooks

https://www.youtube.com/watch?v=MgF2nkWvKCQ

Migrate the module account_banking_reconciliation originally made by Nova Point Group and maintained by Ursa Information Systems.

Can't try bank_statement_journal_items module on Runbot (no menu leads to bank statements)

Hi,

I tried this module via runbot : https://github.com/OCA/account-reconcile/tree/13.0/bank_statement_journal_items

Here's the problem :
There is no submenu in Invoicing that leads to bank statements. Thus, it's impossible for a novice user (like me) to try this module via runbot.

Thank you for your work!

Migration to version 12.0

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-12.0

Modules to migrate

account_banking_reconciliation - By @murtuzasaleh - #268
account_mass_reconcile - By @ageficent - #235
account_mass_reconcile_by_purchase_line
account_move_reconcile_helper - By @Abranes - #246
account_partner_reconcile - By @bjeficent - #236
account_set_reconcilable - By @mreficent - #280
bank_statement_foreign_currency - ~~By @open-net-sarl - #241~~ By @jbeficent - #255
base_transaction_id - By @i-vyshnevska - #239

[14.0] not possible to reconcile with filled in partner bank account

Steps to reproduce:

Create or import a bank statement.
Create a statement line, fill in a partner and an account_number.
Validate the statement and do an reconcile.
In the reconcile widget perform an reconcile and press the validate button.

Following error is shown.


Fout:
Odoo Server Error

Traceback (most recent call last):
  File "/opt/odoo/custom/src/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 683, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 347, in checked_call
    result = self.endpoint(*a, **kw)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 912, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 531, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/auto/addons/web/controllers/main.py", line 1389, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/opt/odoo/auto/addons/web/controllers/main.py", line 1381, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/api.py", line 392, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/api.py", line 365, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "/opt/odoo/auto/addons/account_reconciliation_widget/models/reconciliation_widget.py", line 49, in process_bank_statement_line
    moves = st_line.with_context(ctx).process_reconciliation(
  File "/opt/odoo/auto/addons/account_reconciliation_widget/models/account_bank_statement.py", line 203, in process_reconciliation
    if self.account_number and self.partner_id and not self.bank_account_id:
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 639, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 315, in _handle_exception
    raise exception.with_traceback(None) from new_cause
AttributeError: 'account.bank.statement.line' object has no attribute 'bank_account_id'

Step to double check if it is coming from bank account number:
Go back to the statement. Set to draft. Edit the statement to delete the account number.
Validate the statement again. Do a reconciliation. Press the validate button.
No there is no error.

p.s. when a fix is made on this module. please see. #376

[13.0][BUG] Why account_mass_reconcile allow reconcile items with move's status = Draft, Cancelled ?

This module has long history, but it does surprise me that it reconcile even cancelled items. Is this intentional? And what is the rational?

[7.0] Accented characters in bank statement label field

The completion crashes if an accented character is present in a bank statement label field (when completing based on this field).

The problem is in line 273 of file account_statement_base_completion/statement.py:
re.escape(x.strip())

The escape method escapes accented characters leading to invalid SQL queries (they should not be escaped I think).

I don't know how to fix this problem...

account_banking_reconciliation module - Report enhancements requests

While all the data IS available in the actual process of the bank reconciliation, the reports, both summary and detail are both missing vital parts. In particular, it is missing the Uncleared data and is also missing the name of the statement or something to identify when the report is printed, which account the report applies to.

Comments from my accountant and their auditors.
"the reconciliation should show the uncleared item of $30

it is usually in the sequence
balance as per general ledger $19223.96
add uncleared cheques $30
balance as per bank statement $19253.96

The odoo report does not appear in this format.
It should at least show the uncleared item "

Conflicts between repo?

Hi,

Is there really useful to have import ofx in this repo as it already exists in https://github.com/OCA/bank-statement-import and it's already port to v9?

regards

[11.0] account_reconciliation_widget_partial module not do a partially reconcile.

Thanks for this module. I have tried this module and I was able to modify the amount and see the difference but when I click on Reconcile button and check the journal entry I see that the whole amount in the reconciled not the partial amount.

Please check the screencastify for my work:
https://drive.google.com/file/d/1WJB6A56D-thmlW_iL25P3moDvScTCJHu/view

Kindly check and advise if I understood the module function/logic correctly or not!

Migration to version 11.0

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-11.0

Modules to migrate

Missing labels needs fixing and needs review

Read OCA/maintainer-tools#29 to know more about it

[8.0] [account_easy_reconcile] partial reconciliation not working

In 8.0 partial reconciliation is not happening. In v7 it used to work.

Root cause:
base_reconciliation.py, in method "_reconcile_lines" calls to account move line method "reconcile" instead of "reconcile_partial".

Migration to version 14.0

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-14.0

Modules to migrate

account_mass_reconcile
account_mass_reconcile_by_sale_line - By @dnplkndll - #434
account_partner_reconcile
account_reconcile_payment_order - By @CarlosRoca13 - #457
account_reconcile_restrict_partner_mismatch
bank_statement_journal_items

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

[13.0] [Fonctional BUG] "bank_statement_journal_items" View miss the account move lines sourced by account.paiement reconciled

Context :
OCB 13.0 Odoo Server up to date [(07/30/2020),]
Virgin database , to reproduce issue faced on my test environnement.
Also !! >> Get same bug on runbot : http://3432790-13-0-d7682b.runbot2-2.odoo-community.org

Considering "bank_statement_journal_items", is installed, and user have:

Show Full Accounting Features

Module feature is usefull ; So, the module do the job, exept if in bank staement, we reconcile an "account.payment" line.

Steps to reproduce :

From an invoive form, register a payment by bank journal ; then now, you suppose to retreive your account.payment line in a futur bank statement..
Now , let say i want to make a new bank statement, so i create it and i proceed by reconcile the payment blue line shown in bank_statement_reconciliation_view
Now from "account.bank.statement form"go to "Journal entry" smart button : Everything ok in this view, all my journal entries are there, balance is ok

Then, return to the form, and click to "Journal items" smart button : Look the wrong unbanced total ; because a move line is missing (the move in reference of an "account.payment" reconciliation )

@ajaniszewska-dev
@fclementic2c
.

.

.

.

Import of remitance

Hi all

I would like to share with you some idea about credit card remittance, marketplace remittance.

My customer sells on 3 marketplace and also on his own website.
This generate a lot of invoice per day and each day or week depending of the sale channel he receive a transfer for all the invoice paid

How I work on 6.1 and 7 version

For now we use the bank_statement_import framework combine with the module account_statement_one_move, in order to generate only one move with all the detail in the customer account (I mean one acccount.move.line per line on my credit card remittance) and a counterpart of the total amount in a transfer account (in French 581CB).

Afterwards I import the bank statement (the real on from my bank account) and it generates a move per line and in one of this line I have the total amount of the remittance that will go to the transfer account

As a picture is sometime the best explication, the flow is the following:

So with a simple exemple I have:

2 invoices (one with an amount of 100€ one with 50€)
one CB remittance with 2 lines (a line with 100€ and a line with 50€)
a bank statement with a lot of line and inside a transfer of 150€ for the sum of the CB remittance

Each invoice will be reconcile with a account.move.line of the remittance and the conterpart of the remittance will be reconcile with the account.move.line of the bank.statement

The reconciliation process is done automatically with account_easy_reconcile (and account_advanced_reconcile if need)

So it's work perfectly and Richard is an happy manager

Note : Why account_statement_one_move exist?

Note for sure we can also avoid using the module account_statement_one_move and in this case you have the following move

This flow is totaly correct in a point of view of accounting. And we can use this flow with the new bank statement framework of odoo.
But the difference is in case of huge volume of data we have two issues

odoo is slow (but we can always fix it), in a case of a remittance of 500 lines you have 1000 account.move.line instead of 501 lines
the accountant do not like this solution, "why doing a move for each line of my remittance?" I just need a move with all the line. Indeed the first solution is easier to understand for an accountant and reading the data in the account is more easy (less lines in the transfer account)

My personal point of view from my experience.

At the beginning my customer what using the second solution and after some complain from customer accountant, I propose and migrate one customer on the first solution. After some feedback I have migrated all of my customer on the first solution and I am read to spend time to have the same behaviour on 8 and 9 because it really worth. Moreover I can not propose to my customer to go back to the previous solution, I want to keep Richard happy !

You think is not worth

We live in a democratie and as both solution work, you are right and I am right ;). In my case I follow my customer need, so I will go in that direction (or an third solution if you have a better one ;) )

Now I need to port this to 8 and 9 version

First I really like the way we process the bank statement in version 8. But for the bank remiitance the new frameork will be not compatible with the module account_statement_one_move

With CamptoCamp we had some discussion about not processing the remittance using an account.move but with a different object (batch reconcile) that can flag the invoice in order to check what have been paid. Indeed in the real live card/marketplace remittance can have more than 500 lines so it's a lot of move line in the accounting. Avoid the generation of such amount of line can be a good thing

But as always customer have crazy flow and now I have to manage remittance that are not reconcile with only one invoice but For a same partner I can have 2 invoice with 2 payment with 2 different method like

one invoice of 200€ and a bank transfer of 180€
one invoice of 100€ and a CB payment of 120€
So using move (bank transfer) and batch reconcile (CB payment) will be a nightmare for solving this case.

The v7 community bank statement import is missing me :'(

What we need

In fact I do not really need v7 community bank statement import.

But what I really need is to generate an account.move from a CB remittance or a marketplace remittance. I do not need some extra object. I just need this and nothing more

What we plan to do

We want to :

convert the module account_bank_statement_base_import into a module account_move_base_import and make it as simple as possible (no more import profile but just some extra field on the account journal). This module will be as generic as possible in order to simplify the import of account.move from accounting software, payroll....
create a module account_move_remittance_import : This module will add some method and field on the journal for importing remittance, add the support of commission... well everything need for importing a card remittance
create a module account_move_base_completion : This module will autocomplete the remittance based on the transaction_id or sale order name (complete the partner_id on the account.move.line)

We have just started to extract some module from this branch in order to develop the new module based on it the branch is here : https://github.com/akretion/account-move-base-import

What do you think?

Fix PEP8 on 7.0 branch

I'm going to do it, so this is a message to avoid duplicating work.

[14.0] not possible reconcile after odoo/odoo@80c2818

Hi,

I do not know exactly if this issue should be post here or in odoo repository.

The thing is that after this commit was posted: odoo/odoo@80c2818#diff-1e3bd6be3bfb83a37ec9fb800ce8b1c95afe0be90ff792874ae7299c320a2f6e

I am not able to reconcile any journal item.
The steps to reproduce the error are the next ones:

Create an invoice (to reconcile with)
Create an item in a bank or cash journal
Publish the entry
Try to reconcile the invoice in the step 1 with the journal entry.
You get the error "The entry ... is already posted"

It seem that is due to the next line:
https://github.com/odoo/odoo/blob/1bf2e8805503d9bbebec58df9933abab3db70bd2/addons/account/models/account_move.py#L2436

if move.state == "posted":
raise UserError(_('The entry %s (id %s) is already posted.') % (move.name, move.id))

What so you think? Any ideas of how to solve this?

Please let me know if I should put this issue in the odoo or is ok here.

Weird behaviour of account_invoice_reference with customer invoices and structured references

Hi,

While testing account_invoice_reference, I noticed a weird behaviour of the module wrt structured references (and l10n_be_invoice_bba in particular).

Modules generating structured reference for specific values of reference_type tend to put the structured reference in the... reference field.

With this module, since the name and reference fields are swapped on customer invoices this gives a weird behaviour as illustrated on this screenshot.

What do you think?

Blank pdf report using account_banking_reconciliation

Hello,
i am facing an issue on Odoo 12 community using account_banking_reconciliation module. PDF reports "bank Statement details" are blank/empty...I am wondering why ? Anyone may have an idea, please ? Thank you for developpement and attention. Laurent.
Bank Statement-Detail (25).pdf

Bad encoding in account_statement_base_completion/i18n/fr.po

The encoding of the file bank-statement-reconcile/account_statement_base_completion/i18n/fr.po is broken ; all accents are badly displayed.

account_skip_bank_reconciliation no translation files

For account_skip_bank_reconciliation the translation files are not generated, so I can't translate.

Put 8.0 branch as default and remove master

@yvaucher can you do this? Anyone?

[account_banking_reconciliation] Question

I'm testing this module, but when the account is in a foreing currency, it closes the currency amount pretty well, but base currency is not closing very well. How can I specify the ending balance in base currency?

Am I missing something?? (check the images below)

Migration to version 13.0

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-13.0

Modules to migrate

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

[7.0] Easy reconcile module -> do not work if secondary currency set on account

If you create a easy reconcile on an account with a secondary currency you will get a message : You have to prive an account for the write off/exchange difference entry.
Even if you set these account in settings / accounting, it does not prevent you to get this message.

see my print screen (the main currency is in CHF and the EUR is a foreign currency in this exemple)

[12.0][BUG?] account_reconcile_rule: exception when loading reconcile list with lines that match any rule

(On production instance, did not yet try to reproduce on Runbot)

Error:
Odoo Server Error

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 1049, in get
    value = self._data[key][field][record._ids[0]]
KeyError: 'createLine1915'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1012, in __get__
    value = record.env.cache.get(record, self)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 1051, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ("account.move.line('createLine1915',).credit", None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 656, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 314, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise
    raise value
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 698, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 346, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 98, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 941, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 519, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 962, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 954, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 755, in call_kw
    return _call_kw_model(method, model, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 728, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "/opt/addons/account_reconcile_rule/models/account_reconcile_rule.py", line 164, in models_for_reconciliation
    rules = self.find_first_rule(statement_line, move_lines)
  File "/opt/addons/account_reconcile_rule/models/account_reconcile_rule.py", line 137, in find_first_rule
    balance += move_line.credit - move_line.debit
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1016, in __get__
    self.determine_value(record)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1119, in determine_value
    record._prefetch_field(self)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2865, in _prefetch_field
    result = records.read([f.name for f in fs], load='_classic_write')
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2803, in read
    self._read_from_database(stored, inherited)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2930, in _read_from_database
    cr.execute(query_str, params)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 148, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 225, in execute
    res = self._obj.execute(query, params)
psycopg2.DataError: invalid input syntax for integer: "createLine1915"
LINE 1: ...count_move_line" WHERE "account_move_line".id IN ('createLin...
                                                             ^

Remove account_statement_ext from the repository

As stated in #34, most of the functionality is in the new import framework, and some missing features are being handled here: OCA/bank-statement-import#4

oca / account-reconcile Goto Github PK

account-reconcile's People

Contributors

Stargazers

Watchers

Forkers

account-reconcile's Issues

Todo

Modules to migrate (alphabetically)

Usage

Technical Specifications

account.invoice

account.payment

account.full.reconcile

Todo

Modules to migrate

Todo

Modules to migrate

Todo

Modules to migrate

Todo

Modules to migrate

How I work on 6.1 and 7 version

Note : Why account_statement_one_move exist?

My personal point of view from my experience.

You think is not worth

Now I need to port this to 8 and 9 version

What we need

What we plan to do

Todo

Modules to migrate

Recommend Projects

Recommend Topics

Recommend Org