blob: 2a14be85325597803fbf210953abf9c4ebf57540 [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
Deepesh Gargef0d26c2020-01-06 15:34:15 +053011from erpnext.stock.get_item_details import _get_item_tax_template
Nabin Hait3237c752015-02-17 11:11:11 +053012
Nabin Haitfe81da22015-02-18 12:23:18 +053013class calculate_taxes_and_totals(object):
Nabin Hait3237c752015-02-17 11:11:11 +053014 def __init__(self, doc):
15 self.doc = doc
Nabin Haitfe81da22015-02-18 12:23:18 +053016 self.calculate()
17
Nabin Hait3237c752015-02-17 11:11:11 +053018 def calculate(self):
Nabin Haitb315acb2019-07-12 14:27:19 +053019 if not len(self.doc.get("items")):
20 return
21
Nabin Hait3237c752015-02-17 11:11:11 +053022 self.discount_amount_applied = False
23 self._calculate()
24
25 if self.doc.meta.get_field("discount_amount"):
Nabin Hait3769d872015-12-18 13:12:02 +053026 self.set_discount_amount()
Nabin Hait3237c752015-02-17 11:11:11 +053027 self.apply_discount_amount()
28
Nabin Haitbd00e812015-02-17 12:50:51 +053029 if self.doc.doctype in ["Sales Invoice", "Purchase Invoice"]:
Nabin Hait3237c752015-02-17 11:11:11 +053030 self.calculate_total_advance()
Vishal Dhayaguded42242d2017-11-29 16:09:59 +053031
Nabin Hait852cb642017-07-05 12:58:19 +053032 if self.doc.meta.get_field("other_charges_calculation"):
33 self.set_item_wise_tax_breakup()
Nabin Hait3237c752015-02-17 11:11:11 +053034
35 def _calculate(self):
Faris Ansarieae2dda2018-05-02 12:19:30 +053036 self.validate_conversion_rate()
Nabin Haite7679702015-02-20 14:40:35 +053037 self.calculate_item_values()
Deepesh Gargef0d26c2020-01-06 15:34:15 +053038 self.validate_item_tax_template()
Nabin Haite7679702015-02-20 14:40:35 +053039 self.initialize_taxes()
40 self.determine_exclusive_rate()
41 self.calculate_net_total()
42 self.calculate_taxes()
Nabin Haita1bf43b2015-03-17 10:50:47 +053043 self.manipulate_grand_total_for_inclusive_tax()
Nabin Haite7679702015-02-20 14:40:35 +053044 self.calculate_totals()
45 self._cleanup()
rohitwaghchaurea8fb2db2018-05-26 09:23:02 +053046 self.calculate_total_net_weight()
Nabin Haite7679702015-02-20 14:40:35 +053047
Deepesh Gargef0d26c2020-01-06 15:34:15 +053048 def validate_item_tax_template(self):
49 for item in self.doc.get('items'):
50 if item.item_code and item.get('item_tax_template'):
51 item_doc = frappe.get_cached_doc("Item", item.item_code)
52 args = {
53 'tax_category': self.doc.get('tax_category'),
54 'posting_date': self.doc.get('posting_date'),
55 'bill_date': self.doc.get('bill_date'),
mohammadahmad1990728bf0e2020-06-18 12:21:42 +050056 'transaction_date': self.doc.get('transaction_date'),
57 'company': self.doc.get('company')
Deepesh Gargef0d26c2020-01-06 15:34:15 +053058 }
59
60 item_group = item_doc.item_group
61 item_group_taxes = []
62
63 while item_group:
64 item_group_doc = frappe.get_cached_doc('Item Group', item_group)
65 item_group_taxes += item_group_doc.taxes or []
66 item_group = item_group_doc.parent_item_group
67
68 item_taxes = item_doc.taxes or []
69
70 if not item_group_taxes and (not item_taxes):
71 # No validation if no taxes in item or item group
72 continue
73
74 taxes = _get_item_tax_template(args, item_taxes + item_group_taxes, for_validate=True)
75
76 if item.item_tax_template not in taxes:
77 frappe.throw(_("Row {0}: Invalid Item Tax Template for item {1}").format(
78 item.idx, frappe.bold(item.item_code)
79 ))
80
Nabin Haite7679702015-02-20 14:40:35 +053081 def validate_conversion_rate(self):
Nabin Hait3237c752015-02-17 11:11:11 +053082 # validate conversion rate
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +053083 company_currency = erpnext.get_company_currency(self.doc.company)
Nabin Hait3237c752015-02-17 11:11:11 +053084 if not self.doc.currency or self.doc.currency == company_currency:
85 self.doc.currency = company_currency
86 self.doc.conversion_rate = 1.0
87 else:
88 validate_conversion_rate(self.doc.currency, self.doc.conversion_rate,
89 self.doc.meta.get_label("conversion_rate"), self.doc.company)
90
91 self.doc.conversion_rate = flt(self.doc.conversion_rate)
92
Nabin Hait3237c752015-02-17 11:11:11 +053093 def calculate_item_values(self):
94 if not self.discount_amount_applied:
95 for item in self.doc.get("items"):
96 self.doc.round_floats_in(item)
97
98 if item.discount_percentage == 100:
99 item.rate = 0.0
Nabin Hait593242f2019-04-05 19:35:02 +0530100 elif item.price_list_rate:
101 if not item.rate or (item.pricing_rules and item.discount_percentage > 0):
102 item.rate = flt(item.price_list_rate *
103 (1.0 - (item.discount_percentage / 100.0)), item.precision("rate"))
104 item.discount_amount = item.price_list_rate * (item.discount_percentage / 100.0)
105 elif item.discount_amount and item.pricing_rules:
106 item.rate = item.price_list_rate - item.discount_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530107
mbauskara52472c2016-03-05 15:10:25 +0530108 if item.doctype in ['Quotation Item', 'Sales Order Item', 'Delivery Note Item', 'Sales Invoice Item']:
Shreya Shahbe690ef2017-11-14 17:22:41 +0530109 item.rate_with_margin, item.base_rate_with_margin = self.calculate_margin(item)
Nabin Hait64bfdd92019-04-23 13:37:19 +0530110 if flt(item.rate_with_margin) > 0:
111 item.rate = flt(item.rate_with_margin * (1.0 - (item.discount_percentage / 100.0)), item.precision("rate"))
112 item.discount_amount = item.rate_with_margin - item.rate
113 elif flt(item.price_list_rate) > 0:
114 item.discount_amount = item.price_list_rate - item.rate
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530115 elif flt(item.price_list_rate) > 0 and not item.discount_amount:
116 item.discount_amount = item.price_list_rate - item.rate
mbauskara52472c2016-03-05 15:10:25 +0530117
Nabin Haite7679702015-02-20 14:40:35 +0530118 item.net_rate = item.rate
Deepesh Gargb65c7612019-07-31 15:58:01 +0530119
deepeshgarg0078bf19ce2019-08-03 13:40:37 +0530120 if not item.qty and self.doc.get("is_return"):
Deepesh Gargb65c7612019-07-31 15:58:01 +0530121 item.amount = flt(-1 * item.rate, item.precision("amount"))
122 else:
123 item.amount = flt(item.rate * item.qty, item.precision("amount"))
124
Nabin Haite7679702015-02-20 14:40:35 +0530125 item.net_amount = item.amount
Nabin Hait3237c752015-02-17 11:11:11 +0530126
Nabin Haite7679702015-02-20 14:40:35 +0530127 self._set_in_company_currency(item, ["price_list_rate", "rate", "net_rate", "amount", "net_amount"])
Nabin Hait3237c752015-02-17 11:11:11 +0530128
Nabin Haite7679702015-02-20 14:40:35 +0530129 item.item_tax_amount = 0.0
130
131 def _set_in_company_currency(self, doc, fields):
Nabin Hait3237c752015-02-17 11:11:11 +0530132 """set values in base currency"""
Nabin Haite7679702015-02-20 14:40:35 +0530133 for f in fields:
134 val = flt(flt(doc.get(f), doc.precision(f)) * self.doc.conversion_rate, doc.precision("base_" + f))
135 doc.set("base_" + f, val)
Nabin Hait3237c752015-02-17 11:11:11 +0530136
137 def initialize_taxes(self):
138 for tax in self.doc.get("taxes"):
Nabin Hait86cd4cc2015-02-28 19:11:51 +0530139 if not self.discount_amount_applied:
140 validate_taxes_and_charges(tax)
141 validate_inclusive_tax(tax, self.doc)
Nabin Hait613d0812015-02-23 11:58:15 +0530142
Nabin Hait3237c752015-02-17 11:11:11 +0530143 tax.item_wise_tax_detail = {}
144 tax_fields = ["total", "tax_amount_after_discount_amount",
145 "tax_amount_for_current_item", "grand_total_for_current_item",
146 "tax_fraction_for_current_item", "grand_total_fraction_for_current_item"]
147
Nabin Haitde9c8a92015-02-23 01:06:00 +0530148 if tax.charge_type != "Actual" and \
149 not (self.discount_amount_applied and self.doc.apply_discount_on=="Grand Total"):
150 tax_fields.append("tax_amount")
Nabin Hait3237c752015-02-17 11:11:11 +0530151
152 for fieldname in tax_fields:
153 tax.set(fieldname, 0.0)
154
Nabin Hait3237c752015-02-17 11:11:11 +0530155 self.doc.round_floats_in(tax)
156
Nabin Hait3237c752015-02-17 11:11:11 +0530157 def determine_exclusive_rate(self):
Nabin Hait37b047d2015-02-23 16:01:33 +0530158 if not any((cint(tax.included_in_print_rate) for tax in self.doc.get("taxes"))):
159 return
Nabin Hait3237c752015-02-17 11:11:11 +0530160
161 for item in self.doc.get("items"):
162 item_tax_map = self._load_item_tax_rate(item.item_tax_rate)
163 cumulated_tax_fraction = 0
Nabin Hait19ea7212020-08-11 20:34:57 +0530164 total_inclusive_tax_amount_per_qty = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530165 for i, tax in enumerate(self.doc.get("taxes")):
Nabin Hait19ea7212020-08-11 20:34:57 +0530166 tax.tax_fraction_for_current_item, inclusive_tax_amount_per_qty = self.get_current_tax_fraction(tax, item_tax_map)
Nabin Hait3237c752015-02-17 11:11:11 +0530167
168 if i==0:
169 tax.grand_total_fraction_for_current_item = 1 + tax.tax_fraction_for_current_item
170 else:
171 tax.grand_total_fraction_for_current_item = \
172 self.doc.get("taxes")[i-1].grand_total_fraction_for_current_item \
173 + tax.tax_fraction_for_current_item
174
175 cumulated_tax_fraction += tax.tax_fraction_for_current_item
Nabin Haite2ee4552020-08-12 20:58:03 +0530176 total_inclusive_tax_amount_per_qty += inclusive_tax_amount_per_qty * flt(item.qty)
Nabin Hait3237c752015-02-17 11:11:11 +0530177
Nabin Hait19ea7212020-08-11 20:34:57 +0530178 if not self.discount_amount_applied and item.qty and (cumulated_tax_fraction or total_inclusive_tax_amount_per_qty):
179 amount = flt(item.amount) - total_inclusive_tax_amount_per_qty
180
181 item.net_amount = flt(amount / (1 + cumulated_tax_fraction))
Nabin Haite7679702015-02-20 14:40:35 +0530182 item.net_rate = flt(item.net_amount / item.qty, item.precision("net_rate"))
Nabin Hait2e4de832017-09-19 14:53:16 +0530183 item.discount_percentage = flt(item.discount_percentage,
184 item.precision("discount_percentage"))
Nabin Hait3237c752015-02-17 11:11:11 +0530185
Nabin Haite7679702015-02-20 14:40:35 +0530186 self._set_in_company_currency(item, ["net_rate", "net_amount"])
187
Nabin Hait3237c752015-02-17 11:11:11 +0530188 def _load_item_tax_rate(self, item_tax_rate):
189 return json.loads(item_tax_rate) if item_tax_rate else {}
190
191 def get_current_tax_fraction(self, tax, item_tax_map):
192 """
193 Get tax fraction for calculating tax exclusive amount
194 from tax inclusive amount
195 """
196 current_tax_fraction = 0
Nabin Hait19ea7212020-08-11 20:34:57 +0530197 inclusive_tax_amount_per_qty = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530198
199 if cint(tax.included_in_print_rate):
200 tax_rate = self._get_tax_rate(tax, item_tax_map)
201
202 if tax.charge_type == "On Net Total":
203 current_tax_fraction = tax_rate / 100.0
204
205 elif tax.charge_type == "On Previous Row Amount":
206 current_tax_fraction = (tax_rate / 100.0) * \
207 self.doc.get("taxes")[cint(tax.row_id) - 1].tax_fraction_for_current_item
208
209 elif tax.charge_type == "On Previous Row Total":
210 current_tax_fraction = (tax_rate / 100.0) * \
211 self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_fraction_for_current_item
Nabin Hait19ea7212020-08-11 20:34:57 +0530212
213 elif tax.charge_type == "On Item Quantity":
214 inclusive_tax_amount_per_qty = flt(tax_rate)
Nabin Hait3237c752015-02-17 11:11:11 +0530215
Nabin Hait19ea7212020-08-11 20:34:57 +0530216 if getattr(tax, "add_deduct_tax", None) and tax.add_deduct_tax == "Deduct":
217 current_tax_fraction *= -1.0
218 inclusive_tax_amount_per_qty *= -1.0
219
220 return current_tax_fraction, inclusive_tax_amount_per_qty
Nabin Hait3237c752015-02-17 11:11:11 +0530221
222 def _get_tax_rate(self, tax, item_tax_map):
Achilles Rasquinha87dab142018-03-08 14:21:48 +0530223 if tax.account_head in item_tax_map:
Nabin Hait3237c752015-02-17 11:11:11 +0530224 return flt(item_tax_map.get(tax.account_head), self.doc.precision("rate", tax))
225 else:
226 return tax.rate
227
228 def calculate_net_total(self):
Shreya Shahe3290382018-05-28 11:49:08 +0530229 self.doc.total_qty = self.doc.total = self.doc.base_total = self.doc.net_total = self.doc.base_net_total = 0.0
rohitwaghchaure3a595d02018-06-25 10:10:29 +0530230
Nabin Hait3237c752015-02-17 11:11:11 +0530231 for item in self.doc.get("items"):
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530232 self.doc.total += item.amount
Shreya Shahe3290382018-05-28 11:49:08 +0530233 self.doc.total_qty += item.qty
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530234 self.doc.base_total += item.base_amount
Nabin Haite7679702015-02-20 14:40:35 +0530235 self.doc.net_total += item.net_amount
236 self.doc.base_net_total += item.base_net_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530237
Nabin Haitf0bc9b62015-02-23 01:40:01 +0530238 self.doc.round_floats_in(self.doc, ["total", "base_total", "net_total", "base_net_total"])
Nabin Hait3237c752015-02-17 11:11:11 +0530239
rohitwaghchaure3a595d02018-06-25 10:10:29 +0530240 if self.doc.doctype == 'Sales Invoice' and self.doc.is_pos:
241 self.doc.pos_total_qty = self.doc.total_qty
242
Nabin Hait3237c752015-02-17 11:11:11 +0530243 def calculate_taxes(self):
Nabin Hait2e4de832017-09-19 14:53:16 +0530244 self.doc.rounding_adjustment = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530245 # maintain actual tax rate based on idx
Nabin Haite7679702015-02-20 14:40:35 +0530246 actual_tax_dict = dict([[tax.idx, flt(tax.tax_amount, tax.precision("tax_amount"))]
Nabin Hait3237c752015-02-17 11:11:11 +0530247 for tax in self.doc.get("taxes") if tax.charge_type == "Actual"])
248
249 for n, item in enumerate(self.doc.get("items")):
250 item_tax_map = self._load_item_tax_rate(item.item_tax_rate)
Nabin Hait3237c752015-02-17 11:11:11 +0530251 for i, tax in enumerate(self.doc.get("taxes")):
252 # tax_amount represents the amount of tax for the current step
253 current_tax_amount = self.get_current_tax_amount(item, tax, item_tax_map)
254
255 # Adjust divisional loss to the last item
256 if tax.charge_type == "Actual":
257 actual_tax_dict[tax.idx] -= current_tax_amount
258 if n == len(self.doc.get("items")) - 1:
259 current_tax_amount += actual_tax_dict[tax.idx]
260
Nabin Hait2b019ed2015-02-22 23:03:07 +0530261 # accumulate tax amount into tax.tax_amount
Nabin Haitde9c8a92015-02-23 01:06:00 +0530262 if tax.charge_type != "Actual" and \
263 not (self.discount_amount_applied and self.doc.apply_discount_on=="Grand Total"):
264 tax.tax_amount += current_tax_amount
Nabin Hait2b019ed2015-02-22 23:03:07 +0530265
Nabin Hait3237c752015-02-17 11:11:11 +0530266 # store tax_amount for current item as it will be used for
267 # charge type = 'On Previous Row Amount'
268 tax.tax_amount_for_current_item = current_tax_amount
269
Nabin Hait2b019ed2015-02-22 23:03:07 +0530270 # set tax after discount
Nabin Hait3237c752015-02-17 11:11:11 +0530271 tax.tax_amount_after_discount_amount += current_tax_amount
272
Nabin Haitcd951342017-07-31 18:07:45 +0530273 current_tax_amount = self.get_tax_amount_if_for_valuation_or_deduction(current_tax_amount, tax)
Nabin Hait3237c752015-02-17 11:11:11 +0530274
Nabin Hait3237c752015-02-17 11:11:11 +0530275 # note: grand_total_for_current_item contains the contribution of
276 # item's amount, previously applied tax and the current tax on that item
277 if i==0:
Nabin Haitcd951342017-07-31 18:07:45 +0530278 tax.grand_total_for_current_item = flt(item.net_amount + current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530279 else:
280 tax.grand_total_for_current_item = \
Nabin Haitcd951342017-07-31 18:07:45 +0530281 flt(self.doc.get("taxes")[i-1].grand_total_for_current_item + current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530282
283 # set precision in the last item iteration
284 if n == len(self.doc.get("items")) - 1:
285 self.round_off_totals(tax)
Nabin Haitcd951342017-07-31 18:07:45 +0530286 self.set_cumulative_total(i, tax)
287
288 self._set_in_company_currency(tax,
289 ["total", "tax_amount", "tax_amount_after_discount_amount"])
Anand Doshiec5ec602015-03-05 19:31:23 +0530290
Nabin Hait3237c752015-02-17 11:11:11 +0530291 # adjust Discount Amount loss in last tax iteration
Nabin Haitde9c8a92015-02-23 01:06:00 +0530292 if i == (len(self.doc.get("taxes")) - 1) and self.discount_amount_applied \
Nabin Haitdb53a782015-07-31 16:53:13 +0530293 and self.doc.discount_amount and self.doc.apply_discount_on == "Grand Total":
Nabin Hait2e4de832017-09-19 14:53:16 +0530294 self.doc.rounding_adjustment = flt(self.doc.grand_total
295 - flt(self.doc.discount_amount) - tax.total,
296 self.doc.precision("rounding_adjustment"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530297
Nabin Haitcd951342017-07-31 18:07:45 +0530298 def get_tax_amount_if_for_valuation_or_deduction(self, tax_amount, tax):
299 # if just for valuation, do not add the tax amount in total
300 # if tax/charges is for deduction, multiply by -1
301 if getattr(tax, "category", None):
302 tax_amount = 0.0 if (tax.category == "Valuation") else tax_amount
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530303 if self.doc.doctype in ["Purchase Order", "Purchase Invoice", "Purchase Receipt", "Supplier Quotation"]:
304 tax_amount *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
Nabin Haitcd951342017-07-31 18:07:45 +0530305 return tax_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530306
Nabin Haitcd951342017-07-31 18:07:45 +0530307 def set_cumulative_total(self, row_idx, tax):
308 tax_amount = tax.tax_amount_after_discount_amount
309 tax_amount = self.get_tax_amount_if_for_valuation_or_deduction(tax_amount, tax)
310
311 if row_idx == 0:
312 tax.total = flt(self.doc.net_total + tax_amount, tax.precision("total"))
313 else:
314 tax.total = flt(self.doc.get("taxes")[row_idx-1].total + tax_amount, tax.precision("total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530315
316 def get_current_tax_amount(self, item, tax, item_tax_map):
317 tax_rate = self._get_tax_rate(tax, item_tax_map)
318 current_tax_amount = 0.0
319
320 if tax.charge_type == "Actual":
321 # distribute the tax amount proportionally to each item row
Nabin Haite7679702015-02-20 14:40:35 +0530322 actual = flt(tax.tax_amount, tax.precision("tax_amount"))
323 current_tax_amount = item.net_amount*actual / self.doc.net_total if self.doc.net_total else 0.0
324
Nabin Hait3237c752015-02-17 11:11:11 +0530325 elif tax.charge_type == "On Net Total":
Nabin Haite7679702015-02-20 14:40:35 +0530326 current_tax_amount = (tax_rate / 100.0) * item.net_amount
Nabin Hait3237c752015-02-17 11:11:11 +0530327 elif tax.charge_type == "On Previous Row Amount":
328 current_tax_amount = (tax_rate / 100.0) * \
329 self.doc.get("taxes")[cint(tax.row_id) - 1].tax_amount_for_current_item
330 elif tax.charge_type == "On Previous Row Total":
331 current_tax_amount = (tax_rate / 100.0) * \
332 self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_for_current_item
Himanshu Mishra35b26272018-11-13 11:13:04 +0530333 elif tax.charge_type == "On Item Quantity":
Nabin Hait19ea7212020-08-11 20:34:57 +0530334 current_tax_amount = tax_rate * item.qty
Nabin Hait3237c752015-02-17 11:11:11 +0530335
Nabin Haite7679702015-02-20 14:40:35 +0530336 self.set_item_wise_tax(item, tax, tax_rate, current_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530337
338 return current_tax_amount
339
Nabin Haite7679702015-02-20 14:40:35 +0530340 def set_item_wise_tax(self, item, tax, tax_rate, current_tax_amount):
341 # store tax breakup for each item
342 key = item.item_code or item.item_name
343 item_wise_tax_amount = current_tax_amount*self.doc.conversion_rate
344 if tax.item_wise_tax_detail.get(key):
345 item_wise_tax_amount += tax.item_wise_tax_detail[key][1]
346
Nabin Haitcaab5822017-08-24 16:22:28 +0530347 tax.item_wise_tax_detail[key] = [tax_rate,flt(item_wise_tax_amount)]
Nabin Haite7679702015-02-20 14:40:35 +0530348
Nabin Hait3237c752015-02-17 11:11:11 +0530349 def round_off_totals(self, tax):
Nabin Haite7679702015-02-20 14:40:35 +0530350 tax.tax_amount = flt(tax.tax_amount, tax.precision("tax_amount"))
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530351 tax.tax_amount_after_discount_amount = flt(tax.tax_amount_after_discount_amount,
Nabin Haitcd951342017-07-31 18:07:45 +0530352 tax.precision("tax_amount"))
Nabin Haitce245122015-02-22 20:14:49 +0530353
Nabin Haita1bf43b2015-03-17 10:50:47 +0530354 def manipulate_grand_total_for_inclusive_tax(self):
355 # if fully inclusive taxes and diff
Nabin Hait2e4de832017-09-19 14:53:16 +0530356 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 +0530357 last_tax = self.doc.get("taxes")[-1]
Nabin Hait2e4de832017-09-19 14:53:16 +0530358 non_inclusive_tax_amount = sum([flt(d.tax_amount_after_discount_amount)
359 for d in self.doc.get("taxes") if not d.included_in_print_rate])
Nabin Haitf32fc232019-12-25 13:59:24 +0530360
Nabin Hait2e4de832017-09-19 14:53:16 +0530361 diff = self.doc.total + non_inclusive_tax_amount \
362 - flt(last_tax.total, last_tax.precision("total"))
Nabin Haitf32fc232019-12-25 13:59:24 +0530363
364 # If discount amount applied, deduct the discount amount
365 # because self.doc.total is always without discount, but last_tax.total is after discount
366 if self.discount_amount_applied and self.doc.discount_amount:
367 diff -= flt(self.doc.discount_amount)
368
369 diff = flt(diff, self.doc.precision("rounding_adjustment"))
370
Nabin Hait2e4de832017-09-19 14:53:16 +0530371 if diff and abs(diff) <= (5.0 / 10**last_tax.precision("tax_amount")):
Nabin Haitf32fc232019-12-25 13:59:24 +0530372 self.doc.rounding_adjustment = diff
Nabin Hait3237c752015-02-17 11:11:11 +0530373
374 def calculate_totals(self):
Nabin Hait2e4de832017-09-19 14:53:16 +0530375 self.doc.grand_total = flt(self.doc.get("taxes")[-1].total) + flt(self.doc.rounding_adjustment) \
376 if self.doc.get("taxes") else flt(self.doc.net_total)
Nabin Hait3237c752015-02-17 11:11:11 +0530377
Nabin Hait2e4de832017-09-19 14:53:16 +0530378 self.doc.total_taxes_and_charges = flt(self.doc.grand_total - self.doc.net_total
379 - flt(self.doc.rounding_adjustment), self.doc.precision("total_taxes_and_charges"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530380
Nabin Hait2e4de832017-09-19 14:53:16 +0530381 self._set_in_company_currency(self.doc, ["total_taxes_and_charges", "rounding_adjustment"])
Anand Doshiec5ec602015-03-05 19:31:23 +0530382
Saqiba6f98d42020-07-23 18:51:26 +0530383 if self.doc.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice", "POS Invoice"]:
Anurag Mishra8a06b8f2019-07-17 14:55:16 +0530384 self.doc.base_grand_total = flt(self.doc.grand_total * self.doc.conversion_rate, self.doc.precision("base_grand_total")) \
Nabin Haite7679702015-02-20 14:40:35 +0530385 if self.doc.total_taxes_and_charges else self.doc.base_net_total
Nabin Hait3237c752015-02-17 11:11:11 +0530386 else:
Anand Doshiec5ec602015-03-05 19:31:23 +0530387 self.doc.taxes_and_charges_added = self.doc.taxes_and_charges_deducted = 0.0
Nabin Hait3237c752015-02-17 11:11:11 +0530388 for tax in self.doc.get("taxes"):
389 if tax.category in ["Valuation and Total", "Total"]:
390 if tax.add_deduct_tax == "Add":
Nabin Haitdb53a782015-07-31 16:53:13 +0530391 self.doc.taxes_and_charges_added += flt(tax.tax_amount_after_discount_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530392 else:
Nabin Haitdb53a782015-07-31 16:53:13 +0530393 self.doc.taxes_and_charges_deducted += flt(tax.tax_amount_after_discount_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530394
Nabin Haite7679702015-02-20 14:40:35 +0530395 self.doc.round_floats_in(self.doc, ["taxes_and_charges_added", "taxes_and_charges_deducted"])
Nabin Hait3237c752015-02-17 11:11:11 +0530396
Nabin Haite7679702015-02-20 14:40:35 +0530397 self.doc.base_grand_total = flt(self.doc.grand_total * self.doc.conversion_rate) \
398 if (self.doc.taxes_and_charges_added or self.doc.taxes_and_charges_deducted) \
399 else self.doc.base_net_total
Nabin Hait3237c752015-02-17 11:11:11 +0530400
Nabin Hait2e4de832017-09-19 14:53:16 +0530401 self._set_in_company_currency(self.doc,
402 ["taxes_and_charges_added", "taxes_and_charges_deducted"])
Nabin Hait3237c752015-02-17 11:11:11 +0530403
Nabin Haite7679702015-02-20 14:40:35 +0530404 self.doc.round_floats_in(self.doc, ["grand_total", "base_grand_total"])
Nabin Hait3237c752015-02-17 11:11:11 +0530405
Nabin Hait2e4de832017-09-19 14:53:16 +0530406 self.set_rounded_total()
407
rohitwaghchaurea8fb2db2018-05-26 09:23:02 +0530408 def calculate_total_net_weight(self):
409 if self.doc.meta.get_field('total_net_weight'):
410 self.doc.total_net_weight = 0.0
411 for d in self.doc.items:
412 if d.total_weight:
413 self.doc.total_net_weight += d.total_weight
414
Nabin Hait2e4de832017-09-19 14:53:16 +0530415 def set_rounded_total(self):
Nabin Hait3237c752015-02-17 11:11:11 +0530416 if self.doc.meta.get_field("rounded_total"):
Nabin Hait877e1bb2017-11-17 12:27:43 +0530417 if self.doc.is_rounded_total_disabled():
418 self.doc.rounded_total = self.doc.base_rounded_total = 0
419 return
420
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530421 self.doc.rounded_total = round_based_on_smallest_currency_fraction(self.doc.grand_total,
Nabin Haitfb0b24a2016-01-20 14:46:26 +0530422 self.doc.currency, self.doc.precision("rounded_total"))
Nabin Hait2e4de832017-09-19 14:53:16 +0530423
Nabin Hait877e1bb2017-11-17 12:27:43 +0530424 #if print_in_rate is set, we would have already calculated rounding adjustment
425 self.doc.rounding_adjustment += flt(self.doc.rounded_total - self.doc.grand_total,
426 self.doc.precision("rounding_adjustment"))
427
Nabin Hait02ac9012017-11-22 16:12:20 +0530428 self._set_in_company_currency(self.doc, ["rounding_adjustment", "rounded_total"])
Nabin Hait877e1bb2017-11-17 12:27:43 +0530429
Nabin Hait3237c752015-02-17 11:11:11 +0530430 def _cleanup(self):
431 for tax in self.doc.get("taxes"):
432 tax.item_wise_tax_detail = json.dumps(tax.item_wise_tax_detail, separators=(',', ':'))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530433
Nabin Hait3769d872015-12-18 13:12:02 +0530434 def set_discount_amount(self):
Nabin Haite0405102016-10-13 12:14:32 +0530435 if self.doc.additional_discount_percentage:
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530436 self.doc.discount_amount = flt(flt(self.doc.get(scrub(self.doc.apply_discount_on)))
Nabin Hait3769d872015-12-18 13:12:02 +0530437 * self.doc.additional_discount_percentage / 100, self.doc.precision("discount_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530438
439 def apply_discount_amount(self):
440 if self.doc.discount_amount:
Nabin Hait37b047d2015-02-23 16:01:33 +0530441 if not self.doc.apply_discount_on:
442 frappe.throw(_("Please select Apply Discount On"))
443
Nabin Hait3237c752015-02-17 11:11:11 +0530444 self.doc.base_discount_amount = flt(self.doc.discount_amount * self.doc.conversion_rate,
445 self.doc.precision("base_discount_amount"))
446
Nabin Haite7679702015-02-20 14:40:35 +0530447 total_for_discount_amount = self.get_total_for_discount_amount()
Nabin Hait25bd84d2015-03-04 15:06:56 +0530448 taxes = self.doc.get("taxes")
449 net_total = 0
Nabin Hait3237c752015-02-17 11:11:11 +0530450
Nabin Haite7679702015-02-20 14:40:35 +0530451 if total_for_discount_amount:
Nabin Hait3237c752015-02-17 11:11:11 +0530452 # calculate item amount after Discount Amount
Nabin Hait25bd84d2015-03-04 15:06:56 +0530453 for i, item in enumerate(self.doc.get("items")):
454 distributed_amount = flt(self.doc.discount_amount) * \
455 item.net_amount / total_for_discount_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530456
Nabin Haite7679702015-02-20 14:40:35 +0530457 item.net_amount = flt(item.net_amount - distributed_amount, item.precision("net_amount"))
Nabin Hait25bd84d2015-03-04 15:06:56 +0530458 net_total += item.net_amount
Anand Doshiec5ec602015-03-05 19:31:23 +0530459
Nabin Hait25bd84d2015-03-04 15:06:56 +0530460 # discount amount rounding loss adjustment if no taxes
Nabin Hait4d587342019-05-30 15:50:46 +0530461 if (self.doc.apply_discount_on == "Net Total" or not taxes or total_for_discount_amount==self.doc.net_total) \
Nabin Hait25bd84d2015-03-04 15:06:56 +0530462 and i == len(self.doc.get("items")) - 1:
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530463 discount_amount_loss = flt(self.doc.net_total - net_total - self.doc.discount_amount,
Nabin Hait25bd84d2015-03-04 15:06:56 +0530464 self.doc.precision("net_total"))
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530465
Anand Doshiec5ec602015-03-05 19:31:23 +0530466 item.net_amount = flt(item.net_amount + discount_amount_loss,
Nabin Hait25bd84d2015-03-04 15:06:56 +0530467 item.precision("net_amount"))
Anand Doshiec5ec602015-03-05 19:31:23 +0530468
Nabin Hait51e980d2015-10-10 18:10:05 +0530469 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 +0530470
Nabin Haite7679702015-02-20 14:40:35 +0530471 self._set_in_company_currency(item, ["net_rate", "net_amount"])
Nabin Hait3237c752015-02-17 11:11:11 +0530472
473 self.discount_amount_applied = True
474 self._calculate()
475 else:
476 self.doc.base_discount_amount = 0
477
Nabin Haite7679702015-02-20 14:40:35 +0530478 def get_total_for_discount_amount(self):
Nabin Haitde9c8a92015-02-23 01:06:00 +0530479 if self.doc.apply_discount_on == "Net Total":
480 return self.doc.net_total
Nabin Haite7679702015-02-20 14:40:35 +0530481 else:
482 actual_taxes_dict = {}
Nabin Hait3237c752015-02-17 11:11:11 +0530483
Nabin Haite7679702015-02-20 14:40:35 +0530484 for tax in self.doc.get("taxes"):
Nabin Hait19ea7212020-08-11 20:34:57 +0530485 if tax.charge_type in ["Actual", "On Item Quantity"]:
Nabin Haitaf9bdfe2017-12-12 18:50:05 +0530486 tax_amount = self.get_tax_amount_if_for_valuation_or_deduction(tax.tax_amount, tax)
487 actual_taxes_dict.setdefault(tax.idx, tax_amount)
Nabin Haite7679702015-02-20 14:40:35 +0530488 elif tax.row_id in actual_taxes_dict:
489 actual_tax_amount = flt(actual_taxes_dict.get(tax.row_id, 0)) * flt(tax.rate) / 100
490 actual_taxes_dict.setdefault(tax.idx, actual_tax_amount)
Nabin Hait3237c752015-02-17 11:11:11 +0530491
Nabin Hait877e1bb2017-11-17 12:27:43 +0530492 return flt(self.doc.grand_total - sum(actual_taxes_dict.values()),
493 self.doc.precision("grand_total"))
Nabin Hait3237c752015-02-17 11:11:11 +0530494
495
Nabin Hait7b19b9e2015-02-24 09:42:24 +0530496 def calculate_total_advance(self):
497 if self.doc.docstatus < 2:
Nabin Haite7679702015-02-20 14:40:35 +0530498 total_allocated_amount = sum([flt(adv.allocated_amount, adv.precision("allocated_amount"))
Nabin Hait3237c752015-02-17 11:11:11 +0530499 for adv in self.doc.get("advances")])
500
Nabin Haite7679702015-02-20 14:40:35 +0530501 self.doc.total_advance = flt(total_allocated_amount, self.doc.precision("total_advance"))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530502
Faris Ansari6041f5c2018-02-08 13:33:52 +0530503 grand_total = self.doc.rounded_total or self.doc.grand_total
504
Nabin Hait289ffb72016-02-08 11:06:55 +0530505 if self.doc.party_account_currency == self.doc.currency:
Faris Ansari6041f5c2018-02-08 13:33:52 +0530506 invoice_total = flt(grand_total - flt(self.doc.write_off_amount),
Nabin Hait289ffb72016-02-08 11:06:55 +0530507 self.doc.precision("grand_total"))
Nabin Hait8d8cba72017-04-03 17:26:22 +0530508 else:
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530509 base_write_off_amount = flt(flt(self.doc.write_off_amount) * self.doc.conversion_rate,
Nabin Hait8d8cba72017-04-03 17:26:22 +0530510 self.doc.precision("base_write_off_amount"))
Faris Ansari6041f5c2018-02-08 13:33:52 +0530511 invoice_total = flt(grand_total * self.doc.conversion_rate,
Nabin Hait8d8cba72017-04-03 17:26:22 +0530512 self.doc.precision("grand_total")) - base_write_off_amount
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530513
Nabin Haitadc09232016-02-09 10:31:11 +0530514 if invoice_total > 0 and self.doc.total_advance > invoice_total:
Nabin Hait289ffb72016-02-08 11:06:55 +0530515 frappe.throw(_("Advance amount cannot be greater than {0} {1}")
516 .format(self.doc.party_account_currency, invoice_total))
Nabin Hait3237c752015-02-17 11:11:11 +0530517
Rushabh Mehta8bb6e532015-02-18 20:22:59 +0530518 if self.doc.docstatus == 0:
Nabin Hait3237c752015-02-17 11:11:11 +0530519 self.calculate_outstanding_amount()
520
521 def calculate_outstanding_amount(self):
522 # NOTE:
523 # write_off_amount is only for POS Invoice
524 # total_advance is only for non POS Invoice
Rohit Waghchaureefb5bf22016-08-25 02:09:53 +0530525 if self.doc.doctype == "Sales Invoice":
526 self.calculate_paid_amount()
527
Deepesh Garg0ebace52020-02-25 13:21:16 +0530528 if self.doc.is_return and self.doc.return_against and not self.doc.get('is_pos'): return
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530529
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530530 self.doc.round_floats_in(self.doc, ["grand_total", "total_advance", "write_off_amount"])
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530531 self._set_in_company_currency(self.doc, ['write_off_amount'])
532
Nabin Hait877e1bb2017-11-17 12:27:43 +0530533 if self.doc.doctype in ["Sales Invoice", "Purchase Invoice"]:
534 grand_total = self.doc.rounded_total or self.doc.grand_total
535 if self.doc.party_account_currency == self.doc.currency:
Manas Solankida486ee2018-07-06 12:36:57 +0530536 total_amount_to_pay = flt(grand_total - self.doc.total_advance
Nabin Hait877e1bb2017-11-17 12:27:43 +0530537 - flt(self.doc.write_off_amount), self.doc.precision("grand_total"))
538 else:
539 total_amount_to_pay = flt(flt(grand_total *
540 self.doc.conversion_rate, self.doc.precision("grand_total")) - self.doc.total_advance
541 - flt(self.doc.base_write_off_amount), self.doc.precision("grand_total"))
Anand Doshi15f7b1e2016-04-04 15:03:28 +0530542
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530543 self.doc.round_floats_in(self.doc, ["paid_amount"])
Nabin Hait877e1bb2017-11-17 12:27:43 +0530544 change_amount = 0
545
Deepesh Garg0ebace52020-02-25 13:21:16 +0530546 if self.doc.doctype == "Sales Invoice" and not self.doc.get('is_return'):
Nabin Hait877e1bb2017-11-17 12:27:43 +0530547 self.calculate_write_off_amount()
548 self.calculate_change_amount()
549 change_amount = self.doc.change_amount \
550 if self.doc.party_account_currency == self.doc.currency else self.doc.base_change_amount
551
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530552 paid_amount = self.doc.paid_amount \
553 if self.doc.party_account_currency == self.doc.currency else self.doc.base_paid_amount
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530554
Nabin Hait877e1bb2017-11-17 12:27:43 +0530555 self.doc.outstanding_amount = flt(total_amount_to_pay - flt(paid_amount) + flt(change_amount),
556 self.doc.precision("outstanding_amount"))
Rushabh Mehtac6bd7ad2016-12-21 17:30:29 +0530557
Deepesh Garg0ebace52020-02-25 13:21:16 +0530558 if self.doc.doctype == 'Sales Invoice' and self.doc.get('is_pos') and self.doc.get('is_return'):
559 self.update_paid_amount_for_return(total_amount_to_pay)
560
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530561 def calculate_paid_amount(self):
Manas Solankida486ee2018-07-06 12:36:57 +0530562
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530563 paid_amount = base_paid_amount = 0.0
Rohit Waghchauref58cad62017-01-17 12:11:57 +0530564
565 if self.doc.is_pos:
566 for payment in self.doc.get('payments'):
Ayush Shuklae9cf1ab2017-05-25 14:14:55 +0530567 payment.amount = flt(payment.amount)
568 payment.base_amount = payment.amount * flt(self.doc.conversion_rate)
Rohit Waghchauref58cad62017-01-17 12:11:57 +0530569 paid_amount += payment.amount
570 base_paid_amount += payment.base_amount
rohitwaghchaure73456ac2017-05-16 11:29:57 +0530571 elif not self.doc.is_return:
572 self.doc.set('payments', [])
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530573
Manas Solankida486ee2018-07-06 12:36:57 +0530574 if self.doc.redeem_loyalty_points and self.doc.loyalty_amount:
575 base_paid_amount += self.doc.loyalty_amount
576 paid_amount += (self.doc.loyalty_amount / flt(self.doc.conversion_rate))
577
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530578 self.doc.paid_amount = flt(paid_amount, self.doc.precision("paid_amount"))
579 self.doc.base_paid_amount = flt(base_paid_amount, self.doc.precision("base_paid_amount"))
580
Nabin Hait3bb1a422016-08-02 16:41:10 +0530581 def calculate_change_amount(self):
582 self.doc.change_amount = 0.0
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530583 self.doc.base_change_amount = 0.0
Nabin Hait877e1bb2017-11-17 12:27:43 +0530584
585 if self.doc.doctype == "Sales Invoice" \
586 and self.doc.paid_amount > self.doc.grand_total and not self.doc.is_return \
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530587 and any([d.type == "Cash" for d in self.doc.payments]):
Rohit Waghchauree8d22bb2018-02-05 18:13:29 +0530588 grand_total = self.doc.rounded_total or self.doc.grand_total
589 base_grand_total = self.doc.base_rounded_total or self.doc.base_grand_total
Nabin Haitac3b2aa2017-05-30 15:35:01 +0530590
Rohit Waghchauree8d22bb2018-02-05 18:13:29 +0530591 self.doc.change_amount = flt(self.doc.paid_amount - grand_total +
Nabin Hait3bb1a422016-08-02 16:41:10 +0530592 self.doc.write_off_amount, self.doc.precision("change_amount"))
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530593
Rohit Waghchauree8d22bb2018-02-05 18:13:29 +0530594 self.doc.base_change_amount = flt(self.doc.base_paid_amount - base_grand_total +
Rohit Waghchaure609e2b42016-08-31 02:04:37 +0530595 self.doc.base_write_off_amount, self.doc.precision("base_change_amount"))
mbauskar36b51892016-01-18 16:31:10 +0530596
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530597 def calculate_write_off_amount(self):
Rohit Waghchaurebaef2622016-08-05 15:41:36 +0530598 if flt(self.doc.change_amount) > 0:
Nabin Hait877e1bb2017-11-17 12:27:43 +0530599 self.doc.write_off_amount = flt(self.doc.grand_total - self.doc.paid_amount
600 + self.doc.change_amount, self.doc.precision("write_off_amount"))
Rohit Waghchaurebaef2622016-08-05 15:41:36 +0530601 self.doc.base_write_off_amount = flt(self.doc.write_off_amount * self.doc.conversion_rate,
602 self.doc.precision("base_write_off_amount"))
Rohit Waghchaure7127a8f2016-08-04 14:56:15 +0530603
mbauskar36b51892016-01-18 16:31:10 +0530604 def calculate_margin(self, item):
Shreya Shahf718b0c2018-02-20 11:26:46 +0530605
Makarand Bauskar0e4c5c92017-05-11 11:40:02 +0530606 rate_with_margin = 0.0
Shreya Shahbe690ef2017-11-14 17:22:41 +0530607 base_rate_with_margin = 0.0
mbauskar36b51892016-01-18 16:31:10 +0530608 if item.price_list_rate:
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530609 if item.pricing_rules and not self.doc.ignore_pricing_rule:
Deepesh Garg7ac4ad82020-07-23 12:12:55 +0530610 for d in json.loads(item.pricing_rules):
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530611 pricing_rule = frappe.get_cached_doc('Pricing Rule', d)
Shreya Shahf718b0c2018-02-20 11:26:46 +0530612
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530613 if (pricing_rule.margin_type == 'Amount' and pricing_rule.currency == self.doc.currency)\
614 or (pricing_rule.margin_type == 'Percentage'):
615 item.margin_type = pricing_rule.margin_type
616 item.margin_rate_or_amount = pricing_rule.margin_rate_or_amount
617 else:
618 item.margin_type = None
619 item.margin_rate_or_amount = 0.0
mbauskar36b51892016-01-18 16:31:10 +0530620
mbauskara52472c2016-03-05 15:10:25 +0530621 if item.margin_type and item.margin_rate_or_amount:
622 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 +0530623 rate_with_margin = flt(item.price_list_rate) + flt(margin_value)
Shreya Shahbe690ef2017-11-14 17:22:41 +0530624 base_rate_with_margin = flt(rate_with_margin) * flt(self.doc.conversion_rate)
mbauskar36b51892016-01-18 16:31:10 +0530625
Shreya Shahbe690ef2017-11-14 17:22:41 +0530626 return rate_with_margin, base_rate_with_margin
Nabin Hait852cb642017-07-05 12:58:19 +0530627
628 def set_item_wise_tax_breakup(self):
Nabin Hait9c421612017-07-20 13:32:01 +0530629 self.doc.other_charges_calculation = get_itemised_tax_breakup_html(self.doc)
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530630
Deepesh Garg0ebace52020-02-25 13:21:16 +0530631 def update_paid_amount_for_return(self, total_amount_to_pay):
Saqiba6f98d42020-07-23 18:51:26 +0530632 default_mode_of_payment = frappe.db.get_value('POS Payment Method',
633 {'parent': self.doc.pos_profile, 'default': 1}, ['mode_of_payment'], as_dict=1)
Deepesh Garg0ebace52020-02-25 13:21:16 +0530634
635 self.doc.payments = []
636
637 if default_mode_of_payment:
638 self.doc.append('payments', {
639 'mode_of_payment': default_mode_of_payment.mode_of_payment,
Deepesh Garg0ebace52020-02-25 13:21:16 +0530640 'amount': total_amount_to_pay
641 })
642 else:
643 self.doc.is_pos = 0
644 self.doc.pos_profile = ''
645
646 self.calculate_paid_amount()
647
648
Nabin Hait9c421612017-07-20 13:32:01 +0530649def get_itemised_tax_breakup_html(doc):
650 if not doc.taxes:
651 return
652 frappe.flags.company = doc.company
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530653
Nabin Hait9c421612017-07-20 13:32:01 +0530654 # get headers
Nabin Haitcaab5822017-08-24 16:22:28 +0530655 tax_accounts = []
656 for tax in doc.taxes:
657 if getattr(tax, "category", None) and tax.category=="Valuation":
658 continue
rohitwaghchaure4e17fae2017-12-12 14:40:52 +0530659 if tax.description not in tax_accounts:
Nabin Haitcaab5822017-08-24 16:22:28 +0530660 tax_accounts.append(tax.description)
661
Nabin Hait9c421612017-07-20 13:32:01 +0530662 headers = get_itemised_tax_breakup_header(doc.doctype + " Item", tax_accounts)
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530663
Nabin Hait9c421612017-07-20 13:32:01 +0530664 # get tax breakup data
665 itemised_tax, itemised_taxable_amount = get_itemised_tax_breakup_data(doc)
Nabin Haitcaab5822017-08-24 16:22:28 +0530666
667 get_rounded_tax_amount(itemised_tax, doc.precision("tax_amount", "taxes"))
668
rohitwaghchaured4526682017-12-28 14:20:13 +0530669 update_itemised_tax_data(doc)
Nabin Hait9c421612017-07-20 13:32:01 +0530670 frappe.flags.company = None
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530671
Nabin Hait9c421612017-07-20 13:32:01 +0530672 return frappe.render_template(
673 "templates/includes/itemised_tax_breakup.html", dict(
674 headers=headers,
675 itemised_tax=itemised_tax,
676 itemised_taxable_amount=itemised_taxable_amount,
677 tax_accounts=tax_accounts,
Saqib Ansari10a6a2d2020-04-13 16:40:13 +0530678 doc=doc
Nabin Haitb962fc12017-07-17 18:02:31 +0530679 )
Nabin Hait9c421612017-07-20 13:32:01 +0530680 )
Nabin Hait852cb642017-07-05 12:58:19 +0530681
rohitwaghchaured4526682017-12-28 14:20:13 +0530682
683@erpnext.allow_regional
684def update_itemised_tax_data(doc):
685 #Don't delete this method, used for localization
686 pass
687
Nabin Haitb962fc12017-07-17 18:02:31 +0530688@erpnext.allow_regional
689def get_itemised_tax_breakup_header(item_doctype, tax_accounts):
690 return [_("Item"), _("Taxable Amount")] + tax_accounts
691
692@erpnext.allow_regional
693def get_itemised_tax_breakup_data(doc):
694 itemised_tax = get_itemised_tax(doc.taxes)
695
696 itemised_taxable_amount = get_itemised_taxable_amount(doc.items)
697
698 return itemised_tax, itemised_taxable_amount
699
Nabin Hait34c551d2019-07-03 10:34:31 +0530700def get_itemised_tax(taxes, with_tax_account=False):
Nabin Haitb962fc12017-07-17 18:02:31 +0530701 itemised_tax = {}
702 for tax in taxes:
Nabin Haitcaab5822017-08-24 16:22:28 +0530703 if getattr(tax, "category", None) and tax.category=="Valuation":
704 continue
705
Nabin Haitb962fc12017-07-17 18:02:31 +0530706 item_tax_map = json.loads(tax.item_wise_tax_detail) if tax.item_wise_tax_detail else {}
Nabin Hait2e4de832017-09-19 14:53:16 +0530707 if item_tax_map:
708 for item_code, tax_data in item_tax_map.items():
709 itemised_tax.setdefault(item_code, frappe._dict())
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530710
Prateeksha Singhea7533f2018-06-11 13:31:33 +0530711 tax_rate = 0.0
712 tax_amount = 0.0
713
Nabin Hait2e4de832017-09-19 14:53:16 +0530714 if isinstance(tax_data, list):
Prateeksha Singhea7533f2018-06-11 13:31:33 +0530715 tax_rate = flt(tax_data[0])
716 tax_amount = flt(tax_data[1])
Nabin Hait2e4de832017-09-19 14:53:16 +0530717 else:
Prateeksha Singhea7533f2018-06-11 13:31:33 +0530718 tax_rate = flt(tax_data)
719
720 itemised_tax[item_code][tax.description] = frappe._dict(dict(
721 tax_rate = tax_rate,
722 tax_amount = tax_amount
723 ))
Rohit Waghchaure296fbfe2017-07-10 13:03:29 +0530724
Nabin Hait34c551d2019-07-03 10:34:31 +0530725 if with_tax_account:
726 itemised_tax[item_code][tax.description].tax_account = tax.account_head
727
Nabin Haitb962fc12017-07-17 18:02:31 +0530728 return itemised_tax
729
730def get_itemised_taxable_amount(items):
731 itemised_taxable_amount = frappe._dict()
732 for item in items:
Rohit Waghchaure296fbfe2017-07-10 13:03:29 +0530733 item_code = item.item_code or item.item_name
Nabin Haitb962fc12017-07-17 18:02:31 +0530734 itemised_taxable_amount.setdefault(item_code, 0)
735 itemised_taxable_amount[item_code] += item.net_amount
736
Nabin Haitcaab5822017-08-24 16:22:28 +0530737 return itemised_taxable_amount
738
739def get_rounded_tax_amount(itemised_tax, precision):
740 # Rounding based on tax_amount precision
741 for taxes in itemised_tax.values():
742 for tax_account in taxes:
Himanshu Mishra35b26272018-11-13 11:13:04 +0530743 taxes[tax_account]["tax_amount"] = flt(taxes[tax_account]["tax_amount"], precision)