blob: 60ba0d1bca0dd7181544cd4b80bfe886eb860014 [file] [log] [blame]
Anand Doshi885e0742015-03-03 14:55:30 +05301# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
Rushabh Mehtae67d1fb2013-08-05 14:59:54 +05302# License: GNU General Public License v3. See license.txt
Nabin Haitec52db82013-01-22 11:53:14 +05303
Nabin Haitec52db82013-01-22 11:53:14 +05304
Chillar Anand915b3432021-09-02 16:44:59 +05305import frappe
6from frappe import _, bold, throw
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05307from frappe.utils import cint, flt, get_link_to_form, nowtime
Chillar Anand915b3432021-09-02 16:44:59 +05308
Ankush Menatf4d74992023-10-17 22:11:56 +05309from erpnext.accounts.party import render_address
Chillar Anand915b3432021-09-02 16:44:59 +053010from erpnext.controllers.accounts_controller import get_taxes_and_charges
Nabin Haita77b8c92020-12-21 14:45:50 +053011from erpnext.controllers.sales_and_purchase_return import get_rate_for_return
Chillar Anand915b3432021-09-02 16:44:59 +053012from erpnext.controllers.stock_controller import StockController
13from erpnext.stock.doctype.item.item import set_item_default
14from erpnext.stock.get_item_details import get_bin_details, get_conversion_factor
mergify[bot]40576822023-12-19 18:29:56 +053015from erpnext.stock.utils import get_incoming_rate, get_valuation_method
Chillar Anand915b3432021-09-02 16:44:59 +053016
Nabin Haitbf495c92013-01-30 12:49:08 +053017
Nabin Haitc3afb252013-03-19 12:01:24 +053018class SellingController(StockController):
Nabin Hait993c6c02022-04-12 12:24:47 +053019 def __setup__(self):
20 self.flags.ignore_permlevel_for_fields = ["selling_price_list", "price_list_currency"]
21
Rushabh Mehtab5e76892014-07-29 16:07:43 +053022 def onload(self):
Akhil Narang3effaf22024-03-27 11:37:26 +053023 super().onload()
Rushabh Mehtab5e76892014-07-29 16:07:43 +053024 if self.doctype in ("Sales Order", "Delivery Note", "Sales Invoice"):
Rohit Waghchaure02566a02023-01-20 22:38:56 +053025 for item in self.get("items") + (self.get("packed_items") or []):
s-aga-rc716dcc2022-12-29 12:34:18 +053026 item.update(get_bin_details(item.item_code, item.warehouse, include_child_warehouses=True))
Rushabh Mehtab5e76892014-07-29 16:07:43 +053027
Nabin Haitd1fd1e22013-10-18 12:29:11 +053028 def validate(self):
Akhil Narang3effaf22024-03-27 11:37:26 +053029 super().validate()
Zarrarfc03a042018-06-04 12:52:52 +053030 self.validate_items()
Gursheen Anand5a3b1332024-02-22 16:08:11 +053031 if not self.get("is_debit_note"):
32 self.validate_max_discount()
shreyas1cfe2d72016-10-19 18:36:12 +053033 self.validate_selling_price()
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +053034 self.set_qty_as_per_stock_uom()
Afshan01eca122020-12-08 09:27:56 +053035 self.set_po_nos(for_validate=True)
Saif Ur Rehman5fdbc682018-11-26 19:32:16 +050036 self.set_gross_profit()
Rushabh Mehta708e47a2018-08-08 16:37:31 +053037 set_default_income_account_for_item(self)
Rohit Waghchauref4dc7162018-11-15 17:04:02 +053038 self.set_customer_address()
Deepesh Gargf3d78dd2019-08-23 11:42:35 +053039 self.validate_for_duplicate_items()
rohitwaghchaure6fa6caf2020-04-23 09:46:29 +053040 self.validate_target_warehouse()
Deepesh Gargfa152212022-11-28 19:22:35 +053041 self.validate_auto_repeat_subscription_dates()
Rohit Waghchaure674bd3e2023-03-17 16:42:59 +053042 for table_field in ["items", "packed_items"]:
43 if self.get(table_field):
44 self.set_serial_and_batch_bundle(table_field)
Anand Doshid2946502014-04-08 20:10:03 +053045
Anand Doshif3096132013-05-21 19:35:06 +053046 def set_missing_values(self, for_validate=False):
Akhil Narang3effaf22024-03-27 11:37:26 +053047 super().set_missing_values(for_validate)
Anand Doshid2946502014-04-08 20:10:03 +053048
Anand Doshif3096132013-05-21 19:35:06 +053049 # set contact and address details for customer, if they are not mentioned
Deepesh Garg6f3d93e2020-09-18 11:23:35 +053050 self.set_missing_lead_customer_details(for_validate=for_validate)
mbauskar9e9d2422017-04-10 19:16:07 +053051 self.set_price_list_and_item_details(for_validate=for_validate)
Anand Doshid2946502014-04-08 20:10:03 +053052
Deepesh Garg6f3d93e2020-09-18 11:23:35 +053053 def set_missing_lead_customer_details(self, for_validate=False):
Nabin Hait34c551d2019-07-03 10:34:31 +053054 customer, lead = None, None
Rushabh Mehtaf14b8092014-04-03 14:30:42 +053055 if getattr(self, "customer", None):
Nabin Hait34c551d2019-07-03 10:34:31 +053056 customer = self.customer
57 elif self.doctype == "Opportunity" and self.party_name:
58 if self.opportunity_from == "Customer":
59 customer = self.party_name
60 else:
61 lead = self.party_name
62 elif self.doctype == "Quotation" and self.party_name:
63 if self.quotation_to == "Customer":
64 customer = self.party_name
Nabin Hait5a0aacc2023-06-06 15:39:22 +053065 elif self.quotation_to == "Lead":
Nabin Hait34c551d2019-07-03 10:34:31 +053066 lead = self.party_name
67
68 if customer:
Anand Doshi43624432014-02-25 15:42:16 +053069 from erpnext.accounts.party import _get_party_details
Ankush Menat494bd9e2022-03-28 18:52:46 +053070
rohitwaghchaure3ffe8962018-07-13 17:40:48 +053071 fetch_payment_terms_template = False
Ankush Menat494bd9e2022-03-28 18:52:46 +053072 if self.get("__islocal") or self.company != frappe.db.get_value(
73 self.doctype, self.name, "company"
74 ):
rohitwaghchaure3ffe8962018-07-13 17:40:48 +053075 fetch_payment_terms_template = True
76
Ankush Menat494bd9e2022-03-28 18:52:46 +053077 party_details = _get_party_details(
78 customer,
Nabin Hait7eba1a32017-10-02 15:59:27 +053079 ignore_permissions=self.flags.ignore_permissions,
Ankush Menat494bd9e2022-03-28 18:52:46 +053080 doctype=self.doctype,
81 company=self.company,
82 posting_date=self.get("posting_date"),
Shreya Shah5615cb42018-10-07 11:42:07 +053083 fetch_payment_terms_template=fetch_payment_terms_template,
Ankush Menat494bd9e2022-03-28 18:52:46 +053084 party_address=self.customer_address,
85 shipping_address=self.shipping_address_name,
86 company_address=self.get("company_address"),
87 )
Nabin Hait6b039142014-05-02 15:45:10 +053088 if not self.meta.get_field("sales_team"):
89 party_details.pop("sales_team")
Nabin Hait6b039142014-05-02 15:45:10 +053090 self.update_if_missing(party_details)
Anand Doshid2946502014-04-08 20:10:03 +053091
Nabin Hait34c551d2019-07-03 10:34:31 +053092 elif lead:
Rushabh Mehta60cfccb2015-02-17 10:36:54 +053093 from erpnext.crm.doctype.lead.lead import get_lead_details
Anand Doshid2946502014-04-08 20:10:03 +053094
Ankush Menat494bd9e2022-03-28 18:52:46 +053095 self.update_if_missing(
96 get_lead_details(
97 lead,
98 posting_date=self.get("transaction_date") or self.get("posting_date"),
99 company=self.company,
100 )
101 )
102
103 if self.get("taxes_and_charges") and not self.get("taxes") and not for_validate:
104 taxes = get_taxes_and_charges("Sales Taxes and Charges Template", self.taxes_and_charges)
Deepesh Garg6f3d93e2020-09-18 11:23:35 +0530105 for tax in taxes:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530106 self.append("taxes", tax)
Deepesh Garg6f3d93e2020-09-18 11:23:35 +0530107
mbauskar9e9d2422017-04-10 19:16:07 +0530108 def set_price_list_and_item_details(self, for_validate=False):
Nabin Hait096d3632013-10-17 17:01:14 +0530109 self.set_price_list_currency("Selling")
mbauskar287fe812017-04-10 19:15:57 +0530110 self.set_missing_item_details(for_validate=for_validate)
Anand Doshid2946502014-04-08 20:10:03 +0530111
Anand Doshiac32bad2014-04-18 01:30:14 +0530112 def remove_shipping_charge(self):
113 if self.shipping_rule:
114 shipping_rule = frappe.get_doc("Shipping Rule", self.shipping_rule)
Ankush Menat494bd9e2022-03-28 18:52:46 +0530115 existing_shipping_charge = self.get(
116 "taxes",
117 {
118 "doctype": "Sales Taxes and Charges",
119 "charge_type": "Actual",
120 "account_head": shipping_rule.account,
121 "cost_center": shipping_rule.cost_center,
122 },
123 )
Anand Doshiac32bad2014-04-18 01:30:14 +0530124 if existing_shipping_charge:
Nabin Haite7d15362014-12-25 16:01:55 +0530125 self.get("taxes").remove(existing_shipping_charge[-1])
Anand Doshiac32bad2014-04-18 01:30:14 +0530126 self.calculate_taxes_and_totals()
Anand Doshid2946502014-04-08 20:10:03 +0530127
Nabin Haitec52db82013-01-22 11:53:14 +0530128 def set_total_in_words(self):
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530129 from frappe.utils import money_in_words
Anand Doshid2946502014-04-08 20:10:03 +0530130
Nabin Hait5690be12015-02-12 16:09:11 +0530131 if self.meta.get_field("base_in_words"):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530132 base_amount = abs(
133 self.base_grand_total if self.is_rounded_total_disabled() else self.base_rounded_total
134 )
Nabin Hait877e1bb2017-11-17 12:27:43 +0530135 self.base_in_words = money_in_words(base_amount, self.company_currency)
136
Nabin Haitec52db82013-01-22 11:53:14 +0530137 if self.meta.get_field("in_words"):
Nabin Hait877e1bb2017-11-17 12:27:43 +0530138 amount = abs(self.grand_total if self.is_rounded_total_disabled() else self.rounded_total)
139 self.in_words = money_in_words(amount, self.currency)
Anand Doshid2946502014-04-08 20:10:03 +0530140
Anand Doshi923d41d2013-05-28 17:23:36 +0530141 def calculate_commission(self):
Deepesh Gargf76da502024-03-29 17:57:58 +0530142 if not self.meta.get_field("commission_rate"):
Raffael Meyere10ab162021-11-30 13:24:18 +0100143 return
Anand Doshid2946502014-04-08 20:10:03 +0530144
Ankush Menat494bd9e2022-03-28 18:52:46 +0530145 self.round_floats_in(self, ("amount_eligible_for_commission", "commission_rate"))
Raffael Meyere10ab162021-11-30 13:24:18 +0100146
147 if not (0 <= self.commission_rate <= 100.0):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530148 throw(
149 "{} {}".format(
150 _(self.meta.get_label("commission_rate")),
151 _("must be between 0 and 100"),
152 )
153 )
Raffael Meyere10ab162021-11-30 13:24:18 +0100154
155 self.amount_eligible_for_commission = sum(
156 item.base_net_amount for item in self.items if item.grant_commission
157 )
158
159 self.total_commission = flt(
160 self.amount_eligible_for_commission * self.commission_rate / 100.0,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530161 self.precision("total_commission"),
Raffael Meyere10ab162021-11-30 13:24:18 +0100162 )
Anand Doshif3096132013-05-21 19:35:06 +0530163
164 def calculate_contribution(self):
Anand Doshiac32bad2014-04-18 01:30:14 +0530165 if not self.meta.get_field("sales_team"):
166 return
167
Anand Doshif3096132013-05-21 19:35:06 +0530168 total = 0.0
Rushabh Mehtad2b34dc2014-03-27 16:12:56 +0530169 sales_team = self.get("sales_team")
Anand Doshif3096132013-05-21 19:35:06 +0530170 for sales_person in sales_team:
171 self.round_floats_in(sales_person)
172
173 sales_person.allocated_amount = flt(
Indrajith.vs0c8276e2023-05-14 11:47:46 +0530174 flt(self.amount_eligible_for_commission) * sales_person.allocated_percentage / 100.0,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530175 self.precision("allocated_amount", sales_person),
176 )
Anand Doshid2946502014-04-08 20:10:03 +0530177
Anuja Pawar87553392021-03-01 10:44:13 +0530178 if sales_person.commission_rate:
179 sales_person.incentives = flt(
Sagar Voraf4a6c782021-03-17 19:57:53 +0530180 sales_person.allocated_amount * flt(sales_person.commission_rate) / 100.0,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530181 self.precision("incentives", sales_person),
182 )
Anuja Pawar87553392021-03-01 10:44:13 +0530183
Anand Doshif3096132013-05-21 19:35:06 +0530184 total += sales_person.allocated_percentage
Anand Doshid2946502014-04-08 20:10:03 +0530185
Anand Doshif3096132013-05-21 19:35:06 +0530186 if sales_team and total != 100.0:
Rushabh Mehta9f0d6252014-04-14 19:20:45 +0530187 throw(_("Total allocated percentage for sales team should be 100"))
Anand Doshid2946502014-04-08 20:10:03 +0530188
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530189 def validate_max_discount(self):
Nabin Haitdd38a262014-12-26 13:15:21 +0530190 for d in self.get("items"):
Nabin Haitc35271a2018-08-10 19:01:04 +0530191 if d.item_code:
192 discount = flt(frappe.get_cached_value("Item", d.item_code, "max_discount"))
Anand Doshid2946502014-04-08 20:10:03 +0530193
Nabin Haitc35271a2018-08-10 19:01:04 +0530194 if discount and flt(d.discount_percentage) > discount:
195 frappe.throw(_("Maximum discount for Item {0} is {1}%").format(d.item_code, discount))
Anand Doshid2946502014-04-08 20:10:03 +0530196
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +0530197 def set_qty_as_per_stock_uom(self):
rohitwaghchauredd4769e2023-09-20 18:09:03 +0530198 allow_to_edit_stock_qty = frappe.db.get_single_value(
199 "Stock Settings", "allow_to_edit_stock_uom_qty_for_sales"
200 )
201
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +0530202 for d in self.get("items"):
203 if d.meta.get_field("stock_qty"):
204 if not d.conversion_factor:
205 frappe.throw(_("Row {0}: Conversion Factor is mandatory").format(d.idx))
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +0530206 d.stock_qty = flt(d.qty) * flt(d.conversion_factor)
rohitwaghchauredd4769e2023-09-20 18:09:03 +0530207 if allow_to_edit_stock_qty:
208 d.stock_qty = flt(d.stock_qty, d.precision("stock_qty"))
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +0530209
shreyas1cfe2d72016-10-19 18:36:12 +0530210 def validate_selling_price(self):
Saqibfff00ce2020-05-05 16:14:17 +0530211 def throw_message(idx, item_name, rate, ref_rate_field):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530212 throw(
213 _(
214 """Row #{0}: Selling rate for item {1} is lower than its {2}.
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530215 Selling {3} should be atleast {4}.<br><br>Alternatively,
216 you can disable selling price validation in {5} to bypass
Ankush Menat494bd9e2022-03-28 18:52:46 +0530217 this validation."""
218 ).format(
219 idx,
220 bold(item_name),
221 bold(ref_rate_field),
222 bold("net rate"),
223 bold(rate),
224 get_link_to_form("Selling Settings", "Selling Settings"),
225 ),
226 title=_("Invalid Selling Price"),
227 )
mbauskare9747a82016-11-16 17:19:47 +0530228
Ankush Menat494bd9e2022-03-28 18:52:46 +0530229 if self.get("is_return") or not frappe.db.get_single_value(
230 "Selling Settings", "validate_selling_price"
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530231 ):
rohitwaghchaure45ac31a2018-02-12 11:27:37 +0530232 return
233
Ankush Menat494bd9e2022-03-28 18:52:46 +0530234 is_internal_customer = self.get("is_internal_customer")
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530235 valuation_rate_map = {}
236
237 for item in self.items:
Krithi Ramani8c536ff2022-01-19 15:27:09 +0530238 if not item.item_code or item.is_free_item:
Saurabhd7e18692017-09-18 15:43:35 +0530239 continue
prssannab57b3c92020-10-22 15:37:47 +0530240
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530241 last_purchase_rate, is_stock_item = frappe.get_cached_value(
242 "Item", item.item_code, ("last_purchase_rate", "is_stock_item")
243 )
shreyase8aaa922016-10-20 14:03:59 +0530244
Ankush Menat494bd9e2022-03-28 18:52:46 +0530245 last_purchase_rate_in_sales_uom = last_purchase_rate * (item.conversion_factor or 1)
shreyase8aaa922016-10-20 14:03:59 +0530246
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530247 if flt(item.base_net_rate) < flt(last_purchase_rate_in_sales_uom):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530248 throw_message(item.idx, item.item_name, last_purchase_rate_in_sales_uom, "last purchase rate")
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530249
250 if is_internal_customer or not is_stock_item:
251 continue
252
253 valuation_rate_map[(item.item_code, item.warehouse)] = None
254
255 if not valuation_rate_map:
256 return
257
258 or_conditions = (
259 f"""(item_code = {frappe.db.escape(valuation_rate[0])}
260 and warehouse = {frappe.db.escape(valuation_rate[1])})"""
261 for valuation_rate in valuation_rate_map
262 )
263
Ankush Menat494bd9e2022-03-28 18:52:46 +0530264 valuation_rates = frappe.db.sql(
265 f"""
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530266 select
267 item_code, warehouse, valuation_rate
268 from
269 `tabBin`
270 where
271 ({" or ".join(or_conditions)})
272 and valuation_rate > 0
Ankush Menat494bd9e2022-03-28 18:52:46 +0530273 """,
274 as_dict=True,
275 )
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530276
277 for rate in valuation_rates:
278 valuation_rate_map[(rate.item_code, rate.warehouse)] = rate.valuation_rate
279
280 for item in self.items:
Krithi Ramani8c536ff2022-01-19 15:27:09 +0530281 if not item.item_code or item.is_free_item:
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530282 continue
283
Ankush Menat494bd9e2022-03-28 18:52:46 +0530284 last_valuation_rate = valuation_rate_map.get((item.item_code, item.warehouse))
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530285
286 if not last_valuation_rate:
287 continue
288
Ankush Menat494bd9e2022-03-28 18:52:46 +0530289 last_valuation_rate_in_sales_uom = last_valuation_rate * (item.conversion_factor or 1)
Pruthvi Patel7c957d72021-08-24 21:24:25 +0530290
291 if flt(item.base_net_rate) < flt(last_valuation_rate_in_sales_uom):
mergify[bot]d2aa4d52023-10-05 18:13:23 +0530292 throw_message(
Akhil Narang3effaf22024-03-27 11:37:26 +0530293 item.idx,
294 item.item_name,
295 last_valuation_rate_in_sales_uom,
296 "valuation rate (Moving Average)",
mergify[bot]d2aa4d52023-10-05 18:13:23 +0530297 )
shreyas1cfe2d72016-10-19 18:36:12 +0530298
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530299 def get_item_list(self):
300 il = []
Nabin Haitdd38a262014-12-26 13:15:21 +0530301 for d in self.get("items"):
Neil Trini Lasradoed8cecb2015-07-07 13:59:23 +0530302 if self.has_product_bundle(d.item_code):
Nabin Haite7d15362014-12-25 16:01:55 +0530303 for p in self.get("packed_items"):
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530304 if p.parent_detail_docname == d.name and p.parent_item == d.item_code:
305 # the packing details table's qty is already multiplied with parent's qty
Ankush Menat494bd9e2022-03-28 18:52:46 +0530306 il.append(
307 frappe._dict(
308 {
309 "warehouse": p.warehouse or d.warehouse,
310 "item_code": p.item_code,
311 "qty": flt(p.qty),
rohitwaghchaure07432892023-12-17 12:42:07 +0530312 "serial_no": p.serial_no if self.docstatus == 2 else None,
313 "batch_no": p.batch_no if self.docstatus == 2 else None,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530314 "uom": p.uom,
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530315 "serial_and_batch_bundle": p.serial_and_batch_bundle
316 or get_serial_and_batch_bundle(p, self),
Ankush Menat494bd9e2022-03-28 18:52:46 +0530317 "name": d.name,
318 "target_warehouse": p.target_warehouse,
319 "company": self.company,
320 "voucher_type": self.doctype,
321 "allow_zero_valuation": d.allow_zero_valuation_rate,
322 "sales_invoice_item": d.get("sales_invoice_item"),
323 "dn_detail": d.get("dn_detail"),
324 "incoming_rate": p.get("incoming_rate"),
Rohit Waghchaure23729992022-09-02 18:43:55 +0530325 "item_row": p,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530326 }
327 )
328 )
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530329 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530330 il.append(
331 frappe._dict(
332 {
333 "warehouse": d.warehouse,
334 "item_code": d.item_code,
335 "qty": d.stock_qty,
rohitwaghchaure07432892023-12-17 12:42:07 +0530336 "serial_no": d.serial_no if self.docstatus == 2 else None,
337 "batch_no": d.batch_no if self.docstatus == 2 else None,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530338 "uom": d.uom,
339 "stock_uom": d.stock_uom,
340 "conversion_factor": d.conversion_factor,
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +0530341 "serial_and_batch_bundle": d.serial_and_batch_bundle,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530342 "name": d.name,
343 "target_warehouse": d.target_warehouse,
344 "company": self.company,
345 "voucher_type": self.doctype,
346 "allow_zero_valuation": d.allow_zero_valuation_rate,
347 "sales_invoice_item": d.get("sales_invoice_item"),
348 "dn_detail": d.get("dn_detail"),
349 "incoming_rate": d.get("incoming_rate"),
Rohit Waghchaure23729992022-09-02 18:43:55 +0530350 "item_row": d,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530351 }
352 )
353 )
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530354
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530355 return il
Anand Doshid2946502014-04-08 20:10:03 +0530356
Neil Trini Lasradoed8cecb2015-07-07 13:59:23 +0530357 def has_product_bundle(self, item_code):
Gursheen Anand16573372023-11-22 16:45:14 +0530358 product_bundle = frappe.qb.DocType("Product Bundle")
359 return (
360 frappe.qb.from_(product_bundle)
361 .select(product_bundle.name)
362 .where((product_bundle.new_item_code == item_code) & (product_bundle.disabled == 0))
363 ).run()
Anand Doshid2946502014-04-08 20:10:03 +0530364
Nabin Hait453cc372015-07-29 12:21:03 +0530365 def get_already_delivered_qty(self, current_docname, so, so_detail):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530366 delivered_via_dn = frappe.db.sql(
367 """select sum(qty) from `tabDelivery Note Item`
ankitjavalkarworke69a6112014-10-08 12:46:02 +0530368 where so_detail = %s and docstatus = 1
Anand Doshid2946502014-04-08 20:10:03 +0530369 and against_sales_order = %s
Ankush Menat494bd9e2022-03-28 18:52:46 +0530370 and parent != %s""",
371 (so_detail, so, current_docname),
372 )
Anand Doshi01de9452016-01-26 16:22:50 +0530373
Ankush Menat494bd9e2022-03-28 18:52:46 +0530374 delivered_via_si = frappe.db.sql(
375 """select sum(si_item.qty)
Nabin Hait18267912015-08-17 15:36:23 +0530376 from `tabSales Invoice Item` si_item, `tabSales Invoice` si
Anand Doshi602e8252015-11-16 19:05:46 +0530377 where si_item.parent = si.name and si.update_stock = 1
Anand Doshi01de9452016-01-26 16:22:50 +0530378 and si_item.so_detail = %s and si.docstatus = 1
Nabin Hait18267912015-08-17 15:36:23 +0530379 and si_item.sales_order = %s
Ankush Menat494bd9e2022-03-28 18:52:46 +0530380 and si.name != %s""",
381 (so_detail, so, current_docname),
382 )
Anand Doshi01de9452016-01-26 16:22:50 +0530383
Ankush Menat494bd9e2022-03-28 18:52:46 +0530384 total_delivered_qty = (flt(delivered_via_dn[0][0]) if delivered_via_dn else 0) + (
385 flt(delivered_via_si[0][0]) if delivered_via_si else 0
386 )
Anand Doshi01de9452016-01-26 16:22:50 +0530387
Nabin Hait453cc372015-07-29 12:21:03 +0530388 return total_delivered_qty
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530389
390 def get_so_qty_and_warehouse(self, so_detail):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530391 so_item = frappe.db.sql(
392 """select qty, warehouse from `tabSales Order Item`
393 where name = %s and docstatus = 1""",
394 so_detail,
395 as_dict=1,
396 )
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530397 so_qty = so_item and flt(so_item[0]["qty"]) or 0.0
Nabin Haita7f757a2014-02-10 17:54:04 +0530398 so_warehouse = so_item and so_item[0]["warehouse"] or ""
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530399 return so_qty, so_warehouse
Anand Doshid2946502014-04-08 20:10:03 +0530400
Mangesh-Khairnare17b7092019-03-01 15:52:23 +0530401 def check_sales_order_on_hold_or_close(self, ref_fieldname):
Nabin Haitdd38a262014-12-26 13:15:21 +0530402 for d in self.get("items"):
Anand Doshif78d1ae2014-03-28 13:55:00 +0530403 if d.get(ref_fieldname):
Rushabh Mehtaf2227d02014-03-31 23:37:40 +0530404 status = frappe.db.get_value("Sales Order", d.get(ref_fieldname), "status")
mergify[bot]35f72a12023-08-26 19:29:33 +0530405 if status in ("Closed", "On Hold") and not self.is_return:
Saurabh8a8ef852015-10-21 19:28:53 +0530406 frappe.throw(_("Sales Order {0} is {1}").format(d.get(ref_fieldname), status))
shreyas1cfe2d72016-10-19 18:36:12 +0530407
Nabin Hait14aa9c52016-04-18 15:54:01 +0530408 def update_reserved_qty(self):
409 so_map = {}
410 for d in self.get("items"):
411 if d.so_detail:
412 if self.doctype == "Delivery Note" and d.against_sales_order:
413 so_map.setdefault(d.against_sales_order, []).append(d.so_detail)
414 elif self.doctype == "Sales Invoice" and d.sales_order and self.update_stock:
415 so_map.setdefault(d.sales_order, []).append(d.so_detail)
416
417 for so, so_item_rows in so_map.items():
418 if so and so_item_rows:
419 sales_order = frappe.get_doc("Sales Order", so)
420
mergify[bot]35f72a12023-08-26 19:29:33 +0530421 if (sales_order.status == "Closed" and not self.is_return) or sales_order.status in [
422 "Cancelled"
423 ]:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530424 frappe.throw(
Akhil Narang3effaf22024-03-27 11:37:26 +0530425 _("{0} {1} is cancelled or closed").format(_("Sales Order"), so),
426 frappe.InvalidStatusError,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530427 )
Nabin Hait14aa9c52016-04-18 15:54:01 +0530428
429 sales_order.update_reserved_qty(so_item_rows)
430
Nabin Haita77b8c92020-12-21 14:45:50 +0530431 def set_incoming_rate(self):
rohitwaghchaurefe4540d2021-08-26 12:52:36 +0530432 if self.doctype not in ("Delivery Note", "Sales Invoice"):
Nabin Haita77b8c92020-12-21 14:45:50 +0530433 return
434
435 items = self.get("items") + (self.get("packed_items") or [])
436 for d in items:
s-aga-re1b0fff2024-01-04 11:43:02 +0530437 if not frappe.get_cached_value("Item", d.item_code, "is_stock_item"):
438 continue
439
mergify[bot]40576822023-12-19 18:29:56 +0530440 if not self.get("return_against") or (
441 get_valuation_method(d.item_code) == "Moving Average" and self.get("is_return")
442 ):
Nabin Haita77b8c92020-12-21 14:45:50 +0530443 # Get incoming rate based on original item cost based on valuation method
Ankush Menat494bd9e2022-03-28 18:52:46 +0530444 qty = flt(d.get("stock_qty") or d.get("actual_qty"))
rohitwaghchaurece6c3b52021-04-13 20:55:52 +0530445
rohitwaghchaure59222812024-03-15 17:55:41 +0530446 if (
447 not d.incoming_rate
448 or self.is_internal_transfer()
449 or (get_valuation_method(d.item_code) == "Moving Average" and self.get("is_return"))
mergify[bot]07175362023-12-21 14:40:52 +0530450 ):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530451 d.incoming_rate = get_incoming_rate(
452 {
453 "item_code": d.item_code,
454 "warehouse": d.warehouse,
455 "posting_date": self.get("posting_date") or self.get("transaction_date"),
456 "posting_time": self.get("posting_time") or nowtime(),
457 "qty": qty if cint(self.get("is_return")) else (-1 * qty),
Rohit Waghchaure674bd3e2023-03-17 16:42:59 +0530458 "serial_and_batch_bundle": d.serial_and_batch_bundle,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530459 "company": self.company,
460 "voucher_type": self.doctype,
461 "voucher_no": self.name,
rohitwaghchaure5e9016f2023-12-01 21:42:22 +0530462 "voucher_detail_no": d.name,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530463 "allow_zero_valuation": d.get("allow_zero_valuation"),
rohitwaghchaure59222812024-03-15 17:55:41 +0530464 "batch_no": d.batch_no,
465 "serial_no": d.serial_no,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530466 },
467 raise_error_if_no_rate=False,
468 )
Deepesh Gargb4be2922021-01-28 13:09:56 +0530469
470 # For internal transfers use incoming rate as the valuation rate
471 if self.is_internal_transfer():
Deepesh Gargef9d1262022-12-05 10:17:19 +0530472 if self.doctype == "Delivery Note" or self.get("update_stock"):
473 if d.doctype == "Packed Item":
474 incoming_rate = flt(
475 flt(d.incoming_rate, d.precision("incoming_rate")) * d.conversion_factor,
476 d.precision("incoming_rate"),
Ankush Menatee0a2772022-05-12 18:17:09 +0530477 )
Deepesh Gargef9d1262022-12-05 10:17:19 +0530478 if d.incoming_rate != incoming_rate:
479 d.incoming_rate = incoming_rate
480 else:
481 rate = flt(
482 flt(d.incoming_rate, d.precision("incoming_rate")) * d.conversion_factor,
483 d.precision("rate"),
484 )
485 if d.rate != rate:
486 d.rate = rate
487 frappe.msgprint(
488 _(
489 "Row {0}: Item rate has been updated as per valuation rate since its an internal stock transfer"
490 ).format(d.idx),
491 alert=1,
492 )
Noah Jacobac0bc1f2021-06-24 19:36:17 +0530493
Deepesh Gargef9d1262022-12-05 10:17:19 +0530494 d.discount_percentage = 0.0
495 d.discount_amount = 0.0
496 d.margin_rate_or_amount = 0.0
Deepesh Gargb4be2922021-01-28 13:09:56 +0530497
Nabin Haita77b8c92020-12-21 14:45:50 +0530498 elif self.get("return_against"):
499 # Get incoming rate of return entry from reference document
500 # based on original item cost as per valuation method
Ankush Menat494bd9e2022-03-28 18:52:46 +0530501 d.incoming_rate = get_rate_for_return(
502 self.doctype, self.name, d.item_code, self.return_against, item_row=d
503 )
Nabin Haita77b8c92020-12-21 14:45:50 +0530504
Nabin Hait14aa9c52016-04-18 15:54:01 +0530505 def update_stock_ledger(self):
506 self.update_reserved_qty()
507
508 sl_entries = []
Nabin Haita77b8c92020-12-21 14:45:50 +0530509 # Loop over items and packed items table
Nabin Hait14aa9c52016-04-18 15:54:01 +0530510 for d in self.get_item_list():
Himanshu Mishra859d9422018-08-08 18:33:50 +0530511 if frappe.get_cached_value("Item", d.item_code, "is_stock_item") == 1 and flt(d.qty):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530512 if flt(d.conversion_factor) == 0.0:
513 d.conversion_factor = (
514 get_conversion_factor(d.item_code, d.uom).get("conversion_factor") or 1.0
515 )
rohitwaghchaure019d4de2020-08-20 15:53:58 +0530516
Nabin Haita77b8c92020-12-21 14:45:50 +0530517 # On cancellation or return entry submission, make stock ledger entry for
Nabin Hait14aa9c52016-04-18 15:54:01 +0530518 # target warehouse first, to update serial no values properly
519
Ankush Menat494bd9e2022-03-28 18:52:46 +0530520 if d.warehouse and (
521 (not cint(self.is_return) and self.docstatus == 1)
522 or (cint(self.is_return) and self.docstatus == 2)
523 ):
524 sl_entries.append(self.get_sle_for_source_warehouse(d))
Nabin Hait14aa9c52016-04-18 15:54:01 +0530525
mergify[bot]233bf5d2021-10-05 16:16:21 +0530526 if d.target_warehouse:
Nabin Haita77b8c92020-12-21 14:45:50 +0530527 sl_entries.append(self.get_sle_for_target_warehouse(d))
Nabin Hait14aa9c52016-04-18 15:54:01 +0530528
Ankush Menat494bd9e2022-03-28 18:52:46 +0530529 if d.warehouse and (
530 (not cint(self.is_return) and self.docstatus == 2)
531 or (cint(self.is_return) and self.docstatus == 1)
532 ):
533 sl_entries.append(self.get_sle_for_source_warehouse(d))
Nabin Haita77b8c92020-12-21 14:45:50 +0530534
Nabin Hait14aa9c52016-04-18 15:54:01 +0530535 self.make_sl_entries(sl_entries)
Anand Doshid2946502014-04-08 20:10:03 +0530536
Nabin Haita77b8c92020-12-21 14:45:50 +0530537 def get_sle_for_source_warehouse(self, item_row):
rohitwaghchaure59222812024-03-15 17:55:41 +0530538 serial_and_batch_bundle = item_row.serial_and_batch_bundle
539 if serial_and_batch_bundle and self.is_internal_transfer() and self.is_return:
540 if self.docstatus == 1:
541 serial_and_batch_bundle = self.make_package_for_transfer(
542 serial_and_batch_bundle, item_row.warehouse, type_of_transaction="Inward"
543 )
544 else:
545 serial_and_batch_bundle = frappe.db.get_value(
546 "Stock Ledger Entry",
547 {"voucher_detail_no": item_row.name, "warehouse": item_row.warehouse},
548 "serial_and_batch_bundle",
549 )
550
Ankush Menat494bd9e2022-03-28 18:52:46 +0530551 sle = self.get_sl_entries(
552 item_row,
553 {
554 "actual_qty": -1 * flt(item_row.qty),
555 "incoming_rate": item_row.incoming_rate,
556 "recalculate_rate": cint(self.is_return),
rohitwaghchaure59222812024-03-15 17:55:41 +0530557 "serial_and_batch_bundle": serial_and_batch_bundle,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530558 },
559 )
Nabin Haita77b8c92020-12-21 14:45:50 +0530560 if item_row.target_warehouse and not cint(self.is_return):
561 sle.dependant_sle_voucher_detail_no = item_row.name
562
563 return sle
564
565 def get_sle_for_target_warehouse(self, item_row):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530566 sle = self.get_sl_entries(
567 item_row, {"actual_qty": flt(item_row.qty), "warehouse": item_row.target_warehouse}
568 )
Nabin Haita77b8c92020-12-21 14:45:50 +0530569
570 if self.docstatus == 1:
571 if not cint(self.is_return):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530572 sle.update({"incoming_rate": item_row.incoming_rate, "recalculate_rate": 1})
Nabin Haita77b8c92020-12-21 14:45:50 +0530573 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530574 sle.update({"outgoing_rate": item_row.incoming_rate})
Nabin Haita77b8c92020-12-21 14:45:50 +0530575 if item_row.warehouse:
576 sle.dependant_sle_voucher_detail_no = item_row.name
Deepesh Gargb4be2922021-01-28 13:09:56 +0530577
rohitwaghchaure59222812024-03-15 17:55:41 +0530578 if item_row.serial_and_batch_bundle and not cint(self.is_return):
579 type_of_transaction = "Inward"
580 if cint(self.is_return):
581 type_of_transaction = "Outward"
582
Rohit Waghchaure86da3062023-03-20 14:15:34 +0530583 sle["serial_and_batch_bundle"] = self.make_package_for_transfer(
rohitwaghchaure59222812024-03-15 17:55:41 +0530584 item_row.serial_and_batch_bundle,
585 item_row.target_warehouse,
586 type_of_transaction=type_of_transaction,
Rohit Waghchaure86da3062023-03-20 14:15:34 +0530587 )
588
Nabin Haita77b8c92020-12-21 14:45:50 +0530589 return sle
590
Afshan01eca122020-12-08 09:27:56 +0530591 def set_po_nos(self, for_validate=False):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530592 if self.doctype == "Sales Invoice" and hasattr(self, "items"):
Afshan01eca122020-12-08 09:27:56 +0530593 if for_validate and self.po_no:
594 return
Afshan3f971b22020-10-26 16:59:57 +0530595 self.set_pos_for_sales_invoice()
Ankush Menat494bd9e2022-03-28 18:52:46 +0530596 if self.doctype == "Delivery Note" and hasattr(self, "items"):
Afshan01eca122020-12-08 09:27:56 +0530597 if for_validate and self.po_no:
598 return
Afshan3f971b22020-10-26 16:59:57 +0530599 self.set_pos_for_delivery_note()
600
601 def set_pos_for_sales_invoice(self):
Afshan0a6e1b32020-10-26 21:23:31 +0530602 po_nos = []
Afshan01eca122020-12-08 09:27:56 +0530603 if self.po_no:
604 po_nos.append(self.po_no)
Ankush Menat494bd9e2022-03-28 18:52:46 +0530605 self.get_po_nos("Sales Order", "sales_order", po_nos)
606 self.get_po_nos("Delivery Note", "delivery_note", po_nos)
607 self.po_no = ", ".join(list(set(x.strip() for x in ",".join(po_nos).split(","))))
Afshan3f971b22020-10-26 16:59:57 +0530608
609 def set_pos_for_delivery_note(self):
Afshan0a6e1b32020-10-26 21:23:31 +0530610 po_nos = []
Afshan01eca122020-12-08 09:27:56 +0530611 if self.po_no:
612 po_nos.append(self.po_no)
Ankush Menat494bd9e2022-03-28 18:52:46 +0530613 self.get_po_nos("Sales Order", "against_sales_order", po_nos)
614 self.get_po_nos("Sales Invoice", "against_sales_invoice", po_nos)
615 self.po_no = ", ".join(list(set(x.strip() for x in ",".join(po_nos).split(","))))
Afshan0a6e1b32020-10-26 21:23:31 +0530616
617 def get_po_nos(self, ref_doctype, ref_fieldname, po_nos):
Ankush Menat98917802021-06-11 18:40:22 +0530618 doc_list = list(set(d.get(ref_fieldname) for d in self.items if d.get(ref_fieldname)))
Afshan0a6e1b32020-10-26 21:23:31 +0530619 if doc_list:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530620 po_nos += [
621 d.po_no
622 for d in frappe.get_all(ref_doctype, "po_no", filters={"name": ("in", doc_list)})
623 if d.get("po_no")
624 ]
Nabin Hait96f4b222018-03-13 15:46:59 +0530625
Saif Ur Rehman5fdbc682018-11-26 19:32:16 +0500626 def set_gross_profit(self):
Abhishek Balam18e7b602020-05-26 18:37:02 +0530627 if self.doctype in ["Sales Order", "Quotation"]:
Saif Ur Rehman5fdbc682018-11-26 19:32:16 +0500628 for item in self.items:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530629 item.gross_profit = flt(
Akhil Narang3effaf22024-03-27 11:37:26 +0530630 ((item.base_rate - flt(item.valuation_rate)) * item.stock_qty),
631 self.precision("amount", item),
Ankush Menat494bd9e2022-03-28 18:52:46 +0530632 )
Saif Ur Rehman5fdbc682018-11-26 19:32:16 +0500633
Rohit Waghchauref4dc7162018-11-15 17:04:02 +0530634 def set_customer_address(self):
635 address_dict = {
Ankush Menat494bd9e2022-03-28 18:52:46 +0530636 "customer_address": "address_display",
637 "shipping_address_name": "shipping_address",
638 "company_address": "company_address_display",
Deepesh Garg104fdcb2022-11-24 16:41:40 +0530639 "dispatch_address_name": "dispatch_address",
Rohit Waghchauref4dc7162018-11-15 17:04:02 +0530640 }
641
642 for address_field, address_display_field in address_dict.items():
643 if self.get(address_field):
Ankush Menatf4d74992023-10-17 22:11:56 +0530644 self.set(
645 address_display_field, render_address(self.get(address_field), check_permissions=False)
646 )
Rohit Waghchauref4dc7162018-11-15 17:04:02 +0530647
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530648 def validate_for_duplicate_items(self):
649 check_list, chk_dupl_itm = [], []
650 if cint(frappe.db.get_single_value("Selling Settings", "allow_multiple_items")):
651 return
Saqib0681a482021-02-11 14:06:15 +0530652 if self.doctype == "Sales Invoice" and self.is_consolidated:
653 return
654 if self.doctype == "POS Invoice":
655 return
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530656
Ankush Menat494bd9e2022-03-28 18:52:46 +0530657 for d in self.get("items"):
Saqib0681a482021-02-11 14:06:15 +0530658 if self.doctype == "Sales Invoice":
Ankush Menat494bd9e2022-03-28 18:52:46 +0530659 stock_items = [
660 d.item_code,
661 d.description,
662 d.warehouse,
663 d.sales_order or d.delivery_note,
664 d.batch_no or "",
665 ]
Jannat Patelc1187bc2020-11-19 13:10:24 +0530666 non_stock_items = [d.item_code, d.description, d.sales_order or d.delivery_note]
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530667 elif self.doctype == "Delivery Note":
Ankush Menat494bd9e2022-03-28 18:52:46 +0530668 stock_items = [
669 d.item_code,
670 d.description,
671 d.warehouse,
672 d.against_sales_order or d.against_sales_invoice,
673 d.batch_no or "",
674 ]
675 non_stock_items = [
676 d.item_code,
677 d.description,
678 d.against_sales_order or d.against_sales_invoice,
679 ]
Rohit Waghchaure13c7e182019-08-29 19:45:19 +0530680 elif self.doctype in ["Sales Order", "Quotation"]:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530681 stock_items = [d.item_code, d.description, d.warehouse, ""]
Jannat Patelc1187bc2020-11-19 13:10:24 +0530682 non_stock_items = [d.item_code, d.description]
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530683
mergify[bot]89f516c2022-07-21 13:57:03 +0530684 duplicate_items_msg = _("Item {0} entered multiple times.").format(frappe.bold(d.item_code))
685 duplicate_items_msg += "<br><br>"
686 duplicate_items_msg += _("Please enable {} in {} to allow same item in multiple rows").format(
687 frappe.bold("Allow Item to Be Added Multiple Times in a Transaction"),
688 get_link_to_form("Selling Settings", "Selling Settings"),
689 )
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530690 if frappe.db.get_value("Item", d.item_code, "is_stock_item") == 1:
Jannat Patelc1187bc2020-11-19 13:10:24 +0530691 if stock_items in check_list:
Saqibac9e6ff2021-01-28 17:58:55 +0530692 frappe.throw(duplicate_items_msg)
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530693 else:
Jannat Patelc1187bc2020-11-19 13:10:24 +0530694 check_list.append(stock_items)
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530695 else:
Jannat Patelc1187bc2020-11-19 13:10:24 +0530696 if non_stock_items in chk_dupl_itm:
Saqibac9e6ff2021-01-28 17:58:55 +0530697 frappe.throw(duplicate_items_msg)
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530698 else:
Jannat Patelc1187bc2020-11-19 13:10:24 +0530699 chk_dupl_itm.append(non_stock_items)
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530700
rohitwaghchaure6fa6caf2020-04-23 09:46:29 +0530701 def validate_target_warehouse(self):
702 items = self.get("items") + (self.get("packed_items") or [])
703
704 for d in items:
705 if d.get("target_warehouse") and d.get("warehouse") == d.get("target_warehouse"):
706 warehouse = frappe.bold(d.get("target_warehouse"))
Ankush Menat494bd9e2022-03-28 18:52:46 +0530707 frappe.throw(
Akhil Narang3effaf22024-03-27 11:37:26 +0530708 _(
709 "Row {0}: Delivery Warehouse ({1}) and Customer Warehouse ({2}) can not be same"
710 ).format(d.idx, warehouse, warehouse)
Ankush Menat494bd9e2022-03-28 18:52:46 +0530711 )
Deepesh Gargf3d78dd2019-08-23 11:42:35 +0530712
mergify[bot]233bf5d2021-10-05 16:16:21 +0530713 if not self.get("is_internal_customer") and any(d.get("target_warehouse") for d in items):
714 msg = _("Target Warehouse is set for some items but the customer is not an internal customer.")
715 msg += " " + _("This {} will be treated as material transfer.").format(_(self.doctype))
716 frappe.msgprint(msg, title="Internal Transfer", alert=True)
717
Zarrarfc03a042018-06-04 12:52:52 +0530718 def validate_items(self):
719 # validate items to see if they have is_sales_item enabled
720 from erpnext.controllers.buying_controller import validate_item_type
Ankush Menat494bd9e2022-03-28 18:52:46 +0530721
Zarrarfc03a042018-06-04 12:52:52 +0530722 validate_item_type(self, "is_sales_item", "sales")
723
Ankush Menat494bd9e2022-03-28 18:52:46 +0530724
Rushabh Mehta708e47a2018-08-08 16:37:31 +0530725def set_default_income_account_for_item(obj):
Nabin Haitdd38a262014-12-26 13:15:21 +0530726 for d in obj.get("items"):
Nabin Haitd1fd1e22013-10-18 12:29:11 +0530727 if d.item_code:
Manas Solanki5b935622018-05-16 17:44:51 +0530728 if getattr(d, "income_account", None):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530729 set_item_default(d.item_code, obj.company, "income_account", d.income_account)
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530730
731
732def get_serial_and_batch_bundle(child, parent):
733 from erpnext.stock.serial_batch_bundle import SerialBatchCreation
734
rohitwaghchaurebc9c4802024-02-26 23:57:52 +0530735 if child.get("use_serial_batch_fields"):
736 return
737
Akhil Narang3effaf22024-03-27 11:37:26 +0530738 if not frappe.db.get_single_value("Stock Settings", "auto_create_serial_and_batch_bundle_for_outward"):
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530739 return
740
Akhil Narang3effaf22024-03-27 11:37:26 +0530741 item_details = frappe.db.get_value("Item", child.item_code, ["has_serial_no", "has_batch_no"], as_dict=1)
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530742
743 if not item_details.has_serial_no and not item_details.has_batch_no:
744 return
745
746 sn_doc = SerialBatchCreation(
747 {
748 "item_code": child.item_code,
749 "warehouse": child.warehouse,
750 "voucher_type": parent.doctype,
Rohit Waghchaured73b1f32024-03-30 10:46:56 +0530751 "voucher_no": parent.name if parent.docstatus < 2 else None,
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530752 "voucher_detail_no": child.name,
753 "posting_date": parent.posting_date,
754 "posting_time": parent.posting_time,
755 "qty": child.qty,
Rohit Waghchaured73b1f32024-03-30 10:46:56 +0530756 "type_of_transaction": "Outward" if child.qty > 0 and parent.docstatus < 2 else "Inward",
Rohit Waghchaured3ceb072023-03-31 09:03:54 +0530757 "company": parent.company,
758 "do_not_submit": "True",
759 }
760 )
761
762 doc = sn_doc.make_serial_and_batch_bundle()
763 child.db_set("serial_and_batch_bundle", doc.name)
764
765 return doc.name