Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 1 | # Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors |
| 2 | # License: GNU General Public License v3. See license.txt |
| 3 | |
| 4 | from __future__ import unicode_literals |
| 5 | |
| 6 | import frappe, os, json |
Rushabh Mehta | f056974 | 2017-09-13 12:52:30 +0530 | [diff] [blame] | 7 | from frappe.custom.doctype.custom_field.custom_field import create_custom_fields |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 8 | from frappe.permissions import add_permission |
| 9 | from erpnext.regional.india import states |
Zarrar | 7f8024c | 2018-08-01 17:45:05 +0530 | [diff] [blame] | 10 | from erpnext.accounts.utils import get_fiscal_year |
| 11 | from frappe.utils import today |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 12 | |
Rushabh Mehta | 0165927 | 2017-06-27 18:05:17 +0530 | [diff] [blame] | 13 | def setup(company=None, patch=True): |
Prateeksha Singh | dabf349 | 2018-11-13 15:56:15 +0530 | [diff] [blame] | 14 | setup_company_independent_fixtures() |
Prateeksha Singh | 39b8765 | 2018-11-12 17:19:56 +0530 | [diff] [blame] | 15 | if not patch: |
| 16 | update_address_template() |
Prateeksha Singh | dabf349 | 2018-11-13 15:56:15 +0530 | [diff] [blame] | 17 | make_fixtures(company) |
Prateeksha Singh | 39b8765 | 2018-11-12 17:19:56 +0530 | [diff] [blame] | 18 | |
| 19 | # TODO: for all countries |
| 20 | def setup_company_independent_fixtures(): |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 21 | make_custom_fields() |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 22 | add_permissions() |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 23 | add_custom_roles_for_reports() |
Nabin Hait | c314485 | 2017-09-28 18:55:40 +0530 | [diff] [blame] | 24 | frappe.enqueue('erpnext.regional.india.setup.add_hsn_sac_codes', now=frappe.flags.in_test) |
Nabin Hait | 852cb64 | 2017-07-05 12:58:19 +0530 | [diff] [blame] | 25 | add_print_formats() |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 26 | |
| 27 | def 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 Mehta | 9b09ff2 | 2017-06-27 12:17:39 +0530 | [diff] [blame] | 36 | frappe.get_doc(dict( |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 37 | doctype='Address Template', |
| 38 | country='India', |
| 39 | template=html |
Rushabh Mehta | 9b09ff2 | 2017-06-27 12:17:39 +0530 | [diff] [blame] | 40 | )).insert() |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 41 | |
Nabin Hait | 1a60931 | 2017-07-13 12:16:04 +0530 | [diff] [blame] | 42 | def add_hsn_sac_codes(): |
| 43 | # HSN codes |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 44 | 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 Hait | 1a60931 | 2017-07-13 12:16:04 +0530 | [diff] [blame] | 47 | create_hsn_codes(hsn_codes, code_field="hsn_code") |
Prateeksha Singh | 95d8fd3 | 2017-09-04 11:14:04 +0530 | [diff] [blame] | 48 | |
Nabin Hait | 1a60931 | 2017-07-13 12:16:04 +0530 | [diff] [blame] | 49 | # 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 Singh | 95d8fd3 | 2017-09-04 11:14:04 +0530 | [diff] [blame] | 53 | |
Nabin Hait | 1a60931 | 2017-07-13 12:16:04 +0530 | [diff] [blame] | 54 | def create_hsn_codes(data, code_field): |
| 55 | for d in data: |
Rushabh Mehta | f702d72 | 2017-09-27 15:31:30 +0530 | [diff] [blame] | 56 | 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 Hait | 1a60931 | 2017-07-13 12:16:04 +0530 | [diff] [blame] | 61 | hsn_code.db_insert() |
Rushabh Mehta | f702d72 | 2017-09-27 15:31:30 +0530 | [diff] [blame] | 62 | except frappe.DuplicateEntryError: |
| 63 | pass |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 64 | |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 65 | def add_custom_roles_for_reports(): |
| 66 | for report_name in ('GST Sales Register', 'GST Purchase Register', |
rohitwaghchaure | 8cca61f | 2018-08-20 17:53:56 +0530 | [diff] [blame] | 67 | 'GST Itemised Sales Register', 'GST Itemised Purchase Register', 'Eway Bill'): |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 68 | |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 69 | 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 Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 79 | def add_permissions(): |
Rushabh Mehta | 00ae424 | 2017-06-27 17:31:41 +0530 | [diff] [blame] | 80 | for doctype in ('GST HSN Code', 'GST Settings'): |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 81 | add_permission(doctype, 'All', 0) |
| 82 | |
Nabin Hait | 852cb64 | 2017-07-05 12:58:19 +0530 | [diff] [blame] | 83 | def add_print_formats(): |
| 84 | frappe.reload_doc("regional", "print_format", "gst_tax_invoice") |
rohitwaghchaure | e3b5c0f | 2017-12-16 10:53:53 +0530 | [diff] [blame] | 85 | 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 Hait | 852cb64 | 2017-07-05 12:58:19 +0530 | [diff] [blame] | 89 | |
Rushabh Mehta | 69fa808 | 2018-07-17 18:22:51 +0530 | [diff] [blame] | 90 | def make_custom_fields(update=True): |
Nabin Hait | f3f0dfe | 2017-07-06 14:49:34 +0530 | [diff] [blame] | 91 | hsn_sac_field = dict(fieldname='gst_hsn_code', label='HSN/SAC', |
Nabin Hait | d34bfa8 | 2018-11-13 18:19:58 +0530 | [diff] [blame] | 92 | fieldtype='Data', fetch_from='item_code.gst_hsn_code', insert_after='description', |
Nabin Hait | e5716e3 | 2017-09-11 19:21:37 +0530 | [diff] [blame] | 93 | allow_on_submit=1, print_hide=1) |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 94 | invoice_gst_fields = [ |
| 95 | dict(fieldname='gst_section', label='GST Details', fieldtype='Section Break', |
vishdha | 109b408 | 2018-01-30 12:11:13 +0530 | [diff] [blame] | 96 | insert_after='language', print_hide=1, collapsible=1), |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 97 | 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 Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 103 | dict(fieldname='invoice_type', label='Invoice Type', |
Nabin Hait | e6d65bc | 2018-02-14 17:44:06 +0530 | [diff] [blame] | 104 | fieldtype='Select', insert_after='invoice_copy', print_hide=1, |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 105 | 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 Dhayagude | c463c06 | 2018-01-26 11:27:22 +0530 | [diff] [blame] | 111 | fieldtype='Data', insert_after='export_type', print_hide=1), |
Nabin Hait | e6d65bc | 2018-02-14 17:44:06 +0530 | [diff] [blame] | 112 | dict(fieldname='gst_col_break', fieldtype='Column Break', insert_after='ecommerce_gstin'), |
Vishal Dhayagude | c463c06 | 2018-01-26 11:27:22 +0530 | [diff] [blame] | 113 | dict(fieldname='reason_for_issuing_document', label='Reason For Issuing document', |
Nabin Hait | b02c109 | 2018-02-05 16:09:51 +0530 | [diff] [blame] | 114 | fieldtype='Select', insert_after='gst_col_break', print_hide=1, |
Nabin Hait | e6d65bc | 2018-02-14 17:44:06 +0530 | [diff] [blame] | 115 | depends_on='eval:doc.is_return==1', |
Nabin Hait | a8d10b7 | 2018-02-12 16:54:13 +0530 | [diff] [blame] | 116 | 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 Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 117 | ] |
Prateeksha Singh | 95d8fd3 | 2017-09-04 11:14:04 +0530 | [diff] [blame] | 118 | |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 119 | purchase_invoice_gst_fields = [ |
| 120 | dict(fieldname='supplier_gstin', label='Supplier GSTIN', |
| 121 | fieldtype='Data', insert_after='supplier_address', |
Shreya Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 122 | fetch_from='supplier_address.gstin', print_hide=1), |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 123 | dict(fieldname='company_gstin', label='Company GSTIN', |
Shreya Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 124 | fieldtype='Data', insert_after='shipping_address_display', |
| 125 | fetch_from='shipping_address.gstin', print_hide=1), |
Nabin Hait | b02c109 | 2018-02-05 16:09:51 +0530 | [diff] [blame] | 126 | dict(fieldname='place_of_supply', label='Place of Supply', |
| 127 | fieldtype='Data', insert_after='shipping_address', |
| 128 | print_hide=1, read_only=0), |
deepeshgarg007 | d29ee97 | 2019-01-09 17:09:11 +0530 | [diff] [blame] | 129 | ] |
| 130 | |
| 131 | purchase_invoice_itc_fields = [ |
vishdha | 98e33c3 | 2018-01-29 13:57:34 +0530 | [diff] [blame] | 132 | 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 Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 143 | ] |
Prateeksha Singh | 95d8fd3 | 2017-09-04 11:14:04 +0530 | [diff] [blame] | 144 | |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 145 | sales_invoice_gst_fields = [ |
rohitwaghchaure | 1664580 | 2017-09-28 11:05:03 +0530 | [diff] [blame] | 146 | dict(fieldname='billing_address_gstin', label='Billing Address GSTIN', |
| 147 | fieldtype='Data', insert_after='customer_address', |
Shreya Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 148 | fetch_from='customer_address.gstin', print_hide=1), |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 149 | dict(fieldname='customer_gstin', label='Customer GSTIN', |
Shreya Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 150 | fieldtype='Data', insert_after='shipping_address_name', |
| 151 | fetch_from='shipping_address_name.gstin', print_hide=1), |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 152 | dict(fieldname='place_of_supply', label='Place of Supply', |
Nabin Hait | 619c42b | 2018-01-10 17:48:03 +0530 | [diff] [blame] | 153 | fieldtype='Data', insert_after='customer_gstin', |
| 154 | print_hide=1, read_only=0), |
Nabin Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 155 | dict(fieldname='company_gstin', label='Company GSTIN', |
| 156 | fieldtype='Data', insert_after='company_address', |
Shreya Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 157 | fetch_from='company_address.gstin', print_hide=1), |
deepeshgarg007 | d29ee97 | 2019-01-09 17:09:11 +0530 | [diff] [blame] | 158 | ] |
| 159 | |
| 160 | sales_invoice_shipping_fields = [ |
vishdha | 98e33c3 | 2018-01-29 13:57:34 +0530 | [diff] [blame] | 161 | 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 Hait | 879e162 | 2017-08-21 08:28:55 +0530 | [diff] [blame] | 170 | ] |
Prateeksha Singh | 95d8fd3 | 2017-09-04 11:14:04 +0530 | [diff] [blame] | 171 | |
Shreya Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 172 | 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 Vora | d92f3ac | 2018-10-10 14:51:26 +0530 | [diff] [blame] | 177 | 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 Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 214 | custom_fields = { |
| 215 | 'Address': [ |
Rushabh Mehta | 919a74a | 2017-06-22 16:37:04 +0530 | [diff] [blame] | 216 | dict(fieldname='gstin', label='Party GSTIN', fieldtype='Data', |
| 217 | insert_after='fax'), |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 218 | dict(fieldname='gst_state', label='GST State', fieldtype='Select', |
Nabin Hait | f3f0dfe | 2017-07-06 14:49:34 +0530 | [diff] [blame] | 219 | options='\n'.join(states), insert_after='gstin'), |
| 220 | dict(fieldname='gst_state_number', label='GST State Number', |
Nabin Hait | 562d942 | 2018-09-07 16:14:44 +0530 | [diff] [blame] | 221 | fieldtype='Data', insert_after='gst_state', read_only=1), |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 222 | ], |
deepeshgarg007 | d29ee97 | 2019-01-09 17:09:11 +0530 | [diff] [blame] | 223 | '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 Shah | 4fa600a | 2018-06-05 11:27:53 +0530 | [diff] [blame] | 229 | 'Sales Taxes and Charges Template': inter_state_gst_field, |
| 230 | 'Purchase Taxes and Charges Template': inter_state_gst_field, |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 231 | 'Item': [ |
Nabin Hait | f3f0dfe | 2017-07-06 14:49:34 +0530 | [diff] [blame] | 232 | dict(fieldname='gst_hsn_code', label='HSN/SAC', |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 233 | fieldtype='Link', options='GST HSN Code', insert_after='item_group'), |
| 234 | ], |
Nabin Hait | 9c42161 | 2017-07-20 13:32:01 +0530 | [diff] [blame] | 235 | 'Quotation Item': [hsn_sac_field], |
| 236 | 'Supplier Quotation Item': [hsn_sac_field], |
Nabin Hait | f3f0dfe | 2017-07-06 14:49:34 +0530 | [diff] [blame] | 237 | '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 Mehta | f419635 | 2018-04-05 14:54:51 +0530 | [diff] [blame] | 242 | 'Purchase Invoice Item': [hsn_sac_field], |
| 243 | 'Employee': [ |
| 244 | dict(fieldname='ifsc_code', label='IFSC Code', |
Rushabh Mehta | 369afce | 2018-04-26 10:10:03 +0530 | [diff] [blame] | 245 | fieldtype='Data', insert_after='bank_ac_no', print_hide=1, |
Ranjith Kurungadam | a8e047a | 2018-06-14 17:56:16 +0530 | [diff] [blame] | 246 | 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 Kurungadam | b1a756c | 2018-07-01 16:42:38 +0530 | [diff] [blame] | 251 | dict(fieldname='basic_component', label='Basic Component', |
Ranjith Kurungadam | a8e047a | 2018-06-14 17:56:16 +0530 | [diff] [blame] | 252 | fieldtype='Link', options='Salary Component', insert_after='hra_section'), |
Ranjith Kurungadam | b1a756c | 2018-07-01 16:42:38 +0530 | [diff] [blame] | 253 | dict(fieldname='hra_component', label='HRA Component', |
| 254 | fieldtype='Link', options='Salary Component', insert_after='basic_component'), |
Ranjith Kurungadam | a8e047a | 2018-06-14 17:56:16 +0530 | [diff] [blame] | 255 | 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 Vora | d92f3ac | 2018-10-10 14:51:26 +0530 | [diff] [blame] | 293 | ], |
| 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 Kurungadam | a8e047a | 2018-06-14 17:56:16 +0530 | [diff] [blame] | 302 | ] |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 303 | } |
| 304 | |
Rushabh Mehta | 69fa808 | 2018-07-17 18:22:51 +0530 | [diff] [blame] | 305 | create_custom_fields(custom_fields, ignore_validate = frappe.flags.in_patch, update=update) |
Nabin Hait | 9c42161 | 2017-07-20 13:32:01 +0530 | [diff] [blame] | 306 | |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 307 | def 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 Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 312 | set_tds_account(docs, company) |
Rushabh Mehta | b3c8f44 | 2017-06-21 17:22:38 +0530 | [diff] [blame] | 313 | |
| 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 |
Zarrar | 7f8024c | 2018-08-01 17:45:05 +0530 | [diff] [blame] | 321 | except frappe.DuplicateEntryError: |
| 322 | pass |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 323 | |
Zarrar | 7f8024c | 2018-08-01 17:45:05 +0530 | [diff] [blame] | 324 | # create records for Tax Withholding Category |
Ranjith Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 325 | set_tax_withholding_category(company) |
| 326 | |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 327 | def 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 Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 337 | def set_tax_withholding_category(company): |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 338 | accounts = [] |
Ranjith Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 339 | abbr = frappe.get_value("Company", company, "abbr") |
| 340 | tds_account = frappe.get_value("Account", 'TDS Payable - {0}'.format(abbr), 'name') |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 341 | |
| 342 | if company and tds_account: |
Ranjith Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 343 | accounts = [dict(company=company, account=tds_account)] |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 344 | |
Zarrar | 7f8024c | 2018-08-01 17:45:05 +0530 | [diff] [blame] | 345 | fiscal_year = get_fiscal_year(today(), company=accounts[0].get('company'))[0] |
| 346 | docs = get_tds_details(accounts, fiscal_year) |
Ranjith Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 347 | |
Zarrar | 7f8024c | 2018-08-01 17:45:05 +0530 | [diff] [blame] | 348 | 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() |
Saurabh | 2d8a7ee | 2018-05-11 13:16:16 +0530 | [diff] [blame] | 363 | |
| 364 | def set_tds_account(docs, company): |
Ranjith Kurungadam | e51c175 | 2018-07-24 11:07:28 +0530 | [diff] [blame] | 365 | abbr = frappe.get_value("Company", company, "abbr") |
Nabin Hait | f77cd54 | 2018-11-20 16:46:25 +0530 | [diff] [blame] | 366 | 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 | ]) |
Zarrar | 7f8024c | 2018-08-01 17:45:05 +0530 | [diff] [blame] | 377 | |
| 378 | def 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 | ] |