From d490560859771a16bf99b7a992ff4fd0247e908a Mon Sep 17 00:00:00 2001
From: "Turkesh Patel (Open ERP)" <tpa@tinyerp.com>
Date: Tue, 30 Apr 2013 16:58:38 +0530
Subject: [PATCH] [IMP] improved data and sign for tax paid.

bzr revid: tpa@tinyerp.com-20130430112838-ub3x3iko5pnui1yp
---
 addons/l10n_in/l10n_in_public_tax_template.xml |   93 ++++++++++++------------
 addons/l10n_in/l10n_in_tax_code_template.xml   |   17 +++--
 2 files changed, 57 insertions(+), 53 deletions(-)

diff --git a/addons/l10n_in/l10n_in_public_tax_template.xml b/addons/l10n_in/l10n_in_public_tax_template.xml
index aaf51b5..f848045 100644
--- a/addons/l10n_in/l10n_in_public_tax_template.xml
+++ b/addons/l10n_in/l10n_in_public_tax_template.xml
@@ -104,6 +104,7 @@
         <field name="type_tax_use">purchase</field>
         <field name="type">percent</field>
         <field name="amount">0.0200</field>
+        <field name="sequence">3</field>
         <field name="account_collected_id" ref="p154009"/>
         <field name="account_paid_id" ref="p154009"/>
         <field name="tax_code_id" ref="vat_code_tax_pay_ic_edu_cess"/>
@@ -117,6 +118,7 @@
         <field name="type_tax_use">purchase</field>
         <field name="type">percent</field>
         <field name="amount">0.0100</field>
+        <field name="sequence">5</field>
         <field name="account_collected_id" ref="p154002"/>
         <field name="account_paid_id" ref="p154002"/>
         <field name="tax_code_id" ref="vat_code_tax_pay_ic_seco_hec"/>
@@ -137,47 +139,6 @@
         <field name="chart_template_id" ref="indian_chart_template_public"/>
     </record>
 
-    <record id="account_tax_exic6_pur" model="account.tax.template">
-        <field name="name">Input Excise Duty 6%</field>
-        <field name="description">Input Excise Duty 6%</field>
-        <field name="type_tax_use">purchase</field>
-        <field name="type">percent</field>
-        <field name="amount">0.0600</field>
-        <field name="account_collected_id" ref="p154011"/>
-        <field name="account_paid_id" ref="p154011"/>
-        <field name="base_code_id" ref="vat_code_tax_pur_vat"/>
-        <field name="tax_code_id" ref="vat_code_tax_pay_exice6"/>
-        <field name="chart_template_id" ref="indian_chart_template_public"/>
-    </record>
-
-    <record id="account_tax_exice6_edu_cess2_pur" model="account.tax.template">
-        <field name="name">Education Cess 2% Purchase</field>
-        <field name="description">Education Cess 2% Purchase</field>
-        <field name="type_tax_use">purchase</field>
-        <field name="type">percent</field>
-        <field name="amount">0.0200</field>
-        <field name="sequence">21</field>
-        <field name="account_collected_id" ref="p154014"/>
-        <field name="account_paid_id" ref="p154014"/>
-        <field name="tax_code_id" ref="vat_code_tax_pay_cess2"/>
-        <field name="parent_id" ref="account_tax_exic6_pur"/>
-        <field name="chart_template_id" ref="indian_chart_template_public"/>
-    </record>
-
-    <record id="account_tax_exice6_seco_high_cess_pur" model="account.tax.template">
-        <field name="name">Seco. &amp; Higher Edu. Cess 1% Purchase</field>
-        <field name="description">Seco. &amp; Higher Edu. Cess 1% Purchase</field>
-        <field name="type_tax_use">all</field>
-        <field name="type">percent</field>
-        <field name="amount">0.0100</field>
-        <field name="sequence">22</field>
-        <field name="account_collected_id" ref="p154015"/>
-        <field name="account_paid_id" ref="p154015"/>
-        <field name="tax_code_id" ref="vat_code_tax_pay_sec_hig_edu"/>
-        <field name="parent_id" ref="account_tax_exic6_pur"/>
-        <field name="chart_template_id" ref="indian_chart_template_public"/>
-    </record>
-
     <record id="account_tax_exic5_pur" model="account.tax.template">
         <field name="name">Input Excise Duty 5%</field>
         <field name="description">Input Excise Duty 5%</field>
@@ -253,7 +214,7 @@
         <field name="type_tax_use">sale</field>
         <field name="type">percent</field>
         <field name="amount">0.0200</field>
-        <field name="sequence">2</field>
+        <field name="sequence">3</field>
         <field name="account_collected_id" ref="p247010"/>
         <field name="account_paid_id" ref="p247010"/>
         <field name="tax_code_id" ref="vat_code_tax_rec_cess2"/>
@@ -267,7 +228,7 @@
         <field name="type_tax_use">sale</field>
         <field name="type">percent</field>
         <field name="amount">0.0100</field>
-        <field name="sequence">3</field>
+        <field name="sequence">5</field>
         <field name="account_collected_id" ref="p247002"/>
         <field name="account_paid_id" ref="p247002"/>
         <field name="tax_code_id" ref="vat_code_tax_rec_sec_hig_cess"/>
@@ -635,6 +596,48 @@
         <field name="chart_template_id" ref="indian_chart_template_public"/>
     </record>
 
+    <record id="account_tax_exic6_pur" model="account.tax.template">
+        <field name="name">Input Excise Duty 6%</field>
+        <field name="description">Input Excise Duty 6%</field>
+        <field name="type_tax_use">purchase</field>
+        <field name="type">percent</field>
+        <field name="amount">0.0600</field>
+        <field name="sequence">1</field>
+        <field name="account_collected_id" ref="p154011"/>
+        <field name="account_paid_id" ref="p154011"/>
+        <field name="base_code_id" ref="vat_code_tax_pur_vat"/>
+        <field name="tax_code_id" ref="vat_code_tax_pay_exice6"/>
+        <field name="chart_template_id" ref="indian_chart_template_public"/>
+    </record>
+
+    <record id="account_tax_exice6_edu_cess2_pur" model="account.tax.template">
+        <field name="name">Education Cess 2% Purchase</field>
+        <field name="description">Education Cess 2% Purchase</field>
+        <field name="type_tax_use">purchase</field>
+        <field name="type">percent</field>
+        <field name="amount">0.0200</field>
+        <field name="sequence">21</field>
+        <field name="account_collected_id" ref="p154014"/>
+        <field name="account_paid_id" ref="p154014"/>
+        <field name="tax_code_id" ref="vat_code_tax_pay_cess2"/>
+        <field name="parent_id" ref="account_tax_exic6_pur"/>
+        <field name="chart_template_id" ref="indian_chart_template_public"/>
+    </record>
+
+    <record id="account_tax_exice6_seco_high_cess_pur" model="account.tax.template">
+        <field name="name">Seco. &amp; Higher Edu. Cess 1% Purchase</field>
+        <field name="description">Seco. &amp; Higher Edu. Cess 1% Purchase</field>
+        <field name="type_tax_use">all</field>
+        <field name="type">percent</field>
+        <field name="amount">0.0100</field>
+        <field name="sequence">22</field>
+        <field name="account_collected_id" ref="p154015"/>
+        <field name="account_paid_id" ref="p154015"/>
+        <field name="tax_code_id" ref="vat_code_tax_pay_sec_hig_edu"/>
+        <field name="parent_id" ref="account_tax_exic6_pur"/>
+        <field name="chart_template_id" ref="indian_chart_template_public"/>
+    </record>
+
     <record id="account_tax_ser12_sale" model="account.tax.template">
         <field name="name">Service Tax 12% - Sales</field>
         <field name="description">Service Tax 12% - Sales</field>
@@ -655,7 +658,7 @@
         <field name="type_tax_use">sale</field>
         <field name="type">percent</field>
         <field name="amount">0.02</field>
-        <field name="sequence">1</field>
+        <field name="sequence">3</field>
         <field name="account_collected_id" ref="p24740"/>
         <field name="account_paid_id" ref="p24740"/>
         <field name="tax_code_id" ref="vat_code_tax_rec_st2"/>
@@ -669,7 +672,7 @@
         <field name="type_tax_use">sale</field>
         <field name="type">percent</field>
         <field name="amount">0.01</field>
-        <field name="sequence">1</field>
+        <field name="sequence">5</field>
         <field name="account_collected_id" ref="p24740"/>
         <field name="account_paid_id" ref="p24740"/>
         <field name="tax_code_id" ref="vat_code_tax_rec_st1"/>
diff --git a/addons/l10n_in/l10n_in_tax_code_template.xml b/addons/l10n_in/l10n_in_tax_code_template.xml
index c547b84..b067ef6 100644
--- a/addons/l10n_in/l10n_in_tax_code_template.xml
+++ b/addons/l10n_in/l10n_in_tax_code_template.xml
@@ -19,6 +19,7 @@
 
         <record model="account.tax.code.template" id="vat_code_payable">
             <field name="name">Tax Paid</field>
+            <field name="sign">-1</field>
             <field name="parent_id" ref="vat_code_balance_net"/>
         </record>
 
@@ -52,6 +53,11 @@
             <field name="parent_id" ref="vat_code_tax_rec"/>
         </record>
 
+        <record model="account.tax.code.template" id="vat_code_tax_sale_ser12">
+            <field name="name">Sales Service Tax 12%</field>
+            <field name="parent_id" ref="vat_code_base_tax_sale"/>
+        </record>
+
         <record model="account.tax.code.template" id="vat_code_tax_rec_exice12">
             <field name="name">Excise Duty 12% - Sales</field>
             <field name="parent_id" ref="vat_code_tax_rec_exice_salebase"/>
@@ -208,7 +214,7 @@
         </record>
 
         <record model="account.tax.code.template" id="vat_code_tax_pay_tds_dir_intrest">
-            <field name="name"> TDS on Director's Interest</field>
+            <field name="name">TDS on Director's Interest</field>
             <field name="parent_id" ref="vat_code_payable"/>
         </record>
 
@@ -268,7 +274,7 @@
         </record>
 
         <record model="account.tax.code.template" id="vat_code_tax_sale_cst15">
-            <field name="name">CST 5% on Sales</field>
+            <field name="name">Sales CST 5%</field>
             <field name="parent_id" ref="vat_code_base_tax_sale"/>
         </record>
 
@@ -358,7 +364,7 @@
         </record>
 
         <record model="account.tax.code.template" id="vat_code_tax_sal_sez_in_guj">
-            <field name="name">Sales Export - SEZ - In Gujarat </field>
+            <field name="name">Sales Export - SEZ - In Gujarat</field>
             <field name="parent_id" ref="vat_code_base_tax_sale"/>
         </record>
 
@@ -422,10 +428,5 @@
             <field name="parent_id" ref="vat_code_tax_rec_st_salebase"/>
         </record>
 
-        <record model="account.tax.code.template" id="vat_code_tax_sale_ser12">
-            <field name="name">Service Tax 12% - Sales</field>
-            <field name="parent_id" ref="vat_code_base_tax_sale"/>
-        </record>
-
     </data>
 </openerp>
-- 
1.7.10.4