blob: 933ced0bd701042bf2c61946ad98755e2d9b9deb [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
Anand Doshi3543f302013-05-24 19:25:01 +05303
Deepesh Garg6b9dda52020-11-25 14:49:10 +05304frappe.provide('erpnext.accounts.dimensions');
5
Faris Ansari1fe891b2021-04-23 08:04:00 +05306erpnext.TransactionController = class TransactionController extends erpnext.taxes_and_totals {
7 setup() {
Suraj Shetty81d49e92021-05-21 17:03:09 +05308 super.setup();
Deepesh Garg8a7e2832021-06-04 22:53:26 +05309 let me = this;
Saqibfaea8542020-03-26 13:18:57 +053010 frappe.flags.hide_serial_batch_dialog = true;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053011 frappe.ui.form.on(this.frm.doctype + " Item", "rate", function(frm, cdt, cdn) {
12 var item = frappe.get_doc(cdt, cdn);
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053013 var has_margin_field = frappe.meta.has_field(cdt, 'margin_type');
14
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053015 frappe.model.round_floats_in(item, ["rate", "price_list_rate"]);
16
17 if(item.price_list_rate) {
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053018 if(item.rate > item.price_list_rate && has_margin_field) {
19 // if rate is greater than price_list_rate, set margin
20 // or set discount
21 item.discount_percentage = 0;
Nabin Haite72c98d2017-05-24 09:01:44 +053022 item.margin_type = 'Amount';
Rushabh Mehta36311022017-06-20 09:30:53 +053023 item.margin_rate_or_amount = flt(item.rate - item.price_list_rate,
Nabin Haite72c98d2017-05-24 09:01:44 +053024 precision("margin_rate_or_amount", item));
25 item.rate_with_margin = item.rate;
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053026 } else {
Rushabh Mehta36311022017-06-20 09:30:53 +053027 item.discount_percentage = flt((1 - item.rate / item.price_list_rate) * 100.0,
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053028 precision("discount_percentage", item));
Nabin Hait593242f2019-04-05 19:35:02 +053029 item.discount_amount = flt(item.price_list_rate) - flt(item.rate);
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053030 item.margin_type = '';
31 item.margin_rate_or_amount = 0;
32 item.rate_with_margin = 0;
33 }
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053034 } else {
35 item.discount_percentage = 0.0;
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053036 item.margin_type = '';
37 item.margin_rate_or_amount = 0;
38 item.rate_with_margin = 0;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053039 }
Saif Ur Rehman147fa732018-11-26 18:14:06 +050040 item.base_rate_with_margin = item.rate_with_margin * flt(frm.doc.conversion_rate);
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053041
42 cur_frm.cscript.set_gross_profit(item);
43 cur_frm.cscript.calculate_taxes_and_totals();
Anupam Kumar7e1dcf92021-02-11 20:19:30 +053044 cur_frm.cscript.calculate_stock_uom_rate(frm, cdt, cdn);
Rushabh Mehta30dc9a12017-11-17 14:31:09 +053045 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053046
47 frappe.ui.form.on(this.frm.cscript.tax_table, "rate", function(frm, cdt, cdn) {
48 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053049 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053050
51 frappe.ui.form.on(this.frm.cscript.tax_table, "tax_amount", function(frm, cdt, cdn) {
52 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053053 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053054
55 frappe.ui.form.on(this.frm.cscript.tax_table, "row_id", function(frm, cdt, cdn) {
56 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053057 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053058
59 frappe.ui.form.on(this.frm.cscript.tax_table, "included_in_print_rate", function(frm, cdt, cdn) {
60 cur_frm.cscript.set_dynamic_labels();
61 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053062 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053063
64 frappe.ui.form.on(this.frm.doctype, "apply_discount_on", function(frm) {
65 if(frm.doc.additional_discount_percentage) {
66 frm.trigger("additional_discount_percentage");
67 } else {
68 cur_frm.cscript.calculate_taxes_and_totals();
69 }
Rushabh Mehta764aa922016-05-02 13:28:46 +053070 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053071
72 frappe.ui.form.on(this.frm.doctype, "additional_discount_percentage", function(frm) {
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053073 if(!frm.doc.apply_discount_on) {
74 frappe.msgprint(__("Please set 'Apply Additional Discount On'"));
Rushabh Mehta233a19a2017-07-07 13:05:11 +053075 return;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053076 }
77
78 frm.via_discount_percentage = true;
79
80 if(frm.doc.additional_discount_percentage && frm.doc.discount_amount) {
81 // Reset discount amount and net / grand total
Rushabh Mehta6705ab32017-07-07 13:14:08 +053082 frm.doc.discount_amount = 0;
83 frm.cscript.calculate_taxes_and_totals();
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053084 }
85
86 var total = flt(frm.doc[frappe.model.scrub(frm.doc.apply_discount_on)]);
87 var discount_amount = flt(total*flt(frm.doc.additional_discount_percentage) / 100,
88 precision("discount_amount"));
89
Rushabh Mehta233a19a2017-07-07 13:05:11 +053090 frm.set_value("discount_amount", discount_amount)
91 .then(() => delete frm.via_discount_percentage);
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053092 });
93
94 frappe.ui.form.on(this.frm.doctype, "discount_amount", function(frm) {
95 frm.cscript.set_dynamic_labels();
96
97 if (!frm.via_discount_percentage) {
Rushabh Mehta233a19a2017-07-07 13:05:11 +053098 frm.doc.additional_discount_percentage = 0;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053099 }
100
101 frm.cscript.calculate_taxes_and_totals();
102 });
Makarand Bauskarc196d742017-06-02 17:28:40 +0530103
Saif60ec88b2018-11-13 12:07:53 +0500104 frappe.ui.form.on(this.frm.doctype + " Item", {
105 items_add: function(frm, cdt, cdn) {
106 var item = frappe.get_doc(cdt, cdn);
Deepesh Gargb4be2922021-01-28 13:09:56 +0530107 if (!item.warehouse && frm.doc.set_warehouse) {
Saif60ec88b2018-11-13 12:07:53 +0500108 item.warehouse = frm.doc.set_warehouse;
109 }
Deepesh Garg6b9dda52020-11-25 14:49:10 +0530110
Deepesh Gargb4be2922021-01-28 13:09:56 +0530111 if (!item.target_warehouse && frm.doc.set_target_warehouse) {
112 item.target_warehouse = frm.doc.set_target_warehouse;
113 }
114
115 if (!item.from_warehouse && frm.doc.set_from_warehouse) {
116 item.from_warehouse = frm.doc.set_from_warehouse;
117 }
118
Deepesh Garg6b9dda52020-11-25 14:49:10 +0530119 erpnext.accounts.dimensions.copy_dimension_from_first_row(frm, cdt, cdn, 'items');
Saif60ec88b2018-11-13 12:07:53 +0500120 }
121 });
122
Makarand Bauskarc196d742017-06-02 17:28:40 +0530123 if(this.frm.fields_dict["items"].grid.get_field('batch_no')) {
124 this.frm.set_query("batch_no", "items", function(doc, cdt, cdn) {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530125 return me.set_query_for_batch(doc, cdt, cdn);
Makarand Bauskarc196d742017-06-02 17:28:40 +0530126 });
127 }
Akhilesh Darjee564c6212013-10-17 11:31:11 +0530128
tundebabzy590bd0a2017-12-25 07:10:19 +0100129 if(
Faris Ansari404f39d2018-05-14 15:46:45 +0530130 this.frm.docstatus < 2
Manas Solankia7f55892018-04-02 10:32:00 +0530131 && this.frm.fields_dict["payment_terms_template"]
tundebabzy590bd0a2017-12-25 07:10:19 +0100132 && this.frm.fields_dict["payment_schedule"]
133 && this.frm.doc.payment_terms_template
134 && !this.frm.doc.payment_schedule.length
135 ){
tundedf3a1752017-09-11 11:02:57 +0100136 this.frm.trigger("payment_terms_template");
137 }
138
Nabin Haitdd38a262014-12-26 13:15:21 +0530139 if(this.frm.fields_dict["taxes"]) {
140 this["taxes_remove"] = this.calculate_taxes_and_totals;
Anand Doshia91c95f2013-08-23 13:00:47 +0530141 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530142
Nabin Haitdd38a262014-12-26 13:15:21 +0530143 if(this.frm.fields_dict["items"]) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530144 this["items_remove"] = this.calculate_net_weight;
Anand Doshi1e4fb682013-08-23 12:56:33 +0530145 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530146
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530147 if(this.frm.fields_dict["recurring_print_format"]) {
148 this.frm.set_query("recurring_print_format", function(doc) {
149 return{
150 filters: [
151 ['Print Format', 'doc_type', '=', cur_frm.doctype],
152 ]
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530153 };
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530154 });
155 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530156
Nabin Hait1d218422015-07-17 15:19:02 +0530157 if(this.frm.fields_dict["return_against"]) {
158 this.frm.set_query("return_against", function(doc) {
159 var filters = {
160 "docstatus": 1,
161 "is_return": 0,
162 "company": doc.company
163 };
164 if (me.frm.fields_dict["customer"] && doc.customer) filters["customer"] = doc.customer;
165 if (me.frm.fields_dict["supplier"] && doc.supplier) filters["supplier"] = doc.supplier;
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530166
Nabin Hait1d218422015-07-17 15:19:02 +0530167 return {
168 filters: filters
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530169 };
Nabin Hait1d218422015-07-17 15:19:02 +0530170 });
171 }
michellealva08f842d2020-06-26 19:56:00 +0530172
rohitwaghchaured5736712020-06-28 11:12:20 +0530173 if (this.frm.fields_dict["items"].grid.get_field("expense_account")) {
michellealva08f842d2020-06-26 19:56:00 +0530174 this.frm.set_query("expense_account", "items", function(doc) {
rohitwaghchaured5736712020-06-28 11:12:20 +0530175 return {
michellealva08f842d2020-06-26 19:56:00 +0530176 filters: {
177 "company": doc.company
178 }
179 };
180 });
181 }
182
Rohit Waghchauree5405342019-03-31 16:42:41 +0530183 if(frappe.meta.get_docfield(this.frm.doc.doctype, "pricing_rules")) {
Rohit Waghchaure70b996a2019-03-31 20:33:15 +0530184 this.frm.set_indicator_formatter('pricing_rule', function(doc) {
185 return (doc.rule_applied) ? "green" : "red";
186 });
Rohit Waghchauree5405342019-03-31 16:42:41 +0530187 }
Rohit Waghchaurea5357c22020-03-27 12:54:01 +0530188
189 let batch_no_field = this.frm.get_docfield("items", "batch_no");
190 if (batch_no_field) {
191 batch_no_field.get_route_options_for_new_doc = function(row) {
192 return {
193 "item": row.doc.item_code
194 }
195 };
196 }
197
Marica299e2172020-04-28 13:00:04 +0530198 if (this.frm.fields_dict["items"].grid.get_field('blanket_order')) {
199 this.frm.set_query("blanket_order", "items", function(doc, cdt, cdn) {
200 var item = locals[cdt][cdn];
201 return {
202 query: "erpnext.controllers.queries.get_blanket_orders",
203 filters: {
204 "company": doc.company,
205 "blanket_order_type": doc.doctype === "Sales Order" ? "Selling" : "Purchasing",
206 "item": item.item_code
207 }
208 }
209 });
210 }
211
Mohammad Hasnain Mohsin Rajane15b6a92020-11-25 15:36:41 +0530212 if (this.frm.fields_dict.taxes_and_charges) {
213 this.frm.set_query("taxes_and_charges", function() {
214 return {
215 filters: [
216 ['company', '=', me.frm.doc.company],
217 ['docstatus', '!=', 2]
218 ]
219 };
220 });
221 }
222
Faris Ansari1fe891b2021-04-23 08:04:00 +0530223 }
224 onload() {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530225 var me = this;
Rushabh Mehta6b537922017-03-14 16:59:11 +0530226
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530227 if(this.frm.doc.__islocal) {
228 var currency = frappe.defaults.get_user_default("currency");
229
230 let set_value = (fieldname, value) => {
231 if(me.frm.fields_dict[fieldname] && !me.frm.doc[fieldname]) {
232 return me.frm.set_value(fieldname, value);
233 }
234 };
235
Deepesh Gargb4be2922021-01-28 13:09:56 +0530236 this.frm.trigger('set_default_internal_warehouse');
237
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530238 return frappe.run_serially([
239 () => set_value('currency', currency),
240 () => set_value('price_list_currency', currency),
241 () => set_value('status', 'Draft'),
242 () => set_value('is_subcontracted', 'No'),
243 () => {
244 if(this.frm.doc.company && !this.frm.doc.amended_from) {
245 this.frm.trigger("company");
246 }
247 }
248 ]);
249 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530250 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530251
Faris Ansari1fe891b2021-04-23 08:04:00 +0530252 is_return() {
Rohit Waghchaureb4a59932018-11-26 20:02:01 +0530253 if(!this.frm.doc.is_return && this.frm.doc.return_against) {
254 this.frm.set_value('return_against', '');
255 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530256 }
Rohit Waghchaureb4a59932018-11-26 20:02:01 +0530257
Faris Ansari1fe891b2021-04-23 08:04:00 +0530258 setup_quality_inspection() {
Nabin Hait8af429d2016-11-16 17:21:59 +0530259 if(!in_list(["Delivery Note", "Sales Invoice", "Purchase Receipt", "Purchase Invoice"], this.frm.doc.doctype)) {
260 return;
261 }
Rohan Bansala93b5142021-04-06 17:10:52 +0530262
263 const me = this;
264 if (!this.frm.is_new() && this.frm.doc.docstatus === 0) {
265 this.frm.add_custom_button(__("Quality Inspection(s)"), () => {
266 me.make_quality_inspection();
267 }, __("Create"));
268 this.frm.page.set_inner_btn_group_as_primary(__('Create'));
269 }
270
271 const inspection_type = in_list(["Purchase Receipt", "Purchase Invoice"], this.frm.doc.doctype)
Nabin Hait8af429d2016-11-16 17:21:59 +0530272 ? "Incoming" : "Outgoing";
Rushabh Mehta6b537922017-03-14 16:59:11 +0530273
Rohan Bansala93b5142021-04-06 17:10:52 +0530274 let quality_inspection_field = this.frm.get_docfield("items", "quality_inspection");
Nabin Hait8af429d2016-11-16 17:21:59 +0530275 quality_inspection_field.get_route_options_for_new_doc = function(row) {
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530276 if(me.frm.is_new()) return;
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530277 return {
278 "inspection_type": inspection_type,
Manas Solanki34feab12016-11-16 14:36:28 +0530279 "reference_type": me.frm.doc.doctype,
Manas Solankidbc25112016-11-16 15:06:08 +0530280 "reference_name": me.frm.doc.name,
Nabin Hait8af429d2016-11-16 17:21:59 +0530281 "item_code": row.doc.item_code,
282 "description": row.doc.description,
283 "item_serial_no": row.doc.serial_no ? row.doc.serial_no.split("\n")[0] : null,
284 "batch_no": row.doc.batch_no
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530285 }
286 }
Rushabh Mehta6b537922017-03-14 16:59:11 +0530287
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530288 this.frm.set_query("quality_inspection", "items", function(doc, cdt, cdn) {
Rohan Bansala93b5142021-04-06 17:10:52 +0530289 let d = locals[cdt][cdn];
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530290 return {
291 filters: {
292 docstatus: 1,
293 inspection_type: inspection_type,
rohitwaghchaure4e8fdf72018-02-22 11:03:48 +0530294 reference_name: doc.name,
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530295 item_code: d.item_code
296 }
297 }
298 });
Faris Ansari1fe891b2021-04-23 08:04:00 +0530299 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530300
Faris Ansari1fe891b2021-04-23 08:04:00 +0530301 make_payment_request() {
Rohit Waghchaure210f4982018-10-03 15:55:51 +0530302 var me = this;
303 const payment_request_type = (in_list(['Sales Order', 'Sales Invoice'], this.frm.doc.doctype))
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530304 ? "Inward" : "Outward";
305
306 frappe.call({
307 method:"erpnext.accounts.doctype.payment_request.payment_request.make_payment_request",
308 args: {
309 dt: me.frm.doc.doctype,
310 dn: me.frm.doc.name,
311 recipient_id: me.frm.doc.contact_email,
312 payment_request_type: payment_request_type,
313 party_type: payment_request_type == 'Outward' ? "Supplier" : "Customer",
314 party: payment_request_type == 'Outward' ? me.frm.doc.supplier : me.frm.doc.customer
315 },
316 callback: function(r) {
317 if(!r.exc){
318 var doc = frappe.model.sync(r.message);
319 frappe.set_route("Form", r.message.doctype, r.message.name);
320 }
321 }
322 })
Faris Ansari1fe891b2021-04-23 08:04:00 +0530323 }
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530324
Faris Ansari1fe891b2021-04-23 08:04:00 +0530325 onload_post_render() {
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530326 if(this.frm.doc.__islocal && !(this.frm.doc.taxes || []).length
327 && !(this.frm.doc.__onload ? this.frm.doc.__onload.load_after_mapping : false)) {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530328 frappe.after_ajax(() => this.apply_default_taxes());
Anand Doshi70f57eb2015-11-27 14:37:40 +0530329 } else if(this.frm.doc.__islocal && this.frm.doc.company && this.frm.doc["items"]
Nabin Haitbdfb0702015-10-28 15:38:08 +0530330 && !this.frm.doc.is_pos) {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530331 frappe.after_ajax(() => this.calculate_taxes_and_totals());
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530332 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530333 if(frappe.meta.get_docfield(this.frm.doc.doctype + " Item", "item_code")) {
Rushabh Mehta203cc962016-04-07 15:25:43 +0530334 this.setup_item_selector();
Nabin Hait3fccfaa2019-05-16 14:48:10 +0530335 this.frm.get_field("items").grid.set_multiple_add("item_code", "qty");
Rushabh Mehtab6843f22014-06-04 13:10:41 +0530336 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530337 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530338
Faris Ansari1fe891b2021-04-23 08:04:00 +0530339 refresh() {
Anand Doshi8bde7f92014-04-24 18:11:49 +0530340 erpnext.toggle_naming_series();
Anand Doshibdee6e02013-07-09 13:03:39 +0530341 erpnext.hide_company();
Nabin Hait1f996c32013-07-29 19:00:53 +0530342 this.set_dynamic_labels();
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530343 this.setup_sms();
Rohit Waghchauref2705672018-06-12 12:20:52 +0530344 this.setup_quality_inspection();
Faris Ansari1fe891b2021-04-23 08:04:00 +0530345 }
Zarrar69224152018-11-13 11:11:32 +0530346
Faris Ansari1fe891b2021-04-23 08:04:00 +0530347 scan_barcode() {
marination596cf392021-09-27 15:06:46 +0530348 let me = this;
Zarrar69224152018-11-13 11:11:32 +0530349
350 if(this.frm.doc.scan_barcode) {
351 frappe.call({
Saqib7ff19eb2021-06-21 10:48:50 +0530352 method: "erpnext.selling.page.point_of_sale.point_of_sale.search_for_serial_or_batch_or_barcode_number",
marination596cf392021-09-27 15:06:46 +0530353 args: {
354 search_value: this.frm.doc.scan_barcode
355 }
Zarrar69224152018-11-13 11:11:32 +0530356 }).then(r => {
Faris Ansari5631ffc2019-02-12 17:12:48 +0530357 const data = r && r.message;
Nabin Hait34c551d2019-07-03 10:34:31 +0530358 if (!data || Object.keys(data).length === 0) {
Marica8f6bd852020-10-29 18:55:52 +0530359 frappe.show_alert({
360 message: __('Cannot find Item with this Barcode'),
361 indicator: 'red'
362 });
Faris Ansari5631ffc2019-02-12 17:12:48 +0530363 return;
Zarrar69224152018-11-13 11:11:32 +0530364 }
Faris Ansari5631ffc2019-02-12 17:12:48 +0530365
marination596cf392021-09-27 15:06:46 +0530366 me.modify_table_after_scan(data);
Zarrar69224152018-11-13 11:11:32 +0530367 });
Zarrar69224152018-11-13 11:11:32 +0530368 }
369 return false;
Faris Ansari1fe891b2021-04-23 08:04:00 +0530370 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530371
marination596cf392021-09-27 15:06:46 +0530372 modify_table_after_scan(data) {
373 let scan_barcode_field = this.frm.fields_dict["scan_barcode"];
374 let cur_grid = this.frm.fields_dict.items.grid;
375 let row_to_modify = null;
376
377 // Check if batch is scanned and table has batch no field
378 let batch_no_scan = Boolean(data.batch_no) && frappe.meta.has_field(cur_grid.doctype, "batch_no");
379
380 if (batch_no_scan) {
marinationabf450d2021-09-30 14:03:40 +0530381 row_to_modify = this.get_batch_row_to_modify(data.batch_no);
marination596cf392021-09-27 15:06:46 +0530382 } else {
383 // serial or barcode scan
384 row_to_modify = this.get_row_to_modify_on_scan(row_to_modify, data);
385 }
386
marinationabf450d2021-09-30 14:03:40 +0530387 if (!row_to_modify) {
388 // add new row if new item/batch is scanned
marination596cf392021-09-27 15:06:46 +0530389 row_to_modify = frappe.model.add_child(this.frm.doc, cur_grid.doctype, 'items');
390 }
391
392 this.show_scan_message(row_to_modify.idx, row_to_modify.item_code);
393 this.set_scanned_values(row_to_modify, data, scan_barcode_field);
394 }
395
396 set_scanned_values(row_to_modify, data, scan_barcode_field) {
397 // increase qty and set scanned value and item in row
398 this.frm.from_barcode = this.frm.from_barcode ? this.frm.from_barcode + 1 : 1;
399 frappe.model.set_value(row_to_modify.doctype, row_to_modify.name, {
400 item_code: data.item_code,
401 qty: (row_to_modify.qty || 0) + 1
402 });
403
404 ['serial_no', 'batch_no', 'barcode'].forEach(field => {
405 if (data[field] && frappe.meta.has_field(row_to_modify.doctype, field)) {
406 let is_serial_no = row_to_modify[field] && field === "serial_no";
marination596cf392021-09-27 15:06:46 +0530407 let value = data[field];
marinationabf450d2021-09-30 14:03:40 +0530408
marination596cf392021-09-27 15:06:46 +0530409 if (is_serial_no) {
410 value = row_to_modify[field] + '\n' + data[field];
411 }
412
413 frappe.model.set_value(row_to_modify.doctype, row_to_modify.name, field, value);
414 }
415 });
416
417 scan_barcode_field.set_value('');
418 refresh_field("items");
419 }
420
421 get_row_to_modify_on_scan(row_to_modify, data) {
422 // get an existing item row to increment or blank row to modify
423 const existing_item_row = this.frm.doc.items.find(d => d.item_code === data.item_code);
424 const blank_item_row = this.frm.doc.items.find(d => !d.item_code);
425
426 if (existing_item_row) {
427 row_to_modify = existing_item_row;
428 } else if (blank_item_row) {
429 row_to_modify = blank_item_row;
430 }
431
432 return row_to_modify;
433 }
434
marinationabf450d2021-09-30 14:03:40 +0530435 get_batch_row_to_modify(batch_no) {
436 // get row if batch already exists in table
marination596cf392021-09-27 15:06:46 +0530437 const existing_batch_row = this.frm.doc.items.find(d => d.batch_no === batch_no);
marinationabf450d2021-09-30 14:03:40 +0530438 return existing_batch_row || null;
marination596cf392021-09-27 15:06:46 +0530439 }
440
441 show_scan_message (idx, exist = null) {
marinationabf450d2021-09-30 14:03:40 +0530442 // show new row or qty increase toast
marination596cf392021-09-27 15:06:46 +0530443 if (exist) {
444 frappe.show_alert({
445 message: __('Row #{0}: Qty increased by 1', [idx]),
446 indicator: 'green'
447 });
448 } else {
449 frappe.show_alert({
450 message: __('Row #{0}: Item added', [idx]),
451 indicator: 'green'
452 });
453 }
454 }
455
Faris Ansari1fe891b2021-04-23 08:04:00 +0530456 apply_default_taxes() {
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530457 var me = this;
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530458 var taxes_and_charges_field = frappe.meta.get_docfield(me.frm.doc.doctype, "taxes_and_charges",
459 me.frm.doc.name);
460
SDLyu68672af2020-09-18 13:58:23 +0800461 if (!this.frm.doc.taxes_and_charges && this.frm.doc.taxes && this.frm.doc.taxes.length > 0) {
rohitwaghchaure1f39feb2018-01-05 12:25:45 +0530462 return;
463 }
464
465 if (taxes_and_charges_field) {
Nabin Haitbdfb0702015-10-28 15:38:08 +0530466 return frappe.call({
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530467 method: "erpnext.controllers.accounts_controller.get_default_taxes_and_charges",
468 args: {
rohitwaghchaure505661b2017-12-11 14:52:28 +0530469 "master_doctype": taxes_and_charges_field.options,
Rushabh Mehta39154e52020-12-10 12:37:16 +0530470 "tax_template": me.frm.doc.taxes_and_charges || "",
rohitwaghchaure505661b2017-12-11 14:52:28 +0530471 "company": me.frm.doc.company
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530472 },
Rushabh Mehta39154e52020-12-10 12:37:16 +0530473 debounce: 2000,
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530474 callback: function(r) {
Nabin Haita2426fc2018-01-15 17:45:46 +0530475 if(!r.exc && r.message) {
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530476 frappe.run_serially([
477 () => {
478 // directly set in doc, so as not to call triggers
rohitwaghchaure1bc47fa2017-12-16 10:49:58 +0530479 if(r.message.taxes_and_charges) {
480 me.frm.doc.taxes_and_charges = r.message.taxes_and_charges;
481 }
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530482
483 // set taxes table
rohitwaghchaure1bc47fa2017-12-16 10:49:58 +0530484 if(r.message.taxes) {
485 me.frm.set_value("taxes", r.message.taxes);
486 }
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530487 },
Saif3c9155e2018-10-18 17:27:56 +0500488 () => me.set_dynamic_labels(),
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530489 () => me.calculate_taxes_and_totals()
490 ]);
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530491 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530492 }
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530493 });
494 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530495 }
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530496
Faris Ansari1fe891b2021-04-23 08:04:00 +0530497 setup_sms() {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530498 var me = this;
Faris Ansaria5d975d2019-07-04 17:47:28 +0530499 let blacklist = ['Purchase Invoice', 'BOM'];
Nabin Hait7132bd32016-04-13 15:19:37 +0530500 if(this.frm.doc.docstatus===1 && !in_list(["Lost", "Stopped", "Closed"], this.frm.doc.status)
Faris Ansaria5d975d2019-07-04 17:47:28 +0530501 && !blacklist.includes(this.frm.doctype)) {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530502 this.frm.page.add_menu_item(__('Send SMS'), function() { me.send_sms(); });
503 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530504 }
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530505
Faris Ansari1fe891b2021-04-23 08:04:00 +0530506 send_sms() {
Faris Ansariab74ca72017-05-30 12:54:42 +0530507 var sms_man = new erpnext.SMSManager(this.frm.doc);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530508 }
Anand Doshi50d7e8c2015-01-06 17:14:13 +0530509
Faris Ansari1fe891b2021-04-23 08:04:00 +0530510 barcode(doc, cdt, cdn) {
Neil Trini Lasradod0151952015-06-09 15:21:50 +0530511 var d = locals[cdt][cdn];
512 if(d.barcode=="" || d.barcode==null) {
513 // barcode cleared, remove item
514 d.item_code = "";
515 }
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530516
Mohammad Hasnain Mohsin Rajan8abe7b92020-12-10 17:48:22 +0530517 this.frm.from_barcode = this.frm.from_barcode ? this.frm.from_barcode + 1 : 1;
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530518 this.item_code(doc, cdt, cdn);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530519 }
Neil Trini Lasradod0151952015-06-09 15:21:50 +0530520
Faris Ansari1fe891b2021-04-23 08:04:00 +0530521 item_code(doc, cdt, cdn) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530522 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530523 var item = frappe.get_doc(cdt, cdn);
pratu16x75f389c92017-06-26 13:38:24 +0530524 var update_stock = 0, show_batch_dialog = 0;
rohitwaghchaure7b4a6542021-09-03 22:00:14 +0530525
526 item.weight_per_unit = 0;
527 item.weight_uom = '';
528
rohitwaghchaure5999ade2017-08-09 17:24:13 +0530529 if(['Sales Invoice'].includes(this.frm.doc.doctype)) {
pratu16x7577e4c42017-06-23 11:39:03 +0530530 update_stock = cint(me.frm.doc.update_stock);
531 show_batch_dialog = update_stock;
pratu16x7ae450fc2017-06-26 15:31:46 +0530532
533 } else if((this.frm.doc.doctype === 'Purchase Receipt' && me.frm.doc.is_return) ||
534 this.frm.doc.doctype === 'Delivery Note') {
pratu16x789d001c2017-06-26 17:45:49 +0530535 show_batch_dialog = 1;
pratu16x7577e4c42017-06-23 11:39:03 +0530536 }
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530537 // clear barcode if setting item (else barcode will take priority)
Mohammad Hasnain Mohsin Rajandeaf2e82020-12-09 12:36:14 +0530538 if (this.frm.from_barcode == 0) {
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530539 item.barcode = null;
540 }
Mohammad Hasnain Mohsin Rajandeaf2e82020-12-09 12:36:14 +0530541 this.frm.from_barcode = this.frm.from_barcode - 1 >= 0 ? this.frm.from_barcode - 1 : 0;
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530542
Mohammad Hasnain69514c42020-12-09 12:10:28 +0530543
Nabin Hait139dc7b2014-02-12 14:53:18 +0530544 if(item.item_code || item.barcode || item.serial_no) {
545 if(!this.validate_company_and_party()) {
pratu16x7577e4c42017-06-23 11:39:03 +0530546 this.frm.fields_dict["items"].grid.grid_rows[item.idx - 1].remove();
Nabin Hait139dc7b2014-02-12 14:53:18 +0530547 } else {
548 return this.frm.call({
549 method: "erpnext.stock.get_item_details.get_item_details",
550 child: item,
551 args: {
Rohit Waghchauree5405342019-03-31 16:42:41 +0530552 doc: me.frm.doc,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530553 args: {
554 item_code: item.item_code,
555 barcode: item.barcode,
556 serial_no: item.serial_no,
marinatione05013e2020-04-06 22:13:13 +0530557 batch_no: item.batch_no,
Saif Ur Rehman2689dea2019-01-09 13:43:06 +0500558 set_warehouse: me.frm.doc.set_warehouse,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530559 warehouse: item.warehouse,
Nabin Hait34c551d2019-07-03 10:34:31 +0530560 customer: me.frm.doc.customer || me.frm.doc.party_name,
561 quotation_to: me.frm.doc.quotation_to,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530562 supplier: me.frm.doc.supplier,
563 currency: me.frm.doc.currency,
pratu16x7577e4c42017-06-23 11:39:03 +0530564 update_stock: update_stock,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530565 conversion_rate: me.frm.doc.conversion_rate,
Faris Ansariab74ca72017-05-30 12:54:42 +0530566 price_list: me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530567 price_list_currency: me.frm.doc.price_list_currency,
568 plc_conversion_rate: me.frm.doc.plc_conversion_rate,
569 company: me.frm.doc.company,
570 order_type: me.frm.doc.order_type,
571 is_pos: cint(me.frm.doc.is_pos),
Saqib1f591ab2021-01-05 13:53:51 +0530572 is_return: cint(me.frm.doc.is_return),
Nabin Hait139dc7b2014-02-12 14:53:18 +0530573 is_subcontracted: me.frm.doc.is_subcontracted,
Nabin Haita1bf43b2015-03-17 10:50:47 +0530574 transaction_date: me.frm.doc.transaction_date || me.frm.doc.posting_date,
Nabin Hait444f9562014-06-20 15:59:49 +0530575 ignore_pricing_rule: me.frm.doc.ignore_pricing_rule,
Anand Doshiafe85bd2016-01-21 21:04:16 +0530576 doctype: me.frm.doc.doctype,
577 name: me.frm.doc.name,
Neil Trini Lasrado6e343e22016-03-09 17:02:59 +0530578 project: item.project || me.frm.doc.project,
mbauskarba412422017-04-19 12:35:51 +0530579 qty: item.qty || 1,
Deepesh Garg8a7e2832021-06-04 22:53:26 +0530580 net_rate: item.rate,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530581 stock_qty: item.stock_qty,
rohitwaghchaurec037dc72017-11-28 16:11:15 +0530582 conversion_factor: item.conversion_factor,
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530583 weight_per_unit: item.weight_per_unit,
584 weight_uom: item.weight_uom,
Rohit Waghchaure3cf24362019-06-02 16:03:05 +0530585 manufacturer: item.manufacturer,
Nabin Hait158e7dc2019-01-04 11:04:37 +0530586 stock_uom: item.stock_uom,
Saqibcdc99cd2021-05-03 11:54:55 +0530587 pos_profile: cint(me.frm.doc.is_pos) ? me.frm.doc.pos_profile : '',
Saif Ur Rehman67786682018-12-27 02:11:07 +0500588 cost_center: item.cost_center,
589 tax_category: me.frm.doc.tax_category,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530590 item_tax_template: item.item_tax_template,
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530591 child_docname: item.name
Nabin Hait139dc7b2014-02-12 14:53:18 +0530592 }
593 },
Anand Doshi13945092014-09-21 19:45:49 +0530594
Nabin Hait139dc7b2014-02-12 14:53:18 +0530595 callback: function(r) {
596 if(!r.exc) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530597 frappe.run_serially([
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500598 () => {
599 var d = locals[cdt][cdn];
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +0500600 me.add_taxes_from_item_tax_template(d.item_tax_rate);
Rohit Waghchaure2ae79b82019-12-18 17:48:39 +0530601 if (d.free_item_data) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +0530602 me.apply_product_discount(d);
Rohit Waghchaure2ae79b82019-12-18 17:48:39 +0530603 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500604 },
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530605 () => {
606 // for internal customer instead of pricing rule directly apply valuation rate on item
607 if (me.frm.doc.is_internal_customer || me.frm.doc.is_internal_supplier) {
608 me.get_incoming_rate(item, me.frm.posting_date, me.frm.posting_time,
609 me.frm.doc.doctype, me.frm.doc.company);
610 } else {
611 me.frm.script_manager.trigger("price_list_rate", cdt, cdn);
612 }
613 },
614 () => {
615 if (me.frm.doc.is_internal_customer || me.frm.doc.is_internal_supplier) {
616 me.calculate_taxes_and_totals();
617 }
618 },
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530619 () => me.toggle_conversion_factor(item),
620 () => {
Saqibfaea8542020-03-26 13:18:57 +0530621 if (show_batch_dialog)
622 return frappe.db.get_value("Item", item.item_code, ["has_batch_no", "has_serial_no"])
623 .then((r) => {
Rohit Waghchaureafe8e882020-06-10 17:55:24 +0530624 if (r.message &&
Deepesh Garg16bcd012021-01-28 12:09:35 +0530625 (r.message.has_batch_no || r.message.has_serial_no)) {
Saqibfaea8542020-03-26 13:18:57 +0530626 frappe.flags.hide_serial_batch_dialog = false;
627 }
628 });
629 },
630 () => {
Deepesh Garg16bcd012021-01-28 12:09:35 +0530631 // check if batch serial selector is disabled or not
632 if (show_batch_dialog && !frappe.flags.hide_serial_batch_dialog)
633 return frappe.db.get_single_value('Stock Settings', 'disable_serial_no_and_batch_selector')
634 .then((value) => {
635 if (value) {
636 frappe.flags.hide_serial_batch_dialog = true;
637 }
638 });
639 },
640 () => {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530641 if(show_batch_dialog && !frappe.flags.hide_serial_batch_dialog) {
642 var d = locals[cdt][cdn];
643 $.each(r.message, function(k, v) {
644 if(!d[k]) d[k] = v;
645 });
Rohit Waghchaure6ab63032017-09-01 15:28:44 +0530646
Saqib14cdb242020-04-16 16:21:35 +0530647 if (d.has_batch_no && d.has_serial_no) {
648 d.batch_no = undefined;
649 }
650
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530651 erpnext.show_serial_batch_selector(me.frm, d, (item) => {
652 me.frm.script_manager.trigger('qty', item.doctype, item.name);
Saqibfaea8542020-03-26 13:18:57 +0530653 if (!me.frm.doc.set_warehouse)
654 me.frm.script_manager.trigger('warehouse', item.doctype, item.name);
Alan72c081f2021-09-28 12:56:26 +0530655 me.apply_price_list(item, true);
Saqibfaea8542020-03-26 13:18:57 +0530656 }, undefined, !frappe.flags.hide_serial_batch_dialog);
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530657 }
658 },
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530659 () => me.conversion_factor(doc, cdt, cdn, true),
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +0530660 () => me.remove_pricing_rule(item),
661 () => {
662 if (item.apply_rule_on_other_items) {
663 let key = item.name;
664 me.apply_rule_on_other_items({key: item});
665 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +0530666 },
667 () => {
668 var company_currency = me.get_company_currency();
669 me.update_item_grid_labels(company_currency);
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +0530670 }
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530671 ]);
Nabin Hait139dc7b2014-02-12 14:53:18 +0530672 }
673 }
674 });
675 }
676 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530677 }
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530678
Faris Ansari1fe891b2021-04-23 08:04:00 +0530679 price_list_rate(doc, cdt, cdn) {
Anupam Kumared42afc2021-03-15 11:11:28 +0530680 var item = frappe.get_doc(cdt, cdn);
681 frappe.model.round_floats_in(item, ["price_list_rate", "discount_percentage"]);
682
Deepesh Garg2d0208b2021-12-22 12:01:39 +0530683 // check if child doctype is Sales Order Item/Quotation Item and calculate the rate
Anupam Kumared42afc2021-03-15 11:11:28 +0530684 if (in_list(["Quotation Item", "Sales Order Item", "Delivery Note Item", "Sales Invoice Item", "POS Invoice Item", "Purchase Invoice Item", "Purchase Order Item", "Purchase Receipt Item"]), cdt)
685 this.apply_pricing_rule_on_item(item);
686 else
687 item.rate = flt(item.price_list_rate * (1 - item.discount_percentage / 100.0),
688 precision("rate", item));
689
690 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +0530691 }
Anupam Kumared42afc2021-03-15 11:11:28 +0530692
Faris Ansari1fe891b2021-04-23 08:04:00 +0530693 margin_rate_or_amount(doc, cdt, cdn) {
Anupam Kumared42afc2021-03-15 11:11:28 +0530694 // calculated the revised total margin and rate on margin rate changes
695 let item = frappe.get_doc(cdt, cdn);
696 this.apply_pricing_rule_on_item(item);
697 this.calculate_taxes_and_totals();
698 cur_frm.refresh_fields();
Faris Ansari1fe891b2021-04-23 08:04:00 +0530699 }
Anupam Kumared42afc2021-03-15 11:11:28 +0530700
Faris Ansari1fe891b2021-04-23 08:04:00 +0530701 margin_type(doc, cdt, cdn) {
Anupam Kumared42afc2021-03-15 11:11:28 +0530702 // calculate the revised total margin and rate on margin type changes
703 let item = frappe.get_doc(cdt, cdn);
704 if (!item.margin_type) {
705 frappe.model.set_value(cdt, cdn, "margin_rate_or_amount", 0);
706 } else {
707 this.apply_pricing_rule_on_item(item, doc, cdt, cdn);
708 this.calculate_taxes_and_totals();
709 cur_frm.refresh_fields();
710 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530711 }
Anupam Kumared42afc2021-03-15 11:11:28 +0530712
Faris Ansari1fe891b2021-04-23 08:04:00 +0530713 get_incoming_rate(item, posting_date, posting_time, voucher_type, company) {
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530714
715 let item_args = {
716 'item_code': item.item_code,
717 'warehouse': in_list('Purchase Receipt', 'Purchase Invoice') ? item.from_warehouse : item.warehouse,
718 'posting_date': posting_date,
719 'posting_time': posting_time,
720 'qty': item.qty * item.conversion_factor,
721 'serial_no': item.serial_no,
Ankush Menat342d09a2022-02-19 14:28:51 +0530722 'batch_no': item.batch_no,
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530723 'voucher_type': voucher_type,
724 'company': company,
725 'allow_zero_valuation_rate': item.allow_zero_valuation_rate
726 }
727
728 frappe.call({
729 method: 'erpnext.stock.utils.get_incoming_rate',
730 args: {
731 args: item_args
732 },
733 callback: function(r) {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530734 frappe.model.set_value(item.doctype, item.name, 'rate', r.message * item.conversion_factor);
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530735 }
736 });
Faris Ansari1fe891b2021-04-23 08:04:00 +0530737 }
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530738
Faris Ansari1fe891b2021-04-23 08:04:00 +0530739 add_taxes_from_item_tax_template(item_tax_map) {
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500740 let me = this;
741
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +0500742 if(item_tax_map && cint(frappe.defaults.get_default("add_taxes_from_item_tax_template"))) {
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500743 if(typeof (item_tax_map) == "string") {
744 item_tax_map = JSON.parse(item_tax_map);
745 }
746
747 $.each(item_tax_map, function(tax, rate) {
748 let found = (me.frm.doc.taxes || []).find(d => d.account_head === tax);
749 if(!found) {
750 let child = frappe.model.add_child(me.frm.doc, "taxes");
751 child.charge_type = "On Net Total";
752 child.account_head = tax;
Saqib7d9dd3c2020-10-28 17:07:10 +0530753 child.rate = 0;
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500754 }
755 });
756 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530757 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500758
Faris Ansari1fe891b2021-04-23 08:04:00 +0530759 serial_no(doc, cdt, cdn) {
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530760 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530761 var item = frappe.get_doc(cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530762
Rohit Waghchaure6bbc8ec2021-06-08 10:36:39 +0530763 if (item && item.doctype === 'Purchase Receipt Item Supplied') {
764 return;
765 }
766
deepeshgarg00749cca7a2019-01-25 16:41:01 +0530767 if (item && item.serial_no) {
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530768 if (!item.item_code) {
Rushabh Mehtab66edd12017-03-30 21:21:56 +0530769 this.frm.trigger("item_code", cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530770 }
771 else {
marinationeecfc4c2021-07-22 13:23:54 +0530772 // Replace all occurences of comma with line feed
Jannat Patel12f09232021-03-23 21:09:49 +0530773 item.serial_no = item.serial_no.replace(/,/g, '\n');
marinatione05013e2020-04-06 22:13:13 +0530774 item.conversion_factor = item.conversion_factor || 1;
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530775 refresh_field("serial_no", item.name, item.parentfield);
Jannat Pateld9fa79d2021-04-08 16:04:57 +0530776 if (!doc.is_return && cint(frappe.user_defaults.set_qty_in_transactions_based_on_serial_no_input)) {
777 setTimeout(() => {
778 me.update_qty(cdt, cdn);
779 }, 10000);
Nabin Haitb7c0c552015-08-04 12:18:12 +0530780 }
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530781 }
782 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530783 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530784
Faris Ansari69eb6d42021-05-07 15:21:33 +0530785 update_qty(cdt, cdn) {
Jannat Pateld9fa79d2021-04-08 16:04:57 +0530786 var valid_serial_nos = [];
787 var serialnos = [];
788 var item = frappe.get_doc(cdt, cdn);
789 serialnos = item.serial_no.split("\n");
790 for (var i = 0; i < serialnos.length; i++) {
791 if (serialnos[i] != "") {
792 valid_serial_nos.push(serialnos[i]);
793 }
794 }
795 frappe.model.set_value(item.doctype, item.name,
796 "qty", valid_serial_nos.length / item.conversion_factor);
797 frappe.model.set_value(item.doctype, item.name, "stock_qty", valid_serial_nos.length);
Faris Ansari69eb6d42021-05-07 15:21:33 +0530798 }
Jannat Pateld9fa79d2021-04-08 16:04:57 +0530799
Faris Ansari1fe891b2021-04-23 08:04:00 +0530800 validate() {
Anand Doshi652bc072014-04-16 15:21:46 +0530801 this.calculate_taxes_and_totals(false);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530802 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530803
Faris Ansari1fe891b2021-04-23 08:04:00 +0530804 update_stock() {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530805 this.frm.trigger('set_default_internal_warehouse');
Faris Ansari1fe891b2021-04-23 08:04:00 +0530806 }
Deepesh Gargb4be2922021-01-28 13:09:56 +0530807
Faris Ansari1fe891b2021-04-23 08:04:00 +0530808 set_default_internal_warehouse() {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530809 let me = this;
810 if ((this.frm.doc.doctype === 'Sales Invoice' && me.frm.doc.update_stock)
811 || this.frm.doc.doctype == 'Delivery Note') {
812 if (this.frm.doc.is_internal_customer && this.frm.doc.company === this.frm.doc.represents_company) {
813 frappe.db.get_value('Company', this.frm.doc.company, 'default_in_transit_warehouse', function(value) {
814 me.frm.set_value('set_target_warehouse', value.default_in_transit_warehouse);
815 });
816 }
817 }
818
819 if ((this.frm.doc.doctype === 'Purchase Invoice' && me.frm.doc.update_stock)
820 || this.frm.doc.doctype == 'Purchase Receipt') {
821 if (this.frm.doc.is_internal_supplier && this.frm.doc.company === this.frm.doc.represents_company) {
822 frappe.db.get_value('Company', this.frm.doc.company, 'default_in_transit_warehouse', function(value) {
823 me.frm.set_value('set_from_warehouse', value.default_in_transit_warehouse);
824 });
825 }
826 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530827 }
Deepesh Gargb4be2922021-01-28 13:09:56 +0530828
Faris Ansari1fe891b2021-04-23 08:04:00 +0530829 company() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530830 var me = this;
Nabin Haita731ad42016-02-04 17:21:28 +0530831 var set_pricing = function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530832 if(me.frm.doc.company && me.frm.fields_dict.currency) {
833 var company_currency = me.get_company_currency();
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530834 var company_doc = frappe.get_doc(":Company", me.frm.doc.company);
tundebabzy5510d072017-09-29 10:51:59 +0100835
Nabin Hait1f10d692017-10-02 13:20:51 +0530836 if (!me.frm.doc.currency) {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530837 me.frm.set_value("currency", company_currency);
838 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530839
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530840 if (me.frm.doc.currency == company_currency) {
841 me.frm.set_value("conversion_rate", 1.0);
842 }
843 if (me.frm.doc.price_list_currency == company_currency) {
844 me.frm.set_value('plc_conversion_rate', 1.0);
845 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530846 if (company_doc.default_letter_head) {
Rushabh Mehtac1857342015-05-27 12:29:57 +0530847 if(me.frm.fields_dict.letter_head) {
848 me.frm.set_value("letter_head", company_doc.default_letter_head);
849 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530850 }
karthikeyan57fc60212019-07-04 22:46:16 +0530851 let selling_doctypes_for_tc = ["Sales Invoice", "Quotation", "Sales Order", "Delivery Note"];
852 if (company_doc.default_selling_terms && frappe.meta.has_field(me.frm.doc.doctype, "tc_name") &&
853 selling_doctypes_for_tc.indexOf(me.frm.doc.doctype) != -1) {
854 me.frm.set_value("tc_name", company_doc.default_selling_terms);
855 }
856 let buying_doctypes_for_tc = ["Request for Quotation", "Supplier Quotation", "Purchase Order",
857 "Material Request", "Purchase Receipt"];
858 // Purchase Invoice is excluded as per issue #3345
859 if (company_doc.default_buying_terms && frappe.meta.has_field(me.frm.doc.doctype, "tc_name") &&
860 buying_doctypes_for_tc.indexOf(me.frm.doc.doctype) != -1) {
861 me.frm.set_value("tc_name", company_doc.default_buying_terms);
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530862 }
Akhilesh Darjee1797cfe2013-10-11 13:34:10 +0530863
rohitwaghchaure505661b2017-12-11 14:52:28 +0530864 frappe.run_serially([
865 () => me.frm.script_manager.trigger("currency"),
Deepesh Garg9ab18b52021-07-21 23:15:15 +0530866 () => me.update_item_tax_map(),
rohitwaghchaure505661b2017-12-11 14:52:28 +0530867 () => me.apply_default_taxes(),
Deepesh Garg9ab18b52021-07-21 23:15:15 +0530868 () => me.apply_pricing_rule()
rohitwaghchaure505661b2017-12-11 14:52:28 +0530869 ]);
Nabin Haitdd38a262014-12-26 13:15:21 +0530870 }
Anand Doshi3543f302013-05-24 19:25:01 +0530871 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530872
Nabin Haita731ad42016-02-04 17:21:28 +0530873 var set_party_account = function(set_pricing) {
874 if (in_list(["Sales Invoice", "Purchase Invoice"], me.frm.doc.doctype)) {
875 if(me.frm.doc.doctype=="Sales Invoice") {
876 var party_type = "Customer";
877 var party_account_field = 'debit_to';
878 } else {
879 var party_type = "Supplier";
880 var party_account_field = 'credit_to';
881 }
Anand Doshi39a28912016-02-15 11:42:18 +0530882
Nabin Haitef864402016-02-10 14:47:25 +0530883 var party = me.frm.doc[frappe.model.scrub(party_type)];
Faris Ansarif7717b92018-02-08 11:09:54 +0530884 if(party && me.frm.doc.company) {
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530885 return frappe.call({
886 method: "erpnext.accounts.party.get_party_account",
887 args: {
888 company: me.frm.doc.company,
889 party_type: party_type,
Nabin Haitef864402016-02-10 14:47:25 +0530890 party: party
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530891 },
892 callback: function(r) {
893 if(!r.exc && r.message) {
894 me.frm.set_value(party_account_field, r.message);
895 set_pricing();
896 }
Nabin Haita731ad42016-02-04 17:21:28 +0530897 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530898 });
Nabin Haitef864402016-02-10 14:47:25 +0530899 } else {
900 set_pricing();
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530901 }
Nabin Haita731ad42016-02-04 17:21:28 +0530902 } else {
903 set_pricing();
904 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530905
Nabin Haita731ad42016-02-04 17:21:28 +0530906 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530907
Rushabh Mehta5dfe20c2016-04-26 12:59:08 +0530908 if (frappe.meta.get_docfield(this.frm.doctype, "shipping_address") &&
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530909 in_list(['Purchase Order', 'Purchase Receipt', 'Purchase Invoice'], this.frm.doctype)) {
Deepesh Gargfd467e62021-08-30 17:53:59 +0530910 erpnext.utils.get_shipping_address(this.frm, function() {
Faris Ansariab74ca72017-05-30 12:54:42 +0530911 set_party_account(set_pricing);
Deepesh Gargb4be2922021-01-28 13:09:56 +0530912 });
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530913
914 // Get default company billing address in Purchase Invoice, Order and Receipt
Deepesh Gargfd467e62021-08-30 17:53:59 +0530915 if (this.frm.doc.company && frappe.meta.get_docfield(this.frm.doctype, "billing_address")) {
916 frappe.call({
917 method: "erpnext.setup.doctype.company.company.get_default_company_address",
918 args: {name: this.frm.doc.company, existing_address: this.frm.doc.billing_address || ""},
919 debounce: 2000,
920 callback: function(r) {
921 if (r.message) {
922 me.frm.set_value("billing_address", r.message);
923 } else {
Frappe PR Bot4f7af792021-09-18 13:34:27 +0530924 if (frappe.meta.get_docfield(me.frm.doctype, 'company_address')) {
925 me.frm.set_value("company_address", "");
926 }
Deepesh Gargfd467e62021-08-30 17:53:59 +0530927 }
928 }
929 });
930 }
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530931
Faris Ansariab74ca72017-05-30 12:54:42 +0530932 } else {
Rohit Waghchaureb2e7a1f2016-04-11 12:10:20 +0530933 set_party_account(set_pricing);
934 }
Rushabh Mehta45ca8a42015-04-28 16:02:09 +0530935
936 if(this.frm.doc.company) {
937 erpnext.last_selected_company = this.frm.doc.company;
938 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530939 }
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530940
Faris Ansari1fe891b2021-04-23 08:04:00 +0530941 transaction_date() {
Anand Doshi87da6622015-10-19 14:59:32 +0530942 if (this.frm.doc.transaction_date) {
943 this.frm.transaction_date = this.frm.doc.transaction_date;
Nabin Hait288a18e2016-12-08 15:36:23 +0530944 frappe.ui.form.trigger(this.frm.doc.doctype, "currency");
Anand Doshi87da6622015-10-19 14:59:32 +0530945 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530946 }
Neil Trini Lasrado78fa6952014-10-03 17:43:02 +0530947
Faris Ansari1fe891b2021-04-23 08:04:00 +0530948 posting_date() {
Nabin Hait40e92b62015-07-09 17:12:23 +0530949 var me = this;
950 if (this.frm.doc.posting_date) {
Anand Doshi87da6622015-10-19 14:59:32 +0530951 this.frm.posting_date = this.frm.doc.posting_date;
952
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530953 if ((this.frm.doc.doctype == "Sales Invoice" && this.frm.doc.customer) ||
Nabin Hait40e92b62015-07-09 17:12:23 +0530954 (this.frm.doc.doctype == "Purchase Invoice" && this.frm.doc.supplier)) {
955 return frappe.call({
956 method: "erpnext.accounts.party.get_due_date",
957 args: {
958 "posting_date": me.frm.doc.posting_date,
959 "party_type": me.frm.doc.doctype == "Sales Invoice" ? "Customer" : "Supplier",
Shreya Shah3a9eec22018-02-16 13:05:21 +0530960 "bill_date": me.frm.doc.bill_date,
Nabin Hait40e92b62015-07-09 17:12:23 +0530961 "party": me.frm.doc.doctype == "Sales Invoice" ? me.frm.doc.customer : me.frm.doc.supplier,
962 "company": me.frm.doc.company
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530963 },
Nabin Hait40e92b62015-07-09 17:12:23 +0530964 callback: function(r, rt) {
965 if(r.message) {
Nabin Haitcfa9d1a2018-01-29 16:07:21 +0530966 me.frm.doc.due_date = r.message;
967 refresh_field("due_date");
Nabin Hait87d70272016-12-08 14:43:11 +0530968 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
tundebabzy650a1ee2018-01-02 07:32:30 +0100969 me.recalculate_terms();
Nabin Hait40e92b62015-07-09 17:12:23 +0530970 }
Nabin Hait40e92b62015-07-09 17:12:23 +0530971 }
972 })
Nabin Hait87d70272016-12-08 14:43:11 +0530973 } else {
974 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
Nabin Hait40e92b62015-07-09 17:12:23 +0530975 }
976 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530977 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530978
Faris Ansari1fe891b2021-04-23 08:04:00 +0530979 due_date() {
tundebabzyda221672018-01-09 06:28:44 +0100980 // due_date is to be changed, payment terms template and/or payment schedule must
981 // be removed as due_date is automatically changed based on payment terms
rohitwaghchaure52beb772018-01-29 17:40:44 +0530982 if (this.frm.doc.due_date && !this.frm.updating_party_details && !this.frm.doc.is_pos) {
Saurabh3959aeb2018-01-23 15:40:29 +0530983 if (this.frm.doc.payment_terms_template ||
984 (this.frm.doc.payment_schedule && this.frm.doc.payment_schedule.length)) {
tundebabzyda221672018-01-09 06:28:44 +0100985 var message1 = "";
986 var message2 = "";
Ankush Menatff96bdf2021-05-25 19:54:40 +0530987 var final_message = __("Please clear the") + " ";
tundebabzyda221672018-01-09 06:28:44 +0100988
989 if (this.frm.doc.payment_terms_template) {
Ankush Menatff96bdf2021-05-25 19:54:40 +0530990 message1 = __("selected Payment Terms Template");
tundebabzyda221672018-01-09 06:28:44 +0100991 final_message = final_message + message1;
992 }
993
Nabin Hait2bfa1802018-01-17 14:39:05 +0530994 if ((this.frm.doc.payment_schedule || []).length) {
Ankush Menatff96bdf2021-05-25 19:54:40 +0530995 message2 = __("Payment Schedule Table");
tundebabzyda221672018-01-09 06:28:44 +0100996 if (message1.length !== 0) message2 = " and " + message2;
997 final_message = final_message + message2;
998 }
tundebabzyda221672018-01-09 06:28:44 +0100999 frappe.msgprint(final_message);
1000 }
Nabin Haitcfa9d1a2018-01-29 16:07:21 +05301001 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301002 }
tundebabzyda221672018-01-09 06:28:44 +01001003
Faris Ansari1fe891b2021-04-23 08:04:00 +05301004 bill_date() {
Shreya Shah3a9eec22018-02-16 13:05:21 +05301005 this.posting_date();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301006 }
Shreya Shah3a9eec22018-02-16 13:05:21 +05301007
Faris Ansari1fe891b2021-04-23 08:04:00 +05301008 recalculate_terms() {
tundebabzy650a1ee2018-01-02 07:32:30 +01001009 const doc = this.frm.doc;
tundebabzy650a1ee2018-01-02 07:32:30 +01001010 if (doc.payment_terms_template) {
1011 this.payment_terms_template();
1012 } else if (doc.payment_schedule) {
1013 const me = this;
tundebabzy650a1ee2018-01-02 07:32:30 +01001014 doc.payment_schedule.forEach(
1015 function(term) {
1016 if (term.payment_term) {
1017 me.payment_term(doc, term.doctype, term.name);
1018 } else {
1019 frappe.model.set_value(
1020 term.doctype, term.name, 'due_date',
1021 doc.posting_date || doc.transaction_date
1022 );
1023 }
1024 }
1025 );
1026 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301027 }
tundebabzy650a1ee2018-01-02 07:32:30 +01001028
Faris Ansari1fe891b2021-04-23 08:04:00 +05301029 get_company_currency() {
Anand Doshi3543f302013-05-24 19:25:01 +05301030 return erpnext.get_currency(this.frm.doc.company);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301031 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +05301032
Faris Ansari1fe891b2021-04-23 08:04:00 +05301033 contact_person() {
Neil Trini Lasrado09a66c42015-07-07 16:41:37 +05301034 erpnext.utils.get_contact_details(this.frm);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301035 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301036
Faris Ansari1fe891b2021-04-23 08:04:00 +05301037 currency() {
Chude Osiegbu256ec172016-09-19 03:53:37 +01001038 /* manqala 19/09/2016: let the translation date be whichever of the transaction_date or posting_date is available */
Nabin Hait288a18e2016-12-08 15:36:23 +05301039 var transaction_date = this.frm.doc.transaction_date || this.frm.doc.posting_date;
Chude Osiegbu256ec172016-09-19 03:53:37 +01001040 /* end manqala */
Anand Doshi61a2f682013-06-21 17:55:31 +05301041 var me = this;
1042 this.set_dynamic_labels();
Anand Doshi61a2f682013-06-21 17:55:31 +05301043 var company_currency = this.get_company_currency();
Nabin Hait69cdf592015-05-02 18:46:10 +05301044 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
Rushabh Mehta76b13412016-07-18 14:30:18 +05301045 if(this.frm.doc.currency && this.frm.doc.currency !== company_currency
Nabin Hait39505072016-07-07 11:11:32 +05301046 && !this.frm.doc.ignore_pricing_rule) {
Shreya0db85062018-05-15 11:25:46 +05301047
Nabin Hait288a18e2016-12-08 15:36:23 +05301048 this.get_exchange_rate(transaction_date, this.frm.doc.currency, company_currency,
Anand Doshi61a2f682013-06-21 17:55:31 +05301049 function(exchange_rate) {
Nabin Haitaafd64d2019-05-27 17:15:47 +05301050 if(exchange_rate != me.frm.doc.conversion_rate) {
1051 me.set_margin_amount_based_on_currency(exchange_rate);
1052 me.set_actual_charges_based_on_currency(exchange_rate);
1053 me.frm.set_value("conversion_rate", exchange_rate);
1054 }
Anand Doshi61a2f682013-06-21 17:55:31 +05301055 });
1056 } else {
Rushabh Mehtaff938022014-04-15 18:40:00 +05301057 this.conversion_rate();
Anand Doshi61a2f682013-06-21 17:55:31 +05301058 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301059 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301060
Faris Ansari1fe891b2021-04-23 08:04:00 +05301061 conversion_rate() {
tundebabzyab5b0302017-09-21 10:20:39 +01001062 const me = this.frm;
Anand Doshi535d8332013-07-19 13:51:07 +05301063 if(this.frm.doc.currency === this.get_company_currency()) {
1064 this.frm.set_value("conversion_rate", 1.0);
Akhilesh Darjeeacf65a72013-10-17 13:04:26 +05301065 }
1066 if(this.frm.doc.currency === this.frm.doc.price_list_currency &&
Anand Doshi61a2f682013-06-21 17:55:31 +05301067 this.frm.doc.plc_conversion_rate !== this.frm.doc.conversion_rate) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301068 this.frm.set_value("plc_conversion_rate", this.frm.doc.conversion_rate);
Anand Doshi61a2f682013-06-21 17:55:31 +05301069 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +05301070
Nabin Haita3dd72a2014-05-28 12:49:20 +05301071 if(flt(this.frm.doc.conversion_rate)>0.0) {
Nabin Hait444f9562014-06-20 15:59:49 +05301072 if(this.frm.doc.ignore_pricing_rule) {
1073 this.calculate_taxes_and_totals();
Anand Doshi51f722d2014-07-04 15:44:26 +05301074 } else if (!this.in_apply_price_list){
1075 this.apply_price_list();
Nabin Hait444f9562014-06-20 15:59:49 +05301076 }
1077
Nabin Haita3dd72a2014-05-28 12:49:20 +05301078 }
tundebabzyab5b0302017-09-21 10:20:39 +01001079 // Make read only if Accounts Settings doesn't allow stale rates
tundebabzybc7c3872017-11-28 18:10:05 +01001080 this.frm.set_df_property("conversion_rate", "read_only", erpnext.stale_rate_allowed() ? 0 : 1);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301081 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301082
Faris Ansari1fe891b2021-04-23 08:04:00 +05301083 shipping_rule() {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301084 var me = this;
marination0c722492020-06-03 14:32:07 +05301085 if(this.frm.doc.shipping_rule) {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301086 return this.frm.call({
1087 doc: this.frm.doc,
1088 method: "apply_shipping_rule",
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301089 }).fail(() => this.frm.set_value('shipping_rule', ''));
1090 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301091 }
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301092
Faris Ansari1fe891b2021-04-23 08:04:00 +05301093 set_margin_amount_based_on_currency(exchange_rate) {
Anupam Kumared42afc2021-03-15 11:11:28 +05301094 if (in_list(["Quotation", "Sales Order", "Delivery Note", "Sales Invoice", "Purchase Invoice", "Purchase Order", "Purchase Receipt"]), this.frm.doc.doctype) {
Nabin Haitaafd64d2019-05-27 17:15:47 +05301095 var me = this;
1096 $.each(this.frm.doc.items || [], function(i, d) {
1097 if(d.margin_type == "Amount") {
1098 frappe.model.set_value(d.doctype, d.name, "margin_rate_or_amount",
1099 flt(d.margin_rate_or_amount) / flt(exchange_rate));
1100 }
1101 });
1102 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301103 }
Nabin Haitaafd64d2019-05-27 17:15:47 +05301104
Faris Ansari1fe891b2021-04-23 08:04:00 +05301105 set_actual_charges_based_on_currency(exchange_rate) {
Nabin Haita9c9b692017-08-31 19:40:09 +05301106 var me = this;
1107 $.each(this.frm.doc.taxes || [], function(i, d) {
1108 if(d.charge_type == "Actual") {
1109 frappe.model.set_value(d.doctype, d.name, "tax_amount",
Saqib48896612021-12-02 11:37:08 +05301110 flt(d.base_tax_amount) / flt(exchange_rate));
Nabin Haita9c9b692017-08-31 19:40:09 +05301111 }
1112 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301113 }
Nabin Haita9c9b692017-08-31 19:40:09 +05301114
Faris Ansari1fe891b2021-04-23 08:04:00 +05301115 get_exchange_rate(transaction_date, from_currency, to_currency, callback) {
Shreya3f778522018-05-15 16:59:20 +05301116 var args;
1117 if (["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"].includes(this.frm.doctype)) {
1118 args = "for_selling";
Shreya0db85062018-05-15 11:25:46 +05301119 }
Shreya3f778522018-05-15 16:59:20 +05301120 else if (["Purchase Order", "Purchase Receipt", "Purchase Invoice"].includes(this.frm.doctype)) {
1121 args = "for_buying";
1122 }
1123
Nabin Hait17179ee2017-05-06 13:23:12 +05301124 if (!transaction_date || !from_currency || !to_currency) return;
Nabin Haitbdfb0702015-10-28 15:38:08 +05301125 return frappe.call({
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301126 method: "erpnext.setup.utils.get_exchange_rate",
1127 args: {
Nabin Hait288a18e2016-12-08 15:36:23 +05301128 transaction_date: transaction_date,
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301129 from_currency: from_currency,
Shreya0db85062018-05-15 11:25:46 +05301130 to_currency: to_currency,
1131 args: args
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301132 },
Maricae8bc9122021-04-19 11:05:21 +05301133 freeze: true,
1134 freeze_message: __("Fetching exchange rates ..."),
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301135 callback: function(r) {
1136 callback(flt(r.message));
1137 }
Anand Doshi61a2f682013-06-21 17:55:31 +05301138 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301139 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301140
Faris Ansari1fe891b2021-04-23 08:04:00 +05301141 price_list_currency() {
Akhilesh Darjeedb59ffb2013-09-11 13:05:24 +05301142 var me=this;
Anand Doshi3543f302013-05-24 19:25:01 +05301143 this.set_dynamic_labels();
Nabin Haitec361ea2015-05-11 18:14:45 +05301144
1145 var company_currency = this.get_company_currency();
1146 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
1147 if(this.frm.doc.price_list_currency !== company_currency && !this.frm.doc.ignore_pricing_rule) {
Chude Osiegbufbf27b52016-09-07 03:06:08 +01001148 this.get_exchange_rate(this.frm.doc.posting_date, this.frm.doc.price_list_currency, company_currency,
Nabin Haitec361ea2015-05-11 18:14:45 +05301149 function(exchange_rate) {
1150 me.frm.set_value("plc_conversion_rate", exchange_rate);
1151 });
1152 } else {
1153 this.plc_conversion_rate();
1154 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301155 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301156
Faris Ansari1fe891b2021-04-23 08:04:00 +05301157 plc_conversion_rate() {
Anand Doshi61a2f682013-06-21 17:55:31 +05301158 if(this.frm.doc.price_list_currency === this.get_company_currency()) {
1159 this.frm.set_value("plc_conversion_rate", 1.0);
Rushabh Mehtaa208c562015-08-03 13:18:54 +05301160 } else if(this.frm.doc.price_list_currency === this.frm.doc.currency
Nabin Hait1d218422015-07-17 15:19:02 +05301161 && this.frm.doc.plc_conversion_rate && cint(this.frm.doc.plc_conversion_rate) != 1 &&
Nabin Haitec361ea2015-05-11 18:14:45 +05301162 cint(this.frm.doc.plc_conversion_rate) != cint(this.frm.doc.conversion_rate)) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301163 this.frm.set_value("conversion_rate", this.frm.doc.plc_conversion_rate);
Akhilesh Darjee564c6212013-10-17 11:31:11 +05301164 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +05301165
Nabin Haitec361ea2015-05-11 18:14:45 +05301166 if(!this.in_apply_price_list) {
tundebabzy6e90f492018-02-12 10:48:57 +01001167 this.apply_price_list(null, true);
Anand Doshi61a2f682013-06-21 17:55:31 +05301168 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301169 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301170
Faris Ansari1fe891b2021-04-23 08:04:00 +05301171 uom(doc, cdt, cdn) {
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301172 var me = this;
1173 var item = frappe.get_doc(cdt, cdn);
1174 if(item.item_code && item.uom) {
1175 return this.frm.call({
1176 method: "erpnext.stock.get_item_details.get_conversion_factor",
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301177 args: {
1178 item_code: item.item_code,
1179 uom: item.uom
1180 },
1181 callback: function(r) {
1182 if(!r.exc) {
Saqib60212ff2020-10-26 11:17:04 +05301183 frappe.model.set_value(cdt, cdn, 'conversion_factor', r.message.conversion_factor);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301184 }
1185 }
1186 });
1187 }
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301188 me.calculate_stock_uom_rate(doc, cdt, cdn);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301189 }
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301190
Faris Ansari1fe891b2021-04-23 08:04:00 +05301191 conversion_factor(doc, cdt, cdn, dont_fetch_price_list_rate) {
marinatione1439832020-02-18 10:51:54 +05301192 if(frappe.meta.get_docfield(cdt, "stock_qty", cdn)) {
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301193 var item = frappe.get_doc(cdt, cdn);
1194 frappe.model.round_floats_in(item, ["qty", "conversion_factor"]);
1195 item.stock_qty = flt(item.qty * item.conversion_factor, precision("stock_qty", item));
1196 refresh_field("stock_qty", item.name, item.parentfield);
mbauskar287fe812017-04-10 19:15:57 +05301197 this.toggle_conversion_factor(item);
marinatione1439832020-02-18 10:51:54 +05301198
1199 if(doc.doctype != "Material Request") {
1200 item.total_weight = flt(item.stock_qty * item.weight_per_unit);
1201 refresh_field("total_weight", item.name, item.parentfield);
1202 this.calculate_net_weight();
1203 }
1204
Anupam Kumar1033cf72021-03-31 19:39:45 +05301205 // for handling customization not to fetch price list rate
1206 if(frappe.flags.dont_fetch_price_list_rate) {
1207 return
1208 }
1209
rohitwaghchauree8ccc0e2017-11-21 16:17:22 +05301210 if (!dont_fetch_price_list_rate &&
1211 frappe.meta.has_field(doc.doctype, "price_list_currency")) {
1212 this.apply_price_list(item, true);
1213 }
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301214 this.calculate_stock_uom_rate(doc, cdt, cdn);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301215 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301216 }
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301217
Faris Ansari1fe891b2021-04-23 08:04:00 +05301218 batch_no(doc, cdt, cdn) {
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301219 let item = frappe.get_doc(cdt, cdn);
1220 this.apply_price_list(item, true);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301221 }
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301222
Faris Ansari1fe891b2021-04-23 08:04:00 +05301223 toggle_conversion_factor(item) {
mbauskar287fe812017-04-10 19:15:57 +05301224 // toggle read only property for conversion factor field if the uom and stock uom are same
Rushabh Mehta36311022017-06-20 09:30:53 +05301225 if(this.frm.get_field('items').grid.fields_map.conversion_factor) {
1226 this.frm.fields_dict.items.grid.toggle_enable("conversion_factor",
Javier Wong24690952017-12-29 16:36:47 +08001227 ((item.uom != item.stock_uom) && !frappe.meta.get_docfield(cur_frm.fields_dict.items.grid.doctype, "conversion_factor").read_only)? true: false);
Rushabh Mehta36311022017-06-20 09:30:53 +05301228 }
Vishal Dhayaguded3770182017-12-14 18:06:02 +05301229
Faris Ansari1fe891b2021-04-23 08:04:00 +05301230 }
mbauskar287fe812017-04-10 19:15:57 +05301231
Faris Ansari1fe891b2021-04-23 08:04:00 +05301232 qty(doc, cdt, cdn) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301233 let item = frappe.get_doc(cdt, cdn);
Nabin Hait50cb49c2020-01-21 13:04:21 +05301234 this.conversion_factor(doc, cdt, cdn, true);
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301235 this.calculate_stock_uom_rate(doc, cdt, cdn);
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301236 this.apply_pricing_rule(item, true);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301237 }
Vishal Dhayaguded42242d2017-11-29 16:09:59 +05301238
Faris Ansari1fe891b2021-04-23 08:04:00 +05301239 calculate_stock_uom_rate(doc, cdt, cdn) {
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301240 let item = frappe.get_doc(cdt, cdn);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301241 item.stock_uom_rate = flt(item.rate)/flt(item.conversion_factor);
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301242 refresh_field("stock_uom_rate", item.name, item.parentfield);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301243 }
1244 service_stop_date(frm, cdt, cdn) {
Zarrare83ff382018-09-21 15:45:40 +05301245 var child = locals[cdt][cdn];
1246
1247 if(child.service_stop_date) {
1248 let start_date = Date.parse(child.service_start_date);
1249 let end_date = Date.parse(child.service_end_date);
1250 let stop_date = Date.parse(child.service_stop_date);
1251
1252 if(stop_date < start_date) {
1253 frappe.model.set_value(cdt, cdn, "service_stop_date", "");
1254 frappe.throw(__("Service Stop Date cannot be before Service Start Date"));
1255 } else if (stop_date > end_date) {
1256 frappe.model.set_value(cdt, cdn, "service_stop_date", "");
1257 frappe.throw(__("Service Stop Date cannot be after Service End Date"));
1258 }
1259 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301260 }
Zarrare83ff382018-09-21 15:45:40 +05301261
Faris Ansari1fe891b2021-04-23 08:04:00 +05301262 service_start_date(frm, cdt, cdn) {
Zarrare83ff382018-09-21 15:45:40 +05301263 var child = locals[cdt][cdn];
1264
1265 if(child.service_start_date) {
1266 frappe.call({
1267 "method": "erpnext.stock.get_item_details.calculate_service_end_date",
1268 args: {"args": child},
1269 callback: function(r) {
1270 frappe.model.set_value(cdt, cdn, "service_end_date", r.message.service_end_date);
1271 }
1272 })
1273 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301274 }
Zarrare83ff382018-09-21 15:45:40 +05301275
Faris Ansari1fe891b2021-04-23 08:04:00 +05301276 calculate_net_weight(){
Vishal Dhayaguded3770182017-12-14 18:06:02 +05301277 /* Calculate Total Net Weight then further applied shipping rule to calculate shipping charges.*/
1278 var me = this;
1279 this.frm.doc.total_net_weight= 0.0;
1280
1281 $.each(this.frm.doc["items"] || [], function(i, item) {
1282 me.frm.doc.total_net_weight += flt(item.total_weight);
1283 });
1284 refresh_field("total_net_weight");
1285 this.shipping_rule();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301286 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301287
Faris Ansari1fe891b2021-04-23 08:04:00 +05301288 set_dynamic_labels() {
Anand Doshi61a2f682013-06-21 17:55:31 +05301289 // What TODO? should we make price list system non-mandatory?
1290 this.frm.toggle_reqd("plc_conversion_rate",
1291 !!(this.frm.doc.price_list_name && this.frm.doc.price_list_currency));
Rushabh Mehtaff938022014-04-15 18:40:00 +05301292
Saif3c9155e2018-10-18 17:27:56 +05001293 var company_currency = this.get_company_currency();
1294 this.change_form_labels(company_currency);
1295 this.change_grid_labels(company_currency);
1296 this.frm.refresh_fields();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301297 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301298
Faris Ansari1fe891b2021-04-23 08:04:00 +05301299 change_form_labels(company_currency) {
Nabin Hait613d0812015-02-23 11:58:15 +05301300 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301301
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301302 this.frm.set_currency_labels(["base_total", "base_net_total", "base_total_taxes_and_charges",
Nabin Hait613d0812015-02-23 11:58:15 +05301303 "base_discount_amount", "base_grand_total", "base_rounded_total", "base_in_words",
1304 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted", "total_amount_to_pay",
Rushabh Mehta6b537922017-03-14 16:59:11 +05301305 "base_paid_amount", "base_write_off_amount", "base_change_amount", "base_operating_cost",
Nabin Hait2e4de832017-09-19 14:53:16 +05301306 "base_raw_material_cost", "base_total_cost", "base_scrap_material_cost",
1307 "base_rounding_adjustment"], company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301308
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301309 this.frm.set_currency_labels(["total", "net_total", "total_taxes_and_charges", "discount_amount",
Nabin Hait613d0812015-02-23 11:58:15 +05301310 "grand_total", "taxes_and_charges_added", "taxes_and_charges_deducted",
Nabin Hait2e4de832017-09-19 14:53:16 +05301311 "rounded_total", "in_words", "paid_amount", "write_off_amount", "operating_cost",
1312 "scrap_material_cost", "rounding_adjustment", "raw_material_cost",
1313 "total_cost"], this.frm.doc.currency);
Anand Doshi87da6622015-10-19 14:59:32 +05301314
Nabin Hait2e4de832017-09-19 14:53:16 +05301315 this.frm.set_currency_labels(["outstanding_amount", "total_advance"],
1316 this.frm.doc.party_account_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301317
1318 cur_frm.set_df_property("conversion_rate", "description", "1 " + this.frm.doc.currency
Nabin Hait2e4de832017-09-19 14:53:16 +05301319 + " = [?] " + company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301320
1321 if(this.frm.doc.price_list_currency && this.frm.doc.price_list_currency!=company_currency) {
Nabin Hait2e4de832017-09-19 14:53:16 +05301322 cur_frm.set_df_property("plc_conversion_rate", "description", "1 "
1323 + this.frm.doc.price_list_currency + " = [?] " + company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301324 }
1325
1326 // toggle fields
Nabin Hait2e4de832017-09-19 14:53:16 +05301327 this.frm.toggle_display(["conversion_rate", "base_total", "base_net_total",
1328 "base_total_taxes_and_charges", "base_taxes_and_charges_added", "base_taxes_and_charges_deducted",
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301329 "base_grand_total", "base_rounded_total", "base_in_words", "base_discount_amount",
Nabin Hait2e4de832017-09-19 14:53:16 +05301330 "base_paid_amount", "base_write_off_amount", "base_operating_cost", "base_raw_material_cost",
1331 "base_total_cost", "base_scrap_material_cost", "base_rounding_adjustment"],
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301332 this.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301333
1334 this.frm.toggle_display(["plc_conversion_rate", "price_list_currency"],
1335 this.frm.doc.price_list_currency != company_currency);
1336
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301337 var show = cint(cur_frm.doc.discount_amount) ||
Nabin Hait903c42a2015-02-24 15:24:49 +05301338 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
1339
1340 if(frappe.meta.get_docfield(cur_frm.doctype, "net_total"))
1341 cur_frm.toggle_display("net_total", show);
1342
1343 if(frappe.meta.get_docfield(cur_frm.doctype, "base_net_total"))
1344 cur_frm.toggle_display("base_net_total", (show && (me.frm.doc.currency != company_currency)));
1345
Faris Ansari1fe891b2021-04-23 08:04:00 +05301346 }
Nabin Hait613d0812015-02-23 11:58:15 +05301347
Faris Ansari1fe891b2021-04-23 08:04:00 +05301348 change_grid_labels(company_currency) {
Nabin Hait613d0812015-02-23 11:58:15 +05301349 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301350
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301351 this.update_item_grid_labels(company_currency);
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301352
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301353 this.toggle_item_grid_columns(company_currency);
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301354
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301355 if (this.frm.doc.operations && this.frm.doc.operations.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301356 this.frm.set_currency_labels(["operating_cost", "hour_rate"], this.frm.doc.currency, "operations");
1357 this.frm.set_currency_labels(["base_operating_cost", "base_hour_rate"], company_currency, "operations");
1358
1359 var item_grid = this.frm.fields_dict["operations"].grid;
1360 $.each(["base_operating_cost", "base_hour_rate"], function(i, fname) {
1361 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1362 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301363 });
1364 }
1365
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301366 if (this.frm.doc.scrap_items && this.frm.doc.scrap_items.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301367 this.frm.set_currency_labels(["rate", "amount"], this.frm.doc.currency, "scrap_items");
1368 this.frm.set_currency_labels(["base_rate", "base_amount"], company_currency, "scrap_items");
Nabin Hait613d0812015-02-23 11:58:15 +05301369
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301370 var item_grid = this.frm.fields_dict["scrap_items"].grid;
1371 $.each(["base_rate", "base_amount"], function(i, fname) {
1372 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1373 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1374 });
1375 }
Nabin Hait613d0812015-02-23 11:58:15 +05301376
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301377 if (this.frm.doc.taxes && this.frm.doc.taxes.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301378 this.frm.set_currency_labels(["tax_amount", "total", "tax_amount_after_discount"], this.frm.doc.currency, "taxes");
Nabin Hait613d0812015-02-23 11:58:15 +05301379
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301380 this.frm.set_currency_labels(["base_tax_amount", "base_total", "base_tax_amount_after_discount"], company_currency, "taxes");
Nabin Hait613d0812015-02-23 11:58:15 +05301381 }
1382
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301383 if (this.frm.doc.advances && this.frm.doc.advances.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301384 this.frm.set_currency_labels(["advance_amount", "allocated_amount"],
Nabin Haitaa015902015-10-16 13:08:33 +05301385 this.frm.doc.party_account_currency, "advances");
Nabin Hait613d0812015-02-23 11:58:15 +05301386 }
1387
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301388 this.update_payment_schedule_grid_labels(company_currency);
Faris Ansari69eb6d42021-05-07 15:21:33 +05301389 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301390
Faris Ansari69eb6d42021-05-07 15:21:33 +05301391 update_item_grid_labels(company_currency) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301392 this.frm.set_currency_labels([
1393 "base_rate", "base_net_rate", "base_price_list_rate",
1394 "base_amount", "base_net_amount", "base_rate_with_margin"
1395 ], company_currency, "items");
1396
1397 this.frm.set_currency_labels([
1398 "rate", "net_rate", "price_list_rate", "amount",
1399 "net_amount", "stock_uom_rate", "rate_with_margin"
1400 ], this.frm.doc.currency, "items");
Faris Ansari69eb6d42021-05-07 15:21:33 +05301401 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301402
Faris Ansari69eb6d42021-05-07 15:21:33 +05301403 update_payment_schedule_grid_labels(company_currency) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301404 const me = this;
Deepesh Gargdaf6c122021-05-05 12:28:40 +05301405 if (this.frm.doc.payment_schedule && this.frm.doc.payment_schedule.length > 0) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301406 this.frm.set_currency_labels(["base_payment_amount", "base_outstanding", "base_paid_amount"],
1407 company_currency, "payment_schedule");
1408 this.frm.set_currency_labels(["payment_amount", "outstanding", "paid_amount"],
1409 this.frm.doc.currency, "payment_schedule");
Deepesh Garga0ed5172021-05-04 21:01:12 +05301410
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301411 var schedule_grid = this.frm.fields_dict["payment_schedule"].grid;
1412 $.each(["base_payment_amount", "base_outstanding", "base_paid_amount"], function(i, fname) {
Saqib Ansari6fb41752021-04-29 14:05:20 +05301413 if (frappe.meta.get_docfield(schedule_grid.doctype, fname))
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301414 schedule_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1415 });
1416 }
Faris Ansari69eb6d42021-05-07 15:21:33 +05301417 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301418
Faris Ansari69eb6d42021-05-07 15:21:33 +05301419 toggle_item_grid_columns(company_currency) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301420 const me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301421 // toggle columns
1422 var item_grid = this.frm.fields_dict["items"].grid;
Anupam Kumared42afc2021-03-15 11:11:28 +05301423 $.each(["base_rate", "base_price_list_rate", "base_amount", "base_rate_with_margin"], function(i, fname) {
Nabin Hait613d0812015-02-23 11:58:15 +05301424 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1425 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1426 });
1427
1428 var show = (cint(cur_frm.doc.discount_amount)) ||
1429 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
1430
1431 $.each(["net_rate", "net_amount"], function(i, fname) {
1432 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1433 item_grid.set_column_disp(fname, show);
1434 });
1435
1436 $.each(["base_net_rate", "base_net_amount"], function(i, fname) {
1437 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1438 item_grid.set_column_disp(fname, (show && (me.frm.doc.currency != company_currency)));
1439 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301440 }
Nabin Hait613d0812015-02-23 11:58:15 +05301441
Faris Ansari1fe891b2021-04-23 08:04:00 +05301442 recalculate() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301443 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301444 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301445
Faris Ansari1fe891b2021-04-23 08:04:00 +05301446 recalculate_values() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301447 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301448 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301449
Faris Ansari1fe891b2021-04-23 08:04:00 +05301450 calculate_charges() {
Anand Doshid0b00722013-05-28 18:54:48 +05301451 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301452 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301453
Faris Ansari1fe891b2021-04-23 08:04:00 +05301454 ignore_pricing_rule() {
Nabin Hait8c9fb762017-04-28 14:23:03 +05301455 if(this.frm.doc.ignore_pricing_rule) {
1456 var me = this;
1457 var item_list = [];
Rushabh Mehta36311022017-06-20 09:30:53 +05301458
Nabin Hait8c9fb762017-04-28 14:23:03 +05301459 $.each(this.frm.doc["items"] || [], function(i, d) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301460 if (d.item_code && !d.is_free_item) {
Nabin Hait8c9fb762017-04-28 14:23:03 +05301461 item_list.push({
1462 "doctype": d.doctype,
1463 "name": d.name,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301464 "item_code": d.item_code,
1465 "pricing_rules": d.pricing_rules,
1466 "parenttype": d.parenttype,
Saqib Ansarif6dda732022-01-20 12:22:56 +05301467 "parent": d.parent,
1468 "price_list_rate": d.price_list_rate
Nabin Hait8c9fb762017-04-28 14:23:03 +05301469 })
1470 }
1471 });
1472 return this.frm.call({
1473 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.remove_pricing_rules",
1474 args: { item_list: item_list },
1475 callback: function(r) {
1476 if (!r.exc && r.message) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301477 r.message.forEach(row_item => {
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301478 me.remove_pricing_rule(row_item);
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301479 });
Nabin Hait8c9fb762017-04-28 14:23:03 +05301480 me._set_values_for_item_list(r.message);
1481 me.calculate_taxes_and_totals();
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301482 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on");
Nabin Hait8c9fb762017-04-28 14:23:03 +05301483 }
1484 }
1485 });
1486 } else {
1487 this.apply_pricing_rule();
1488 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301489 }
Nabin Hait444f9562014-06-20 15:59:49 +05301490
Faris Ansari1fe891b2021-04-23 08:04:00 +05301491 apply_pricing_rule(item, calculate_taxes_and_totals) {
Nabin Haita3dd72a2014-05-28 12:49:20 +05301492 var me = this;
Anand Doshi70f57eb2015-11-27 14:37:40 +05301493 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301494 if (!(args.items && args.items.length)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +05301495 if(calculate_taxes_and_totals) me.calculate_taxes_and_totals();
1496 return;
1497 }
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301498
Anand Doshidffec8f2014-07-01 17:45:15 +05301499 return this.frm.call({
1500 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.apply_pricing_rule",
Rohit Waghchauree5405342019-03-31 16:42:41 +05301501 args: { args: args, doc: me.frm.doc },
Anand Doshidffec8f2014-07-01 17:45:15 +05301502 callback: function(r) {
Anand Doshif214bfc2014-07-16 17:52:08 +05301503 if (!r.exc && r.message) {
Anand Doshidffec8f2014-07-01 17:45:15 +05301504 me._set_values_for_item_list(r.message);
Saurabh2d7af632016-02-26 11:09:20 +05301505 if(item) me.set_gross_profit(item);
Rohit Waghchauredeaee7c2016-09-22 14:02:53 +05301506 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on")
Anand Doshidffec8f2014-07-01 17:45:15 +05301507 }
1508 }
1509 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301510 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301511
Faris Ansari1fe891b2021-04-23 08:04:00 +05301512 _get_args(item) {
Anand Doshidffec8f2014-07-01 17:45:15 +05301513 var me = this;
1514 return {
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301515 "items": this._get_item_list(item),
Nabin Hait34c551d2019-07-03 10:34:31 +05301516 "customer": me.frm.doc.customer || me.frm.doc.party_name,
1517 "quotation_to": me.frm.doc.quotation_to,
Nabin Hait444f9562014-06-20 15:59:49 +05301518 "customer_group": me.frm.doc.customer_group,
1519 "territory": me.frm.doc.territory,
1520 "supplier": me.frm.doc.supplier,
Zlash652e080982018-04-19 18:37:53 +05301521 "supplier_group": me.frm.doc.supplier_group,
Nabin Hait444f9562014-06-20 15:59:49 +05301522 "currency": me.frm.doc.currency,
1523 "conversion_rate": me.frm.doc.conversion_rate,
1524 "price_list": me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Haitdd82bf22015-05-11 16:49:17 +05301525 "price_list_currency": me.frm.doc.price_list_currency,
Nabin Hait444f9562014-06-20 15:59:49 +05301526 "plc_conversion_rate": me.frm.doc.plc_conversion_rate,
1527 "company": me.frm.doc.company,
1528 "transaction_date": me.frm.doc.transaction_date || me.frm.doc.posting_date,
1529 "campaign": me.frm.doc.campaign,
1530 "sales_partner": me.frm.doc.sales_partner,
1531 "ignore_pricing_rule": me.frm.doc.ignore_pricing_rule,
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301532 "doctype": me.frm.doc.doctype,
Rohit Waghchaure5ecbaa42017-03-28 12:09:07 +05301533 "name": me.frm.doc.name,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +05301534 "is_return": cint(me.frm.doc.is_return),
1535 "update_stock": in_list(['Sales Invoice', 'Purchase Invoice'], me.frm.doc.doctype) ? cint(me.frm.doc.update_stock) : 0,
rohitwaghchaurec037dc72017-11-28 16:11:15 +05301536 "conversion_factor": me.frm.doc.conversion_factor,
ashish-greycube74dc3c92019-08-12 13:39:25 +05301537 "pos_profile": me.frm.doc.doctype == 'Sales Invoice' ? me.frm.doc.pos_profile : '',
1538 "coupon_code": me.frm.doc.coupon_code
Nabin Hait444f9562014-06-20 15:59:49 +05301539 };
Faris Ansari1fe891b2021-04-23 08:04:00 +05301540 }
Nabin Hait444f9562014-06-20 15:59:49 +05301541
Faris Ansari1fe891b2021-04-23 08:04:00 +05301542 _get_item_list(item) {
Nabin Hait444f9562014-06-20 15:59:49 +05301543 var item_list = [];
1544 var append_item = function(d) {
Anand Doshi39edcbc2014-07-28 16:00:19 +05301545 if (d.item_code) {
1546 item_list.push({
1547 "doctype": d.doctype,
1548 "name": d.name,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301549 "child_docname": d.name,
Anand Doshi39edcbc2014-07-28 16:00:19 +05301550 "item_code": d.item_code,
1551 "item_group": d.item_group,
1552 "brand": d.brand,
Anand Doshi39a28912016-02-15 11:42:18 +05301553 "qty": d.qty,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301554 "stock_qty": d.stock_qty,
Nabin Haite45ec662018-08-01 17:44:34 +05301555 "uom": d.uom,
Suraj Shettyc87b47a2019-04-29 23:18:47 +05301556 "stock_uom": d.stock_uom,
Anand Doshi39a28912016-02-15 11:42:18 +05301557 "parenttype": d.parenttype,
Rohit Waghchaure43b50802016-10-24 14:04:46 +05301558 "parent": d.parent,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301559 "pricing_rules": d.pricing_rules,
Kanchan Chauhanaf0d6372016-11-13 21:19:09 +05301560 "warehouse": d.warehouse,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +05301561 "serial_no": d.serial_no,
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301562 "batch_no": d.batch_no,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301563 "price_list_rate": d.price_list_rate,
mbauskar287fe812017-04-10 19:15:57 +05301564 "conversion_factor": d.conversion_factor || 1.0
Anand Doshi39edcbc2014-07-28 16:00:19 +05301565 });
mbauskarc79415e2016-01-18 16:32:24 +05301566
1567 // if doctype is Quotation Item / Sales Order Iten then add Margin Type and rate in item_list
Anupam Kumared42afc2021-03-15 11:11:28 +05301568 if (in_list(["Quotation Item", "Sales Order Item", "Delivery Note Item", "Sales Invoice Item", "Purchase Invoice Item", "Purchase Order Item", "Purchase Receipt Item"]), d.doctype) {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301569 item_list[0]["margin_type"] = d.margin_type;
1570 item_list[0]["margin_rate_or_amount"] = d.margin_rate_or_amount;
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301571 }
Anand Doshi39edcbc2014-07-28 16:00:19 +05301572 }
Nabin Hait444f9562014-06-20 15:59:49 +05301573 };
Nabin Haita3dd72a2014-05-28 12:49:20 +05301574
Nabin Hait444f9562014-06-20 15:59:49 +05301575 if (item) {
1576 append_item(item);
Nabin Haitc1367d92014-05-30 11:43:00 +05301577 } else {
Nabin Hait96339342015-01-21 17:22:11 +05301578 $.each(this.frm.doc["items"] || [], function(i, d) {
Nabin Hait444f9562014-06-20 15:59:49 +05301579 append_item(d);
Nabin Haita3dd72a2014-05-28 12:49:20 +05301580 });
1581 }
Nabin Hait444f9562014-06-20 15:59:49 +05301582 return item_list;
Faris Ansari1fe891b2021-04-23 08:04:00 +05301583 }
Nabin Haita3dd72a2014-05-28 12:49:20 +05301584
Faris Ansari1fe891b2021-04-23 08:04:00 +05301585 _set_values_for_item_list(children) {
Nabin Hait49a27292014-12-17 11:21:32 +05301586 var me = this;
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301587 var items_rule_dict = {};
1588
Anand Doshidea3fb02015-02-05 15:05:58 +05301589 for(var i=0, l=children.length; i<l; i++) {
Deepesh Gargab09dc52021-12-20 12:16:14 +05301590 var d = children[i] ;
Deepesh Garg4756fbc2021-12-20 13:26:16 +05301591 let item_row = frappe.get_doc(d.doctype, d.name);
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301592 var existing_pricing_rule = frappe.model.get_value(d.doctype, d.name, "pricing_rules");
Anand Doshidea3fb02015-02-05 15:05:58 +05301593 for(var k in d) {
1594 var v = d[k];
Anand Doshidffec8f2014-07-01 17:45:15 +05301595 if (["doctype", "name"].indexOf(k)===-1) {
Nabin Hait7d8fa802014-12-30 15:35:45 +05301596 if(k=="price_list_rate") {
Deepesh Gargab09dc52021-12-20 12:16:14 +05301597 item_row['rate'] = v;
Nabin Hait7d8fa802014-12-30 15:35:45 +05301598 }
Rohit Waghchaurea9b13472021-03-07 11:43:22 +05301599
1600 if (k !== 'free_item_data') {
Deepesh Gargab09dc52021-12-20 12:16:14 +05301601 item_row[k] = v;
Rohit Waghchaurea9b13472021-03-07 11:43:22 +05301602 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301603 }
Anand Doshidea3fb02015-02-05 15:05:58 +05301604 }
1605
Deepesh Garg2d0208b2021-12-22 12:01:39 +05301606 frappe.model.round_floats_in(item_row, ["price_list_rate", "discount_percentage"]);
1607
Nabin Hait49a27292014-12-17 11:21:32 +05301608 // if pricing rule set as blank from an existing value, apply price_list
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301609 if(!me.frm.doc.ignore_pricing_rule && existing_pricing_rule && !d.pricing_rules) {
Nabin Hait49a27292014-12-17 11:21:32 +05301610 me.apply_price_list(frappe.get_doc(d.doctype, d.name));
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301611 } else if(!d.pricing_rules) {
1612 me.remove_pricing_rule(frappe.get_doc(d.doctype, d.name));
1613 }
1614
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301615 if (d.free_item_data) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301616 me.apply_product_discount(d);
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301617 }
1618
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301619 if (d.apply_rule_on_other_items) {
1620 items_rule_dict[d.name] = d;
Nabin Hait49a27292014-12-17 11:21:32 +05301621 }
Anand Doshidea3fb02015-02-05 15:05:58 +05301622 }
Nabin Hait7d8fa802014-12-30 15:35:45 +05301623
Deepesh Gargab09dc52021-12-20 12:16:14 +05301624 me.frm.refresh_field('items');
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301625 me.apply_rule_on_other_items(items_rule_dict);
1626
Deepesh Gargd19369b2021-12-22 11:26:19 +05301627 me.calculate_taxes_and_totals();
Deepesh Garg6eb3d6a2021-12-25 09:04:34 +05301628 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301629
Faris Ansari1fe891b2021-04-23 08:04:00 +05301630 apply_rule_on_other_items(args) {
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301631 const me = this;
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301632 const fields = ["discount_percentage", "pricing_rules", "discount_amount", "rate"];
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301633
1634 for(var k in args) {
1635 let data = args[k];
Saqib Ansari8c70e8d2020-04-24 16:41:48 +05301636
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301637 if (data && data.apply_rule_on_other_items) {
1638 me.frm.doc.items.forEach(d => {
1639 if (in_list(data.apply_rule_on_other_items, d[data.apply_rule_on])) {
1640 for(var k in data) {
Saqib Ansari40140c62020-04-24 14:51:14 +05301641 if (in_list(fields, k) && data[k] && (data.price_or_product_discount === 'price' || k === 'pricing_rules')) {
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301642 frappe.model.set_value(d.doctype, d.name, k, data[k]);
1643 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301644 }
1645 }
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301646 });
1647 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301648 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301649 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301650
Faris Ansari69eb6d42021-05-07 15:21:33 +05301651 apply_product_discount(args) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301652 const items = this.frm.doc.items.filter(d => (d.is_free_item)) || [];
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301653
Rohit Waghchaure77add492021-03-17 18:49:54 +05301654 const exist_items = items.map(row => (row.item_code, row.pricing_rules));
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301655
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301656 args.free_item_data.forEach(pr_row => {
1657 let row_to_modify = {};
Rohit Waghchaure77add492021-03-17 18:49:54 +05301658 if (!items || !in_list(exist_items, (pr_row.item_code, pr_row.pricing_rules))) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301659
1660 row_to_modify = frappe.model.add_child(this.frm.doc,
1661 this.frm.doc.doctype + ' Item', 'items');
1662
1663 } else if(items) {
Rohit Waghchaure77add492021-03-17 18:49:54 +05301664 row_to_modify = items.filter(d => (d.item_code === pr_row.item_code
1665 && d.pricing_rules === pr_row.pricing_rules))[0];
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301666 }
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301667
1668 for (let key in pr_row) {
1669 row_to_modify[key] = pr_row[key];
1670 }
1671 });
1672
1673 // free_item_data is a temporary variable
1674 args.free_item_data = '';
1675 refresh_field('items');
Faris Ansari1fe891b2021-04-23 08:04:00 +05301676 }
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301677
Faris Ansari1fe891b2021-04-23 08:04:00 +05301678 apply_price_list(item, reset_plc_conversion) {
tundebabzy6e90f492018-02-12 10:48:57 +01001679 // We need to reset plc_conversion_rate sometimes because the call to
1680 // `erpnext.stock.get_item_details.apply_price_list` is sensitive to its value
1681 if (!reset_plc_conversion) {
1682 this.frm.set_value("plc_conversion_rate", "");
1683 }
1684
Anand Doshidffec8f2014-07-01 17:45:15 +05301685 var me = this;
Rushabh Mehta052bd622015-01-30 16:57:24 +05301686 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301687 if (!((args.items && args.items.length) || args.price_list)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +05301688 return;
1689 }
Nabin Hait37b047d2015-02-23 16:01:33 +05301690
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301691 if (me.in_apply_price_list == true) return;
1692
1693 me.in_apply_price_list = true;
Anand Doshidffec8f2014-07-01 17:45:15 +05301694 return this.frm.call({
1695 method: "erpnext.stock.get_item_details.apply_price_list",
Rushabh Mehta052bd622015-01-30 16:57:24 +05301696 args: { args: args },
Anand Doshidffec8f2014-07-01 17:45:15 +05301697 callback: function(r) {
1698 if (!r.exc) {
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301699 frappe.run_serially([
1700 () => me.frm.set_value("price_list_currency", r.message.parent.price_list_currency),
1701 () => me.frm.set_value("plc_conversion_rate", r.message.parent.plc_conversion_rate),
1702 () => {
1703 if(args.items.length) {
1704 me._set_values_for_item_list(r.message.children);
1705 }
1706 },
1707 () => { me.in_apply_price_list = false; }
1708 ]);
Nabin Hait37b047d2015-02-23 16:01:33 +05301709
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301710 } else {
1711 me.in_apply_price_list = false;
Anand Doshidffec8f2014-07-01 17:45:15 +05301712 }
1713 }
Faris Ansari404f39d2018-05-14 15:46:45 +05301714 }).always(() => {
1715 me.in_apply_price_list = false;
Anand Doshidffec8f2014-07-01 17:45:15 +05301716 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301717 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301718
Faris Ansari1fe891b2021-04-23 08:04:00 +05301719 remove_pricing_rule(item) {
Rohit Waghchauree5405342019-03-31 16:42:41 +05301720 let me = this;
Rohit Waghchaure660a78b2020-01-02 17:29:50 +05301721 const fields = ["discount_percentage",
1722 "discount_amount", "margin_rate_or_amount", "rate_with_margin"];
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301723
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301724 if(item.remove_free_item) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301725 var items = [];
1726
1727 me.frm.doc.items.forEach(d => {
1728 if(d.item_code != item.remove_free_item || !d.is_free_item) {
1729 items.push(d);
1730 }
1731 });
1732
1733 me.frm.doc.items = items;
1734 refresh_field('items');
Rohit Waghchauree5405342019-03-31 16:42:41 +05301735 } else if(item.applied_on_items && item.apply_on) {
1736 const applied_on_items = item.applied_on_items.split(',');
1737 me.frm.doc.items.forEach(row => {
1738 if(applied_on_items.includes(row[item.apply_on])) {
1739 fields.forEach(f => {
1740 row[f] = 0;
1741 });
Rohit Waghchaure660a78b2020-01-02 17:29:50 +05301742
1743 ["pricing_rules", "margin_type"].forEach(field => {
1744 if (row[field]) {
1745 row[field] = '';
1746 }
1747 })
Rohit Waghchauree5405342019-03-31 16:42:41 +05301748 }
1749 });
1750
1751 me.trigger_price_list_rate();
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301752 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301753 }
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301754
Faris Ansari1fe891b2021-04-23 08:04:00 +05301755 trigger_price_list_rate() {
Rohit Waghchauree5405342019-03-31 16:42:41 +05301756 var me = this;
1757
1758 this.frm.doc.items.forEach(child_row => {
1759 me.frm.script_manager.trigger("price_list_rate",
1760 child_row.doctype, child_row.name);
1761 })
Faris Ansari1fe891b2021-04-23 08:04:00 +05301762 }
Rohit Waghchauree5405342019-03-31 16:42:41 +05301763
Faris Ansari1fe891b2021-04-23 08:04:00 +05301764 validate_company_and_party() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301765 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +05301766 var valid = true;
Rushabh Mehtaff938022014-04-15 18:40:00 +05301767
Nabin Hait0f231062014-02-20 11:27:47 +05301768 $.each(["company", "customer"], function(i, fieldname) {
Nabin Haitae07f222017-06-02 13:57:08 +05301769 if(frappe.meta.has_field(me.frm.doc.doctype, fieldname) && me.frm.doc.doctype != "Purchase Order") {
Nabin Hait139dc7b2014-02-12 14:53:18 +05301770 if (!me.frm.doc[fieldname]) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301771 frappe.msgprint(__("Please specify") + ": " +
Rushabh Mehtaff938022014-04-15 18:40:00 +05301772 frappe.meta.get_label(me.frm.doc.doctype, fieldname, me.frm.doc.name) +
Pratik Vyasb52618c2014-04-14 16:25:30 +05301773 ". " + __("It is needed to fetch Item Details."));
Faris Ansariab74ca72017-05-30 12:54:42 +05301774 valid = false;
Nabin Hait139dc7b2014-02-12 14:53:18 +05301775 }
Anand Doshi3543f302013-05-24 19:25:01 +05301776 }
1777 });
1778 return valid;
Faris Ansari1fe891b2021-04-23 08:04:00 +05301779 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301780
Faris Ansari1fe891b2021-04-23 08:04:00 +05301781 get_terms() {
Anand Doshibf3e54a2013-06-05 14:11:32 +05301782 var me = this;
Makarand Bauskar157c3342017-05-26 21:32:33 +05301783
1784 erpnext.utils.get_terms(this.frm.doc.tc_name, this.frm.doc, function(r) {
1785 if(!r.exc) {
1786 me.frm.set_value("terms", r.message);
1787 }
1788 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301789 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301790
Faris Ansari1fe891b2021-04-23 08:04:00 +05301791 taxes_and_charges() {
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301792 var me = this;
1793 if(this.frm.doc.taxes_and_charges) {
1794 return this.frm.call({
Nabin Hait6b039142014-05-02 15:45:10 +05301795 method: "erpnext.controllers.accounts_controller.get_taxes_and_charges",
1796 args: {
Nabin Hait03f3a8a2014-05-13 16:38:31 +05301797 "master_doctype": frappe.meta.get_docfield(this.frm.doc.doctype, "taxes_and_charges",
1798 this.frm.doc.name).options,
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301799 "master_name": this.frm.doc.taxes_and_charges
Nabin Hait6b039142014-05-02 15:45:10 +05301800 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301801 callback: function(r) {
1802 if(!r.exc) {
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301803 if(me.frm.doc.shipping_rule && me.frm.doc.taxes) {
1804 for (let tax of r.message) {
1805 me.frm.add_child("taxes", tax);
1806 }
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301807
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301808 refresh_field("taxes");
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301809 } else {
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301810 me.frm.set_value("taxes", r.message);
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301811 me.calculate_taxes_and_totals();
Rohan Bansal90972cf2019-03-11 14:48:26 +05301812 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301813 }
1814 }
1815 });
Nabin Haitbc83b9c2014-05-02 17:03:18 +05301816 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301817 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301818
Faris Ansari1fe891b2021-04-23 08:04:00 +05301819 tax_category() {
Saif Ur Rehman67786682018-12-27 02:11:07 +05001820 var me = this;
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +05001821 if(me.frm.updating_party_details) return;
1822
Saif Ur Rehmane414a922018-12-28 04:59:42 +05001823 frappe.run_serially([
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001824 () => this.update_item_tax_map(),
Saif Ur Rehmane414a922018-12-28 04:59:42 +05001825 () => erpnext.utils.set_taxes(this.frm, "tax_category"),
1826 ]);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301827 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001828
Nabin Hait595c7a62021-07-22 17:11:20 +05301829 update_item_tax_map() {
Deepesh Garg72eb72f2021-07-20 15:45:04 +05301830 let me = this;
1831 let item_codes = [];
1832 let item_rates = {};
1833 let item_tax_templates = {};
1834
1835 $.each(this.frm.doc.items || [], function(i, item) {
1836 if (item.item_code) {
1837 // Use combination of name and item code in case same item is added multiple times
1838 item_codes.push([item.item_code, item.name]);
1839 item_rates[item.name] = item.net_rate;
1840 item_tax_templates[item.name] = item.item_tax_template;
1841 }
1842 });
1843
1844 if (item_codes.length) {
1845 return this.frm.call({
1846 method: "erpnext.stock.get_item_details.get_item_tax_info",
1847 args: {
1848 company: me.frm.doc.company,
1849 tax_category: cstr(me.frm.doc.tax_category),
1850 item_codes: item_codes,
1851 item_rates: item_rates,
1852 item_tax_templates: item_tax_templates
1853 },
1854 callback: function(r) {
1855 if (!r.exc) {
1856 $.each(me.frm.doc.items || [], function(i, item) {
1857 if (item.name && r.message.hasOwnProperty(item.name) && r.message[item.name].item_tax_template) {
1858 item.item_tax_template = r.message[item.name].item_tax_template;
1859 item.item_tax_rate = r.message[item.name].item_tax_rate;
1860 me.add_taxes_from_item_tax_template(item.item_tax_rate);
1861 }
1862 });
1863 }
1864 }
1865 });
1866 }
Nabin Hait595c7a62021-07-22 17:11:20 +05301867 }
Deepesh Garg72eb72f2021-07-20 15:45:04 +05301868
Faris Ansari1fe891b2021-04-23 08:04:00 +05301869 item_tax_template(doc, cdt, cdn) {
Saif Ur Rehman67786682018-12-27 02:11:07 +05001870 var me = this;
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +05001871 if(me.frm.updating_party_details) return;
1872
Saif Ur Rehman67786682018-12-27 02:11:07 +05001873 var item = frappe.get_doc(cdt, cdn);
1874
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001875 if(item.item_tax_template) {
1876 return this.frm.call({
1877 method: "erpnext.stock.get_item_details.get_item_tax_map",
1878 args: {
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001879 company: me.frm.doc.company,
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001880 item_tax_template: item.item_tax_template,
1881 as_json: true
1882 },
1883 callback: function(r) {
1884 if(!r.exc) {
1885 item.item_tax_rate = r.message;
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001886 me.calculate_taxes_and_totals();
1887 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001888 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001889 });
1890 } else {
1891 item.item_tax_rate = "{}";
1892 me.calculate_taxes_and_totals();
1893 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301894 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001895
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001896
Faris Ansari1fe891b2021-04-23 08:04:00 +05301897 is_recurring() {
Anand Doshi13945092014-09-21 19:45:49 +05301898 // set default values for recurring documents
Rushabh Mehta756e5182016-03-03 13:00:17 +05301899 if(this.frm.doc.is_recurring && this.frm.doc.__islocal) {
1900 frappe.msgprint(__("Please set recurring after saving"));
1901 this.frm.set_value('is_recurring', 0);
1902 return;
1903 }
1904
Anand Doshi13945092014-09-21 19:45:49 +05301905 if(this.frm.doc.is_recurring) {
Nabin Hait68a628e2016-03-21 12:03:16 +05301906 if(!this.frm.doc.recurring_id) {
1907 this.frm.set_value('recurring_id', this.frm.doc.name);
1908 }
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301909
Anand Doshi13945092014-09-21 19:45:49 +05301910 var owner_email = this.frm.doc.owner=="Administrator"
1911 ? frappe.user_info("Administrator").email
1912 : this.frm.doc.owner;
1913
1914 this.frm.doc.notification_email_address = $.map([cstr(owner_email),
1915 cstr(this.frm.doc.contact_email)], function(v) { return v || null; }).join(", ");
1916 this.frm.doc.repeat_on_day_of_month = frappe.datetime.str_to_obj(this.frm.doc.posting_date).getDate();
1917 }
1918
1919 refresh_many(["notification_email_address", "repeat_on_day_of_month"]);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301920 }
Anand Doshi13945092014-09-21 19:45:49 +05301921
Faris Ansari1fe891b2021-04-23 08:04:00 +05301922 from_date() {
Anand Doshi13945092014-09-21 19:45:49 +05301923 // set to_date
1924 if(this.frm.doc.from_date) {
1925 var recurring_type_map = {'Monthly': 1, 'Quarterly': 3, 'Half-yearly': 6,
1926 'Yearly': 12};
1927
1928 var months = recurring_type_map[this.frm.doc.recurring_type];
1929 if(months) {
1930 var to_date = frappe.datetime.add_months(this.frm.doc.from_date,
1931 months);
1932 this.frm.doc.to_date = frappe.datetime.add_days(to_date, -1);
1933 refresh_field('to_date');
1934 }
1935 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301936 }
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301937
Faris Ansari1fe891b2021-04-23 08:04:00 +05301938 set_gross_profit(item) {
Abhishek Balam18e7b602020-05-26 18:37:02 +05301939 if (["Sales Order", "Quotation"].includes(this.frm.doc.doctype) && item.valuation_rate) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301940 var rate = flt(item.rate) * flt(this.frm.doc.conversion_rate || 1);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301941 item.gross_profit = flt(((rate - item.valuation_rate) * item.stock_qty), precision("amount", item));
Saurabh2d7af632016-02-26 11:09:20 +05301942 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301943 }
Rushabh Mehta203cc962016-04-07 15:25:43 +05301944
Faris Ansari1fe891b2021-04-23 08:04:00 +05301945 setup_item_selector() {
Rushabh Mehtabc928242016-05-29 23:08:22 +05301946 // TODO: remove item selector
1947
1948 return;
Faris Ansariab74ca72017-05-30 12:54:42 +05301949 // if(!this.item_selector) {
1950 // this.item_selector = new erpnext.ItemSelector({frm: this.frm});
1951 // }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301952 }
Rushabh Mehta76b13412016-07-18 14:30:18 +05301953
Faris Ansari1fe891b2021-04-23 08:04:00 +05301954 get_advances() {
Nabin Hait28a05282016-06-27 17:41:39 +05301955 if(!this.frm.is_return) {
1956 return this.frm.call({
1957 method: "set_advances",
1958 doc: this.frm.doc,
1959 callback: function(r, rt) {
1960 refresh_field("advances");
1961 }
1962 })
1963 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301964 }
Rushabh Mehta76b13412016-07-18 14:30:18 +05301965
Faris Ansari1fe891b2021-04-23 08:04:00 +05301966 make_payment_entry() {
Nabin Hait05aefbb2016-06-28 19:42:19 +05301967 return frappe.call({
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301968 method: cur_frm.cscript.get_method_for_payment(),
Nabin Hait05aefbb2016-06-28 19:42:19 +05301969 args: {
1970 "dt": cur_frm.doc.doctype,
1971 "dn": cur_frm.doc.name
1972 },
1973 callback: function(r) {
1974 var doclist = frappe.model.sync(r.message);
1975 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
Nabin Hait56548cb2016-07-01 15:58:39 +05301976 // cur_frm.refresh_fields()
Nabin Hait05aefbb2016-06-28 19:42:19 +05301977 }
1978 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301979 }
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301980
Ankushfd848472021-06-16 11:14:40 +05301981 make_quality_inspection() {
Rohan Bansala93b5142021-04-06 17:10:52 +05301982 let data = [];
1983 const fields = [
1984 {
1985 label: "Items",
1986 fieldtype: "Table",
1987 fieldname: "items",
1988 cannot_add_rows: true,
1989 in_place_edit: true,
1990 data: data,
Rohan Bansal03f711e2021-04-14 14:41:55 +05301991 get_data: () => {
1992 return data;
1993 },
Rohan Bansala93b5142021-04-06 17:10:52 +05301994 fields: [
1995 {
1996 fieldtype: "Data",
1997 fieldname: "docname",
1998 hidden: true
1999 },
2000 {
2001 fieldtype: "Read Only",
2002 fieldname: "item_code",
2003 label: __("Item Code"),
2004 in_list_view: true
2005 },
2006 {
2007 fieldtype: "Read Only",
2008 fieldname: "item_name",
2009 label: __("Item Name"),
2010 in_list_view: true
2011 },
2012 {
2013 fieldtype: "Float",
2014 fieldname: "qty",
2015 label: __("Accepted Quantity"),
2016 in_list_view: true,
2017 read_only: true
2018 },
2019 {
2020 fieldtype: "Float",
2021 fieldname: "sample_size",
2022 label: __("Sample Size"),
2023 reqd: true,
2024 in_list_view: true
2025 },
2026 {
2027 fieldtype: "Data",
2028 fieldname: "description",
2029 label: __("Description"),
2030 hidden: true
2031 },
2032 {
2033 fieldtype: "Data",
2034 fieldname: "serial_no",
2035 label: __("Serial No"),
2036 hidden: true
2037 },
2038 {
2039 fieldtype: "Data",
2040 fieldname: "batch_no",
2041 label: __("Batch No"),
2042 hidden: true
2043 }
2044 ]
2045 }
2046 ];
2047
2048 const me = this;
2049 const dialog = new frappe.ui.Dialog({
2050 title: __("Select Items for Quality Inspection"),
2051 fields: fields,
2052 primary_action: function () {
2053 const data = dialog.get_values();
2054 frappe.call({
Rohan Bansal7f8b95e2021-04-14 14:12:03 +05302055 method: "erpnext.controllers.stock_controller.make_quality_inspections",
Rohan Bansala93b5142021-04-06 17:10:52 +05302056 args: {
2057 doctype: me.frm.doc.doctype,
2058 docname: me.frm.doc.name,
Rohan Bansala06ec032021-06-02 14:55:31 +05302059 items: data.items
Rohan Bansala93b5142021-04-06 17:10:52 +05302060 },
2061 freeze: true,
2062 callback: function (r) {
Rohan Bansal1cdf5a02021-05-26 14:42:15 +05302063 if (r.message.length > 0) {
2064 if (r.message.length === 1) {
2065 frappe.set_route("Form", "Quality Inspection", r.message[0]);
2066 } else {
2067 frappe.route_options = {
2068 "reference_type": me.frm.doc.doctype,
2069 "reference_name": me.frm.doc.name
2070 };
2071 frappe.set_route("List", "Quality Inspection");
2072 }
Rohan Bansala93b5142021-04-06 17:10:52 +05302073 }
2074 dialog.hide();
2075 }
2076 });
2077 },
2078 primary_action_label: __("Create")
2079 });
2080
2081 this.frm.doc.items.forEach(item => {
2082 if (!item.quality_inspection) {
2083 let dialog_items = dialog.fields_dict.items;
2084 dialog_items.df.data.push({
2085 "docname": item.name,
2086 "item_code": item.item_code,
2087 "item_name": item.item_name,
2088 "qty": item.qty,
2089 "description": item.description,
2090 "serial_no": item.serial_no,
2091 "batch_no": item.batch_no
2092 });
2093 dialog_items.grid.refresh();
2094 }
Rohan Bansal03f711e2021-04-14 14:41:55 +05302095 });
Rohan Bansala93b5142021-04-06 17:10:52 +05302096
2097 data = dialog.fields_dict.items.df.data;
2098 if (!data.length) {
2099 frappe.msgprint(__("All items in this document already have a linked Quality Inspection."));
2100 } else {
2101 dialog.show();
2102 }
Ankushfd848472021-06-16 11:14:40 +05302103 }
Rohan Bansala93b5142021-04-06 17:10:52 +05302104
Ankushfd848472021-06-16 11:14:40 +05302105 get_method_for_payment() {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302106 var method = "erpnext.accounts.doctype.payment_entry.payment_entry.get_payment_entry";
Rohit Waghchaure7d529892016-10-06 14:35:04 +05302107 if(cur_frm.doc.__onload && cur_frm.doc.__onload.make_payment_via_journal_entry){
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302108 if(in_list(['Sales Invoice', 'Purchase Invoice'], cur_frm.doc.doctype)){
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302109 method = "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_invoice";
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302110 }else {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302111 method= "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_order";
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302112 }
2113 }
2114
2115 return method
Faris Ansari1fe891b2021-04-23 08:04:00 +05302116 }
Makarand Bauskarc196d742017-06-02 17:28:40 +05302117
Faris Ansari1fe891b2021-04-23 08:04:00 +05302118 set_query_for_batch(doc, cdt, cdn) {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302119 // Show item's batches in the dropdown of batch no
2120
2121 var me = this;
2122 var item = frappe.get_doc(cdt, cdn);
2123
2124 if(!item.item_code) {
2125 frappe.throw(__("Please enter Item Code to get batch no"));
Rushabh Mehta36311022017-06-20 09:30:53 +05302126 } else if (doc.doctype == "Purchase Receipt" ||
Makarand Bauskarc196d742017-06-02 17:28:40 +05302127 (doc.doctype == "Purchase Invoice" && doc.update_stock)) {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302128 return {
2129 filters: {'item': item.item_code}
2130 }
2131 } else {
Rushabh Mehta98aa5812017-11-14 09:32:32 +05302132 let filters = {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302133 'item_code': item.item_code,
2134 'posting_date': me.frm.doc.posting_date || frappe.datetime.nowdate(),
2135 }
Rohit Waghchaured8ddd1e2019-10-22 14:03:27 +05302136
2137 if (doc.is_return) {
2138 filters["is_return"] = 1;
2139 }
2140
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302141 if (item.warehouse) filters["warehouse"] = item.warehouse;
Makarand Bauskarc196d742017-06-02 17:28:40 +05302142
KanchanChauhan0fe455a2017-11-17 20:08:15 +05302143 return {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302144 query : "erpnext.controllers.queries.get_batch_no",
2145 filters: filters
2146 }
2147 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302148 }
Nabin Hait92759692017-08-15 08:23:51 +05302149
Faris Ansari1fe891b2021-04-23 08:04:00 +05302150 set_query_for_item_tax_template(doc, cdt, cdn) {
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302151 var item = frappe.get_doc(cdt, cdn);
2152 if(!item.item_code) {
casesolved-co-uka7803062021-02-16 05:48:50 +00002153 return doc.company ? {filters: {company: doc.company}} : {};
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302154 } else {
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302155 let filters = {
2156 'item_code': item.item_code,
Marica0fcb05a2020-08-10 14:48:13 +05302157 'valid_from': ["<=", doc.transaction_date || doc.bill_date || doc.posting_date],
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302158 'item_group': item.item_group,
2159 }
2160
2161 if (doc.tax_category)
2162 filters['tax_category'] = doc.tax_category;
mohammadahmad199041c0c9f2020-06-18 11:18:44 +05002163 if (doc.company)
2164 filters['company'] = doc.company;
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302165 return {
2166 query: "erpnext.controllers.queries.get_tax_template",
2167 filters: filters
2168 }
2169 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302170 }
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302171
Faris Ansari1fe891b2021-04-23 08:04:00 +05302172 payment_terms_template() {
Nabin Hait92759692017-08-15 08:23:51 +05302173 var me = this;
tundebabzy8f44d1c2018-01-05 08:16:50 +01002174 const doc = this.frm.doc;
2175 if(doc.payment_terms_template && doc.doctype !== 'Delivery Note') {
Shreya Shah3a9eec22018-02-16 13:05:21 +05302176 var posting_date = doc.posting_date || doc.transaction_date;
Nabin Hait92759692017-08-15 08:23:51 +05302177 frappe.call({
2178 method: "erpnext.controllers.accounts_controller.get_payment_terms",
2179 args: {
tundebabzy8f44d1c2018-01-05 08:16:50 +01002180 terms_template: doc.payment_terms_template,
rohitwaghchaureda941af2018-01-17 16:23:04 +05302181 posting_date: posting_date,
Shreya Shah3a9eec22018-02-16 13:05:21 +05302182 grand_total: doc.rounded_total || doc.grand_total,
Saqib Ansarid552fe62021-04-23 14:46:52 +05302183 base_grand_total: doc.base_rounded_total || doc.base_grand_total,
Shreya Shah3a9eec22018-02-16 13:05:21 +05302184 bill_date: doc.bill_date
Nabin Hait92759692017-08-15 08:23:51 +05302185 },
2186 callback: function(r) {
2187 if(r.message && !r.exc) {
2188 me.frm.set_value("payment_schedule", r.message);
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05302189 const company_currency = me.get_company_currency();
Deepesh Garga0ed5172021-05-04 21:01:12 +05302190 me.update_payment_schedule_grid_labels(company_currency);
Nabin Hait92759692017-08-15 08:23:51 +05302191 }
2192 }
2193 })
2194 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302195 }
Nabin Hait92759692017-08-15 08:23:51 +05302196
Faris Ansari1fe891b2021-04-23 08:04:00 +05302197 payment_term(doc, cdt, cdn) {
Saqib Ansari6fb41752021-04-29 14:05:20 +05302198 const me = this;
Nabin Hait92759692017-08-15 08:23:51 +05302199 var row = locals[cdt][cdn];
2200 if(row.payment_term) {
2201 frappe.call({
2202 method: "erpnext.controllers.accounts_controller.get_payment_term_details",
2203 args: {
2204 term: row.payment_term,
Shreya Shah3a9eec22018-02-16 13:05:21 +05302205 bill_date: this.frm.doc.bill_date,
Nabin Hait92759692017-08-15 08:23:51 +05302206 posting_date: this.frm.doc.posting_date || this.frm.doc.transaction_date,
Saqib Ansarid552fe62021-04-23 14:46:52 +05302207 grand_total: this.frm.doc.rounded_total || this.frm.doc.grand_total,
2208 base_grand_total: this.frm.doc.base_rounded_total || this.frm.doc.base_grand_total
Nabin Hait92759692017-08-15 08:23:51 +05302209 },
2210 callback: function(r) {
2211 if(r.message && !r.exc) {
2212 for (var d in r.message) {
2213 frappe.model.set_value(cdt, cdn, d, r.message[d]);
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05302214 const company_currency = me.get_company_currency();
Saqib Ansari6fb41752021-04-29 14:05:20 +05302215 me.update_payment_schedule_grid_labels(company_currency);
Nabin Hait92759692017-08-15 08:23:51 +05302216 }
2217 }
2218 }
2219 })
2220 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302221 }
Manas Solankie5e87f72018-05-28 20:07:08 +05302222
Faris Ansari1fe891b2021-04-23 08:04:00 +05302223 against_blanket_order(doc, cdt, cdn) {
ronelvcabrera370cdc02019-12-04 18:37:11 +08002224 var item = locals[cdt][cdn];
2225 if(!item.against_blanket_order) {
2226 frappe.model.set_value(this.frm.doctype + " Item", item.name, "blanket_order", null);
2227 frappe.model.set_value(this.frm.doctype + " Item", item.name, "blanket_order_rate", 0.00);
2228 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302229 }
ronelvcabrera370cdc02019-12-04 18:37:11 +08002230
Faris Ansari1fe891b2021-04-23 08:04:00 +05302231 blanket_order(doc, cdt, cdn) {
Manas Solankie5e87f72018-05-28 20:07:08 +05302232 var me = this;
2233 var item = locals[cdt][cdn];
2234 if (item.blanket_order && (item.parenttype=="Sales Order" || item.parenttype=="Purchase Order")) {
2235 frappe.call({
2236 method: "erpnext.stock.get_item_details.get_blanket_order_details",
2237 args: {
2238 args:{
2239 item_code: item.item_code,
2240 customer: doc.customer,
2241 supplier: doc.supplier,
2242 company: doc.company,
2243 transaction_date: doc.transaction_date,
2244 blanket_order: item.blanket_order
2245 }
2246 },
2247 callback: function(r) {
2248 if (!r.message) {
Manas Solanki2df1b312018-05-29 12:56:14 +05302249 frappe.throw(__("Invalid Blanket Order for the selected Customer and Item"));
Manas Solankie5e87f72018-05-28 20:07:08 +05302250 } else {
2251 frappe.run_serially([
2252 () => frappe.model.set_value(cdt, cdn, "blanket_order_rate", r.message.blanket_order_rate),
2253 () => me.frm.script_manager.trigger("price_list_rate", cdt, cdn)
2254 ]);
2255 }
2256 }
2257 })
2258 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302259 }
Saif60ec88b2018-11-13 12:07:53 +05002260
Faris Ansari1fe891b2021-04-23 08:04:00 +05302261 set_reserve_warehouse() {
marination8a30cb22020-04-23 00:18:21 +05302262 this.autofill_warehouse(this.frm.doc.supplied_items, "reserve_warehouse", this.frm.doc.set_reserve_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302263 }
Marica93cb64e2019-12-23 18:24:56 +05302264
Faris Ansari1fe891b2021-04-23 08:04:00 +05302265 set_warehouse() {
marination8a30cb22020-04-23 00:18:21 +05302266 this.autofill_warehouse(this.frm.doc.items, "warehouse", this.frm.doc.set_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302267 }
Marica93cb64e2019-12-23 18:24:56 +05302268
Faris Ansari1fe891b2021-04-23 08:04:00 +05302269 set_target_warehouse() {
Deepesh Gargb4be2922021-01-28 13:09:56 +05302270 this.autofill_warehouse(this.frm.doc.items, "target_warehouse", this.frm.doc.set_target_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302271 }
Deepesh Gargb4be2922021-01-28 13:09:56 +05302272
Faris Ansari1fe891b2021-04-23 08:04:00 +05302273 set_from_warehouse() {
Deepesh Gargb4be2922021-01-28 13:09:56 +05302274 this.autofill_warehouse(this.frm.doc.items, "from_warehouse", this.frm.doc.set_from_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302275 }
Deepesh Gargb4be2922021-01-28 13:09:56 +05302276
Faris Ansari1fe891b2021-04-23 08:04:00 +05302277 autofill_warehouse(child_table, warehouse_field, warehouse) {
marinationb7f68782020-04-28 19:18:45 +05302278 if (warehouse && child_table && child_table.length) {
2279 let doctype = child_table[0].doctype;
Marica93cb64e2019-12-23 18:24:56 +05302280 $.each(child_table || [], function(i, item) {
2281 frappe.model.set_value(doctype, item.name, warehouse_field, warehouse);
Saif60ec88b2018-11-13 12:07:53 +05002282 });
2283 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302284 }
Marica93cb64e2019-12-23 18:24:56 +05302285
Faris Ansari1fe891b2021-04-23 08:04:00 +05302286 coupon_code() {
ashish-greycube74dc3c92019-08-12 13:39:25 +05302287 var me = this;
Saqib Ansari27439992022-02-17 15:59:12 +05302288 frappe.run_serially([
2289 () => this.frm.doc.ignore_pricing_rule=1,
2290 () => me.ignore_pricing_rule(),
2291 () => this.frm.doc.ignore_pricing_rule=0,
2292 () => me.apply_pricing_rule()
2293 ]);
Nabin Hait92759692017-08-15 08:23:51 +05302294 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302295};
pratu16x7ae450fc2017-06-26 15:31:46 +05302296
Rohan73726722019-12-24 18:19:58 +05302297erpnext.show_serial_batch_selector = function (frm, d, callback, on_close, show_dialog) {
2298 let warehouse, receiving_stock, existing_stock;
2299 if (frm.doc.is_return) {
2300 if (["Purchase Receipt", "Purchase Invoice"].includes(frm.doc.doctype)) {
2301 existing_stock = true;
2302 warehouse = d.warehouse;
2303 } else if (["Delivery Note", "Sales Invoice"].includes(frm.doc.doctype)) {
2304 receiving_stock = true;
2305 }
2306 } else {
2307 if (frm.doc.doctype == "Stock Entry") {
2308 if (frm.doc.purpose == "Material Receipt") {
2309 receiving_stock = true;
2310 } else {
2311 existing_stock = true;
2312 warehouse = d.s_warehouse;
2313 }
2314 } else {
2315 existing_stock = true;
2316 warehouse = d.warehouse;
2317 }
2318 }
2319
2320 if (!warehouse) {
2321 if (receiving_stock) {
2322 warehouse = ["like", ""];
2323 } else if (existing_stock) {
2324 warehouse = ["!=", ""];
2325 }
2326 }
2327
pratu16x7ae450fc2017-06-26 15:31:46 +05302328 frappe.require("assets/erpnext/js/utils/serial_no_batch_selector.js", function() {
pratu16x789d001c2017-06-26 17:45:49 +05302329 new erpnext.SerialNoBatchSelector({
pratu16x7ae450fc2017-06-26 15:31:46 +05302330 frm: frm,
2331 item: d,
2332 warehouse_details: {
2333 type: "Warehouse",
Rohan73726722019-12-24 18:19:58 +05302334 name: warehouse
pratu16x7ae450fc2017-06-26 15:31:46 +05302335 },
rohitwaghchaure2b95a542017-12-14 16:06:23 +05302336 callback: callback,
2337 on_close: on_close
Rohit Waghchaure6ab63032017-09-01 15:28:44 +05302338 }, show_dialog);
pratu16x7ae450fc2017-06-26 15:31:46 +05302339 });
2340}
marination0f3cfc52020-12-08 19:11:51 +05302341
marinationc47d38d2020-12-14 11:48:04 +05302342erpnext.apply_putaway_rule = (frm, purpose=null) => {
marination0f3cfc52020-12-08 19:11:51 +05302343 if (!frm.doc.company) {
2344 frappe.throw({message: __("Please select a Company first."), title: __("Mandatory")});
2345 }
2346 if (!frm.doc.items.length) return;
2347
2348 frappe.call({
2349 method: "erpnext.stock.doctype.putaway_rule.putaway_rule.apply_putaway_rule",
2350 args: {
2351 doctype: frm.doctype,
2352 items: frm.doc.items,
2353 company: frm.doc.company,
marinationc47d38d2020-12-14 11:48:04 +05302354 sync: true,
2355 purpose: purpose
marination0f3cfc52020-12-08 19:11:51 +05302356 },
2357 callback: (result) => {
2358 if (!result.exc && result.message) {
2359 frm.clear_table("items");
2360
2361 let items = result.message;
2362 items.forEach((row) => {
marinationa5d8d322020-12-09 16:27:18 +05302363 delete row["name"]; // dont overwrite name from server side
marination0f3cfc52020-12-08 19:11:51 +05302364 let child = frm.add_child("items");
2365 Object.assign(child, row);
marinationa5d8d322020-12-09 16:27:18 +05302366 frm.script_manager.trigger("qty", child.doctype, child.name);
marination0f3cfc52020-12-08 19:11:51 +05302367 });
2368 frm.get_field("items").grid.refresh();
2369 }
2370 }
2371 });
casesolved-co-uka7803062021-02-16 05:48:50 +00002372};