blob: 52193394768b9416c9e68348c7d2c8f386115f8f [file] [log] [blame]
Rushabh Mehtaad45e312013-11-20 12:59:58 +05301# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
Rushabh Mehtae67d1fb2013-08-05 14:59:54 +05302# License: GNU General Public License v3. See license.txt
Nabin Hait2df4d542013-01-29 11:34:39 +05303
4from __future__ import unicode_literals
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05305import frappe
6from frappe import _, throw
Nabin Hait48f5fa62014-09-18 15:03:54 +05307from frappe.utils import cint, today, flt
Anand Doshidffec8f2014-07-01 17:45:15 +05308from erpnext.setup.utils import get_company_currency, get_exchange_rate
Rushabh Mehta1f847992013-12-12 19:12:19 +05309from erpnext.accounts.utils import get_fiscal_year, validate_fiscal_year
Nabin Hait436f5262014-02-10 14:47:54 +053010from erpnext.utilities.transaction_base import TransactionBase
Anand Doshi13945092014-09-21 19:45:49 +053011from erpnext.controllers.recurring_document import convert_to_recurring, validate_recurring_document
Anand Doshi3543f302013-05-24 19:25:01 +053012import json
Nabin Hait2df4d542013-01-29 11:34:39 +053013
Nabin Haitbf495c92013-01-30 12:49:08 +053014class AccountsController(TransactionBase):
Saurabh6f753182013-03-20 12:55:28 +053015 def validate(self):
nabinhait23cce732014-07-03 12:25:06 +053016 if self.get("_action") and self._action != "update_after_submit":
Nabin Hait704a4532014-06-05 16:55:31 +053017 self.set_missing_values(for_validate=True)
Nabin Haitcfecd2b2013-07-11 17:49:18 +053018 self.validate_date_with_fiscal_year()
Anand Doshi3543f302013-05-24 19:25:01 +053019 if self.meta.get_field("currency"):
Anand Doshi923d41d2013-05-28 17:23:36 +053020 self.calculate_taxes_and_totals()
Saurabh6f753182013-03-20 12:55:28 +053021 self.validate_value("grand_total", ">=", 0)
Anand Doshi3543f302013-05-24 19:25:01 +053022 self.set_total_in_words()
Anand Doshid2946502014-04-08 20:10:03 +053023
Nabin Hait3986bad2013-07-26 11:01:17 +053024 self.validate_for_freezed_account()
Anand Doshid2946502014-04-08 20:10:03 +053025
Anand Doshi13945092014-09-21 19:45:49 +053026 if self.meta.get_field("is_recurring"):
27 validate_recurring_document(self)
28
29 def on_submit(self):
30 if self.meta.get_field("is_recurring"):
31 convert_to_recurring(self, self.get("posting_date") or self.get("transaction_date"))
32
33 def on_update_after_submit(self):
34 if self.meta.get_field("is_recurring"):
35 validate_recurring_document(self)
36 convert_to_recurring(self, self.get("posting_date") or self.get("transaction_date"))
37
38 def before_recurring(self):
39 self.fiscal_year = None
40 for fieldname in ("due_date", "aging_date"):
41 if self.meta.get_field(fieldname):
42 self.set(fieldname, None)
43
Anand Doshiabc10032013-06-14 17:44:03 +053044 def set_missing_values(self, for_validate=False):
45 for fieldname in ["posting_date", "transaction_date"]:
Anand Doshif78d1ae2014-03-28 13:55:00 +053046 if not self.get(fieldname) and self.meta.get_field(fieldname):
47 self.set(fieldname, today())
48 if not self.fiscal_year:
Rushabh Mehtaf2227d02014-03-31 23:37:40 +053049 self.fiscal_year = get_fiscal_year(self.get(fieldname))[0]
Anand Doshiac32bad2014-04-18 01:30:14 +053050 break
Anand Doshid2946502014-04-08 20:10:03 +053051
Nabin Haitcfecd2b2013-07-11 17:49:18 +053052 def validate_date_with_fiscal_year(self):
53 if self.meta.get_field("fiscal_year") :
54 date_field = ""
55 if self.meta.get_field("posting_date"):
56 date_field = "posting_date"
57 elif self.meta.get_field("transaction_date"):
58 date_field = "transaction_date"
Anand Doshid2946502014-04-08 20:10:03 +053059
Rushabh Mehtaf2227d02014-03-31 23:37:40 +053060 if date_field and self.get(date_field):
Anand Doshid2946502014-04-08 20:10:03 +053061 validate_fiscal_year(self.get(date_field), self.fiscal_year,
Nabin Haitcfecd2b2013-07-11 17:49:18 +053062 label=self.meta.get_label(date_field))
Anand Doshid2946502014-04-08 20:10:03 +053063
Nabin Hait3986bad2013-07-26 11:01:17 +053064 def validate_for_freezed_account(self):
Anand Doshi74740122013-07-26 16:07:52 +053065 for fieldname in ["customer", "supplier"]:
Anand Doshif78d1ae2014-03-28 13:55:00 +053066 if self.meta.get_field(fieldname) and self.get(fieldname):
Anand Doshid2946502014-04-08 20:10:03 +053067 accounts = frappe.db.get_values("Account",
68 {"master_type": fieldname.title(), "master_name": self.get(fieldname),
Anand Doshif78d1ae2014-03-28 13:55:00 +053069 "company": self.company}, "name")
Nabin Hait3986bad2013-07-26 11:01:17 +053070 if accounts:
Nabin Hait5ae6a612014-01-23 15:33:30 +053071 from erpnext.accounts.doctype.gl_entry.gl_entry import validate_frozen_account
Anand Doshid2946502014-04-08 20:10:03 +053072 for account in accounts:
Nabin Haitdc15b4f2014-01-20 16:48:49 +053073 validate_frozen_account(account[0])
Anand Doshid2946502014-04-08 20:10:03 +053074
Nabin Hait096d3632013-10-17 17:01:14 +053075 def set_price_list_currency(self, buying_or_selling):
Rushabh Mehta4a404e92013-08-09 18:11:35 +053076 if self.meta.get_field("currency"):
Anand Doshif78d1ae2014-03-28 13:55:00 +053077 company_currency = get_company_currency(self.company)
Anand Doshid2946502014-04-08 20:10:03 +053078
Nabin Hait7a75e102013-09-17 10:21:20 +053079 # price list part
80 fieldname = "selling_price_list" if buying_or_selling.lower() == "selling" \
81 else "buying_price_list"
Anand Doshif78d1ae2014-03-28 13:55:00 +053082 if self.meta.get_field(fieldname) and self.get(fieldname):
83 self.price_list_currency = frappe.db.get_value("Price List",
84 self.get(fieldname), "currency")
Anand Doshid2946502014-04-08 20:10:03 +053085
Anand Doshif78d1ae2014-03-28 13:55:00 +053086 if self.price_list_currency == company_currency:
87 self.plc_conversion_rate = 1.0
Nabin Hait11f41952013-09-24 14:36:55 +053088
Anand Doshif78d1ae2014-03-28 13:55:00 +053089 elif not self.plc_conversion_rate:
Anand Doshidffec8f2014-07-01 17:45:15 +053090 self.plc_conversion_rate = get_exchange_rate(
Anand Doshif78d1ae2014-03-28 13:55:00 +053091 self.price_list_currency, company_currency)
Anand Doshid2946502014-04-08 20:10:03 +053092
Nabin Hait7a75e102013-09-17 10:21:20 +053093 # currency
Anand Doshif78d1ae2014-03-28 13:55:00 +053094 if not self.currency:
95 self.currency = self.price_list_currency
96 self.conversion_rate = self.plc_conversion_rate
97 elif self.currency == company_currency:
98 self.conversion_rate = 1.0
99 elif not self.conversion_rate:
Anand Doshidffec8f2014-07-01 17:45:15 +0530100 self.conversion_rate = get_exchange_rate(self.currency,
Nabin Hait7a75e102013-09-17 10:21:20 +0530101 company_currency)
102
Nabin Hait0aa71a52014-02-11 16:14:52 +0530103 def set_missing_item_details(self):
Anand Doshi3543f302013-05-24 19:25:01 +0530104 """set missing item values"""
Nabin Hait0aa71a52014-02-11 16:14:52 +0530105 from erpnext.stock.get_item_details import get_item_details
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530106 if hasattr(self, "fname"):
Nabin Hait444f9562014-06-20 15:59:49 +0530107 parent_dict = {}
Pratik Vyasf7daab72014-04-10 17:53:30 +0530108 for fieldname in self.meta.get_valid_columns():
109 parent_dict[fieldname] = self.get(fieldname)
110
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530111 for item in self.get(self.fname):
112 if item.get("item_code"):
Nabin Hait444f9562014-06-20 15:59:49 +0530113 args = parent_dict.copy()
114 args.update(item.as_dict())
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530115 ret = get_item_details(args)
Nabin Haita3dd72a2014-05-28 12:49:20 +0530116
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530117 for fieldname, value in ret.items():
Nabin Hait365ae272014-04-03 17:38:54 +0530118 if item.meta.get_field(fieldname) and \
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530119 item.get(fieldname) is None and value is not None:
120 item.set(fieldname, value)
Anand Doshid2946502014-04-08 20:10:03 +0530121
Nabin Haita74468b2014-12-30 18:33:52 +0530122 if fieldname == "cost_center" and item.meta.get_field("cost_center") \
123 and not item.get("cost_center") and value is not None:
124 item.set(fieldname, value)
125
Nabin Haita3dd72a2014-05-28 12:49:20 +0530126 if ret.get("pricing_rule"):
127 for field in ["base_price_list_rate", "price_list_rate",
128 "discount_percentage", "base_rate", "rate"]:
129 item.set(field, ret.get(field))
130
Anand Doshi99100a42013-07-04 17:13:53 +0530131 def set_taxes(self, tax_parentfield, tax_master_field):
Anand Doshi3543f302013-05-24 19:25:01 +0530132 if not self.meta.get_field(tax_parentfield):
133 return
Anand Doshid2946502014-04-08 20:10:03 +0530134
Anand Doshi99100a42013-07-04 17:13:53 +0530135 tax_master_doctype = self.meta.get_field(tax_master_field).options
Anand Doshid2946502014-04-08 20:10:03 +0530136
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530137 if not self.get(tax_parentfield):
Anand Doshif78d1ae2014-03-28 13:55:00 +0530138 if not self.get(tax_master_field):
Anand Doshi3543f302013-05-24 19:25:01 +0530139 # get the default tax master
Anand Doshif78d1ae2014-03-28 13:55:00 +0530140 self.set(tax_master_field, frappe.db.get_value(tax_master_doctype, {"is_default": 1}))
Anand Doshid2946502014-04-08 20:10:03 +0530141
Anand Doshi99100a42013-07-04 17:13:53 +0530142 self.append_taxes_from_master(tax_parentfield, tax_master_field, tax_master_doctype)
Anand Doshid2946502014-04-08 20:10:03 +0530143
Anand Doshi99100a42013-07-04 17:13:53 +0530144 def append_taxes_from_master(self, tax_parentfield, tax_master_field, tax_master_doctype=None):
Anand Doshif78d1ae2014-03-28 13:55:00 +0530145 if self.get(tax_master_field):
Anand Doshi99100a42013-07-04 17:13:53 +0530146 if not tax_master_doctype:
147 tax_master_doctype = self.meta.get_field(tax_master_field).options
Anand Doshid2946502014-04-08 20:10:03 +0530148
Nabin Hait6b039142014-05-02 15:45:10 +0530149 self.extend(tax_parentfield,
Anand Doshi69e0cb52014-05-04 19:37:45 +0530150 get_taxes_and_charges(tax_master_doctype, self.get(tax_master_field), tax_parentfield))
Akhilesh Darjee4cdb7992014-01-30 13:56:57 +0530151
Anand Doshiac32bad2014-04-18 01:30:14 +0530152 def set_other_charges(self):
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530153 self.set("other_charges", [])
Akhilesh Darjee4cdb7992014-01-30 13:56:57 +0530154 self.set_taxes("other_charges", "taxes_and_charges")
Anand Doshid2946502014-04-08 20:10:03 +0530155
Anand Doshi3543f302013-05-24 19:25:01 +0530156 def calculate_taxes_and_totals(self):
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530157 self.discount_amount_applied = False
158 self._calculate_taxes_and_totals()
Anand Doshid2946502014-04-08 20:10:03 +0530159
Nabin Hait4ba95d02014-01-23 16:45:22 +0530160 if self.meta.get_field("discount_amount"):
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530161 self.apply_discount_amount()
162
163 def _calculate_taxes_and_totals(self):
Anand Doshid4e76bc2013-07-15 18:10:51 +0530164 # validate conversion rate
Anand Doshif78d1ae2014-03-28 13:55:00 +0530165 company_currency = get_company_currency(self.company)
166 if not self.currency or self.currency == company_currency:
167 self.currency = company_currency
168 self.conversion_rate = 1.0
Anand Doshid4e76bc2013-07-15 18:10:51 +0530169 else:
Nabin Hait436f5262014-02-10 14:47:54 +0530170 from erpnext.setup.doctype.currency.currency import validate_conversion_rate
Anand Doshif78d1ae2014-03-28 13:55:00 +0530171 validate_conversion_rate(self.currency, self.conversion_rate,
172 self.meta.get_label("conversion_rate"), self.company)
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530173
Anand Doshif78d1ae2014-03-28 13:55:00 +0530174 self.conversion_rate = flt(self.conversion_rate)
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530175 self.item_doclist = self.get(self.fname)
176 self.tax_doclist = self.get(self.other_fname)
Anand Doshid2946502014-04-08 20:10:03 +0530177
Anand Doshi3543f302013-05-24 19:25:01 +0530178 self.calculate_item_values()
179 self.initialize_taxes()
Anand Doshid2946502014-04-08 20:10:03 +0530180
Anand Doshi3543f302013-05-24 19:25:01 +0530181 if hasattr(self, "determine_exclusive_rate"):
182 self.determine_exclusive_rate()
Anand Doshid2946502014-04-08 20:10:03 +0530183
Anand Doshi3543f302013-05-24 19:25:01 +0530184 self.calculate_net_total()
185 self.calculate_taxes()
186 self.calculate_totals()
187 self._cleanup()
Anand Doshid2946502014-04-08 20:10:03 +0530188
Anand Doshi3543f302013-05-24 19:25:01 +0530189 def initialize_taxes(self):
190 for tax in self.tax_doclist:
191 tax.item_wise_tax_detail = {}
Anand Doshid2946502014-04-08 20:10:03 +0530192 tax_fields = ["total", "tax_amount_after_discount_amount",
193 "tax_amount_for_current_item", "grand_total_for_current_item",
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530194 "tax_fraction_for_current_item", "grand_total_fraction_for_current_item"]
195
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530196 if not self.discount_amount_applied:
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530197 tax_fields.append("tax_amount")
198
199 for fieldname in tax_fields:
Anand Doshif78d1ae2014-03-28 13:55:00 +0530200 tax.set(fieldname, 0.0)
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530201
Anand Doshi3543f302013-05-24 19:25:01 +0530202 self.validate_on_previous_row(tax)
203 self.validate_inclusive_tax(tax)
204 self.round_floats_in(tax)
Anand Doshid2946502014-04-08 20:10:03 +0530205
Anand Doshi3543f302013-05-24 19:25:01 +0530206 def validate_on_previous_row(self, tax):
207 """
208 validate if a valid row id is mentioned in case of
209 On Previous Row Amount and On Previous Row Total
210 """
211 if tax.charge_type in ["On Previous Row Amount", "On Previous Row Total"] and \
212 (not tax.row_id or cint(tax.row_id) >= tax.idx):
Rushabh Mehta8a40c132014-04-15 16:30:55 +0530213 throw(_("Please specify a valid Row ID for {0} in row {1}").format(_(tax.doctype), tax.idx))
Anand Doshid2946502014-04-08 20:10:03 +0530214
Anand Doshi3543f302013-05-24 19:25:01 +0530215 def validate_inclusive_tax(self, tax):
216 def _on_previous_row_error(row_range):
Rushabh Mehta8a40c132014-04-15 16:30:55 +0530217 throw(_("To include tax in row {0} in Item rate, taxes in rows {1} must also be included").format(tax.idx,
218 row_range))
Anand Doshid2946502014-04-08 20:10:03 +0530219
Nabin Hait312ba992014-04-04 11:06:10 +0530220 if cint(getattr(tax, "included_in_print_rate", None)):
Anand Doshi3543f302013-05-24 19:25:01 +0530221 if tax.charge_type == "Actual":
222 # inclusive tax cannot be of type Actual
Rushabh Mehta8a40c132014-04-15 16:30:55 +0530223 throw(_("Charge of type 'Actual' in row {0} cannot be included in Item Rate").format(tax.idx))
Anand Doshi3543f302013-05-24 19:25:01 +0530224 elif tax.charge_type == "On Previous Row Amount" and \
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530225 not cint(self.tax_doclist[cint(tax.row_id) - 1].included_in_print_rate):
Anand Doshi3543f302013-05-24 19:25:01 +0530226 # referred row should also be inclusive
227 _on_previous_row_error(tax.row_id)
228 elif tax.charge_type == "On Previous Row Total" and \
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530229 not all([cint(t.included_in_print_rate) for t in self.tax_doclist[:cint(tax.row_id) - 1]]):
Anand Doshi3543f302013-05-24 19:25:01 +0530230 # all rows about the reffered tax should be inclusive
231 _on_previous_row_error("1 - %d" % (tax.row_id,))
Anand Doshid2946502014-04-08 20:10:03 +0530232
Anand Doshi3543f302013-05-24 19:25:01 +0530233 def calculate_taxes(self):
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530234 # maintain actual tax rate based on idx
Nabin Hait0a35eff2014-08-19 12:39:40 +0530235 actual_tax_dict = dict([[tax.idx, flt(tax.rate, self.precision("tax_amount", tax))] for tax in self.tax_doclist
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530236 if tax.charge_type == "Actual"])
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530237
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530238 for n, item in enumerate(self.item_doclist):
Anand Doshi3543f302013-05-24 19:25:01 +0530239 item_tax_map = self._load_item_tax_rate(item.item_tax_rate)
240
241 for i, tax in enumerate(self.tax_doclist):
242 # tax_amount represents the amount of tax for the current step
243 current_tax_amount = self.get_current_tax_amount(item, tax, item_tax_map)
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530244
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530245 # Adjust divisional loss to the last item
246 if tax.charge_type == "Actual":
247 actual_tax_dict[tax.idx] -= current_tax_amount
248 if n == len(self.item_doclist) - 1:
249 current_tax_amount += actual_tax_dict[tax.idx]
Anand Doshi3543f302013-05-24 19:25:01 +0530250
251 # store tax_amount for current item as it will be used for
252 # charge type = 'On Previous Row Amount'
253 tax.tax_amount_for_current_item = current_tax_amount
254
255 # accumulate tax amount into tax.tax_amount
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530256 if not self.discount_amount_applied:
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530257 tax.tax_amount += current_tax_amount
258
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530259 tax.tax_amount_after_discount_amount += current_tax_amount
Anand Doshid2946502014-04-08 20:10:03 +0530260
Nabin Hait312ba992014-04-04 11:06:10 +0530261 if getattr(tax, "category", None):
Anand Doshi3543f302013-05-24 19:25:01 +0530262 # if just for valuation, do not add the tax amount in total
263 # hence, setting it as 0 for further steps
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530264 current_tax_amount = 0.0 if (tax.category == "Valuation") \
265 else current_tax_amount
Anand Doshid2946502014-04-08 20:10:03 +0530266
Anand Doshi3543f302013-05-24 19:25:01 +0530267 current_tax_amount *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
Anand Doshid2946502014-04-08 20:10:03 +0530268
Anand Doshi3543f302013-05-24 19:25:01 +0530269 # Calculate tax.total viz. grand total till that step
Anand Doshid2946502014-04-08 20:10:03 +0530270 # note: grand_total_for_current_item contains the contribution of
Anand Doshi3543f302013-05-24 19:25:01 +0530271 # item's amount, previously applied tax and the current tax on that item
272 if i==0:
Nabin Hait1eb56012014-02-10 19:20:15 +0530273 tax.grand_total_for_current_item = flt(item.base_amount + current_tax_amount,
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530274 self.precision("total", tax))
Anand Doshi3543f302013-05-24 19:25:01 +0530275 else:
276 tax.grand_total_for_current_item = \
Anand Doshid2946502014-04-08 20:10:03 +0530277 flt(self.tax_doclist[i-1].grand_total_for_current_item +
Anand Doshi3543f302013-05-24 19:25:01 +0530278 current_tax_amount, self.precision("total", tax))
Anand Doshid2946502014-04-08 20:10:03 +0530279
Anand Doshi3543f302013-05-24 19:25:01 +0530280 # in tax.total, accumulate grand total of each item
281 tax.total += tax.grand_total_for_current_item
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530282
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530283 # set precision in the last item iteration
284 if n == len(self.item_doclist) - 1:
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530285 self.round_off_totals(tax)
286
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530287 # adjust Discount Amount loss in last tax iteration
288 if i == (len(self.tax_doclist) - 1) and self.discount_amount_applied:
289 self.adjust_discount_amount_loss(tax)
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530290
291 def round_off_totals(self, tax):
292 tax.total = flt(tax.total, self.precision("total", tax))
293 tax.tax_amount = flt(tax.tax_amount, self.precision("tax_amount", tax))
Anand Doshid2946502014-04-08 20:10:03 +0530294 tax.tax_amount_after_discount_amount = flt(tax.tax_amount_after_discount_amount,
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530295 self.precision("tax_amount", tax))
296
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530297 def adjust_discount_amount_loss(self, tax):
Nabin Hait2244ac42015-01-12 17:35:14 +0530298 discount_amount_loss = self.grand_total - flt(self.base_discount_amount) - tax.total
Anand Doshid2946502014-04-08 20:10:03 +0530299 tax.tax_amount_after_discount_amount = flt(tax.tax_amount_after_discount_amount +
Akhilesh Darjee57738a02014-01-03 18:15:07 +0530300 discount_amount_loss, self.precision("tax_amount", tax))
301 tax.total = flt(tax.total + discount_amount_loss, self.precision("total", tax))
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530302
Anand Doshi3543f302013-05-24 19:25:01 +0530303 def get_current_tax_amount(self, item, tax, item_tax_map):
304 tax_rate = self._get_tax_rate(tax, item_tax_map)
305 current_tax_amount = 0.0
306
307 if tax.charge_type == "Actual":
308 # distribute the tax amount proportionally to each item row
309 actual = flt(tax.rate, self.precision("tax_amount", tax))
Anand Doshif78d1ae2014-03-28 13:55:00 +0530310 current_tax_amount = (self.net_total
311 and ((item.base_amount / self.net_total) * actual)
Anand Doshi3543f302013-05-24 19:25:01 +0530312 or 0)
313 elif tax.charge_type == "On Net Total":
Nabin Hait1eb56012014-02-10 19:20:15 +0530314 current_tax_amount = (tax_rate / 100.0) * item.base_amount
Anand Doshi3543f302013-05-24 19:25:01 +0530315 elif tax.charge_type == "On Previous Row Amount":
316 current_tax_amount = (tax_rate / 100.0) * \
317 self.tax_doclist[cint(tax.row_id) - 1].tax_amount_for_current_item
318 elif tax.charge_type == "On Previous Row Total":
319 current_tax_amount = (tax_rate / 100.0) * \
320 self.tax_doclist[cint(tax.row_id) - 1].grand_total_for_current_item
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530321
Anand Doshi53b73422013-05-31 11:50:01 +0530322 current_tax_amount = flt(current_tax_amount, self.precision("tax_amount", tax))
Akhilesh Darjeed203aea2013-12-27 17:49:57 +0530323
Anand Doshi53b73422013-05-31 11:50:01 +0530324 # store tax breakup for each item
Anand Doshi179e3772013-09-05 16:53:57 +0530325 key = item.item_code or item.item_name
326 if tax.item_wise_tax_detail.get(key):
327 item_wise_tax_amount = tax.item_wise_tax_detail[key][1] + current_tax_amount
Nabin Hait90f2d8d2014-05-07 14:55:09 +0530328 tax.item_wise_tax_detail[key] = [tax_rate,item_wise_tax_amount]
Anand Doshi179e3772013-09-05 16:53:57 +0530329 else:
Nabin Hait90f2d8d2014-05-07 14:55:09 +0530330 tax.item_wise_tax_detail[key] = [tax_rate,current_tax_amount]
Anand Doshi3543f302013-05-24 19:25:01 +0530331
Anand Doshi53b73422013-05-31 11:50:01 +0530332 return current_tax_amount
Anand Doshid2946502014-04-08 20:10:03 +0530333
Anand Doshi3543f302013-05-24 19:25:01 +0530334 def _load_item_tax_rate(self, item_tax_rate):
335 return json.loads(item_tax_rate) if item_tax_rate else {}
Anand Doshid2946502014-04-08 20:10:03 +0530336
Anand Doshi3543f302013-05-24 19:25:01 +0530337 def _get_tax_rate(self, tax, item_tax_map):
338 if item_tax_map.has_key(tax.account_head):
339 return flt(item_tax_map.get(tax.account_head), self.precision("rate", tax))
340 else:
341 return tax.rate
Anand Doshid2946502014-04-08 20:10:03 +0530342
Anand Doshi3543f302013-05-24 19:25:01 +0530343 def _cleanup(self):
344 for tax in self.tax_doclist:
Nabin Hait90f2d8d2014-05-07 14:55:09 +0530345 tax.item_wise_tax_detail = json.dumps(tax.item_wise_tax_detail, separators=(',', ':'))
Anand Doshid2946502014-04-08 20:10:03 +0530346
Anand Doshi3543f302013-05-24 19:25:01 +0530347 def _set_in_company_currency(self, item, print_field, base_field):
348 """set values in base currency"""
Anand Doshid2946502014-04-08 20:10:03 +0530349 value_in_company_currency = flt(self.conversion_rate *
Anand Doshi5b552b52014-04-02 15:03:35 +0530350 flt(item.get(print_field), self.precision(print_field, item)),
Anand Doshi3543f302013-05-24 19:25:01 +0530351 self.precision(base_field, item))
Anand Doshi5b552b52014-04-02 15:03:35 +0530352 item.set(base_field, value_in_company_currency)
Anand Doshid2946502014-04-08 20:10:03 +0530353
Anand Doshi923d41d2013-05-28 17:23:36 +0530354 def calculate_total_advance(self, parenttype, advance_parentfield):
Anand Doshif78d1ae2014-03-28 13:55:00 +0530355 if self.doctype == parenttype and self.docstatus < 2:
Anand Doshid2946502014-04-08 20:10:03 +0530356 sum_of_allocated_amount = sum([flt(adv.allocated_amount, self.precision("allocated_amount", adv))
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530357 for adv in self.get(advance_parentfield)])
Anand Doshi923d41d2013-05-28 17:23:36 +0530358
Anand Doshif78d1ae2014-03-28 13:55:00 +0530359 self.total_advance = flt(sum_of_allocated_amount, self.precision("total_advance"))
Anand Doshid2946502014-04-08 20:10:03 +0530360
Anand Doshi923d41d2013-05-28 17:23:36 +0530361 self.calculate_outstanding_amount()
Saurabh6f753182013-03-20 12:55:28 +0530362
Nabin Hait9b09c952013-08-21 17:47:11 +0530363 def get_gl_dict(self, args):
Nabin Hait2df4d542013-01-29 11:34:39 +0530364 """this method populates the common properties of a gl entry record"""
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530365 gl_dict = frappe._dict({
Anand Doshid2946502014-04-08 20:10:03 +0530366 'company': self.company,
Anand Doshif78d1ae2014-03-28 13:55:00 +0530367 'posting_date': self.posting_date,
368 'voucher_type': self.doctype,
369 'voucher_no': self.name,
370 'aging_date': self.get("aging_date") or self.posting_date,
Nabin Haitdc82d4f2014-04-07 12:02:57 +0530371 'remarks': self.get("remarks"),
Anand Doshif78d1ae2014-03-28 13:55:00 +0530372 'fiscal_year': self.fiscal_year,
Nabin Hait2df4d542013-01-29 11:34:39 +0530373 'debit': 0,
374 'credit': 0,
Anand Doshif78d1ae2014-03-28 13:55:00 +0530375 'is_opening': self.get("is_opening") or "No",
Nabin Hait2e296fa2013-08-28 18:53:11 +0530376 })
Nabin Hait2df4d542013-01-29 11:34:39 +0530377 gl_dict.update(args)
378 return gl_dict
Anand Doshid2946502014-04-08 20:10:03 +0530379
Anand Doshi613cb6a2013-02-06 17:33:46 +0530380 def clear_unallocated_advances(self, childtype, parentfield):
Rushabh Mehtaf191f852014-04-02 18:09:34 +0530381 self.set(parentfield, self.get(parentfield, {"allocated_amount": ["not in", [0, None, ""]]}))
382
Anand Doshid2946502014-04-08 20:10:03 +0530383 frappe.db.sql("""delete from `tab%s` where parentfield=%s and parent = %s
Anand Doshif78d1ae2014-03-28 13:55:00 +0530384 and ifnull(allocated_amount, 0) = 0""" % (childtype, '%s', '%s'), (parentfield, self.name))
Anand Doshid2946502014-04-08 20:10:03 +0530385
Nabin Hait48f5fa62014-09-18 15:03:54 +0530386 def get_advances(self, account_head, child_doctype, parentfield, dr_or_cr, against_order_field):
387 so_list = list(set([d.get(against_order_field) for d in self.get("entries") if d.get(against_order_field)]))
Nabin Hait7c831c32014-09-19 14:31:49 +0530388 cond = ""
389 if so_list:
390 cond = "or (ifnull(t2.%s, '') in (%s))" % ("against_" + against_order_field, ', '.join(['%s']*len(so_list)))
Nabin Hait48f5fa62014-09-18 15:03:54 +0530391
Nabin Hait5b983402014-05-01 15:43:22 +0530392 res = frappe.db.sql("""
393 select
Nabin Haitbc8b20a2014-10-13 10:47:14 +0530394 t1.name as jv_no, t1.remark, t2.%s as amount, t2.name as jv_detail_no, `against_%s` as against_order
Nabin Hait5b983402014-05-01 15:43:22 +0530395 from
396 `tabJournal Voucher` t1, `tabJournal Voucher Detail` t2
397 where
398 t1.name = t2.parent and t2.account = %s and t2.is_advance = 'Yes' and t1.docstatus = 1
Nabin Hait48f5fa62014-09-18 15:03:54 +0530399 and ((
400 ifnull(t2.against_voucher, '') = ''
401 and ifnull(t2.against_invoice, '') = ''
402 and ifnull(t2.against_jv, '') = ''
403 and ifnull(t2.against_sales_order, '') = ''
404 and ifnull(t2.against_purchase_order, '') = ''
Nabin Hait7c831c32014-09-19 14:31:49 +0530405 ) %s)
Nabin Hait5b983402014-05-01 15:43:22 +0530406 order by t1.posting_date""" %
Nabin Haitbc8b20a2014-10-13 10:47:14 +0530407 (dr_or_cr, against_order_field, '%s', cond),
Nabin Hait48f5fa62014-09-18 15:03:54 +0530408 tuple([account_head] + so_list), as_dict= True)
Anand Doshid2946502014-04-08 20:10:03 +0530409
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530410 self.set(parentfield, [])
Nabin Haitfb3fd6e2013-01-30 19:16:13 +0530411 for d in res:
Nabin Hait48f5fa62014-09-18 15:03:54 +0530412 self.append(parentfield, {
413 "doctype": child_doctype,
414 "journal_voucher": d.jv_no,
415 "jv_detail_no": d.jv_detail_no,
416 "remarks": d.remark,
417 "advance_amount": flt(d.amount),
Nabin Haitbc8b20a2014-10-13 10:47:14 +0530418 "allocated_amount": flt(d.amount) if d.against_order else 0
Nabin Hait48f5fa62014-09-18 15:03:54 +0530419 })
420
421 def validate_advance_jv(self, advance_table_fieldname, against_order_field):
422 order_list = list(set([d.get(against_order_field) for d in self.get("entries") if d.get(against_order_field)]))
423 if order_list:
424 account = self.get("debit_to" if self.doctype=="Sales Invoice" else "credit_to")
425
426 jv_against_order = frappe.db.sql("""select parent, %s as against_order
427 from `tabJournal Voucher Detail`
428 where docstatus=1 and account=%s and ifnull(is_advance, 'No') = 'Yes'
429 and ifnull(against_sales_order, '') in (%s)
430 group by parent, against_sales_order""" %
431 ("against_" + against_order_field, '%s', ', '.join(['%s']*len(order_list))),
432 tuple([account] + order_list), as_dict=1)
433
434 if jv_against_order:
435 order_jv_map = {}
436 for d in jv_against_order:
437 order_jv_map.setdefault(d.against_order, []).append(d.parent)
438
439 advance_jv_against_si = [d.journal_voucher for d in self.get(advance_table_fieldname)]
440
441 for order, jv_list in order_jv_map.items():
442 for jv in jv_list:
443 if not advance_jv_against_si or jv not in advance_jv_against_si:
Nabin Haitcc110452014-11-28 15:53:07 +0530444 frappe.msgprint(_("Journal Voucher {0} is linked against Order {1}, check if it should be pulled as advance in this invoice.")
Nabin Hait48f5fa62014-09-18 15:03:54 +0530445 .format(jv, order))
446
Anand Doshid2946502014-04-08 20:10:03 +0530447
Nabin Hait19d945a2013-07-29 18:35:39 +0530448 def validate_multiple_billing(self, ref_dt, item_ref_dn, based_on, parentfield):
Nabin Hait5ae6a612014-01-23 15:33:30 +0530449 from erpnext.controllers.status_updater import get_tolerance_for
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530450 item_tolerance = {}
451 global_tolerance = None
Anand Doshid2946502014-04-08 20:10:03 +0530452
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530453 for item in self.get("entries"):
Anand Doshif78d1ae2014-03-28 13:55:00 +0530454 if item.get(item_ref_dn):
Anand Doshid2946502014-04-08 20:10:03 +0530455 ref_amt = flt(frappe.db.get_value(ref_dt + " Item",
Rushabh Mehtaf2227d02014-03-31 23:37:40 +0530456 item.get(item_ref_dn), based_on), self.precision(based_on, item))
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530457 if not ref_amt:
Rushabh Mehta9f0d6252014-04-14 19:20:45 +0530458 frappe.msgprint(_("Warning: System will not check overbilling since amount for Item {0} in {1} is zero").format(item.item_code, ref_dt))
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530459 else:
Anand Doshid2946502014-04-08 20:10:03 +0530460 already_billed = frappe.db.sql("""select sum(%s) from `tab%s`
461 where %s=%s and docstatus=1 and parent != %s""" %
462 (based_on, self.tname, item_ref_dn, '%s', '%s'),
Rushabh Mehtaf2227d02014-03-31 23:37:40 +0530463 (item.get(item_ref_dn), self.name))[0][0]
Anand Doshid2946502014-04-08 20:10:03 +0530464
465 total_billed_amt = flt(flt(already_billed) + flt(item.get(based_on)),
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530466 self.precision(based_on, item))
Anand Doshid2946502014-04-08 20:10:03 +0530467
468 tolerance, item_tolerance, global_tolerance = get_tolerance_for(item.item_code,
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530469 item_tolerance, global_tolerance)
Anand Doshid2946502014-04-08 20:10:03 +0530470
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530471 max_allowed_amt = flt(ref_amt * (100 + tolerance) / 100)
Anand Doshid2946502014-04-08 20:10:03 +0530472
Nabin Haitdc15b4f2014-01-20 16:48:49 +0530473 if total_billed_amt - max_allowed_amt > 0.01:
Nabin Haite24365f2015-01-06 12:56:37 +0530474 frappe.throw(_("Cannot overbill for Item {0} in row {1} more than {2}. To allow overbilling, please set in Stock Settings").format(item.item_code, item.idx, max_allowed_amt))
Anand Doshid2946502014-04-08 20:10:03 +0530475
Nabin Hait0fc24542013-03-25 11:06:00 +0530476 def get_company_default(self, fieldname):
Rushabh Mehta1f847992013-12-12 19:12:19 +0530477 from erpnext.accounts.utils import get_company_default
Anand Doshif78d1ae2014-03-28 13:55:00 +0530478 return get_company_default(self.company, fieldname)
Anand Doshid2946502014-04-08 20:10:03 +0530479
Nabin Haita36adbd2013-08-02 14:50:12 +0530480 def get_stock_items(self):
481 stock_items = []
Anand Doshia740f752014-06-25 13:31:02 +0530482 item_codes = list(set(item.item_code for item in self.get(self.fname)))
Nabin Haita36adbd2013-08-02 14:50:12 +0530483 if item_codes:
Anand Doshie9baaa62014-02-26 12:35:33 +0530484 stock_items = [r[0] for r in frappe.db.sql("""select name
Nabin Haita36adbd2013-08-02 14:50:12 +0530485 from `tabItem` where name in (%s) and is_stock_item='Yes'""" % \
486 (", ".join((["%s"]*len(item_codes))),), item_codes)]
Anand Doshid2946502014-04-08 20:10:03 +0530487
Nabin Haita36adbd2013-08-02 14:50:12 +0530488 return stock_items
Anand Doshid2946502014-04-08 20:10:03 +0530489
Ankit Javalkar8e7ca412014-09-12 15:18:53 +0530490 def set_total_advance_paid(self):
491 if self.doctype == "Sales Order":
492 dr_or_cr = "credit"
493 against_field = "against_sales_order"
494 else:
495 dr_or_cr = "debit"
496 against_field = "against_purchase_order"
497
498 advance_paid = frappe.db.sql("""
499 select
500 sum(ifnull({dr_or_cr}, 0))
501 from
502 `tabJournal Voucher Detail`
503 where
504 {against_field} = %s and docstatus = 1 and is_advance = "Yes" """.format(dr_or_cr=dr_or_cr, \
505 against_field=against_field), self.name)
506
507 if advance_paid:
508 advance_paid = flt(advance_paid[0][0], self.precision("advance_paid"))
509 if flt(self.grand_total) >= advance_paid:
510 frappe.db.set_value(self.doctype, self.name, "advance_paid", advance_paid)
511 else:
512 frappe.throw(_("Total advance ({0}) against Order {1} cannot be greater \
513 than the Grand Total ({2})")
514 .format(advance_paid, self.name, self.grand_total))
515
ankitjavalkarworke60822b2014-08-26 14:29:06 +0530516 @property
517 def company_abbr(self):
518 if not hasattr(self, "_abbr"):
519 self._abbr = frappe.db.get_value("Company", self.company, "abbr")
520
521 return self._abbr
522
523 def check_credit_limit(self, account):
524 total_outstanding = frappe.db.sql("""
525 select sum(ifnull(debit, 0)) - sum(ifnull(credit, 0))
526 from `tabGL Entry` where account = %s""", account)
527
528 total_outstanding = total_outstanding[0][0] if total_outstanding else 0
529 if total_outstanding:
530 frappe.get_doc('Account', account).check_credit_limit(total_outstanding)
531
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530532@frappe.whitelist()
Rushabh Mehtaf56d73c2013-10-10 16:35:09 +0530533def get_tax_rate(account_head):
Anand Doshid2946502014-04-08 20:10:03 +0530534 return frappe.db.get_value("Account", account_head, "tax_rate")
Nabin Hait6b039142014-05-02 15:45:10 +0530535
536@frappe.whitelist()
537def get_taxes_and_charges(master_doctype, master_name, tax_parentfield):
538 from frappe.model import default_fields
539 tax_master = frappe.get_doc(master_doctype, master_name)
540
541 taxes_and_charges = []
542 for i, tax in enumerate(tax_master.get(tax_parentfield)):
543 tax = tax.as_dict()
544
545 for fieldname in default_fields:
546 if fieldname in tax:
547 del tax[fieldname]
548
549 taxes_and_charges.append(tax)
550
551 return taxes_and_charges