blob: f1e95ec0be7f4819fc03c3fd47fd9e3535175138 [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 Haite7679702015-02-20 14:40:35 +0530124 item.net_amount = flt(item.amount / (1 + cumulated_tax_fraction), item.precision("net_amount"))
125 item.net_rate = flt(item.net_amount / item.qty, item.precision("net_rate"))
126 item.discount_percentage = flt(item.discount_percentage, item.precision("discount_percentage"))
Nabin Hait3237c752015-02-17 11:11:11 +0530127
Nabin Haite7679702015-02-20 14:40:35 +0530128 self._set_in_company_currency(item, ["net_rate", "net_amount"])
129
Nabin Hait3237c752015-02-17 11:11:11 +0530130 def _load_item_tax_rate(self, item_tax_rate):
131 return json.loads(item_tax_rate) if item_tax_rate else {}
132
133 def get_current_tax_fraction(self, tax, item_tax_map):
134 """
135 Get tax fraction for calculating tax exclusive amount
136 from tax inclusive amount
137 """
138 current_tax_fraction = 0
139
140 if cint(tax.included_in_print_rate):
141 tax_rate = self._get_tax_rate(tax, item_tax_map)
142
143 if tax.charge_type == "On Net Total":
144 current_tax_fraction = tax_rate / 100.0
145
146 elif tax.charge_type == "On Previous Row Amount":
147 current_tax_fraction = (tax_rate / 100.0) * \
148 self.doc.get("taxes")[cint(tax.row_id) - 1].tax_fraction_for_current_item
149
150 elif tax.charge_type == "On Previous Row Total":
151 current_tax_fraction = (tax_rate / 100.0) * \
152 self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_fraction_for_current_item
153
Nabin Haita6ee8292015-05-15 12:02:01 +0530154 if getattr(tax, "add_deduct_tax", None):
155 current_tax_fraction *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
Nabin Hait3237c752015-02-17 11:11:11 +0530156 return current_tax_fraction
157
158 def _get_tax_rate(self, tax, item_tax_map):
159 if item_tax_map.has_key(tax.account_head):
160 return flt(item_tax_map.get(tax.account_head), self.doc.precision("rate", tax))
161 else:
162 return tax.rate
163
164 def calculate_net_total(self):
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530165 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 +0530166
167 for item in self.doc.get("items"):
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530168 self.doc.total += item.amount
169 self.doc.base_total += item.base_amount
Nabin Haite7679702015-02-20 14:40:35 +0530170 self.doc.net_total += item.net_amount
171 self.doc.base_net_total += item.base_net_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530172
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530173 self.doc.round_floats_in(self.doc, ["total", "base_total", "net_total", "base_net_total"])
Nabin Hait3237c752015-02-17 11:11:11 +0530174
175 def calculate_taxes(self):
176 # maintain actual tax rate based on idx
Nabin Haite7679702015-02-20 14:40:35 +0530177 actual_tax_dict = dict([[tax.idx, flt(tax.tax_amount, tax.precision("tax_amount"))]
Nabin Hait3237c752015-02-17 11:11:11 +0530178 for tax in self.doc.get("taxes") if tax.charge_type == "Actual"])
179
180 for n, item in enumerate(self.doc.get("items")):
181 item_tax_map = self._load_item_tax_rate(item.item_tax_rate)
182
183 for i, tax in enumerate(self.doc.get("taxes")):
184 # tax_amount represents the amount of tax for the current step
185 current_tax_amount = self.get_current_tax_amount(item, tax, item_tax_map)
186
187 # Adjust divisional loss to the last item
188 if tax.charge_type == "Actual":
189 actual_tax_dict[tax.idx] -= current_tax_amount
190 if n == len(self.doc.get("items")) - 1:
191 current_tax_amount += actual_tax_dict[tax.idx]
192
Nabin Hait2b019ed2015-02-22 23:03:07 +0530193 # accumulate tax amount into tax.tax_amount
Nabin Haitde9c8a92015-02-23 01:06:00 +0530194 if tax.charge_type != "Actual" and \
195 not (self.discount_amount_applied and self.doc.apply_discount_on=="Grand Total"):
196 tax.tax_amount += current_tax_amount
Nabin Hait2b019ed2015-02-22 23:03:07 +0530197
Nabin Hait3237c752015-02-17 11:11:11 +0530198 # store tax_amount for current item as it will be used for
199 # charge type = 'On Previous Row Amount'
200 tax.tax_amount_for_current_item = current_tax_amount
201
Nabin Hait2b019ed2015-02-22 23:03:07 +0530202 # set tax after discount
Nabin Hait3237c752015-02-17 11:11:11 +0530203 tax.tax_amount_after_discount_amount += current_tax_amount
204
205 if getattr(tax, "category", None):
206 # if just for valuation, do not add the tax amount in total
207 # hence, setting it as 0 for further steps
208 current_tax_amount = 0.0 if (tax.category == "Valuation") \
209 else current_tax_amount
210
211 current_tax_amount *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
212
213 # Calculate tax.total viz. grand total till that step
214 # note: grand_total_for_current_item contains the contribution of
215 # item's amount, previously applied tax and the current tax on that item
216 if i==0:
Nabin Hait93b3a372015-02-24 17:08:34 +0530217 tax.grand_total_for_current_item = flt(item.net_amount + current_tax_amount, tax.precision("total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530218 else:
219 tax.grand_total_for_current_item = \
Rushabh Mehta6cdfd1e2015-02-25 15:55:57 +0530220 flt(self.doc.get("taxes")[i-1].grand_total_for_current_item + current_tax_amount, tax.precision("total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530221
222 # in tax.total, accumulate grand total of each item
223 tax.total += tax.grand_total_for_current_item
224
225 # set precision in the last item iteration
226 if n == len(self.doc.get("items")) - 1:
227 self.round_off_totals(tax)
Anand Doshiec5ec602015-03-05 19:31:23 +0530228
Nabin Hait3237c752015-02-17 11:11:11 +0530229 # adjust Discount Amount loss in last tax iteration
Nabin Haitde9c8a92015-02-23 01:06:00 +0530230 if i == (len(self.doc.get("taxes")) - 1) and self.discount_amount_applied \
Nabin Haitdb53a782015-07-31 16:53:13 +0530231 and self.doc.discount_amount and self.doc.apply_discount_on == "Grand Total":
Nabin Haitde9c8a92015-02-23 01:06:00 +0530232 self.adjust_discount_amount_loss(tax)
Anand Doshiec5ec602015-03-05 19:31:23 +0530233
234
Nabin Hait3237c752015-02-17 11:11:11 +0530235
236 def get_current_tax_amount(self, item, tax, item_tax_map):
237 tax_rate = self._get_tax_rate(tax, item_tax_map)
238 current_tax_amount = 0.0
239
240 if tax.charge_type == "Actual":
241 # distribute the tax amount proportionally to each item row
Nabin Haite7679702015-02-20 14:40:35 +0530242 actual = flt(tax.tax_amount, tax.precision("tax_amount"))
243 current_tax_amount = item.net_amount*actual / self.doc.net_total if self.doc.net_total else 0.0
244
Nabin Hait3237c752015-02-17 11:11:11 +0530245 elif tax.charge_type == "On Net Total":
Nabin Haite7679702015-02-20 14:40:35 +0530246 current_tax_amount = (tax_rate / 100.0) * item.net_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530247 elif tax.charge_type == "On Previous Row Amount":
248 current_tax_amount = (tax_rate / 100.0) * \
249 self.doc.get("taxes")[cint(tax.row_id) - 1].tax_amount_for_current_item
250 elif tax.charge_type == "On Previous Row Total":
251 current_tax_amount = (tax_rate / 100.0) * \
252 self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_for_current_item
253
Nabin Hait93b3a372015-02-24 17:08:34 +0530254 current_tax_amount = flt(current_tax_amount, tax.precision("tax_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530255
Nabin Haite7679702015-02-20 14:40:35 +0530256 self.set_item_wise_tax(item, tax, tax_rate, current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530257
258 return current_tax_amount
259
Nabin Haite7679702015-02-20 14:40:35 +0530260 def set_item_wise_tax(self, item, tax, tax_rate, current_tax_amount):
261 # store tax breakup for each item
262 key = item.item_code or item.item_name
263 item_wise_tax_amount = current_tax_amount*self.doc.conversion_rate
264 if tax.item_wise_tax_detail.get(key):
265 item_wise_tax_amount += tax.item_wise_tax_detail[key][1]
266
267 tax.item_wise_tax_detail[key] = [tax_rate,flt(item_wise_tax_amount, tax.precision("base_tax_amount"))]
268
Nabin Hait3237c752015-02-17 11:11:11 +0530269 def round_off_totals(self, tax):
Nabin Haite7679702015-02-20 14:40:35 +0530270 tax.total = flt(tax.total, tax.precision("total"))
271 tax.tax_amount = flt(tax.tax_amount, tax.precision("tax_amount"))
272 tax.tax_amount_after_discount_amount = flt(tax.tax_amount_after_discount_amount, tax.precision("tax_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530273
Nabin Haitde9c8a92015-02-23 01:06:00 +0530274 self._set_in_company_currency(tax, ["total", "tax_amount", "tax_amount_after_discount_amount"])
Nabin Haitce245122015-02-22 20:14:49 +0530275
Nabin Hait3237c752015-02-17 11:11:11 +0530276 def adjust_discount_amount_loss(self, tax):
Nabin Haite7679702015-02-20 14:40:35 +0530277 discount_amount_loss = self.doc.grand_total - flt(self.doc.discount_amount) - tax.total
Nabin Hait3237c752015-02-17 11:11:11 +0530278 tax.tax_amount_after_discount_amount = flt(tax.tax_amount_after_discount_amount +
Nabin Hait95ff2d42015-03-04 16:02:03 +0530279 discount_amount_loss, tax.precision("tax_amount"))
280 tax.total = flt(tax.total + discount_amount_loss, tax.precision("total"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530281
Nabin Hait95ff2d42015-03-04 16:02:03 +0530282 self._set_in_company_currency(tax, ["total", "tax_amount_after_discount_amount"])
Anand Doshi731b15e2015-04-05 20:09:09 +0530283
Nabin Haita1bf43b2015-03-17 10:50:47 +0530284 def manipulate_grand_total_for_inclusive_tax(self):
285 # if fully inclusive taxes and diff
286 if self.doc.get("taxes") and all(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 Haita6ee8292015-05-15 12:02:01 +0530288 diff = self.doc.total - flt(last_tax.total, self.doc.precision("grand_total"))
Nabin Haita1bf43b2015-03-17 10:50:47 +0530289
290 if diff and abs(diff) <= (2.0 / 10**last_tax.precision("tax_amount")):
Nabin Haita6ee8292015-05-15 12:02:01 +0530291 last_tax.tax_amount += diff
292 last_tax.tax_amount_after_discount_amount += diff
293 last_tax.total += diff
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530294
295 self._set_in_company_currency(last_tax,
Nabin Hait82521172015-05-19 16:29:44 +0530296 ["total", "tax_amount", "tax_amount_after_discount_amount"])
Nabin Hait3237c752015-02-17 11:11:11 +0530297
298 def calculate_totals(self):
Nabin Haite7679702015-02-20 14:40:35 +0530299 self.doc.grand_total = flt(self.doc.get("taxes")[-1].total
300 if self.doc.get("taxes") else self.doc.net_total)
Nabin Hait3237c752015-02-17 11:11:11 +0530301
Anand Doshiec5ec602015-03-05 19:31:23 +0530302 self.doc.total_taxes_and_charges = flt(self.doc.grand_total - self.doc.net_total,
303 self.doc.precision("total_taxes_and_charges"))
304
305 self._set_in_company_currency(self.doc, ["total_taxes_and_charges"])
306
Nabin Haitbd00e812015-02-17 12:50:51 +0530307 if self.doc.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]:
Nabin Haite7679702015-02-20 14:40:35 +0530308 self.doc.base_grand_total = flt(self.doc.grand_total * self.doc.conversion_rate) \
309 if self.doc.total_taxes_and_charges else self.doc.base_net_total
Nabin Hait3237c752015-02-17 11:11:11 +0530310 else:
Anand Doshiec5ec602015-03-05 19:31:23 +0530311 self.doc.taxes_and_charges_added = self.doc.taxes_and_charges_deducted = 0.0
Nabin Hait3237c752015-02-17 11:11:11 +0530312 for tax in self.doc.get("taxes"):
313 if tax.category in ["Valuation and Total", "Total"]:
314 if tax.add_deduct_tax == "Add":
Nabin Haitdb53a782015-07-31 16:53:13 +0530315 self.doc.taxes_and_charges_added += flt(tax.tax_amount_after_discount_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530316 else:
Nabin Haitdb53a782015-07-31 16:53:13 +0530317 self.doc.taxes_and_charges_deducted += flt(tax.tax_amount_after_discount_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530318
Nabin Haite7679702015-02-20 14:40:35 +0530319 self.doc.round_floats_in(self.doc, ["taxes_and_charges_added", "taxes_and_charges_deducted"])
Nabin Hait3237c752015-02-17 11:11:11 +0530320
Nabin Haite7679702015-02-20 14:40:35 +0530321 self.doc.base_grand_total = flt(self.doc.grand_total * self.doc.conversion_rate) \
322 if (self.doc.taxes_and_charges_added or self.doc.taxes_and_charges_deducted) \
323 else self.doc.base_net_total
Nabin Hait3237c752015-02-17 11:11:11 +0530324
Nabin Haite7679702015-02-20 14:40:35 +0530325 self._set_in_company_currency(self.doc, ["taxes_and_charges_added", "taxes_and_charges_deducted"])
Nabin Hait3237c752015-02-17 11:11:11 +0530326
Nabin Haite7679702015-02-20 14:40:35 +0530327 self.doc.round_floats_in(self.doc, ["grand_total", "base_grand_total"])
Nabin Hait3237c752015-02-17 11:11:11 +0530328
Nabin Hait3237c752015-02-17 11:11:11 +0530329 if self.doc.meta.get_field("rounded_total"):
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530330 self.doc.rounded_total = round_based_on_smallest_currency_fraction(self.doc.grand_total,
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530331 self.doc.currency, self.doc.precision("rounded_total"))
Nabin Haite7679702015-02-20 14:40:35 +0530332 if self.doc.meta.get_field("base_rounded_total"):
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +0530333 company_currency = erpnext.get_company_currency(self.doc.company)
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530334
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530335 self.doc.base_rounded_total = \
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530336 round_based_on_smallest_currency_fraction(self.doc.base_grand_total,
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530337 company_currency, self.doc.precision("base_rounded_total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530338
339 def _cleanup(self):
340 for tax in self.doc.get("taxes"):
341 tax.item_wise_tax_detail = json.dumps(tax.item_wise_tax_detail, separators=(',', ':'))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530342
Nabin Hait3769d872015-12-18 13:12:02 +0530343 def set_discount_amount(self):
Nabin Haite0405102016-10-13 12:14:32 +0530344 if self.doc.additional_discount_percentage:
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530345 self.doc.discount_amount = flt(flt(self.doc.get(scrub(self.doc.apply_discount_on)))
Nabin Hait3769d872015-12-18 13:12:02 +0530346 * self.doc.additional_discount_percentage / 100, self.doc.precision("discount_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530347
348 def apply_discount_amount(self):
349 if self.doc.discount_amount:
Nabin Hait37b047d2015-02-23 16:01:33 +0530350 if not self.doc.apply_discount_on:
351 frappe.throw(_("Please select Apply Discount On"))
352
Nabin Hait3237c752015-02-17 11:11:11 +0530353 self.doc.base_discount_amount = flt(self.doc.discount_amount * self.doc.conversion_rate,
354 self.doc.precision("base_discount_amount"))
355
Nabin Haite7679702015-02-20 14:40:35 +0530356 total_for_discount_amount = self.get_total_for_discount_amount()
Nabin Hait25bd84d2015-03-04 15:06:56 +0530357 taxes = self.doc.get("taxes")
358 net_total = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530359
Nabin Haite7679702015-02-20 14:40:35 +0530360 if total_for_discount_amount:
Nabin Hait3237c752015-02-17 11:11:11 +0530361 # calculate item amount after Discount Amount
Nabin Hait25bd84d2015-03-04 15:06:56 +0530362 for i, item in enumerate(self.doc.get("items")):
363 distributed_amount = flt(self.doc.discount_amount) * \
364 item.net_amount / total_for_discount_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530365
Nabin Haite7679702015-02-20 14:40:35 +0530366 item.net_amount = flt(item.net_amount - distributed_amount, item.precision("net_amount"))
Nabin Hait25bd84d2015-03-04 15:06:56 +0530367 net_total += item.net_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530368
Nabin Hait25bd84d2015-03-04 15:06:56 +0530369 # discount amount rounding loss adjustment if no taxes
370 if (not taxes or self.doc.apply_discount_on == "Net Total") \
371 and i == len(self.doc.get("items")) - 1:
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530372 discount_amount_loss = flt(self.doc.net_total - net_total - self.doc.discount_amount,
Nabin Hait25bd84d2015-03-04 15:06:56 +0530373 self.doc.precision("net_total"))
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530374
Anand Doshiec5ec602015-03-05 19:31:23 +0530375 item.net_amount = flt(item.net_amount + discount_amount_loss,
Nabin Hait25bd84d2015-03-04 15:06:56 +0530376 item.precision("net_amount"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530377
Nabin Hait51e980d2015-10-10 18:10:05 +0530378 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 +0530379
Nabin Haite7679702015-02-20 14:40:35 +0530380 self._set_in_company_currency(item, ["net_rate", "net_amount"])
Nabin Hait3237c752015-02-17 11:11:11 +0530381
382 self.discount_amount_applied = True
383 self._calculate()
384 else:
385 self.doc.base_discount_amount = 0
386
Nabin Haite7679702015-02-20 14:40:35 +0530387 def get_total_for_discount_amount(self):
Nabin Haitde9c8a92015-02-23 01:06:00 +0530388 if self.doc.apply_discount_on == "Net Total":
389 return self.doc.net_total
Nabin Haite7679702015-02-20 14:40:35 +0530390 else:
391 actual_taxes_dict = {}
Nabin Hait3237c752015-02-17 11:11:11 +0530392
Nabin Haite7679702015-02-20 14:40:35 +0530393 for tax in self.doc.get("taxes"):
394 if tax.charge_type == "Actual":
395 actual_taxes_dict.setdefault(tax.idx, tax.tax_amount)
396 elif tax.row_id in actual_taxes_dict:
397 actual_tax_amount = flt(actual_taxes_dict.get(tax.row_id, 0)) * flt(tax.rate) / 100
398 actual_taxes_dict.setdefault(tax.idx, actual_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530399
Nabin Haite7679702015-02-20 14:40:35 +0530400 return flt(self.doc.grand_total - sum(actual_taxes_dict.values()), self.doc.precision("grand_total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530401
402
Nabin Hait7b19b9e2015-02-24 09:42:24 +0530403 def calculate_total_advance(self):
404 if self.doc.docstatus < 2:
Nabin Haite7679702015-02-20 14:40:35 +0530405 total_allocated_amount = sum([flt(adv.allocated_amount, adv.precision("allocated_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530406 for adv in self.doc.get("advances")])
407
Nabin Haite7679702015-02-20 14:40:35 +0530408 self.doc.total_advance = flt(total_allocated_amount, self.doc.precision("total_advance"))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530409
Nabin Hait289ffb72016-02-08 11:06:55 +0530410 if self.doc.party_account_currency == self.doc.currency:
Nabin Hait6f038bc2017-04-03 17:56:05 +0530411 invoice_total = flt(self.doc.grand_total - flt(self.doc.write_off_amount),
Nabin Hait289ffb72016-02-08 11:06:55 +0530412 self.doc.precision("grand_total"))
Nabin Hait8d8cba72017-04-03 17:26:22 +0530413 else:
Nabin Hait6f038bc2017-04-03 17:56:05 +0530414 base_write_off_amount = flt(flt(self.doc.write_off_amount) * self.doc.conversion_rate,
Nabin Hait8d8cba72017-04-03 17:26:22 +0530415 self.doc.precision("base_write_off_amount"))
416 invoice_total = flt(self.doc.grand_total * self.doc.conversion_rate,
417 self.doc.precision("grand_total")) - base_write_off_amount
418
Nabin Haitadc09232016-02-09 10:31:11 +0530419 if invoice_total > 0 and self.doc.total_advance > invoice_total:
Nabin Hait289ffb72016-02-08 11:06:55 +0530420 frappe.throw(_("Advance amount cannot be greater than {0} {1}")
421 .format(self.doc.party_account_currency, invoice_total))
Nabin Hait3237c752015-02-17 11:11:11 +0530422
Rushabh Mehta8bb6e532015-02-18 20:22:59 +0530423 if self.doc.docstatus == 0:
Nabin Hait3237c752015-02-17 11:11:11 +0530424 self.calculate_outstanding_amount()
425
426 def calculate_outstanding_amount(self):
427 # NOTE:
428 # write_off_amount is only for POS Invoice
429 # total_advance is only for non POS Invoice
Rohit Waghchaureefb5bf22016-08-25 02:09:53 +0530430 if self.doc.doctype == "Sales Invoice":
431 self.calculate_paid_amount()
432
433 if self.doc.is_return: return
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530434
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530435 self.doc.round_floats_in(self.doc, ["grand_total", "total_advance", "write_off_amount"])
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530436 self._set_in_company_currency(self.doc, ['write_off_amount'])
437
Nabin Hait90c6d7b2015-11-13 13:03:10 +0530438 if self.doc.party_account_currency == self.doc.currency:
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530439 total_amount_to_pay = flt(self.doc.grand_total - self.doc.total_advance
Nabin Hait90c6d7b2015-11-13 13:03:10 +0530440 - flt(self.doc.write_off_amount), self.doc.precision("grand_total"))
441 else:
Nabin Haitd4507ac2016-01-20 16:14:27 +0530442 total_amount_to_pay = flt(flt(self.doc.grand_total *
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530443 self.doc.conversion_rate, self.doc.precision("grand_total")) - self.doc.total_advance
Nabin Haitd4507ac2016-01-20 16:14:27 +0530444 - flt(self.doc.base_write_off_amount), self.doc.precision("grand_total"))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530445
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530446 if self.doc.doctype == "Sales Invoice":
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530447 self.doc.round_floats_in(self.doc, ["paid_amount"])
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530448 self.calculate_write_off_amount()
Nabin Hait3bb1a422016-08-02 16:41:10 +0530449 self.calculate_change_amount()
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530450
451 paid_amount = self.doc.paid_amount \
452 if self.doc.party_account_currency == self.doc.currency else self.doc.base_paid_amount
453
454 change_amount = self.doc.change_amount \
455 if self.doc.party_account_currency == self.doc.currency else self.doc.base_change_amount
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530456
Nabin Hait3bb1a422016-08-02 16:41:10 +0530457 self.doc.outstanding_amount = flt(total_amount_to_pay - flt(paid_amount) +
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530458 flt(change_amount), self.doc.precision("outstanding_amount"))
459
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530460 elif self.doc.doctype == "Purchase Invoice":
mbauskar36b51892016-01-18 16:31:10 +0530461 self.doc.outstanding_amount = flt(total_amount_to_pay, self.doc.precision("outstanding_amount"))
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530462
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530463 def calculate_paid_amount(self):
464 paid_amount = base_paid_amount = 0.0
Rohit Waghchauref58cad62017-01-17 12:11:57 +0530465
466 if self.doc.is_pos:
467 for payment in self.doc.get('payments'):
Ayush Shuklae9cf1ab2017-05-25 14:14:55 +0530468 payment.amount = flt(payment.amount)
469 payment.base_amount = payment.amount * flt(self.doc.conversion_rate)
Rohit Waghchauref58cad62017-01-17 12:11:57 +0530470 paid_amount += payment.amount
471 base_paid_amount += payment.base_amount
rohitwaghchaure73456ac2017-05-16 11:29:57 +0530472 elif not self.doc.is_return:
473 self.doc.set('payments', [])
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530474
475 self.doc.paid_amount = flt(paid_amount, self.doc.precision("paid_amount"))
476 self.doc.base_paid_amount = flt(base_paid_amount, self.doc.precision("base_paid_amount"))
477
Nabin Hait3bb1a422016-08-02 16:41:10 +0530478 def calculate_change_amount(self):
479 self.doc.change_amount = 0.0
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530480 self.doc.base_change_amount = 0.0
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530481 if self.doc.paid_amount > self.doc.grand_total and not self.doc.is_return \
482 and any([d.type == "Cash" for d in self.doc.payments]):
483
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530484 self.doc.change_amount = flt(self.doc.paid_amount - self.doc.grand_total +
Nabin Hait3bb1a422016-08-02 16:41:10 +0530485 self.doc.write_off_amount, self.doc.precision("change_amount"))
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530486
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530487 self.doc.base_change_amount = flt(self.doc.base_paid_amount - self.doc.base_grand_total +
488 self.doc.base_write_off_amount, self.doc.precision("base_change_amount"))
mbauskar36b51892016-01-18 16:31:10 +0530489
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530490 def calculate_write_off_amount(self):
Rohit Waghchaurebaef2622016-08-05 15:41:36 +0530491 if flt(self.doc.change_amount) > 0:
Rohit Waghchaureea6d7e92016-08-22 19:49:17 +0530492 self.doc.write_off_amount = flt(self.doc.grand_total - self.doc.paid_amount + self.doc.change_amount,
493 self.doc.precision("write_off_amount"))
Rohit Waghchaurebaef2622016-08-05 15:41:36 +0530494 self.doc.base_write_off_amount = flt(self.doc.write_off_amount * self.doc.conversion_rate,
495 self.doc.precision("base_write_off_amount"))
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530496
mbauskar36b51892016-01-18 16:31:10 +0530497 def calculate_margin(self, item):
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +0530498 rate_with_margin = 0.0
mbauskar36b51892016-01-18 16:31:10 +0530499 if item.price_list_rate:
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530500 if item.pricing_rule and not self.doc.ignore_pricing_rule:
mbauskar36b51892016-01-18 16:31:10 +0530501 pricing_rule = frappe.get_doc('Pricing Rule', item.pricing_rule)
mbauskara52472c2016-03-05 15:10:25 +0530502 item.margin_type = pricing_rule.margin_type
503 item.margin_rate_or_amount = pricing_rule.margin_rate_or_amount
mbauskar36b51892016-01-18 16:31:10 +0530504
mbauskara52472c2016-03-05 15:10:25 +0530505 if item.margin_type and item.margin_rate_or_amount:
506 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 +0530507 rate_with_margin = flt(item.price_list_rate) + flt(margin_value)
mbauskar36b51892016-01-18 16:31:10 +0530508
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +0530509 return rate_with_margin
Nabin Hait852cb642017-07-05 12:58:19 +0530510
511 def set_item_wise_tax_breakup(self):
Nabin Haitb962fc12017-07-17 18:02:31 +0530512 if not self.doc.taxes:
513 return
514 frappe.flags.company = self.doc.company
Nabin Hait852cb642017-07-05 12:58:19 +0530515
Nabin Haitb962fc12017-07-17 18:02:31 +0530516 # get headers
517 tax_accounts = list(set([d.description for d in self.doc.taxes]))
518 headers = get_itemised_tax_breakup_header(self.doc.doctype + " Item", tax_accounts)
Nabin Hait852cb642017-07-05 12:58:19 +0530519
Nabin Haitb962fc12017-07-17 18:02:31 +0530520 # get tax breakup data
521 itemised_tax, itemised_taxable_amount = get_itemised_tax_breakup_data(self.doc)
Nabin Hait852cb642017-07-05 12:58:19 +0530522
Nabin Haitb962fc12017-07-17 18:02:31 +0530523 frappe.flags.company = None
Nabin Hait852cb642017-07-05 12:58:19 +0530524
Nabin Haitb962fc12017-07-17 18:02:31 +0530525 self.doc.other_charges_calculation = frappe.render_template(
526 "templates/includes/itemised_tax_breakup.html", dict(
527 headers=headers,
528 itemised_tax=itemised_tax,
529 itemised_taxable_amount=itemised_taxable_amount,
530 tax_accounts=tax_accounts,
531 company_currency=erpnext.get_company_currency(self.doc.company)
532 )
533 )
Nabin Hait852cb642017-07-05 12:58:19 +0530534
Nabin Haitb962fc12017-07-17 18:02:31 +0530535@erpnext.allow_regional
536def get_itemised_tax_breakup_header(item_doctype, tax_accounts):
537 return [_("Item"), _("Taxable Amount")] + tax_accounts
538
539@erpnext.allow_regional
540def get_itemised_tax_breakup_data(doc):
541 itemised_tax = get_itemised_tax(doc.taxes)
542
543 itemised_taxable_amount = get_itemised_taxable_amount(doc.items)
544
545 return itemised_tax, itemised_taxable_amount
546
547def get_itemised_tax(taxes):
548 itemised_tax = {}
549 for tax in taxes:
550 tax_amount_precision = tax.precision("tax_amount")
551 tax_rate_precision = tax.precision("rate")
552
553 item_tax_map = json.loads(tax.item_wise_tax_detail) if tax.item_wise_tax_detail else {}
554
555 for item_code, tax_data in item_tax_map.items():
556 itemised_tax.setdefault(item_code, frappe._dict())
Nabin Hait852cb642017-07-05 12:58:19 +0530557
Nabin Haitb962fc12017-07-17 18:02:31 +0530558 if isinstance(tax_data, list) and tax_data[0]:
559 precision = tax_amount_precision if tax.charge_type == "Actual" else tax_rate_precision
Nabin Hait852cb642017-07-05 12:58:19 +0530560
Nabin Haitb962fc12017-07-17 18:02:31 +0530561 itemised_tax[item_code][tax.description] = frappe._dict(dict(
562 tax_rate=flt(tax_data[0], precision),
563 tax_amount=flt(tax_data[1], tax_amount_precision)
564 ))
Nabin Hait852cb642017-07-05 12:58:19 +0530565 else:
Nabin Haitb962fc12017-07-17 18:02:31 +0530566 itemised_tax[item_code][tax.description] = frappe._dict(dict(
567 tax_rate=flt(tax_data, tax_rate_precision),
568 tax_amount=0.0
569 ))
Rohit Waghchaure296fbfe2017-07-10 13:03:29 +0530570
Nabin Haitb962fc12017-07-17 18:02:31 +0530571 return itemised_tax
572
573def get_itemised_taxable_amount(items):
574 itemised_taxable_amount = frappe._dict()
575 for item in items:
Rohit Waghchaure296fbfe2017-07-10 13:03:29 +0530576 item_code = item.item_code or item.item_name
Nabin Haitb962fc12017-07-17 18:02:31 +0530577 itemised_taxable_amount.setdefault(item_code, 0)
578 itemised_taxable_amount[item_code] += item.net_amount
579
580 return itemised_taxable_amount