oca/l10n-netherlands

Odoo Dutch Localization

l10n-netherlands

Odoo Dutch Localization

Available addons

addon	version	maintainers	summary
l10n_nl_account_tax_unece	16.0.1.0.0		Auto-configure UNECE params on Dutch taxes
l10n_nl_bank	16.0.1.0.0		Import all Dutch banks with BIC code
l10n_nl_bsn	16.0.1.0.0		Burgerservicenummer (BSN) for Partners
l10n_nl_oin	16.0.1.0.0		Adds Dutch OIN field
l10n_nl_postcode	16.0.1.0.0		Dutch postcode validation for Partners
l10n_nl_tax_statement	16.0.1.0.2		Netherlands BTW Statement
l10n_nl_tax_statement_date_range	16.0.1.0.0		Netherlands BTW Statement - Date range
l10n_nl_tax_statement_icp	16.0.1.1.0		Netherlands ICP Statement
l10n_nl_xaf_auditfile_export	16.0.1.2.0		Export XAF auditfiles for Dutch tax authorities

Licenses

This repository is licensed under AGPL-3.0.

However, each module can have a totally different license, as long as they adhere to Odoo Community Association (OCA) policy. Consult each module's __manifest__.py file, which contains a license key that explains its license.

---

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

l10n-netherlands's Issues

Migration to version 10.0

Todo

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

Modules to migrate

• l10n_nl_bsn
• l10n_nl_postcodeapi
• l10n_nl_xaf_auditfile_export

XAF export no starting balance

We runned a XAF file (the V9 version) through a XAF analyser. But it look like there is not starting balance data. I am not a technical guy but what I can see in the code we only talking about start- and end-date of the fiscal year.

But as properly every knows Odoo has left since V8 the concept of fixed periods.
So since V8 there is not opening period (0). Therefore it will not appear anymore in the Audit-file.

Can somebody confirm that my findings are match with the code.
I see call of start- and end date in the V9/10/11 versions. but not a the "creation" of a period 0/opening/starting balance.

As my understandings the XAF module is only fetching the mutations of the exported year.

Alignment in report

l10n_nl_postcodeapi: res.country.state.csv not used from manifest

While porting this module to V11, got this warning:

************* Module l10n_nl_postcodeapi
l10n_nl_postcodeapi/data/res.country.state.csv:1: [W7930(file-not-used), ]  not used from manifest

All versions of the module are affected.

l10n_nl_xaf_auditfile_export error while generating auditfile

module: l10n_nl_xaf_auditfile_export
version: 12.0

Steps to reproduce
Click on Generate auditfile.

Current behavior
getting error
File "/home/lenovo/resham_work/odoo_12/odoo/addons/web/controllers/main.py", line 954, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/home/lenovo/resham_work/odoo_12/odoo/odoo/api.py", line 749, in call_kw
return _call_kw_multi(method, model, args, kwargs)
File "/home/lenovo/resham_work/odoo_12/odoo/odoo/api.py", line 736, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/home/lenovo/resham_work/odoo_12/Hospitaner/extra_addons/l10n_nl_xaf_auditfile_export/models/xaf_auditfile_export.py", line 168, in button_generate
self.message_post(e)
TypeError: message_post() takes 1 positional argument but 2 were given

Expected behavior
Expecting this message to be posted
odoo.addons.l10n_nl_xaf_auditfile_export.models.xaf_auditfile_export: Element '{http://www.auditfiles.nl/XAF/3.2}bankAccNr': [facet 'maxLength'] The value has a length of '38'; this exceeds the allowed maximum length of '35'. (, line 0)

report_tax_statement not working

Error in line 67:
Should be: due to the changes in V11
But after changing this, the report is created but empty

Translating

Hi,

I want to help by translation the Dutch modules. But it seems l10n-netherlands is not on Transifex.

CBS / Intrastat module for The Netherlands

Based on the OCA intrastat base we should provide a correct Intrastat report

Serbia missing in .xsd file

missing: country code = RS
in: l10n_nl_xaf_auditfile_export/data/XmlAuditfileFinancieel3.2.xsd

Local Netherlands Maintainers Team

Hi Everybody,

with new year is time to intensify the work on this project and to speed up the activities we should have a bigger maintenance team.
Who is interested in this activity can just reply to this post and I will be happy to organise a team big enough to never leave the project uncovered.
For some permission issues I cannot add directly new members but I will take care to forward the requests to the OCA administrators.

Cheers.

l10n_nl_tax_statement - 4a & 4b turnover negative

Hi,

When creating a tax statement the turnover in 4a & 4b are shown as a negative amount. I think this should be positive, surely because the tax in 4a&4b is shown as a positive number.

Cas

XAF Audit traceback when using max_record [V10]

Couldn't reproduce in v11, when max_records isn't set the export starts running:

Traceback (most recent call last):
  File "/odoo/customer/odoo/odoo/http.py", line 642, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/odoo/customer/odoo/odoo/http.py", line 684, in dispatch
    result = self._call_function(**self.params)
  File "/odoo/customer/odoo/odoo/http.py", line 334, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/odoo/customer/odoo/odoo/service/model.py", line 101, in wrapper
    return f(dbname, *args, **kwargs)
  File "/odoo/customer/odoo/odoo/http.py", line 327, in checked_call
    result = self.endpoint(*a, **kw)
  File "/odoo/customer/odoo/odoo/http.py", line 942, in __call__
    return self.method(*args, **kw)
  File "/odoo/customer/odoo/odoo/http.py", line 507, in response_wrap
    response = f(*args, **kw)
  File "/odoo/customer/odoo/addons/web/controllers/main.py", line 896, in call_button
    action = self._call_kw(model, method, args, {})
  File "/odoo/customer/odoo/addons/web/controllers/main.py", line 884, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/odoo/customer/odoo/odoo/api.py", line 689, in call_kw
    return call_kw_multi(method, model, args, kwargs)
  File "/odoo/customer/odoo/odoo/api.py", line 680, in call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/odoo/customer/community/l10n_nl_xaf_auditfile_export/models/xaf_auditfile_export.py", line 95, in button_generate
    'self': self,
  File "/odoo/customer/odoo/addons/web_editor/models/ir_ui_view.py", line 26, in render
    return super(IrUiView, self).render(values=values, engine=engine)
  File "/odoo/customer/odoo/odoo/addons/base/ir/ir_ui_view.py", line 1063, in render
    return self.env[engine].render(self.id, qcontext)
  File "/odoo/customer/odoo/odoo/addons/base/ir/ir_qweb/ir_qweb.py", line 53, in render
    return super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
  File "/odoo/customer/odoo/odoo/addons/base/ir/ir_qweb/qweb.py", line 248, in render
    self.compile(template, options)(self, body.append, values or {})
  File "/odoo/customer/odoo/odoo/addons/base/ir/ir_qweb/qweb.py", line 322, in _compiled_fn
    raise QWebException("Error to render compiling AST", e, path, node and etree.tostring(node[0]), name)
QWebException: %d format: a number is required, not unicode
Traceback (most recent call last):
  File "/odoo/customer/odoo/odoo/addons/base/ir/ir_qweb/qweb.py", line 315, in _compiled_fn
    return compiled(self, append, values, options, log)
  File "<template>", line 1, in template_2132_2342
  File "/odoo/customer/odoo/odoo/addons/base/ir/ir_qweb/qweb.py", line 177, in foreach_iterator
    for index, (item, value) in enumerate(enum):
  File "/odoo/customer/community/l10n_nl_xaf_auditfile_export/models/xaf_auditfile_export.py", line 153, in get_partners
    default=MAX_RECORDS))
  File "/odoo/customer/odoo/odoo/models.py", line 1516, in search
    res = self._search(args, offset=offset, limit=limit, order=order, count=count)
  File "/odoo/customer/odoo/odoo/addons/base/res/res_partner.py", line 639, in _search
    count=count, access_rights_uid=access_rights_uid)
  File "/odoo/customer/odoo/odoo/models.py", line 4257, in _search
    limit_str = limit and ' limit %d' % limit or ''
TypeError: %d format: a number is required, not unicode

Error to render compiling AST
TypeError: %d format: a number is required, not unicode
Template: 2132
Path: /templates/t/auditfile/company/customersSuppliers/customerSupplier
Node: <customerSupplier t-foreach="self.get_partners()" t-as="p">
                <custSupID><t t-esc="p.id"/></custSupID>
                <custSupName><t t-esc="p.name" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string50&quot;}"/></custSupName>
                <contact t-if="p.is_company and p.child_ids"><t t-esc="p.child_ids[0].name" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string50&quot;}"/></contact>
                <telephone><t t-esc="p.phone" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string30&quot;}"/></telephone>
                <fax><t t-esc="p.fax" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string30&quot;}"/></fax>
                <eMail><t t-esc="p.email"/></eMail>
                <website><t t-esc="p.website"/></website>
                <!-- not in standard data model
                <commerceNr /> /-->
                <taxRegistrationCountry t-if="p.country_id"><t t-esc="p.country_id.code"/></taxRegistrationCountry>
                <taxRegIdent><t t-esc="p.vat" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string30&quot;}"/></taxRegIdent>
                <custSupTp><t t-esc="'B' if p.customer and p.supplier else 'C' if p.customer else 'S' if p.supplier else 'O'"/></custSupTp>
                <!-- those need to be defined in <basics/> and are not required
                     labels might be used here
                <relationshipID>String</relationshipID>
                <custSupGrpID>String</custSupGrpID> -->
                <custCreditLimit t-if="p.customer and p.credit_limit"><t t-esc="p.credit_limit"/></custCreditLimit>
                <supplierLimit t-if="p.supplier and p.credit_limit"><t t-esc="p.credit_limit"/></supplierLimit>
                <streetAddress>
                    <streetname><t t-esc="p.street" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string999&quot;}"/></streetname>
                    <number/>
                    <numberExtension/>
                    <property/>
                    <city><t t-esc="p.city" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string50&quot;}"/></city>
                    <postalCode><t t-esc="p.zip" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string10&quot;}"/></postalCode>
                    <region><t t-esc="p.state_id.name" t-esc-options="{&quot;widget&quot;: &quot;auditfile.string50&quot;}"/></region>
                    <country t-if="p.country_id"><t t-esc="p.country_id.code"/></country>
                </streetAddress>
                <bankAccount t-foreach="p.bank_ids" t-as="bank">
                    <bankAccNr><t t-esc="bank.acc_number"/></bankAccNr>
                    <bankIdCd><t t-esc="bank.bank_bic or bank.bank_id.bic"/></bankIdCd>
                </bankAccount>
                <changeInfo t-if="p.write_uid">
                    <userID><t t-esc="p.write_uid.login"/></userID>
                    <changeDateTime><t t-esc="p.write_date[:10]"/>T<t t-esc="p.write_date[-8:]"/></changeDateTime>
                    <changeDescription>Laast geschreven</changeDescription>
                </changeInfo>
                <customerSupplierHistory/>
            </customerSupplier>

Postcodeapi not working

I installed the postcode module for odoo v10 community edition.
-Module installed
-pyPostcode installed
-Dutch Provinces imported

When I enter a postcode I get the following odoo Server error:

Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 638, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 675, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 331, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/service/model.py", line 119, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 324, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 933, in call
return self.method(*args, **kw)
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 504, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 885, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/addons/web/controllers/main.py", line 877, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 681, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/api.py", line 672, in call_kw_multi
result = method(recs, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 5494, in onchange
record._onchange_eval(name, field_onchange[name], result)
File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 5392, in _onchange_eval
method_res = method(self)
File "/usr/lib/python2.7/dist-packages/odoo/addons/l10n_nl_postcodeapi/models/res_partner.py", line 75, in on_change_zip_street_number
provider_obj = self.get_provider_obj()
File "", line 2, in get_provider_obj
File "/usr/lib/python2.7/dist-packages/odoo/tools/cache.py", line 87, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/odoo/addons/l10n_nl_postcodeapi/models/res_partner.py", line 45, in get_provider_obj
_('Could not verify the connection with the address '
TypeError: init() takes exactly 2 arguments (3 given)

Migration to version 9.0

Todo

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

Modules to migrate

• l10n_nl_xaf_auditfile_export
• l10n_nl_postcodeapi

l10n_nl_tax_invoice_basis tax booking should be on invoice date

Hi,

Example:
Invoice date = 04-01-2018
Accounting date = 31-12-2017

Odoo will book everything on 31-12-2017 including the tax. The tax statement report will be correct, but the balance on the tax statement will be incorrect matched to the balance on the ledger.
In the booking the accounting date of the tax moves should be 04-01-2018.

With kind regards,
Cas

IDEAL payment module

In the meeting of today popup the common need of a module to handle directly the IDEAL payments on the webshop: will be really nice to implement this together as an OCA module. Open discussion below...

Odoo 9 Sprint - Shared goals

Odoo 9 sprint shared goals for September 9th 2015.

XAF financial information exporting

Proposal for the implementation of a module to export the financial (accounting) information
from Odoo to an .XAF file according to the model provided by the Dutch tax authorities (http://www.belastingdienst.nl/wps/wcm/connect/bldcontentnl/belastingdienst/zakelijk/aangifte_betalen_en_toezicht/toezicht/handhaving_en_controle/belastingcontrole_met_de_auditfile).

[9.0] XAF audit file export fails with long login (E-Mail)

With the new 9.0 module, the export fails when the user doing the entries logs in with an emailadres.
The error message:

:5228:0:ERROR:SCHEMASV:SCHEMAV_CVC_MAXLENGTH_VALID: Element '{http://www.auditfiles.nl/XAF/3.2}userID': [facet 'maxLength'] The value has a length of '37'; this exceeds the allowed maximum length of '35'.
:5228:0:ERROR:SCHEMASV:SCHEMAV_CVC_DATATYPE_VALID_1_2_1: Element '{http://www.auditfiles.nl/XAF/3.2}userID': '[email protected]' is not a valid value of the atomic type '{http://www.auditfiles.nl/XAF/3.2}IdentificationString35'.

We are using google authentication, therefore we can't change the login.
Proposed solutions:

• Replace the login with the part before the @, if the login contains an @.
• Truncate the login to 35 characters.. This usually truncates the last part of the domain,
• Use the name, of another field?

If someone can give feedback, I can create a patch for this.

Migration to version 12.0

Todo

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

Modules to migrate

• l10n_nl_account_tax_unece
• l10n_nl_bank
• l10n_nl_bsn - By @astirpe - #199
• l10n_nl_postcode - By @astirpe - #201
• l10n_nl_postcodeapi
• l10n_nl_tax_invoice_basis - By @astirpe - #203
• l10n_nl_tax_statement
• l10n_nl_xaf_auditfile_export - By @astirpe - #200

l10n_nl_bsn: searching on BSN without dots

I have seen that the l10n_nl_bsn module reformats the BSN by placing dots between the numbers in certain places, eg. 123.45.678 instead of 12345678. However, when reading for example CSV files with BSN data and trying to match on it, the data will often be without those dots and thus the matching/searching on BSN will not work without extra modifications. Searching on a number without dots will also not work well in the regular Odoo "advanced search".

To me, the dots are formatting and the BSN should not be stored with them; rather there should be something like a BSN widget that shows the formatted BSN but the stored number is still vanilla. This is IMO the "right" way and will also aid in searching and comparing.

Any opinions on this?

[V11] l10n_nl_tax_statement: Update of past undeclared invoices - Update of BTW statement doesn't work

Hello,

i have just checked the V11 version of l10n_nl_tax_statement in order to adopt it for the german "clone" of this module: https://github.com/openbig/l10n-germany/tree/10.0/l10n_de_tax_statement.

I have created a customer invoice with the tax "Verkopen/omzet hoog" with a invoice date in between of the given date_range in the tax statement. If i click on update button the value in the line "1a Leveringen/diensten belast met hoog tarief" was calculated correctly.

Now i created two further invoices with a invoice date before the "from_date" of the statement. If i go to the tab "Past undeclared invoices" i can see the two lines. Now i wanted to include those lines in the statement by clicking on the ">" arrow to add them + clicking on the "update" button as suggested by the description "Add/Remove the Undeclared Invoices listed below. Afterwards press the Update button in order to recompute the statement lines!".

Now i would normally expect that the line "1a Leveringen/diensten belast met hoog tarief" would have been updated but it doesn't.

Unfortunately it just shows the "regular" invoice in between of the given date range. I miss here the two further added invoices from the past months.

Nevertheless, thanks a lot for your great work on that module. The added feature "past undeclared invoices" is a great further improvement. I will now try to adopt the V11 changes for the german accounting plans.

Best regards
Thorsten

Whiteworks import

Hi,

by customer demand, I have made a module that imports .xlsx files with contacts and invoices generated by Whiteworks CRM and accounting. https://www.whiteworks.nl/. It can be used as the starting point of a one time migration or as a periodic process. As Whiteworks is a very local player in the Netherlands, we could host the module in this project if there is any interest. Let me know and I will make a PR.

l10n_nl_postcodeapi: sslv3 alert handshake failure

When we change customer address zip code, sslv3 error raised in trace back.

Iteration issue when res_partner.bank_ids is filled

When banking information is filled for a partner (Accounting tab on the partner view), the created XAF file will contain errors and on opening with the AuditFileViewer an error message will be given by the viewer ("Er is een fout opgetreden bij het tonen van bedrijfsgegevens van een xaf bestand.").
The file is also much larger than when the banking information is removed (e.g. 270kB instead of 75kB).

CBS export Bugs

When testing by our customer we have noted a few bugs. We will create PR soon for the fixes:

1. First line, phone number. If phone number of company setting is with country code =31, it has to be replaced by a 0
2. First line pos 22: This digit has to represents the month that it concerns. Now it is wrongly the month of creation of the file.
3. First line: Change line ending LF > CRLF
4. Detail lines pos 100. This has to be a invoice line number increment from 00 until 99.
5. Detail lines: Change line ending LF > CRLF
6. detail lines: If amount is 0, then calculate the line value as Cost price x qty
7. Footer line: Change line ending LF > CRLF

xaf_auditfile_export.py: SQL syntax error when account.period has no tuples

File "...l10n_nl_xaf_auditfile_export/models/xaf_auditfile_export.py", line 193, in get_move_line_count
(tuple(p.id for p in self.get_periods()), self.company_id.id))
File "...odoo/openerp/sql_db.py", line 158, in wrapper
return f(self, args, **kwargs)
File "...odoo/openerp/sql_db.py", line 234, in execute
res = self._obj.execute(query, params)
QWebException: "syntax error at or near ")"
LINE 1: ...unt() from account_move_line where period_id in () and (com...
^
" while evaluating
'self.get_move_line_count()'

[11.0]: traceback error on l10n_nl_account_tax_unece

I am unable to install this module:
Traceback:

Error:
Odoo Server Error

Traceback (most recent call last):
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 744, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 654, in _tag_record
    id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/opt/odoo/custom/src/odoo/odoo/addons/base/ir/ir_model.py", line 1493, in _update
    record = record.create(values)
  File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3377, in create
    record = self.browse(self._create(old_vals))
  File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3470, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
psycopg2.IntegrityError: null value in column "name" violates not-null constraint
DETAIL:  Failing row contains (75, null, 2019-02-02 12:19:13.536225, null, 1, 1, null, null, f, null, 1, null, null, null, null, null, null, null, null, null, sale, null, 2019-02-02 12:19:13.536225, null, null, null, null, null, null, null, f, null, null, percent, 1, f, t, f, null, 45, 47, on_invoice, null).


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 651, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 310, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/opt/odoo/custom/src/odoo/odoo/tools/pycompat.py", line 87, in reraise
    raise value
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 693, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 342, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/service/model.py", line 97, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 335, in checked_call
    result = self.endpoint(*a, **kw)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 937, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/custom/src/odoo/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/auto/addons/web/controllers/main.py", line 938, in call_button
    action = self._call_kw(model, method, args, {})
  File "/opt/odoo/auto/addons/web/controllers/main.py", line 926, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/api.py", line 689, in call_kw
    return call_kw_multi(method, model, args, kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/api.py", line 680, in call_kw_multi
    result = method(recs, *args, **kwargs)
  File "<decorator-gen-42>", line 2, in button_immediate_install
  File "/opt/odoo/custom/src/odoo/odoo/addons/base/module/module.py", line 71, in check_and_log
    return method(self, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/addons/base/module/module.py", line 449, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/opt/odoo/custom/src/odoo/odoo/addons/base/module/module.py", line 543, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "/opt/odoo/custom/src/odoo/odoo/modules/registry.py", line 85, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/opt/odoo/custom/src/odoo/odoo/modules/loading.py", line 380, in load_modules
    loaded_modules, update_module, models_to_check)
  File "/opt/odoo/custom/src/odoo/odoo/modules/loading.py", line 274, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/opt/odoo/custom/src/odoo/odoo/modules/loading.py", line 181, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/opt/odoo/custom/src/odoo/odoo/modules/loading.py", line 95, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 791, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 852, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 751, in parse
    exc_info[2]
  File "/opt/odoo/custom/src/odoo/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 744, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo/custom/src/odoo/odoo/tools/convert.py", line 654, in _tag_record
    id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/opt/odoo/custom/src/odoo/odoo/addons/base/ir/ir_model.py", line 1493, in _update
    record = record.create(values)
  File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3377, in create
    record = self.browse(self._create(old_vals))
  File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3470, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 155, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/odoo/custom/src/odoo/odoo/sql_db.py", line 232, in execute
    res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "name" violates not-null constraint
DETAIL:  Failing row contains (75, null, 2019-02-02 12:19:13.536225, null, 1, 1, null, null, f, null, 1, null, null, null, null, null, null, null, null, null, sale, null, 2019-02-02 12:19:13.536225, null, null, null, null, null, null, null, f, null, null, percent, 1, f, t, f, null, 45, 47, on_invoice, null).
" while parsing /opt/odoo/auto/addons/l10n_nl_account_tax_unece/data/account_tax_template.xml:17, near
<record id="l10n_nl.btw_9" model="account.tax.template">
        <field name="unece_type_id" eval="ref('account_tax_unece.tax_type_vat')"/>
        <field name="unece_categ_id" eval="ref('account_tax_unece.tax_categ_aa')"/>
    </record>

New VAT rule 9% not honoured in module

The current version does not support the change in taxes from 6% to 9%.

Setup:

• duplicate 6% and change to 9%
• re-run NL VAT

[8.0 ]l10n_nl_xaf_auditfile_expor

Impacted versions:
8.0

Steps to reproduce:
Opening 2017 to 04/2017' 'period. However, after reading the relevant Auditfile he still displays as of 15/16/17/18.

Current behavior:
Period 15/16/17/18. File can also not be read in the Audit File Viewer of the Dutch Tax Office.

Expected behavior:
Period 0/01/02/03/04

Is about the:
10n_nl_xaf_auditfile_export 8.0.1.0.0 Export XAF auditfiles for Dutch tax authorities

l10n_nl_tax_statement: Clearing the tax account moves included in the Nederlands BTW Statement to a dedicated payable/receivable (suspense) account when posting the statement

Hi,

It would be a great enhancement, if when posting a BTW Statement, the option is given to clear all the tax account moves, which are included in the statement, to a dedicated payable/receivable (suspense) account. Subsequently the tax account moves are reconciled on the tax accounts, leaving only the journal item on the dedicated suspense account open to be reconciled with the (bank) payment. The status of the BTW Statement should then be Posted & Reconciled (Draft - Posted & Reconciled - Final). If the option is not used the status should be Posted (Draft - Posted - Final).

Additionally, when the option to clear the concerning tax account moves was been used when posting the BTW Statement, the resulting journal entry and reconciliations are automatically reversed when statement is reset to draft. The accounting date of the reversal should be in the current period and the 2 journal items on the dedicated suspense account should be automatically reconciled.
If the statement was only posted, when resetting the statement to draft, the user should get a notification to consider the manual journal entry and reconciliations (if applicable).

If further information is needed, please contact me.

Thanks in advance for your reply.

Regards,

Robert Wever

New OCA representative (aka. project leader)

From LinkedIn I understand that @diellenne is no longer working in the Odoo area, so I wanted to propose @hbrunn as the next OCA representative for this project.

Holger is one of the most active Odoo developers in the OCA. He wrote three of the four modules in the 8.0 branch of this repository.

Migration to version 11.0

Todo

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

Modules to migrate

• l10n_nl_bank
• l10n_nl_bsn
• l10n_nl_cbs_export
• l10n_nl_intrastat
• l10n_nl_partner_name
• l10n_nl_partner_salutation
• l10n_nl_postcodeapi
• l10n_nl_tax_statement
• l10n_nl_xaf_auditfile_export

[BUG] l10n_nl_cbs_export: ValueError: day is out of range for month

The tests of module l10n_nl_cbs_export failed on date 31/10/2018 because of a bug in the code.
Here is the traceback from Travis:

ERROR: test_04_run_cron_job (odoo.addons.l10n_nl_cbs_export.tests.test_cbs_export_file.TestCbsExportFile)
Traceback (most recent call last):
`   File "/home/travis/build/OCA/l10n-netherlands/l10n_nl_cbs_export/tests/test_cbs_export_file.py", line 205, in test_04_run_cron_job
`     self.env['cbs.export.file'].cron_get_cbs_export_file()
`   File "/home/travis/build/OCA/l10n-netherlands/l10n_nl_cbs_export/models/cbs_export_file.py", line 159, in cron_get_cbs_export_file
`     cbs_export_file.export_file()
`   File "/home/travis/build/OCA/l10n-netherlands/l10n_nl_cbs_export/models/cbs_export_file.py", line 165, in export_file
`     cbs_export_data = self._format_header()
`   File "/home/travis/build/OCA/l10n-netherlands/l10n_nl_cbs_export/models/cbs_export_file.py", line 182, in _format_header
`     month=int(self.month), year=int(self.year))
` ValueError: day is out of range for month

Working on a patch, I'll open a PR soon.

l10n_nl_intrastat should be based on country of parent_id

Hi,

Example: Company A has Customer B (Netherlands) with Invoice Contact C (Belgium)

In Odoo, fiscal postion and VAT are managed on customer B. The intrastat ICP module incorrectly calculates based on the country of the invoice contact (contact C).

I.e. auto fiscal position calculation on invoices also uses the customer, not the invoice contact.

Regards,
Cas

Dutch basic configurations

Proposal for the implementation of a module containing basic configurations to fit the general customs and traditions of the Netherlands. The idea is to create a module to collect all the settings and configurations that are too small to have a dedicated module: the discussion about what has to be included in this module and what doesn't is open...

l10n_nl_intrastat company domain on date_range

There is a company domain on date ranges, this is incorrect in my opinion. In multi-company environments it's possible to make generic date ranges for all companies (without company).

In addition there is already a record rule on company_id in:
https://github.com/OCA/server-tools/blob/10.0/date_range/security/date_range_security.xml

l10n_nl_bsn, improve check: BSN unique

One minor bug: When having a valid BSN number for a partner, then changing it to an invalid number, save and get the correct warning, finally change it back to the original valid number, you will get a "Another person (Administrator) has the same BSN [...]" warning.

Plotting a new roadmap

Dear Dutch OCA community,

2016 is well underway and Odoo 9 has been released for a few months now.

Let's discuss which modules we want to update to 9 and which new modules would be nice to have for the Dutch market.

To name just a few:

• XAF audit file
• Ideal Payment
• KvK connector
• NL Configuration
• SBR / XBLR / BTW aangifte
• Tax: Werkkostenregeling
• NL Banking integration

As the last sprint was a success and a nice way to meet other Odoo developers, we plan to organize a sprint at the end of Q1 '16.

In preparation for this sprint it would be nice if we could have already developed some modules or upgraded some to 9, this so there are only real challenges left for the sprint ;)

So reply to this topic if you are considering:

• to add a module,
• to discontinue a module,
• on what module(s) you want to work,
• to contribute to this discussion in a constructive manner.

l10n_nl_intrastat should only show revenu of revenu accounts

The ICP report should only show the amounts that are posted on revenu-accounts. At the moment, it also shows the amounts of f.e. current assets. The dutch tax authorities clearly states that the ICP report is a detailed representation of the revenu of category 3a, and should only show revenu on companies that are obliged to report/pay tax.
If the accounts are limited to only 'type=revenu', the report will still 'find' the flaws in the journal entries, f.e. when a partner has the correct fiscal position, but the entry is on the wrong tax-code.

[RFC] l10n_nl_chart_rgs: upgrade RGS Taxonomie to version 2.0

Would it be of interest to upgrade the accounts present in module l10n_nl_chart_rgs according to RGS Taxonomie version 2.0?
Version 2.0 was published 12 jan, 2017 (Download link)

Predefined 'Chart of accounts' for Company type

The idea is to build a module to load automatically a different chart of account based on the kind of the company that is running the system. Any input on this?

Dutch community modules icon

Will be nice to stamp all the modules related with our localization project with our own icon: is a very small thing but I think is nice to have a symbol to identify our work as a community.

For now we don't have anything so all the ideas and suggestions will be greatly appreciated!

XAF export not stored

When exporting a XAF audit for companies with a high number of journal entries the computation can take longer then for example the nginx time-out time or the employee's work time :)

Can we attach generated XAF files to the object and add a list view so we can see and reload historic XAF files?

Thank you.
Cas

V9: traceback error on l10n_nl_xaf_auditfile_export

I get an error when trying to generate an audit file with your module. Can anyone enlighten me what is wrong with the module or the data?

Traceback (most recent call last):
....
File "/opt/odoo/enterprise/web/controllers/main.py", line 902, in _call_kw
return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
File "/opt/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/openerp/api.py", line 381, in old_api
result = method(recs, args, **kwargs)
File "/opt/odoo/openerp/addons/l10n_nl_xaf_auditfile_export/models/xaf_auditfile_export.py", line 123, in button_generate
'XmlAuditfileFinancieel3.2.xsd'))))
File "xmlschema.pxi", line 102, in lxml.etree.XMLSchema.init (src/lxml/lxml.etree.c:168126)
XMLSchemaParseError: Element '{http://www.w3.org/2001/XMLSchema}restriction': The content is not valid. Expected is (annotation?, (simpleType?, (minExclusive | minInclusive | maxExclusive | maxInclusive | totalDigits | fractionDigits | length | minLength | maxLength | enumeration | whiteSpace | pattern)))., line 639

Error when generating Auditfile - country': 'AX' is not a valid value

When you export an Auditfile you get this error. AX is a valid country:
https://en.wikipedia.org/wiki/ISO_3166-2:AX

:205:0:ERROR:SCHEMASV:SCHEMAV_CVC_ENUMERATION_VALID: Element '{http://www.auditfiles.nl/XAF/3.2}country': [facet 'enumeration'] The value 'AX' is not an element of the set {'AD', 'AE', 'AF', 'AG', 'AI', 'AL', 'AM', 'AN', 'AO', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AW', 'AZ', 'BA', 'BB', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BM', 'BN', 'BO', 'BR', 'BS', 'BT', 'BV', 'BW', 'BY', 'BZ', 'CA', 'CC', 'CD', 'CF', 'CG', 'CH', 'CI', 'CK', 'CL', 'CM', 'CN', 'CO', 'CR', 'CS', 'CU', 'CV', 'CX', 'CY', 'CZ', 'DE', 'DJ', 'DK', 'DM', 'DO', 'DZ', 'EC', 'EE', 'EG', 'EH', 'ER', 'ES', 'ET', 'FI', 'FJ', 'FK', 'FM', 'FO', 'FR', 'GA', 'GB', 'GD', 'GE', 'GF', 'GH', 'GI', 'GL', 'GM', 'GN', 'GP', 'GQ', 'GR', 'GS', 'GT', 'GU', 'GW', 'GY', 'HK', 'HM', 'HN', 'HR', 'HT', 'HU', 'ID', 'IE', 'IL', 'IM', 'IN', 'IO', 'IQ', 'IR', 'IS', 'IT', 'JM', 'JO', 'JP', 'KE', 'KG', 'KH', 'KI', 'KM', 'KN', 'KP', 'KR', 'KW', 'KY', 'KZ', 'LA', 'LB', 'LC', 'LI', 'LK', 'LR', 'LS', 'LT', 'LU', 'LV', 'LY', 'MA', 'MC', 'MD', 'MG', 'MH', 'MK', 'ML', 'MM', 'MN', 'MO', 'MP', 'MQ', 'MR', 'MS', 'MT', 'MU', 'MV', 'MW', 'MX', 'MY', 'MZ', 'NA', 'NC', 'NE', 'NF', 'NG', 'NI', 'NL', 'NO', 'NP', 'NR', 'NU', 'NZ', 'OM', 'PA', 'PE', 'PF', 'PG', 'PH', 'PK', 'PL', 'PM', 'PN', 'PR', 'PS', 'PT', 'PW', 'PY', 'QA', 'RE', 'RO', 'RU', 'RW', 'SA', 'SB', 'SC', 'SD', 'SE', 'SG', 'SH', 'SI', 'SJ', 'SK', 'SL', 'SM', 'SN', 'SO', 'SR', 'ST', 'SV', 'SY', 'SZ', 'TC', 'TD', 'TF', 'TG', 'TH', 'TJ', 'TK', 'TL', 'TM', 'TN', 'TO', 'TR', 'TT', 'TV', 'TW', 'TZ', 'UA', 'UG', 'UK', 'UM', 'US', 'UY', 'UZ', 'VA', 'VC', 'VE', 'VG', 'VI', 'VN', 'VU', 'WF', 'WS', 'YE', 'YT', 'ZA', 'ZM', 'ZW'}.

:205:0:ERROR:SCHEMASV:SCHEMAV_CVC_DATATYPE_VALID_1_2_1: Element '{http://www.auditfiles.nl/XAF/3.2}country': 'AX' is not a valid value of the atomic type '{http://www.auditfiles.nl/XAF/3.2}CountrycodeIso3166'.

Government communication modules

The Dutch government provide different services (https://data.overheid.nl/data/dataset) to retrieve information like:

• Company info form KvK
• Car info from RDW
• BAG info
• ....

Will be nice to implement modules for that...possibly based on a unique platform. Open discussion below...

By default installed or not?

Odoo has already some default Dutch stuff (like ledger accounts, VAT, etc.).

So is this l10n-netherlands by default installed in Odoo (it's different than l10n_nl add-on)? If not, what does it really add more?

And will this module be added by default in Odoo v11?

Kind regards,
Melroy

NL BTW statement, date range not working

When creating a new NL BTW Statement I select a date range. Unfortunately the date range is not used in de two date fields in the NL BTW Statement form.

Postcode API

This is a great addition for Dutch users. Now it relies on a single provider. It would also be great to be able to use other providers like: overheid.io, postcodes.nl or even directly from the government via: kadaster. This way it would be less dependent and more robust and flexible.