← Back to team overview

openerp-dutch team mailing list archive

lp:~therp-nl/openobject-addons/7.0-lp1027893-l10n_nl-add_fiscal_positions into lp:openobject-addons

 

Stefan Rijnhart (Therp) has proposed merging lp:~therp-nl/openobject-addons/7.0-lp1027893-l10n_nl-add_fiscal_positions into lp:openobject-addons.

Requested reviews:
  OpenERP Dutch Team - Nederland (openerp-dutch)
  OpenERP Core Team (openerp)
Related bugs:
  Bug #1027893 in OpenERP Addons: "[trunk] l10n_nl: no fiscal positions preconfigured"
  https://bugs.launchpad.net/openobject-addons/+bug/1027893

For more details, see:
https://code.launchpad.net/~therp-nl/openobject-addons/7.0-lp1027893-l10n_nl-add_fiscal_positions/+merge/116249

This branch adds fiscal positions for partners inside and outside the EU to the Dutch chart of accounts for new installations.

-- 
https://code.launchpad.net/~therp-nl/openobject-addons/7.0-lp1027893-l10n_nl-add_fiscal_positions/+merge/116249
Your team OpenERP Dutch Team - Nederland is requested to review the proposed merge of lp:~therp-nl/openobject-addons/7.0-lp1027893-l10n_nl-add_fiscal_positions into lp:openobject-addons.
=== modified file 'l10n_nl/__openerp__.py'
--- l10n_nl/__openerp__.py	2011-12-19 16:54:40 +0000
+++ l10n_nl/__openerp__.py	2012-07-23 11:27:30 +0000
@@ -118,6 +118,9 @@
                  ],
     "init_xml" : [],
     "update_xml" : ["account_chart_netherlands.xml",
+                    "account_fiscal_position_template.xml",
+                    "account_fiscal_position_tax_template.xml",
+                    "account_fiscal_position_account_template.xml",
                     "l10n_nl_wizard.xml"
                    ],
     "demo_xml" : [

=== added file 'l10n_nl/account_fiscal_position_account_template.xml'
--- l10n_nl/account_fiscal_position_account_template.xml	1970-01-01 00:00:00 +0000
+++ l10n_nl/account_fiscal_position_account_template.xml	2012-07-23 11:27:30 +0000
@@ -0,0 +1,245 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <!-- Fiscal Position Account Templates -->
+
+        <!-- Position 2 - NON-EU Countries -->
+        <!-- inkopen laag -->
+        <record
+            id="position_account_non_eu_purchase_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_7001" />
+            <field name="account_dest_id" ref="l10n_nl.a_7017" />
+        </record>
+        <!-- inkopen hoog. NB: id not according to convention! -->
+        <record
+            id="position_account_non_eu_purchase_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_expense" />
+            <field name="account_dest_id" ref="l10n_nl.a_7018" />
+        </record>
+        <!-- inkopen overig -->
+        <record
+            id="position_account_non_eu_purchase_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_7003" />
+            <field name="account_dest_id" ref="l10n_nl.a_7019" />
+        </record>
+        <!-- verkopen fabricage -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_non_eu_production_sales_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8001" />
+            <field name="account_dest_id" ref="l10n_nl.a_8020" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_non_eu_production_sales_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8002" />
+            <field name="account_dest_id" ref="l10n_nl.a_8020" />
+        </record>   
+        <!-- verkopen overig -->
+        <record
+            id="position_account_non_eu_sales_production_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8003" />
+            <field name="account_dest_id" ref="l10n_nl.a_8020" />
+        </record>  
+        <!-- verkopen handel -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_non_eu_sales_trade_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8011" />
+            <field name="account_dest_id" ref="l10n_nl.a_8021" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_non_eu_sales_trade_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_sale" />
+            <field name="account_dest_id" ref="l10n_nl.a_8021" />
+        </record>   
+        <!-- verkopen overig -->
+        <record
+            id="position_account_non_eu_sales_trade_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8013" />
+            <field name="account_dest_id" ref="l10n_nl.a_8021" />
+        </record>   
+        <!-- verkopen diensten fabricage -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_non_eu_sales_service_production_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8041" />
+            <field name="account_dest_id" ref="l10n_nl.a_8060" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_non_eu_sales_service_production_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8042" />
+            <field name="account_dest_id" ref="l10n_nl.a_8060" />
+        </record>   
+        <!-- verkopen overig -->
+        <record
+            id="position_account_non_eu_sales_service_production_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8043" />
+            <field name="account_dest_id" ref="l10n_nl.a_8060" />
+        </record>  
+        <!-- verkopen diensten handel -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_non_eu_sales_service_trade_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8051" />
+            <field name="account_dest_id" ref="l10n_nl.a_8061" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_non_eu_sales_service_trade_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_non_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8052" />
+            <field name="account_dest_id" ref="l10n_nl.a_8061" />
+        </record>   
+        <!-- verkopen overig: is er niet?? -->
+        
+        <!-- Position 3 - EU Countries -->
+        <!-- inkopen laag -->
+        <record
+            id="position_account_eu_purchase_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_7001" />
+            <field name="account_dest_id" ref="l10n_nl.a_7014" />
+        </record>
+        <!-- inkopen hoog -->
+        <record
+            id="position_account_eu_purchase_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_expense" />
+            <field name="account_dest_id" ref="l10n_nl.a_7015" />
+        </record>
+        <!-- inkopen overig -->
+        <record
+            id="position_account_eu_purchase_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_7003" />
+            <field name="account_dest_id" ref="l10n_nl.a_7016" />
+        </record>
+        <!-- verkopen fabricage -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_eu_sales_production_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8001" />
+            <field name="account_dest_id" ref="l10n_nl.a_8000" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_eu_sales_production_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8002" />
+            <field name="account_dest_id" ref="l10n_nl.a_8000" />
+        </record>   
+        <!-- verkopen overig -->
+        <record
+            id="position_account_eu_sales_production_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8003" />
+            <field name="account_dest_id" ref="l10n_nl.a_8000" />
+        </record>  
+        <!-- verkopen handel -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_eu_sales_trade_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8011" />
+            <field name="account_dest_id" ref="l10n_nl.a_8010" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_eu_sales_trade_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_sale" />
+            <field name="account_dest_id" ref="l10n_nl.a_8010" />
+        </record>   
+        <!-- verkopen overig -->
+        <record
+            id="position_account_eu_sales_trade_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8013" />
+            <field name="account_dest_id" ref="l10n_nl.a_8010" />
+        </record>   
+        <!-- verkopen diensten fabricage -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_eu_sales_service_production_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8041" />
+            <field name="account_dest_id" ref="l10n_nl.a_8040" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_eu_sales_service_production_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8042" />
+            <field name="account_dest_id" ref="l10n_nl.a_8040" />
+        </record>   
+        <!-- verkopen overig -->
+        <record
+            id="position_account_eu_sales_service_production_other"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8043" />
+            <field name="account_dest_id" ref="l10n_nl.a_8040" />
+        </record>  
+        <!-- verkopen diensten handel -->
+        <!-- verkopen laag -->
+        <record
+            id="position_account_eu_sales_service_trade_low"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8051" />
+            <field name="account_dest_id" ref="l10n_nl.a_8050" />
+        </record>     
+        <!-- verkopen hoog -->
+        <record
+            id="position_account_eu_sales_service_trade_high"
+            model="account.fiscal.position.account.template">
+            <field name="position_id"     ref="fiscal_position_template_eu" />
+            <field name="account_src_id"  ref="l10n_nl.a_8052" />
+            <field name="account_dest_id" ref="l10n_nl.a_8050" />
+        </record>   
+        <!-- verkopen overig: is er niet?? -->
+
+    </data>
+</openerp>
\ No newline at end of file

=== added file 'l10n_nl/account_fiscal_position_tax_template.xml'
--- l10n_nl/account_fiscal_position_tax_template.xml	1970-01-01 00:00:00 +0000
+++ l10n_nl/account_fiscal_position_tax_template.xml	2012-07-23 11:27:30 +0000
@@ -0,0 +1,97 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<openerp>
+    <data>
+
+        <!-- account.fiscal.position.tax.template -->
+        
+        <!-- Position 2 - NON-EU Countries -->
+        <!--  All sales tax will become 0 -->
+        <record id="position_tax_extracom_1" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_0"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X1"/>
+        </record>
+        <record id="position_tax_extracom_2" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_6"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X1"/>
+        </record>
+        <record id="position_tax_extracom_3" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_19"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X1"/>
+        </record>
+        <record id="position_tax_extracom_4" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_overig"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X1"/>
+        </record>
+        
+        <!-- VAT on buying from outside the EU -->
+        <!-- VAT low -->
+        <record id="position_tax_extracom_5" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_6_buy"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_E1"/>
+        </record>
+        <!-- VAT high -->
+        <record id="position_tax_extracom_6" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_19_buy"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_E2"/>
+        </record>
+        <!-- VAT other -->
+        <record id="position_tax_extracom_7" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_non_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_overig_buy"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_E_overig"/>
+        </record>
+        <!-- Belgian schema has many more lines here.... -->
+        
+        <!-- Position 3 - EU Countries -->
+        <record id="position_tax_intracom_1" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_0"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X0"/>
+        </record>
+        <record id="position_tax_intracom_2" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_6"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X0"/>
+        </record>
+        <record id="position_tax_intracom_3" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_19"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X0"/>
+        </record>
+        <record id="position_tax_intracom_4" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_overig"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_X0"/>
+        </record>
+        
+        <!-- In source-tax we lack the separation of goods and services,
+             therefore no lines now for "Installatie/Afstandsverkopen. -->
+             
+        <!-- Buying from other EU countries (only goods = VAT 0 -->
+        <record id="position_tax_intracom_5" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_6_buy"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_I_6"/>
+        </record>
+        <record id="position_tax_intracom_6" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_19_buy"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_I_19"/>
+        </record>
+        <record id="position_tax_intracom_7" model="account.fiscal.position.tax.template">
+            <field name="position_id" ref="fiscal_position_template_eu"/>
+            <field name="tax_src_id" ref="l10n_nl.btw_overig_buy"/>
+            <field name="tax_dest_id" ref="l10n_nl.btw_I_overig"/>
+        </record>
+        
+        <!-- Again, Belgian schema has 17 (!) more records. Missing VAT 0
+             and separation of goods and services .. -->
+
+    </data>
+</openerp>

=== added file 'l10n_nl/account_fiscal_position_template.xml'
--- l10n_nl/account_fiscal_position_template.xml	1970-01-01 00:00:00 +0000
+++ l10n_nl/account_fiscal_position_template.xml	2012-07-23 11:27:30 +0000
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <!-- Fiscal Position Templates -->
+        
+        <!--  for the moment no use for this 
+        <record
+            id="fiscal_position_template_domestic"
+            model="account.fiscal.position.template">
+            <field name="name">Binnenland</field>
+            <field
+                name="chart_template_id"
+                ref="l10nnl_chart_template" />
+        </record>
+        -->
+        <record
+            id="fiscal_position_template_eu"
+            model="account.fiscal.position.template">
+	    <field name="name">EU landen</field>
+            <field
+                name="chart_template_id"
+                ref="l10nnl_chart_template" />
+        </record>
+        <record
+            id="fiscal_position_template_non_eu"
+            model="account.fiscal.position.template">
+            <field name="name">Niet-EU landen</field>
+            <field
+                name="chart_template_id"
+                ref="l10nnl_chart_template" />
+        </record>
+    </data>
+</openerp>


Follow ups