NBP released simple Web API for taking currency exchange rates. Please update module currency_rate_update to take data from this more reliable source.
Currently data from NBP is taken from released once a day xml files which need parsing.
Web API allow to get data both in XML and JSON with easy access through HTTP GET. More information available on http://api.nbp.pl/en.html.

Thanks!

Hi, Just Installed This module and Im Receiving this error:
Odoo Version 8.0

Uncaught TypeError: viewclass is not a function
/web/js/web.assets_backend/7812b85:3143

Try it: You have to go to Accounting -- Journal Entries -- Journal Items Search All
http://111428-8-0-0ea130.runbot.odoo.com/web?db=111428-8-0-0ea130-all

Hi OCA,

I have used currency_rate_update module, it’s a great module to update currency rate automatically.

But I found a problem, sometimes we get the wrong rate.

As for your info, My database has a multicompany configuration
my first company base currency is CNY,
My second company base currency is HKD
And we choose yahoo provider to update the currency.

The problem is sometimes we get the wrong rate.

Why did this happen? Is it a bug from the module?

As my point of view, there’s no problem if we failed to has the update rate on that day, but if we get the wrong rate it’s a big problem for us.

We used this module on each our customer database, and Its very big problem if we got this wrong rate.

Is there someone that has this kind of problem?

I have check it manually on the yahoo website, and the rate is right in there.

I have look on the log, and there's no error in that day.

Is it because I run the scheduler as administrator?
and the system mistakely update the rate based on first company?
but why its not always happen? just sometimes we get the wrong date.

After all, in our other database that not have multicompany configuration.
We find a similar problem too, so I think its not because of multicompany.

Configuration set to automatic update.
Using Bank of Canada to update USD currency but getting this error when trying to refresh currency:
ERROR : except_orm(u'Error !', u'Exchange data format error for Bank of Canada - USD !')

• module: account_journal_entry_posted_async
• version: 7.0

Current behavior

When clone this repository to server and start openerp-server, the following error is logged and 'No handler found' is shown on web.
Although no database has installed this module, openerp-server could not been started.

2016-02-25 12:27:19,412 114 CRITICAL ? openerp.modules.module: Couldn't load module web
2016-02-25 12:27:19,412 114 CRITICAL ? openerp.modules.module: job() got an unexpected keyword argument 'default_channel'
2016-02-25 12:27:19,412 114 ERROR ? openerp.service: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
  File "/opt/openerp/server/openerp/service/__init__.py", line 60, in load_server_wide_modules
    openerp.modules.module.load_openerp_module(m)
  File "/opt/openerp/server/openerp/modules/module.py", line 415, in load_openerp_module
    getattr(sys.modules['openerp.addons.' + module_name], info['post_load'])()
  File "/opt/openerp/server/openerp/addons/web/http.py", line 628, in wsgi_postload
    openerp.wsgi.register_wsgi_handler(Root())
  File "/opt/openerp/server/openerp/addons/web/http.py", line 517, in __init__
    self.load_addons()
  File "/opt/openerp/server/openerp/addons/web/http.py", line 580, in load_addons
    m = __import__('openerp.addons.' + module)
  File "/opt/openerp/server/openerp/modules/module.py", line 133, in load_module
    mod = imp.load_module('openerp.addons.' + module_part, f, path, descr)
  File "/opt/openerp/addons/account-financial-tools/account_journal_entry_posted_async/__init__.py", line 2, in <module>
    from . import models
  File "/opt/openerp/addons/account-financial-tools/account_journal_entry_posted_async/models/__init__.py", line 2, in <module>
    from . import account_move
  File "/opt/openerp/addons/account-financial-tools/account_journal_entry_posted_async/models/account_move.py", line 58, in <module>
    @job(default_channel='root.account_move_validate')
TypeError: job() got an unexpected keyword argument 'default_channel'

config file is as follows.

[options]
addons_path = openerp/addons,../addons/e-commerce,../addons/connector,../addons/connector-magento,../addons/product-attribute,../addons/sale-workflow,../addons/connector-ecommerce,../addons/partner-contact,../addons/account-financial-tools
admin_passwd = ******
csv_internal_sep = ,
db_host = 
db_maxconn = 64
db_name = False
db_password = ******
db_port = False
db_template = template1
db_user = openerp
dbfilter = .*
debug_mode = False
demo = {}
email_from = False
import_partial =
limit_memory_hard = 805306368
limit_memory_soft = 671088640
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 120
list_db = True
log_handler = [':INFO']
log_level = info
logfile = /var/log/openerp/openerp-server.log
login_message = False
logrotate = True
max_cron_threads = 2
netrpc = False
netrpc_interface =
netrpc_port = 8070
osv_memory_age_limit = 1.0
osv_memory_count_limit = False
pg_path = None
pidfile = None
proxy_mode = True
reportgz = False
secure_cert_file = server.cert
secure_pkey_file = server.pkey
server_wide_modules = web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
static_http_document_root = None
static_http_enable = False
static_http_url_prefix = None
syslog = False
test_commit = False
test_enable = False
test_file = False
test_report_directory = False
timezone = False
translate_modules = ['all']
unaccent = False
without_demo = False
workers = 0
xmlrpc = True
xmlrpc_interface =
xmlrpc_port = 8069
xmlrpcs = True
xmlrpcs_interface =
xmlrpcs_port = 8071
odoo_connector_channels = root:4,root.account_move_validate:1

@lmignon If you have ideas, could you please let me know the reason and how to deal with it?

While investigating why travis was red on #48, it appeared it is due to a missing ACL on credit.control.dunning.fees.computer (in module account_credit_control_dunning_fees).
https://travis-ci.org/OCA/account-financial-tools/jobs/36345695

I started to add it when I noticed it was a bit of a special Model. At first glance I had the impression that it could be modified to be a TransientModel (which would lift the issue of the ACL), but I don't fully understand why it is built this way.

So I pass the ball.

I ran the script with erppeek as suggested.
It is already stuck for 12 hours with CPU level of Python at 100%.

In the beginning I could still use the server, but not anymore, it has become unresponsive.

Should I wait for the script to finish or is it a lost cause?

For example, I use accout_auto_fy_sequence with the module donation_tax_receipt ; the tax receipts use a sequence with "%(fy)s". When a regular user creates a tax receipt, if he is the first to do it for a fiscal year, he will get an access rights error pop-up that says that he doesn't have "create" access on ir.sequence:

Sorry, you are not allowed to create this kind of document. Only users with the following access level are currently allowed to do that:

• Point of Sale/Manager
• Administration/Settings
  (Document model: ir.sequence)

The reason is obvious: In account_auto_fy_sequence/ir_sequence.py, a call to _next() may lead to the automatic creation of a new ir.sequence, and this creating is made with the uid of the current user... and only members of Administration/Settings have "create" rights on ir.sequence.

So I think that the creation should be made with SUPERUSER_ID

Hello there,
I have account_constraints installed. I don't find a solution to generate my opening entries in my accounting.
I always get this error. How to correct the situation?

Error :
_('You cannot do this on an entry generated by a bank'
' statement. '
'You must change the related bank statement'
' directly.\n%s.') % err_msg)

My project use this one and today I had next error:

  File "./odoo-8.0/openerp/http.py", line 1308, in load_addons
    m = __import__('openerp.addons.' + module)
  File "./odoo-8.0/openerp/modules/module.py", line 80, in load_module
    mod = imp.load_module('openerp.addons.' + module_part, f, path, descr)
  File "/home/travis/account-financial-tools/account_move_batch_validate/__init__.py", line 23, in <module>
    from . import account  # noqa
  File "/home/travis/account-financial-tools/account_move_batch_validate/account.py", line 28, in <module>
    from openerp.addons.connector.queue.job import job
  File "./odoo-8.0/openerp/modules/module.py", line 79, in load_module
    f, path, descr = imp.find_module(module_part, ad_paths)
ImportError: No module named connector

This is by next issue:
odoo/odoo#7507

This needs to add a try-except ImportError: log.debug sentence similar to CONTRIBUTING.md#importerror to don't force my project to use other one that we don't use.

Hello,

While playing around with account_move_batch_validate, I noticed it does not post moves in chronological order.

The problem is similar with account_move_validation_improvement.

The official wizard has an order by 'date'.

I believe this can create issues in some situations. However this is not easy to resolve in a multi-worker environment, or in the presences of retries.

What are your thoughts about this? cc/ @nbessi @gurneyalex @lepistone

I have a crash when creating a new partner:

 File "/home/odoo/erp/odoo/openerp/addons/base/res/res_partner.py", line 573, in create
    partner = super(res_partner, self).create(vals)
  File "/home/odoo/erp/odoo/openerp/api.py", line 239, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/odoo/erp/odoo/openerp/api.py", line 463, in new_api
    result = method(self._model, cr, uid, *args, **kwargs)
  File "/home/odoo/erp/odoo/addons/mail/mail_thread.py", line 381, in create
    thread_id = super(mail_thread, self).create(cr, uid, values, context=context)
  File "/home/odoo/erp/odoo/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo/erp/odoo/openerp/api.py", line 336, in old_api
    result = method(recs, *args, **kwargs)
  File "/home/odoo/erp/odoo/openerp/models.py", line 4076, in create
    record = self.browse(self._create(old_vals))
  File "/home/odoo/erp/odoo/openerp/api.py", line 239, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/odoo/erp/odoo/openerp/api.py", line 463, in new_api
    result = method(self._model, cr, uid, *args, **kwargs)
  File "/home/odoo/erp/odoo/openerp/models.py", line 4267, in _create
    recs._validate_fields(vals)
  File "/home/odoo/erp/odoo/openerp/api.py", line 239, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/odoo/erp/odoo/openerp/models.py", line 1281, in _validate_fields
    raise ValidationError("Error while validating constraint\n\n%s" % tools.ustr(e))
ValidationError: ('ValidateError', u"Error while validating constraint\n\n'module' object has no attribute 'ValidationError'")

The cause of the issue is in account-financial-tools/account_credit_control/partner.py on the last line : "api.ValidationError" is not good. @guewen it seems you are the author of this code...

By the way, @api.constrains('credit_policy_id') needs to be updated to @api.constrains('credit_policy_id', 'property_account_receivable') (it is works to invalidate on a property field).

Hello,

I coded a small improvement on your module
new field : target_amount
You can then filter checks so your remittance will reach just above this target amount
How can I share ?

I am using the currency_rate_update module on Odoo 8.0.20150330.

My base currency is GBP and I have additional working currencies USD and EUR. I am using the ECB update method.

For "currencies to update with this service" I have set USD and GBP. I am unable to select a EUR option. Now I realise that the ECB rates provided are conversion rates from foreign currencies to Euros. But from my perspective as a GBP base currency user it is EUR and USD which I wish to update. The correct EUR update from my perspective is 1/GBP rate.

The USD update appears to be correct. For instance for 9/4/2015 I have 1.482389, and xe.com is telling me that the spot rate as I write is 1.47153. So currency_rate_update appears to be understanding that my base currency is GBP and making the appropriate adjustments using the EUR:USD rate and the EUR:GBP rate to get the GBP:EUR. It is just not able to do a similar adjustment to create a GBP:EUR rate.

Given that the ECB feed provides sufficient information to provide Base currency to EUR exchange rates, it should be possible to select EUR as a rate to update if the base currency != EUR.

Installed in Odoo8 the currency rate update module version 8.0.0.7

But after hitting the Refresh currencies button there are errors messages in the log
Like this:

AttributeError("'YAHOO_getter' object has no attribute 'MOD_NAME'",)
AttributeError("'ECB_getter' object has no attribute 'MOD_NAME'",)

And currency is not updated

so, what goes wrong.

module: account_reset_chart
version: 8.0

• Module installed on database with Swiss account chart

Current behavior
Run the part of code provided
`import erppeek

host = 'localhost'
port = '8069'
admin_pw = 'admin'
dbname = 'test'

client = erppeek.Client('http://%s:%s' % (host, port))
client.login('admin', admin_pw, dbname)
client.execute('res.company', 'reset_chart', 1)`

I've get this error
`xmlrpclib.Fault: <Fault warning -- Integrity Error

The operation cannot be completed, probably due to the following:

• deletion: you may be trying to delete a record while other records still reference it
• creation/update: a mandatory field is not correctly set

I think asset location needs to be added to asset... if the OCA team is in agreement I can do this and create a PR

The exchangerates i have put for USD and EUR arent updating.

• company default is set to Peruvean Sol (PEN)
• workers are running and i see the automated action "Currency Rate Update" being updated to a new day 1 day ahead.

but the log of the webservice on the accounting -> Currency Rate -> Updatecurrency.rate.update.service,1 stays empty and the one time set exchangerate isnt changing.

am i missing something?

Hi,

https://github.com/OCA/account-financial-tools/blob/8.0/currency_rate_date_check/currency_rate_date_check.py#L76

rate_date_dt is always a date object (line 76)

if the date in context is equivalent to a datetime, date_dt will be a datetime object (line 80)

and that will raise an exception in line 82 (TypeError: unsupported operand type(s) for -: 'datetime.datetime' and 'datetime.date')

In branch 7.0 both dates are datetime instances. Why was it changed for 8.0?

When printing the Partner Ledger from the Partner view, the standard report is printed, even when account_financial_report_webkit is installed.

Expected behaviour: the webkit report should be printed from that menu too.

I have played around with account_check_deposit and I like it overall. But to my understanding, the counterpart move line should be using account_id form Account Journal of the selected Bank, isn't it?

Now, I see the system always use "Account for Check Deposits" from company, and ignore what ever Bank user selected.

Am I missing something?
Thank you,

I'm attempting to migrate currency_rate_update to 9.0c. I think I'm about 75% done.

The one area I am stuck on is the _compute_multi_curr_enable method of res_company.

company_id no longer appears to be a property of the res.currency model. It is not clear to me what this method is intended to indicate. Multi-currency functionality for the company is indicated by the "Allow multi currencies" setting in Accounting | Settings.

_compute_multi_curr_enable is used in Currency_rate_update_service._onchange_service to modify a currency list based on this property.

Any pointers?

Thank you

One of the purpose of the module account_constraints is to prevent users to validate accounting entries with a mismatch between the debit or credit amount and the amount in currency:

• in case of credit, you must have a positive amount in currency
• in case of debit, you must have a negative amount in currency
  This constraint avoid mistakes when users post manual entries.

We recently had 2 corner cases which are possibly in conflict with this module ; at least we are wondering how to handle it the best way.

Case 1:
Assumptions
Your company currency is in EUR
You have created in your chart of account the following account 'Supplier in USD' (with the secondary currency 'USD' set on this account.

Scenario
On the 18-Mar, you have posted in your ledger a supplier invoice for 1608$ - The exchange rate that day was 1.1045
On the 23-Apr, you receive the payment of 1608$ on your EUR bank account - The exchange rate that day : 1.1235

Problem: The amount in currency is negative while this line is a debit -> The constraint will block validation of the entry.

In my view, I consider the -11.96 USD as wrong information (imagine a have received a 1st partial payment in GBP for example...which relevant amount currency the system could calculate?) so it should be 0 I think.
However, we could maybe force it to 0 USD but:

• 1 the fix would be a bit ugly since we have a secondary currency on the account the amount in currency is mandatory (so calculated anyway)
• 2 what about the cumulative balance in currency in the financial reports webkit, the information will not be consistent so it will be meaningless (not even helpfull to calculated the exchange rate provision/revaluation for the closing).
  In fact I even wonder the pupose to set a secondary currency on a payable or recevable account - all is does is giving an very likely questionable information : the balance in currency !
  Remark : Without this set up I is no issue.

Case 2:
Different case.
You are posting the year end entries and more specificaly you are posting the revaluation entry on your USD bank account. While you post this manual entry in EUR (col. debit & credit) you will also fill in the amount currency field to adjust the USD end balance to reality.
In this situation, we can also have a negative amount_currency while you are posting a debit or vice versa since the adjustement can be anything.

So in these 2 cases the above constraint is maybe not relevant... Should we remove the constraint or do you see a better way to handle this ?

Thanks for your inputs we are really puzzling on this one.

Todo

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

Modules to migrate

• account_asset_depr_line_cancel - By @chienandalu - #490
• account_asset_management
• account_asset_management_xls
• account_auto_fy_sequence - Not needed anymore - #321
• account_balance_line
• account_cancel_invoice_check_payment_order
• account_cancel_invoice_check_voucher
• account_chart_update - By @yajo - #381 - By @jbaudoux - #420
• account_check_deposit
• account_compute_tax_amount
• account_constraints @vrenaville
• account_credit_control
• account_credit_control_dunning_fees
• account_default_draft_move
  • the Skip Draft State (aka entry_posted) journal option does not exist in 9.0
• account_fiscal_position_vat_check - By @cubells - #418
• account_invoice_constraint_chronology
• account_invoice_currency - By @antespi - #390
• account_invoice_tax_required - By @angelmoya - #404
• account_journal_always_check_date
• account_journal_period_close
  • since periods are gone, the underlying infrastructure that allowed fined grained closing per journal is gone too and is replaced by a per company lock date
• account_move_batch_validate - By @OleksandrPaziuk - #602
• account_move_line_no_default_search
• account_move_line_payable_receivable_filter
• account_move_line_search_extension
• account_move_locking
  • some fixes @mdietrichc2c #377
• account_move_template
• account_partner_required
• account_renumber - By @yajo - #379
• account_reset_chart
• account_reversal - By @antespi - #405
  • Reverse Move is standard in 9.0 Community
  • The to_reverse flag and link to reversal move are missing in 9.0 so an OCA module can add that
• account_tax_analysis @vrenaville
• account_tax_chart_interval
• account_tax_update
• async_move_line_importer
• currency_rate_date_check
• currency_rate_update #318 by @vrenaville and @yvaucher (includes refactor #363 @katyukha )
• account_reconcile_trace

Hi,

Since march 5 2015, we cannot convert anymore.
The service that we used is Yahoo.
Is there something wrong?

2015-03-02 04:32:35 currency updated.
2015-03-03 04:33:24 currency updated.
2015-03-04 04:33:07 currency updated.
2015-03-05 04:47:25 ERROR : could not convert string to float: N/A
2015-03-06 04:33:22 ERROR : could not convert string to float: N/A
2015-03-07 04:33:12 ERROR : 'Yahoo_getter' object has no attribute 'MOD_NAME'
2015-03-08 04:33:14 ERROR : could not convert string to float: N/A
2015-03-09 04:33:28 ERROR : could not convert string to float: N/A
2015-03-10 04:33:34 ERROR : could not convert string to float: N/A
2015-03-11 04:32:30 ERROR : could not convert string to float: N/A
2015-03-12 04:33:04 ERROR : could not convert string to float: N/A
2015-03-13 04:39:38 ERROR : could not convert string to float: N/A
2015-03-14 04:32:27 ERROR : 'Yahoo_getter' object has no attribute 'MOD_NAME'
2015-03-15 04:39:24 ERROR : could not convert string to float: N/A
2015-03-16 04:32:52 ERROR : 'Yahoo_getter' object has no attribute 'MOD_NAME'
2015-03-17 04:32:43 ERROR : could not convert string to float: N/A
2015-03-18 04:32:59 ERROR : could not convert string to float: N/A
2015-03-19 04:33:10 ERROR : could not convert string to float: N/A
2015-03-20 04:33:07 ERROR : 'Yahoo_getter' object has no attribute 'MOD_NAME'
2015-03-21 04:36:39 ERROR : 'Yahoo_getter' object has no attribute 'MOD_NAME'
2015-03-22 04:36:58 ERROR : could not convert string to float: N/A
2015-03-23 04:36:51 ERROR : could not convert string to float: N/A
2015-03-24 04:33:20 ERROR : could not convert string to float: N/A
2015-03-24 04:33:23 ERROR : could not convert string to float: N/A
2015-03-25 04:32:53 ERROR : could not convert string to float: N/A
2015-03-26 04:33:05 ERROR : could not convert string to float: N/A
2015-03-27 04:32:40 ERROR : could not convert string to float: N/A
2015-03-28 04:33:23 ERROR : could not convert string to float: N/A
2015-03-29 04:39:34 ERROR : could not convert string to float: N/A
2015-03-30 04:40:30 ERROR : could not convert string to float: N/A
2015-03-31 04:33:20 ERROR : could not convert string to float: N/A

The title "Currency update frequency" should be "Update interval"

Something from commit 3f3f59c seems incomplete, as a reference to self._tax_mapping remains in _prepare_account_vals, which causes traceback on actual trying to update things:

File "/home/leio/.local/share/Odoo/addons/8.0/account_chart_update/wizard/wizard_chart_update.py", line 1006, in _update_accounts
account_template, mapping_taxes, mapping_accounts)
File "/home/leio/.local/share/Odoo/addons/8.0/account_chart_update/wizard/wizard_chart_update.py", line 971, in _prepare_account_vals
if self.map_tax_template(tax_template, mapping_taxes)]
AttributeError: 'wizard.update.charts.accounts' object has no attribute '_tax_mapping'

@pedrobaeza ?

What the directory created by accident?

With an up-to-date code from account-financial-tools/8.0, when the method _onchange_service() is executed, if self.company_id.multi_company_currency_enable is True, we have:

company_id = self.company_id.id

But, if you print this variable in the code, you have:

self.company_id.id= <openerp.models.NewId object at 0x7f839a8d3b50

So then the variable "currencies" doesn't have any values, so you can't select the currencies that needs to be dowloaded for this webservice.

Hello,

When trying to update my Odoo, I get an error because of the post_migrate script of the v7 branch:
File "currency_rate_update/migrations/7.0.0.8/post-migrate.py", line 39, in migrate
File "currency_rate_update/migrations/7.0.0.8/post-migrate.py", line 25, in rename_states
ValueError: need more than 1 value to unpack

Hello,

Can you please add a parameter context to the _check_max_delta_days function in currency_rate_update.py : I think it's the standard and It add flexibility.

Branch 7.0

Thkx,

Assem Bayahi

Hello!

I've been trying to figure out how I could include in the code a subtract or add so that it could get a more favorable rate. Is there anyway I can do this?

What I mean is that the module is working fine, the only thing is that when ie. you're from Canada and go to the bank to buy USD, the rate shown in all these services is less than what you really have to pay to get that amount. So if I charge a customer USD 10,000.00, Odoo has a rate of 1.27 CAD so I'm supposed to pay CAD 12,700.00 for this amount, however the reality is that the bank is selling the USD at 1.3 so I would be having to pay CAD 13,000.00 and losing CAD 300.

Hello,
I don't understand why the check_deposit module doesn't use the same mechanism as the v8 bank_statement ?

I think check_deposit is not different than a bank_statement with a specific check journal and perhaps a specific report.
I understand that we could have a new menu, but I think the form should be the same than the v8 bank statement with the same way of reconcilation.

What do you think ?

Luc

Hi
I have installed Odoo from bitnami and install your latest module for currency conversation. I am generating payslips in different currency for different users. Payslips are generated properly, journal entries are generated properly, but when I check actual account, amount was not deducted properly. Currency conversation was not made properly. So I have check log of that your module and found below error.

" 2015-05-06 10:39:53 ERROR : ValueError('could not convert string to float: helvetica',) "

Can you please help me on this, how to resolve this error.

In account_credit_control/line.py (https://github.com/OCA/account-financial-tools/blob/8.0/account_credit_control/line.py#L57), there is a field 'date_sent'. This field is displayed in the form view of credit.control.line, but it is not set anywhere (a grep on date_sent only brings the form view and the definition of the field).

I think it's a mistake and it should be set when the state of the line goes to 'sent'. Could the developers of the module @nbessi and @guewen confirm this ? If yes, I'll make a PR to fix this bug.

Can a good soul create the 8.0 branch for account-financial-tools?

Thanks

cc/ @gurneyalex

I am experiencing this issue with several customers in v8.0 that use currency_rate_update with a simple configuration:

• 1 service provider
• cron activated with a daily frequency
  If, for some strange reasons, the field next_run is not correctly updated on one particular run (I still need to understand exactly why), the future runs will fail because of the line of code:

services = self.search([('next_run', '=', fields.Date.today())])

This is a new behavior of v8, it was not like that in v7. It is causing at lot of failures with my v8 customers that use currency_rate_update in production. Maybe we should change this line of code by:

services = self.search([('next_run', '<=', fields.Date.today())])

So that, if one run started by cron fails (and next_run is not correctly updated), then the next runs started by cron will be executed. What do you think ?

@StefanRijnhart
I have just tried to reset a chart of accounts with account_reset_chart in v8.0, following the brief example in README file.
Everything OK till client.execute('res.company', 'reset_chart', 1), that raises this:

>>> client.login('admin', admin_pw, dbname)
1
>>> client.execute('res.company', 'reset_chart', 1)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/erppeek.py", line 693, in execute
    res = self._execute(obj, method, *params)
  File "/usr/local/lib/python2.7/dist-packages/erppeek.py", line 383, in <lambda>
    wrapper = lambda s, *args: s._dispatch(name, args)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
    return self.single_request(host, handler, request_body, verbose)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
    return self.parse_response(response)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
    return u.close()
  File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
    raise Fault(**self._stack[0])
xmlrpclib.Fault: <Fault warning -- Error

Unable to delete this document because it is used as a default property: ''>

Server log gives no warning, but they show this:

2015-05-25 17:51:19,807 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking vouchers.
2015-05-25 17:51:19,843 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking all records of model account.banking.account.settings for company My Company
2015-05-25 17:51:19,844 2120 INFO db_test openerp.addons.account_reset_chart: Model account.banking.account.settings not found
2015-05-25 17:51:19,844 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking all records of model res.partner.bank for company My Company
2015-05-25 17:51:19,846 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking reconciliations
2015-05-25 17:51:19,850 2120 INFO db_test openerp.addons.account_reset_chart: Reset paid invoices's workflows
2015-05-25 17:51:19,854 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking moves
2015-05-25 17:51:19,857 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking all records of model account.fiscal.position for company My Company
2015-05-25 17:51:19,890 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking all records of model account.tax for company My Company
2015-05-25 17:51:20,026 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking all records of model account.tax.code for company My Company
2015-05-25 17:51:20,208 2120 INFO db_test openerp.addons.account_reset_chart: Unlinking all records of model account.journal for company My Company

I tried with both the chart of accounts module installed and uninstalled, with same lack of luck.

Any idea?

Hi OCA,

I have migrated our database from v7 to v8,
Since V7 we have used this module(Currency Rate Update), and in V8 we used this module too.
But when I tried to configure it, we have a bug that said: "super_res is not defined", and the currency records that we want to update is not in the table, and when we want to choose it again, there's no show on it too. (In V7 we have: HKD,EURO,USD). I tried to delete this configuration and reconfigure again, but still the behavior is the same.

Can you check why?

Here is the video to explain things:
https://www.dropbox.com/s/3y66ov0tvtjkbos/curbug.avi?dl=0

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

Here is the scenario of the bug: on an up-to-date odoo 8, install the point_of_sale module and use it: everything works fine.

Install the module account_auto_fy_sequence. Start the point of sale again: Point of sale > Your Session > New session
Add a product. Click on "Checks journal", then "Validate", then "Next Order" : you will get an error pop-up : _next() takes at least 4 arguments (4 given)

Here is the full backtrace in the server logs:

2015-01-01 13:40:27,259 8606 ERROR o8_template openerp.http: Exception during JSON request handling.
Traceback (most recent call last):
  File "/home/alexis/new_boite/dev/odoo/openerp/http.py", line 518, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/alexis/new_boite/dev/odoo/openerp/http.py", line 539, in dispatch
    result = self._call_function(**self.params)
  File "/home/alexis/new_boite/dev/odoo/openerp/http.py", line 295, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/alexis/new_boite/dev/odoo/openerp/service/model.py", line 113, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/alexis/new_boite/dev/odoo/openerp/http.py", line 292, in checked_call
    return self.endpoint(*a, **kw)
  File "/home/alexis/new_boite/dev/odoo/openerp/http.py", line 755, in __call__
    return self.method(*args, **kw)
  File "/home/alexis/new_boite/dev/odoo/openerp/http.py", line 388, in response_wrap
    response = f(*args, **kw)
  File "/home/alexis/new_boite/dev/odoo/addons/web/controllers/main.py", line 949, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/home/alexis/new_boite/dev/odoo/addons/web/controllers/main.py", line 941, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/home/alexis/new_boite/dev/odoo/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/alexis/new_boite/dev/odoo/addons/point_of_sale/point_of_sale.py", line 591, in create_from_ui
    order_id = self.create(cr, uid, self._order_fields(cr, uid, order, context=context),context)
  File "/home/alexis/new_boite/dev/odoo/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/alexis/new_boite/dev/odoo/addons/point_of_sale/point_of_sale.py", line 758, in create
    values['name'] = session.config_id.sequence_id._next()
  File "/home/alexis/new_boite/dev/odoo/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/alexis/new_boite/dev/odoo/openerp/api.py", line 464, in new_api
    result = method(self._model, cr, uid, *args, **kwargs)
TypeError: _next() takes at least 4 arguments (4 given)

We have detect some issues when updating Spanish Account Chart:

• If template tax has change its parent_id field, this change is not detected and then this tax is not updated
• If there is a current tax deactivated with the same description as a template tax, then wizard do not re-activate this tax nor create a new one.

We tried to resolve these issues in this PR: #231
Please review it and send your comments or approvals

Here is the scenario of the bug : I am using donation_tax_receipt with account_auto_fy_sequence. My tax receipts have a sequence with a prefix "%(fy)s", see donation_tax_receipt/donation_tax_data.xml. In donation_tax_receipt/donation_tax.py line 171, I have:

        fiscalyear_id = self.env['account.fiscalyear'].find(
            dt=date, exception=True)
        # If date is False, it uses today, which is our default value
        # I use account_auto_fy_sequence here:
        vals['number'] = self.env['ir.sequence'].with_context(
            fiscalyear_id=fiscalyear_id).next_by_code('donation.tax.receipt')

see http://bazaar.launchpad.net/~philemon-core-editors/philemon/trunk/view/head:/donation_tax_receipt/donation_tax.py

I have one fiscal year per civil year. A user creates a first tax receipt in 2014: the module account_auto_fy_sequence will create a new ir.sequence for 2014 that will be attached to the "main" sequence.

Then, a user creates a first tax receipt for 2015: he gets the following error message:

The system tried to access a fiscal year sequence but there is more than one sequence to choose from.

This is because the call to next_by_code('donation.tax.receipt') will find 2 ir.sequences that have a sequence type = 'donation.tax.receipt' : the main sequence and the sequence auto-created for 2014. So it will hit the error in account_auto_fy_sequence/models/ir_sequence.py line 80 that raises an error where there are multiple sequences passed to the _next() function.

I think that a proper way to fix this is to have Sequence Type = False on the fiscal-year-specific sequence that the module auto-creates.

Employee Payslip AccessError.

Impacted versions:

• 8.0

Steps to reproduce:

• sign in with an user without accounting permission
• create a new Employee Payslip
• Set accounts on Salary Rules of Structure
• Set required fields
• Click on "Confirm" button

https://www.youtube.com/watch?v=SGspTnUN9YE&feature=youtu.be

Current behavior:

AccessError Message
https://docs.google.com/file/d/0B2UF4u0-ob1FS2ZLUjllbjkwdFk/edit?usp=drivesdk

Expected behavior:

Employee payslip Confirmed and should not display the error message

Only install hr_payroll_account and account_partner_required modules.

Hi,
I've been playing around with the Currency Rate Update module, I have added our national bank currency rate and everything run as expected from the Currency Rate Update module Getter called NI-BCN but at the end of the running process when the currency exchange is posted on the Currency schema the date and currency are wrong.

For excample, today's currency (2016-08-29) is 1 USD = 28.8439 NIO the inverted value in odoo should be 1 NIO = 0.0346693755005 USD, the latter is the default in Odoo, but when I check the values in Currency options the date is set -1 day from today's date and the currency is set as 1 NIO = 0.034669 USD, as noted the actual decimal places is set to 6 and in order to have the most accurate rate I should have more decimal digits, for example if I do some math:

1 / 0.034669 = 28.84421240878018 <> 28.8439 (This is the bank correct rate) .

Base and accounting currency is = NIO
Foreing currency is = USD

My question is, where should I go to be able to have the correct currency's date and also set the decimal places from 6 to 8 digits?

Thanks for help.

module : account_move_line_search_extension (with filters on top of the tree view 'journal items'

• select a journal and type in a period
• click on create
• input a date, description, debit... and press enter
  -> the new line generate is considered a new move so it is impossible to create the couterpart entry of the first move

I noticed a second issue : After you select the journal and period and click on create, the journal field on the move line is not automatically field in + the 2 columns journal and period are not automatically hidden as in standard.

Due to the following error, the Transifex build failed on eed4784:

Downloading PO file for account_credit_control

Traceback (most recent call last):
  File "/home/travis/maintainer-quality-tools/travis/travis_transifex.py", line 168, in <module>
    exit(main())
  File "/home/travis/maintainer-quality-tools/travis/travis_transifex.py", line 146, in main
    f.write(odoo_context.get_pot_contents(module))
  File "/home/travis/maintainer-quality-tools/travis/odoo_connection.py", line 51, in get_pot_contents
    self.trans_export(False, [addon], buf, 'po', self.cr)
  File "/home/travis/odoo-8.0/openerp/tools/translate.py", line 526, in trans_export
    _process(format, modules, translations, buffer, lang)
  File "/home/travis/odoo-8.0/openerp/tools/translate.py", line 500, in _process
    writer.write(row['modules'], row['tnrs'], src, row['translation'], row['comments'])
  File "/home/travis/odoo-8.0/openerp/tools/translate.py", line 464, in write
    % (quote(source), quote(trad))
  File "/home/travis/odoo-8.0/openerp/tools/translate.py", line 274, in quote
    assert r"\n" not in s, "Translation terms may not include escaped newlines ('\\n'), please use only literal newlines! (in '%s')" % s
AssertionError: Translation terms may not include escaped newlines ('\n'), please use only literal newlines! (in '
      Dear ${object.contact_address.name or ''}
      <br/>
      <br/>
      ${object.current_policy_level.custom_mail_text.replace('\n', '<br>') | safe}
      ')

+=======================================
|  Tests summary:
|---------------------------------------
| travis_transifex.py         FAIL
+=======================================

the tests of account_asset_management are red.

https://travis-ci.org/OCA/account-financial-tools/jobs/108216715#L249

Travis failed on transifex:

https://travis-ci.org/OCA/account-financial-tools/jobs/65095319

I checked on:
OCA/maintainer-quality-tools#194

The key seems right.

@bwrsandman any idea?

How to reproduce:

• create move M in period P
• close period P
• try to reverse move M in period P+1
• => You can not add/modify entries in a closed period P of journal ...

This is due to https://github.com/OCA/account-financial-tools/blob/8.0/account_reversal/account_reversal.py#L88 which tries to write on the original move.