Anand Doshi | 885e074 | 2015-03-03 14:55:30 +0530 | [diff] [blame] | 1 | # Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors |
Rushabh Mehta | e67d1fb | 2013-08-05 14:59:54 +0530 | [diff] [blame] | 2 | # License: GNU General Public License v3. See license.txt |
Nabin Hait | ec52db8 | 2013-01-22 11:53:14 +0530 | [diff] [blame] | 3 | |
Nabin Hait | ec52db8 | 2013-01-22 11:53:14 +0530 | [diff] [blame] | 4 | |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 5 | import frappe |
| 6 | from frappe import _, bold, throw |
| 7 | from frappe.contacts.doctype.address.address import get_address_display |
| 8 | from frappe.utils import cint, cstr, flt, get_link_to_form, nowtime |
| 9 | |
| 10 | from erpnext.controllers.accounts_controller import get_taxes_and_charges |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 11 | from erpnext.controllers.sales_and_purchase_return import get_rate_for_return |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 12 | from erpnext.controllers.stock_controller import StockController |
| 13 | from erpnext.stock.doctype.item.item import set_item_default |
| 14 | from erpnext.stock.get_item_details import get_bin_details, get_conversion_factor |
| 15 | from erpnext.stock.utils import get_incoming_rate |
| 16 | |
Nabin Hait | bf495c9 | 2013-01-30 12:49:08 +0530 | [diff] [blame] | 17 | |
Nabin Hait | c3afb25 | 2013-03-19 12:01:24 +0530 | [diff] [blame] | 18 | class SellingController(StockController): |
Rushabh Mehta | c0bb453 | 2014-09-09 16:15:35 +0530 | [diff] [blame] | 19 | def get_feed(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 20 | return _("To {0} | {1} {2}").format(self.customer_name, self.currency, self.grand_total) |
Rushabh Mehta | c0bb453 | 2014-09-09 16:15:35 +0530 | [diff] [blame] | 21 | |
Rushabh Mehta | b5e7689 | 2014-07-29 16:07:43 +0530 | [diff] [blame] | 22 | def onload(self): |
Rohit Waghchaure | 7d52989 | 2016-10-06 14:35:04 +0530 | [diff] [blame] | 23 | super(SellingController, self).onload() |
Rushabh Mehta | b5e7689 | 2014-07-29 16:07:43 +0530 | [diff] [blame] | 24 | if self.doctype in ("Sales Order", "Delivery Note", "Sales Invoice"): |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 25 | for item in self.get("items"): |
Nabin Hait | 877e1bb | 2017-11-17 12:27:43 +0530 | [diff] [blame] | 26 | item.update(get_bin_details(item.item_code, item.warehouse)) |
Rushabh Mehta | b5e7689 | 2014-07-29 16:07:43 +0530 | [diff] [blame] | 27 | |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 28 | def validate(self): |
| 29 | super(SellingController, self).validate() |
Zarrar | fc03a04 | 2018-06-04 12:52:52 +0530 | [diff] [blame] | 30 | self.validate_items() |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 31 | self.validate_max_discount() |
shreyas | 1cfe2d7 | 2016-10-19 18:36:12 +0530 | [diff] [blame] | 32 | self.validate_selling_price() |
Kanchan Chauhan | 5a980ac | 2017-02-10 14:27:11 +0530 | [diff] [blame] | 33 | self.set_qty_as_per_stock_uom() |
Afshan | 01eca12 | 2020-12-08 09:27:56 +0530 | [diff] [blame] | 34 | self.set_po_nos(for_validate=True) |
Saif Ur Rehman | 5fdbc68 | 2018-11-26 19:32:16 +0500 | [diff] [blame] | 35 | self.set_gross_profit() |
Rushabh Mehta | 708e47a | 2018-08-08 16:37:31 +0530 | [diff] [blame] | 36 | set_default_income_account_for_item(self) |
Rohit Waghchaure | f4dc716 | 2018-11-15 17:04:02 +0530 | [diff] [blame] | 37 | self.set_customer_address() |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 38 | self.validate_for_duplicate_items() |
rohitwaghchaure | 6fa6caf | 2020-04-23 09:46:29 +0530 | [diff] [blame] | 39 | self.validate_target_warehouse() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 40 | |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 41 | def set_missing_values(self, for_validate=False): |
Shreya Shah | 5615cb4 | 2018-10-07 11:42:07 +0530 | [diff] [blame] | 42 | |
Anand Doshi | abc1003 | 2013-06-14 17:44:03 +0530 | [diff] [blame] | 43 | super(SellingController, self).set_missing_values(for_validate) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 44 | |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 45 | # set contact and address details for customer, if they are not mentioned |
Deepesh Garg | 6f3d93e | 2020-09-18 11:23:35 +0530 | [diff] [blame] | 46 | self.set_missing_lead_customer_details(for_validate=for_validate) |
mbauskar | 9e9d242 | 2017-04-10 19:16:07 +0530 | [diff] [blame] | 47 | self.set_price_list_and_item_details(for_validate=for_validate) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 48 | |
Deepesh Garg | 6f3d93e | 2020-09-18 11:23:35 +0530 | [diff] [blame] | 49 | def set_missing_lead_customer_details(self, for_validate=False): |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 50 | customer, lead = None, None |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 51 | if getattr(self, "customer", None): |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 52 | customer = self.customer |
| 53 | elif self.doctype == "Opportunity" and self.party_name: |
| 54 | if self.opportunity_from == "Customer": |
| 55 | customer = self.party_name |
| 56 | else: |
| 57 | lead = self.party_name |
| 58 | elif self.doctype == "Quotation" and self.party_name: |
| 59 | if self.quotation_to == "Customer": |
| 60 | customer = self.party_name |
| 61 | else: |
| 62 | lead = self.party_name |
| 63 | |
| 64 | if customer: |
Anand Doshi | 4362443 | 2014-02-25 15:42:16 +0530 | [diff] [blame] | 65 | from erpnext.accounts.party import _get_party_details |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 66 | |
rohitwaghchaure | 3ffe896 | 2018-07-13 17:40:48 +0530 | [diff] [blame] | 67 | fetch_payment_terms_template = False |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 68 | if self.get("__islocal") or self.company != frappe.db.get_value( |
| 69 | self.doctype, self.name, "company" |
| 70 | ): |
rohitwaghchaure | 3ffe896 | 2018-07-13 17:40:48 +0530 | [diff] [blame] | 71 | fetch_payment_terms_template = True |
| 72 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 73 | party_details = _get_party_details( |
| 74 | customer, |
Nabin Hait | 7eba1a3 | 2017-10-02 15:59:27 +0530 | [diff] [blame] | 75 | ignore_permissions=self.flags.ignore_permissions, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 76 | doctype=self.doctype, |
| 77 | company=self.company, |
| 78 | posting_date=self.get("posting_date"), |
Shreya Shah | 5615cb4 | 2018-10-07 11:42:07 +0530 | [diff] [blame] | 79 | fetch_payment_terms_template=fetch_payment_terms_template, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 80 | party_address=self.customer_address, |
| 81 | shipping_address=self.shipping_address_name, |
| 82 | company_address=self.get("company_address"), |
| 83 | ) |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 84 | if not self.meta.get_field("sales_team"): |
| 85 | party_details.pop("sales_team") |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 86 | self.update_if_missing(party_details) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 87 | |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 88 | elif lead: |
Rushabh Mehta | 60cfccb | 2015-02-17 10:36:54 +0530 | [diff] [blame] | 89 | from erpnext.crm.doctype.lead.lead import get_lead_details |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 90 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 91 | self.update_if_missing( |
| 92 | get_lead_details( |
| 93 | lead, |
| 94 | posting_date=self.get("transaction_date") or self.get("posting_date"), |
| 95 | company=self.company, |
| 96 | ) |
| 97 | ) |
| 98 | |
| 99 | if self.get("taxes_and_charges") and not self.get("taxes") and not for_validate: |
| 100 | taxes = get_taxes_and_charges("Sales Taxes and Charges Template", self.taxes_and_charges) |
Deepesh Garg | 6f3d93e | 2020-09-18 11:23:35 +0530 | [diff] [blame] | 101 | for tax in taxes: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 102 | self.append("taxes", tax) |
Deepesh Garg | 6f3d93e | 2020-09-18 11:23:35 +0530 | [diff] [blame] | 103 | |
mbauskar | 9e9d242 | 2017-04-10 19:16:07 +0530 | [diff] [blame] | 104 | def set_price_list_and_item_details(self, for_validate=False): |
Nabin Hait | 096d363 | 2013-10-17 17:01:14 +0530 | [diff] [blame] | 105 | self.set_price_list_currency("Selling") |
mbauskar | 287fe81 | 2017-04-10 19:15:57 +0530 | [diff] [blame] | 106 | self.set_missing_item_details(for_validate=for_validate) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 107 | |
Anand Doshi | ac32bad | 2014-04-18 01:30:14 +0530 | [diff] [blame] | 108 | def remove_shipping_charge(self): |
| 109 | if self.shipping_rule: |
| 110 | shipping_rule = frappe.get_doc("Shipping Rule", self.shipping_rule) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 111 | existing_shipping_charge = self.get( |
| 112 | "taxes", |
| 113 | { |
| 114 | "doctype": "Sales Taxes and Charges", |
| 115 | "charge_type": "Actual", |
| 116 | "account_head": shipping_rule.account, |
| 117 | "cost_center": shipping_rule.cost_center, |
| 118 | }, |
| 119 | ) |
Anand Doshi | ac32bad | 2014-04-18 01:30:14 +0530 | [diff] [blame] | 120 | if existing_shipping_charge: |
Nabin Hait | e7d1536 | 2014-12-25 16:01:55 +0530 | [diff] [blame] | 121 | self.get("taxes").remove(existing_shipping_charge[-1]) |
Anand Doshi | ac32bad | 2014-04-18 01:30:14 +0530 | [diff] [blame] | 122 | self.calculate_taxes_and_totals() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 123 | |
Nabin Hait | ec52db8 | 2013-01-22 11:53:14 +0530 | [diff] [blame] | 124 | def set_total_in_words(self): |
Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 125 | from frappe.utils import money_in_words |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 126 | |
Nabin Hait | 5690be1 | 2015-02-12 16:09:11 +0530 | [diff] [blame] | 127 | if self.meta.get_field("base_in_words"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 128 | base_amount = abs( |
| 129 | self.base_grand_total if self.is_rounded_total_disabled() else self.base_rounded_total |
| 130 | ) |
Nabin Hait | 877e1bb | 2017-11-17 12:27:43 +0530 | [diff] [blame] | 131 | self.base_in_words = money_in_words(base_amount, self.company_currency) |
| 132 | |
Nabin Hait | ec52db8 | 2013-01-22 11:53:14 +0530 | [diff] [blame] | 133 | if self.meta.get_field("in_words"): |
Nabin Hait | 877e1bb | 2017-11-17 12:27:43 +0530 | [diff] [blame] | 134 | amount = abs(self.grand_total if self.is_rounded_total_disabled() else self.rounded_total) |
| 135 | self.in_words = money_in_words(amount, self.currency) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 136 | |
Anand Doshi | 923d41d | 2013-05-28 17:23:36 +0530 | [diff] [blame] | 137 | def calculate_commission(self): |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 138 | if not self.meta.get_field("commission_rate"): |
| 139 | return |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 140 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 141 | self.round_floats_in(self, ("amount_eligible_for_commission", "commission_rate")) |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 142 | |
| 143 | if not (0 <= self.commission_rate <= 100.0): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 144 | throw( |
| 145 | "{} {}".format( |
| 146 | _(self.meta.get_label("commission_rate")), |
| 147 | _("must be between 0 and 100"), |
| 148 | ) |
| 149 | ) |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 150 | |
| 151 | self.amount_eligible_for_commission = sum( |
| 152 | item.base_net_amount for item in self.items if item.grant_commission |
| 153 | ) |
| 154 | |
| 155 | self.total_commission = flt( |
| 156 | self.amount_eligible_for_commission * self.commission_rate / 100.0, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 157 | self.precision("total_commission"), |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 158 | ) |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 159 | |
| 160 | def calculate_contribution(self): |
Anand Doshi | ac32bad | 2014-04-18 01:30:14 +0530 | [diff] [blame] | 161 | if not self.meta.get_field("sales_team"): |
| 162 | return |
| 163 | |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 164 | total = 0.0 |
Rushabh Mehta | d2b34dc | 2014-03-27 16:12:56 +0530 | [diff] [blame] | 165 | sales_team = self.get("sales_team") |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 166 | for sales_person in sales_team: |
| 167 | self.round_floats_in(sales_person) |
| 168 | |
| 169 | sales_person.allocated_amount = flt( |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 170 | self.amount_eligible_for_commission * sales_person.allocated_percentage / 100.0, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 171 | self.precision("allocated_amount", sales_person), |
| 172 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 173 | |
Anuja Pawar | 8755339 | 2021-03-01 10:44:13 +0530 | [diff] [blame] | 174 | if sales_person.commission_rate: |
| 175 | sales_person.incentives = flt( |
Sagar Vora | f4a6c78 | 2021-03-17 19:57:53 +0530 | [diff] [blame] | 176 | sales_person.allocated_amount * flt(sales_person.commission_rate) / 100.0, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 177 | self.precision("incentives", sales_person), |
| 178 | ) |
Anuja Pawar | 8755339 | 2021-03-01 10:44:13 +0530 | [diff] [blame] | 179 | |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 180 | total += sales_person.allocated_percentage |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 181 | |
Anand Doshi | f309613 | 2013-05-21 19:35:06 +0530 | [diff] [blame] | 182 | if sales_team and total != 100.0: |
Rushabh Mehta | 9f0d625 | 2014-04-14 19:20:45 +0530 | [diff] [blame] | 183 | throw(_("Total allocated percentage for sales team should be 100")) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 184 | |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 185 | def validate_max_discount(self): |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 186 | for d in self.get("items"): |
Nabin Hait | c35271a | 2018-08-10 19:01:04 +0530 | [diff] [blame] | 187 | if d.item_code: |
| 188 | discount = flt(frappe.get_cached_value("Item", d.item_code, "max_discount")) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 189 | |
Nabin Hait | c35271a | 2018-08-10 19:01:04 +0530 | [diff] [blame] | 190 | if discount and flt(d.discount_percentage) > discount: |
| 191 | frappe.throw(_("Maximum discount for Item {0} is {1}%").format(d.item_code, discount)) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 192 | |
Kanchan Chauhan | 5a980ac | 2017-02-10 14:27:11 +0530 | [diff] [blame] | 193 | def set_qty_as_per_stock_uom(self): |
| 194 | for d in self.get("items"): |
| 195 | if d.meta.get_field("stock_qty"): |
| 196 | if not d.conversion_factor: |
| 197 | frappe.throw(_("Row {0}: Conversion Factor is mandatory").format(d.idx)) |
Rushabh Mehta | cc8b2b2 | 2017-03-31 12:44:29 +0530 | [diff] [blame] | 198 | d.stock_qty = flt(d.qty) * flt(d.conversion_factor) |
Kanchan Chauhan | 5a980ac | 2017-02-10 14:27:11 +0530 | [diff] [blame] | 199 | |
shreyas | 1cfe2d7 | 2016-10-19 18:36:12 +0530 | [diff] [blame] | 200 | def validate_selling_price(self): |
Saqib | fff00ce | 2020-05-05 16:14:17 +0530 | [diff] [blame] | 201 | def throw_message(idx, item_name, rate, ref_rate_field): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 202 | throw( |
| 203 | _( |
| 204 | """Row #{0}: Selling rate for item {1} is lower than its {2}. |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 205 | Selling {3} should be atleast {4}.<br><br>Alternatively, |
| 206 | you can disable selling price validation in {5} to bypass |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 207 | this validation.""" |
| 208 | ).format( |
| 209 | idx, |
| 210 | bold(item_name), |
| 211 | bold(ref_rate_field), |
| 212 | bold("net rate"), |
| 213 | bold(rate), |
| 214 | get_link_to_form("Selling Settings", "Selling Settings"), |
| 215 | ), |
| 216 | title=_("Invalid Selling Price"), |
| 217 | ) |
mbauskar | e9747a8 | 2016-11-16 17:19:47 +0530 | [diff] [blame] | 218 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 219 | if self.get("is_return") or not frappe.db.get_single_value( |
| 220 | "Selling Settings", "validate_selling_price" |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 221 | ): |
rohitwaghchaure | 45ac31a | 2018-02-12 11:27:37 +0530 | [diff] [blame] | 222 | return |
| 223 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 224 | is_internal_customer = self.get("is_internal_customer") |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 225 | valuation_rate_map = {} |
| 226 | |
| 227 | for item in self.items: |
Krithi Ramani | 8c536ff | 2022-01-19 15:27:09 +0530 | [diff] [blame] | 228 | if not item.item_code or item.is_free_item: |
Saurabh | d7e1869 | 2017-09-18 15:43:35 +0530 | [diff] [blame] | 229 | continue |
prssanna | b57b3c9 | 2020-10-22 15:37:47 +0530 | [diff] [blame] | 230 | |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 231 | last_purchase_rate, is_stock_item = frappe.get_cached_value( |
| 232 | "Item", item.item_code, ("last_purchase_rate", "is_stock_item") |
| 233 | ) |
shreyas | e8aaa92 | 2016-10-20 14:03:59 +0530 | [diff] [blame] | 234 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 235 | last_purchase_rate_in_sales_uom = last_purchase_rate * (item.conversion_factor or 1) |
shreyas | e8aaa92 | 2016-10-20 14:03:59 +0530 | [diff] [blame] | 236 | |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 237 | if flt(item.base_net_rate) < flt(last_purchase_rate_in_sales_uom): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 238 | throw_message(item.idx, item.item_name, last_purchase_rate_in_sales_uom, "last purchase rate") |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 239 | |
| 240 | if is_internal_customer or not is_stock_item: |
| 241 | continue |
| 242 | |
| 243 | valuation_rate_map[(item.item_code, item.warehouse)] = None |
| 244 | |
| 245 | if not valuation_rate_map: |
| 246 | return |
| 247 | |
| 248 | or_conditions = ( |
| 249 | f"""(item_code = {frappe.db.escape(valuation_rate[0])} |
| 250 | and warehouse = {frappe.db.escape(valuation_rate[1])})""" |
| 251 | for valuation_rate in valuation_rate_map |
| 252 | ) |
| 253 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 254 | valuation_rates = frappe.db.sql( |
| 255 | f""" |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 256 | select |
| 257 | item_code, warehouse, valuation_rate |
| 258 | from |
| 259 | `tabBin` |
| 260 | where |
| 261 | ({" or ".join(or_conditions)}) |
| 262 | and valuation_rate > 0 |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 263 | """, |
| 264 | as_dict=True, |
| 265 | ) |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 266 | |
| 267 | for rate in valuation_rates: |
| 268 | valuation_rate_map[(rate.item_code, rate.warehouse)] = rate.valuation_rate |
| 269 | |
| 270 | for item in self.items: |
Krithi Ramani | 8c536ff | 2022-01-19 15:27:09 +0530 | [diff] [blame] | 271 | if not item.item_code or item.is_free_item: |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 272 | continue |
| 273 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 274 | last_valuation_rate = valuation_rate_map.get((item.item_code, item.warehouse)) |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 275 | |
| 276 | if not last_valuation_rate: |
| 277 | continue |
| 278 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 279 | last_valuation_rate_in_sales_uom = last_valuation_rate * (item.conversion_factor or 1) |
Pruthvi Patel | 7c957d7 | 2021-08-24 21:24:25 +0530 | [diff] [blame] | 280 | |
| 281 | if flt(item.base_net_rate) < flt(last_valuation_rate_in_sales_uom): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 282 | throw_message(item.idx, item.item_name, last_valuation_rate_in_sales_uom, "valuation rate") |
shreyas | 1cfe2d7 | 2016-10-19 18:36:12 +0530 | [diff] [blame] | 283 | |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 284 | def get_item_list(self): |
| 285 | il = [] |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 286 | for d in self.get("items"): |
nathando | 247e9ff | 2014-09-03 15:03:31 +0800 | [diff] [blame] | 287 | if d.qty is None: |
Nabin Hait | c41a948 | 2014-08-18 15:40:15 +0530 | [diff] [blame] | 288 | frappe.throw(_("Row {0}: Qty is mandatory").format(d.idx)) |
Anand Doshi | 01de945 | 2016-01-26 16:22:50 +0530 | [diff] [blame] | 289 | |
Neil Trini Lasrado | ed8cecb | 2015-07-07 13:59:23 +0530 | [diff] [blame] | 290 | if self.has_product_bundle(d.item_code): |
Nabin Hait | e7d1536 | 2014-12-25 16:01:55 +0530 | [diff] [blame] | 291 | for p in self.get("packed_items"): |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 292 | if p.parent_detail_docname == d.name and p.parent_item == d.item_code: |
| 293 | # the packing details table's qty is already multiplied with parent's qty |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 294 | il.append( |
| 295 | frappe._dict( |
| 296 | { |
| 297 | "warehouse": p.warehouse or d.warehouse, |
| 298 | "item_code": p.item_code, |
| 299 | "qty": flt(p.qty), |
| 300 | "uom": p.uom, |
| 301 | "batch_no": cstr(p.batch_no).strip(), |
| 302 | "serial_no": cstr(p.serial_no).strip(), |
| 303 | "name": d.name, |
| 304 | "target_warehouse": p.target_warehouse, |
| 305 | "company": self.company, |
| 306 | "voucher_type": self.doctype, |
| 307 | "allow_zero_valuation": d.allow_zero_valuation_rate, |
| 308 | "sales_invoice_item": d.get("sales_invoice_item"), |
| 309 | "dn_detail": d.get("dn_detail"), |
| 310 | "incoming_rate": p.get("incoming_rate"), |
| 311 | } |
| 312 | ) |
| 313 | ) |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 314 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 315 | il.append( |
| 316 | frappe._dict( |
| 317 | { |
| 318 | "warehouse": d.warehouse, |
| 319 | "item_code": d.item_code, |
| 320 | "qty": d.stock_qty, |
| 321 | "uom": d.uom, |
| 322 | "stock_uom": d.stock_uom, |
| 323 | "conversion_factor": d.conversion_factor, |
| 324 | "batch_no": cstr(d.get("batch_no")).strip(), |
| 325 | "serial_no": cstr(d.get("serial_no")).strip(), |
| 326 | "name": d.name, |
| 327 | "target_warehouse": d.target_warehouse, |
| 328 | "company": self.company, |
| 329 | "voucher_type": self.doctype, |
| 330 | "allow_zero_valuation": d.allow_zero_valuation_rate, |
| 331 | "sales_invoice_item": d.get("sales_invoice_item"), |
| 332 | "dn_detail": d.get("dn_detail"), |
| 333 | "incoming_rate": d.get("incoming_rate"), |
| 334 | } |
| 335 | ) |
| 336 | ) |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 337 | return il |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 338 | |
Neil Trini Lasrado | ed8cecb | 2015-07-07 13:59:23 +0530 | [diff] [blame] | 339 | def has_product_bundle(self, item_code): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 340 | return frappe.db.sql( |
| 341 | """select name from `tabProduct Bundle` |
| 342 | where new_item_code=%s and docstatus != 2""", |
| 343 | item_code, |
| 344 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 345 | |
Nabin Hait | 453cc37 | 2015-07-29 12:21:03 +0530 | [diff] [blame] | 346 | def get_already_delivered_qty(self, current_docname, so, so_detail): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 347 | delivered_via_dn = frappe.db.sql( |
| 348 | """select sum(qty) from `tabDelivery Note Item` |
ankitjavalkarwork | e69a611 | 2014-10-08 12:46:02 +0530 | [diff] [blame] | 349 | where so_detail = %s and docstatus = 1 |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 350 | and against_sales_order = %s |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 351 | and parent != %s""", |
| 352 | (so_detail, so, current_docname), |
| 353 | ) |
Anand Doshi | 01de945 | 2016-01-26 16:22:50 +0530 | [diff] [blame] | 354 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 355 | delivered_via_si = frappe.db.sql( |
| 356 | """select sum(si_item.qty) |
Nabin Hait | 1826791 | 2015-08-17 15:36:23 +0530 | [diff] [blame] | 357 | from `tabSales Invoice Item` si_item, `tabSales Invoice` si |
Anand Doshi | 602e825 | 2015-11-16 19:05:46 +0530 | [diff] [blame] | 358 | where si_item.parent = si.name and si.update_stock = 1 |
Anand Doshi | 01de945 | 2016-01-26 16:22:50 +0530 | [diff] [blame] | 359 | and si_item.so_detail = %s and si.docstatus = 1 |
Nabin Hait | 1826791 | 2015-08-17 15:36:23 +0530 | [diff] [blame] | 360 | and si_item.sales_order = %s |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 361 | and si.name != %s""", |
| 362 | (so_detail, so, current_docname), |
| 363 | ) |
Anand Doshi | 01de945 | 2016-01-26 16:22:50 +0530 | [diff] [blame] | 364 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 365 | total_delivered_qty = (flt(delivered_via_dn[0][0]) if delivered_via_dn else 0) + ( |
| 366 | flt(delivered_via_si[0][0]) if delivered_via_si else 0 |
| 367 | ) |
Anand Doshi | 01de945 | 2016-01-26 16:22:50 +0530 | [diff] [blame] | 368 | |
Nabin Hait | 453cc37 | 2015-07-29 12:21:03 +0530 | [diff] [blame] | 369 | return total_delivered_qty |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 370 | |
| 371 | def get_so_qty_and_warehouse(self, so_detail): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 372 | so_item = frappe.db.sql( |
| 373 | """select qty, warehouse from `tabSales Order Item` |
| 374 | where name = %s and docstatus = 1""", |
| 375 | so_detail, |
| 376 | as_dict=1, |
| 377 | ) |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 378 | so_qty = so_item and flt(so_item[0]["qty"]) or 0.0 |
Nabin Hait | a7f757a | 2014-02-10 17:54:04 +0530 | [diff] [blame] | 379 | so_warehouse = so_item and so_item[0]["warehouse"] or "" |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 380 | return so_qty, so_warehouse |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 381 | |
Mangesh-Khairnar | e17b709 | 2019-03-01 15:52:23 +0530 | [diff] [blame] | 382 | def check_sales_order_on_hold_or_close(self, ref_fieldname): |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 383 | for d in self.get("items"): |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 384 | if d.get(ref_fieldname): |
Rushabh Mehta | f2227d0 | 2014-03-31 23:37:40 +0530 | [diff] [blame] | 385 | status = frappe.db.get_value("Sales Order", d.get(ref_fieldname), "status") |
Mangesh-Khairnar | 86e650c | 2019-03-02 20:30:21 +0530 | [diff] [blame] | 386 | if status in ("Closed", "On Hold"): |
Saurabh | 8a8ef85 | 2015-10-21 19:28:53 +0530 | [diff] [blame] | 387 | frappe.throw(_("Sales Order {0} is {1}").format(d.get(ref_fieldname), status)) |
shreyas | 1cfe2d7 | 2016-10-19 18:36:12 +0530 | [diff] [blame] | 388 | |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 389 | def update_reserved_qty(self): |
| 390 | so_map = {} |
| 391 | for d in self.get("items"): |
| 392 | if d.so_detail: |
| 393 | if self.doctype == "Delivery Note" and d.against_sales_order: |
| 394 | so_map.setdefault(d.against_sales_order, []).append(d.so_detail) |
| 395 | elif self.doctype == "Sales Invoice" and d.sales_order and self.update_stock: |
| 396 | so_map.setdefault(d.sales_order, []).append(d.so_detail) |
| 397 | |
| 398 | for so, so_item_rows in so_map.items(): |
| 399 | if so and so_item_rows: |
| 400 | sales_order = frappe.get_doc("Sales Order", so) |
| 401 | |
| 402 | if sales_order.status in ["Closed", "Cancelled"]: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 403 | frappe.throw( |
| 404 | _("{0} {1} is cancelled or closed").format(_("Sales Order"), so), frappe.InvalidStatusError |
| 405 | ) |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 406 | |
| 407 | sales_order.update_reserved_qty(so_item_rows) |
| 408 | |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 409 | def set_incoming_rate(self): |
rohitwaghchaure | fe4540d | 2021-08-26 12:52:36 +0530 | [diff] [blame] | 410 | if self.doctype not in ("Delivery Note", "Sales Invoice"): |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 411 | return |
| 412 | |
| 413 | items = self.get("items") + (self.get("packed_items") or []) |
| 414 | for d in items: |
rohitwaghchaure | ce6c3b5 | 2021-04-13 20:55:52 +0530 | [diff] [blame] | 415 | if not self.get("return_against"): |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 416 | # Get incoming rate based on original item cost based on valuation method |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 417 | qty = flt(d.get("stock_qty") or d.get("actual_qty")) |
rohitwaghchaure | ce6c3b5 | 2021-04-13 20:55:52 +0530 | [diff] [blame] | 418 | |
Ankush Menat | fcc885b | 2021-12-22 12:38:51 +0530 | [diff] [blame] | 419 | if not (self.get("is_return") and d.incoming_rate): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 420 | d.incoming_rate = get_incoming_rate( |
| 421 | { |
| 422 | "item_code": d.item_code, |
| 423 | "warehouse": d.warehouse, |
| 424 | "posting_date": self.get("posting_date") or self.get("transaction_date"), |
| 425 | "posting_time": self.get("posting_time") or nowtime(), |
| 426 | "qty": qty if cint(self.get("is_return")) else (-1 * qty), |
| 427 | "serial_no": d.get("serial_no"), |
| 428 | "batch_no": d.get("batch_no"), |
| 429 | "company": self.company, |
| 430 | "voucher_type": self.doctype, |
| 431 | "voucher_no": self.name, |
| 432 | "allow_zero_valuation": d.get("allow_zero_valuation"), |
| 433 | }, |
| 434 | raise_error_if_no_rate=False, |
| 435 | ) |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 436 | |
| 437 | # For internal transfers use incoming rate as the valuation rate |
| 438 | if self.is_internal_transfer(): |
Noah Jacob | ac0bc1f | 2021-06-24 19:36:17 +0530 | [diff] [blame] | 439 | if d.doctype == "Packed Item": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 440 | incoming_rate = flt(d.incoming_rate * d.conversion_factor, d.precision("incoming_rate")) |
Noah Jacob | ac0bc1f | 2021-06-24 19:36:17 +0530 | [diff] [blame] | 441 | if d.incoming_rate != incoming_rate: |
| 442 | d.incoming_rate = incoming_rate |
| 443 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 444 | rate = flt(d.incoming_rate * d.conversion_factor, d.precision("rate")) |
Noah Jacob | ac0bc1f | 2021-06-24 19:36:17 +0530 | [diff] [blame] | 445 | if d.rate != rate: |
| 446 | d.rate = rate |
| 447 | |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 448 | d.discount_percentage = 0 |
| 449 | d.discount_amount = 0 |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 450 | frappe.msgprint( |
| 451 | _( |
| 452 | "Row {0}: Item rate has been updated as per valuation rate since its an internal stock transfer" |
| 453 | ).format(d.idx), |
| 454 | alert=1, |
| 455 | ) |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 456 | |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 457 | elif self.get("return_against"): |
| 458 | # Get incoming rate of return entry from reference document |
| 459 | # based on original item cost as per valuation method |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 460 | d.incoming_rate = get_rate_for_return( |
| 461 | self.doctype, self.name, d.item_code, self.return_against, item_row=d |
| 462 | ) |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 463 | |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 464 | def update_stock_ledger(self): |
| 465 | self.update_reserved_qty() |
| 466 | |
| 467 | sl_entries = [] |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 468 | # Loop over items and packed items table |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 469 | for d in self.get_item_list(): |
Himanshu Mishra | 859d942 | 2018-08-08 18:33:50 +0530 | [diff] [blame] | 470 | if frappe.get_cached_value("Item", d.item_code, "is_stock_item") == 1 and flt(d.qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 471 | if flt(d.conversion_factor) == 0.0: |
| 472 | d.conversion_factor = ( |
| 473 | get_conversion_factor(d.item_code, d.uom).get("conversion_factor") or 1.0 |
| 474 | ) |
rohitwaghchaure | 019d4de | 2020-08-20 15:53:58 +0530 | [diff] [blame] | 475 | |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 476 | # On cancellation or return entry submission, make stock ledger entry for |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 477 | # target warehouse first, to update serial no values properly |
| 478 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 479 | if d.warehouse and ( |
| 480 | (not cint(self.is_return) and self.docstatus == 1) |
| 481 | or (cint(self.is_return) and self.docstatus == 2) |
| 482 | ): |
| 483 | sl_entries.append(self.get_sle_for_source_warehouse(d)) |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 484 | |
mergify[bot] | 233bf5d | 2021-10-05 16:16:21 +0530 | [diff] [blame] | 485 | if d.target_warehouse: |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 486 | sl_entries.append(self.get_sle_for_target_warehouse(d)) |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 487 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 488 | if d.warehouse and ( |
| 489 | (not cint(self.is_return) and self.docstatus == 2) |
| 490 | or (cint(self.is_return) and self.docstatus == 1) |
| 491 | ): |
| 492 | sl_entries.append(self.get_sle_for_source_warehouse(d)) |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 493 | |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 494 | self.make_sl_entries(sl_entries) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 495 | |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 496 | def get_sle_for_source_warehouse(self, item_row): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 497 | sle = self.get_sl_entries( |
| 498 | item_row, |
| 499 | { |
| 500 | "actual_qty": -1 * flt(item_row.qty), |
| 501 | "incoming_rate": item_row.incoming_rate, |
| 502 | "recalculate_rate": cint(self.is_return), |
| 503 | }, |
| 504 | ) |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 505 | if item_row.target_warehouse and not cint(self.is_return): |
| 506 | sle.dependant_sle_voucher_detail_no = item_row.name |
| 507 | |
| 508 | return sle |
| 509 | |
| 510 | def get_sle_for_target_warehouse(self, item_row): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 511 | sle = self.get_sl_entries( |
| 512 | item_row, {"actual_qty": flt(item_row.qty), "warehouse": item_row.target_warehouse} |
| 513 | ) |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 514 | |
| 515 | if self.docstatus == 1: |
| 516 | if not cint(self.is_return): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 517 | sle.update({"incoming_rate": item_row.incoming_rate, "recalculate_rate": 1}) |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 518 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 519 | sle.update({"outgoing_rate": item_row.incoming_rate}) |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 520 | if item_row.warehouse: |
| 521 | sle.dependant_sle_voucher_detail_no = item_row.name |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 522 | |
Nabin Hait | a77b8c9 | 2020-12-21 14:45:50 +0530 | [diff] [blame] | 523 | return sle |
| 524 | |
Afshan | 01eca12 | 2020-12-08 09:27:56 +0530 | [diff] [blame] | 525 | def set_po_nos(self, for_validate=False): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 526 | if self.doctype == "Sales Invoice" and hasattr(self, "items"): |
Afshan | 01eca12 | 2020-12-08 09:27:56 +0530 | [diff] [blame] | 527 | if for_validate and self.po_no: |
| 528 | return |
Afshan | 3f971b2 | 2020-10-26 16:59:57 +0530 | [diff] [blame] | 529 | self.set_pos_for_sales_invoice() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 530 | if self.doctype == "Delivery Note" and hasattr(self, "items"): |
Afshan | 01eca12 | 2020-12-08 09:27:56 +0530 | [diff] [blame] | 531 | if for_validate and self.po_no: |
| 532 | return |
Afshan | 3f971b2 | 2020-10-26 16:59:57 +0530 | [diff] [blame] | 533 | self.set_pos_for_delivery_note() |
| 534 | |
| 535 | def set_pos_for_sales_invoice(self): |
Afshan | 0a6e1b3 | 2020-10-26 21:23:31 +0530 | [diff] [blame] | 536 | po_nos = [] |
Afshan | 01eca12 | 2020-12-08 09:27:56 +0530 | [diff] [blame] | 537 | if self.po_no: |
| 538 | po_nos.append(self.po_no) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 539 | self.get_po_nos("Sales Order", "sales_order", po_nos) |
| 540 | self.get_po_nos("Delivery Note", "delivery_note", po_nos) |
| 541 | self.po_no = ", ".join(list(set(x.strip() for x in ",".join(po_nos).split(",")))) |
Afshan | 3f971b2 | 2020-10-26 16:59:57 +0530 | [diff] [blame] | 542 | |
| 543 | def set_pos_for_delivery_note(self): |
Afshan | 0a6e1b3 | 2020-10-26 21:23:31 +0530 | [diff] [blame] | 544 | po_nos = [] |
Afshan | 01eca12 | 2020-12-08 09:27:56 +0530 | [diff] [blame] | 545 | if self.po_no: |
| 546 | po_nos.append(self.po_no) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 547 | self.get_po_nos("Sales Order", "against_sales_order", po_nos) |
| 548 | self.get_po_nos("Sales Invoice", "against_sales_invoice", po_nos) |
| 549 | self.po_no = ", ".join(list(set(x.strip() for x in ",".join(po_nos).split(",")))) |
Afshan | 0a6e1b3 | 2020-10-26 21:23:31 +0530 | [diff] [blame] | 550 | |
| 551 | def get_po_nos(self, ref_doctype, ref_fieldname, po_nos): |
Ankush Menat | 9891780 | 2021-06-11 18:40:22 +0530 | [diff] [blame] | 552 | doc_list = list(set(d.get(ref_fieldname) for d in self.items if d.get(ref_fieldname))) |
Afshan | 0a6e1b3 | 2020-10-26 21:23:31 +0530 | [diff] [blame] | 553 | if doc_list: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 554 | po_nos += [ |
| 555 | d.po_no |
| 556 | for d in frappe.get_all(ref_doctype, "po_no", filters={"name": ("in", doc_list)}) |
| 557 | if d.get("po_no") |
| 558 | ] |
Nabin Hait | 96f4b22 | 2018-03-13 15:46:59 +0530 | [diff] [blame] | 559 | |
Saif Ur Rehman | 5fdbc68 | 2018-11-26 19:32:16 +0500 | [diff] [blame] | 560 | def set_gross_profit(self): |
Abhishek Balam | 18e7b60 | 2020-05-26 18:37:02 +0530 | [diff] [blame] | 561 | if self.doctype in ["Sales Order", "Quotation"]: |
Saif Ur Rehman | 5fdbc68 | 2018-11-26 19:32:16 +0500 | [diff] [blame] | 562 | for item in self.items: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 563 | item.gross_profit = flt( |
| 564 | ((item.base_rate - item.valuation_rate) * item.stock_qty), self.precision("amount", item) |
| 565 | ) |
Saif Ur Rehman | 5fdbc68 | 2018-11-26 19:32:16 +0500 | [diff] [blame] | 566 | |
Rohit Waghchaure | f4dc716 | 2018-11-15 17:04:02 +0530 | [diff] [blame] | 567 | def set_customer_address(self): |
| 568 | address_dict = { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 569 | "customer_address": "address_display", |
| 570 | "shipping_address_name": "shipping_address", |
| 571 | "company_address": "company_address_display", |
Rohit Waghchaure | f4dc716 | 2018-11-15 17:04:02 +0530 | [diff] [blame] | 572 | } |
| 573 | |
| 574 | for address_field, address_display_field in address_dict.items(): |
| 575 | if self.get(address_field): |
| 576 | self.set(address_display_field, get_address_display(self.get(address_field))) |
| 577 | |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 578 | def validate_for_duplicate_items(self): |
| 579 | check_list, chk_dupl_itm = [], [] |
| 580 | if cint(frappe.db.get_single_value("Selling Settings", "allow_multiple_items")): |
| 581 | return |
Saqib | 0681a48 | 2021-02-11 14:06:15 +0530 | [diff] [blame] | 582 | if self.doctype == "Sales Invoice" and self.is_consolidated: |
| 583 | return |
| 584 | if self.doctype == "POS Invoice": |
| 585 | return |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 586 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 587 | for d in self.get("items"): |
Saqib | 0681a48 | 2021-02-11 14:06:15 +0530 | [diff] [blame] | 588 | if self.doctype == "Sales Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 589 | stock_items = [ |
| 590 | d.item_code, |
| 591 | d.description, |
| 592 | d.warehouse, |
| 593 | d.sales_order or d.delivery_note, |
| 594 | d.batch_no or "", |
| 595 | ] |
Jannat Patel | c1187bc | 2020-11-19 13:10:24 +0530 | [diff] [blame] | 596 | non_stock_items = [d.item_code, d.description, d.sales_order or d.delivery_note] |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 597 | elif self.doctype == "Delivery Note": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 598 | stock_items = [ |
| 599 | d.item_code, |
| 600 | d.description, |
| 601 | d.warehouse, |
| 602 | d.against_sales_order or d.against_sales_invoice, |
| 603 | d.batch_no or "", |
| 604 | ] |
| 605 | non_stock_items = [ |
| 606 | d.item_code, |
| 607 | d.description, |
| 608 | d.against_sales_order or d.against_sales_invoice, |
| 609 | ] |
Rohit Waghchaure | 13c7e18 | 2019-08-29 19:45:19 +0530 | [diff] [blame] | 610 | elif self.doctype in ["Sales Order", "Quotation"]: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 611 | stock_items = [d.item_code, d.description, d.warehouse, ""] |
Jannat Patel | c1187bc | 2020-11-19 13:10:24 +0530 | [diff] [blame] | 612 | non_stock_items = [d.item_code, d.description] |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 613 | |
| 614 | if frappe.db.get_value("Item", d.item_code, "is_stock_item") == 1: |
Saqib | ac9e6ff | 2021-01-28 17:58:55 +0530 | [diff] [blame] | 615 | duplicate_items_msg = _("Item {0} entered multiple times.").format(frappe.bold(d.item_code)) |
| 616 | duplicate_items_msg += "<br><br>" |
| 617 | duplicate_items_msg += _("Please enable {} in {} to allow same item in multiple rows").format( |
| 618 | frappe.bold("Allow Item to Be Added Multiple Times in a Transaction"), |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 619 | get_link_to_form("Selling Settings", "Selling Settings"), |
Saqib | ac9e6ff | 2021-01-28 17:58:55 +0530 | [diff] [blame] | 620 | ) |
Jannat Patel | c1187bc | 2020-11-19 13:10:24 +0530 | [diff] [blame] | 621 | if stock_items in check_list: |
Saqib | ac9e6ff | 2021-01-28 17:58:55 +0530 | [diff] [blame] | 622 | frappe.throw(duplicate_items_msg) |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 623 | else: |
Jannat Patel | c1187bc | 2020-11-19 13:10:24 +0530 | [diff] [blame] | 624 | check_list.append(stock_items) |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 625 | else: |
Jannat Patel | c1187bc | 2020-11-19 13:10:24 +0530 | [diff] [blame] | 626 | if non_stock_items in chk_dupl_itm: |
Saqib | ac9e6ff | 2021-01-28 17:58:55 +0530 | [diff] [blame] | 627 | frappe.throw(duplicate_items_msg) |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 628 | else: |
Jannat Patel | c1187bc | 2020-11-19 13:10:24 +0530 | [diff] [blame] | 629 | chk_dupl_itm.append(non_stock_items) |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 630 | |
rohitwaghchaure | 6fa6caf | 2020-04-23 09:46:29 +0530 | [diff] [blame] | 631 | def validate_target_warehouse(self): |
| 632 | items = self.get("items") + (self.get("packed_items") or []) |
| 633 | |
| 634 | for d in items: |
| 635 | if d.get("target_warehouse") and d.get("warehouse") == d.get("target_warehouse"): |
| 636 | warehouse = frappe.bold(d.get("target_warehouse")) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 637 | frappe.throw( |
| 638 | _("Row {0}: Delivery Warehouse ({1}) and Customer Warehouse ({2}) can not be same").format( |
| 639 | d.idx, warehouse, warehouse |
| 640 | ) |
| 641 | ) |
Deepesh Garg | f3d78dd | 2019-08-23 11:42:35 +0530 | [diff] [blame] | 642 | |
mergify[bot] | 233bf5d | 2021-10-05 16:16:21 +0530 | [diff] [blame] | 643 | if not self.get("is_internal_customer") and any(d.get("target_warehouse") for d in items): |
| 644 | msg = _("Target Warehouse is set for some items but the customer is not an internal customer.") |
| 645 | msg += " " + _("This {} will be treated as material transfer.").format(_(self.doctype)) |
| 646 | frappe.msgprint(msg, title="Internal Transfer", alert=True) |
| 647 | |
Zarrar | fc03a04 | 2018-06-04 12:52:52 +0530 | [diff] [blame] | 648 | def validate_items(self): |
| 649 | # validate items to see if they have is_sales_item enabled |
| 650 | from erpnext.controllers.buying_controller import validate_item_type |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 651 | |
Zarrar | fc03a04 | 2018-06-04 12:52:52 +0530 | [diff] [blame] | 652 | validate_item_type(self, "is_sales_item", "sales") |
| 653 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 654 | |
Rushabh Mehta | 708e47a | 2018-08-08 16:37:31 +0530 | [diff] [blame] | 655 | def set_default_income_account_for_item(obj): |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 656 | for d in obj.get("items"): |
Nabin Hait | d1fd1e2 | 2013-10-18 12:29:11 +0530 | [diff] [blame] | 657 | if d.item_code: |
Manas Solanki | 5b93562 | 2018-05-16 17:44:51 +0530 | [diff] [blame] | 658 | if getattr(d, "income_account", None): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 659 | set_item_default(d.item_code, obj.company, "income_account", d.income_account) |