blob: e85e56b4d6ce468e1eaf0cbb584d39e825b870ac [file] [log] [blame]
Anand Doshi885e0742015-03-03 14:55:30 +05301# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
Nabin Hait3237c752015-02-17 11:11:11 +05302# License: GNU General Public License v3. See license.txt
3
4from __future__ import unicode_literals
5import json
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +05306import frappe, erpnext
Nabin Hait3769d872015-12-18 13:12:02 +05307from frappe import _, scrub
Nabin Haitb962fc12017-07-17 18:02:31 +05308from frappe.utils import cint, flt, round_based_on_smallest_currency_fraction
Nabin Hait613d0812015-02-23 11:58:15 +05309from erpnext.controllers.accounts_controller import validate_conversion_rate, \
10 validate_taxes_and_charges, validate_inclusive_tax
Nabin Hait3237c752015-02-17 11:11:11 +053011
Nabin Haitfe81da22015-02-18 12:23:18 +053012class calculate_taxes_and_totals(object):
Nabin Hait3237c752015-02-17 11:11:11 +053013 def __init__(self, doc):
14 self.doc = doc
Nabin Haitfe81da22015-02-18 12:23:18 +053015 self.calculate()
16
Nabin Hait3237c752015-02-17 11:11:11 +053017 def calculate(self):
18 self.discount_amount_applied = False
19 self._calculate()
20
21 if self.doc.meta.get_field("discount_amount"):
Nabin Hait3769d872015-12-18 13:12:02 +053022 self.set_discount_amount()
Nabin Hait3237c752015-02-17 11:11:11 +053023 self.apply_discount_amount()
24
Nabin Haitbd00e812015-02-17 12:50:51 +053025 if self.doc.doctype in ["Sales Invoice", "Purchase Invoice"]:
Nabin Hait3237c752015-02-17 11:11:11 +053026 self.calculate_total_advance()
Nabin Hait852cb642017-07-05 12:58:19 +053027
28 if self.doc.meta.get_field("other_charges_calculation"):
29 self.set_item_wise_tax_breakup()
Nabin Hait3237c752015-02-17 11:11:11 +053030
31 def _calculate(self):
Nabin Haite7679702015-02-20 14:40:35 +053032 self.calculate_item_values()
33 self.initialize_taxes()
34 self.determine_exclusive_rate()
35 self.calculate_net_total()
36 self.calculate_taxes()
Nabin Haita1bf43b2015-03-17 10:50:47 +053037 self.manipulate_grand_total_for_inclusive_tax()
Nabin Haite7679702015-02-20 14:40:35 +053038 self.calculate_totals()
39 self._cleanup()
40
41 def validate_conversion_rate(self):
Nabin Hait3237c752015-02-17 11:11:11 +053042 # validate conversion rate
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +053043 company_currency = erpnext.get_company_currency(self.doc.company)
Nabin Hait3237c752015-02-17 11:11:11 +053044 if not self.doc.currency or self.doc.currency == company_currency:
45 self.doc.currency = company_currency
46 self.doc.conversion_rate = 1.0
47 else:
48 validate_conversion_rate(self.doc.currency, self.doc.conversion_rate,
49 self.doc.meta.get_label("conversion_rate"), self.doc.company)
50
51 self.doc.conversion_rate = flt(self.doc.conversion_rate)
52
Nabin Hait3237c752015-02-17 11:11:11 +053053 def calculate_item_values(self):
54 if not self.discount_amount_applied:
55 for item in self.doc.get("items"):
56 self.doc.round_floats_in(item)
57
58 if item.discount_percentage == 100:
59 item.rate = 0.0
60 elif not item.rate:
Nabin Haite7679702015-02-20 14:40:35 +053061 item.rate = flt(item.price_list_rate *
62 (1.0 - (item.discount_percentage / 100.0)), item.precision("rate"))
Nabin Hait3237c752015-02-17 11:11:11 +053063
mbauskara52472c2016-03-05 15:10:25 +053064 if item.doctype in ['Quotation Item', 'Sales Order Item', 'Delivery Note Item', 'Sales Invoice Item']:
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +053065 item.rate_with_margin = self.calculate_margin(item)
mbauskar287fe812017-04-10 19:15:57 +053066
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +053067 item.rate = flt(item.rate_with_margin * (1.0 - (item.discount_percentage / 100.0)), item.precision("rate"))\
68 if item.rate_with_margin > 0 else item.rate
mbauskara52472c2016-03-05 15:10:25 +053069
Nabin Haite7679702015-02-20 14:40:35 +053070 item.net_rate = item.rate
71 item.amount = flt(item.rate * item.qty, item.precision("amount"))
72 item.net_amount = item.amount
Nabin Hait3237c752015-02-17 11:11:11 +053073
Nabin Haite7679702015-02-20 14:40:35 +053074 self._set_in_company_currency(item, ["price_list_rate", "rate", "net_rate", "amount", "net_amount"])
Nabin Hait3237c752015-02-17 11:11:11 +053075
Nabin Haite7679702015-02-20 14:40:35 +053076 item.item_tax_amount = 0.0
77
78 def _set_in_company_currency(self, doc, fields):
Nabin Hait3237c752015-02-17 11:11:11 +053079 """set values in base currency"""
Nabin Haite7679702015-02-20 14:40:35 +053080 for f in fields:
81 val = flt(flt(doc.get(f), doc.precision(f)) * self.doc.conversion_rate, doc.precision("base_" + f))
82 doc.set("base_" + f, val)
Nabin Hait3237c752015-02-17 11:11:11 +053083
84 def initialize_taxes(self):
85 for tax in self.doc.get("taxes"):
Nabin Hait86cd4cc2015-02-28 19:11:51 +053086 if not self.discount_amount_applied:
87 validate_taxes_and_charges(tax)
88 validate_inclusive_tax(tax, self.doc)
Nabin Hait613d0812015-02-23 11:58:15 +053089
Nabin Hait3237c752015-02-17 11:11:11 +053090 tax.item_wise_tax_detail = {}
91 tax_fields = ["total", "tax_amount_after_discount_amount",
92 "tax_amount_for_current_item", "grand_total_for_current_item",
93 "tax_fraction_for_current_item", "grand_total_fraction_for_current_item"]
94
Nabin Haitde9c8a92015-02-23 01:06:00 +053095 if tax.charge_type != "Actual" and \
96 not (self.discount_amount_applied and self.doc.apply_discount_on=="Grand Total"):
97 tax_fields.append("tax_amount")
Nabin Hait3237c752015-02-17 11:11:11 +053098
99 for fieldname in tax_fields:
100 tax.set(fieldname, 0.0)
101
Nabin Hait3237c752015-02-17 11:11:11 +0530102 self.doc.round_floats_in(tax)
103
Nabin Hait3237c752015-02-17 11:11:11 +0530104 def determine_exclusive_rate(self):
Nabin Hait37b047d2015-02-23 16:01:33 +0530105 if not any((cint(tax.included_in_print_rate) for tax in self.doc.get("taxes"))):
106 return
Nabin Hait3237c752015-02-17 11:11:11 +0530107
108 for item in self.doc.get("items"):
109 item_tax_map = self._load_item_tax_rate(item.item_tax_rate)
110 cumulated_tax_fraction = 0
111 for i, tax in enumerate(self.doc.get("taxes")):
112 tax.tax_fraction_for_current_item = self.get_current_tax_fraction(tax, item_tax_map)
113
114 if i==0:
115 tax.grand_total_fraction_for_current_item = 1 + tax.tax_fraction_for_current_item
116 else:
117 tax.grand_total_fraction_for_current_item = \
118 self.doc.get("taxes")[i-1].grand_total_fraction_for_current_item \
119 + tax.tax_fraction_for_current_item
120
121 cumulated_tax_fraction += tax.tax_fraction_for_current_item
122
123 if cumulated_tax_fraction and not self.discount_amount_applied and item.qty:
Nabin Hait2e4de832017-09-19 14:53:16 +0530124 item.net_amount = flt(item.amount / (1 + cumulated_tax_fraction))
Nabin Haite7679702015-02-20 14:40:35 +0530125 item.net_rate = flt(item.net_amount / item.qty, item.precision("net_rate"))
Nabin Hait2e4de832017-09-19 14:53:16 +0530126 item.discount_percentage = flt(item.discount_percentage,
127 item.precision("discount_percentage"))
Nabin Hait3237c752015-02-17 11:11:11 +0530128
Nabin Haite7679702015-02-20 14:40:35 +0530129 self._set_in_company_currency(item, ["net_rate", "net_amount"])
130
Nabin Hait3237c752015-02-17 11:11:11 +0530131 def _load_item_tax_rate(self, item_tax_rate):
132 return json.loads(item_tax_rate) if item_tax_rate else {}
133
134 def get_current_tax_fraction(self, tax, item_tax_map):
135 """
136 Get tax fraction for calculating tax exclusive amount
137 from tax inclusive amount
138 """
139 current_tax_fraction = 0
140
141 if cint(tax.included_in_print_rate):
142 tax_rate = self._get_tax_rate(tax, item_tax_map)
143
144 if tax.charge_type == "On Net Total":
145 current_tax_fraction = tax_rate / 100.0
146
147 elif tax.charge_type == "On Previous Row Amount":
148 current_tax_fraction = (tax_rate / 100.0) * \
149 self.doc.get("taxes")[cint(tax.row_id) - 1].tax_fraction_for_current_item
150
151 elif tax.charge_type == "On Previous Row Total":
152 current_tax_fraction = (tax_rate / 100.0) * \
153 self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_fraction_for_current_item
154
Nabin Haita6ee8292015-05-15 12:02:01 +0530155 if getattr(tax, "add_deduct_tax", None):
156 current_tax_fraction *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
Nabin Hait3237c752015-02-17 11:11:11 +0530157 return current_tax_fraction
158
159 def _get_tax_rate(self, tax, item_tax_map):
160 if item_tax_map.has_key(tax.account_head):
161 return flt(item_tax_map.get(tax.account_head), self.doc.precision("rate", tax))
162 else:
163 return tax.rate
164
165 def calculate_net_total(self):
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530166 self.doc.total = self.doc.base_total = self.doc.net_total = self.doc.base_net_total = 0.0
Nabin Hait3237c752015-02-17 11:11:11 +0530167
168 for item in self.doc.get("items"):
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530169 self.doc.total += item.amount
170 self.doc.base_total += item.base_amount
Nabin Haite7679702015-02-20 14:40:35 +0530171 self.doc.net_total += item.net_amount
172 self.doc.base_net_total += item.base_net_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530173
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530174 self.doc.round_floats_in(self.doc, ["total", "base_total", "net_total", "base_net_total"])
Nabin Hait3237c752015-02-17 11:11:11 +0530175
176 def calculate_taxes(self):
Nabin Hait2e4de832017-09-19 14:53:16 +0530177 self.doc.rounding_adjustment = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530178 # maintain actual tax rate based on idx
Nabin Haite7679702015-02-20 14:40:35 +0530179 actual_tax_dict = dict([[tax.idx, flt(tax.tax_amount, tax.precision("tax_amount"))]
Nabin Hait3237c752015-02-17 11:11:11 +0530180 for tax in self.doc.get("taxes") if tax.charge_type == "Actual"])
181
182 for n, item in enumerate(self.doc.get("items")):
183 item_tax_map = self._load_item_tax_rate(item.item_tax_rate)
Nabin Hait3237c752015-02-17 11:11:11 +0530184 for i, tax in enumerate(self.doc.get("taxes")):
185 # tax_amount represents the amount of tax for the current step
186 current_tax_amount = self.get_current_tax_amount(item, tax, item_tax_map)
187
188 # Adjust divisional loss to the last item
189 if tax.charge_type == "Actual":
190 actual_tax_dict[tax.idx] -= current_tax_amount
191 if n == len(self.doc.get("items")) - 1:
192 current_tax_amount += actual_tax_dict[tax.idx]
193
Nabin Hait2b019ed2015-02-22 23:03:07 +0530194 # accumulate tax amount into tax.tax_amount
Nabin Haitde9c8a92015-02-23 01:06:00 +0530195 if tax.charge_type != "Actual" and \
196 not (self.discount_amount_applied and self.doc.apply_discount_on=="Grand Total"):
197 tax.tax_amount += current_tax_amount
Nabin Hait2b019ed2015-02-22 23:03:07 +0530198
Nabin Hait3237c752015-02-17 11:11:11 +0530199 # store tax_amount for current item as it will be used for
200 # charge type = 'On Previous Row Amount'
201 tax.tax_amount_for_current_item = current_tax_amount
202
Nabin Hait2b019ed2015-02-22 23:03:07 +0530203 # set tax after discount
Nabin Hait3237c752015-02-17 11:11:11 +0530204 tax.tax_amount_after_discount_amount += current_tax_amount
205
Nabin Haitcd951342017-07-31 18:07:45 +0530206 current_tax_amount = self.get_tax_amount_if_for_valuation_or_deduction(current_tax_amount, tax)
Nabin Hait3237c752015-02-17 11:11:11 +0530207
Nabin Hait3237c752015-02-17 11:11:11 +0530208 # note: grand_total_for_current_item contains the contribution of
209 # item's amount, previously applied tax and the current tax on that item
210 if i==0:
Nabin Haitcd951342017-07-31 18:07:45 +0530211 tax.grand_total_for_current_item = flt(item.net_amount + current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530212 else:
213 tax.grand_total_for_current_item = \
Nabin Haitcd951342017-07-31 18:07:45 +0530214 flt(self.doc.get("taxes")[i-1].grand_total_for_current_item + current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530215
216 # set precision in the last item iteration
217 if n == len(self.doc.get("items")) - 1:
218 self.round_off_totals(tax)
Nabin Haitcd951342017-07-31 18:07:45 +0530219 self.set_cumulative_total(i, tax)
220
221 self._set_in_company_currency(tax,
222 ["total", "tax_amount", "tax_amount_after_discount_amount"])
Anand Doshiec5ec602015-03-05 19:31:23 +0530223
Nabin Hait3237c752015-02-17 11:11:11 +0530224 # adjust Discount Amount loss in last tax iteration
Nabin Haitde9c8a92015-02-23 01:06:00 +0530225 if i == (len(self.doc.get("taxes")) - 1) and self.discount_amount_applied \
Nabin Haitdb53a782015-07-31 16:53:13 +0530226 and self.doc.discount_amount and self.doc.apply_discount_on == "Grand Total":
Nabin Hait2e4de832017-09-19 14:53:16 +0530227 self.doc.rounding_adjustment = flt(self.doc.grand_total
228 - flt(self.doc.discount_amount) - tax.total,
229 self.doc.precision("rounding_adjustment"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530230
Nabin Haitcd951342017-07-31 18:07:45 +0530231 def get_tax_amount_if_for_valuation_or_deduction(self, tax_amount, tax):
232 # if just for valuation, do not add the tax amount in total
233 # if tax/charges is for deduction, multiply by -1
234 if getattr(tax, "category", None):
235 tax_amount = 0.0 if (tax.category == "Valuation") else tax_amount
236 tax_amount *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
237 return tax_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530238
Nabin Haitcd951342017-07-31 18:07:45 +0530239 def set_cumulative_total(self, row_idx, tax):
240 tax_amount = tax.tax_amount_after_discount_amount
241 tax_amount = self.get_tax_amount_if_for_valuation_or_deduction(tax_amount, tax)
242
243 if row_idx == 0:
244 tax.total = flt(self.doc.net_total + tax_amount, tax.precision("total"))
245 else:
246 tax.total = flt(self.doc.get("taxes")[row_idx-1].total + tax_amount, tax.precision("total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530247
248 def get_current_tax_amount(self, item, tax, item_tax_map):
249 tax_rate = self._get_tax_rate(tax, item_tax_map)
250 current_tax_amount = 0.0
251
252 if tax.charge_type == "Actual":
253 # distribute the tax amount proportionally to each item row
Nabin Haite7679702015-02-20 14:40:35 +0530254 actual = flt(tax.tax_amount, tax.precision("tax_amount"))
255 current_tax_amount = item.net_amount*actual / self.doc.net_total if self.doc.net_total else 0.0
256
Nabin Hait3237c752015-02-17 11:11:11 +0530257 elif tax.charge_type == "On Net Total":
Nabin Haite7679702015-02-20 14:40:35 +0530258 current_tax_amount = (tax_rate / 100.0) * item.net_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530259 elif tax.charge_type == "On Previous Row Amount":
260 current_tax_amount = (tax_rate / 100.0) * \
261 self.doc.get("taxes")[cint(tax.row_id) - 1].tax_amount_for_current_item
262 elif tax.charge_type == "On Previous Row Total":
263 current_tax_amount = (tax_rate / 100.0) * \
264 self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_for_current_item
265
Nabin Haite7679702015-02-20 14:40:35 +0530266 self.set_item_wise_tax(item, tax, tax_rate, current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530267
268 return current_tax_amount
269
Nabin Haite7679702015-02-20 14:40:35 +0530270 def set_item_wise_tax(self, item, tax, tax_rate, current_tax_amount):
271 # store tax breakup for each item
272 key = item.item_code or item.item_name
273 item_wise_tax_amount = current_tax_amount*self.doc.conversion_rate
274 if tax.item_wise_tax_detail.get(key):
275 item_wise_tax_amount += tax.item_wise_tax_detail[key][1]
276
Nabin Haitcaab5822017-08-24 16:22:28 +0530277 tax.item_wise_tax_detail[key] = [tax_rate,flt(item_wise_tax_amount)]
Nabin Haite7679702015-02-20 14:40:35 +0530278
Nabin Hait3237c752015-02-17 11:11:11 +0530279 def round_off_totals(self, tax):
Nabin Haite7679702015-02-20 14:40:35 +0530280 tax.tax_amount = flt(tax.tax_amount, tax.precision("tax_amount"))
Nabin Haitcd951342017-07-31 18:07:45 +0530281 tax.tax_amount_after_discount_amount = flt(tax.tax_amount_after_discount_amount,
282 tax.precision("tax_amount"))
Nabin Haitce245122015-02-22 20:14:49 +0530283
Nabin Haita1bf43b2015-03-17 10:50:47 +0530284 def manipulate_grand_total_for_inclusive_tax(self):
285 # if fully inclusive taxes and diff
Nabin Hait2e4de832017-09-19 14:53:16 +0530286 if self.doc.get("taxes") and any([cint(t.included_in_print_rate) for t in self.doc.get("taxes")]):
Nabin Haita1bf43b2015-03-17 10:50:47 +0530287 last_tax = self.doc.get("taxes")[-1]
Nabin Hait2e4de832017-09-19 14:53:16 +0530288 non_inclusive_tax_amount = sum([flt(d.tax_amount_after_discount_amount)
289 for d in self.doc.get("taxes") if not d.included_in_print_rate])
290 diff = self.doc.total + non_inclusive_tax_amount \
291 - flt(last_tax.total, last_tax.precision("total"))
292 if diff and abs(diff) <= (5.0 / 10**last_tax.precision("tax_amount")):
293 self.doc.rounding_adjustment = flt(flt(self.doc.rounding_adjustment) +
294 flt(diff), self.doc.precision("rounding_adjustment"))
Nabin Hait3237c752015-02-17 11:11:11 +0530295
296 def calculate_totals(self):
Nabin Hait2e4de832017-09-19 14:53:16 +0530297 self.doc.grand_total = flt(self.doc.get("taxes")[-1].total) + flt(self.doc.rounding_adjustment) \
298 if self.doc.get("taxes") else flt(self.doc.net_total)
Nabin Hait3237c752015-02-17 11:11:11 +0530299
Nabin Hait2e4de832017-09-19 14:53:16 +0530300 self.doc.total_taxes_and_charges = flt(self.doc.grand_total - self.doc.net_total
301 - flt(self.doc.rounding_adjustment), self.doc.precision("total_taxes_and_charges"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530302
Nabin Hait2e4de832017-09-19 14:53:16 +0530303 self._set_in_company_currency(self.doc, ["total_taxes_and_charges", "rounding_adjustment"])
Anand Doshiec5ec602015-03-05 19:31:23 +0530304
Nabin Haitbd00e812015-02-17 12:50:51 +0530305 if self.doc.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]:
Nabin Haite7679702015-02-20 14:40:35 +0530306 self.doc.base_grand_total = flt(self.doc.grand_total * self.doc.conversion_rate) \
307 if self.doc.total_taxes_and_charges else self.doc.base_net_total
Nabin Hait3237c752015-02-17 11:11:11 +0530308 else:
Anand Doshiec5ec602015-03-05 19:31:23 +0530309 self.doc.taxes_and_charges_added = self.doc.taxes_and_charges_deducted = 0.0
Nabin Hait3237c752015-02-17 11:11:11 +0530310 for tax in self.doc.get("taxes"):
311 if tax.category in ["Valuation and Total", "Total"]:
312 if tax.add_deduct_tax == "Add":
Nabin Haitdb53a782015-07-31 16:53:13 +0530313 self.doc.taxes_and_charges_added += flt(tax.tax_amount_after_discount_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530314 else:
Nabin Haitdb53a782015-07-31 16:53:13 +0530315 self.doc.taxes_and_charges_deducted += flt(tax.tax_amount_after_discount_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530316
Nabin Haite7679702015-02-20 14:40:35 +0530317 self.doc.round_floats_in(self.doc, ["taxes_and_charges_added", "taxes_and_charges_deducted"])
Nabin Hait3237c752015-02-17 11:11:11 +0530318
Nabin Haite7679702015-02-20 14:40:35 +0530319 self.doc.base_grand_total = flt(self.doc.grand_total * self.doc.conversion_rate) \
320 if (self.doc.taxes_and_charges_added or self.doc.taxes_and_charges_deducted) \
321 else self.doc.base_net_total
Nabin Hait3237c752015-02-17 11:11:11 +0530322
Nabin Hait2e4de832017-09-19 14:53:16 +0530323 self._set_in_company_currency(self.doc,
324 ["taxes_and_charges_added", "taxes_and_charges_deducted"])
Nabin Hait3237c752015-02-17 11:11:11 +0530325
Nabin Haite7679702015-02-20 14:40:35 +0530326 self.doc.round_floats_in(self.doc, ["grand_total", "base_grand_total"])
Nabin Hait3237c752015-02-17 11:11:11 +0530327
Nabin Hait2e4de832017-09-19 14:53:16 +0530328 self.set_rounded_total()
329
330 def set_rounded_total(self):
331 if frappe.db.get_single_value("Global Defaults", "disable_rounded_total"):
332 self.doc.rounded_total = self.doc.base_rounded_total = 0
333 return
334
Nabin Hait3237c752015-02-17 11:11:11 +0530335 if self.doc.meta.get_field("rounded_total"):
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530336 self.doc.rounded_total = round_based_on_smallest_currency_fraction(self.doc.grand_total,
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530337 self.doc.currency, self.doc.precision("rounded_total"))
Nabin Hait2e4de832017-09-19 14:53:16 +0530338
Nabin Haite7679702015-02-20 14:40:35 +0530339 if self.doc.meta.get_field("base_rounded_total"):
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +0530340 company_currency = erpnext.get_company_currency(self.doc.company)
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530341
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530342 self.doc.base_rounded_total = \
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530343 round_based_on_smallest_currency_fraction(self.doc.base_grand_total,
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530344 company_currency, self.doc.precision("base_rounded_total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530345
346 def _cleanup(self):
347 for tax in self.doc.get("taxes"):
348 tax.item_wise_tax_detail = json.dumps(tax.item_wise_tax_detail, separators=(',', ':'))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530349
Nabin Hait3769d872015-12-18 13:12:02 +0530350 def set_discount_amount(self):
Nabin Haite0405102016-10-13 12:14:32 +0530351 if self.doc.additional_discount_percentage:
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530352 self.doc.discount_amount = flt(flt(self.doc.get(scrub(self.doc.apply_discount_on)))
Nabin Hait3769d872015-12-18 13:12:02 +0530353 * self.doc.additional_discount_percentage / 100, self.doc.precision("discount_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530354
355 def apply_discount_amount(self):
356 if self.doc.discount_amount:
Nabin Hait37b047d2015-02-23 16:01:33 +0530357 if not self.doc.apply_discount_on:
358 frappe.throw(_("Please select Apply Discount On"))
359
Nabin Hait3237c752015-02-17 11:11:11 +0530360 self.doc.base_discount_amount = flt(self.doc.discount_amount * self.doc.conversion_rate,
361 self.doc.precision("base_discount_amount"))
362
Nabin Haite7679702015-02-20 14:40:35 +0530363 total_for_discount_amount = self.get_total_for_discount_amount()
Nabin Hait25bd84d2015-03-04 15:06:56 +0530364 taxes = self.doc.get("taxes")
365 net_total = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530366
Nabin Haite7679702015-02-20 14:40:35 +0530367 if total_for_discount_amount:
Nabin Hait3237c752015-02-17 11:11:11 +0530368 # calculate item amount after Discount Amount
Nabin Hait25bd84d2015-03-04 15:06:56 +0530369 for i, item in enumerate(self.doc.get("items")):
370 distributed_amount = flt(self.doc.discount_amount) * \
371 item.net_amount / total_for_discount_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530372
Nabin Haite7679702015-02-20 14:40:35 +0530373 item.net_amount = flt(item.net_amount - distributed_amount, item.precision("net_amount"))
Nabin Hait25bd84d2015-03-04 15:06:56 +0530374 net_total += item.net_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530375
Nabin Hait25bd84d2015-03-04 15:06:56 +0530376 # discount amount rounding loss adjustment if no taxes
377 if (not taxes or self.doc.apply_discount_on == "Net Total") \
378 and i == len(self.doc.get("items")) - 1:
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530379 discount_amount_loss = flt(self.doc.net_total - net_total - self.doc.discount_amount,
Nabin Hait25bd84d2015-03-04 15:06:56 +0530380 self.doc.precision("net_total"))
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530381
Anand Doshiec5ec602015-03-05 19:31:23 +0530382 item.net_amount = flt(item.net_amount + discount_amount_loss,
Nabin Hait25bd84d2015-03-04 15:06:56 +0530383 item.precision("net_amount"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530384
Nabin Hait51e980d2015-10-10 18:10:05 +0530385 item.net_rate = flt(item.net_amount / item.qty, item.precision("net_rate")) if item.qty else 0
Anand Doshiec5ec602015-03-05 19:31:23 +0530386
Nabin Haite7679702015-02-20 14:40:35 +0530387 self._set_in_company_currency(item, ["net_rate", "net_amount"])
Nabin Hait3237c752015-02-17 11:11:11 +0530388
389 self.discount_amount_applied = True
390 self._calculate()
391 else:
392 self.doc.base_discount_amount = 0
393
Nabin Haite7679702015-02-20 14:40:35 +0530394 def get_total_for_discount_amount(self):
Nabin Haitde9c8a92015-02-23 01:06:00 +0530395 if self.doc.apply_discount_on == "Net Total":
396 return self.doc.net_total
Nabin Haite7679702015-02-20 14:40:35 +0530397 else:
398 actual_taxes_dict = {}
Nabin Hait3237c752015-02-17 11:11:11 +0530399
Nabin Haite7679702015-02-20 14:40:35 +0530400 for tax in self.doc.get("taxes"):
401 if tax.charge_type == "Actual":
402 actual_taxes_dict.setdefault(tax.idx, tax.tax_amount)
403 elif tax.row_id in actual_taxes_dict:
404 actual_tax_amount = flt(actual_taxes_dict.get(tax.row_id, 0)) * flt(tax.rate) / 100
405 actual_taxes_dict.setdefault(tax.idx, actual_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530406
Nabin Haite7679702015-02-20 14:40:35 +0530407 return flt(self.doc.grand_total - sum(actual_taxes_dict.values()), self.doc.precision("grand_total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530408
409
Nabin Hait7b19b9e2015-02-24 09:42:24 +0530410 def calculate_total_advance(self):
411 if self.doc.docstatus < 2:
Nabin Haite7679702015-02-20 14:40:35 +0530412 total_allocated_amount = sum([flt(adv.allocated_amount, adv.precision("allocated_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530413 for adv in self.doc.get("advances")])
414
Nabin Haite7679702015-02-20 14:40:35 +0530415 self.doc.total_advance = flt(total_allocated_amount, self.doc.precision("total_advance"))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530416
Nabin Hait289ffb72016-02-08 11:06:55 +0530417 if self.doc.party_account_currency == self.doc.currency:
Nabin Hait6f038bc2017-04-03 17:56:05 +0530418 invoice_total = flt(self.doc.grand_total - flt(self.doc.write_off_amount),
Nabin Hait289ffb72016-02-08 11:06:55 +0530419 self.doc.precision("grand_total"))
Nabin Hait8d8cba72017-04-03 17:26:22 +0530420 else:
Nabin Hait6f038bc2017-04-03 17:56:05 +0530421 base_write_off_amount = flt(flt(self.doc.write_off_amount) * self.doc.conversion_rate,
Nabin Hait8d8cba72017-04-03 17:26:22 +0530422 self.doc.precision("base_write_off_amount"))
423 invoice_total = flt(self.doc.grand_total * self.doc.conversion_rate,
424 self.doc.precision("grand_total")) - base_write_off_amount
425
Nabin Haitadc09232016-02-09 10:31:11 +0530426 if invoice_total > 0 and self.doc.total_advance > invoice_total:
Nabin Hait289ffb72016-02-08 11:06:55 +0530427 frappe.throw(_("Advance amount cannot be greater than {0} {1}")
428 .format(self.doc.party_account_currency, invoice_total))
Nabin Hait3237c752015-02-17 11:11:11 +0530429
Rushabh Mehta8bb6e532015-02-18 20:22:59 +0530430 if self.doc.docstatus == 0:
Nabin Hait3237c752015-02-17 11:11:11 +0530431 self.calculate_outstanding_amount()
432
433 def calculate_outstanding_amount(self):
434 # NOTE:
435 # write_off_amount is only for POS Invoice
436 # total_advance is only for non POS Invoice
Rohit Waghchaureefb5bf22016-08-25 02:09:53 +0530437 if self.doc.doctype == "Sales Invoice":
438 self.calculate_paid_amount()
439
440 if self.doc.is_return: return
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530441
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530442 self.doc.round_floats_in(self.doc, ["grand_total", "total_advance", "write_off_amount"])
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530443 self._set_in_company_currency(self.doc, ['write_off_amount'])
444
Nabin Hait90c6d7b2015-11-13 13:03:10 +0530445 if self.doc.party_account_currency == self.doc.currency:
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530446 total_amount_to_pay = flt(self.doc.grand_total - self.doc.total_advance
Nabin Hait90c6d7b2015-11-13 13:03:10 +0530447 - flt(self.doc.write_off_amount), self.doc.precision("grand_total"))
448 else:
Nabin Haitd4507ac2016-01-20 16:14:27 +0530449 total_amount_to_pay = flt(flt(self.doc.grand_total *
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530450 self.doc.conversion_rate, self.doc.precision("grand_total")) - self.doc.total_advance
Nabin Haitd4507ac2016-01-20 16:14:27 +0530451 - flt(self.doc.base_write_off_amount), self.doc.precision("grand_total"))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530452
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530453 if self.doc.doctype == "Sales Invoice":
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530454 self.doc.round_floats_in(self.doc, ["paid_amount"])
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530455 self.calculate_write_off_amount()
Nabin Hait3bb1a422016-08-02 16:41:10 +0530456 self.calculate_change_amount()
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530457
458 paid_amount = self.doc.paid_amount \
459 if self.doc.party_account_currency == self.doc.currency else self.doc.base_paid_amount
460
461 change_amount = self.doc.change_amount \
462 if self.doc.party_account_currency == self.doc.currency else self.doc.base_change_amount
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530463
Nabin Hait3bb1a422016-08-02 16:41:10 +0530464 self.doc.outstanding_amount = flt(total_amount_to_pay - flt(paid_amount) +
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530465 flt(change_amount), self.doc.precision("outstanding_amount"))
466
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530467 elif self.doc.doctype == "Purchase Invoice":
mbauskar36b51892016-01-18 16:31:10 +0530468 self.doc.outstanding_amount = flt(total_amount_to_pay, self.doc.precision("outstanding_amount"))
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530469
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530470 def calculate_paid_amount(self):
471 paid_amount = base_paid_amount = 0.0
Rohit Waghchauref58cad62017-01-17 12:11:57 +0530472
473 if self.doc.is_pos:
474 for payment in self.doc.get('payments'):
Ayush Shuklae9cf1ab2017-05-25 14:14:55 +0530475 payment.amount = flt(payment.amount)
476 payment.base_amount = payment.amount * flt(self.doc.conversion_rate)
Rohit Waghchauref58cad62017-01-17 12:11:57 +0530477 paid_amount += payment.amount
478 base_paid_amount += payment.base_amount
rohitwaghchaure73456ac2017-05-16 11:29:57 +0530479 elif not self.doc.is_return:
480 self.doc.set('payments', [])
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530481
482 self.doc.paid_amount = flt(paid_amount, self.doc.precision("paid_amount"))
483 self.doc.base_paid_amount = flt(base_paid_amount, self.doc.precision("base_paid_amount"))
484
Nabin Hait3bb1a422016-08-02 16:41:10 +0530485 def calculate_change_amount(self):
486 self.doc.change_amount = 0.0
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530487 self.doc.base_change_amount = 0.0
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530488 if self.doc.paid_amount > self.doc.grand_total and not self.doc.is_return \
489 and any([d.type == "Cash" for d in self.doc.payments]):
490
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530491 self.doc.change_amount = flt(self.doc.paid_amount - self.doc.grand_total +
Nabin Hait3bb1a422016-08-02 16:41:10 +0530492 self.doc.write_off_amount, self.doc.precision("change_amount"))
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530493
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530494 self.doc.base_change_amount = flt(self.doc.base_paid_amount - self.doc.base_grand_total +
495 self.doc.base_write_off_amount, self.doc.precision("base_change_amount"))
mbauskar36b51892016-01-18 16:31:10 +0530496
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530497 def calculate_write_off_amount(self):
Rohit Waghchaurebaef2622016-08-05 15:41:36 +0530498 if flt(self.doc.change_amount) > 0:
Rohit Waghchaureea6d7e92016-08-22 19:49:17 +0530499 self.doc.write_off_amount = flt(self.doc.grand_total - self.doc.paid_amount + self.doc.change_amount,
500 self.doc.precision("write_off_amount"))
Rohit Waghchaurebaef2622016-08-05 15:41:36 +0530501 self.doc.base_write_off_amount = flt(self.doc.write_off_amount * self.doc.conversion_rate,
502 self.doc.precision("base_write_off_amount"))
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530503
mbauskar36b51892016-01-18 16:31:10 +0530504 def calculate_margin(self, item):
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +0530505 rate_with_margin = 0.0
mbauskar36b51892016-01-18 16:31:10 +0530506 if item.price_list_rate:
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530507 if item.pricing_rule and not self.doc.ignore_pricing_rule:
mbauskar36b51892016-01-18 16:31:10 +0530508 pricing_rule = frappe.get_doc('Pricing Rule', item.pricing_rule)
mbauskara52472c2016-03-05 15:10:25 +0530509 item.margin_type = pricing_rule.margin_type
510 item.margin_rate_or_amount = pricing_rule.margin_rate_or_amount
mbauskar36b51892016-01-18 16:31:10 +0530511
mbauskara52472c2016-03-05 15:10:25 +0530512 if item.margin_type and item.margin_rate_or_amount:
513 margin_value = item.margin_rate_or_amount if item.margin_type == 'Amount' else flt(item.price_list_rate) * flt(item.margin_rate_or_amount) / 100
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +0530514 rate_with_margin = flt(item.price_list_rate) + flt(margin_value)
mbauskar36b51892016-01-18 16:31:10 +0530515
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +0530516 return rate_with_margin
Nabin Hait852cb642017-07-05 12:58:19 +0530517
518 def set_item_wise_tax_breakup(self):
Nabin Hait9c421612017-07-20 13:32:01 +0530519 self.doc.other_charges_calculation = get_itemised_tax_breakup_html(self.doc)
Nabin Hait852cb642017-07-05 12:58:19 +0530520
Nabin Hait9c421612017-07-20 13:32:01 +0530521def get_itemised_tax_breakup_html(doc):
522 if not doc.taxes:
523 return
524 frappe.flags.company = doc.company
525
526 # get headers
Nabin Haitcaab5822017-08-24 16:22:28 +0530527 tax_accounts = []
528 for tax in doc.taxes:
529 if getattr(tax, "category", None) and tax.category=="Valuation":
530 continue
Nabin Hait2e4de832017-09-19 14:53:16 +0530531 if tax.description not in tax_accounts and tax.tax_amount_after_discount_amount:
Nabin Haitcaab5822017-08-24 16:22:28 +0530532 tax_accounts.append(tax.description)
533
Nabin Hait9c421612017-07-20 13:32:01 +0530534 headers = get_itemised_tax_breakup_header(doc.doctype + " Item", tax_accounts)
535
536 # get tax breakup data
537 itemised_tax, itemised_taxable_amount = get_itemised_tax_breakup_data(doc)
Nabin Haitcaab5822017-08-24 16:22:28 +0530538
539 get_rounded_tax_amount(itemised_tax, doc.precision("tax_amount", "taxes"))
540
Nabin Hait9c421612017-07-20 13:32:01 +0530541 frappe.flags.company = None
542
543 return frappe.render_template(
544 "templates/includes/itemised_tax_breakup.html", dict(
545 headers=headers,
546 itemised_tax=itemised_tax,
547 itemised_taxable_amount=itemised_taxable_amount,
548 tax_accounts=tax_accounts,
549 company_currency=erpnext.get_company_currency(doc.company)
Nabin Haitb962fc12017-07-17 18:02:31 +0530550 )
Nabin Hait9c421612017-07-20 13:32:01 +0530551 )
Nabin Hait852cb642017-07-05 12:58:19 +0530552
Nabin Haitb962fc12017-07-17 18:02:31 +0530553@erpnext.allow_regional
554def get_itemised_tax_breakup_header(item_doctype, tax_accounts):
555 return [_("Item"), _("Taxable Amount")] + tax_accounts
556
557@erpnext.allow_regional
558def get_itemised_tax_breakup_data(doc):
559 itemised_tax = get_itemised_tax(doc.taxes)
560
561 itemised_taxable_amount = get_itemised_taxable_amount(doc.items)
562
563 return itemised_tax, itemised_taxable_amount
564
565def get_itemised_tax(taxes):
566 itemised_tax = {}
567 for tax in taxes:
Nabin Haitcaab5822017-08-24 16:22:28 +0530568 if getattr(tax, "category", None) and tax.category=="Valuation":
569 continue
570
Nabin Haitb962fc12017-07-17 18:02:31 +0530571 item_tax_map = json.loads(tax.item_wise_tax_detail) if tax.item_wise_tax_detail else {}
Nabin Hait2e4de832017-09-19 14:53:16 +0530572 if item_tax_map:
573 for item_code, tax_data in item_tax_map.items():
574 itemised_tax.setdefault(item_code, frappe._dict())
Nabin Hait852cb642017-07-05 12:58:19 +0530575
Nabin Hait2e4de832017-09-19 14:53:16 +0530576 if isinstance(tax_data, list):
577 itemised_tax[item_code][tax.description] = frappe._dict(dict(
578 tax_rate=flt(tax_data[0]),
579 tax_amount=flt(tax_data[1])
580 ))
581 else:
582 itemised_tax[item_code][tax.description] = frappe._dict(dict(
583 tax_rate=flt(tax_data),
584 tax_amount=0.0
585 ))
Rohit Waghchaure296fbfe2017-07-10 13:03:29 +0530586
Nabin Haitb962fc12017-07-17 18:02:31 +0530587 return itemised_tax
588
589def get_itemised_taxable_amount(items):
590 itemised_taxable_amount = frappe._dict()
591 for item in items:
Rohit Waghchaure296fbfe2017-07-10 13:03:29 +0530592 item_code = item.item_code or item.item_name
Nabin Haitb962fc12017-07-17 18:02:31 +0530593 itemised_taxable_amount.setdefault(item_code, 0)
594 itemised_taxable_amount[item_code] += item.net_amount
595
Nabin Haitcaab5822017-08-24 16:22:28 +0530596 return itemised_taxable_amount
597
598def get_rounded_tax_amount(itemised_tax, precision):
599 # Rounding based on tax_amount precision
600 for taxes in itemised_tax.values():
601 for tax_account in taxes:
602 taxes[tax_account]["tax_amount"] = flt(taxes[tax_account]["tax_amount"], precision)