blob: 365851aab677e22a5a8ba31d9208a179f1de11c8 [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
Nabin Haitb4a3dfa2015-01-22 17:13:13 +05306erpnext.TransactionController = erpnext.taxes_and_totals.extend({
Rushabh Mehtabe2ee182016-04-29 17:22:42 +05307 setup: function() {
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +05308 this._super();
Saqibfaea8542020-03-26 13:18:57 +05309 frappe.flags.hide_serial_batch_dialog = true;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053010 frappe.ui.form.on(this.frm.doctype + " Item", "rate", function(frm, cdt, cdn) {
11 var item = frappe.get_doc(cdt, cdn);
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053012 var has_margin_field = frappe.meta.has_field(cdt, 'margin_type');
13
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053014 frappe.model.round_floats_in(item, ["rate", "price_list_rate"]);
15
16 if(item.price_list_rate) {
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053017 if(item.rate > item.price_list_rate && has_margin_field) {
18 // if rate is greater than price_list_rate, set margin
19 // or set discount
20 item.discount_percentage = 0;
Nabin Haite72c98d2017-05-24 09:01:44 +053021 item.margin_type = 'Amount';
Rushabh Mehta36311022017-06-20 09:30:53 +053022 item.margin_rate_or_amount = flt(item.rate - item.price_list_rate,
Nabin Haite72c98d2017-05-24 09:01:44 +053023 precision("margin_rate_or_amount", item));
24 item.rate_with_margin = item.rate;
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053025 } else {
Rushabh Mehta36311022017-06-20 09:30:53 +053026 item.discount_percentage = flt((1 - item.rate / item.price_list_rate) * 100.0,
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053027 precision("discount_percentage", item));
Nabin Hait593242f2019-04-05 19:35:02 +053028 item.discount_amount = flt(item.price_list_rate) - flt(item.rate);
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053029 item.margin_type = '';
30 item.margin_rate_or_amount = 0;
31 item.rate_with_margin = 0;
32 }
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053033 } else {
34 item.discount_percentage = 0.0;
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053035 item.margin_type = '';
36 item.margin_rate_or_amount = 0;
37 item.rate_with_margin = 0;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053038 }
Saif Ur Rehman147fa732018-11-26 18:14:06 +050039 item.base_rate_with_margin = item.rate_with_margin * flt(frm.doc.conversion_rate);
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053040
41 cur_frm.cscript.set_gross_profit(item);
42 cur_frm.cscript.calculate_taxes_and_totals();
Anupam Kumar7e1dcf92021-02-11 20:19:30 +053043 cur_frm.cscript.calculate_stock_uom_rate(frm, cdt, cdn);
Rushabh Mehta30dc9a12017-11-17 14:31:09 +053044 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053045
Vishal Dhayaguded42242d2017-11-29 16:09:59 +053046
47
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053048 frappe.ui.form.on(this.frm.cscript.tax_table, "rate", function(frm, cdt, cdn) {
49 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053050 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053051
52 frappe.ui.form.on(this.frm.cscript.tax_table, "tax_amount", function(frm, cdt, cdn) {
53 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053054 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053055
56 frappe.ui.form.on(this.frm.cscript.tax_table, "row_id", function(frm, cdt, cdn) {
57 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053058 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053059
60 frappe.ui.form.on(this.frm.cscript.tax_table, "included_in_print_rate", function(frm, cdt, cdn) {
61 cur_frm.cscript.set_dynamic_labels();
62 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053063 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053064
65 frappe.ui.form.on(this.frm.doctype, "apply_discount_on", function(frm) {
66 if(frm.doc.additional_discount_percentage) {
67 frm.trigger("additional_discount_percentage");
68 } else {
69 cur_frm.cscript.calculate_taxes_and_totals();
70 }
Rushabh Mehta764aa922016-05-02 13:28:46 +053071 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053072
73 frappe.ui.form.on(this.frm.doctype, "additional_discount_percentage", function(frm) {
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053074 if(!frm.doc.apply_discount_on) {
75 frappe.msgprint(__("Please set 'Apply Additional Discount On'"));
Rushabh Mehta233a19a2017-07-07 13:05:11 +053076 return;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053077 }
78
79 frm.via_discount_percentage = true;
80
81 if(frm.doc.additional_discount_percentage && frm.doc.discount_amount) {
82 // Reset discount amount and net / grand total
Rushabh Mehta6705ab32017-07-07 13:14:08 +053083 frm.doc.discount_amount = 0;
84 frm.cscript.calculate_taxes_and_totals();
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053085 }
86
87 var total = flt(frm.doc[frappe.model.scrub(frm.doc.apply_discount_on)]);
88 var discount_amount = flt(total*flt(frm.doc.additional_discount_percentage) / 100,
89 precision("discount_amount"));
90
Rushabh Mehta233a19a2017-07-07 13:05:11 +053091 frm.set_value("discount_amount", discount_amount)
92 .then(() => delete frm.via_discount_percentage);
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053093 });
94
95 frappe.ui.form.on(this.frm.doctype, "discount_amount", function(frm) {
96 frm.cscript.set_dynamic_labels();
97
98 if (!frm.via_discount_percentage) {
Rushabh Mehta233a19a2017-07-07 13:05:11 +053099 frm.doc.additional_discount_percentage = 0;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +0530100 }
101
102 frm.cscript.calculate_taxes_and_totals();
103 });
Makarand Bauskarc196d742017-06-02 17:28:40 +0530104
Saif60ec88b2018-11-13 12:07:53 +0500105 frappe.ui.form.on(this.frm.doctype + " Item", {
106 items_add: function(frm, cdt, cdn) {
107 var item = frappe.get_doc(cdt, cdn);
Deepesh Gargb4be2922021-01-28 13:09:56 +0530108 if (!item.warehouse && frm.doc.set_warehouse) {
Saif60ec88b2018-11-13 12:07:53 +0500109 item.warehouse = frm.doc.set_warehouse;
110 }
Deepesh Garg6b9dda52020-11-25 14:49:10 +0530111
Deepesh Gargb4be2922021-01-28 13:09:56 +0530112 if (!item.target_warehouse && frm.doc.set_target_warehouse) {
113 item.target_warehouse = frm.doc.set_target_warehouse;
114 }
115
116 if (!item.from_warehouse && frm.doc.set_from_warehouse) {
117 item.from_warehouse = frm.doc.set_from_warehouse;
118 }
119
Deepesh Garg6b9dda52020-11-25 14:49:10 +0530120 erpnext.accounts.dimensions.copy_dimension_from_first_row(frm, cdt, cdn, 'items');
Saif60ec88b2018-11-13 12:07:53 +0500121 }
122 });
123
Makarand Bauskarc196d742017-06-02 17:28:40 +0530124 var me = this;
125 if(this.frm.fields_dict["items"].grid.get_field('batch_no')) {
126 this.frm.set_query("batch_no", "items", function(doc, cdt, cdn) {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530127 return me.set_query_for_batch(doc, cdt, cdn);
Makarand Bauskarc196d742017-06-02 17:28:40 +0530128 });
129 }
Akhilesh Darjee564c6212013-10-17 11:31:11 +0530130
tundebabzy590bd0a2017-12-25 07:10:19 +0100131 if(
Faris Ansari404f39d2018-05-14 15:46:45 +0530132 this.frm.docstatus < 2
Manas Solankia7f55892018-04-02 10:32:00 +0530133 && this.frm.fields_dict["payment_terms_template"]
tundebabzy590bd0a2017-12-25 07:10:19 +0100134 && this.frm.fields_dict["payment_schedule"]
135 && this.frm.doc.payment_terms_template
136 && !this.frm.doc.payment_schedule.length
137 ){
tundedf3a1752017-09-11 11:02:57 +0100138 this.frm.trigger("payment_terms_template");
139 }
140
Nabin Haitdd38a262014-12-26 13:15:21 +0530141 if(this.frm.fields_dict["taxes"]) {
142 this["taxes_remove"] = this.calculate_taxes_and_totals;
Anand Doshia91c95f2013-08-23 13:00:47 +0530143 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530144
Nabin Haitdd38a262014-12-26 13:15:21 +0530145 if(this.frm.fields_dict["items"]) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530146 this["items_remove"] = this.calculate_net_weight;
Anand Doshi1e4fb682013-08-23 12:56:33 +0530147 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530148
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530149 if(this.frm.fields_dict["recurring_print_format"]) {
150 this.frm.set_query("recurring_print_format", function(doc) {
151 return{
152 filters: [
153 ['Print Format', 'doc_type', '=', cur_frm.doctype],
154 ]
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530155 };
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530156 });
157 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530158
Nabin Hait1d218422015-07-17 15:19:02 +0530159 if(this.frm.fields_dict["return_against"]) {
160 this.frm.set_query("return_against", function(doc) {
161 var filters = {
162 "docstatus": 1,
163 "is_return": 0,
164 "company": doc.company
165 };
166 if (me.frm.fields_dict["customer"] && doc.customer) filters["customer"] = doc.customer;
167 if (me.frm.fields_dict["supplier"] && doc.supplier) filters["supplier"] = doc.supplier;
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530168
Nabin Hait1d218422015-07-17 15:19:02 +0530169 return {
170 filters: filters
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530171 };
Nabin Hait1d218422015-07-17 15:19:02 +0530172 });
173 }
michellealva08f842d2020-06-26 19:56:00 +0530174
rohitwaghchaured5736712020-06-28 11:12:20 +0530175 if (this.frm.fields_dict["items"].grid.get_field("expense_account")) {
michellealva08f842d2020-06-26 19:56:00 +0530176 this.frm.set_query("expense_account", "items", function(doc) {
rohitwaghchaured5736712020-06-28 11:12:20 +0530177 return {
michellealva08f842d2020-06-26 19:56:00 +0530178 filters: {
179 "company": doc.company
180 }
181 };
182 });
183 }
184
Rohit Waghchauree5405342019-03-31 16:42:41 +0530185 if(frappe.meta.get_docfield(this.frm.doc.doctype, "pricing_rules")) {
Rohit Waghchaure70b996a2019-03-31 20:33:15 +0530186 this.frm.set_indicator_formatter('pricing_rule', function(doc) {
187 return (doc.rule_applied) ? "green" : "red";
188 });
Rohit Waghchauree5405342019-03-31 16:42:41 +0530189 }
Rohit Waghchaurea5357c22020-03-27 12:54:01 +0530190
191 let batch_no_field = this.frm.get_docfield("items", "batch_no");
192 if (batch_no_field) {
193 batch_no_field.get_route_options_for_new_doc = function(row) {
194 return {
195 "item": row.doc.item_code
196 }
197 };
198 }
199
Marica299e2172020-04-28 13:00:04 +0530200 if (this.frm.fields_dict["items"].grid.get_field('blanket_order')) {
201 this.frm.set_query("blanket_order", "items", function(doc, cdt, cdn) {
202 var item = locals[cdt][cdn];
203 return {
204 query: "erpnext.controllers.queries.get_blanket_orders",
205 filters: {
206 "company": doc.company,
207 "blanket_order_type": doc.doctype === "Sales Order" ? "Selling" : "Purchasing",
208 "item": item.item_code
209 }
210 }
211 });
212 }
213
Mohammad Hasnain Mohsin Rajane15b6a92020-11-25 15:36:41 +0530214 if (this.frm.fields_dict.taxes_and_charges) {
215 this.frm.set_query("taxes_and_charges", function() {
216 return {
217 filters: [
218 ['company', '=', me.frm.doc.company],
219 ['docstatus', '!=', 2]
220 ]
221 };
222 });
223 }
224
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530225 },
226 onload: function() {
227 var me = this;
Rushabh Mehta6b537922017-03-14 16:59:11 +0530228
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530229 if(this.frm.doc.__islocal) {
230 var currency = frappe.defaults.get_user_default("currency");
231
232 let set_value = (fieldname, value) => {
233 if(me.frm.fields_dict[fieldname] && !me.frm.doc[fieldname]) {
234 return me.frm.set_value(fieldname, value);
235 }
236 };
237
Deepesh Gargb4be2922021-01-28 13:09:56 +0530238 this.frm.trigger('set_default_internal_warehouse');
239
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530240 return frappe.run_serially([
241 () => set_value('currency', currency),
242 () => set_value('price_list_currency', currency),
243 () => set_value('status', 'Draft'),
244 () => set_value('is_subcontracted', 'No'),
245 () => {
246 if(this.frm.doc.company && !this.frm.doc.amended_from) {
247 this.frm.trigger("company");
248 }
249 }
250 ]);
251 }
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530252 },
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530253
Rohit Waghchaureb4a59932018-11-26 20:02:01 +0530254 is_return: function() {
255 if(!this.frm.doc.is_return && this.frm.doc.return_against) {
256 this.frm.set_value('return_against', '');
257 }
258 },
259
Nabin Hait8af429d2016-11-16 17:21:59 +0530260 setup_quality_inspection: function() {
261 if(!in_list(["Delivery Note", "Sales Invoice", "Purchase Receipt", "Purchase Invoice"], this.frm.doc.doctype)) {
262 return;
263 }
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530264 var me = this;
Rushabh Mehta6b537922017-03-14 16:59:11 +0530265 var inspection_type = in_list(["Purchase Receipt", "Purchase Invoice"], this.frm.doc.doctype)
Nabin Hait8af429d2016-11-16 17:21:59 +0530266 ? "Incoming" : "Outgoing";
Rushabh Mehta6b537922017-03-14 16:59:11 +0530267
Manas Solankia8d1bc72016-11-15 14:48:23 +0530268 var quality_inspection_field = this.frm.get_docfield("items", "quality_inspection");
Nabin Hait8af429d2016-11-16 17:21:59 +0530269 quality_inspection_field.get_route_options_for_new_doc = function(row) {
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530270 if(me.frm.is_new()) return;
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530271 return {
272 "inspection_type": inspection_type,
Manas Solanki34feab12016-11-16 14:36:28 +0530273 "reference_type": me.frm.doc.doctype,
Manas Solankidbc25112016-11-16 15:06:08 +0530274 "reference_name": me.frm.doc.name,
Nabin Hait8af429d2016-11-16 17:21:59 +0530275 "item_code": row.doc.item_code,
276 "description": row.doc.description,
277 "item_serial_no": row.doc.serial_no ? row.doc.serial_no.split("\n")[0] : null,
278 "batch_no": row.doc.batch_no
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530279 }
280 }
Rushabh Mehta6b537922017-03-14 16:59:11 +0530281
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530282 this.frm.set_query("quality_inspection", "items", function(doc, cdt, cdn) {
283 var d = locals[cdt][cdn];
284 return {
285 filters: {
286 docstatus: 1,
287 inspection_type: inspection_type,
rohitwaghchaure4e8fdf72018-02-22 11:03:48 +0530288 reference_name: doc.name,
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530289 item_code: d.item_code
290 }
291 }
292 });
Anand Doshi3543f302013-05-24 19:25:01 +0530293 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530294
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530295 make_payment_request: function() {
Rohit Waghchaure210f4982018-10-03 15:55:51 +0530296 var me = this;
297 const payment_request_type = (in_list(['Sales Order', 'Sales Invoice'], this.frm.doc.doctype))
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530298 ? "Inward" : "Outward";
299
300 frappe.call({
301 method:"erpnext.accounts.doctype.payment_request.payment_request.make_payment_request",
302 args: {
303 dt: me.frm.doc.doctype,
304 dn: me.frm.doc.name,
305 recipient_id: me.frm.doc.contact_email,
306 payment_request_type: payment_request_type,
307 party_type: payment_request_type == 'Outward' ? "Supplier" : "Customer",
308 party: payment_request_type == 'Outward' ? me.frm.doc.supplier : me.frm.doc.customer
309 },
310 callback: function(r) {
311 if(!r.exc){
312 var doc = frappe.model.sync(r.message);
313 frappe.set_route("Form", r.message.doctype, r.message.name);
314 }
315 }
316 })
317 },
318
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530319 onload_post_render: function() {
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530320 if(this.frm.doc.__islocal && !(this.frm.doc.taxes || []).length
321 && !(this.frm.doc.__onload ? this.frm.doc.__onload.load_after_mapping : false)) {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530322 frappe.after_ajax(() => this.apply_default_taxes());
Anand Doshi70f57eb2015-11-27 14:37:40 +0530323 } else if(this.frm.doc.__islocal && this.frm.doc.company && this.frm.doc["items"]
Nabin Haitbdfb0702015-10-28 15:38:08 +0530324 && !this.frm.doc.is_pos) {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530325 frappe.after_ajax(() => this.calculate_taxes_and_totals());
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530326 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530327 if(frappe.meta.get_docfield(this.frm.doc.doctype + " Item", "item_code")) {
Rushabh Mehta203cc962016-04-07 15:25:43 +0530328 this.setup_item_selector();
Nabin Hait3fccfaa2019-05-16 14:48:10 +0530329 this.frm.get_field("items").grid.set_multiple_add("item_code", "qty");
Rushabh Mehtab6843f22014-06-04 13:10:41 +0530330 }
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530331 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530332
Anand Doshi3543f302013-05-24 19:25:01 +0530333 refresh: function() {
Anand Doshi8bde7f92014-04-24 18:11:49 +0530334 erpnext.toggle_naming_series();
Anand Doshibdee6e02013-07-09 13:03:39 +0530335 erpnext.hide_company();
Nabin Hait1f996c32013-07-29 19:00:53 +0530336 this.set_dynamic_labels();
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530337 this.setup_sms();
Rohit Waghchauref2705672018-06-12 12:20:52 +0530338 this.setup_quality_inspection();
Faris Ansari8beca682019-09-16 15:20:10 +0530339 let scan_barcode_field = this.frm.get_field('scan_barcode');
Suraj Shetty3e3a7932020-04-26 23:25:40 +0530340 if (scan_barcode_field && scan_barcode_field.get_value()) {
Faris Ansari8beca682019-09-16 15:20:10 +0530341 scan_barcode_field.set_value("");
342 scan_barcode_field.set_new_description("");
343
344 if (frappe.is_mobile()) {
345 if (scan_barcode_field.$input_wrapper.find('.input-group').length) return;
346
347 let $input_group = $('<div class="input-group">');
348 scan_barcode_field.$input_wrapper.find('.control-input').append($input_group);
349 $input_group.append(scan_barcode_field.$input);
350 $(`<span class="input-group-btn" style="vertical-align: top">
351 <button class="btn btn-default border" type="button">
352 <i class="fa fa-camera text-muted"></i>
353 </button>
354 </span>`)
355 .on('click', '.btn', () => {
356 frappe.barcode.scan_barcode().then(barcode => {
357 scan_barcode_field.set_value(barcode);
358 });
359 })
360 .appendTo($input_group);
361 }
362 }
Zarrar69224152018-11-13 11:11:32 +0530363 },
364
365 scan_barcode: function() {
366 let scan_barcode_field = this.frm.fields_dict["scan_barcode"];
367
Faris Ansari5631ffc2019-02-12 17:12:48 +0530368 let show_description = function(idx, exist = null) {
369 if (exist) {
Marica8f6bd852020-10-29 18:55:52 +0530370 frappe.show_alert({
371 message: __('Row #{0}: Qty increased by 1', [idx]),
372 indicator: 'green'
373 });
Zarrar69224152018-11-13 11:11:32 +0530374 } else {
Marica8f6bd852020-10-29 18:55:52 +0530375 frappe.show_alert({
376 message: __('Row #{0}: Item added', [idx]),
377 indicator: 'green'
378 });
Zarrar69224152018-11-13 11:11:32 +0530379 }
380 }
381
382 if(this.frm.doc.scan_barcode) {
383 frappe.call({
384 method: "erpnext.selling.page.point_of_sale.point_of_sale.search_serial_or_batch_or_barcode_number",
385 args: { search_value: this.frm.doc.scan_barcode }
386 }).then(r => {
Faris Ansari5631ffc2019-02-12 17:12:48 +0530387 const data = r && r.message;
Nabin Hait34c551d2019-07-03 10:34:31 +0530388 if (!data || Object.keys(data).length === 0) {
Marica8f6bd852020-10-29 18:55:52 +0530389 frappe.show_alert({
390 message: __('Cannot find Item with this Barcode'),
391 indicator: 'red'
392 });
Faris Ansari5631ffc2019-02-12 17:12:48 +0530393 return;
Zarrar69224152018-11-13 11:11:32 +0530394 }
Faris Ansari5631ffc2019-02-12 17:12:48 +0530395
396 let cur_grid = this.frm.fields_dict.items.grid;
397
398 let row_to_modify = null;
399 const existing_item_row = this.frm.doc.items.find(d => d.item_code === data.item_code);
400 const blank_item_row = this.frm.doc.items.find(d => !d.item_code);
401
402 if (existing_item_row) {
403 row_to_modify = existing_item_row;
404 } else if (blank_item_row) {
405 row_to_modify = blank_item_row;
Zarrar69224152018-11-13 11:11:32 +0530406 }
Faris Ansari5631ffc2019-02-12 17:12:48 +0530407
408 if (!row_to_modify) {
409 // add new row
410 row_to_modify = frappe.model.add_child(this.frm.doc, cur_grid.doctype, 'items');
411 }
412
413 show_description(row_to_modify.idx, row_to_modify.item_code);
414
Mohammad Hasnain Mohsin Rajance1ca282020-12-10 17:48:05 +0530415 this.frm.from_barcode = this.frm.from_barcode ? this.frm.from_barcode + 1 : 1;
Faris Ansari5631ffc2019-02-12 17:12:48 +0530416 frappe.model.set_value(row_to_modify.doctype, row_to_modify.name, {
417 item_code: data.item_code,
418 qty: (row_to_modify.qty || 0) + 1
419 });
420
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530421 ['serial_no', 'batch_no', 'barcode'].forEach(field => {
422 if (data[field] && frappe.meta.has_field(row_to_modify.doctype, field)) {
rohitwaghchaure86aff0d2020-03-31 15:26:45 +0530423
424 let value = (row_to_modify[field] && field === "serial_no")
425 ? row_to_modify[field] + '\n' + data[field] : data[field];
426
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530427 frappe.model.set_value(row_to_modify.doctype,
rohitwaghchaure86aff0d2020-03-31 15:26:45 +0530428 row_to_modify.name, field, value);
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530429 }
430 });
431
432 scan_barcode_field.set_value('');
rohitwaghchaure86aff0d2020-03-31 15:26:45 +0530433 refresh_field("items");
Zarrar69224152018-11-13 11:11:32 +0530434 });
Zarrar69224152018-11-13 11:11:32 +0530435 }
436 return false;
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530437 },
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530438
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530439 apply_default_taxes: function() {
440 var me = this;
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530441 var taxes_and_charges_field = frappe.meta.get_docfield(me.frm.doc.doctype, "taxes_and_charges",
442 me.frm.doc.name);
443
SDLyu68672af2020-09-18 13:58:23 +0800444 if (!this.frm.doc.taxes_and_charges && this.frm.doc.taxes && this.frm.doc.taxes.length > 0) {
rohitwaghchaure1f39feb2018-01-05 12:25:45 +0530445 return;
446 }
447
448 if (taxes_and_charges_field) {
Nabin Haitbdfb0702015-10-28 15:38:08 +0530449 return frappe.call({
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530450 method: "erpnext.controllers.accounts_controller.get_default_taxes_and_charges",
451 args: {
rohitwaghchaure505661b2017-12-11 14:52:28 +0530452 "master_doctype": taxes_and_charges_field.options,
Rushabh Mehta39154e52020-12-10 12:37:16 +0530453 "tax_template": me.frm.doc.taxes_and_charges || "",
rohitwaghchaure505661b2017-12-11 14:52:28 +0530454 "company": me.frm.doc.company
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530455 },
Rushabh Mehta39154e52020-12-10 12:37:16 +0530456 debounce: 2000,
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530457 callback: function(r) {
Nabin Haita2426fc2018-01-15 17:45:46 +0530458 if(!r.exc && r.message) {
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530459 frappe.run_serially([
460 () => {
461 // directly set in doc, so as not to call triggers
rohitwaghchaure1bc47fa2017-12-16 10:49:58 +0530462 if(r.message.taxes_and_charges) {
463 me.frm.doc.taxes_and_charges = r.message.taxes_and_charges;
464 }
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530465
466 // set taxes table
rohitwaghchaure1bc47fa2017-12-16 10:49:58 +0530467 if(r.message.taxes) {
468 me.frm.set_value("taxes", r.message.taxes);
469 }
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530470 },
Saif3c9155e2018-10-18 17:27:56 +0500471 () => me.set_dynamic_labels(),
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530472 () => me.calculate_taxes_and_totals()
473 ]);
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530474 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530475 }
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530476 });
477 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530478 },
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530479
480 setup_sms: function() {
481 var me = this;
Faris Ansaria5d975d2019-07-04 17:47:28 +0530482 let blacklist = ['Purchase Invoice', 'BOM'];
Nabin Hait7132bd32016-04-13 15:19:37 +0530483 if(this.frm.doc.docstatus===1 && !in_list(["Lost", "Stopped", "Closed"], this.frm.doc.status)
Faris Ansaria5d975d2019-07-04 17:47:28 +0530484 && !blacklist.includes(this.frm.doctype)) {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530485 this.frm.page.add_menu_item(__('Send SMS'), function() { me.send_sms(); });
486 }
487 },
488
489 send_sms: function() {
Faris Ansariab74ca72017-05-30 12:54:42 +0530490 var sms_man = new erpnext.SMSManager(this.frm.doc);
Nabin Hait239c2c32015-01-15 14:21:41 +0530491 },
Anand Doshi50d7e8c2015-01-06 17:14:13 +0530492
Neil Trini Lasradod0151952015-06-09 15:21:50 +0530493 barcode: function(doc, cdt, cdn) {
494 var d = locals[cdt][cdn];
495 if(d.barcode=="" || d.barcode==null) {
496 // barcode cleared, remove item
497 d.item_code = "";
498 }
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530499
Mohammad Hasnain Mohsin Rajan8abe7b92020-12-10 17:48:22 +0530500 this.frm.from_barcode = this.frm.from_barcode ? this.frm.from_barcode + 1 : 1;
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530501 this.item_code(doc, cdt, cdn);
Neil Trini Lasradod0151952015-06-09 15:21:50 +0530502 },
503
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530504 item_code: function(doc, cdt, cdn) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530505 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530506 var item = frappe.get_doc(cdt, cdn);
pratu16x75f389c92017-06-26 13:38:24 +0530507 var update_stock = 0, show_batch_dialog = 0;
rohitwaghchaure5999ade2017-08-09 17:24:13 +0530508 if(['Sales Invoice'].includes(this.frm.doc.doctype)) {
pratu16x7577e4c42017-06-23 11:39:03 +0530509 update_stock = cint(me.frm.doc.update_stock);
510 show_batch_dialog = update_stock;
pratu16x7ae450fc2017-06-26 15:31:46 +0530511
512 } else if((this.frm.doc.doctype === 'Purchase Receipt' && me.frm.doc.is_return) ||
513 this.frm.doc.doctype === 'Delivery Note') {
pratu16x789d001c2017-06-26 17:45:49 +0530514 show_batch_dialog = 1;
pratu16x7577e4c42017-06-23 11:39:03 +0530515 }
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530516 // clear barcode if setting item (else barcode will take priority)
Mohammad Hasnain Mohsin Rajandeaf2e82020-12-09 12:36:14 +0530517 if (this.frm.from_barcode == 0) {
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530518 item.barcode = null;
519 }
Mohammad Hasnain Mohsin Rajandeaf2e82020-12-09 12:36:14 +0530520 this.frm.from_barcode = this.frm.from_barcode - 1 >= 0 ? this.frm.from_barcode - 1 : 0;
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530521
Mohammad Hasnain69514c42020-12-09 12:10:28 +0530522
Nabin Hait139dc7b2014-02-12 14:53:18 +0530523 if(item.item_code || item.barcode || item.serial_no) {
524 if(!this.validate_company_and_party()) {
pratu16x7577e4c42017-06-23 11:39:03 +0530525 this.frm.fields_dict["items"].grid.grid_rows[item.idx - 1].remove();
Nabin Hait139dc7b2014-02-12 14:53:18 +0530526 } else {
527 return this.frm.call({
528 method: "erpnext.stock.get_item_details.get_item_details",
529 child: item,
530 args: {
Rohit Waghchauree5405342019-03-31 16:42:41 +0530531 doc: me.frm.doc,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530532 args: {
533 item_code: item.item_code,
534 barcode: item.barcode,
535 serial_no: item.serial_no,
marinatione05013e2020-04-06 22:13:13 +0530536 batch_no: item.batch_no,
Saif Ur Rehman2689dea2019-01-09 13:43:06 +0500537 set_warehouse: me.frm.doc.set_warehouse,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530538 warehouse: item.warehouse,
Nabin Hait34c551d2019-07-03 10:34:31 +0530539 customer: me.frm.doc.customer || me.frm.doc.party_name,
540 quotation_to: me.frm.doc.quotation_to,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530541 supplier: me.frm.doc.supplier,
542 currency: me.frm.doc.currency,
pratu16x7577e4c42017-06-23 11:39:03 +0530543 update_stock: update_stock,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530544 conversion_rate: me.frm.doc.conversion_rate,
Faris Ansariab74ca72017-05-30 12:54:42 +0530545 price_list: me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530546 price_list_currency: me.frm.doc.price_list_currency,
547 plc_conversion_rate: me.frm.doc.plc_conversion_rate,
548 company: me.frm.doc.company,
549 order_type: me.frm.doc.order_type,
550 is_pos: cint(me.frm.doc.is_pos),
Saqib1f591ab2021-01-05 13:53:51 +0530551 is_return: cint(me.frm.doc.is_return),
Nabin Hait139dc7b2014-02-12 14:53:18 +0530552 is_subcontracted: me.frm.doc.is_subcontracted,
Nabin Haita1bf43b2015-03-17 10:50:47 +0530553 transaction_date: me.frm.doc.transaction_date || me.frm.doc.posting_date,
Nabin Hait444f9562014-06-20 15:59:49 +0530554 ignore_pricing_rule: me.frm.doc.ignore_pricing_rule,
Anand Doshiafe85bd2016-01-21 21:04:16 +0530555 doctype: me.frm.doc.doctype,
556 name: me.frm.doc.name,
Neil Trini Lasrado6e343e22016-03-09 17:02:59 +0530557 project: item.project || me.frm.doc.project,
mbauskarba412422017-04-19 12:35:51 +0530558 qty: item.qty || 1,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530559 stock_qty: item.stock_qty,
rohitwaghchaurec037dc72017-11-28 16:11:15 +0530560 conversion_factor: item.conversion_factor,
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530561 weight_per_unit: item.weight_per_unit,
562 weight_uom: item.weight_uom,
Rohit Waghchaure3cf24362019-06-02 16:03:05 +0530563 manufacturer: item.manufacturer,
Nabin Hait158e7dc2019-01-04 11:04:37 +0530564 stock_uom: item.stock_uom,
Sanjay Kumar1b49f3a2018-09-06 13:09:35 +0400565 pos_profile: me.frm.doc.doctype == 'Sales Invoice' ? me.frm.doc.pos_profile : '',
Saif Ur Rehman67786682018-12-27 02:11:07 +0500566 cost_center: item.cost_center,
567 tax_category: me.frm.doc.tax_category,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530568 item_tax_template: item.item_tax_template,
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530569 child_docname: item.name
Nabin Hait139dc7b2014-02-12 14:53:18 +0530570 }
571 },
Anand Doshi13945092014-09-21 19:45:49 +0530572
Nabin Hait139dc7b2014-02-12 14:53:18 +0530573 callback: function(r) {
574 if(!r.exc) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530575 frappe.run_serially([
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500576 () => {
577 var d = locals[cdt][cdn];
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +0500578 me.add_taxes_from_item_tax_template(d.item_tax_rate);
Rohit Waghchaure2ae79b82019-12-18 17:48:39 +0530579 if (d.free_item_data) {
580 me.apply_product_discount(d.free_item_data);
581 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500582 },
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530583 () => {
584 // for internal customer instead of pricing rule directly apply valuation rate on item
585 if (me.frm.doc.is_internal_customer || me.frm.doc.is_internal_supplier) {
586 me.get_incoming_rate(item, me.frm.posting_date, me.frm.posting_time,
587 me.frm.doc.doctype, me.frm.doc.company);
588 } else {
589 me.frm.script_manager.trigger("price_list_rate", cdt, cdn);
590 }
591 },
592 () => {
593 if (me.frm.doc.is_internal_customer || me.frm.doc.is_internal_supplier) {
594 me.calculate_taxes_and_totals();
595 }
596 },
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530597 () => me.toggle_conversion_factor(item),
598 () => {
Saqibfaea8542020-03-26 13:18:57 +0530599 if (show_batch_dialog)
600 return frappe.db.get_value("Item", item.item_code, ["has_batch_no", "has_serial_no"])
601 .then((r) => {
Rohit Waghchaureafe8e882020-06-10 17:55:24 +0530602 if (r.message &&
Deepesh Garg16bcd012021-01-28 12:09:35 +0530603 (r.message.has_batch_no || r.message.has_serial_no)) {
Saqibfaea8542020-03-26 13:18:57 +0530604 frappe.flags.hide_serial_batch_dialog = false;
605 }
606 });
607 },
608 () => {
Deepesh Garg16bcd012021-01-28 12:09:35 +0530609 // check if batch serial selector is disabled or not
610 if (show_batch_dialog && !frappe.flags.hide_serial_batch_dialog)
611 return frappe.db.get_single_value('Stock Settings', 'disable_serial_no_and_batch_selector')
612 .then((value) => {
613 if (value) {
614 frappe.flags.hide_serial_batch_dialog = true;
615 }
616 });
617 },
618 () => {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530619 if(show_batch_dialog && !frappe.flags.hide_serial_batch_dialog) {
620 var d = locals[cdt][cdn];
621 $.each(r.message, function(k, v) {
622 if(!d[k]) d[k] = v;
623 });
Rohit Waghchaure6ab63032017-09-01 15:28:44 +0530624
Saqib14cdb242020-04-16 16:21:35 +0530625 if (d.has_batch_no && d.has_serial_no) {
626 d.batch_no = undefined;
627 }
628
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530629 erpnext.show_serial_batch_selector(me.frm, d, (item) => {
630 me.frm.script_manager.trigger('qty', item.doctype, item.name);
Saqibfaea8542020-03-26 13:18:57 +0530631 if (!me.frm.doc.set_warehouse)
632 me.frm.script_manager.trigger('warehouse', item.doctype, item.name);
633 }, undefined, !frappe.flags.hide_serial_batch_dialog);
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530634 }
635 },
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530636 () => me.conversion_factor(doc, cdt, cdn, true),
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +0530637 () => me.remove_pricing_rule(item),
638 () => {
639 if (item.apply_rule_on_other_items) {
640 let key = item.name;
641 me.apply_rule_on_other_items({key: item});
642 }
643 }
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530644 ]);
Nabin Hait139dc7b2014-02-12 14:53:18 +0530645 }
646 }
647 });
648 }
649 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530650 },
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530651
Anupam Kumared42afc2021-03-15 11:11:28 +0530652 price_list_rate: function(doc, cdt, cdn) {
653 var item = frappe.get_doc(cdt, cdn);
654 frappe.model.round_floats_in(item, ["price_list_rate", "discount_percentage"]);
655
656 // check if child doctype is Sales Order Item/Qutation Item and calculate the rate
657 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)
658 this.apply_pricing_rule_on_item(item);
659 else
660 item.rate = flt(item.price_list_rate * (1 - item.discount_percentage / 100.0),
661 precision("rate", item));
662
663 this.calculate_taxes_and_totals();
664 },
665
666 margin_rate_or_amount: function(doc, cdt, cdn) {
667 // calculated the revised total margin and rate on margin rate changes
668 let item = frappe.get_doc(cdt, cdn);
669 this.apply_pricing_rule_on_item(item);
670 this.calculate_taxes_and_totals();
671 cur_frm.refresh_fields();
672 },
673
674 margin_type: function(doc, cdt, cdn) {
675 // calculate the revised total margin and rate on margin type changes
676 let item = frappe.get_doc(cdt, cdn);
677 if (!item.margin_type) {
678 frappe.model.set_value(cdt, cdn, "margin_rate_or_amount", 0);
679 } else {
680 this.apply_pricing_rule_on_item(item, doc, cdt, cdn);
681 this.calculate_taxes_and_totals();
682 cur_frm.refresh_fields();
683 }
684 },
685
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530686 get_incoming_rate: function(item, posting_date, posting_time, voucher_type, company) {
687
688 let item_args = {
689 'item_code': item.item_code,
690 'warehouse': in_list('Purchase Receipt', 'Purchase Invoice') ? item.from_warehouse : item.warehouse,
691 'posting_date': posting_date,
692 'posting_time': posting_time,
693 'qty': item.qty * item.conversion_factor,
694 'serial_no': item.serial_no,
695 'voucher_type': voucher_type,
696 'company': company,
697 'allow_zero_valuation_rate': item.allow_zero_valuation_rate
698 }
699
700 frappe.call({
701 method: 'erpnext.stock.utils.get_incoming_rate',
702 args: {
703 args: item_args
704 },
705 callback: function(r) {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530706 frappe.model.set_value(item.doctype, item.name, 'rate', r.message * item.conversion_factor);
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530707 }
708 });
709 },
710
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500711 add_taxes_from_item_tax_template: function(item_tax_map) {
712 let me = this;
713
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +0500714 if(item_tax_map && cint(frappe.defaults.get_default("add_taxes_from_item_tax_template"))) {
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500715 if(typeof (item_tax_map) == "string") {
716 item_tax_map = JSON.parse(item_tax_map);
717 }
718
719 $.each(item_tax_map, function(tax, rate) {
720 let found = (me.frm.doc.taxes || []).find(d => d.account_head === tax);
721 if(!found) {
722 let child = frappe.model.add_child(me.frm.doc, "taxes");
723 child.charge_type = "On Net Total";
724 child.account_head = tax;
Saqib7d9dd3c2020-10-28 17:07:10 +0530725 child.rate = 0;
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500726 }
727 });
728 }
729 },
730
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530731 serial_no: function(doc, cdt, cdn) {
732 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530733 var item = frappe.get_doc(cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530734
deepeshgarg00749cca7a2019-01-25 16:41:01 +0530735 if (item && item.serial_no) {
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530736 if (!item.item_code) {
Rushabh Mehtab66edd12017-03-30 21:21:56 +0530737 this.frm.trigger("item_code", cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530738 }
739 else {
Nabin Hait79c21912017-07-12 14:10:43 +0530740 var valid_serial_nos = [];
Jannat Patel12f09232021-03-23 21:09:49 +0530741 var serialnos = [];
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530742 // Replacing all occurences of comma with carriage return
Jannat Patel12f09232021-03-23 21:09:49 +0530743 item.serial_no = item.serial_no.replace(/,/g, '\n');
744 serialnos = item.serial_no.split("\n");
745 for (var i = 0; i < serialnos.length; i++) {
746 if (serialnos[i] != "") {
747 valid_serial_nos.push(serialnos[i]);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530748 }
749 }
marinatione05013e2020-04-06 22:13:13 +0530750 item.conversion_factor = item.conversion_factor || 1;
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530751
752 refresh_field("serial_no", item.name, item.parentfield);
Nabin Haited376ca2018-05-03 16:24:52 +0530753 if(!doc.is_return && cint(user_defaults.set_qty_in_transactions_based_on_serial_no_input)) {
Rushabh Mehta6b537922017-03-14 16:59:11 +0530754 frappe.model.set_value(item.doctype, item.name,
Nabin Hait79c21912017-07-12 14:10:43 +0530755 "qty", valid_serial_nos.length / item.conversion_factor);
756 frappe.model.set_value(item.doctype, item.name, "stock_qty", valid_serial_nos.length);
Nabin Haitb7c0c552015-08-04 12:18:12 +0530757 }
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530758 }
759 }
760 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530761
Anand Doshi923d41d2013-05-28 17:23:36 +0530762 validate: function() {
Anand Doshi652bc072014-04-16 15:21:46 +0530763 this.calculate_taxes_and_totals(false);
Anand Doshi923d41d2013-05-28 17:23:36 +0530764 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530765
Deepesh Gargb4be2922021-01-28 13:09:56 +0530766 update_stock: function() {
767 this.frm.trigger('set_default_internal_warehouse');
768 },
769
770 set_default_internal_warehouse: function() {
771 let me = this;
772 if ((this.frm.doc.doctype === 'Sales Invoice' && me.frm.doc.update_stock)
773 || this.frm.doc.doctype == 'Delivery Note') {
774 if (this.frm.doc.is_internal_customer && this.frm.doc.company === this.frm.doc.represents_company) {
775 frappe.db.get_value('Company', this.frm.doc.company, 'default_in_transit_warehouse', function(value) {
776 me.frm.set_value('set_target_warehouse', value.default_in_transit_warehouse);
777 });
778 }
779 }
780
781 if ((this.frm.doc.doctype === 'Purchase Invoice' && me.frm.doc.update_stock)
782 || this.frm.doc.doctype == 'Purchase Receipt') {
783 if (this.frm.doc.is_internal_supplier && this.frm.doc.company === this.frm.doc.represents_company) {
784 frappe.db.get_value('Company', this.frm.doc.company, 'default_in_transit_warehouse', function(value) {
785 me.frm.set_value('set_from_warehouse', value.default_in_transit_warehouse);
786 });
787 }
788 }
789 },
790
Anand Doshi3543f302013-05-24 19:25:01 +0530791 company: function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530792 var me = this;
Nabin Haita731ad42016-02-04 17:21:28 +0530793 var set_pricing = function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530794 if(me.frm.doc.company && me.frm.fields_dict.currency) {
795 var company_currency = me.get_company_currency();
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530796 var company_doc = frappe.get_doc(":Company", me.frm.doc.company);
tundebabzy5510d072017-09-29 10:51:59 +0100797
Nabin Hait1f10d692017-10-02 13:20:51 +0530798 if (!me.frm.doc.currency) {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530799 me.frm.set_value("currency", company_currency);
800 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530801
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530802 if (me.frm.doc.currency == company_currency) {
803 me.frm.set_value("conversion_rate", 1.0);
804 }
805 if (me.frm.doc.price_list_currency == company_currency) {
806 me.frm.set_value('plc_conversion_rate', 1.0);
807 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530808 if (company_doc.default_letter_head) {
Rushabh Mehtac1857342015-05-27 12:29:57 +0530809 if(me.frm.fields_dict.letter_head) {
810 me.frm.set_value("letter_head", company_doc.default_letter_head);
811 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530812 }
karthikeyan57fc60212019-07-04 22:46:16 +0530813 let selling_doctypes_for_tc = ["Sales Invoice", "Quotation", "Sales Order", "Delivery Note"];
814 if (company_doc.default_selling_terms && frappe.meta.has_field(me.frm.doc.doctype, "tc_name") &&
815 selling_doctypes_for_tc.indexOf(me.frm.doc.doctype) != -1) {
816 me.frm.set_value("tc_name", company_doc.default_selling_terms);
817 }
818 let buying_doctypes_for_tc = ["Request for Quotation", "Supplier Quotation", "Purchase Order",
819 "Material Request", "Purchase Receipt"];
820 // Purchase Invoice is excluded as per issue #3345
821 if (company_doc.default_buying_terms && frappe.meta.has_field(me.frm.doc.doctype, "tc_name") &&
822 buying_doctypes_for_tc.indexOf(me.frm.doc.doctype) != -1) {
823 me.frm.set_value("tc_name", company_doc.default_buying_terms);
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530824 }
Akhilesh Darjee1797cfe2013-10-11 13:34:10 +0530825
rohitwaghchaure505661b2017-12-11 14:52:28 +0530826 frappe.run_serially([
827 () => me.frm.script_manager.trigger("currency"),
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +0500828 () => me.update_item_tax_map(),
rohitwaghchaure505661b2017-12-11 14:52:28 +0530829 () => me.apply_default_taxes(),
830 () => me.apply_pricing_rule()
831 ]);
Nabin Haitdd38a262014-12-26 13:15:21 +0530832 }
Anand Doshi3543f302013-05-24 19:25:01 +0530833 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530834
Nabin Haita731ad42016-02-04 17:21:28 +0530835 var set_party_account = function(set_pricing) {
836 if (in_list(["Sales Invoice", "Purchase Invoice"], me.frm.doc.doctype)) {
837 if(me.frm.doc.doctype=="Sales Invoice") {
838 var party_type = "Customer";
839 var party_account_field = 'debit_to';
840 } else {
841 var party_type = "Supplier";
842 var party_account_field = 'credit_to';
843 }
Anand Doshi39a28912016-02-15 11:42:18 +0530844
Nabin Haitef864402016-02-10 14:47:25 +0530845 var party = me.frm.doc[frappe.model.scrub(party_type)];
Faris Ansarif7717b92018-02-08 11:09:54 +0530846 if(party && me.frm.doc.company) {
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530847 return frappe.call({
848 method: "erpnext.accounts.party.get_party_account",
849 args: {
850 company: me.frm.doc.company,
851 party_type: party_type,
Nabin Haitef864402016-02-10 14:47:25 +0530852 party: party
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530853 },
854 callback: function(r) {
855 if(!r.exc && r.message) {
856 me.frm.set_value(party_account_field, r.message);
857 set_pricing();
858 }
Nabin Haita731ad42016-02-04 17:21:28 +0530859 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530860 });
Nabin Haitef864402016-02-10 14:47:25 +0530861 } else {
862 set_pricing();
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530863 }
Nabin Haita731ad42016-02-04 17:21:28 +0530864 } else {
865 set_pricing();
866 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530867
Nabin Haita731ad42016-02-04 17:21:28 +0530868 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530869
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530870 if (this.frm.doc.posting_date) var date = this.frm.doc.posting_date;
871 else var date = this.frm.doc.transaction_date;
Rushabh Mehta5dfe20c2016-04-26 12:59:08 +0530872
873 if (frappe.meta.get_docfield(this.frm.doctype, "shipping_address") &&
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530874 in_list(['Purchase Order', 'Purchase Receipt', 'Purchase Invoice'], this.frm.doctype)) {
Faris Ansariab74ca72017-05-30 12:54:42 +0530875 erpnext.utils.get_shipping_address(this.frm, function(){
876 set_party_account(set_pricing);
Deepesh Gargb4be2922021-01-28 13:09:56 +0530877 });
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530878
879 // Get default company billing address in Purchase Invoice, Order and Receipt
880 frappe.call({
881 'method': 'frappe.contacts.doctype.address.address.get_default_address',
882 'args': {
883 'doctype': 'Company',
884 'name': this.frm.doc.company
885 },
886 'callback': function(r) {
887 me.frm.set_value('billing_address', r.message);
888 }
889 });
890
Faris Ansariab74ca72017-05-30 12:54:42 +0530891 } else {
Rohit Waghchaureb2e7a1f2016-04-11 12:10:20 +0530892 set_party_account(set_pricing);
893 }
Rushabh Mehta45ca8a42015-04-28 16:02:09 +0530894
895 if(this.frm.doc.company) {
896 erpnext.last_selected_company = this.frm.doc.company;
897 }
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530898 },
899
900 transaction_date: function() {
Anand Doshi87da6622015-10-19 14:59:32 +0530901 if (this.frm.doc.transaction_date) {
902 this.frm.transaction_date = this.frm.doc.transaction_date;
Nabin Hait288a18e2016-12-08 15:36:23 +0530903 frappe.ui.form.trigger(this.frm.doc.doctype, "currency");
Anand Doshi87da6622015-10-19 14:59:32 +0530904 }
Neil Trini Lasrado78fa6952014-10-03 17:43:02 +0530905 },
906
907 posting_date: function() {
Nabin Hait40e92b62015-07-09 17:12:23 +0530908 var me = this;
909 if (this.frm.doc.posting_date) {
Anand Doshi87da6622015-10-19 14:59:32 +0530910 this.frm.posting_date = this.frm.doc.posting_date;
911
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530912 if ((this.frm.doc.doctype == "Sales Invoice" && this.frm.doc.customer) ||
Nabin Hait40e92b62015-07-09 17:12:23 +0530913 (this.frm.doc.doctype == "Purchase Invoice" && this.frm.doc.supplier)) {
914 return frappe.call({
915 method: "erpnext.accounts.party.get_due_date",
916 args: {
917 "posting_date": me.frm.doc.posting_date,
918 "party_type": me.frm.doc.doctype == "Sales Invoice" ? "Customer" : "Supplier",
Shreya Shah3a9eec22018-02-16 13:05:21 +0530919 "bill_date": me.frm.doc.bill_date,
Nabin Hait40e92b62015-07-09 17:12:23 +0530920 "party": me.frm.doc.doctype == "Sales Invoice" ? me.frm.doc.customer : me.frm.doc.supplier,
921 "company": me.frm.doc.company
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530922 },
Nabin Hait40e92b62015-07-09 17:12:23 +0530923 callback: function(r, rt) {
924 if(r.message) {
Nabin Haitcfa9d1a2018-01-29 16:07:21 +0530925 me.frm.doc.due_date = r.message;
926 refresh_field("due_date");
Nabin Hait87d70272016-12-08 14:43:11 +0530927 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
tundebabzy650a1ee2018-01-02 07:32:30 +0100928 me.recalculate_terms();
Nabin Hait40e92b62015-07-09 17:12:23 +0530929 }
Nabin Hait40e92b62015-07-09 17:12:23 +0530930 }
931 })
Nabin Hait87d70272016-12-08 14:43:11 +0530932 } else {
933 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
Nabin Hait40e92b62015-07-09 17:12:23 +0530934 }
935 }
Anand Doshi3543f302013-05-24 19:25:01 +0530936 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530937
tundebabzyda221672018-01-09 06:28:44 +0100938 due_date: function() {
939 // due_date is to be changed, payment terms template and/or payment schedule must
940 // be removed as due_date is automatically changed based on payment terms
rohitwaghchaure52beb772018-01-29 17:40:44 +0530941 if (this.frm.doc.due_date && !this.frm.updating_party_details && !this.frm.doc.is_pos) {
Saurabh3959aeb2018-01-23 15:40:29 +0530942 if (this.frm.doc.payment_terms_template ||
943 (this.frm.doc.payment_schedule && this.frm.doc.payment_schedule.length)) {
tundebabzyda221672018-01-09 06:28:44 +0100944 var message1 = "";
945 var message2 = "";
946 var final_message = "Please clear the ";
947
948 if (this.frm.doc.payment_terms_template) {
949 message1 = "selected Payment Terms Template";
950 final_message = final_message + message1;
951 }
952
Nabin Hait2bfa1802018-01-17 14:39:05 +0530953 if ((this.frm.doc.payment_schedule || []).length) {
tundebabzyda221672018-01-09 06:28:44 +0100954 message2 = "Payment Schedule Table";
955 if (message1.length !== 0) message2 = " and " + message2;
956 final_message = final_message + message2;
957 }
tundebabzyda221672018-01-09 06:28:44 +0100958 frappe.msgprint(final_message);
959 }
Nabin Haitcfa9d1a2018-01-29 16:07:21 +0530960 }
tundebabzyda221672018-01-09 06:28:44 +0100961 },
962
Shreya Shah3a9eec22018-02-16 13:05:21 +0530963 bill_date: function() {
964 this.posting_date();
965 },
966
tundebabzy650a1ee2018-01-02 07:32:30 +0100967 recalculate_terms: function() {
968 const doc = this.frm.doc;
tundebabzy650a1ee2018-01-02 07:32:30 +0100969 if (doc.payment_terms_template) {
970 this.payment_terms_template();
971 } else if (doc.payment_schedule) {
972 const me = this;
tundebabzy650a1ee2018-01-02 07:32:30 +0100973 doc.payment_schedule.forEach(
974 function(term) {
975 if (term.payment_term) {
976 me.payment_term(doc, term.doctype, term.name);
977 } else {
978 frappe.model.set_value(
979 term.doctype, term.name, 'due_date',
980 doc.posting_date || doc.transaction_date
981 );
982 }
983 }
984 );
985 }
986 },
987
Anand Doshi3543f302013-05-24 19:25:01 +0530988 get_company_currency: function() {
989 return erpnext.get_currency(this.frm.doc.company);
990 },
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530991
Neil Trini Lasrado09a66c42015-07-07 16:41:37 +0530992 contact_person: function() {
993 erpnext.utils.get_contact_details(this.frm);
994 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530995
Anand Doshi3543f302013-05-24 19:25:01 +0530996 currency: function() {
Chude Osiegbu256ec172016-09-19 03:53:37 +0100997 /* 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 +0530998 var transaction_date = this.frm.doc.transaction_date || this.frm.doc.posting_date;
Chude Osiegbu256ec172016-09-19 03:53:37 +0100999 /* end manqala */
Anand Doshi61a2f682013-06-21 17:55:31 +05301000 var me = this;
1001 this.set_dynamic_labels();
Anand Doshi61a2f682013-06-21 17:55:31 +05301002 var company_currency = this.get_company_currency();
Nabin Hait69cdf592015-05-02 18:46:10 +05301003 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
Rushabh Mehta76b13412016-07-18 14:30:18 +05301004 if(this.frm.doc.currency && this.frm.doc.currency !== company_currency
Nabin Hait39505072016-07-07 11:11:32 +05301005 && !this.frm.doc.ignore_pricing_rule) {
Shreya0db85062018-05-15 11:25:46 +05301006
Nabin Hait288a18e2016-12-08 15:36:23 +05301007 this.get_exchange_rate(transaction_date, this.frm.doc.currency, company_currency,
Anand Doshi61a2f682013-06-21 17:55:31 +05301008 function(exchange_rate) {
Nabin Haitaafd64d2019-05-27 17:15:47 +05301009 if(exchange_rate != me.frm.doc.conversion_rate) {
1010 me.set_margin_amount_based_on_currency(exchange_rate);
1011 me.set_actual_charges_based_on_currency(exchange_rate);
1012 me.frm.set_value("conversion_rate", exchange_rate);
1013 }
Anand Doshi61a2f682013-06-21 17:55:31 +05301014 });
1015 } else {
Rushabh Mehtaff938022014-04-15 18:40:00 +05301016 this.conversion_rate();
Anand Doshi61a2f682013-06-21 17:55:31 +05301017 }
1018 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301019
Anand Doshi61a2f682013-06-21 17:55:31 +05301020 conversion_rate: function() {
tundebabzyab5b0302017-09-21 10:20:39 +01001021 const me = this.frm;
Anand Doshi535d8332013-07-19 13:51:07 +05301022 if(this.frm.doc.currency === this.get_company_currency()) {
1023 this.frm.set_value("conversion_rate", 1.0);
Akhilesh Darjeeacf65a72013-10-17 13:04:26 +05301024 }
1025 if(this.frm.doc.currency === this.frm.doc.price_list_currency &&
Anand Doshi61a2f682013-06-21 17:55:31 +05301026 this.frm.doc.plc_conversion_rate !== this.frm.doc.conversion_rate) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301027 this.frm.set_value("plc_conversion_rate", this.frm.doc.conversion_rate);
Anand Doshi61a2f682013-06-21 17:55:31 +05301028 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +05301029
Nabin Haita3dd72a2014-05-28 12:49:20 +05301030 if(flt(this.frm.doc.conversion_rate)>0.0) {
Nabin Hait444f9562014-06-20 15:59:49 +05301031 if(this.frm.doc.ignore_pricing_rule) {
1032 this.calculate_taxes_and_totals();
Anand Doshi51f722d2014-07-04 15:44:26 +05301033 } else if (!this.in_apply_price_list){
1034 this.apply_price_list();
Nabin Hait444f9562014-06-20 15:59:49 +05301035 }
1036
Nabin Haita3dd72a2014-05-28 12:49:20 +05301037 }
tundebabzyab5b0302017-09-21 10:20:39 +01001038 // Make read only if Accounts Settings doesn't allow stale rates
tundebabzybc7c3872017-11-28 18:10:05 +01001039 this.frm.set_df_property("conversion_rate", "read_only", erpnext.stale_rate_allowed() ? 0 : 1);
Anand Doshi3543f302013-05-24 19:25:01 +05301040 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301041
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301042 shipping_rule: function() {
1043 var me = this;
marination0c722492020-06-03 14:32:07 +05301044 if(this.frm.doc.shipping_rule) {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301045 return this.frm.call({
1046 doc: this.frm.doc,
1047 method: "apply_shipping_rule",
1048 callback: function(r) {
1049 if(!r.exc) {
1050 me.calculate_taxes_and_totals();
1051 }
1052 }
1053 }).fail(() => this.frm.set_value('shipping_rule', ''));
1054 }
Shreya39adc8f2018-01-22 13:08:05 +05301055 else {
1056 me.calculate_taxes_and_totals();
1057 }
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301058 },
1059
Nabin Haitaafd64d2019-05-27 17:15:47 +05301060 set_margin_amount_based_on_currency: function(exchange_rate) {
Anupam Kumared42afc2021-03-15 11:11:28 +05301061 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 +05301062 var me = this;
1063 $.each(this.frm.doc.items || [], function(i, d) {
1064 if(d.margin_type == "Amount") {
1065 frappe.model.set_value(d.doctype, d.name, "margin_rate_or_amount",
1066 flt(d.margin_rate_or_amount) / flt(exchange_rate));
1067 }
1068 });
1069 }
1070 },
1071
1072 set_actual_charges_based_on_currency: function(exchange_rate) {
Nabin Haita9c9b692017-08-31 19:40:09 +05301073 var me = this;
1074 $.each(this.frm.doc.taxes || [], function(i, d) {
1075 if(d.charge_type == "Actual") {
1076 frappe.model.set_value(d.doctype, d.name, "tax_amount",
Nabin Haitaafd64d2019-05-27 17:15:47 +05301077 flt(d.tax_amount) / flt(exchange_rate));
Nabin Haita9c9b692017-08-31 19:40:09 +05301078 }
1079 });
1080 },
1081
Nabin Hait288a18e2016-12-08 15:36:23 +05301082 get_exchange_rate: function(transaction_date, from_currency, to_currency, callback) {
Shreya3f778522018-05-15 16:59:20 +05301083 var args;
1084 if (["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"].includes(this.frm.doctype)) {
1085 args = "for_selling";
Shreya0db85062018-05-15 11:25:46 +05301086 }
Shreya3f778522018-05-15 16:59:20 +05301087 else if (["Purchase Order", "Purchase Receipt", "Purchase Invoice"].includes(this.frm.doctype)) {
1088 args = "for_buying";
1089 }
1090
Nabin Hait17179ee2017-05-06 13:23:12 +05301091 if (!transaction_date || !from_currency || !to_currency) return;
Nabin Haitbdfb0702015-10-28 15:38:08 +05301092 return frappe.call({
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301093 method: "erpnext.setup.utils.get_exchange_rate",
1094 args: {
Nabin Hait288a18e2016-12-08 15:36:23 +05301095 transaction_date: transaction_date,
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301096 from_currency: from_currency,
Shreya0db85062018-05-15 11:25:46 +05301097 to_currency: to_currency,
1098 args: args
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301099 },
1100 callback: function(r) {
1101 callback(flt(r.message));
1102 }
Anand Doshi61a2f682013-06-21 17:55:31 +05301103 });
1104 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301105
Anand Doshi3543f302013-05-24 19:25:01 +05301106 price_list_currency: function() {
Akhilesh Darjeedb59ffb2013-09-11 13:05:24 +05301107 var me=this;
Anand Doshi3543f302013-05-24 19:25:01 +05301108 this.set_dynamic_labels();
Nabin Haitec361ea2015-05-11 18:14:45 +05301109
1110 var company_currency = this.get_company_currency();
1111 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
1112 if(this.frm.doc.price_list_currency !== company_currency && !this.frm.doc.ignore_pricing_rule) {
Chude Osiegbufbf27b52016-09-07 03:06:08 +01001113 this.get_exchange_rate(this.frm.doc.posting_date, this.frm.doc.price_list_currency, company_currency,
Nabin Haitec361ea2015-05-11 18:14:45 +05301114 function(exchange_rate) {
1115 me.frm.set_value("plc_conversion_rate", exchange_rate);
1116 });
1117 } else {
1118 this.plc_conversion_rate();
1119 }
Anand Doshi3543f302013-05-24 19:25:01 +05301120 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301121
Anand Doshi3543f302013-05-24 19:25:01 +05301122 plc_conversion_rate: function() {
Anand Doshi61a2f682013-06-21 17:55:31 +05301123 if(this.frm.doc.price_list_currency === this.get_company_currency()) {
1124 this.frm.set_value("plc_conversion_rate", 1.0);
Rushabh Mehtaa208c562015-08-03 13:18:54 +05301125 } else if(this.frm.doc.price_list_currency === this.frm.doc.currency
Nabin Hait1d218422015-07-17 15:19:02 +05301126 && this.frm.doc.plc_conversion_rate && cint(this.frm.doc.plc_conversion_rate) != 1 &&
Nabin Haitec361ea2015-05-11 18:14:45 +05301127 cint(this.frm.doc.plc_conversion_rate) != cint(this.frm.doc.conversion_rate)) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301128 this.frm.set_value("conversion_rate", this.frm.doc.plc_conversion_rate);
Akhilesh Darjee564c6212013-10-17 11:31:11 +05301129 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +05301130
Nabin Haitec361ea2015-05-11 18:14:45 +05301131 if(!this.in_apply_price_list) {
tundebabzy6e90f492018-02-12 10:48:57 +01001132 this.apply_price_list(null, true);
Anand Doshi61a2f682013-06-21 17:55:31 +05301133 }
Anand Doshi3543f302013-05-24 19:25:01 +05301134 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301135
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301136 uom: function(doc, cdt, cdn) {
1137 var me = this;
1138 var item = frappe.get_doc(cdt, cdn);
1139 if(item.item_code && item.uom) {
1140 return this.frm.call({
1141 method: "erpnext.stock.get_item_details.get_conversion_factor",
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301142 args: {
1143 item_code: item.item_code,
1144 uom: item.uom
1145 },
1146 callback: function(r) {
1147 if(!r.exc) {
Saqib60212ff2020-10-26 11:17:04 +05301148 frappe.model.set_value(cdt, cdn, 'conversion_factor', r.message.conversion_factor);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301149 }
1150 }
1151 });
1152 }
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301153 me.calculate_stock_uom_rate(doc, cdt, cdn);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301154 },
1155
Nabin Hait3257aee2017-05-06 12:47:14 +05301156 conversion_factor: function(doc, cdt, cdn, dont_fetch_price_list_rate) {
marinatione1439832020-02-18 10:51:54 +05301157 if(frappe.meta.get_docfield(cdt, "stock_qty", cdn)) {
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301158 var item = frappe.get_doc(cdt, cdn);
1159 frappe.model.round_floats_in(item, ["qty", "conversion_factor"]);
1160 item.stock_qty = flt(item.qty * item.conversion_factor, precision("stock_qty", item));
1161 refresh_field("stock_qty", item.name, item.parentfield);
mbauskar287fe812017-04-10 19:15:57 +05301162 this.toggle_conversion_factor(item);
marinatione1439832020-02-18 10:51:54 +05301163
1164 if(doc.doctype != "Material Request") {
1165 item.total_weight = flt(item.stock_qty * item.weight_per_unit);
1166 refresh_field("total_weight", item.name, item.parentfield);
1167 this.calculate_net_weight();
1168 }
1169
rohitwaghchauree8ccc0e2017-11-21 16:17:22 +05301170 if (!dont_fetch_price_list_rate &&
1171 frappe.meta.has_field(doc.doctype, "price_list_currency")) {
1172 this.apply_price_list(item, true);
1173 }
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301174 this.calculate_stock_uom_rate(doc, cdt, cdn);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301175 }
1176 },
1177
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301178 batch_no: function(doc, cdt, cdn) {
1179 let item = frappe.get_doc(cdt, cdn);
1180 this.apply_price_list(item, true);
1181 },
1182
mbauskar287fe812017-04-10 19:15:57 +05301183 toggle_conversion_factor: function(item) {
1184 // toggle read only property for conversion factor field if the uom and stock uom are same
Rushabh Mehta36311022017-06-20 09:30:53 +05301185 if(this.frm.get_field('items').grid.fields_map.conversion_factor) {
1186 this.frm.fields_dict.items.grid.toggle_enable("conversion_factor",
Javier Wong24690952017-12-29 16:36:47 +08001187 ((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 +05301188 }
Vishal Dhayaguded3770182017-12-14 18:06:02 +05301189
mbauskar287fe812017-04-10 19:15:57 +05301190 },
1191
Anand Doshi3543f302013-05-24 19:25:01 +05301192 qty: function(doc, cdt, cdn) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301193 let item = frappe.get_doc(cdt, cdn);
Nabin Hait50cb49c2020-01-21 13:04:21 +05301194 this.conversion_factor(doc, cdt, cdn, true);
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301195 this.calculate_stock_uom_rate(doc, cdt, cdn);
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301196 this.apply_pricing_rule(item, true);
Vishal Dhayaguded42242d2017-11-29 16:09:59 +05301197 },
1198
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301199 calculate_stock_uom_rate: function(doc, cdt, cdn) {
1200 let item = frappe.get_doc(cdt, cdn);
1201 item.stock_uom_rate = flt(item.rate)/flt(item.conversion_factor);
1202 refresh_field("stock_uom_rate", item.name, item.parentfield);
1203 },
Zarrare83ff382018-09-21 15:45:40 +05301204 service_stop_date: function(frm, cdt, cdn) {
1205 var child = locals[cdt][cdn];
1206
1207 if(child.service_stop_date) {
1208 let start_date = Date.parse(child.service_start_date);
1209 let end_date = Date.parse(child.service_end_date);
1210 let stop_date = Date.parse(child.service_stop_date);
1211
1212 if(stop_date < start_date) {
1213 frappe.model.set_value(cdt, cdn, "service_stop_date", "");
1214 frappe.throw(__("Service Stop Date cannot be before Service Start Date"));
1215 } else if (stop_date > end_date) {
1216 frappe.model.set_value(cdt, cdn, "service_stop_date", "");
1217 frappe.throw(__("Service Stop Date cannot be after Service End Date"));
1218 }
1219 }
1220 },
1221
1222 service_start_date: function(frm, cdt, cdn) {
1223 var child = locals[cdt][cdn];
1224
1225 if(child.service_start_date) {
1226 frappe.call({
1227 "method": "erpnext.stock.get_item_details.calculate_service_end_date",
1228 args: {"args": child},
1229 callback: function(r) {
1230 frappe.model.set_value(cdt, cdn, "service_end_date", r.message.service_end_date);
1231 }
1232 })
1233 }
1234 },
1235
Vishal Dhayaguded3770182017-12-14 18:06:02 +05301236 calculate_net_weight: function(){
1237 /* Calculate Total Net Weight then further applied shipping rule to calculate shipping charges.*/
1238 var me = this;
1239 this.frm.doc.total_net_weight= 0.0;
1240
1241 $.each(this.frm.doc["items"] || [], function(i, item) {
1242 me.frm.doc.total_net_weight += flt(item.total_weight);
1243 });
1244 refresh_field("total_net_weight");
1245 this.shipping_rule();
Anand Doshi3543f302013-05-24 19:25:01 +05301246 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301247
Anand Doshi61a2f682013-06-21 17:55:31 +05301248 set_dynamic_labels: function() {
1249 // What TODO? should we make price list system non-mandatory?
1250 this.frm.toggle_reqd("plc_conversion_rate",
1251 !!(this.frm.doc.price_list_name && this.frm.doc.price_list_currency));
Rushabh Mehtaff938022014-04-15 18:40:00 +05301252
Saif3c9155e2018-10-18 17:27:56 +05001253 var company_currency = this.get_company_currency();
1254 this.change_form_labels(company_currency);
1255 this.change_grid_labels(company_currency);
1256 this.frm.refresh_fields();
Anand Doshi61a2f682013-06-21 17:55:31 +05301257 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301258
Nabin Hait613d0812015-02-23 11:58:15 +05301259 change_form_labels: function(company_currency) {
1260 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301261
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301262 this.frm.set_currency_labels(["base_total", "base_net_total", "base_total_taxes_and_charges",
Nabin Hait613d0812015-02-23 11:58:15 +05301263 "base_discount_amount", "base_grand_total", "base_rounded_total", "base_in_words",
1264 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted", "total_amount_to_pay",
Rushabh Mehta6b537922017-03-14 16:59:11 +05301265 "base_paid_amount", "base_write_off_amount", "base_change_amount", "base_operating_cost",
Nabin Hait2e4de832017-09-19 14:53:16 +05301266 "base_raw_material_cost", "base_total_cost", "base_scrap_material_cost",
1267 "base_rounding_adjustment"], company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301268
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301269 this.frm.set_currency_labels(["total", "net_total", "total_taxes_and_charges", "discount_amount",
Nabin Hait613d0812015-02-23 11:58:15 +05301270 "grand_total", "taxes_and_charges_added", "taxes_and_charges_deducted",
Nabin Hait2e4de832017-09-19 14:53:16 +05301271 "rounded_total", "in_words", "paid_amount", "write_off_amount", "operating_cost",
1272 "scrap_material_cost", "rounding_adjustment", "raw_material_cost",
1273 "total_cost"], this.frm.doc.currency);
Anand Doshi87da6622015-10-19 14:59:32 +05301274
Nabin Hait2e4de832017-09-19 14:53:16 +05301275 this.frm.set_currency_labels(["outstanding_amount", "total_advance"],
1276 this.frm.doc.party_account_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301277
1278 cur_frm.set_df_property("conversion_rate", "description", "1 " + this.frm.doc.currency
Nabin Hait2e4de832017-09-19 14:53:16 +05301279 + " = [?] " + company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301280
1281 if(this.frm.doc.price_list_currency && this.frm.doc.price_list_currency!=company_currency) {
Nabin Hait2e4de832017-09-19 14:53:16 +05301282 cur_frm.set_df_property("plc_conversion_rate", "description", "1 "
1283 + this.frm.doc.price_list_currency + " = [?] " + company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301284 }
1285
1286 // toggle fields
Nabin Hait2e4de832017-09-19 14:53:16 +05301287 this.frm.toggle_display(["conversion_rate", "base_total", "base_net_total",
1288 "base_total_taxes_and_charges", "base_taxes_and_charges_added", "base_taxes_and_charges_deducted",
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301289 "base_grand_total", "base_rounded_total", "base_in_words", "base_discount_amount",
Nabin Hait2e4de832017-09-19 14:53:16 +05301290 "base_paid_amount", "base_write_off_amount", "base_operating_cost", "base_raw_material_cost",
1291 "base_total_cost", "base_scrap_material_cost", "base_rounding_adjustment"],
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301292 this.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301293
1294 this.frm.toggle_display(["plc_conversion_rate", "price_list_currency"],
1295 this.frm.doc.price_list_currency != company_currency);
1296
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301297 var show = cint(cur_frm.doc.discount_amount) ||
Nabin Hait903c42a2015-02-24 15:24:49 +05301298 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
1299
1300 if(frappe.meta.get_docfield(cur_frm.doctype, "net_total"))
1301 cur_frm.toggle_display("net_total", show);
1302
1303 if(frappe.meta.get_docfield(cur_frm.doctype, "base_net_total"))
1304 cur_frm.toggle_display("base_net_total", (show && (me.frm.doc.currency != company_currency)));
1305
Nabin Hait613d0812015-02-23 11:58:15 +05301306 },
1307
1308 change_grid_labels: function(company_currency) {
1309 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301310
Anupam Kumared42afc2021-03-15 11:11:28 +05301311 this.frm.set_currency_labels(["base_rate", "base_net_rate", "base_price_list_rate", "base_amount", "base_net_amount", "base_rate_with_margin"],
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301312 company_currency, "items");
1313
Anupam Kumared42afc2021-03-15 11:11:28 +05301314 this.frm.set_currency_labels(["rate", "net_rate", "price_list_rate", "amount", "net_amount", "stock_uom_rate", "rate_with_margin"],
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301315 this.frm.doc.currency, "items");
1316
1317 if(this.frm.fields_dict["operations"]) {
1318 this.frm.set_currency_labels(["operating_cost", "hour_rate"], this.frm.doc.currency, "operations");
1319 this.frm.set_currency_labels(["base_operating_cost", "base_hour_rate"], company_currency, "operations");
1320
1321 var item_grid = this.frm.fields_dict["operations"].grid;
1322 $.each(["base_operating_cost", "base_hour_rate"], function(i, fname) {
1323 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1324 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301325 });
1326 }
1327
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301328 if(this.frm.fields_dict["scrap_items"]) {
1329 this.frm.set_currency_labels(["rate", "amount"], this.frm.doc.currency, "scrap_items");
1330 this.frm.set_currency_labels(["base_rate", "base_amount"], company_currency, "scrap_items");
Nabin Hait613d0812015-02-23 11:58:15 +05301331
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301332 var item_grid = this.frm.fields_dict["scrap_items"].grid;
1333 $.each(["base_rate", "base_amount"], function(i, fname) {
1334 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1335 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1336 });
1337 }
Nabin Hait613d0812015-02-23 11:58:15 +05301338
1339 if(this.frm.fields_dict["taxes"]) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301340 this.frm.set_currency_labels(["tax_amount", "total", "tax_amount_after_discount"], this.frm.doc.currency, "taxes");
Nabin Hait613d0812015-02-23 11:58:15 +05301341
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301342 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 +05301343 }
1344
1345 if(this.frm.fields_dict["advances"]) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301346 this.frm.set_currency_labels(["advance_amount", "allocated_amount"],
Nabin Haitaa015902015-10-16 13:08:33 +05301347 this.frm.doc.party_account_currency, "advances");
Nabin Hait613d0812015-02-23 11:58:15 +05301348 }
1349
1350 // toggle columns
1351 var item_grid = this.frm.fields_dict["items"].grid;
Anupam Kumared42afc2021-03-15 11:11:28 +05301352 $.each(["base_rate", "base_price_list_rate", "base_amount", "base_rate_with_margin"], function(i, fname) {
Nabin Hait613d0812015-02-23 11:58:15 +05301353 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1354 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1355 });
1356
1357 var show = (cint(cur_frm.doc.discount_amount)) ||
1358 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
1359
1360 $.each(["net_rate", "net_amount"], function(i, fname) {
1361 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1362 item_grid.set_column_disp(fname, show);
1363 });
1364
1365 $.each(["base_net_rate", "base_net_amount"], function(i, fname) {
1366 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1367 item_grid.set_column_disp(fname, (show && (me.frm.doc.currency != company_currency)));
1368 });
1369
1370 // set labels
1371 var $wrapper = $(this.frm.wrapper);
Nabin Hait613d0812015-02-23 11:58:15 +05301372 },
1373
Anand Doshi923d41d2013-05-28 17:23:36 +05301374 recalculate: function() {
1375 this.calculate_taxes_and_totals();
1376 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301377
Anand Doshi923d41d2013-05-28 17:23:36 +05301378 recalculate_values: function() {
1379 this.calculate_taxes_and_totals();
1380 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301381
Anand Doshid0b00722013-05-28 18:54:48 +05301382 calculate_charges: function() {
1383 this.calculate_taxes_and_totals();
1384 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301385
Nabin Hait444f9562014-06-20 15:59:49 +05301386 ignore_pricing_rule: function() {
Nabin Hait8c9fb762017-04-28 14:23:03 +05301387 if(this.frm.doc.ignore_pricing_rule) {
1388 var me = this;
1389 var item_list = [];
Rushabh Mehta36311022017-06-20 09:30:53 +05301390
Nabin Hait8c9fb762017-04-28 14:23:03 +05301391 $.each(this.frm.doc["items"] || [], function(i, d) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301392 if (d.item_code && !d.is_free_item) {
Nabin Hait8c9fb762017-04-28 14:23:03 +05301393 item_list.push({
1394 "doctype": d.doctype,
1395 "name": d.name,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301396 "item_code": d.item_code,
1397 "pricing_rules": d.pricing_rules,
1398 "parenttype": d.parenttype,
1399 "parent": d.parent
Nabin Hait8c9fb762017-04-28 14:23:03 +05301400 })
1401 }
1402 });
1403 return this.frm.call({
1404 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.remove_pricing_rules",
1405 args: { item_list: item_list },
1406 callback: function(r) {
1407 if (!r.exc && r.message) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301408 r.message.forEach(row_item => {
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301409 me.remove_pricing_rule(row_item);
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301410 });
Nabin Hait8c9fb762017-04-28 14:23:03 +05301411 me._set_values_for_item_list(r.message);
1412 me.calculate_taxes_and_totals();
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301413 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on");
Nabin Hait8c9fb762017-04-28 14:23:03 +05301414 }
1415 }
1416 });
1417 } else {
1418 this.apply_pricing_rule();
1419 }
Nabin Hait444f9562014-06-20 15:59:49 +05301420 },
1421
1422 apply_pricing_rule: function(item, calculate_taxes_and_totals) {
Nabin Haita3dd72a2014-05-28 12:49:20 +05301423 var me = this;
Anand Doshi70f57eb2015-11-27 14:37:40 +05301424 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301425 if (!(args.items && args.items.length)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +05301426 if(calculate_taxes_and_totals) me.calculate_taxes_and_totals();
1427 return;
1428 }
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301429
Anand Doshidffec8f2014-07-01 17:45:15 +05301430 return this.frm.call({
1431 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.apply_pricing_rule",
Rohit Waghchauree5405342019-03-31 16:42:41 +05301432 args: { args: args, doc: me.frm.doc },
Anand Doshidffec8f2014-07-01 17:45:15 +05301433 callback: function(r) {
Anand Doshif214bfc2014-07-16 17:52:08 +05301434 if (!r.exc && r.message) {
Anand Doshidffec8f2014-07-01 17:45:15 +05301435 me._set_values_for_item_list(r.message);
Saurabh2d7af632016-02-26 11:09:20 +05301436 if(item) me.set_gross_profit(item);
Rohit Waghchauredeaee7c2016-09-22 14:02:53 +05301437 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on")
Anand Doshidffec8f2014-07-01 17:45:15 +05301438 }
1439 }
1440 });
1441 },
1442
1443 _get_args: function(item) {
1444 var me = this;
1445 return {
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301446 "items": this._get_item_list(item),
Nabin Hait34c551d2019-07-03 10:34:31 +05301447 "customer": me.frm.doc.customer || me.frm.doc.party_name,
1448 "quotation_to": me.frm.doc.quotation_to,
Nabin Hait444f9562014-06-20 15:59:49 +05301449 "customer_group": me.frm.doc.customer_group,
1450 "territory": me.frm.doc.territory,
1451 "supplier": me.frm.doc.supplier,
Zlash652e080982018-04-19 18:37:53 +05301452 "supplier_group": me.frm.doc.supplier_group,
Nabin Hait444f9562014-06-20 15:59:49 +05301453 "currency": me.frm.doc.currency,
1454 "conversion_rate": me.frm.doc.conversion_rate,
1455 "price_list": me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Haitdd82bf22015-05-11 16:49:17 +05301456 "price_list_currency": me.frm.doc.price_list_currency,
Nabin Hait444f9562014-06-20 15:59:49 +05301457 "plc_conversion_rate": me.frm.doc.plc_conversion_rate,
1458 "company": me.frm.doc.company,
1459 "transaction_date": me.frm.doc.transaction_date || me.frm.doc.posting_date,
1460 "campaign": me.frm.doc.campaign,
1461 "sales_partner": me.frm.doc.sales_partner,
1462 "ignore_pricing_rule": me.frm.doc.ignore_pricing_rule,
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301463 "doctype": me.frm.doc.doctype,
Rohit Waghchaure5ecbaa42017-03-28 12:09:07 +05301464 "name": me.frm.doc.name,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +05301465 "is_return": cint(me.frm.doc.is_return),
1466 "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 +05301467 "conversion_factor": me.frm.doc.conversion_factor,
ashish-greycube74dc3c92019-08-12 13:39:25 +05301468 "pos_profile": me.frm.doc.doctype == 'Sales Invoice' ? me.frm.doc.pos_profile : '',
1469 "coupon_code": me.frm.doc.coupon_code
Nabin Hait444f9562014-06-20 15:59:49 +05301470 };
Nabin Hait444f9562014-06-20 15:59:49 +05301471 },
1472
1473 _get_item_list: function(item) {
1474 var item_list = [];
1475 var append_item = function(d) {
Anand Doshi39edcbc2014-07-28 16:00:19 +05301476 if (d.item_code) {
1477 item_list.push({
1478 "doctype": d.doctype,
1479 "name": d.name,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301480 "child_docname": d.name,
Anand Doshi39edcbc2014-07-28 16:00:19 +05301481 "item_code": d.item_code,
1482 "item_group": d.item_group,
1483 "brand": d.brand,
Anand Doshi39a28912016-02-15 11:42:18 +05301484 "qty": d.qty,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301485 "stock_qty": d.stock_qty,
Nabin Haite45ec662018-08-01 17:44:34 +05301486 "uom": d.uom,
Suraj Shettyc87b47a2019-04-29 23:18:47 +05301487 "stock_uom": d.stock_uom,
Anand Doshi39a28912016-02-15 11:42:18 +05301488 "parenttype": d.parenttype,
Rohit Waghchaure43b50802016-10-24 14:04:46 +05301489 "parent": d.parent,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301490 "pricing_rules": d.pricing_rules,
Kanchan Chauhanaf0d6372016-11-13 21:19:09 +05301491 "warehouse": d.warehouse,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +05301492 "serial_no": d.serial_no,
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301493 "batch_no": d.batch_no,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301494 "price_list_rate": d.price_list_rate,
mbauskar287fe812017-04-10 19:15:57 +05301495 "conversion_factor": d.conversion_factor || 1.0
Anand Doshi39edcbc2014-07-28 16:00:19 +05301496 });
mbauskarc79415e2016-01-18 16:32:24 +05301497
1498 // if doctype is Quotation Item / Sales Order Iten then add Margin Type and rate in item_list
Anupam Kumared42afc2021-03-15 11:11:28 +05301499 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 +05301500 item_list[0]["margin_type"] = d.margin_type;
1501 item_list[0]["margin_rate_or_amount"] = d.margin_rate_or_amount;
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301502 }
Anand Doshi39edcbc2014-07-28 16:00:19 +05301503 }
Nabin Hait444f9562014-06-20 15:59:49 +05301504 };
Nabin Haita3dd72a2014-05-28 12:49:20 +05301505
Nabin Hait444f9562014-06-20 15:59:49 +05301506 if (item) {
1507 append_item(item);
Nabin Haitc1367d92014-05-30 11:43:00 +05301508 } else {
Nabin Hait96339342015-01-21 17:22:11 +05301509 $.each(this.frm.doc["items"] || [], function(i, d) {
Nabin Hait444f9562014-06-20 15:59:49 +05301510 append_item(d);
Nabin Haita3dd72a2014-05-28 12:49:20 +05301511 });
1512 }
Nabin Hait444f9562014-06-20 15:59:49 +05301513 return item_list;
Nabin Haita3dd72a2014-05-28 12:49:20 +05301514 },
1515
Anand Doshidffec8f2014-07-01 17:45:15 +05301516 _set_values_for_item_list: function(children) {
Nabin Hait49a27292014-12-17 11:21:32 +05301517 var me = this;
Nabin Hait7d8fa802014-12-30 15:35:45 +05301518 var price_list_rate_changed = false;
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301519 var items_rule_dict = {};
1520
Anand Doshidea3fb02015-02-05 15:05:58 +05301521 for(var i=0, l=children.length; i<l; i++) {
1522 var d = children[i];
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301523 var existing_pricing_rule = frappe.model.get_value(d.doctype, d.name, "pricing_rules");
Anand Doshidea3fb02015-02-05 15:05:58 +05301524 for(var k in d) {
1525 var v = d[k];
Anand Doshidffec8f2014-07-01 17:45:15 +05301526 if (["doctype", "name"].indexOf(k)===-1) {
Nabin Hait7d8fa802014-12-30 15:35:45 +05301527 if(k=="price_list_rate") {
1528 if(flt(v) != flt(d.price_list_rate)) price_list_rate_changed = true;
1529 }
mbauskar287fe812017-04-10 19:15:57 +05301530 frappe.model.set_value(d.doctype, d.name, k, v);
Anand Doshidffec8f2014-07-01 17:45:15 +05301531 }
Anand Doshidea3fb02015-02-05 15:05:58 +05301532 }
1533
Nabin Hait49a27292014-12-17 11:21:32 +05301534 // if pricing rule set as blank from an existing value, apply price_list
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301535 if(!me.frm.doc.ignore_pricing_rule && existing_pricing_rule && !d.pricing_rules) {
Nabin Hait49a27292014-12-17 11:21:32 +05301536 me.apply_price_list(frappe.get_doc(d.doctype, d.name));
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301537 } else if(!d.pricing_rules) {
1538 me.remove_pricing_rule(frappe.get_doc(d.doctype, d.name));
1539 }
1540
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301541 if (d.free_item_data) {
1542 me.apply_product_discount(d.free_item_data);
1543 }
1544
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301545 if (d.apply_rule_on_other_items) {
1546 items_rule_dict[d.name] = d;
Nabin Hait49a27292014-12-17 11:21:32 +05301547 }
Anand Doshidea3fb02015-02-05 15:05:58 +05301548 }
Nabin Hait7d8fa802014-12-30 15:35:45 +05301549
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301550 me.apply_rule_on_other_items(items_rule_dict);
1551
Anand Doshidea3fb02015-02-05 15:05:58 +05301552 if(!price_list_rate_changed) me.calculate_taxes_and_totals();
Anand Doshidffec8f2014-07-01 17:45:15 +05301553 },
1554
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301555 apply_rule_on_other_items: function(args) {
1556 const me = this;
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301557 const fields = ["discount_percentage", "pricing_rules", "discount_amount", "rate"];
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301558
1559 for(var k in args) {
1560 let data = args[k];
Saqib Ansari8c70e8d2020-04-24 16:41:48 +05301561
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301562 if (data && data.apply_rule_on_other_items) {
1563 me.frm.doc.items.forEach(d => {
1564 if (in_list(data.apply_rule_on_other_items, d[data.apply_rule_on])) {
1565 for(var k in data) {
Saqib Ansari40140c62020-04-24 14:51:14 +05301566 if (in_list(fields, k) && data[k] && (data.price_or_product_discount === 'price' || k === 'pricing_rules')) {
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301567 frappe.model.set_value(d.doctype, d.name, k, data[k]);
1568 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301569 }
1570 }
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301571 });
1572 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301573 }
1574 },
1575
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301576 apply_product_discount: function(free_item_data) {
1577 const items = this.frm.doc.items.filter(d => (d.item_code == free_item_data.item_code
1578 && d.is_free_item)) || [];
1579
1580 if (!items.length) {
1581 let row_to_modify = frappe.model.add_child(this.frm.doc,
1582 this.frm.doc.doctype + ' Item', 'items');
1583
1584 for (let key in free_item_data) {
1585 row_to_modify[key] = free_item_data[key];
1586 }
Rohit Waghchaured093a372020-04-21 00:19:19 +05301587 } if (items && items.length && free_item_data) {
1588 items[0].qty = free_item_data.qty
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301589 }
1590 },
1591
tundebabzy6e90f492018-02-12 10:48:57 +01001592 apply_price_list: function(item, reset_plc_conversion) {
1593 // We need to reset plc_conversion_rate sometimes because the call to
1594 // `erpnext.stock.get_item_details.apply_price_list` is sensitive to its value
1595 if (!reset_plc_conversion) {
1596 this.frm.set_value("plc_conversion_rate", "");
1597 }
1598
Anand Doshidffec8f2014-07-01 17:45:15 +05301599 var me = this;
Rushabh Mehta052bd622015-01-30 16:57:24 +05301600 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301601 if (!((args.items && args.items.length) || args.price_list)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +05301602 return;
1603 }
Nabin Hait37b047d2015-02-23 16:01:33 +05301604
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301605 if (me.in_apply_price_list == true) return;
1606
1607 me.in_apply_price_list = true;
Anand Doshidffec8f2014-07-01 17:45:15 +05301608 return this.frm.call({
1609 method: "erpnext.stock.get_item_details.apply_price_list",
Rushabh Mehta052bd622015-01-30 16:57:24 +05301610 args: { args: args },
Anand Doshidffec8f2014-07-01 17:45:15 +05301611 callback: function(r) {
1612 if (!r.exc) {
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301613 frappe.run_serially([
1614 () => me.frm.set_value("price_list_currency", r.message.parent.price_list_currency),
1615 () => me.frm.set_value("plc_conversion_rate", r.message.parent.plc_conversion_rate),
1616 () => {
1617 if(args.items.length) {
1618 me._set_values_for_item_list(r.message.children);
1619 }
1620 },
1621 () => { me.in_apply_price_list = false; }
1622 ]);
Nabin Hait37b047d2015-02-23 16:01:33 +05301623
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301624 } else {
1625 me.in_apply_price_list = false;
Anand Doshidffec8f2014-07-01 17:45:15 +05301626 }
1627 }
Faris Ansari404f39d2018-05-14 15:46:45 +05301628 }).always(() => {
1629 me.in_apply_price_list = false;
Anand Doshidffec8f2014-07-01 17:45:15 +05301630 });
1631 },
1632
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301633 remove_pricing_rule: function(item) {
Rohit Waghchauree5405342019-03-31 16:42:41 +05301634 let me = this;
Rohit Waghchaure660a78b2020-01-02 17:29:50 +05301635 const fields = ["discount_percentage",
1636 "discount_amount", "margin_rate_or_amount", "rate_with_margin"];
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301637
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301638 if(item.remove_free_item) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301639 var items = [];
1640
1641 me.frm.doc.items.forEach(d => {
1642 if(d.item_code != item.remove_free_item || !d.is_free_item) {
1643 items.push(d);
1644 }
1645 });
1646
1647 me.frm.doc.items = items;
1648 refresh_field('items');
Rohit Waghchauree5405342019-03-31 16:42:41 +05301649 } else if(item.applied_on_items && item.apply_on) {
1650 const applied_on_items = item.applied_on_items.split(',');
1651 me.frm.doc.items.forEach(row => {
1652 if(applied_on_items.includes(row[item.apply_on])) {
1653 fields.forEach(f => {
1654 row[f] = 0;
1655 });
Rohit Waghchaure660a78b2020-01-02 17:29:50 +05301656
1657 ["pricing_rules", "margin_type"].forEach(field => {
1658 if (row[field]) {
1659 row[field] = '';
1660 }
1661 })
Rohit Waghchauree5405342019-03-31 16:42:41 +05301662 }
1663 });
1664
1665 me.trigger_price_list_rate();
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301666 }
1667 },
1668
Rohit Waghchauree5405342019-03-31 16:42:41 +05301669 trigger_price_list_rate: function() {
1670 var me = this;
1671
1672 this.frm.doc.items.forEach(child_row => {
1673 me.frm.script_manager.trigger("price_list_rate",
1674 child_row.doctype, child_row.name);
1675 })
1676 },
1677
Nabin Hait139dc7b2014-02-12 14:53:18 +05301678 validate_company_and_party: function() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301679 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +05301680 var valid = true;
Rushabh Mehtaff938022014-04-15 18:40:00 +05301681
Nabin Hait0f231062014-02-20 11:27:47 +05301682 $.each(["company", "customer"], function(i, fieldname) {
Nabin Haitae07f222017-06-02 13:57:08 +05301683 if(frappe.meta.has_field(me.frm.doc.doctype, fieldname) && me.frm.doc.doctype != "Purchase Order") {
Nabin Hait139dc7b2014-02-12 14:53:18 +05301684 if (!me.frm.doc[fieldname]) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301685 frappe.msgprint(__("Please specify") + ": " +
Rushabh Mehtaff938022014-04-15 18:40:00 +05301686 frappe.meta.get_label(me.frm.doc.doctype, fieldname, me.frm.doc.name) +
Pratik Vyasb52618c2014-04-14 16:25:30 +05301687 ". " + __("It is needed to fetch Item Details."));
Faris Ansariab74ca72017-05-30 12:54:42 +05301688 valid = false;
Nabin Hait139dc7b2014-02-12 14:53:18 +05301689 }
Anand Doshi3543f302013-05-24 19:25:01 +05301690 }
1691 });
1692 return valid;
1693 },
Rushabh Mehtaff938022014-04-15 18:40:00 +05301694
Anand Doshibf3e54a2013-06-05 14:11:32 +05301695 get_terms: function() {
1696 var me = this;
Makarand Bauskar157c3342017-05-26 21:32:33 +05301697
1698 erpnext.utils.get_terms(this.frm.doc.tc_name, this.frm.doc, function(r) {
1699 if(!r.exc) {
1700 me.frm.set_value("terms", r.message);
1701 }
1702 });
Anand Doshibf3e54a2013-06-05 14:11:32 +05301703 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301704
1705 taxes_and_charges: function() {
1706 var me = this;
1707 if(this.frm.doc.taxes_and_charges) {
1708 return this.frm.call({
Nabin Hait6b039142014-05-02 15:45:10 +05301709 method: "erpnext.controllers.accounts_controller.get_taxes_and_charges",
1710 args: {
Nabin Hait03f3a8a2014-05-13 16:38:31 +05301711 "master_doctype": frappe.meta.get_docfield(this.frm.doc.doctype, "taxes_and_charges",
1712 this.frm.doc.name).options,
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301713 "master_name": this.frm.doc.taxes_and_charges
Nabin Hait6b039142014-05-02 15:45:10 +05301714 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301715 callback: function(r) {
1716 if(!r.exc) {
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301717 if(me.frm.doc.shipping_rule && me.frm.doc.taxes) {
1718 for (let tax of r.message) {
1719 me.frm.add_child("taxes", tax);
1720 }
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301721
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301722 refresh_field("taxes");
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301723 } else {
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301724 me.frm.set_value("taxes", r.message);
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301725 me.calculate_taxes_and_totals();
Rohan Bansal90972cf2019-03-11 14:48:26 +05301726 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301727 }
1728 }
1729 });
Nabin Haitbc83b9c2014-05-02 17:03:18 +05301730 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301731 },
1732
Saif Ur Rehman67786682018-12-27 02:11:07 +05001733 tax_category: function() {
1734 var me = this;
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +05001735 if(me.frm.updating_party_details) return;
1736
Saif Ur Rehmane414a922018-12-28 04:59:42 +05001737 frappe.run_serially([
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001738 () => this.update_item_tax_map(),
Saif Ur Rehmane414a922018-12-28 04:59:42 +05001739 () => erpnext.utils.set_taxes(this.frm, "tax_category"),
1740 ]);
Saif Ur Rehman67786682018-12-27 02:11:07 +05001741 },
1742
1743 item_tax_template: function(doc, cdt, cdn) {
1744 var me = this;
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +05001745 if(me.frm.updating_party_details) return;
1746
Saif Ur Rehman67786682018-12-27 02:11:07 +05001747 var item = frappe.get_doc(cdt, cdn);
1748
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001749 if(item.item_tax_template) {
1750 return this.frm.call({
1751 method: "erpnext.stock.get_item_details.get_item_tax_map",
1752 args: {
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001753 company: me.frm.doc.company,
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001754 item_tax_template: item.item_tax_template,
1755 as_json: true
1756 },
1757 callback: function(r) {
1758 if(!r.exc) {
1759 item.item_tax_rate = r.message;
1760 me.add_taxes_from_item_tax_template(item.item_tax_rate);
1761 me.calculate_taxes_and_totals();
1762 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001763 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001764 });
1765 } else {
1766 item.item_tax_rate = "{}";
1767 me.calculate_taxes_and_totals();
1768 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001769 },
1770
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001771 update_item_tax_map: function() {
1772 var me = this;
1773 var item_codes = [];
1774 $.each(this.frm.doc.items || [], function(i, item) {
1775 if(item.item_code) {
1776 item_codes.push(item.item_code);
1777 }
1778 });
1779
1780 if(item_codes.length) {
1781 return this.frm.call({
1782 method: "erpnext.stock.get_item_details.get_item_tax_info",
1783 args: {
1784 company: me.frm.doc.company,
1785 tax_category: cstr(me.frm.doc.tax_category),
1786 item_codes: item_codes
1787 },
1788 callback: function(r) {
1789 if(!r.exc) {
1790 $.each(me.frm.doc.items || [], function(i, item) {
1791 if(item.item_code && r.message.hasOwnProperty(item.item_code)) {
Deepesh Garg8d7f5d32020-05-22 12:28:45 +05301792 if (!item.item_tax_template) {
1793 item.item_tax_template = r.message[item.item_code].item_tax_template;
1794 item.item_tax_rate = r.message[item.item_code].item_tax_rate;
1795 }
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001796 me.add_taxes_from_item_tax_template(item.item_tax_rate);
1797 } else {
1798 item.item_tax_template = "";
1799 item.item_tax_rate = "{}";
1800 }
1801 });
1802 me.calculate_taxes_and_totals();
1803 }
1804 }
1805 });
1806 }
1807 },
1808
Anand Doshi13945092014-09-21 19:45:49 +05301809 is_recurring: function() {
1810 // set default values for recurring documents
Rushabh Mehta756e5182016-03-03 13:00:17 +05301811 if(this.frm.doc.is_recurring && this.frm.doc.__islocal) {
1812 frappe.msgprint(__("Please set recurring after saving"));
1813 this.frm.set_value('is_recurring', 0);
1814 return;
1815 }
1816
Anand Doshi13945092014-09-21 19:45:49 +05301817 if(this.frm.doc.is_recurring) {
Nabin Hait68a628e2016-03-21 12:03:16 +05301818 if(!this.frm.doc.recurring_id) {
1819 this.frm.set_value('recurring_id', this.frm.doc.name);
1820 }
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301821
Anand Doshi13945092014-09-21 19:45:49 +05301822 var owner_email = this.frm.doc.owner=="Administrator"
1823 ? frappe.user_info("Administrator").email
1824 : this.frm.doc.owner;
1825
1826 this.frm.doc.notification_email_address = $.map([cstr(owner_email),
1827 cstr(this.frm.doc.contact_email)], function(v) { return v || null; }).join(", ");
1828 this.frm.doc.repeat_on_day_of_month = frappe.datetime.str_to_obj(this.frm.doc.posting_date).getDate();
1829 }
1830
1831 refresh_many(["notification_email_address", "repeat_on_day_of_month"]);
1832 },
1833
1834 from_date: function() {
1835 // set to_date
1836 if(this.frm.doc.from_date) {
1837 var recurring_type_map = {'Monthly': 1, 'Quarterly': 3, 'Half-yearly': 6,
1838 'Yearly': 12};
1839
1840 var months = recurring_type_map[this.frm.doc.recurring_type];
1841 if(months) {
1842 var to_date = frappe.datetime.add_months(this.frm.doc.from_date,
1843 months);
1844 this.frm.doc.to_date = frappe.datetime.add_days(to_date, -1);
1845 refresh_field('to_date');
1846 }
1847 }
Saurabhd3135532016-02-25 18:59:20 +05301848 },
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301849
Saurabh2d7af632016-02-26 11:09:20 +05301850 set_gross_profit: function(item) {
Abhishek Balam18e7b602020-05-26 18:37:02 +05301851 if (["Sales Order", "Quotation"].includes(this.frm.doc.doctype) && item.valuation_rate) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301852 var rate = flt(item.rate) * flt(this.frm.doc.conversion_rate || 1);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301853 item.gross_profit = flt(((rate - item.valuation_rate) * item.stock_qty), precision("amount", item));
Saurabh2d7af632016-02-26 11:09:20 +05301854 }
Rushabh Mehta203cc962016-04-07 15:25:43 +05301855 },
1856
1857 setup_item_selector: function() {
Rushabh Mehtabc928242016-05-29 23:08:22 +05301858 // TODO: remove item selector
1859
1860 return;
Faris Ansariab74ca72017-05-30 12:54:42 +05301861 // if(!this.item_selector) {
1862 // this.item_selector = new erpnext.ItemSelector({frm: this.frm});
1863 // }
Nabin Hait28a05282016-06-27 17:41:39 +05301864 },
Rushabh Mehta76b13412016-07-18 14:30:18 +05301865
Nabin Hait28a05282016-06-27 17:41:39 +05301866 get_advances: function() {
1867 if(!this.frm.is_return) {
1868 return this.frm.call({
1869 method: "set_advances",
1870 doc: this.frm.doc,
1871 callback: function(r, rt) {
1872 refresh_field("advances");
1873 }
1874 })
1875 }
Nabin Hait05aefbb2016-06-28 19:42:19 +05301876 },
Rushabh Mehta76b13412016-07-18 14:30:18 +05301877
Nabin Hait05aefbb2016-06-28 19:42:19 +05301878 make_payment_entry: function() {
1879 return frappe.call({
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301880 method: cur_frm.cscript.get_method_for_payment(),
Nabin Hait05aefbb2016-06-28 19:42:19 +05301881 args: {
1882 "dt": cur_frm.doc.doctype,
1883 "dn": cur_frm.doc.name
1884 },
1885 callback: function(r) {
1886 var doclist = frappe.model.sync(r.message);
1887 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
Nabin Hait56548cb2016-07-01 15:58:39 +05301888 // cur_frm.refresh_fields()
Nabin Hait05aefbb2016-06-28 19:42:19 +05301889 }
1890 });
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301891 },
1892
1893 get_method_for_payment: function(){
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301894 var method = "erpnext.accounts.doctype.payment_entry.payment_entry.get_payment_entry";
Rohit Waghchaure7d529892016-10-06 14:35:04 +05301895 if(cur_frm.doc.__onload && cur_frm.doc.__onload.make_payment_via_journal_entry){
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301896 if(in_list(['Sales Invoice', 'Purchase Invoice'], cur_frm.doc.doctype)){
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301897 method = "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_invoice";
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301898 }else {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301899 method= "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_order";
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301900 }
1901 }
1902
1903 return method
Manas Solankicc902412016-11-10 19:15:11 +05301904 },
Makarand Bauskarc196d742017-06-02 17:28:40 +05301905
1906 set_query_for_batch: function(doc, cdt, cdn) {
1907 // Show item's batches in the dropdown of batch no
1908
1909 var me = this;
1910 var item = frappe.get_doc(cdt, cdn);
1911
1912 if(!item.item_code) {
1913 frappe.throw(__("Please enter Item Code to get batch no"));
Rushabh Mehta36311022017-06-20 09:30:53 +05301914 } else if (doc.doctype == "Purchase Receipt" ||
Makarand Bauskarc196d742017-06-02 17:28:40 +05301915 (doc.doctype == "Purchase Invoice" && doc.update_stock)) {
Makarand Bauskarc196d742017-06-02 17:28:40 +05301916 return {
1917 filters: {'item': item.item_code}
1918 }
1919 } else {
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301920 let filters = {
Makarand Bauskarc196d742017-06-02 17:28:40 +05301921 'item_code': item.item_code,
1922 'posting_date': me.frm.doc.posting_date || frappe.datetime.nowdate(),
1923 }
Rohit Waghchaured8ddd1e2019-10-22 14:03:27 +05301924
1925 if (doc.is_return) {
1926 filters["is_return"] = 1;
1927 }
1928
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301929 if (item.warehouse) filters["warehouse"] = item.warehouse;
Makarand Bauskarc196d742017-06-02 17:28:40 +05301930
KanchanChauhan0fe455a2017-11-17 20:08:15 +05301931 return {
Makarand Bauskarc196d742017-06-02 17:28:40 +05301932 query : "erpnext.controllers.queries.get_batch_no",
1933 filters: filters
1934 }
1935 }
1936 },
Nabin Hait92759692017-08-15 08:23:51 +05301937
Deepesh Gargef0d26c2020-01-06 15:34:15 +05301938 set_query_for_item_tax_template: function(doc, cdt, cdn) {
Deepesh Gargef0d26c2020-01-06 15:34:15 +05301939 var item = frappe.get_doc(cdt, cdn);
1940 if(!item.item_code) {
casesolved-co-uka7803062021-02-16 05:48:50 +00001941 return doc.company ? {filters: {company: doc.company}} : {};
Deepesh Gargef0d26c2020-01-06 15:34:15 +05301942 } else {
Deepesh Gargef0d26c2020-01-06 15:34:15 +05301943 let filters = {
1944 'item_code': item.item_code,
Marica0fcb05a2020-08-10 14:48:13 +05301945 'valid_from': ["<=", doc.transaction_date || doc.bill_date || doc.posting_date],
Deepesh Gargef0d26c2020-01-06 15:34:15 +05301946 'item_group': item.item_group,
1947 }
1948
1949 if (doc.tax_category)
1950 filters['tax_category'] = doc.tax_category;
mohammadahmad199041c0c9f2020-06-18 11:18:44 +05001951 if (doc.company)
1952 filters['company'] = doc.company;
Deepesh Gargef0d26c2020-01-06 15:34:15 +05301953 return {
1954 query: "erpnext.controllers.queries.get_tax_template",
1955 filters: filters
1956 }
1957 }
1958 },
1959
Nabin Hait92759692017-08-15 08:23:51 +05301960 payment_terms_template: function() {
1961 var me = this;
tundebabzy8f44d1c2018-01-05 08:16:50 +01001962 const doc = this.frm.doc;
1963 if(doc.payment_terms_template && doc.doctype !== 'Delivery Note') {
Shreya Shah3a9eec22018-02-16 13:05:21 +05301964 var posting_date = doc.posting_date || doc.transaction_date;
Nabin Hait92759692017-08-15 08:23:51 +05301965 frappe.call({
1966 method: "erpnext.controllers.accounts_controller.get_payment_terms",
1967 args: {
tundebabzy8f44d1c2018-01-05 08:16:50 +01001968 terms_template: doc.payment_terms_template,
rohitwaghchaureda941af2018-01-17 16:23:04 +05301969 posting_date: posting_date,
Shreya Shah3a9eec22018-02-16 13:05:21 +05301970 grand_total: doc.rounded_total || doc.grand_total,
1971 bill_date: doc.bill_date
Nabin Hait92759692017-08-15 08:23:51 +05301972 },
1973 callback: function(r) {
1974 if(r.message && !r.exc) {
1975 me.frm.set_value("payment_schedule", r.message);
1976 }
1977 }
1978 })
1979 }
1980 },
1981
1982 payment_term: function(doc, cdt, cdn) {
1983 var row = locals[cdt][cdn];
1984 if(row.payment_term) {
1985 frappe.call({
1986 method: "erpnext.controllers.accounts_controller.get_payment_term_details",
1987 args: {
1988 term: row.payment_term,
Shreya Shah3a9eec22018-02-16 13:05:21 +05301989 bill_date: this.frm.doc.bill_date,
Nabin Hait92759692017-08-15 08:23:51 +05301990 posting_date: this.frm.doc.posting_date || this.frm.doc.transaction_date,
Nabin Hait0551f7b2017-11-21 19:58:16 +05301991 grand_total: this.frm.doc.rounded_total || this.frm.doc.grand_total
Nabin Hait92759692017-08-15 08:23:51 +05301992 },
1993 callback: function(r) {
1994 if(r.message && !r.exc) {
1995 for (var d in r.message) {
1996 frappe.model.set_value(cdt, cdn, d, r.message[d]);
1997 }
1998 }
1999 }
2000 })
2001 }
Manas Solankie5e87f72018-05-28 20:07:08 +05302002 },
2003
ronelvcabrera370cdc02019-12-04 18:37:11 +08002004 against_blanket_order: function(doc, cdt, cdn) {
2005 var item = locals[cdt][cdn];
2006 if(!item.against_blanket_order) {
2007 frappe.model.set_value(this.frm.doctype + " Item", item.name, "blanket_order", null);
2008 frappe.model.set_value(this.frm.doctype + " Item", item.name, "blanket_order_rate", 0.00);
2009 }
2010 },
2011
Manas Solankie5e87f72018-05-28 20:07:08 +05302012 blanket_order: function(doc, cdt, cdn) {
2013 var me = this;
2014 var item = locals[cdt][cdn];
2015 if (item.blanket_order && (item.parenttype=="Sales Order" || item.parenttype=="Purchase Order")) {
2016 frappe.call({
2017 method: "erpnext.stock.get_item_details.get_blanket_order_details",
2018 args: {
2019 args:{
2020 item_code: item.item_code,
2021 customer: doc.customer,
2022 supplier: doc.supplier,
2023 company: doc.company,
2024 transaction_date: doc.transaction_date,
2025 blanket_order: item.blanket_order
2026 }
2027 },
2028 callback: function(r) {
2029 if (!r.message) {
Manas Solanki2df1b312018-05-29 12:56:14 +05302030 frappe.throw(__("Invalid Blanket Order for the selected Customer and Item"));
Manas Solankie5e87f72018-05-28 20:07:08 +05302031 } else {
2032 frappe.run_serially([
2033 () => frappe.model.set_value(cdt, cdn, "blanket_order_rate", r.message.blanket_order_rate),
2034 () => me.frm.script_manager.trigger("price_list_rate", cdt, cdn)
2035 ]);
2036 }
2037 }
2038 })
2039 }
Saif60ec88b2018-11-13 12:07:53 +05002040 },
2041
Marica93cb64e2019-12-23 18:24:56 +05302042 set_reserve_warehouse: function() {
marination8a30cb22020-04-23 00:18:21 +05302043 this.autofill_warehouse(this.frm.doc.supplied_items, "reserve_warehouse", this.frm.doc.set_reserve_warehouse);
Marica93cb64e2019-12-23 18:24:56 +05302044 },
2045
Saif60ec88b2018-11-13 12:07:53 +05002046 set_warehouse: function() {
marination8a30cb22020-04-23 00:18:21 +05302047 this.autofill_warehouse(this.frm.doc.items, "warehouse", this.frm.doc.set_warehouse);
Marica93cb64e2019-12-23 18:24:56 +05302048 },
2049
Deepesh Gargb4be2922021-01-28 13:09:56 +05302050 set_target_warehouse: function() {
2051 this.autofill_warehouse(this.frm.doc.items, "target_warehouse", this.frm.doc.set_target_warehouse);
2052 },
2053
2054 set_from_warehouse: function() {
2055 this.autofill_warehouse(this.frm.doc.items, "from_warehouse", this.frm.doc.set_from_warehouse);
2056 },
2057
marination8a30cb22020-04-23 00:18:21 +05302058 autofill_warehouse : function (child_table, warehouse_field, warehouse) {
marinationb7f68782020-04-28 19:18:45 +05302059 if (warehouse && child_table && child_table.length) {
2060 let doctype = child_table[0].doctype;
Marica93cb64e2019-12-23 18:24:56 +05302061 $.each(child_table || [], function(i, item) {
2062 frappe.model.set_value(doctype, item.name, warehouse_field, warehouse);
Saif60ec88b2018-11-13 12:07:53 +05002063 });
2064 }
ashish-greycube74dc3c92019-08-12 13:39:25 +05302065 },
Marica93cb64e2019-12-23 18:24:56 +05302066
ashish-greycube74dc3c92019-08-12 13:39:25 +05302067 coupon_code: function() {
2068 var me = this;
2069 frappe.run_serially([
2070 () => this.frm.doc.ignore_pricing_rule=1,
2071 () => me.ignore_pricing_rule(),
2072 () => this.frm.doc.ignore_pricing_rule=0,
2073 () => me.apply_pricing_rule()
2074 ]);
Nabin Hait92759692017-08-15 08:23:51 +05302075 }
Nabin Hait6e740792017-05-06 12:45:16 +05302076});
pratu16x7ae450fc2017-06-26 15:31:46 +05302077
Rohan73726722019-12-24 18:19:58 +05302078erpnext.show_serial_batch_selector = function (frm, d, callback, on_close, show_dialog) {
2079 let warehouse, receiving_stock, existing_stock;
2080 if (frm.doc.is_return) {
2081 if (["Purchase Receipt", "Purchase Invoice"].includes(frm.doc.doctype)) {
2082 existing_stock = true;
2083 warehouse = d.warehouse;
2084 } else if (["Delivery Note", "Sales Invoice"].includes(frm.doc.doctype)) {
2085 receiving_stock = true;
2086 }
2087 } else {
2088 if (frm.doc.doctype == "Stock Entry") {
2089 if (frm.doc.purpose == "Material Receipt") {
2090 receiving_stock = true;
2091 } else {
2092 existing_stock = true;
2093 warehouse = d.s_warehouse;
2094 }
2095 } else {
2096 existing_stock = true;
2097 warehouse = d.warehouse;
2098 }
2099 }
2100
2101 if (!warehouse) {
2102 if (receiving_stock) {
2103 warehouse = ["like", ""];
2104 } else if (existing_stock) {
2105 warehouse = ["!=", ""];
2106 }
2107 }
2108
pratu16x7ae450fc2017-06-26 15:31:46 +05302109 frappe.require("assets/erpnext/js/utils/serial_no_batch_selector.js", function() {
pratu16x789d001c2017-06-26 17:45:49 +05302110 new erpnext.SerialNoBatchSelector({
pratu16x7ae450fc2017-06-26 15:31:46 +05302111 frm: frm,
2112 item: d,
2113 warehouse_details: {
2114 type: "Warehouse",
Rohan73726722019-12-24 18:19:58 +05302115 name: warehouse
pratu16x7ae450fc2017-06-26 15:31:46 +05302116 },
rohitwaghchaure2b95a542017-12-14 16:06:23 +05302117 callback: callback,
2118 on_close: on_close
Rohit Waghchaure6ab63032017-09-01 15:28:44 +05302119 }, show_dialog);
pratu16x7ae450fc2017-06-26 15:31:46 +05302120 });
2121}
marination0f3cfc52020-12-08 19:11:51 +05302122
marinationc47d38d2020-12-14 11:48:04 +05302123erpnext.apply_putaway_rule = (frm, purpose=null) => {
marination0f3cfc52020-12-08 19:11:51 +05302124 if (!frm.doc.company) {
2125 frappe.throw({message: __("Please select a Company first."), title: __("Mandatory")});
2126 }
2127 if (!frm.doc.items.length) return;
2128
2129 frappe.call({
2130 method: "erpnext.stock.doctype.putaway_rule.putaway_rule.apply_putaway_rule",
2131 args: {
2132 doctype: frm.doctype,
2133 items: frm.doc.items,
2134 company: frm.doc.company,
marinationc47d38d2020-12-14 11:48:04 +05302135 sync: true,
2136 purpose: purpose
marination0f3cfc52020-12-08 19:11:51 +05302137 },
2138 callback: (result) => {
2139 if (!result.exc && result.message) {
2140 frm.clear_table("items");
2141
2142 let items = result.message;
2143 items.forEach((row) => {
marinationa5d8d322020-12-09 16:27:18 +05302144 delete row["name"]; // dont overwrite name from server side
marination0f3cfc52020-12-08 19:11:51 +05302145 let child = frm.add_child("items");
2146 Object.assign(child, row);
marinationa5d8d322020-12-09 16:27:18 +05302147 frm.script_manager.trigger("qty", child.doctype, child.name);
marination0f3cfc52020-12-08 19:11:51 +05302148 });
2149 frm.get_field("items").grid.refresh();
2150 }
2151 }
2152 });
casesolved-co-uka7803062021-02-16 05:48:50 +00002153};