oca / l10n-netherlands Goto Github PK
View Code? Open in Web Editor NEWOdoo Dutch Localization
License: GNU Affero General Public License v3.0
Odoo Dutch Localization
License: GNU Affero General Public License v3.0
missing: country code = RS
in: l10n_nl_xaf_auditfile_export/data/XmlAuditfileFinancieel3.2.xsd
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!
Error in line 67:
Should be: due to the changes in V11
But after changing this, the report is created but empty
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
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.
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
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
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...
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'.
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
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)
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
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="{"widget": "auditfile.string50"}"/></custSupName>
<contact t-if="p.is_company and p.child_ids"><t t-esc="p.child_ids[0].name" t-esc-options="{"widget": "auditfile.string50"}"/></contact>
<telephone><t t-esc="p.phone" t-esc-options="{"widget": "auditfile.string30"}"/></telephone>
<fax><t t-esc="p.fax" t-esc-options="{"widget": "auditfile.string30"}"/></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="{"widget": "auditfile.string30"}"/></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="{"widget": "auditfile.string999"}"/></streetname>
<number/>
<numberExtension/>
<property/>
<city><t t-esc="p.city" t-esc-options="{"widget": "auditfile.string50"}"/></city>
<postalCode><t t-esc="p.zip" t-esc-options="{"widget": "auditfile.string10"}"/></postalCode>
<region><t t-esc="p.state_id.name" t-esc-options="{"widget": "auditfile.string50"}"/></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>
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)
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
https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-10.0
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
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
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.
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.
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()'
When testing by our customer we have noted a few bugs. We will create PR soon for the fixes:
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
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)
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.
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.
Based on the OCA intrastat base we should provide a correct Intrastat report
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?
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.
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?
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>
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).
https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-11.0
The current version does not support the change in taxes from 6% to 9%.
Setup:
The Dutch government provide different services (https://data.overheid.nl/data/dataset) to retrieve information like:
Will be nice to implement modules for that...possibly based on a unique platform. Open discussion below...
https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-9.0
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.
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.
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).
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.
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
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:
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:
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...
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:
If someone can give feedback, I can create a patch for this.
Odoo 9 sprint shared goals for September 9th 2015.
Hi,
I want to help by translation the Dutch modules. But it seems l10n-netherlands is not on Transifex.
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.