blob: ec4da0db651e3e5ccf4572ef350c4277fa95def6 [file] [log] [blame]
Rushabh Mehtab3c8f442017-06-21 17:22:38 +05301# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
2# License: GNU General Public License v3. See license.txt
3
4from __future__ import unicode_literals
5
6import frappe, os, json
Rushabh Mehtaf0569742017-09-13 12:52:30 +05307from frappe.custom.doctype.custom_field.custom_field import create_custom_fields
Rushabh Mehtab3c8f442017-06-21 17:22:38 +05308from frappe.permissions import add_permission
9from erpnext.regional.india import states
Zarrar7f8024c2018-08-01 17:45:05 +053010from erpnext.accounts.utils import get_fiscal_year
11from frappe.utils import today
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053012
Rushabh Mehta01659272017-06-27 18:05:17 +053013def setup(company=None, patch=True):
Prateeksha Singhdabf3492018-11-13 15:56:15 +053014 setup_company_independent_fixtures()
Prateeksha Singh39b87652018-11-12 17:19:56 +053015 if not patch:
16 update_address_template()
Prateeksha Singhdabf3492018-11-13 15:56:15 +053017 make_fixtures(company)
Prateeksha Singh39b87652018-11-12 17:19:56 +053018
19# TODO: for all countries
20def setup_company_independent_fixtures():
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053021 make_custom_fields()
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053022 add_permissions()
Rushabh Mehta919a74a2017-06-22 16:37:04 +053023 add_custom_roles_for_reports()
Nabin Haitc3144852017-09-28 18:55:40 +053024 frappe.enqueue('erpnext.regional.india.setup.add_hsn_sac_codes', now=frappe.flags.in_test)
Nabin Hait852cb642017-07-05 12:58:19 +053025 add_print_formats()
Rushabh Mehta919a74a2017-06-22 16:37:04 +053026
27def update_address_template():
28 with open(os.path.join(os.path.dirname(__file__), 'address_template.html'), 'r') as f:
29 html = f.read()
30
31 address_template = frappe.db.get_value('Address Template', 'India')
32 if address_template:
33 frappe.db.set_value('Address Template', 'India', 'template', html)
34 else:
35 # make new html template for India
Rushabh Mehta9b09ff22017-06-27 12:17:39 +053036 frappe.get_doc(dict(
Rushabh Mehta919a74a2017-06-22 16:37:04 +053037 doctype='Address Template',
38 country='India',
39 template=html
Rushabh Mehta9b09ff22017-06-27 12:17:39 +053040 )).insert()
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053041
Nabin Hait1a609312017-07-13 12:16:04 +053042def add_hsn_sac_codes():
43 # HSN codes
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053044 with open(os.path.join(os.path.dirname(__file__), 'hsn_code_data.json'), 'r') as f:
45 hsn_codes = json.loads(f.read())
46
Nabin Hait1a609312017-07-13 12:16:04 +053047 create_hsn_codes(hsn_codes, code_field="hsn_code")
Prateeksha Singh95d8fd32017-09-04 11:14:04 +053048
Nabin Hait1a609312017-07-13 12:16:04 +053049 # SAC Codes
50 with open(os.path.join(os.path.dirname(__file__), 'sac_code_data.json'), 'r') as f:
51 sac_codes = json.loads(f.read())
52 create_hsn_codes(sac_codes, code_field="sac_code")
Prateeksha Singh95d8fd32017-09-04 11:14:04 +053053
Nabin Hait1a609312017-07-13 12:16:04 +053054def create_hsn_codes(data, code_field):
55 for d in data:
Rushabh Mehtaf702d722017-09-27 15:31:30 +053056 hsn_code = frappe.new_doc('GST HSN Code')
57 hsn_code.description = d["description"]
58 hsn_code.hsn_code = d[code_field]
59 hsn_code.name = d[code_field]
60 try:
Nabin Hait1a609312017-07-13 12:16:04 +053061 hsn_code.db_insert()
Rushabh Mehtaf702d722017-09-27 15:31:30 +053062 except frappe.DuplicateEntryError:
63 pass
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053064
Rushabh Mehta919a74a2017-06-22 16:37:04 +053065def add_custom_roles_for_reports():
66 for report_name in ('GST Sales Register', 'GST Purchase Register',
rohitwaghchaure8cca61f2018-08-20 17:53:56 +053067 'GST Itemised Sales Register', 'GST Itemised Purchase Register', 'Eway Bill'):
Rushabh Mehta919a74a2017-06-22 16:37:04 +053068
Rushabh Mehta919a74a2017-06-22 16:37:04 +053069 if not frappe.db.get_value('Custom Role', dict(report=report_name)):
70 frappe.get_doc(dict(
71 doctype='Custom Role',
72 report=report_name,
73 roles= [
74 dict(role='Accounts User'),
75 dict(role='Accounts Manager')
76 ]
77 )).insert()
78
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053079def add_permissions():
Rushabh Mehta00ae4242017-06-27 17:31:41 +053080 for doctype in ('GST HSN Code', 'GST Settings'):
Rushabh Mehtab3c8f442017-06-21 17:22:38 +053081 add_permission(doctype, 'All', 0)
82
Nabin Hait852cb642017-07-05 12:58:19 +053083def add_print_formats():
84 frappe.reload_doc("regional", "print_format", "gst_tax_invoice")
rohitwaghchauree3b5c0f2017-12-16 10:53:53 +053085 frappe.reload_doc("accounts", "print_format", "gst_pos_invoice")
86
87 frappe.db.sql(""" update `tabPrint Format` set disabled = 0 where
88 name in('GST POS Invoice', 'GST Tax Invoice') """)
Nabin Hait852cb642017-07-05 12:58:19 +053089
Rushabh Mehta69fa8082018-07-17 18:22:51 +053090def make_custom_fields(update=True):
Nabin Haitf3f0dfe2017-07-06 14:49:34 +053091 hsn_sac_field = dict(fieldname='gst_hsn_code', label='HSN/SAC',
Nabin Haitd34bfa82018-11-13 18:19:58 +053092 fieldtype='Data', fetch_from='item_code.gst_hsn_code', insert_after='description',
Nabin Haite5716e32017-09-11 19:21:37 +053093 allow_on_submit=1, print_hide=1)
Nabin Hait879e1622017-08-21 08:28:55 +053094 invoice_gst_fields = [
95 dict(fieldname='gst_section', label='GST Details', fieldtype='Section Break',
vishdha109b4082018-01-30 12:11:13 +053096 insert_after='language', print_hide=1, collapsible=1),
Nabin Hait879e1622017-08-21 08:28:55 +053097 dict(fieldname='invoice_copy', label='Invoice Copy',
98 fieldtype='Select', insert_after='gst_section', print_hide=1, allow_on_submit=1,
99 options='Original for Recipient\nDuplicate for Transporter\nDuplicate for Supplier\nTriplicate for Supplier'),
100 dict(fieldname='reverse_charge', label='Reverse Charge',
101 fieldtype='Select', insert_after='invoice_copy', print_hide=1,
102 options='Y\nN', default='N'),
Nabin Hait879e1622017-08-21 08:28:55 +0530103 dict(fieldname='invoice_type', label='Invoice Type',
Nabin Haite6d65bc2018-02-14 17:44:06 +0530104 fieldtype='Select', insert_after='invoice_copy', print_hide=1,
Nabin Hait879e1622017-08-21 08:28:55 +0530105 options='Regular\nSEZ\nExport\nDeemed Export', default='Regular'),
106 dict(fieldname='export_type', label='Export Type',
107 fieldtype='Select', insert_after='invoice_type', print_hide=1,
108 depends_on='eval:in_list(["SEZ", "Export", "Deemed Export"], doc.invoice_type)',
109 options='\nWith Payment of Tax\nWithout Payment of Tax'),
110 dict(fieldname='ecommerce_gstin', label='E-commerce GSTIN',
Vishal Dhayagudec463c062018-01-26 11:27:22 +0530111 fieldtype='Data', insert_after='export_type', print_hide=1),
Nabin Haite6d65bc2018-02-14 17:44:06 +0530112 dict(fieldname='gst_col_break', fieldtype='Column Break', insert_after='ecommerce_gstin'),
Vishal Dhayagudec463c062018-01-26 11:27:22 +0530113 dict(fieldname='reason_for_issuing_document', label='Reason For Issuing document',
Nabin Haitb02c1092018-02-05 16:09:51 +0530114 fieldtype='Select', insert_after='gst_col_break', print_hide=1,
Nabin Haite6d65bc2018-02-14 17:44:06 +0530115 depends_on='eval:doc.is_return==1',
Nabin Haita8d10b72018-02-12 16:54:13 +0530116 options='\n01-Sales Return\n02-Post Sale Discount\n03-Deficiency in services\n04-Correction in Invoice\n05-Change in POS\n06-Finalization of Provisional assessment\n07-Others')
Nabin Hait879e1622017-08-21 08:28:55 +0530117 ]
Prateeksha Singh95d8fd32017-09-04 11:14:04 +0530118
Nabin Hait879e1622017-08-21 08:28:55 +0530119 purchase_invoice_gst_fields = [
120 dict(fieldname='supplier_gstin', label='Supplier GSTIN',
121 fieldtype='Data', insert_after='supplier_address',
Shreya Shah4fa600a2018-06-05 11:27:53 +0530122 fetch_from='supplier_address.gstin', print_hide=1),
Nabin Hait879e1622017-08-21 08:28:55 +0530123 dict(fieldname='company_gstin', label='Company GSTIN',
Shreya Shah4fa600a2018-06-05 11:27:53 +0530124 fieldtype='Data', insert_after='shipping_address_display',
125 fetch_from='shipping_address.gstin', print_hide=1),
Nabin Haitb02c1092018-02-05 16:09:51 +0530126 dict(fieldname='place_of_supply', label='Place of Supply',
127 fieldtype='Data', insert_after='shipping_address',
128 print_hide=1, read_only=0),
deepeshgarg007d29ee972019-01-09 17:09:11 +0530129 ]
130
131 purchase_invoice_itc_fields = [
vishdha98e33c32018-01-29 13:57:34 +0530132 dict(fieldname='eligibility_for_itc', label='Eligibility For ITC',
133 fieldtype='Select', insert_after='reason_for_issuing_document', print_hide=1,
134 options='input\ninput service\ncapital goods\nineligible', default="ineligible"),
135 dict(fieldname='itc_integrated_tax', label='Availed ITC Integrated Tax',
136 fieldtype='Data', insert_after='eligibility_for_itc', print_hide=1),
137 dict(fieldname='itc_central_tax', label='Availed ITC Central Tax',
138 fieldtype='Data', insert_after='itc_integrated_tax', print_hide=1),
139 dict(fieldname='itc_state_tax', label='Availed ITC State/UT Tax',
140 fieldtype='Data', insert_after='itc_central_tax', print_hide=1),
141 dict(fieldname='itc_cess_amount', label='Availed ITC Cess',
142 fieldtype='Data', insert_after='itc_state_tax', print_hide=1),
Nabin Hait879e1622017-08-21 08:28:55 +0530143 ]
Prateeksha Singh95d8fd32017-09-04 11:14:04 +0530144
Nabin Hait879e1622017-08-21 08:28:55 +0530145 sales_invoice_gst_fields = [
rohitwaghchaure16645802017-09-28 11:05:03 +0530146 dict(fieldname='billing_address_gstin', label='Billing Address GSTIN',
147 fieldtype='Data', insert_after='customer_address',
Shreya Shah4fa600a2018-06-05 11:27:53 +0530148 fetch_from='customer_address.gstin', print_hide=1),
Nabin Hait879e1622017-08-21 08:28:55 +0530149 dict(fieldname='customer_gstin', label='Customer GSTIN',
Shreya Shah4fa600a2018-06-05 11:27:53 +0530150 fieldtype='Data', insert_after='shipping_address_name',
151 fetch_from='shipping_address_name.gstin', print_hide=1),
Nabin Hait879e1622017-08-21 08:28:55 +0530152 dict(fieldname='place_of_supply', label='Place of Supply',
Nabin Hait619c42b2018-01-10 17:48:03 +0530153 fieldtype='Data', insert_after='customer_gstin',
154 print_hide=1, read_only=0),
Nabin Hait879e1622017-08-21 08:28:55 +0530155 dict(fieldname='company_gstin', label='Company GSTIN',
156 fieldtype='Data', insert_after='company_address',
Shreya Shah4fa600a2018-06-05 11:27:53 +0530157 fetch_from='company_address.gstin', print_hide=1),
deepeshgarg007d29ee972019-01-09 17:09:11 +0530158 ]
159
160 sales_invoice_shipping_fields = [
vishdha98e33c32018-01-29 13:57:34 +0530161 dict(fieldname='port_code', label='Port Code',
162 fieldtype='Data', insert_after='reason_for_issuing_document', print_hide=1,
163 depends_on="eval:doc.invoice_type=='Export' "),
164 dict(fieldname='shipping_bill_number', label=' Shipping Bill Number',
165 fieldtype='Data', insert_after='port_code', print_hide=1,
166 depends_on="eval:doc.invoice_type=='Export' "),
167 dict(fieldname='shipping_bill_date', label='Shipping Bill Date',
168 fieldtype='Date', insert_after='shipping_bill_number', print_hide=1,
169 depends_on="eval:doc.invoice_type=='Export' ")
Nabin Hait879e1622017-08-21 08:28:55 +0530170 ]
Prateeksha Singh95d8fd32017-09-04 11:14:04 +0530171
Shreya Shah4fa600a2018-06-05 11:27:53 +0530172 inter_state_gst_field = [
173 dict(fieldname='is_inter_state', label='Is Inter State',
174 fieldtype='Check', insert_after='disabled', print_hide=1)
175 ]
176
Sagar Vorad92f3ac2018-10-10 14:51:26 +0530177 ewaybill_fields = [
178 {
179 'fieldname': 'distance',
180 'label': 'Distance (in km)',
181 'fieldtype': 'Float',
182 'insert_after': 'vehicle_no',
183 'print_hide': 1
184 },
185 {
186 'fieldname': 'gst_transporter_id',
187 'label': 'GST Transporter ID',
188 'fieldtype': 'Data',
189 'insert_after': 'transporter_name',
190 'fetch_from': 'transporter.gst_transporter_id',
191 'print_hide': 1
192 },
193 {
194 'fieldname': 'mode_of_transport',
195 'label': 'Mode of Transport',
196 'fieldtype': 'Select',
197 'options': '\nRoad\nAir\nRail\nShip',
198 'default': 'Road',
199 'insert_after': 'lr_date',
200 'print_hide': 1
201 },
202 {
203 'fieldname': 'gst_vehicle_type',
204 'label': 'GST Vehicle Type',
205 'fieldtype': 'Select',
206 'options': '\nRegular\nOver Dimensional Cargo (ODC)',
207 'default': 'Regular',
208 'depends_on': 'eval:(doc.mode_of_transport === "Road")',
209 'insert_after': 'mode_of_transport',
210 'print_hide': 1
211 }
212 ]
213
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530214 custom_fields = {
215 'Address': [
Rushabh Mehta919a74a2017-06-22 16:37:04 +0530216 dict(fieldname='gstin', label='Party GSTIN', fieldtype='Data',
217 insert_after='fax'),
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530218 dict(fieldname='gst_state', label='GST State', fieldtype='Select',
Nabin Haitf3f0dfe2017-07-06 14:49:34 +0530219 options='\n'.join(states), insert_after='gstin'),
220 dict(fieldname='gst_state_number', label='GST State Number',
Nabin Hait562d9422018-09-07 16:14:44 +0530221 fieldtype='Data', insert_after='gst_state', read_only=1),
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530222 ],
deepeshgarg007d29ee972019-01-09 17:09:11 +0530223 'Purchase Invoice': invoice_gst_fields + purchase_invoice_gst_fields + purchase_invoice_itc_fields,
224 'Purchase Order': purchase_invoice_gst_fields,
225 'Purchase Receipt': purchase_invoice_gst_fields,
226 'Sales Invoice': invoice_gst_fields + sales_invoice_gst_fields + sales_invoice_shipping_fields,
227 'Delivery Note': sales_invoice_gst_fields + ewaybill_fields + sales_invoice_shipping_fields,
228 'Sales Order': sales_invoice_gst_fields,
Shreya Shah4fa600a2018-06-05 11:27:53 +0530229 'Sales Taxes and Charges Template': inter_state_gst_field,
230 'Purchase Taxes and Charges Template': inter_state_gst_field,
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530231 'Item': [
Nabin Haitf3f0dfe2017-07-06 14:49:34 +0530232 dict(fieldname='gst_hsn_code', label='HSN/SAC',
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530233 fieldtype='Link', options='GST HSN Code', insert_after='item_group'),
234 ],
Nabin Hait9c421612017-07-20 13:32:01 +0530235 'Quotation Item': [hsn_sac_field],
236 'Supplier Quotation Item': [hsn_sac_field],
Nabin Haitf3f0dfe2017-07-06 14:49:34 +0530237 'Sales Order Item': [hsn_sac_field],
238 'Delivery Note Item': [hsn_sac_field],
239 'Sales Invoice Item': [hsn_sac_field],
240 'Purchase Order Item': [hsn_sac_field],
241 'Purchase Receipt Item': [hsn_sac_field],
Pawan Mehtaf4196352018-04-05 14:54:51 +0530242 'Purchase Invoice Item': [hsn_sac_field],
243 'Employee': [
244 dict(fieldname='ifsc_code', label='IFSC Code',
Rushabh Mehta369afce2018-04-26 10:10:03 +0530245 fieldtype='Data', insert_after='bank_ac_no', print_hide=1,
Ranjith Kurungadama8e047a2018-06-14 17:56:16 +0530246 depends_on='eval:doc.salary_mode == "Bank"')
247 ],
248 'Company': [
249 dict(fieldname='hra_section', label='HRA Settings',
250 fieldtype='Section Break', insert_after='asset_received_but_not_billed'),
Ranjith Kurungadamb1a756c2018-07-01 16:42:38 +0530251 dict(fieldname='basic_component', label='Basic Component',
Ranjith Kurungadama8e047a2018-06-14 17:56:16 +0530252 fieldtype='Link', options='Salary Component', insert_after='hra_section'),
Ranjith Kurungadamb1a756c2018-07-01 16:42:38 +0530253 dict(fieldname='hra_component', label='HRA Component',
254 fieldtype='Link', options='Salary Component', insert_after='basic_component'),
Ranjith Kurungadama8e047a2018-06-14 17:56:16 +0530255 dict(fieldname='arrear_component', label='Arrear Component',
256 fieldtype='Link', options='Salary Component', insert_after='hra_component')
257 ],
258 'Employee Tax Exemption Declaration':[
259 dict(fieldname='hra_section', label='HRA Exemption',
260 fieldtype='Section Break', insert_after='declarations'),
261 dict(fieldname='salary_structure_hra', label='HRA as per Salary Structure',
262 fieldtype='Currency', insert_after='hra_section', read_only=1),
263 dict(fieldname='monthly_house_rent', label='Monthly House Rent',
264 fieldtype='Currency', insert_after='salary_structure_hra'),
265 dict(fieldname='rented_in_metro_city', label='Rented in Metro City',
266 fieldtype='Check', insert_after='monthly_house_rent'),
267 dict(fieldname='hra_column_break', fieldtype='Column Break',
268 insert_after='rented_in_metro_city'),
269 dict(fieldname='annual_hra_exemption', label='Annual HRA Exemption',
270 fieldtype='Currency', insert_after='hra_column_break', read_only=1),
271 dict(fieldname='monthly_hra_exemption', label='Monthly HRA Exemption',
272 fieldtype='Currency', insert_after='annual_hra_exemption', read_only=1)
273 ],
274 'Employee Tax Exemption Proof Submission': [
275 dict(fieldname='hra_section', label='HRA Exemption',
276 fieldtype='Section Break', insert_after='tax_exemption_proofs'),
277 dict(fieldname='house_rent_payment_amount', label='House Rent Payment Amount',
278 fieldtype='Currency', insert_after='hra_section'),
279 dict(fieldname='rented_in_metro_city', label='Rented in Metro City',
280 fieldtype='Check', insert_after='house_rent_payment_amount'),
281 dict(fieldname='rented_from_date', label='Rented From Date',
282 fieldtype='Date', insert_after='rented_in_metro_city'),
283 dict(fieldname='rented_to_date', label='Rented To Date',
284 fieldtype='Date', insert_after='rented_from_date'),
285 dict(fieldname='hra_column_break', fieldtype='Column Break',
286 insert_after='rented_to_date'),
287 dict(fieldname='monthly_house_rent', label='Monthly House Rent',
288 fieldtype='Currency', insert_after='hra_column_break', read_only=1),
289 dict(fieldname='monthly_hra_exemption', label='Monthly Eligible Amount',
290 fieldtype='Currency', insert_after='monthly_house_rent', read_only=1),
291 dict(fieldname='total_eligible_hra_exemption', label='Total Eligible HRA Exemption',
292 fieldtype='Currency', insert_after='monthly_hra_exemption', read_only=1)
Sagar Vorad92f3ac2018-10-10 14:51:26 +0530293 ],
294 'Supplier': [
295 {
296 'fieldname': 'gst_transporter_id',
297 'label': 'GST Transporter ID',
298 'fieldtype': 'Data',
299 'insert_after': 'supplier_type',
300 'depends_on': 'eval:doc.is_transporter'
301 }
Ranjith Kurungadama8e047a2018-06-14 17:56:16 +0530302 ]
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530303 }
304
Rushabh Mehta69fa8082018-07-17 18:22:51 +0530305 create_custom_fields(custom_fields, ignore_validate = frappe.flags.in_patch, update=update)
Nabin Hait9c421612017-07-20 13:32:01 +0530306
Saurabh2d8a7ee2018-05-11 13:16:16 +0530307def make_fixtures(company=None):
308 docs = []
309 company = company.name if company else frappe.db.get_value("Global Defaults", None, "default_company")
310
311 set_salary_components(docs)
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530312 set_tds_account(docs, company)
Rushabh Mehtab3c8f442017-06-21 17:22:38 +0530313
314 for d in docs:
315 try:
316 doc = frappe.get_doc(d)
317 doc.flags.ignore_permissions = True
318 doc.insert()
319 except frappe.NameError:
320 pass
Zarrar7f8024c2018-08-01 17:45:05 +0530321 except frappe.DuplicateEntryError:
322 pass
Saurabh2d8a7ee2018-05-11 13:16:16 +0530323
Zarrar7f8024c2018-08-01 17:45:05 +0530324 # create records for Tax Withholding Category
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530325 set_tax_withholding_category(company)
326
Saurabh2d8a7ee2018-05-11 13:16:16 +0530327def set_salary_components(docs):
328 docs.extend([
329 {'doctype': 'Salary Component', 'salary_component': 'Professional Tax', 'description': 'Professional Tax', 'type': 'Deduction'},
330 {'doctype': 'Salary Component', 'salary_component': 'Provident Fund', 'description': 'Provident fund', 'type': 'Deduction'},
331 {'doctype': 'Salary Component', 'salary_component': 'House Rent Allowance', 'description': 'House Rent Allowance', 'type': 'Earning'},
332 {'doctype': 'Salary Component', 'salary_component': 'Basic', 'description': 'Basic', 'type': 'Earning'},
333 {'doctype': 'Salary Component', 'salary_component': 'Arrear', 'description': 'Arrear', 'type': 'Earning'},
334 {'doctype': 'Salary Component', 'salary_component': 'Leave Encashment', 'description': 'Leave Encashment', 'type': 'Earning'}
335 ])
336
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530337def set_tax_withholding_category(company):
Saurabh2d8a7ee2018-05-11 13:16:16 +0530338 accounts = []
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530339 abbr = frappe.get_value("Company", company, "abbr")
340 tds_account = frappe.get_value("Account", 'TDS Payable - {0}'.format(abbr), 'name')
Saurabh2d8a7ee2018-05-11 13:16:16 +0530341
342 if company and tds_account:
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530343 accounts = [dict(company=company, account=tds_account)]
Saurabh2d8a7ee2018-05-11 13:16:16 +0530344
Zarrar7f8024c2018-08-01 17:45:05 +0530345 fiscal_year = get_fiscal_year(today(), company=accounts[0].get('company'))[0]
346 docs = get_tds_details(accounts, fiscal_year)
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530347
Zarrar7f8024c2018-08-01 17:45:05 +0530348 for d in docs:
349 try:
350 doc = frappe.get_doc(d)
351 doc.flags.ignore_permissions = True
352 doc.insert()
353 except frappe.DuplicateEntryError:
354 doc = frappe.get_doc("Tax Withholding Category", d.get("name"))
355 doc.append("accounts", accounts[0])
356
357 # if fiscal year don't match with any of the already entered data, append rate row
358 fy_exist = [k for k in doc.get('rates') if k.get('fiscal_year')==fiscal_year]
359 if not fy_exist:
360 doc.append("rates", d.get('rates')[0])
361
362 doc.save()
Saurabh2d8a7ee2018-05-11 13:16:16 +0530363
364def set_tds_account(docs, company):
Ranjith Kurungadame51c1752018-07-24 11:07:28 +0530365 abbr = frappe.get_value("Company", company, "abbr")
Nabin Haitf77cd542018-11-20 16:46:25 +0530366 parent_account = frappe.db.get_value("Account", filters = {"account_name": "Duties and Taxes", "company": company})
367 if parent_account:
368 docs.extend([
369 {
370 "doctype": "Account",
371 "account_name": "TDS Payable",
372 "account_type": "Tax",
373 "parent_account": parent_account,
374 "company": company
375 }
376 ])
Zarrar7f8024c2018-08-01 17:45:05 +0530377
378def get_tds_details(accounts, fiscal_year):
379 # bootstrap default tax withholding sections
380 return [
381 dict(name="TDS - 194C - Company",
382 category_name="Payment to Contractors (Single / Aggregate)",
383 doctype="Tax Withholding Category", accounts=accounts,
384 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 2,
385 "single_threshold": 30000, "cumulative_threshold": 100000}]),
386 dict(name="TDS - 194C - Individual",
387 category_name="Payment to Contractors (Single / Aggregate)",
388 doctype="Tax Withholding Category", accounts=accounts,
389 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 1,
390 "single_threshold": 30000, "cumulative_threshold": 100000}]),
391 dict(name="TDS - 194C - No PAN / Invalid PAN",
392 category_name="Payment to Contractors (Single / Aggregate)",
393 doctype="Tax Withholding Category", accounts=accounts,
394 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
395 "single_threshold": 30000, "cumulative_threshold": 100000}]),
396 dict(name="TDS - 194D - Company",
397 category_name="Insurance Commission",
398 doctype="Tax Withholding Category", accounts=accounts,
399 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 5,
400 "single_threshold": 15000, "cumulative_threshold": 0}]),
401 dict(name="TDS - 194D - Company Assessee",
402 category_name="Insurance Commission",
403 doctype="Tax Withholding Category", accounts=accounts,
404 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
405 "single_threshold": 15000, "cumulative_threshold": 0}]),
406 dict(name="TDS - 194D - Individual",
407 category_name="Insurance Commission",
408 doctype="Tax Withholding Category", accounts=accounts,
409 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 5,
410 "single_threshold": 15000, "cumulative_threshold": 0}]),
411 dict(name="TDS - 194D - No PAN / Invalid PAN",
412 category_name="Insurance Commission",
413 doctype="Tax Withholding Category", accounts=accounts,
414 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
415 "single_threshold": 15000, "cumulative_threshold": 0}]),
416 dict(name="TDS - 194DA - Company",
417 category_name="Non-exempt payments made under a life insurance policy",
418 doctype="Tax Withholding Category", accounts=accounts,
419 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 1,
420 "single_threshold": 100000, "cumulative_threshold": 0}]),
421 dict(name="TDS - 194DA - Individual",
422 category_name="Non-exempt payments made under a life insurance policy",
423 doctype="Tax Withholding Category", accounts=accounts,
424 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 1,
425 "single_threshold": 100000, "cumulative_threshold": 0}]),
426 dict(name="TDS - 194DA - No PAN / Invalid PAN",
427 category_name="Non-exempt payments made under a life insurance policy",
428 doctype="Tax Withholding Category", accounts=accounts,
429 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
430 "single_threshold": 100000, "cumulative_threshold": 0}]),
431 dict(name="TDS - 194H - Company",
432 category_name="Commission / Brokerage",
433 doctype="Tax Withholding Category", accounts=accounts,
434 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 5,
435 "single_threshold": 15000, "cumulative_threshold": 0}]),
436 dict(name="TDS - 194H - Individual",
437 category_name="Commission / Brokerage",
438 doctype="Tax Withholding Category", accounts=accounts,
439 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 5,
440 "single_threshold": 15000, "cumulative_threshold": 0}]),
441 dict(name="TDS - 194H - No PAN / Invalid PAN",
442 category_name="Commission / Brokerage",
443 doctype="Tax Withholding Category", accounts=accounts,
444 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
445 "single_threshold": 15000, "cumulative_threshold": 0}]),
446 dict(name="TDS - 194I - Rent - Company",
447 category_name="Rent",
448 doctype="Tax Withholding Category", accounts=accounts,
449 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
450 "single_threshold": 180000, "cumulative_threshold": 0}]),
451 dict(name="TDS - 194I - Rent - Individual",
452 category_name="Rent",
453 doctype="Tax Withholding Category", accounts=accounts,
454 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
455 "single_threshold": 180000, "cumulative_threshold": 0}]),
456 dict(name="TDS - 194I - Rent - No PAN / Invalid PAN",
457 category_name="Rent",
458 doctype="Tax Withholding Category", accounts=accounts,
459 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
460 "single_threshold": 180000, "cumulative_threshold": 0}]),
461 dict(name="TDS - 194I - Rent/Machinery - Company",
462 category_name="Rent-Plant / Machinery",
463 doctype="Tax Withholding Category", accounts=accounts,
464 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 2,
465 "single_threshold": 180000, "cumulative_threshold": 0}]),
466 dict(name="TDS - 194I - Rent/Machinery - Individual",
467 category_name="Rent-Plant / Machinery",
468 doctype="Tax Withholding Category", accounts=accounts,
469 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 2,
470 "single_threshold": 180000, "cumulative_threshold": 0}]),
471 dict(name="TDS - 194I - Rent/Machinery - No PAN / Invalid PAN",
472 category_name="Rent-Plant / Machinery",
473 doctype="Tax Withholding Category", accounts=accounts,
474 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
475 "single_threshold": 180000, "cumulative_threshold": 0}]),
476 dict(name="TDS - 194J - Professional Fees - Company",
477 category_name="Professional Fees",
478 doctype="Tax Withholding Category", accounts=accounts,
479 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
480 "single_threshold": 30000, "cumulative_threshold": 0}]),
481 dict(name="TDS - 194J - Professional Fees - Individual",
482 category_name="Professional Fees",
483 doctype="Tax Withholding Category", accounts=accounts,
484 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
485 "single_threshold": 30000, "cumulative_threshold": 0}]),
486 dict(name="TDS - 194J - Professional Fees - No PAN / Invalid PAN",
487 category_name="Professional Fees",
488 doctype="Tax Withholding Category", accounts=accounts,
489 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
490 "single_threshold": 30000, "cumulative_threshold": 0}]),
491 dict(name="TDS - 194J - Director Fees - Company",
492 category_name="Director Fees",
493 doctype="Tax Withholding Category", accounts=accounts,
494 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
495 "single_threshold": 0, "cumulative_threshold": 0}]),
496 dict(name="TDS - 194J - Director Fees - Individual",
497 category_name="Director Fees",
498 doctype="Tax Withholding Category", accounts=accounts,
499 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
500 "single_threshold": 0, "cumulative_threshold": 0}]),
501 dict(name="TDS - 194J - Director Fees - No PAN / Invalid PAN",
502 category_name="Director Fees",
503 doctype="Tax Withholding Category", accounts=accounts,
504 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
505 "single_threshold": 0, "cumulative_threshold": 0}]),
506 dict(name="TDS - 194 - Dividends - Company",
507 category_name="Dividends",
508 doctype="Tax Withholding Category", accounts=accounts,
509 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
510 "single_threshold": 2500, "cumulative_threshold": 0}]),
511 dict(name="TDS - 194 - Dividends - Individual",
512 category_name="Dividends",
513 doctype="Tax Withholding Category", accounts=accounts,
514 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 10,
515 "single_threshold": 2500, "cumulative_threshold": 0}]),
516 dict(name="TDS - 194 - Dividends - No PAN / Invalid PAN",
517 category_name="Dividends",
518 doctype="Tax Withholding Category", accounts=accounts,
519 rates=[{"fiscal_year": fiscal_year, "tax_withholding_rate": 20,
520 "single_threshold": 2500, "cumulative_threshold": 0}])
521 ]