blob: 64067357639dd35987068855c3fcc7d6b6f5b46e [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 +05304
Faris Ansari1fe891b2021-04-23 08:04:00 +05305erpnext.TransactionController = class TransactionController extends erpnext.taxes_and_totals {
6 setup() {
Suraj Shetty81d49e92021-05-21 17:03:09 +05307 super.setup();
Deepesh Garg8a7e2832021-06-04 22:53:26 +05308 let me = this;
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05309
10 this.frm.ignore_doctypes_on_cancel_all = ['Serial and Batch Bundle'];
11
Saqibfaea8542020-03-26 13:18:57 +053012 frappe.flags.hide_serial_batch_dialog = true;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053013 frappe.ui.form.on(this.frm.doctype + " Item", "rate", function(frm, cdt, cdn) {
14 var item = frappe.get_doc(cdt, cdn);
Rushabh Mehtaf69ffeb2017-05-17 19:40:40 +053015 var has_margin_field = frappe.meta.has_field(cdt, 'margin_type');
16
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053017 frappe.model.round_floats_in(item, ["rate", "price_list_rate"]);
18
Deepesh Garg54cdff72022-03-25 12:17:51 +053019 if(item.price_list_rate) {
20 if(item.rate > item.price_list_rate && has_margin_field) {
21 // if rate is greater than price_list_rate, set margin
22 // or set discount
23 item.discount_percentage = 0;
24 item.margin_type = 'Amount';
25 item.margin_rate_or_amount = flt(item.rate - item.price_list_rate,
26 precision("margin_rate_or_amount", item));
27 item.rate_with_margin = item.rate;
28 } else {
29 item.discount_percentage = flt((1 - item.rate / item.price_list_rate) * 100.0,
30 precision("discount_percentage", item));
31 item.discount_amount = flt(item.price_list_rate) - flt(item.rate);
32 item.margin_type = '';
33 item.margin_rate_or_amount = 0;
34 item.rate_with_margin = 0;
35 }
36 } else {
37 item.discount_percentage = 0.0;
38 item.margin_type = '';
39 item.margin_rate_or_amount = 0;
40 item.rate_with_margin = 0;
41 }
42 item.base_rate_with_margin = item.rate_with_margin * flt(frm.doc.conversion_rate);
43
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053044 cur_frm.cscript.set_gross_profit(item);
45 cur_frm.cscript.calculate_taxes_and_totals();
Anupam Kumar7e1dcf92021-02-11 20:19:30 +053046 cur_frm.cscript.calculate_stock_uom_rate(frm, cdt, cdn);
Rushabh Mehta30dc9a12017-11-17 14:31:09 +053047 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053048
49 frappe.ui.form.on(this.frm.cscript.tax_table, "rate", function(frm, cdt, cdn) {
50 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053051 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053052
53 frappe.ui.form.on(this.frm.cscript.tax_table, "tax_amount", function(frm, cdt, cdn) {
54 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053055 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053056
57 frappe.ui.form.on(this.frm.cscript.tax_table, "row_id", function(frm, cdt, cdn) {
58 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053059 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053060
61 frappe.ui.form.on(this.frm.cscript.tax_table, "included_in_print_rate", function(frm, cdt, cdn) {
62 cur_frm.cscript.set_dynamic_labels();
63 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053064 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053065
66 frappe.ui.form.on(this.frm.doctype, "apply_discount_on", function(frm) {
67 if(frm.doc.additional_discount_percentage) {
68 frm.trigger("additional_discount_percentage");
69 } else {
70 cur_frm.cscript.calculate_taxes_and_totals();
71 }
Rushabh Mehta764aa922016-05-02 13:28:46 +053072 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053073
74 frappe.ui.form.on(this.frm.doctype, "additional_discount_percentage", function(frm) {
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053075 if(!frm.doc.apply_discount_on) {
76 frappe.msgprint(__("Please set 'Apply Additional Discount On'"));
Rushabh Mehta233a19a2017-07-07 13:05:11 +053077 return;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053078 }
79
80 frm.via_discount_percentage = true;
81
82 if(frm.doc.additional_discount_percentage && frm.doc.discount_amount) {
83 // Reset discount amount and net / grand total
Rushabh Mehta6705ab32017-07-07 13:14:08 +053084 frm.doc.discount_amount = 0;
85 frm.cscript.calculate_taxes_and_totals();
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053086 }
87
88 var total = flt(frm.doc[frappe.model.scrub(frm.doc.apply_discount_on)]);
89 var discount_amount = flt(total*flt(frm.doc.additional_discount_percentage) / 100,
90 precision("discount_amount"));
91
Rushabh Mehta233a19a2017-07-07 13:05:11 +053092 frm.set_value("discount_amount", discount_amount)
93 .then(() => delete frm.via_discount_percentage);
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053094 });
95
96 frappe.ui.form.on(this.frm.doctype, "discount_amount", function(frm) {
97 frm.cscript.set_dynamic_labels();
98
99 if (!frm.via_discount_percentage) {
Rushabh Mehta233a19a2017-07-07 13:05:11 +0530100 frm.doc.additional_discount_percentage = 0;
Rushabh Mehtabe2ee182016-04-29 17:22:42 +0530101 }
102
103 frm.cscript.calculate_taxes_and_totals();
104 });
Makarand Bauskarc196d742017-06-02 17:28:40 +0530105
Saif60ec88b2018-11-13 12:07:53 +0500106 frappe.ui.form.on(this.frm.doctype + " Item", {
107 items_add: function(frm, cdt, cdn) {
108 var item = frappe.get_doc(cdt, cdn);
Deepesh Gargb4be2922021-01-28 13:09:56 +0530109 if (!item.warehouse && frm.doc.set_warehouse) {
Saif60ec88b2018-11-13 12:07:53 +0500110 item.warehouse = frm.doc.set_warehouse;
111 }
Deepesh Garg6b9dda52020-11-25 14:49:10 +0530112
Deepesh Gargb4be2922021-01-28 13:09:56 +0530113 if (!item.target_warehouse && frm.doc.set_target_warehouse) {
114 item.target_warehouse = frm.doc.set_target_warehouse;
115 }
116
117 if (!item.from_warehouse && frm.doc.set_from_warehouse) {
118 item.from_warehouse = frm.doc.set_from_warehouse;
119 }
120
Deepesh Garg6b9dda52020-11-25 14:49:10 +0530121 erpnext.accounts.dimensions.copy_dimension_from_first_row(frm, cdt, cdn, 'items');
Saif60ec88b2018-11-13 12:07:53 +0500122 }
123 });
124
Rohit Waghchaurebc75a7e2022-10-10 13:28:19 +0530125 if(this.frm.fields_dict["items"].grid.get_field('serial_and_batch_bundle')) {
126 this.frm.set_query("serial_and_batch_bundle", "items", function(doc, cdt, cdn) {
127 let item_row = locals[cdt][cdn];
128 return {
129 filters: {
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +0530130 'item_code': item_row.item_code,
131 'voucher_type': doc.doctype,
132 'voucher_no': ["in", [doc.name, ""]],
s-aga-r5c805db2023-06-12 13:06:13 +0530133 'is_cancelled': 0,
Rohit Waghchaurebc75a7e2022-10-10 13:28:19 +0530134 }
135 }
Makarand Bauskarc196d742017-06-02 17:28:40 +0530136 });
137 }
Akhilesh Darjee564c6212013-10-17 11:31:11 +0530138
tundebabzy590bd0a2017-12-25 07:10:19 +0100139 if(
Faris Ansari404f39d2018-05-14 15:46:45 +0530140 this.frm.docstatus < 2
Manas Solankia7f55892018-04-02 10:32:00 +0530141 && this.frm.fields_dict["payment_terms_template"]
tundebabzy590bd0a2017-12-25 07:10:19 +0100142 && this.frm.fields_dict["payment_schedule"]
143 && this.frm.doc.payment_terms_template
144 && !this.frm.doc.payment_schedule.length
145 ){
tundedf3a1752017-09-11 11:02:57 +0100146 this.frm.trigger("payment_terms_template");
147 }
148
Nabin Haitdd38a262014-12-26 13:15:21 +0530149 if(this.frm.fields_dict["taxes"]) {
150 this["taxes_remove"] = this.calculate_taxes_and_totals;
Anand Doshia91c95f2013-08-23 13:00:47 +0530151 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530152
Nabin Haitdd38a262014-12-26 13:15:21 +0530153 if(this.frm.fields_dict["items"]) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530154 this["items_remove"] = this.calculate_net_weight;
Anand Doshi1e4fb682013-08-23 12:56:33 +0530155 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530156
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530157 if(this.frm.fields_dict["recurring_print_format"]) {
158 this.frm.set_query("recurring_print_format", function(doc) {
159 return{
160 filters: [
161 ['Print Format', 'doc_type', '=', cur_frm.doctype],
162 ]
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530163 };
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530164 });
165 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530166
Nabin Hait1d218422015-07-17 15:19:02 +0530167 if(this.frm.fields_dict["return_against"]) {
168 this.frm.set_query("return_against", function(doc) {
169 var filters = {
170 "docstatus": 1,
171 "is_return": 0,
172 "company": doc.company
173 };
174 if (me.frm.fields_dict["customer"] && doc.customer) filters["customer"] = doc.customer;
175 if (me.frm.fields_dict["supplier"] && doc.supplier) filters["supplier"] = doc.supplier;
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530176
Nabin Hait1d218422015-07-17 15:19:02 +0530177 return {
178 filters: filters
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530179 };
Nabin Hait1d218422015-07-17 15:19:02 +0530180 });
181 }
michellealva08f842d2020-06-26 19:56:00 +0530182
rohitwaghchaured5736712020-06-28 11:12:20 +0530183 if (this.frm.fields_dict["items"].grid.get_field("expense_account")) {
michellealva08f842d2020-06-26 19:56:00 +0530184 this.frm.set_query("expense_account", "items", function(doc) {
rohitwaghchaured5736712020-06-28 11:12:20 +0530185 return {
michellealva08f842d2020-06-26 19:56:00 +0530186 filters: {
Deepesh Gargd54f5242023-06-30 20:02:46 +0530187 "company": doc.company,
188 "report_type": "Profit and Loss",
189 "is_group": 0
michellealva08f842d2020-06-26 19:56:00 +0530190 }
191 };
192 });
193 }
194
Rohit Waghchauree5405342019-03-31 16:42:41 +0530195 if(frappe.meta.get_docfield(this.frm.doc.doctype, "pricing_rules")) {
Rohit Waghchaure70b996a2019-03-31 20:33:15 +0530196 this.frm.set_indicator_formatter('pricing_rule', function(doc) {
197 return (doc.rule_applied) ? "green" : "red";
198 });
Rohit Waghchauree5405342019-03-31 16:42:41 +0530199 }
Rohit Waghchaurea5357c22020-03-27 12:54:01 +0530200
Marica299e2172020-04-28 13:00:04 +0530201 if (this.frm.fields_dict["items"].grid.get_field('blanket_order')) {
202 this.frm.set_query("blanket_order", "items", function(doc, cdt, cdn) {
203 var item = locals[cdt][cdn];
204 return {
205 query: "erpnext.controllers.queries.get_blanket_orders",
206 filters: {
207 "company": doc.company,
208 "blanket_order_type": doc.doctype === "Sales Order" ? "Selling" : "Purchasing",
209 "item": item.item_code
210 }
211 }
212 });
213 }
214
Mohammad Hasnain Mohsin Rajane15b6a92020-11-25 15:36:41 +0530215 if (this.frm.fields_dict.taxes_and_charges) {
216 this.frm.set_query("taxes_and_charges", function() {
217 return {
218 filters: [
219 ['company', '=', me.frm.doc.company],
220 ['docstatus', '!=', 2]
221 ]
222 };
223 });
224 }
225
Faris Ansari1fe891b2021-04-23 08:04:00 +0530226 }
rohitwaghchauredd4769e2023-09-20 18:09:03 +0530227
228 toggle_enable_for_stock_uom(field) {
229 frappe.db.get_single_value('Stock Settings', field)
230 .then(value => {
231 this.frm.fields_dict["items"].grid.toggle_enable("stock_qty", value);
232 });
233 }
234
Faris Ansari1fe891b2021-04-23 08:04:00 +0530235 onload() {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530236 var me = this;
Rushabh Mehta6b537922017-03-14 16:59:11 +0530237
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530238 if(this.frm.doc.__islocal) {
239 var currency = frappe.defaults.get_user_default("currency");
240
241 let set_value = (fieldname, value) => {
242 if(me.frm.fields_dict[fieldname] && !me.frm.doc[fieldname]) {
243 return me.frm.set_value(fieldname, value);
244 }
245 };
246
Deepesh Gargb4be2922021-01-28 13:09:56 +0530247 this.frm.trigger('set_default_internal_warehouse');
248
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530249 return frappe.run_serially([
250 () => set_value('currency', currency),
251 () => set_value('price_list_currency', currency),
252 () => set_value('status', 'Draft'),
Sagar Sharmad074c932022-03-31 19:57:42 +0530253 () => set_value('is_subcontracted', 0),
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530254 () => {
255 if(this.frm.doc.company && !this.frm.doc.amended_from) {
256 this.frm.trigger("company");
257 }
258 }
259 ]);
260 }
HENRY Florian34bb64e2023-09-16 12:29:09 +0200261
262 if(this.frm.fields_dict['items'].grid.get_field('serial_and_batch_bundle')) {
263 let sbb_field = this.frm.get_docfield('items', 'serial_and_batch_bundle');
264 if (sbb_field) {
265 sbb_field.get_route_options_for_new_doc = (row) => {
266 return {
267 'item_code': row.doc.item_code,
268 }
269 };
270 }
271 }
272
273 if(this.frm.fields_dict['items'].grid.get_field('batch_no')) {
274 let batch_no_field = this.frm.get_docfield('items', 'batch_no');
275 if (batch_no_field) {
276 batch_no_field.get_route_options_for_new_doc = function(row) {
277 return {
278 'item': row.doc.item_code
279 }
280 };
281 }
282 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530283 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530284
Faris Ansari1fe891b2021-04-23 08:04:00 +0530285 is_return() {
Rohit Waghchaureb4a59932018-11-26 20:02:01 +0530286 if(!this.frm.doc.is_return && this.frm.doc.return_against) {
287 this.frm.set_value('return_against', '');
288 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530289 }
Rohit Waghchaureb4a59932018-11-26 20:02:01 +0530290
Faris Ansari1fe891b2021-04-23 08:04:00 +0530291 setup_quality_inspection() {
s-aga-r3fab6612023-08-23 13:21:36 +0530292 if(!in_list(["Delivery Note", "Sales Invoice", "Purchase Receipt", "Purchase Invoice", "Subcontracting Receipt"], this.frm.doc.doctype)) {
Nabin Hait8af429d2016-11-16 17:21:59 +0530293 return;
294 }
Rohan Bansala93b5142021-04-06 17:10:52 +0530295
296 const me = this;
297 if (!this.frm.is_new() && this.frm.doc.docstatus === 0) {
298 this.frm.add_custom_button(__("Quality Inspection(s)"), () => {
299 me.make_quality_inspection();
300 }, __("Create"));
301 this.frm.page.set_inner_btn_group_as_primary(__('Create'));
302 }
303
s-aga-r3fab6612023-08-23 13:21:36 +0530304 const inspection_type = in_list(["Purchase Receipt", "Purchase Invoice", "Subcontracting Receipt"], this.frm.doc.doctype)
Nabin Hait8af429d2016-11-16 17:21:59 +0530305 ? "Incoming" : "Outgoing";
Rushabh Mehta6b537922017-03-14 16:59:11 +0530306
Rohan Bansala93b5142021-04-06 17:10:52 +0530307 let quality_inspection_field = this.frm.get_docfield("items", "quality_inspection");
Nabin Hait8af429d2016-11-16 17:21:59 +0530308 quality_inspection_field.get_route_options_for_new_doc = function(row) {
Marc de Lima Lucio3c393bf2023-01-02 04:48:25 +0100309 if(me.frm.is_new()) return {};
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530310 return {
311 "inspection_type": inspection_type,
Manas Solanki34feab12016-11-16 14:36:28 +0530312 "reference_type": me.frm.doc.doctype,
Manas Solankidbc25112016-11-16 15:06:08 +0530313 "reference_name": me.frm.doc.name,
Nabin Hait8af429d2016-11-16 17:21:59 +0530314 "item_code": row.doc.item_code,
315 "description": row.doc.description,
316 "item_serial_no": row.doc.serial_no ? row.doc.serial_no.split("\n")[0] : null,
317 "batch_no": row.doc.batch_no
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530318 }
319 }
Rushabh Mehta6b537922017-03-14 16:59:11 +0530320
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530321 this.frm.set_query("quality_inspection", "items", function(doc, cdt, cdn) {
Rohan Bansala93b5142021-04-06 17:10:52 +0530322 let d = locals[cdt][cdn];
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530323 return {
324 filters: {
325 docstatus: 1,
326 inspection_type: inspection_type,
rohitwaghchaure4e8fdf72018-02-22 11:03:48 +0530327 reference_name: doc.name,
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530328 item_code: d.item_code
329 }
330 }
331 });
Faris Ansari1fe891b2021-04-23 08:04:00 +0530332 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530333
Faris Ansari1fe891b2021-04-23 08:04:00 +0530334 make_payment_request() {
Deepesh Gargdc178982022-12-15 14:15:20 +0530335 let me = this;
Rohit Waghchaure210f4982018-10-03 15:55:51 +0530336 const payment_request_type = (in_list(['Sales Order', 'Sales Invoice'], this.frm.doc.doctype))
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530337 ? "Inward" : "Outward";
338
339 frappe.call({
340 method:"erpnext.accounts.doctype.payment_request.payment_request.make_payment_request",
341 args: {
342 dt: me.frm.doc.doctype,
343 dn: me.frm.doc.name,
344 recipient_id: me.frm.doc.contact_email,
345 payment_request_type: payment_request_type,
346 party_type: payment_request_type == 'Outward' ? "Supplier" : "Customer",
347 party: payment_request_type == 'Outward' ? me.frm.doc.supplier : me.frm.doc.customer
348 },
349 callback: function(r) {
350 if(!r.exc){
Deepesh Gargdc178982022-12-15 14:15:20 +0530351 frappe.model.sync(r.message);
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530352 frappe.set_route("Form", r.message.doctype, r.message.name);
353 }
354 }
355 })
Faris Ansari1fe891b2021-04-23 08:04:00 +0530356 }
rohitwaghchaure713cfc72018-09-11 17:40:37 +0530357
Faris Ansari1fe891b2021-04-23 08:04:00 +0530358 onload_post_render() {
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530359 if(this.frm.doc.__islocal && !(this.frm.doc.taxes || []).length
Sagar Vorab6a75492023-12-02 20:06:19 +0530360 && !this.frm.doc.__onload?.load_after_mapping) {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530361 frappe.after_ajax(() => this.apply_default_taxes());
Anand Doshi70f57eb2015-11-27 14:37:40 +0530362 } else if(this.frm.doc.__islocal && this.frm.doc.company && this.frm.doc["items"]
Nabin Haitbdfb0702015-10-28 15:38:08 +0530363 && !this.frm.doc.is_pos) {
Nabin Hait7b6eaee2017-10-03 01:09:46 +0530364 frappe.after_ajax(() => this.calculate_taxes_and_totals());
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530365 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530366 if(frappe.meta.get_docfield(this.frm.doc.doctype + " Item", "item_code")) {
Rushabh Mehta203cc962016-04-07 15:25:43 +0530367 this.setup_item_selector();
Nabin Hait3fccfaa2019-05-16 14:48:10 +0530368 this.frm.get_field("items").grid.set_multiple_add("item_code", "qty");
Rushabh Mehtab6843f22014-06-04 13:10:41 +0530369 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530370 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530371
Faris Ansari1fe891b2021-04-23 08:04:00 +0530372 refresh() {
Anand Doshi8bde7f92014-04-24 18:11:49 +0530373 erpnext.toggle_naming_series();
Anand Doshibdee6e02013-07-09 13:03:39 +0530374 erpnext.hide_company();
Nabin Hait1f996c32013-07-29 19:00:53 +0530375 this.set_dynamic_labels();
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530376 this.setup_sms();
Rohit Waghchauref2705672018-06-12 12:20:52 +0530377 this.setup_quality_inspection();
Rohit Waghchauree5b19e32022-11-02 20:38:07 +0530378 this.validate_has_items();
Rohit Waghchaure708eefb2023-07-10 16:54:55 +0530379 erpnext.utils.view_serial_batch_nos(this.frm);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530380 }
Zarrar69224152018-11-13 11:11:32 +0530381
Faris Ansari1fe891b2021-04-23 08:04:00 +0530382 scan_barcode() {
rohitwaghchaure13cba502023-12-13 15:08:16 +0530383 frappe.flags.dialog_set = false;
Ankush Menatc34847e2022-03-27 19:37:23 +0530384 const barcode_scanner = new erpnext.utils.BarcodeScanner({frm:this.frm});
Ankush Menat2d154132022-03-27 19:08:15 +0530385 barcode_scanner.process_scan();
marination596cf392021-09-27 15:06:46 +0530386 }
387
Rohit Waghchauree5b19e32022-11-02 20:38:07 +0530388 validate_has_items () {
389 let table = this.frm.doc.items;
390 this.frm.has_items = (table && table.length
391 && table[0].qty && table[0].item_code);
392 }
393
Faris Ansari1fe891b2021-04-23 08:04:00 +0530394 apply_default_taxes() {
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530395 var me = this;
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530396 var taxes_and_charges_field = frappe.meta.get_docfield(me.frm.doc.doctype, "taxes_and_charges",
397 me.frm.doc.name);
398
SDLyu68672af2020-09-18 13:58:23 +0800399 if (!this.frm.doc.taxes_and_charges && this.frm.doc.taxes && this.frm.doc.taxes.length > 0) {
rohitwaghchaure1f39feb2018-01-05 12:25:45 +0530400 return;
401 }
402
403 if (taxes_and_charges_field) {
Nabin Haitbdfb0702015-10-28 15:38:08 +0530404 return frappe.call({
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530405 method: "erpnext.controllers.accounts_controller.get_default_taxes_and_charges",
406 args: {
rohitwaghchaure505661b2017-12-11 14:52:28 +0530407 "master_doctype": taxes_and_charges_field.options,
Rushabh Mehta39154e52020-12-10 12:37:16 +0530408 "tax_template": me.frm.doc.taxes_and_charges || "",
rohitwaghchaure505661b2017-12-11 14:52:28 +0530409 "company": me.frm.doc.company
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530410 },
Rushabh Mehta39154e52020-12-10 12:37:16 +0530411 debounce: 2000,
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530412 callback: function(r) {
Nabin Haita2426fc2018-01-15 17:45:46 +0530413 if(!r.exc && r.message) {
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530414 frappe.run_serially([
415 () => {
416 // directly set in doc, so as not to call triggers
rohitwaghchaure1bc47fa2017-12-16 10:49:58 +0530417 if(r.message.taxes_and_charges) {
418 me.frm.doc.taxes_and_charges = r.message.taxes_and_charges;
419 }
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530420
421 // set taxes table
rohitwaghchaure1bc47fa2017-12-16 10:49:58 +0530422 if(r.message.taxes) {
423 me.frm.set_value("taxes", r.message.taxes);
424 }
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530425 },
Saif3c9155e2018-10-18 17:27:56 +0500426 () => me.set_dynamic_labels(),
Rushabh Mehta98aa5812017-11-14 09:32:32 +0530427 () => me.calculate_taxes_and_totals()
428 ]);
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530429 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530430 }
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530431 });
432 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530433 }
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530434
Faris Ansari1fe891b2021-04-23 08:04:00 +0530435 setup_sms() {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530436 var me = this;
Faris Ansaria5d975d2019-07-04 17:47:28 +0530437 let blacklist = ['Purchase Invoice', 'BOM'];
Nabin Hait7132bd32016-04-13 15:19:37 +0530438 if(this.frm.doc.docstatus===1 && !in_list(["Lost", "Stopped", "Closed"], this.frm.doc.status)
Faris Ansaria5d975d2019-07-04 17:47:28 +0530439 && !blacklist.includes(this.frm.doctype)) {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530440 this.frm.page.add_menu_item(__('Send SMS'), function() { me.send_sms(); });
441 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530442 }
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530443
Faris Ansari1fe891b2021-04-23 08:04:00 +0530444 send_sms() {
Faris Ansariab74ca72017-05-30 12:54:42 +0530445 var sms_man = new erpnext.SMSManager(this.frm.doc);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530446 }
Anand Doshi50d7e8c2015-01-06 17:14:13 +0530447
Faris Ansari1fe891b2021-04-23 08:04:00 +0530448 item_code(doc, cdt, cdn) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530449 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530450 var item = frappe.get_doc(cdt, cdn);
pratu16x75f389c92017-06-26 13:38:24 +0530451 var update_stock = 0, show_batch_dialog = 0;
rohitwaghchaure7b4a6542021-09-03 22:00:14 +0530452
453 item.weight_per_unit = 0;
454 item.weight_uom = '';
Marica235fc122022-02-22 12:53:46 +0530455 item.conversion_factor = 0;
rohitwaghchaure7b4a6542021-09-03 22:00:14 +0530456
rohitwaghchauref09e2132024-01-04 14:58:02 +0530457 if(['Sales Invoice', 'Purchase Invoice'].includes(this.frm.doc.doctype)) {
pratu16x7577e4c42017-06-23 11:39:03 +0530458 update_stock = cint(me.frm.doc.update_stock);
459 show_batch_dialog = update_stock;
pratu16x7ae450fc2017-06-26 15:31:46 +0530460
Rohit Waghchauref79f2a32023-04-04 11:50:38 +0530461 } else if((this.frm.doc.doctype === 'Purchase Receipt') ||
pratu16x7ae450fc2017-06-26 15:31:46 +0530462 this.frm.doc.doctype === 'Delivery Note') {
pratu16x789d001c2017-06-26 17:45:49 +0530463 show_batch_dialog = 1;
pratu16x7577e4c42017-06-23 11:39:03 +0530464 }
Ankush Menat530f7672022-03-31 14:37:30 +0530465 item.barcode = null;
Rohit Waghchaureab4ff982019-02-28 13:21:28 +0530466
Mohammad Hasnain69514c42020-12-09 12:10:28 +0530467
Ankush Menat3974fbb2022-06-01 16:43:56 +0530468 if(item.item_code || item.serial_no) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530469 if(!this.validate_company_and_party()) {
pratu16x7577e4c42017-06-23 11:39:03 +0530470 this.frm.fields_dict["items"].grid.grid_rows[item.idx - 1].remove();
Nabin Hait139dc7b2014-02-12 14:53:18 +0530471 } else {
Maharshi Patel96b42112022-10-18 22:26:11 +0530472 item.pricing_rules = ''
Nabin Hait139dc7b2014-02-12 14:53:18 +0530473 return this.frm.call({
474 method: "erpnext.stock.get_item_details.get_item_details",
Ankush Menat6851c502023-12-13 23:14:20 +0530475 child: item,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530476 args: {
Rohit Waghchauree5405342019-03-31 16:42:41 +0530477 doc: me.frm.doc,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530478 args: {
479 item_code: item.item_code,
480 barcode: item.barcode,
481 serial_no: item.serial_no,
marinatione05013e2020-04-06 22:13:13 +0530482 batch_no: item.batch_no,
Saif Ur Rehman2689dea2019-01-09 13:43:06 +0500483 set_warehouse: me.frm.doc.set_warehouse,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530484 warehouse: item.warehouse,
Nabin Hait34c551d2019-07-03 10:34:31 +0530485 customer: me.frm.doc.customer || me.frm.doc.party_name,
486 quotation_to: me.frm.doc.quotation_to,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530487 supplier: me.frm.doc.supplier,
488 currency: me.frm.doc.currency,
pratu16x7577e4c42017-06-23 11:39:03 +0530489 update_stock: update_stock,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530490 conversion_rate: me.frm.doc.conversion_rate,
Faris Ansariab74ca72017-05-30 12:54:42 +0530491 price_list: me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530492 price_list_currency: me.frm.doc.price_list_currency,
493 plc_conversion_rate: me.frm.doc.plc_conversion_rate,
494 company: me.frm.doc.company,
495 order_type: me.frm.doc.order_type,
496 is_pos: cint(me.frm.doc.is_pos),
Saqib1f591ab2021-01-05 13:53:51 +0530497 is_return: cint(me.frm.doc.is_return),
Nabin Hait139dc7b2014-02-12 14:53:18 +0530498 is_subcontracted: me.frm.doc.is_subcontracted,
Nabin Hait444f9562014-06-20 15:59:49 +0530499 ignore_pricing_rule: me.frm.doc.ignore_pricing_rule,
Anand Doshiafe85bd2016-01-21 21:04:16 +0530500 doctype: me.frm.doc.doctype,
501 name: me.frm.doc.name,
Neil Trini Lasrado6e343e22016-03-09 17:02:59 +0530502 project: item.project || me.frm.doc.project,
mbauskarba412422017-04-19 12:35:51 +0530503 qty: item.qty || 1,
Deepesh Garg8a7e2832021-06-04 22:53:26 +0530504 net_rate: item.rate,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530505 stock_qty: item.stock_qty,
rohitwaghchaurec037dc72017-11-28 16:11:15 +0530506 conversion_factor: item.conversion_factor,
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530507 weight_per_unit: item.weight_per_unit,
Ankush Menat3974fbb2022-06-01 16:43:56 +0530508 uom: item.uom,
Vishal Dhayaguded42242d2017-11-29 16:09:59 +0530509 weight_uom: item.weight_uom,
Rohit Waghchaure3cf24362019-06-02 16:03:05 +0530510 manufacturer: item.manufacturer,
Nabin Hait158e7dc2019-01-04 11:04:37 +0530511 stock_uom: item.stock_uom,
Saqibcdc99cd2021-05-03 11:54:55 +0530512 pos_profile: cint(me.frm.doc.is_pos) ? me.frm.doc.pos_profile : '',
Saif Ur Rehman67786682018-12-27 02:11:07 +0500513 cost_center: item.cost_center,
514 tax_category: me.frm.doc.tax_category,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530515 item_tax_template: item.item_tax_template,
Smit Vorab206b052023-11-23 15:10:47 +0530516 child_doctype: item.doctype,
s-aga-r6d89b2f2022-06-18 15:46:59 +0530517 child_docname: item.name,
518 is_old_subcontracting_flow: me.frm.doc.is_old_subcontracting_flow,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530519 }
520 },
Anand Doshi13945092014-09-21 19:45:49 +0530521
Nabin Hait139dc7b2014-02-12 14:53:18 +0530522 callback: function(r) {
523 if(!r.exc) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530524 frappe.run_serially([
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500525 () => {
526 var d = locals[cdt][cdn];
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +0500527 me.add_taxes_from_item_tax_template(d.item_tax_rate);
HarryPaulo49af5ba2023-02-23 18:11:09 -0300528 if (d.free_item_data && d.free_item_data.length > 0) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +0530529 me.apply_product_discount(d);
Rohit Waghchaure2ae79b82019-12-18 17:48:39 +0530530 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500531 },
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530532 () => {
533 // for internal customer instead of pricing rule directly apply valuation rate on item
Rohit Waghchaure2931c652023-05-30 08:34:12 +0530534 if ((me.frm.doc.is_internal_customer || me.frm.doc.is_internal_supplier) && me.frm.doc.represents_company === me.frm.doc.company) {
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530535 me.get_incoming_rate(item, me.frm.posting_date, me.frm.posting_time,
536 me.frm.doc.doctype, me.frm.doc.company);
537 } else {
538 me.frm.script_manager.trigger("price_list_rate", cdt, cdn);
539 }
540 },
541 () => {
542 if (me.frm.doc.is_internal_customer || me.frm.doc.is_internal_supplier) {
543 me.calculate_taxes_and_totals();
544 }
545 },
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530546 () => me.toggle_conversion_factor(item),
547 () => {
rohitwaghchauref09e2132024-01-04 14:58:02 +0530548 if (show_batch_dialog && !frappe.flags.trigger_from_barcode_scanner)
Saqibfaea8542020-03-26 13:18:57 +0530549 return frappe.db.get_value("Item", item.item_code, ["has_batch_no", "has_serial_no"])
550 .then((r) => {
Rohit Waghchaureafe8e882020-06-10 17:55:24 +0530551 if (r.message &&
Deepesh Garg16bcd012021-01-28 12:09:35 +0530552 (r.message.has_batch_no || r.message.has_serial_no)) {
Saqibfaea8542020-03-26 13:18:57 +0530553 frappe.flags.hide_serial_batch_dialog = false;
Rohit Waghchaure39da9292023-04-07 11:21:01 +0530554 } else {
555 show_batch_dialog = false;
Saqibfaea8542020-03-26 13:18:57 +0530556 }
557 });
558 },
559 () => {
Deepesh Garg16bcd012021-01-28 12:09:35 +0530560 // check if batch serial selector is disabled or not
561 if (show_batch_dialog && !frappe.flags.hide_serial_batch_dialog)
562 return frappe.db.get_single_value('Stock Settings', 'disable_serial_no_and_batch_selector')
563 .then((value) => {
564 if (value) {
565 frappe.flags.hide_serial_batch_dialog = true;
566 }
567 });
568 },
569 () => {
Rohit Waghchauref79f2a32023-04-04 11:50:38 +0530570 if(show_batch_dialog && !frappe.flags.hide_serial_batch_dialog && !frappe.flags.dialog_set) {
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530571 var d = locals[cdt][cdn];
572 $.each(r.message, function(k, v) {
573 if(!d[k]) d[k] = v;
574 });
Rohit Waghchaure6ab63032017-09-01 15:28:44 +0530575
Saqib14cdb242020-04-16 16:21:35 +0530576 if (d.has_batch_no && d.has_serial_no) {
577 d.batch_no = undefined;
578 }
579
Rohit Waghchauref79f2a32023-04-04 11:50:38 +0530580 frappe.flags.dialog_set = true;
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530581 erpnext.show_serial_batch_selector(me.frm, d, (item) => {
582 me.frm.script_manager.trigger('qty', item.doctype, item.name);
Saqibfaea8542020-03-26 13:18:57 +0530583 if (!me.frm.doc.set_warehouse)
584 me.frm.script_manager.trigger('warehouse', item.doctype, item.name);
Alan72c081f2021-09-28 12:56:26 +0530585 me.apply_price_list(item, true);
Saqibfaea8542020-03-26 13:18:57 +0530586 }, undefined, !frappe.flags.hide_serial_batch_dialog);
Rohit Waghchauref79f2a32023-04-04 11:50:38 +0530587 } else {
588 frappe.flags.dialog_set = false;
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530589 }
590 },
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530591 () => me.conversion_factor(doc, cdt, cdn, true),
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +0530592 () => me.remove_pricing_rule(item),
593 () => {
594 if (item.apply_rule_on_other_items) {
595 let key = item.name;
596 me.apply_rule_on_other_items({key: item});
597 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +0530598 },
599 () => {
600 var company_currency = me.get_company_currency();
601 me.update_item_grid_labels(company_currency);
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +0530602 }
Vishal Dhayaguded3770182017-12-14 18:06:02 +0530603 ]);
Nabin Hait139dc7b2014-02-12 14:53:18 +0530604 }
605 }
606 });
607 }
608 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530609 }
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530610
Faris Ansari1fe891b2021-04-23 08:04:00 +0530611 price_list_rate(doc, cdt, cdn) {
Anupam Kumared42afc2021-03-15 11:11:28 +0530612 var item = frappe.get_doc(cdt, cdn);
613 frappe.model.round_floats_in(item, ["price_list_rate", "discount_percentage"]);
614
Deepesh Garg2d0208b2021-12-22 12:01:39 +0530615 // check if child doctype is Sales Order Item/Quotation Item and calculate the rate
Anupam Kumared42afc2021-03-15 11:11:28 +0530616 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)
617 this.apply_pricing_rule_on_item(item);
618 else
619 item.rate = flt(item.price_list_rate * (1 - item.discount_percentage / 100.0),
620 precision("rate", item));
621
622 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +0530623 }
Anupam Kumared42afc2021-03-15 11:11:28 +0530624
Faris Ansari1fe891b2021-04-23 08:04:00 +0530625 margin_rate_or_amount(doc, cdt, cdn) {
Anupam Kumared42afc2021-03-15 11:11:28 +0530626 // calculated the revised total margin and rate on margin rate changes
627 let item = frappe.get_doc(cdt, cdn);
628 this.apply_pricing_rule_on_item(item);
629 this.calculate_taxes_and_totals();
630 cur_frm.refresh_fields();
Faris Ansari1fe891b2021-04-23 08:04:00 +0530631 }
Anupam Kumared42afc2021-03-15 11:11:28 +0530632
Faris Ansari1fe891b2021-04-23 08:04:00 +0530633 margin_type(doc, cdt, cdn) {
Anupam Kumared42afc2021-03-15 11:11:28 +0530634 // calculate the revised total margin and rate on margin type changes
635 let item = frappe.get_doc(cdt, cdn);
636 if (!item.margin_type) {
637 frappe.model.set_value(cdt, cdn, "margin_rate_or_amount", 0);
638 } else {
639 this.apply_pricing_rule_on_item(item, doc, cdt, cdn);
640 this.calculate_taxes_and_totals();
641 cur_frm.refresh_fields();
642 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530643 }
Anupam Kumared42afc2021-03-15 11:11:28 +0530644
Faris Ansari1fe891b2021-04-23 08:04:00 +0530645 get_incoming_rate(item, posting_date, posting_time, voucher_type, company) {
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530646
647 let item_args = {
648 'item_code': item.item_code,
649 'warehouse': in_list('Purchase Receipt', 'Purchase Invoice') ? item.from_warehouse : item.warehouse,
650 'posting_date': posting_date,
651 'posting_time': posting_time,
652 'qty': item.qty * item.conversion_factor,
653 'serial_no': item.serial_no,
Ankush Menat342d09a2022-02-19 14:28:51 +0530654 'batch_no': item.batch_no,
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530655 'voucher_type': voucher_type,
656 'company': company,
657 'allow_zero_valuation_rate': item.allow_zero_valuation_rate
658 }
659
660 frappe.call({
661 method: 'erpnext.stock.utils.get_incoming_rate',
662 args: {
663 args: item_args
664 },
665 callback: function(r) {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530666 frappe.model.set_value(item.doctype, item.name, 'rate', r.message * item.conversion_factor);
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530667 }
668 });
Faris Ansari1fe891b2021-04-23 08:04:00 +0530669 }
Deepesh Garg15ff6a52020-02-18 12:28:41 +0530670
Faris Ansari1fe891b2021-04-23 08:04:00 +0530671 add_taxes_from_item_tax_template(item_tax_map) {
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500672 let me = this;
673
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +0500674 if(item_tax_map && cint(frappe.defaults.get_default("add_taxes_from_item_tax_template"))) {
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500675 if(typeof (item_tax_map) == "string") {
676 item_tax_map = JSON.parse(item_tax_map);
677 }
678
679 $.each(item_tax_map, function(tax, rate) {
680 let found = (me.frm.doc.taxes || []).find(d => d.account_head === tax);
681 if(!found) {
682 let child = frappe.model.add_child(me.frm.doc, "taxes");
683 child.charge_type = "On Net Total";
684 child.account_head = tax;
Saqib7d9dd3c2020-10-28 17:07:10 +0530685 child.rate = 0;
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500686 }
687 });
688 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530689 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +0500690
Faris Ansari1fe891b2021-04-23 08:04:00 +0530691 serial_no(doc, cdt, cdn) {
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530692 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530693 var item = frappe.get_doc(cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530694
Rohit Waghchaure6bbc8ec2021-06-08 10:36:39 +0530695 if (item && item.doctype === 'Purchase Receipt Item Supplied') {
696 return;
697 }
698
deepeshgarg00749cca7a2019-01-25 16:41:01 +0530699 if (item && item.serial_no) {
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530700 if (!item.item_code) {
Rushabh Mehtab66edd12017-03-30 21:21:56 +0530701 this.frm.trigger("item_code", cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530702 }
703 else {
marinationeecfc4c2021-07-22 13:23:54 +0530704 // Replace all occurences of comma with line feed
Jannat Patel12f09232021-03-23 21:09:49 +0530705 item.serial_no = item.serial_no.replace(/,/g, '\n');
marinatione05013e2020-04-06 22:13:13 +0530706 item.conversion_factor = item.conversion_factor || 1;
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530707 refresh_field("serial_no", item.name, item.parentfield);
Jannat Pateld9fa79d2021-04-08 16:04:57 +0530708 if (!doc.is_return && cint(frappe.user_defaults.set_qty_in_transactions_based_on_serial_no_input)) {
709 setTimeout(() => {
710 me.update_qty(cdt, cdn);
711 }, 10000);
Nabin Haitb7c0c552015-08-04 12:18:12 +0530712 }
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530713 }
714 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530715 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530716
Rohit Waghchauree6143ab2023-03-13 14:51:43 +0530717 on_submit() {
rohitwaghchaurea117ef32023-12-28 11:14:27 +0530718 if (in_list(["Purchase Invoice", "Sales Invoice"], this.frm.doc.doctype)
719 && !this.frm.doc.update_stock) {
720 return;
721 }
722
rohitwaghchaure6a7bdef2023-09-04 14:11:42 +0530723 this.refresh_serial_batch_bundle_field();
724 }
725
726 refresh_serial_batch_bundle_field() {
727 frappe.route_hooks.after_submit = (frm_obj) => {
728 frm_obj.reload_doc();
729 }
Rohit Waghchauree6143ab2023-03-13 14:51:43 +0530730 }
731
Faris Ansari69eb6d42021-05-07 15:21:33 +0530732 update_qty(cdt, cdn) {
Jannat Pateld9fa79d2021-04-08 16:04:57 +0530733 var valid_serial_nos = [];
734 var serialnos = [];
735 var item = frappe.get_doc(cdt, cdn);
736 serialnos = item.serial_no.split("\n");
737 for (var i = 0; i < serialnos.length; i++) {
738 if (serialnos[i] != "") {
739 valid_serial_nos.push(serialnos[i]);
740 }
741 }
742 frappe.model.set_value(item.doctype, item.name,
743 "qty", valid_serial_nos.length / item.conversion_factor);
744 frappe.model.set_value(item.doctype, item.name, "stock_qty", valid_serial_nos.length);
Faris Ansari69eb6d42021-05-07 15:21:33 +0530745 }
Jannat Pateld9fa79d2021-04-08 16:04:57 +0530746
Faris Ansari1fe891b2021-04-23 08:04:00 +0530747 validate() {
Anand Doshi652bc072014-04-16 15:21:46 +0530748 this.calculate_taxes_and_totals(false);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530749 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530750
Faris Ansari1fe891b2021-04-23 08:04:00 +0530751 update_stock() {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530752 this.frm.trigger('set_default_internal_warehouse');
Faris Ansari1fe891b2021-04-23 08:04:00 +0530753 }
Deepesh Gargb4be2922021-01-28 13:09:56 +0530754
Faris Ansari1fe891b2021-04-23 08:04:00 +0530755 set_default_internal_warehouse() {
Deepesh Gargb4be2922021-01-28 13:09:56 +0530756 let me = this;
757 if ((this.frm.doc.doctype === 'Sales Invoice' && me.frm.doc.update_stock)
758 || this.frm.doc.doctype == 'Delivery Note') {
759 if (this.frm.doc.is_internal_customer && this.frm.doc.company === this.frm.doc.represents_company) {
760 frappe.db.get_value('Company', this.frm.doc.company, 'default_in_transit_warehouse', function(value) {
761 me.frm.set_value('set_target_warehouse', value.default_in_transit_warehouse);
762 });
763 }
764 }
765
766 if ((this.frm.doc.doctype === 'Purchase Invoice' && me.frm.doc.update_stock)
767 || this.frm.doc.doctype == 'Purchase Receipt') {
768 if (this.frm.doc.is_internal_supplier && this.frm.doc.company === this.frm.doc.represents_company) {
769 frappe.db.get_value('Company', this.frm.doc.company, 'default_in_transit_warehouse', function(value) {
770 me.frm.set_value('set_from_warehouse', value.default_in_transit_warehouse);
771 });
772 }
773 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530774 }
Deepesh Gargb4be2922021-01-28 13:09:56 +0530775
Faris Ansari1fe891b2021-04-23 08:04:00 +0530776 company() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530777 var me = this;
Nabin Haita731ad42016-02-04 17:21:28 +0530778 var set_pricing = function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530779 if(me.frm.doc.company && me.frm.fields_dict.currency) {
780 var company_currency = me.get_company_currency();
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530781 var company_doc = frappe.get_doc(":Company", me.frm.doc.company);
tundebabzy5510d072017-09-29 10:51:59 +0100782
Nabin Hait1f10d692017-10-02 13:20:51 +0530783 if (!me.frm.doc.currency) {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530784 me.frm.set_value("currency", company_currency);
785 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530786
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530787 if (me.frm.doc.currency == company_currency) {
788 me.frm.set_value("conversion_rate", 1.0);
789 }
790 if (me.frm.doc.price_list_currency == company_currency) {
791 me.frm.set_value('plc_conversion_rate', 1.0);
792 }
ruthra kumar9f27ac12024-01-10 11:34:20 +0530793 if (company_doc && company_doc.default_letter_head) {
Rushabh Mehtac1857342015-05-27 12:29:57 +0530794 if(me.frm.fields_dict.letter_head) {
795 me.frm.set_value("letter_head", company_doc.default_letter_head);
796 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530797 }
karthikeyan57fc60212019-07-04 22:46:16 +0530798 let selling_doctypes_for_tc = ["Sales Invoice", "Quotation", "Sales Order", "Delivery Note"];
799 if (company_doc.default_selling_terms && frappe.meta.has_field(me.frm.doc.doctype, "tc_name") &&
800 selling_doctypes_for_tc.indexOf(me.frm.doc.doctype) != -1) {
801 me.frm.set_value("tc_name", company_doc.default_selling_terms);
802 }
803 let buying_doctypes_for_tc = ["Request for Quotation", "Supplier Quotation", "Purchase Order",
804 "Material Request", "Purchase Receipt"];
805 // Purchase Invoice is excluded as per issue #3345
806 if (company_doc.default_buying_terms && frappe.meta.has_field(me.frm.doc.doctype, "tc_name") &&
807 buying_doctypes_for_tc.indexOf(me.frm.doc.doctype) != -1) {
808 me.frm.set_value("tc_name", company_doc.default_buying_terms);
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530809 }
Akhilesh Darjee1797cfe2013-10-11 13:34:10 +0530810
rohitwaghchaure505661b2017-12-11 14:52:28 +0530811 frappe.run_serially([
812 () => me.frm.script_manager.trigger("currency"),
Deepesh Garg9ab18b52021-07-21 23:15:15 +0530813 () => me.update_item_tax_map(),
rohitwaghchaure505661b2017-12-11 14:52:28 +0530814 () => me.apply_default_taxes(),
Deepesh Garg9ab18b52021-07-21 23:15:15 +0530815 () => me.apply_pricing_rule()
rohitwaghchaure505661b2017-12-11 14:52:28 +0530816 ]);
Nabin Haitdd38a262014-12-26 13:15:21 +0530817 }
Anand Doshi3543f302013-05-24 19:25:01 +0530818 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530819
Nabin Haita731ad42016-02-04 17:21:28 +0530820 var set_party_account = function(set_pricing) {
821 if (in_list(["Sales Invoice", "Purchase Invoice"], me.frm.doc.doctype)) {
822 if(me.frm.doc.doctype=="Sales Invoice") {
823 var party_type = "Customer";
824 var party_account_field = 'debit_to';
825 } else {
826 var party_type = "Supplier";
827 var party_account_field = 'credit_to';
828 }
Anand Doshi39a28912016-02-15 11:42:18 +0530829
Nabin Haitef864402016-02-10 14:47:25 +0530830 var party = me.frm.doc[frappe.model.scrub(party_type)];
Faris Ansarif7717b92018-02-08 11:09:54 +0530831 if(party && me.frm.doc.company) {
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530832 return frappe.call({
833 method: "erpnext.accounts.party.get_party_account",
834 args: {
835 company: me.frm.doc.company,
836 party_type: party_type,
Nabin Haitef864402016-02-10 14:47:25 +0530837 party: party
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530838 },
839 callback: function(r) {
840 if(!r.exc && r.message) {
841 me.frm.set_value(party_account_field, r.message);
842 set_pricing();
843 }
Nabin Haita731ad42016-02-04 17:21:28 +0530844 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530845 });
Nabin Haitef864402016-02-10 14:47:25 +0530846 } else {
847 set_pricing();
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530848 }
Nabin Haita731ad42016-02-04 17:21:28 +0530849 } else {
850 set_pricing();
851 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530852
Nabin Haita731ad42016-02-04 17:21:28 +0530853 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530854
Rushabh Mehta5dfe20c2016-04-26 12:59:08 +0530855 if (frappe.meta.get_docfield(this.frm.doctype, "shipping_address") &&
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530856 in_list(['Purchase Order', 'Purchase Receipt', 'Purchase Invoice'], this.frm.doctype)) {
Deepesh Gargfd467e62021-08-30 17:53:59 +0530857 erpnext.utils.get_shipping_address(this.frm, function() {
Faris Ansariab74ca72017-05-30 12:54:42 +0530858 set_party_account(set_pricing);
Deepesh Gargb4be2922021-01-28 13:09:56 +0530859 });
Deepesh Gargaf1f46f2020-08-07 19:44:20 +0530860
Faris Ansariab74ca72017-05-30 12:54:42 +0530861 } else {
Rohit Waghchaureb2e7a1f2016-04-11 12:10:20 +0530862 set_party_account(set_pricing);
863 }
Rushabh Mehta45ca8a42015-04-28 16:02:09 +0530864
865 if(this.frm.doc.company) {
866 erpnext.last_selected_company = this.frm.doc.company;
867 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530868 }
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530869
Faris Ansari1fe891b2021-04-23 08:04:00 +0530870 transaction_date() {
Anand Doshi87da6622015-10-19 14:59:32 +0530871 if (this.frm.doc.transaction_date) {
872 this.frm.transaction_date = this.frm.doc.transaction_date;
Nabin Hait288a18e2016-12-08 15:36:23 +0530873 frappe.ui.form.trigger(this.frm.doc.doctype, "currency");
Anand Doshi87da6622015-10-19 14:59:32 +0530874 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530875 }
Neil Trini Lasrado78fa6952014-10-03 17:43:02 +0530876
Faris Ansari1fe891b2021-04-23 08:04:00 +0530877 posting_date() {
Nabin Hait40e92b62015-07-09 17:12:23 +0530878 var me = this;
879 if (this.frm.doc.posting_date) {
Anand Doshi87da6622015-10-19 14:59:32 +0530880 this.frm.posting_date = this.frm.doc.posting_date;
881
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530882 if ((this.frm.doc.doctype == "Sales Invoice" && this.frm.doc.customer) ||
Nabin Hait40e92b62015-07-09 17:12:23 +0530883 (this.frm.doc.doctype == "Purchase Invoice" && this.frm.doc.supplier)) {
884 return frappe.call({
885 method: "erpnext.accounts.party.get_due_date",
886 args: {
887 "posting_date": me.frm.doc.posting_date,
888 "party_type": me.frm.doc.doctype == "Sales Invoice" ? "Customer" : "Supplier",
Shreya Shah3a9eec22018-02-16 13:05:21 +0530889 "bill_date": me.frm.doc.bill_date,
Nabin Hait40e92b62015-07-09 17:12:23 +0530890 "party": me.frm.doc.doctype == "Sales Invoice" ? me.frm.doc.customer : me.frm.doc.supplier,
891 "company": me.frm.doc.company
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530892 },
Nabin Hait40e92b62015-07-09 17:12:23 +0530893 callback: function(r, rt) {
894 if(r.message) {
Nabin Haitcfa9d1a2018-01-29 16:07:21 +0530895 me.frm.doc.due_date = r.message;
896 refresh_field("due_date");
Nabin Hait87d70272016-12-08 14:43:11 +0530897 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
tundebabzy650a1ee2018-01-02 07:32:30 +0100898 me.recalculate_terms();
Nabin Hait40e92b62015-07-09 17:12:23 +0530899 }
Nabin Hait40e92b62015-07-09 17:12:23 +0530900 }
901 })
Nabin Hait87d70272016-12-08 14:43:11 +0530902 } else {
903 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
Nabin Hait40e92b62015-07-09 17:12:23 +0530904 }
905 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530906 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530907
Faris Ansari1fe891b2021-04-23 08:04:00 +0530908 due_date() {
tundebabzyda221672018-01-09 06:28:44 +0100909 // due_date is to be changed, payment terms template and/or payment schedule must
910 // be removed as due_date is automatically changed based on payment terms
rohitwaghchaure52beb772018-01-29 17:40:44 +0530911 if (this.frm.doc.due_date && !this.frm.updating_party_details && !this.frm.doc.is_pos) {
Saurabh3959aeb2018-01-23 15:40:29 +0530912 if (this.frm.doc.payment_terms_template ||
913 (this.frm.doc.payment_schedule && this.frm.doc.payment_schedule.length)) {
tundebabzyda221672018-01-09 06:28:44 +0100914 var message1 = "";
915 var message2 = "";
Ankush Menatff96bdf2021-05-25 19:54:40 +0530916 var final_message = __("Please clear the") + " ";
tundebabzyda221672018-01-09 06:28:44 +0100917
918 if (this.frm.doc.payment_terms_template) {
Ankush Menatff96bdf2021-05-25 19:54:40 +0530919 message1 = __("selected Payment Terms Template");
tundebabzyda221672018-01-09 06:28:44 +0100920 final_message = final_message + message1;
921 }
922
Nabin Hait2bfa1802018-01-17 14:39:05 +0530923 if ((this.frm.doc.payment_schedule || []).length) {
Ankush Menatff96bdf2021-05-25 19:54:40 +0530924 message2 = __("Payment Schedule Table");
tundebabzyda221672018-01-09 06:28:44 +0100925 if (message1.length !== 0) message2 = " and " + message2;
926 final_message = final_message + message2;
927 }
tundebabzyda221672018-01-09 06:28:44 +0100928 frappe.msgprint(final_message);
929 }
Nabin Haitcfa9d1a2018-01-29 16:07:21 +0530930 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530931 }
tundebabzyda221672018-01-09 06:28:44 +0100932
Faris Ansari1fe891b2021-04-23 08:04:00 +0530933 bill_date() {
Shreya Shah3a9eec22018-02-16 13:05:21 +0530934 this.posting_date();
Faris Ansari1fe891b2021-04-23 08:04:00 +0530935 }
Shreya Shah3a9eec22018-02-16 13:05:21 +0530936
Faris Ansari1fe891b2021-04-23 08:04:00 +0530937 recalculate_terms() {
tundebabzy650a1ee2018-01-02 07:32:30 +0100938 const doc = this.frm.doc;
tundebabzy650a1ee2018-01-02 07:32:30 +0100939 if (doc.payment_terms_template) {
940 this.payment_terms_template();
941 } else if (doc.payment_schedule) {
942 const me = this;
tundebabzy650a1ee2018-01-02 07:32:30 +0100943 doc.payment_schedule.forEach(
944 function(term) {
945 if (term.payment_term) {
946 me.payment_term(doc, term.doctype, term.name);
947 } else {
948 frappe.model.set_value(
949 term.doctype, term.name, 'due_date',
950 doc.posting_date || doc.transaction_date
951 );
952 }
953 }
954 );
955 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530956 }
tundebabzy650a1ee2018-01-02 07:32:30 +0100957
Faris Ansari1fe891b2021-04-23 08:04:00 +0530958 get_company_currency() {
Anand Doshi3543f302013-05-24 19:25:01 +0530959 return erpnext.get_currency(this.frm.doc.company);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530960 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530961
Faris Ansari1fe891b2021-04-23 08:04:00 +0530962 contact_person() {
Neil Trini Lasrado09a66c42015-07-07 16:41:37 +0530963 erpnext.utils.get_contact_details(this.frm);
Faris Ansari1fe891b2021-04-23 08:04:00 +0530964 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530965
Faris Ansari1fe891b2021-04-23 08:04:00 +0530966 currency() {
Deepesh Garg54d6cf12022-05-13 13:07:23 +0530967 // The transaction date be either transaction_date (from orders) or posting_date (from invoices)
968 let transaction_date = this.frm.doc.transaction_date || this.frm.doc.posting_date;
969
970 let me = this;
Anand Doshi61a2f682013-06-21 17:55:31 +0530971 this.set_dynamic_labels();
Deepesh Garg54d6cf12022-05-13 13:07:23 +0530972 let company_currency = this.get_company_currency();
Sagar Vorab6a75492023-12-02 20:06:19 +0530973 // Added `load_after_mapping` to determine if document is loading after mapping from another doc
Rushabh Mehta76b13412016-07-18 14:30:18 +0530974 if(this.frm.doc.currency && this.frm.doc.currency !== company_currency
Sagar Vorab6a75492023-12-02 20:06:19 +0530975 && !this.frm.doc.__onload?.load_after_mapping) {
Shreya0db85062018-05-15 11:25:46 +0530976
Nabin Hait288a18e2016-12-08 15:36:23 +0530977 this.get_exchange_rate(transaction_date, this.frm.doc.currency, company_currency,
Anand Doshi61a2f682013-06-21 17:55:31 +0530978 function(exchange_rate) {
Nabin Haitaafd64d2019-05-27 17:15:47 +0530979 if(exchange_rate != me.frm.doc.conversion_rate) {
980 me.set_margin_amount_based_on_currency(exchange_rate);
981 me.set_actual_charges_based_on_currency(exchange_rate);
982 me.frm.set_value("conversion_rate", exchange_rate);
983 }
Anand Doshi61a2f682013-06-21 17:55:31 +0530984 });
985 } else {
Deepesh Garg54d6cf12022-05-13 13:07:23 +0530986 // company currency and doc currency is same
987 // this will prevent unnecessary conversion rate triggers
Deepesh Garg2a10f092022-05-27 12:12:34 +0530988 if(this.frm.doc.currency === this.get_company_currency()) {
989 this.frm.set_value("conversion_rate", 1.0);
990 } else {
991 this.conversion_rate();
992 }
Anand Doshi61a2f682013-06-21 17:55:31 +0530993 }
Faris Ansari1fe891b2021-04-23 08:04:00 +0530994 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530995
Faris Ansari1fe891b2021-04-23 08:04:00 +0530996 conversion_rate() {
tundebabzyab5b0302017-09-21 10:20:39 +0100997 const me = this.frm;
Anand Doshi535d8332013-07-19 13:51:07 +0530998 if(this.frm.doc.currency === this.get_company_currency()) {
999 this.frm.set_value("conversion_rate", 1.0);
Akhilesh Darjeeacf65a72013-10-17 13:04:26 +05301000 }
1001 if(this.frm.doc.currency === this.frm.doc.price_list_currency &&
Anand Doshi61a2f682013-06-21 17:55:31 +05301002 this.frm.doc.plc_conversion_rate !== this.frm.doc.conversion_rate) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301003 this.frm.set_value("plc_conversion_rate", this.frm.doc.conversion_rate);
Anand Doshi61a2f682013-06-21 17:55:31 +05301004 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +05301005
Nabin Haita3dd72a2014-05-28 12:49:20 +05301006 if(flt(this.frm.doc.conversion_rate)>0.0) {
Sagar Vorab6a75492023-12-02 20:06:19 +05301007 if(this.frm.doc.__onload?.load_after_mapping) {
Nabin Hait444f9562014-06-20 15:59:49 +05301008 this.calculate_taxes_and_totals();
Anand Doshi51f722d2014-07-04 15:44:26 +05301009 } else if (!this.in_apply_price_list){
1010 this.apply_price_list();
Nabin Hait444f9562014-06-20 15:59:49 +05301011 }
1012
Nabin Haita3dd72a2014-05-28 12:49:20 +05301013 }
tundebabzyab5b0302017-09-21 10:20:39 +01001014 // Make read only if Accounts Settings doesn't allow stale rates
tundebabzybc7c3872017-11-28 18:10:05 +01001015 this.frm.set_df_property("conversion_rate", "read_only", erpnext.stale_rate_allowed() ? 0 : 1);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301016 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301017
Anand Baburajan11a9d412023-07-25 21:55:17 +05301018 apply_discount_on_item(doc, cdt, cdn, field) {
1019 var item = frappe.get_doc(cdt, cdn);
1020 if(!item.price_list_rate) {
1021 item[field] = 0.0;
1022 } else {
1023 this.price_list_rate(doc, cdt, cdn);
1024 }
1025 this.set_gross_profit(item);
1026 }
1027
Faris Ansari1fe891b2021-04-23 08:04:00 +05301028 shipping_rule() {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301029 var me = this;
marination0c722492020-06-03 14:32:07 +05301030 if(this.frm.doc.shipping_rule) {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301031 return this.frm.call({
1032 doc: this.frm.doc,
1033 method: "apply_shipping_rule",
Deepesh Garg485e6b62022-03-27 13:02:31 +05301034 callback: function(r) {
1035 me._calculate_taxes_and_totals();
1036 }
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301037 }).fail(() => this.frm.set_value('shipping_rule', ''));
1038 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301039 }
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301040
Faris Ansari1fe891b2021-04-23 08:04:00 +05301041 set_margin_amount_based_on_currency(exchange_rate) {
Anupam Kumared42afc2021-03-15 11:11:28 +05301042 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 +05301043 var me = this;
1044 $.each(this.frm.doc.items || [], function(i, d) {
1045 if(d.margin_type == "Amount") {
1046 frappe.model.set_value(d.doctype, d.name, "margin_rate_or_amount",
1047 flt(d.margin_rate_or_amount) / flt(exchange_rate));
1048 }
1049 });
1050 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301051 }
Nabin Haitaafd64d2019-05-27 17:15:47 +05301052
Faris Ansari1fe891b2021-04-23 08:04:00 +05301053 set_actual_charges_based_on_currency(exchange_rate) {
Nabin Haita9c9b692017-08-31 19:40:09 +05301054 var me = this;
1055 $.each(this.frm.doc.taxes || [], function(i, d) {
1056 if(d.charge_type == "Actual") {
1057 frappe.model.set_value(d.doctype, d.name, "tax_amount",
Saqib48896612021-12-02 11:37:08 +05301058 flt(d.base_tax_amount) / flt(exchange_rate));
Nabin Haita9c9b692017-08-31 19:40:09 +05301059 }
1060 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301061 }
Nabin Haita9c9b692017-08-31 19:40:09 +05301062
Faris Ansari1fe891b2021-04-23 08:04:00 +05301063 get_exchange_rate(transaction_date, from_currency, to_currency, callback) {
Shreya3f778522018-05-15 16:59:20 +05301064 var args;
1065 if (["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"].includes(this.frm.doctype)) {
1066 args = "for_selling";
Shreya0db85062018-05-15 11:25:46 +05301067 }
Shreya3f778522018-05-15 16:59:20 +05301068 else if (["Purchase Order", "Purchase Receipt", "Purchase Invoice"].includes(this.frm.doctype)) {
1069 args = "for_buying";
1070 }
1071
Nabin Hait17179ee2017-05-06 13:23:12 +05301072 if (!transaction_date || !from_currency || !to_currency) return;
Nabin Haitbdfb0702015-10-28 15:38:08 +05301073 return frappe.call({
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301074 method: "erpnext.setup.utils.get_exchange_rate",
1075 args: {
Nabin Hait288a18e2016-12-08 15:36:23 +05301076 transaction_date: transaction_date,
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301077 from_currency: from_currency,
Shreya0db85062018-05-15 11:25:46 +05301078 to_currency: to_currency,
1079 args: args
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301080 },
Maricae8bc9122021-04-19 11:05:21 +05301081 freeze: true,
1082 freeze_message: __("Fetching exchange rates ..."),
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +05301083 callback: function(r) {
1084 callback(flt(r.message));
1085 }
Anand Doshi61a2f682013-06-21 17:55:31 +05301086 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301087 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301088
Faris Ansari1fe891b2021-04-23 08:04:00 +05301089 price_list_currency() {
Akhilesh Darjeedb59ffb2013-09-11 13:05:24 +05301090 var me=this;
Anand Doshi3543f302013-05-24 19:25:01 +05301091 this.set_dynamic_labels();
Nabin Haitec361ea2015-05-11 18:14:45 +05301092
1093 var company_currency = this.get_company_currency();
Sagar Vorab6a75492023-12-02 20:06:19 +05301094 // Added `load_after_mapping` to determine if document is loading after mapping from another doc
Deepesh Garg2e964852022-03-25 21:49:19 +05301095 if(this.frm.doc.price_list_currency !== company_currency &&
Sagar Vorab6a75492023-12-02 20:06:19 +05301096 !this.frm.doc.__onload?.load_after_mapping) {
Chude Osiegbufbf27b52016-09-07 03:06:08 +01001097 this.get_exchange_rate(this.frm.doc.posting_date, this.frm.doc.price_list_currency, company_currency,
Nabin Haitec361ea2015-05-11 18:14:45 +05301098 function(exchange_rate) {
1099 me.frm.set_value("plc_conversion_rate", exchange_rate);
1100 });
1101 } else {
1102 this.plc_conversion_rate();
1103 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301104 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301105
Faris Ansari1fe891b2021-04-23 08:04:00 +05301106 plc_conversion_rate() {
Anand Doshi61a2f682013-06-21 17:55:31 +05301107 if(this.frm.doc.price_list_currency === this.get_company_currency()) {
1108 this.frm.set_value("plc_conversion_rate", 1.0);
Rushabh Mehtaa208c562015-08-03 13:18:54 +05301109 } else if(this.frm.doc.price_list_currency === this.frm.doc.currency
Nabin Hait1d218422015-07-17 15:19:02 +05301110 && this.frm.doc.plc_conversion_rate && cint(this.frm.doc.plc_conversion_rate) != 1 &&
Nabin Haitec361ea2015-05-11 18:14:45 +05301111 cint(this.frm.doc.plc_conversion_rate) != cint(this.frm.doc.conversion_rate)) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301112 this.frm.set_value("conversion_rate", this.frm.doc.plc_conversion_rate);
Akhilesh Darjee564c6212013-10-17 11:31:11 +05301113 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +05301114
Nabin Haitec361ea2015-05-11 18:14:45 +05301115 if(!this.in_apply_price_list) {
tundebabzy6e90f492018-02-12 10:48:57 +01001116 this.apply_price_list(null, true);
Anand Doshi61a2f682013-06-21 17:55:31 +05301117 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301118 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301119
Faris Ansari1fe891b2021-04-23 08:04:00 +05301120 uom(doc, cdt, cdn) {
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301121 var me = this;
1122 var item = frappe.get_doc(cdt, cdn);
Maharshi Patel96b42112022-10-18 22:26:11 +05301123 item.pricing_rules = ''
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301124 if(item.item_code && item.uom) {
1125 return this.frm.call({
1126 method: "erpnext.stock.get_item_details.get_conversion_factor",
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301127 args: {
1128 item_code: item.item_code,
1129 uom: item.uom
1130 },
1131 callback: function(r) {
1132 if(!r.exc) {
Saqib60212ff2020-10-26 11:17:04 +05301133 frappe.model.set_value(cdt, cdn, 'conversion_factor', r.message.conversion_factor);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301134 }
1135 }
1136 });
1137 }
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301138 me.calculate_stock_uom_rate(doc, cdt, cdn);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301139 }
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301140
Faris Ansari1fe891b2021-04-23 08:04:00 +05301141 conversion_factor(doc, cdt, cdn, dont_fetch_price_list_rate) {
marinatione1439832020-02-18 10:51:54 +05301142 if(frappe.meta.get_docfield(cdt, "stock_qty", cdn)) {
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301143 var item = frappe.get_doc(cdt, cdn);
1144 frappe.model.round_floats_in(item, ["qty", "conversion_factor"]);
1145 item.stock_qty = flt(item.qty * item.conversion_factor, precision("stock_qty", item));
1146 refresh_field("stock_qty", item.name, item.parentfield);
mbauskar287fe812017-04-10 19:15:57 +05301147 this.toggle_conversion_factor(item);
marinatione1439832020-02-18 10:51:54 +05301148
1149 if(doc.doctype != "Material Request") {
1150 item.total_weight = flt(item.stock_qty * item.weight_per_unit);
1151 refresh_field("total_weight", item.name, item.parentfield);
1152 this.calculate_net_weight();
1153 }
1154
Anupam Kumar1033cf72021-03-31 19:39:45 +05301155 // for handling customization not to fetch price list rate
1156 if(frappe.flags.dont_fetch_price_list_rate) {
1157 return
1158 }
1159
rohitwaghchauree8ccc0e2017-11-21 16:17:22 +05301160 if (!dont_fetch_price_list_rate &&
1161 frappe.meta.has_field(doc.doctype, "price_list_currency")) {
1162 this.apply_price_list(item, true);
1163 }
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301164 this.calculate_stock_uom_rate(doc, cdt, cdn);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301165 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301166 }
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301167
Ankush Menat7e40c862022-07-01 20:08:16 +05301168 is_a_mapped_document(item) {
1169 const mapped_item_field_map = {
1170 "Delivery Note Item": ["si_detail", "so_detail", "dn_detail"],
1171 "Sales Invoice Item": ["dn_detail", "so_detail", "sales_invoice_item"],
1172 "Purchase Receipt Item": ["purchase_order_item", "purchase_invoice_item", "purchase_receipt_item"],
1173 "Purchase Invoice Item": ["purchase_order_item", "pr_detail", "po_detail"],
1174 };
1175 const mappped_fields = mapped_item_field_map[item.doctype] || [];
1176
1177 return mappped_fields
1178 .map((field) => item[field])
1179 .filter(Boolean).length > 0;
1180 }
1181
Faris Ansari1fe891b2021-04-23 08:04:00 +05301182 batch_no(doc, cdt, cdn) {
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301183 let item = frappe.get_doc(cdt, cdn);
Ankush Menat7e40c862022-07-01 20:08:16 +05301184 if (!this.is_a_mapped_document(item)) {
1185 this.apply_price_list(item, true);
1186 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301187 }
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301188
Faris Ansari1fe891b2021-04-23 08:04:00 +05301189 toggle_conversion_factor(item) {
mbauskar287fe812017-04-10 19:15:57 +05301190 // toggle read only property for conversion factor field if the uom and stock uom are same
Rushabh Mehta36311022017-06-20 09:30:53 +05301191 if(this.frm.get_field('items').grid.fields_map.conversion_factor) {
1192 this.frm.fields_dict.items.grid.toggle_enable("conversion_factor",
Javier Wong24690952017-12-29 16:36:47 +08001193 ((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 +05301194 }
Vishal Dhayaguded3770182017-12-14 18:06:02 +05301195
Faris Ansari1fe891b2021-04-23 08:04:00 +05301196 }
mbauskar287fe812017-04-10 19:15:57 +05301197
Faris Ansari1fe891b2021-04-23 08:04:00 +05301198 qty(doc, cdt, cdn) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301199 let item = frappe.get_doc(cdt, cdn);
Deepesh Gargb741ae12022-12-02 17:14:06 +05301200 // item.pricing_rules = ''
1201 frappe.run_serially([
Deepesh Gargf52d7c72024-01-02 13:37:39 +05301202 () => this.remove_pricing_rule_for_item(item),
Deepesh Gargb741ae12022-12-02 17:14:06 +05301203 () => this.conversion_factor(doc, cdt, cdn, true),
Deepesh Gargf52d7c72024-01-02 13:37:39 +05301204 () => this.apply_price_list(item, true), //reapply price list before applying pricing rule
Deepesh Gargb741ae12022-12-02 17:14:06 +05301205 () => this.calculate_stock_uom_rate(doc, cdt, cdn),
1206 () => this.apply_pricing_rule(item, true)
1207 ]);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301208 }
Vishal Dhayaguded42242d2017-11-29 16:09:59 +05301209
rohitwaghchauredd4769e2023-09-20 18:09:03 +05301210 stock_qty(doc, cdt, cdn) {
1211 let item = frappe.get_doc(cdt, cdn);
1212 item.conversion_factor = 1.0;
1213 if (item.stock_qty) {
1214 item.conversion_factor = flt(item.stock_qty) / flt(item.qty);
1215 }
1216
1217 refresh_field("conversion_factor", item.name, item.parentfield);
1218 }
1219
Faris Ansari1fe891b2021-04-23 08:04:00 +05301220 calculate_stock_uom_rate(doc, cdt, cdn) {
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301221 let item = frappe.get_doc(cdt, cdn);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301222 item.stock_uom_rate = flt(item.rate)/flt(item.conversion_factor);
Anupam Kumar7e1dcf92021-02-11 20:19:30 +05301223 refresh_field("stock_uom_rate", item.name, item.parentfield);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301224 }
1225 service_stop_date(frm, cdt, cdn) {
Zarrare83ff382018-09-21 15:45:40 +05301226 var child = locals[cdt][cdn];
1227
1228 if(child.service_stop_date) {
1229 let start_date = Date.parse(child.service_start_date);
1230 let end_date = Date.parse(child.service_end_date);
1231 let stop_date = Date.parse(child.service_stop_date);
1232
1233 if(stop_date < start_date) {
1234 frappe.model.set_value(cdt, cdn, "service_stop_date", "");
1235 frappe.throw(__("Service Stop Date cannot be before Service Start Date"));
1236 } else if (stop_date > end_date) {
1237 frappe.model.set_value(cdt, cdn, "service_stop_date", "");
1238 frappe.throw(__("Service Stop Date cannot be after Service End Date"));
1239 }
1240 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301241 }
Zarrare83ff382018-09-21 15:45:40 +05301242
rohitwaghchauref09e2132024-01-04 14:58:02 +05301243 sync_bundle_data() {
1244 let doctypes = ["Sales Invoice", "Purchase Invoice", "Delivery Note", "Purchase Receipt"];
1245
1246 if (this.frm.is_new() && doctypes.includes(this.frm.doc.doctype)) {
1247 const barcode_scanner = new erpnext.utils.BarcodeScanner({frm:this.frm});
1248 barcode_scanner.sync_bundle_data();
1249 barcode_scanner.remove_item_from_localstorage();
1250 }
1251 }
1252
1253 before_save(doc) {
1254 this.sync_bundle_data();
1255 }
1256
Faris Ansari1fe891b2021-04-23 08:04:00 +05301257 service_start_date(frm, cdt, cdn) {
Zarrare83ff382018-09-21 15:45:40 +05301258 var child = locals[cdt][cdn];
1259
1260 if(child.service_start_date) {
1261 frappe.call({
1262 "method": "erpnext.stock.get_item_details.calculate_service_end_date",
1263 args: {"args": child},
1264 callback: function(r) {
1265 frappe.model.set_value(cdt, cdn, "service_end_date", r.message.service_end_date);
1266 }
1267 })
1268 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301269 }
Zarrare83ff382018-09-21 15:45:40 +05301270
Faris Ansari1fe891b2021-04-23 08:04:00 +05301271 calculate_net_weight(){
Vishal Dhayaguded3770182017-12-14 18:06:02 +05301272 /* Calculate Total Net Weight then further applied shipping rule to calculate shipping charges.*/
1273 var me = this;
1274 this.frm.doc.total_net_weight= 0.0;
1275
1276 $.each(this.frm.doc["items"] || [], function(i, item) {
1277 me.frm.doc.total_net_weight += flt(item.total_weight);
1278 });
1279 refresh_field("total_net_weight");
1280 this.shipping_rule();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301281 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301282
Faris Ansari1fe891b2021-04-23 08:04:00 +05301283 set_dynamic_labels() {
Anand Doshi61a2f682013-06-21 17:55:31 +05301284 // What TODO? should we make price list system non-mandatory?
1285 this.frm.toggle_reqd("plc_conversion_rate",
1286 !!(this.frm.doc.price_list_name && this.frm.doc.price_list_currency));
Rushabh Mehtaff938022014-04-15 18:40:00 +05301287
Saif3c9155e2018-10-18 17:27:56 +05001288 var company_currency = this.get_company_currency();
1289 this.change_form_labels(company_currency);
1290 this.change_grid_labels(company_currency);
1291 this.frm.refresh_fields();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301292 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301293
Faris Ansari1fe891b2021-04-23 08:04:00 +05301294 change_form_labels(company_currency) {
Nabin Hait613d0812015-02-23 11:58:15 +05301295 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301296
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301297 this.frm.set_currency_labels(["base_total", "base_net_total", "base_total_taxes_and_charges",
Nabin Hait613d0812015-02-23 11:58:15 +05301298 "base_discount_amount", "base_grand_total", "base_rounded_total", "base_in_words",
1299 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted", "total_amount_to_pay",
Rushabh Mehta6b537922017-03-14 16:59:11 +05301300 "base_paid_amount", "base_write_off_amount", "base_change_amount", "base_operating_cost",
Nabin Hait2e4de832017-09-19 14:53:16 +05301301 "base_raw_material_cost", "base_total_cost", "base_scrap_material_cost",
1302 "base_rounding_adjustment"], company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301303
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301304 this.frm.set_currency_labels(["total", "net_total", "total_taxes_and_charges", "discount_amount",
niralisatapara2ca0cf62022-11-02 12:19:51 +05301305 "grand_total", "taxes_and_charges_added", "taxes_and_charges_deducted","tax_withholding_net_total",
Nabin Hait2e4de832017-09-19 14:53:16 +05301306 "rounded_total", "in_words", "paid_amount", "write_off_amount", "operating_cost",
1307 "scrap_material_cost", "rounding_adjustment", "raw_material_cost",
1308 "total_cost"], this.frm.doc.currency);
Anand Doshi87da6622015-10-19 14:59:32 +05301309
Nabin Hait2e4de832017-09-19 14:53:16 +05301310 this.frm.set_currency_labels(["outstanding_amount", "total_advance"],
1311 this.frm.doc.party_account_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301312
1313 cur_frm.set_df_property("conversion_rate", "description", "1 " + this.frm.doc.currency
Nabin Hait2e4de832017-09-19 14:53:16 +05301314 + " = [?] " + company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301315
1316 if(this.frm.doc.price_list_currency && this.frm.doc.price_list_currency!=company_currency) {
Nabin Hait2e4de832017-09-19 14:53:16 +05301317 cur_frm.set_df_property("plc_conversion_rate", "description", "1 "
1318 + this.frm.doc.price_list_currency + " = [?] " + company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301319 }
1320
1321 // toggle fields
niralisatapara2ca0cf62022-11-02 12:19:51 +05301322 this.frm.toggle_display(["conversion_rate", "base_total", "base_net_total", "base_tax_withholding_net_total",
Nabin Hait2e4de832017-09-19 14:53:16 +05301323 "base_total_taxes_and_charges", "base_taxes_and_charges_added", "base_taxes_and_charges_deducted",
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301324 "base_grand_total", "base_rounded_total", "base_in_words", "base_discount_amount",
Nabin Hait2e4de832017-09-19 14:53:16 +05301325 "base_paid_amount", "base_write_off_amount", "base_operating_cost", "base_raw_material_cost",
1326 "base_total_cost", "base_scrap_material_cost", "base_rounding_adjustment"],
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301327 this.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301328
1329 this.frm.toggle_display(["plc_conversion_rate", "price_list_currency"],
1330 this.frm.doc.price_list_currency != company_currency);
1331
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301332 var show = cint(cur_frm.doc.discount_amount) ||
Nabin Hait903c42a2015-02-24 15:24:49 +05301333 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
1334
1335 if(frappe.meta.get_docfield(cur_frm.doctype, "net_total"))
1336 cur_frm.toggle_display("net_total", show);
1337
1338 if(frappe.meta.get_docfield(cur_frm.doctype, "base_net_total"))
1339 cur_frm.toggle_display("base_net_total", (show && (me.frm.doc.currency != company_currency)));
1340
Faris Ansari1fe891b2021-04-23 08:04:00 +05301341 }
Nabin Hait613d0812015-02-23 11:58:15 +05301342
Faris Ansari1fe891b2021-04-23 08:04:00 +05301343 change_grid_labels(company_currency) {
Nabin Hait613d0812015-02-23 11:58:15 +05301344 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301345
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301346 this.update_item_grid_labels(company_currency);
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301347
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301348 this.toggle_item_grid_columns(company_currency);
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301349
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301350 if (this.frm.doc.operations && this.frm.doc.operations.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301351 this.frm.set_currency_labels(["operating_cost", "hour_rate"], this.frm.doc.currency, "operations");
1352 this.frm.set_currency_labels(["base_operating_cost", "base_hour_rate"], company_currency, "operations");
1353
1354 var item_grid = this.frm.fields_dict["operations"].grid;
1355 $.each(["base_operating_cost", "base_hour_rate"], function(i, fname) {
1356 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1357 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +05301358 });
1359 }
1360
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301361 if (this.frm.doc.scrap_items && this.frm.doc.scrap_items.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301362 this.frm.set_currency_labels(["rate", "amount"], this.frm.doc.currency, "scrap_items");
1363 this.frm.set_currency_labels(["base_rate", "base_amount"], company_currency, "scrap_items");
Nabin Hait613d0812015-02-23 11:58:15 +05301364
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301365 var item_grid = this.frm.fields_dict["scrap_items"].grid;
1366 $.each(["base_rate", "base_amount"], function(i, fname) {
1367 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1368 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1369 });
1370 }
Nabin Hait613d0812015-02-23 11:58:15 +05301371
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301372 if (this.frm.doc.taxes && this.frm.doc.taxes.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301373 this.frm.set_currency_labels(["tax_amount", "total", "tax_amount_after_discount"], this.frm.doc.currency, "taxes");
Nabin Hait613d0812015-02-23 11:58:15 +05301374
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301375 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 +05301376 }
1377
Deepesh Garg9f0823a2021-05-10 16:07:41 +05301378 if (this.frm.doc.advances && this.frm.doc.advances.length > 0) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +05301379 this.frm.set_currency_labels(["advance_amount", "allocated_amount"],
Nabin Haitaa015902015-10-16 13:08:33 +05301380 this.frm.doc.party_account_currency, "advances");
Nabin Hait613d0812015-02-23 11:58:15 +05301381 }
1382
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301383 this.update_payment_schedule_grid_labels(company_currency);
Faris Ansari69eb6d42021-05-07 15:21:33 +05301384 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301385
Faris Ansari69eb6d42021-05-07 15:21:33 +05301386 update_item_grid_labels(company_currency) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301387 this.frm.set_currency_labels([
1388 "base_rate", "base_net_rate", "base_price_list_rate",
1389 "base_amount", "base_net_amount", "base_rate_with_margin"
1390 ], company_currency, "items");
1391
1392 this.frm.set_currency_labels([
1393 "rate", "net_rate", "price_list_rate", "amount",
1394 "net_amount", "stock_uom_rate", "rate_with_margin"
1395 ], this.frm.doc.currency, "items");
Faris Ansari69eb6d42021-05-07 15:21:33 +05301396 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301397
Faris Ansari69eb6d42021-05-07 15:21:33 +05301398 update_payment_schedule_grid_labels(company_currency) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301399 const me = this;
Deepesh Gargdaf6c122021-05-05 12:28:40 +05301400 if (this.frm.doc.payment_schedule && this.frm.doc.payment_schedule.length > 0) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301401 this.frm.set_currency_labels(["base_payment_amount", "base_outstanding", "base_paid_amount"],
1402 company_currency, "payment_schedule");
1403 this.frm.set_currency_labels(["payment_amount", "outstanding", "paid_amount"],
1404 this.frm.doc.currency, "payment_schedule");
Deepesh Garga0ed5172021-05-04 21:01:12 +05301405
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301406 var schedule_grid = this.frm.fields_dict["payment_schedule"].grid;
1407 $.each(["base_payment_amount", "base_outstanding", "base_paid_amount"], function(i, fname) {
Saqib Ansari6fb41752021-04-29 14:05:20 +05301408 if (frappe.meta.get_docfield(schedule_grid.doctype, fname))
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301409 schedule_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1410 });
1411 }
Faris Ansari69eb6d42021-05-07 15:21:33 +05301412 }
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301413
Faris Ansari69eb6d42021-05-07 15:21:33 +05301414 toggle_item_grid_columns(company_currency) {
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05301415 const me = this;
Nabin Hait613d0812015-02-23 11:58:15 +05301416 // toggle columns
1417 var item_grid = this.frm.fields_dict["items"].grid;
Anupam Kumared42afc2021-03-15 11:11:28 +05301418 $.each(["base_rate", "base_price_list_rate", "base_amount", "base_rate_with_margin"], function(i, fname) {
Nabin Hait613d0812015-02-23 11:58:15 +05301419 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1420 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
1421 });
1422
1423 var show = (cint(cur_frm.doc.discount_amount)) ||
1424 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
1425
1426 $.each(["net_rate", "net_amount"], function(i, fname) {
1427 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1428 item_grid.set_column_disp(fname, show);
1429 });
1430
1431 $.each(["base_net_rate", "base_net_amount"], function(i, fname) {
1432 if(frappe.meta.get_docfield(item_grid.doctype, fname))
1433 item_grid.set_column_disp(fname, (show && (me.frm.doc.currency != company_currency)));
1434 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301435 }
Nabin Hait613d0812015-02-23 11:58:15 +05301436
Faris Ansari1fe891b2021-04-23 08:04:00 +05301437 recalculate() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301438 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301439 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301440
Faris Ansari1fe891b2021-04-23 08:04:00 +05301441 recalculate_values() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301442 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301443 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301444
Faris Ansari1fe891b2021-04-23 08:04:00 +05301445 calculate_charges() {
Anand Doshid0b00722013-05-28 18:54:48 +05301446 this.calculate_taxes_and_totals();
Faris Ansari1fe891b2021-04-23 08:04:00 +05301447 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301448
Faris Ansari1fe891b2021-04-23 08:04:00 +05301449 ignore_pricing_rule() {
Nabin Hait8c9fb762017-04-28 14:23:03 +05301450 if(this.frm.doc.ignore_pricing_rule) {
Deepesh Gargf52d7c72024-01-02 13:37:39 +05301451 let me = this;
1452 let item_list = [];
Rushabh Mehta36311022017-06-20 09:30:53 +05301453
Nabin Hait8c9fb762017-04-28 14:23:03 +05301454 $.each(this.frm.doc["items"] || [], function(i, d) {
Deepesh Garg05810002022-12-05 17:59:02 +05301455 if (d.item_code) {
1456 if (d.is_free_item) {
1457 // Simply remove free items
1458 me.frm.get_field("items").grid.grid_rows[i].remove();
1459 } else {
1460 item_list.push({
1461 "doctype": d.doctype,
1462 "name": d.name,
1463 "item_code": d.item_code,
1464 "pricing_rules": d.pricing_rules,
1465 "parenttype": d.parenttype,
1466 "parent": d.parent,
1467 "price_list_rate": d.price_list_rate
1468 })
1469 }
Nabin Hait8c9fb762017-04-28 14:23:03 +05301470 }
1471 });
1472 return this.frm.call({
1473 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.remove_pricing_rules",
1474 args: { item_list: item_list },
1475 callback: function(r) {
1476 if (!r.exc && r.message) {
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301477 r.message.forEach(row_item => {
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301478 me.remove_pricing_rule(row_item);
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301479 });
Nabin Hait8c9fb762017-04-28 14:23:03 +05301480 me._set_values_for_item_list(r.message);
1481 me.calculate_taxes_and_totals();
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05301482 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on");
Nabin Hait8c9fb762017-04-28 14:23:03 +05301483 }
1484 }
1485 });
1486 } else {
1487 this.apply_pricing_rule();
1488 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301489 }
Nabin Hait444f9562014-06-20 15:59:49 +05301490
Deepesh Gargf52d7c72024-01-02 13:37:39 +05301491 remove_pricing_rule_for_item(item) {
1492 let me = this;
1493 return this.frm.call({
1494 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.remove_pricing_rule_for_item",
1495 args: {
1496 pricing_rules: item.pricing_rules,
1497 item_details: {
1498 "doctype": item.doctype,
1499 "name": item.name,
1500 "item_code": item.item_code,
1501 "pricing_rules": item.pricing_rules,
1502 "parenttype": item.parenttype,
1503 "parent": item.parent,
1504 "price_list_rate": item.price_list_rate
1505 },
1506 item_code: item.item_code,
1507 rate: item.price_list_rate,
1508 },
1509 callback: function(r) {
1510 if (!r.exc && r.message) {
1511 me.remove_pricing_rule(r.message);
1512 me.calculate_taxes_and_totals();
1513 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on");
1514 }
1515 }
1516 });
1517 }
1518
Faris Ansari1fe891b2021-04-23 08:04:00 +05301519 apply_pricing_rule(item, calculate_taxes_and_totals) {
Nabin Haita3dd72a2014-05-28 12:49:20 +05301520 var me = this;
Anand Doshi70f57eb2015-11-27 14:37:40 +05301521 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301522 if (!(args.items && args.items.length)) {
marination90a8e922022-05-11 14:54:22 +05301523 if (calculate_taxes_and_totals) me.calculate_taxes_and_totals();
Anand Doshi70f57eb2015-11-27 14:37:40 +05301524 return;
1525 }
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301526
Deepesh Garg9c081942022-04-18 10:21:15 +05301527 // Target doc created from a mapped doc
Sagar Vorab6a75492023-12-02 20:06:19 +05301528 if (this.frm.doc.__onload?.load_after_mapping) {
marination494ddd12022-05-10 14:02:43 +05301529 // Calculate totals even though pricing rule is not applied.
1530 // `apply_pricing_rule` is triggered due to change in data which most likely contributes to Total.
marination90a8e922022-05-11 14:54:22 +05301531 if (calculate_taxes_and_totals) me.calculate_taxes_and_totals();
Deepesh Garg9c081942022-04-18 10:21:15 +05301532 return;
1533 }
1534
Anand Doshidffec8f2014-07-01 17:45:15 +05301535 return this.frm.call({
1536 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.apply_pricing_rule",
Rohit Waghchauree5405342019-03-31 16:42:41 +05301537 args: { args: args, doc: me.frm.doc },
Anand Doshidffec8f2014-07-01 17:45:15 +05301538 callback: function(r) {
Anand Doshif214bfc2014-07-16 17:52:08 +05301539 if (!r.exc && r.message) {
Anand Doshidffec8f2014-07-01 17:45:15 +05301540 me._set_values_for_item_list(r.message);
Saurabh2d7af632016-02-26 11:09:20 +05301541 if(item) me.set_gross_profit(item);
Dany Robert1d83fb22022-11-01 16:39:32 +05301542 if (me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on")
Anand Doshidffec8f2014-07-01 17:45:15 +05301543 }
1544 }
1545 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301546 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301547
Faris Ansari1fe891b2021-04-23 08:04:00 +05301548 _get_args(item) {
Anand Doshidffec8f2014-07-01 17:45:15 +05301549 var me = this;
1550 return {
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301551 "items": this._get_item_list(item),
Nabin Hait34c551d2019-07-03 10:34:31 +05301552 "customer": me.frm.doc.customer || me.frm.doc.party_name,
1553 "quotation_to": me.frm.doc.quotation_to,
Nabin Hait444f9562014-06-20 15:59:49 +05301554 "customer_group": me.frm.doc.customer_group,
1555 "territory": me.frm.doc.territory,
1556 "supplier": me.frm.doc.supplier,
Zlash652e080982018-04-19 18:37:53 +05301557 "supplier_group": me.frm.doc.supplier_group,
Nabin Hait444f9562014-06-20 15:59:49 +05301558 "currency": me.frm.doc.currency,
1559 "conversion_rate": me.frm.doc.conversion_rate,
1560 "price_list": me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Haitdd82bf22015-05-11 16:49:17 +05301561 "price_list_currency": me.frm.doc.price_list_currency,
Nabin Hait444f9562014-06-20 15:59:49 +05301562 "plc_conversion_rate": me.frm.doc.plc_conversion_rate,
1563 "company": me.frm.doc.company,
1564 "transaction_date": me.frm.doc.transaction_date || me.frm.doc.posting_date,
1565 "campaign": me.frm.doc.campaign,
1566 "sales_partner": me.frm.doc.sales_partner,
1567 "ignore_pricing_rule": me.frm.doc.ignore_pricing_rule,
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301568 "doctype": me.frm.doc.doctype,
Rohit Waghchaure5ecbaa42017-03-28 12:09:07 +05301569 "name": me.frm.doc.name,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +05301570 "is_return": cint(me.frm.doc.is_return),
1571 "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 +05301572 "conversion_factor": me.frm.doc.conversion_factor,
ashish-greycube74dc3c92019-08-12 13:39:25 +05301573 "pos_profile": me.frm.doc.doctype == 'Sales Invoice' ? me.frm.doc.pos_profile : '',
1574 "coupon_code": me.frm.doc.coupon_code
Nabin Hait444f9562014-06-20 15:59:49 +05301575 };
Faris Ansari1fe891b2021-04-23 08:04:00 +05301576 }
Nabin Hait444f9562014-06-20 15:59:49 +05301577
Faris Ansari1fe891b2021-04-23 08:04:00 +05301578 _get_item_list(item) {
Nabin Hait444f9562014-06-20 15:59:49 +05301579 var item_list = [];
1580 var append_item = function(d) {
Anand Doshi39edcbc2014-07-28 16:00:19 +05301581 if (d.item_code) {
1582 item_list.push({
1583 "doctype": d.doctype,
1584 "name": d.name,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301585 "child_docname": d.name,
Anand Doshi39edcbc2014-07-28 16:00:19 +05301586 "item_code": d.item_code,
1587 "item_group": d.item_group,
1588 "brand": d.brand,
Anand Doshi39a28912016-02-15 11:42:18 +05301589 "qty": d.qty,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301590 "stock_qty": d.stock_qty,
Nabin Haite45ec662018-08-01 17:44:34 +05301591 "uom": d.uom,
Suraj Shettyc87b47a2019-04-29 23:18:47 +05301592 "stock_uom": d.stock_uom,
Anand Doshi39a28912016-02-15 11:42:18 +05301593 "parenttype": d.parenttype,
Rohit Waghchaure43b50802016-10-24 14:04:46 +05301594 "parent": d.parent,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301595 "pricing_rules": d.pricing_rules,
Dany Robert1e607cd2023-01-20 20:07:37 +05301596 "is_free_item": d.is_free_item,
Kanchan Chauhanaf0d6372016-11-13 21:19:09 +05301597 "warehouse": d.warehouse,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +05301598 "serial_no": d.serial_no,
Deepesh Gargbd9bdc52021-01-28 12:05:57 +05301599 "batch_no": d.batch_no,
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301600 "price_list_rate": d.price_list_rate,
mbauskar287fe812017-04-10 19:15:57 +05301601 "conversion_factor": d.conversion_factor || 1.0
Anand Doshi39edcbc2014-07-28 16:00:19 +05301602 });
mbauskarc79415e2016-01-18 16:32:24 +05301603
1604 // if doctype is Quotation Item / Sales Order Iten then add Margin Type and rate in item_list
Anupam Kumared42afc2021-03-15 11:11:28 +05301605 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 +05301606 item_list[0]["margin_type"] = d.margin_type;
1607 item_list[0]["margin_rate_or_amount"] = d.margin_rate_or_amount;
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301608 }
Anand Doshi39edcbc2014-07-28 16:00:19 +05301609 }
Nabin Hait444f9562014-06-20 15:59:49 +05301610 };
Nabin Haita3dd72a2014-05-28 12:49:20 +05301611
Nabin Hait444f9562014-06-20 15:59:49 +05301612 if (item) {
1613 append_item(item);
Nabin Haitc1367d92014-05-30 11:43:00 +05301614 } else {
Nabin Hait96339342015-01-21 17:22:11 +05301615 $.each(this.frm.doc["items"] || [], function(i, d) {
Nabin Hait444f9562014-06-20 15:59:49 +05301616 append_item(d);
Nabin Haita3dd72a2014-05-28 12:49:20 +05301617 });
1618 }
Nabin Hait444f9562014-06-20 15:59:49 +05301619 return item_list;
Faris Ansari1fe891b2021-04-23 08:04:00 +05301620 }
Nabin Haita3dd72a2014-05-28 12:49:20 +05301621
rohitwaghchauref09e2132024-01-04 14:58:02 +05301622 items_delete() {
1623 this.update_localstorage_scanned_data();
1624 }
1625
1626 update_localstorage_scanned_data() {
1627 let doctypes = ["Sales Invoice", "Purchase Invoice", "Delivery Note", "Purchase Receipt"];
1628 if (this.frm.is_new() && doctypes.includes(this.frm.doc.doctype)) {
1629 const barcode_scanner = new erpnext.utils.BarcodeScanner({frm:this.frm});
1630 barcode_scanner.update_localstorage_scanned_data();
1631 }
1632 }
1633
Faris Ansari1fe891b2021-04-23 08:04:00 +05301634 _set_values_for_item_list(children) {
barredterrae2295b42022-06-20 18:52:40 +02001635 const items_rule_dict = {};
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301636
barredterrae2295b42022-06-20 18:52:40 +02001637 for (const child of children) {
1638 const existing_pricing_rule = frappe.model.get_value(child.doctype, child.name, "pricing_rules");
1639
1640 for (const [key, value] of Object.entries(child)) {
1641 if (!["doctype", "name"].includes(key)) {
1642 if (key === "price_list_rate") {
1643 frappe.model.set_value(child.doctype, child.name, "rate", value);
Nabin Hait7d8fa802014-12-30 15:35:45 +05301644 }
Rohit Waghchaurea9b13472021-03-07 11:43:22 +05301645
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301646 if (key === "pricing_rules") {
1647 frappe.model.set_value(child.doctype, child.name, key, value);
1648 }
1649
barredterrae2295b42022-06-20 18:52:40 +02001650 if (key !== "free_item_data") {
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301651 if (child.apply_rule_on_other_items && JSON.parse(child.apply_rule_on_other_items).length) {
1652 if (!in_list(JSON.parse(child.apply_rule_on_other_items), child.item_code)) {
1653 continue;
1654 }
1655 }
1656
barredterrae2295b42022-06-20 18:52:40 +02001657 frappe.model.set_value(child.doctype, child.name, key, value);
Rohit Waghchaurea9b13472021-03-07 11:43:22 +05301658 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301659 }
Anand Doshidea3fb02015-02-05 15:05:58 +05301660 }
1661
barredterrae2295b42022-06-20 18:52:40 +02001662 frappe.model.round_floats_in(
1663 frappe.get_doc(child.doctype, child.name),
1664 ["price_list_rate", "discount_percentage"],
1665 );
Deepesh Garg2d0208b2021-12-22 12:01:39 +05301666
Nabin Hait49a27292014-12-17 11:21:32 +05301667 // if pricing rule set as blank from an existing value, apply price_list
barredterrae2295b42022-06-20 18:52:40 +02001668 if (!this.frm.doc.ignore_pricing_rule && existing_pricing_rule && !child.pricing_rules) {
1669 this.apply_price_list(frappe.get_doc(child.doctype, child.name));
1670 } else if (!child.pricing_rules) {
1671 this.remove_pricing_rule(frappe.get_doc(child.doctype, child.name));
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301672 }
1673
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301674 if (child.free_item_data && child.free_item_data.length > 0) {
barredterrae2295b42022-06-20 18:52:40 +02001675 this.apply_product_discount(child);
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301676 }
1677
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301678 if (child.apply_rule_on_other_items && JSON.parse(child.apply_rule_on_other_items).length) {
barredterrae2295b42022-06-20 18:52:40 +02001679 items_rule_dict[child.name] = child;
Nabin Hait49a27292014-12-17 11:21:32 +05301680 }
Anand Doshidea3fb02015-02-05 15:05:58 +05301681 }
Nabin Hait7d8fa802014-12-30 15:35:45 +05301682
barredterrae2295b42022-06-20 18:52:40 +02001683 this.apply_rule_on_other_items(items_rule_dict);
1684 this.calculate_taxes_and_totals();
Deepesh Garg6eb3d6a2021-12-25 09:04:34 +05301685 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301686
Faris Ansari1fe891b2021-04-23 08:04:00 +05301687 apply_rule_on_other_items(args) {
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301688 const me = this;
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301689 const fields = ["discount_percentage", "pricing_rules", "discount_amount", "rate"];
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301690
1691 for(var k in args) {
1692 let data = args[k];
Saqib Ansari8c70e8d2020-04-24 16:41:48 +05301693
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301694 if (data && data.apply_rule_on_other_items && JSON.parse(data.apply_rule_on_other_items)) {
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301695 me.frm.doc.items.forEach(d => {
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301696 if (in_list(JSON.parse(data.apply_rule_on_other_items), d[data.apply_rule_on])) {
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301697 for(var k in data) {
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +05301698 if (in_list(fields, k) && data[k] && (data.price_or_product_discount === 'Price' || k === 'pricing_rules')) {
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301699 frappe.model.set_value(d.doctype, d.name, k, data[k]);
1700 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301701 }
1702 }
rohitwaghchaurefc31dbe2020-04-14 12:53:54 +05301703 });
1704 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301705 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301706 }
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301707
Faris Ansari69eb6d42021-05-07 15:21:33 +05301708 apply_product_discount(args) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301709 const items = this.frm.doc.items.filter(d => (d.is_free_item)) || [];
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301710
Rohit Waghchaure77add492021-03-17 18:49:54 +05301711 const exist_items = items.map(row => (row.item_code, row.pricing_rules));
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301712
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301713 args.free_item_data.forEach(pr_row => {
1714 let row_to_modify = {};
Rohit Waghchaure77add492021-03-17 18:49:54 +05301715 if (!items || !in_list(exist_items, (pr_row.item_code, pr_row.pricing_rules))) {
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301716
1717 row_to_modify = frappe.model.add_child(this.frm.doc,
1718 this.frm.doc.doctype + ' Item', 'items');
1719
1720 } else if(items) {
Rohit Waghchaure77add492021-03-17 18:49:54 +05301721 row_to_modify = items.filter(d => (d.item_code === pr_row.item_code
1722 && d.pricing_rules === pr_row.pricing_rules))[0];
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301723 }
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301724
1725 for (let key in pr_row) {
1726 row_to_modify[key] = pr_row[key];
1727 }
Dany Robert1d83fb22022-11-01 16:39:32 +05301728 this.frm.script_manager.copy_from_first_row("items", row_to_modify, ["expense_account", "income_account"]);
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301729 });
1730
1731 // free_item_data is a temporary variable
1732 args.free_item_data = '';
1733 refresh_field('items');
Faris Ansari1fe891b2021-04-23 08:04:00 +05301734 }
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +05301735
Faris Ansari1fe891b2021-04-23 08:04:00 +05301736 apply_price_list(item, reset_plc_conversion) {
tundebabzy6e90f492018-02-12 10:48:57 +01001737 // We need to reset plc_conversion_rate sometimes because the call to
1738 // `erpnext.stock.get_item_details.apply_price_list` is sensitive to its value
1739 if (!reset_plc_conversion) {
1740 this.frm.set_value("plc_conversion_rate", "");
1741 }
1742
Deepesh Gargf52d7c72024-01-02 13:37:39 +05301743 let me = this;
1744 let args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +05301745 if (!((args.items && args.items.length) || args.price_list)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +05301746 return;
1747 }
Nabin Hait37b047d2015-02-23 16:01:33 +05301748
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301749 if (me.in_apply_price_list == true) return;
1750
1751 me.in_apply_price_list = true;
Anand Doshidffec8f2014-07-01 17:45:15 +05301752 return this.frm.call({
1753 method: "erpnext.stock.get_item_details.apply_price_list",
Rushabh Mehta052bd622015-01-30 16:57:24 +05301754 args: { args: args },
Anand Doshidffec8f2014-07-01 17:45:15 +05301755 callback: function(r) {
1756 if (!r.exc) {
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301757 frappe.run_serially([
1758 () => me.frm.set_value("price_list_currency", r.message.parent.price_list_currency),
1759 () => me.frm.set_value("plc_conversion_rate", r.message.parent.plc_conversion_rate),
1760 () => {
1761 if(args.items.length) {
1762 me._set_values_for_item_list(r.message.children);
Anand Baburajan11a9d412023-07-25 21:55:17 +05301763 $.each(r.message.children || [], function(i, d) {
1764 me.apply_discount_on_item(d, d.doctype, d.name, 'discount_percentage');
1765 });
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301766 }
1767 },
1768 () => { me.in_apply_price_list = false; }
1769 ]);
Nabin Hait37b047d2015-02-23 16:01:33 +05301770
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301771 } else {
1772 me.in_apply_price_list = false;
Anand Doshidffec8f2014-07-01 17:45:15 +05301773 }
1774 }
Faris Ansari404f39d2018-05-14 15:46:45 +05301775 }).always(() => {
1776 me.in_apply_price_list = false;
Anand Doshidffec8f2014-07-01 17:45:15 +05301777 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301778 }
Anand Doshidffec8f2014-07-01 17:45:15 +05301779
Faris Ansari1fe891b2021-04-23 08:04:00 +05301780 remove_pricing_rule(item) {
Rohit Waghchauree5405342019-03-31 16:42:41 +05301781 let me = this;
Rohit Waghchaure660a78b2020-01-02 17:29:50 +05301782 const fields = ["discount_percentage",
1783 "discount_amount", "margin_rate_or_amount", "rate_with_margin"];
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301784
rohitwaghchaurea85ddf22019-11-19 18:47:48 +05301785 if(item.remove_free_item) {
Deepesh Gargf52d7c72024-01-02 13:37:39 +05301786 let items = [];
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301787
1788 me.frm.doc.items.forEach(d => {
1789 if(d.item_code != item.remove_free_item || !d.is_free_item) {
1790 items.push(d);
1791 }
1792 });
1793
1794 me.frm.doc.items = items;
1795 refresh_field('items');
Rohit Waghchauree5405342019-03-31 16:42:41 +05301796 } else if(item.applied_on_items && item.apply_on) {
1797 const applied_on_items = item.applied_on_items.split(',');
1798 me.frm.doc.items.forEach(row => {
1799 if(applied_on_items.includes(row[item.apply_on])) {
1800 fields.forEach(f => {
1801 row[f] = 0;
1802 });
Rohit Waghchaure660a78b2020-01-02 17:29:50 +05301803
1804 ["pricing_rules", "margin_type"].forEach(field => {
1805 if (row[field]) {
1806 row[field] = '';
1807 }
1808 })
Rohit Waghchauree5405342019-03-31 16:42:41 +05301809 }
1810 });
1811
1812 me.trigger_price_list_rate();
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301813 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301814 }
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +05301815
Faris Ansari1fe891b2021-04-23 08:04:00 +05301816 trigger_price_list_rate() {
Rohit Waghchauree5405342019-03-31 16:42:41 +05301817 var me = this;
1818
1819 this.frm.doc.items.forEach(child_row => {
1820 me.frm.script_manager.trigger("price_list_rate",
1821 child_row.doctype, child_row.name);
1822 })
Faris Ansari1fe891b2021-04-23 08:04:00 +05301823 }
Rohit Waghchauree5405342019-03-31 16:42:41 +05301824
Faris Ansari1fe891b2021-04-23 08:04:00 +05301825 validate_company_and_party() {
Anand Doshi923d41d2013-05-28 17:23:36 +05301826 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +05301827 var valid = true;
Rushabh Mehtaff938022014-04-15 18:40:00 +05301828
Rohit Waghchaure0d7f98b2023-01-28 13:51:33 +05301829 if (frappe.flags.ignore_company_party_validation) {
1830 return valid;
1831 }
1832
Nabin Hait0f231062014-02-20 11:27:47 +05301833 $.each(["company", "customer"], function(i, fieldname) {
vr-greycube0f0bc9a2023-01-10 20:26:33 +05301834 if(frappe.meta.has_field(me.frm.doc.doctype, fieldname) && !["Purchase Order","Purchase Invoice"].includes(me.frm.doc.doctype)) {
Nabin Hait139dc7b2014-02-12 14:53:18 +05301835 if (!me.frm.doc[fieldname]) {
Faris Ansariab74ca72017-05-30 12:54:42 +05301836 frappe.msgprint(__("Please specify") + ": " +
hyaray59438ee2023-11-11 22:08:24 +08001837 __(frappe.meta.get_label(me.frm.doc.doctype, fieldname, me.frm.doc.name)) +
Pratik Vyasb52618c2014-04-14 16:25:30 +05301838 ". " + __("It is needed to fetch Item Details."));
Faris Ansariab74ca72017-05-30 12:54:42 +05301839 valid = false;
Nabin Hait139dc7b2014-02-12 14:53:18 +05301840 }
Anand Doshi3543f302013-05-24 19:25:01 +05301841 }
1842 });
1843 return valid;
Faris Ansari1fe891b2021-04-23 08:04:00 +05301844 }
Rushabh Mehtaff938022014-04-15 18:40:00 +05301845
Faris Ansari1fe891b2021-04-23 08:04:00 +05301846 get_terms() {
Anand Doshibf3e54a2013-06-05 14:11:32 +05301847 var me = this;
Makarand Bauskar157c3342017-05-26 21:32:33 +05301848
1849 erpnext.utils.get_terms(this.frm.doc.tc_name, this.frm.doc, function(r) {
1850 if(!r.exc) {
1851 me.frm.set_value("terms", r.message);
1852 }
1853 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05301854 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301855
Faris Ansari1fe891b2021-04-23 08:04:00 +05301856 taxes_and_charges() {
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301857 var me = this;
1858 if(this.frm.doc.taxes_and_charges) {
1859 return this.frm.call({
Nabin Hait6b039142014-05-02 15:45:10 +05301860 method: "erpnext.controllers.accounts_controller.get_taxes_and_charges",
1861 args: {
Nabin Hait03f3a8a2014-05-13 16:38:31 +05301862 "master_doctype": frappe.meta.get_docfield(this.frm.doc.doctype, "taxes_and_charges",
1863 this.frm.doc.name).options,
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301864 "master_name": this.frm.doc.taxes_and_charges
Nabin Hait6b039142014-05-02 15:45:10 +05301865 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301866 callback: function(r) {
1867 if(!r.exc) {
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301868 if(me.frm.doc.shipping_rule && me.frm.doc.taxes) {
1869 for (let tax of r.message) {
1870 me.frm.add_child("taxes", tax);
1871 }
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301872
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301873 refresh_field("taxes");
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301874 } else {
rohitwaghchauree9f0e882019-07-15 18:57:25 +05301875 me.frm.set_value("taxes", r.message);
Rohit Waghchaure72cc37e2019-04-11 18:35:15 +05301876 me.calculate_taxes_and_totals();
Rohan Bansal90972cf2019-03-11 14:48:26 +05301877 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301878 }
1879 }
1880 });
Nabin Haitbc83b9c2014-05-02 17:03:18 +05301881 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301882 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +05301883
Faris Ansari1fe891b2021-04-23 08:04:00 +05301884 tax_category() {
Saif Ur Rehman67786682018-12-27 02:11:07 +05001885 var me = this;
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +05001886 if(me.frm.updating_party_details) return;
1887
Saif Ur Rehmane414a922018-12-28 04:59:42 +05001888 frappe.run_serially([
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001889 () => this.update_item_tax_map(),
Saif Ur Rehmane414a922018-12-28 04:59:42 +05001890 () => erpnext.utils.set_taxes(this.frm, "tax_category"),
1891 ]);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301892 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001893
Nabin Hait595c7a62021-07-22 17:11:20 +05301894 update_item_tax_map() {
Deepesh Garg72eb72f2021-07-20 15:45:04 +05301895 let me = this;
1896 let item_codes = [];
1897 let item_rates = {};
1898 let item_tax_templates = {};
1899
1900 $.each(this.frm.doc.items || [], function(i, item) {
1901 if (item.item_code) {
1902 // Use combination of name and item code in case same item is added multiple times
1903 item_codes.push([item.item_code, item.name]);
1904 item_rates[item.name] = item.net_rate;
1905 item_tax_templates[item.name] = item.item_tax_template;
1906 }
1907 });
1908
1909 if (item_codes.length) {
1910 return this.frm.call({
1911 method: "erpnext.stock.get_item_details.get_item_tax_info",
1912 args: {
1913 company: me.frm.doc.company,
1914 tax_category: cstr(me.frm.doc.tax_category),
1915 item_codes: item_codes,
1916 item_rates: item_rates,
1917 item_tax_templates: item_tax_templates
1918 },
1919 callback: function(r) {
1920 if (!r.exc) {
1921 $.each(me.frm.doc.items || [], function(i, item) {
1922 if (item.name && r.message.hasOwnProperty(item.name) && r.message[item.name].item_tax_template) {
1923 item.item_tax_template = r.message[item.name].item_tax_template;
1924 item.item_tax_rate = r.message[item.name].item_tax_rate;
1925 me.add_taxes_from_item_tax_template(item.item_tax_rate);
1926 }
1927 });
1928 }
1929 }
1930 });
1931 }
Nabin Hait595c7a62021-07-22 17:11:20 +05301932 }
Deepesh Garg72eb72f2021-07-20 15:45:04 +05301933
Faris Ansari1fe891b2021-04-23 08:04:00 +05301934 item_tax_template(doc, cdt, cdn) {
Saif Ur Rehman67786682018-12-27 02:11:07 +05001935 var me = this;
Saif Ur Rehmanfd531a62018-12-29 01:49:11 +05001936 if(me.frm.updating_party_details) return;
1937
Saif Ur Rehman67786682018-12-27 02:11:07 +05001938 var item = frappe.get_doc(cdt, cdn);
1939
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001940 if(item.item_tax_template) {
1941 return this.frm.call({
1942 method: "erpnext.stock.get_item_details.get_item_tax_map",
1943 args: {
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001944 company: me.frm.doc.company,
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001945 item_tax_template: item.item_tax_template,
1946 as_json: true
1947 },
1948 callback: function(r) {
1949 if(!r.exc) {
1950 item.item_tax_rate = r.message;
Deepesh Garg66ca0852022-03-22 23:03:41 +05301951 me.add_taxes_from_item_tax_template(item.item_tax_rate);
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001952 me.calculate_taxes_and_totals();
1953 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001954 }
Saif Ur Rehmanaca374e2018-12-28 04:53:25 +05001955 });
1956 } else {
1957 item.item_tax_rate = "{}";
1958 me.calculate_taxes_and_totals();
1959 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05301960 }
Saif Ur Rehman67786682018-12-27 02:11:07 +05001961
Saif Ur Rehmaneeead1d2018-12-29 02:25:00 +05001962
Faris Ansari1fe891b2021-04-23 08:04:00 +05301963 is_recurring() {
Anand Doshi13945092014-09-21 19:45:49 +05301964 // set default values for recurring documents
Rushabh Mehta756e5182016-03-03 13:00:17 +05301965 if(this.frm.doc.is_recurring && this.frm.doc.__islocal) {
1966 frappe.msgprint(__("Please set recurring after saving"));
1967 this.frm.set_value('is_recurring', 0);
1968 return;
1969 }
1970
Anand Doshi13945092014-09-21 19:45:49 +05301971 if(this.frm.doc.is_recurring) {
Nabin Hait68a628e2016-03-21 12:03:16 +05301972 if(!this.frm.doc.recurring_id) {
1973 this.frm.set_value('recurring_id', this.frm.doc.name);
1974 }
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301975
Anand Doshi13945092014-09-21 19:45:49 +05301976 var owner_email = this.frm.doc.owner=="Administrator"
1977 ? frappe.user_info("Administrator").email
1978 : this.frm.doc.owner;
1979
1980 this.frm.doc.notification_email_address = $.map([cstr(owner_email),
1981 cstr(this.frm.doc.contact_email)], function(v) { return v || null; }).join(", ");
1982 this.frm.doc.repeat_on_day_of_month = frappe.datetime.str_to_obj(this.frm.doc.posting_date).getDate();
1983 }
1984
1985 refresh_many(["notification_email_address", "repeat_on_day_of_month"]);
Faris Ansari1fe891b2021-04-23 08:04:00 +05301986 }
Anand Doshi13945092014-09-21 19:45:49 +05301987
Faris Ansari1fe891b2021-04-23 08:04:00 +05301988 from_date() {
Anand Doshi13945092014-09-21 19:45:49 +05301989 // set to_date
1990 if(this.frm.doc.from_date) {
1991 var recurring_type_map = {'Monthly': 1, 'Quarterly': 3, 'Half-yearly': 6,
1992 'Yearly': 12};
1993
1994 var months = recurring_type_map[this.frm.doc.recurring_type];
1995 if(months) {
1996 var to_date = frappe.datetime.add_months(this.frm.doc.from_date,
1997 months);
1998 this.frm.doc.to_date = frappe.datetime.add_days(to_date, -1);
1999 refresh_field('to_date');
2000 }
2001 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302002 }
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05302003
Faris Ansari1fe891b2021-04-23 08:04:00 +05302004 set_gross_profit(item) {
Abhishek Balam18e7b602020-05-26 18:37:02 +05302005 if (["Sales Order", "Quotation"].includes(this.frm.doc.doctype) && item.valuation_rate) {
Faris Ansariab74ca72017-05-30 12:54:42 +05302006 var rate = flt(item.rate) * flt(this.frm.doc.conversion_rate || 1);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05302007 item.gross_profit = flt(((rate - item.valuation_rate) * item.stock_qty), precision("amount", item));
Saurabh2d7af632016-02-26 11:09:20 +05302008 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302009 }
Rushabh Mehta203cc962016-04-07 15:25:43 +05302010
Faris Ansari1fe891b2021-04-23 08:04:00 +05302011 setup_item_selector() {
Rushabh Mehtabc928242016-05-29 23:08:22 +05302012 // TODO: remove item selector
2013
2014 return;
Faris Ansariab74ca72017-05-30 12:54:42 +05302015 // if(!this.item_selector) {
2016 // this.item_selector = new erpnext.ItemSelector({frm: this.frm});
2017 // }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302018 }
Rushabh Mehta76b13412016-07-18 14:30:18 +05302019
Faris Ansari1fe891b2021-04-23 08:04:00 +05302020 get_advances() {
Nabin Hait28a05282016-06-27 17:41:39 +05302021 if(!this.frm.is_return) {
Marica2feb27e2023-03-07 15:45:18 +05302022 var me = this;
Nabin Hait28a05282016-06-27 17:41:39 +05302023 return this.frm.call({
2024 method: "set_advances",
2025 doc: this.frm.doc,
2026 callback: function(r, rt) {
2027 refresh_field("advances");
Marica2feb27e2023-03-07 15:45:18 +05302028 me.frm.dirty();
Nabin Hait28a05282016-06-27 17:41:39 +05302029 }
2030 })
2031 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302032 }
Rushabh Mehta76b13412016-07-18 14:30:18 +05302033
Faris Ansari1fe891b2021-04-23 08:04:00 +05302034 make_payment_entry() {
marinationd6d01632023-03-14 13:40:55 +05302035 let via_journal_entry = this.frm.doc.__onload && this.frm.doc.__onload.make_payment_via_journal_entry;
2036 if(this.has_discount_in_schedule() && !via_journal_entry) {
2037 // If early payment discount is applied, ask user for reference date
2038 this.prompt_user_for_reference_date();
2039 } else {
2040 this.make_mapped_payment_entry();
2041 }
2042 }
2043
2044 make_mapped_payment_entry(args) {
2045 var me = this;
2046 args = args || { "dt": this.frm.doc.doctype, "dn": this.frm.doc.name };
Nabin Hait05aefbb2016-06-28 19:42:19 +05302047 return frappe.call({
marinationd6d01632023-03-14 13:40:55 +05302048 method: me.get_method_for_payment(),
2049 args: args,
Nabin Hait05aefbb2016-06-28 19:42:19 +05302050 callback: function(r) {
2051 var doclist = frappe.model.sync(r.message);
2052 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
2053 }
2054 });
Faris Ansari1fe891b2021-04-23 08:04:00 +05302055 }
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302056
marinationd6d01632023-03-14 13:40:55 +05302057 prompt_user_for_reference_date(){
Deepesh Garg5c758942023-04-16 17:11:24 +05302058 let me = this;
marinationd6d01632023-03-14 13:40:55 +05302059 frappe.prompt({
2060 label: __("Cheque/Reference Date"),
2061 fieldname: "reference_date",
2062 fieldtype: "Date",
2063 reqd: 1,
2064 }, (values) => {
2065 let args = {
2066 "dt": me.frm.doc.doctype,
2067 "dn": me.frm.doc.name,
2068 "reference_date": values.reference_date
2069 }
2070 me.make_mapped_payment_entry(args);
2071 },
2072 __("Reference Date for Early Payment Discount"),
2073 __("Continue")
2074 );
2075 }
2076
2077 has_discount_in_schedule() {
2078 let is_eligible = in_list(
2079 ["Sales Order", "Sales Invoice", "Purchase Order", "Purchase Invoice"],
2080 this.frm.doctype
2081 );
2082 let has_payment_schedule = this.frm.doc.payment_schedule && this.frm.doc.payment_schedule.length;
2083 if(!is_eligible || !has_payment_schedule) return false;
2084
Deepesh Garg5c758942023-04-16 17:11:24 +05302085 let has_discount = this.frm.doc.payment_schedule.some(row => row.discount);
marinationd6d01632023-03-14 13:40:55 +05302086 return has_discount;
2087 }
2088
Ankushfd848472021-06-16 11:14:40 +05302089 make_quality_inspection() {
Rohan Bansala93b5142021-04-06 17:10:52 +05302090 let data = [];
2091 const fields = [
2092 {
2093 label: "Items",
2094 fieldtype: "Table",
2095 fieldname: "items",
2096 cannot_add_rows: true,
2097 in_place_edit: true,
2098 data: data,
Rohan Bansal03f711e2021-04-14 14:41:55 +05302099 get_data: () => {
2100 return data;
2101 },
Rohan Bansala93b5142021-04-06 17:10:52 +05302102 fields: [
2103 {
2104 fieldtype: "Data",
2105 fieldname: "docname",
2106 hidden: true
2107 },
2108 {
2109 fieldtype: "Read Only",
2110 fieldname: "item_code",
2111 label: __("Item Code"),
2112 in_list_view: true
2113 },
2114 {
2115 fieldtype: "Read Only",
2116 fieldname: "item_name",
2117 label: __("Item Name"),
2118 in_list_view: true
2119 },
2120 {
2121 fieldtype: "Float",
2122 fieldname: "qty",
2123 label: __("Accepted Quantity"),
2124 in_list_view: true,
2125 read_only: true
2126 },
2127 {
2128 fieldtype: "Float",
2129 fieldname: "sample_size",
2130 label: __("Sample Size"),
2131 reqd: true,
2132 in_list_view: true
2133 },
2134 {
2135 fieldtype: "Data",
2136 fieldname: "description",
2137 label: __("Description"),
2138 hidden: true
2139 },
2140 {
2141 fieldtype: "Data",
2142 fieldname: "serial_no",
2143 label: __("Serial No"),
2144 hidden: true
2145 },
2146 {
2147 fieldtype: "Data",
2148 fieldname: "batch_no",
2149 label: __("Batch No"),
2150 hidden: true
2151 }
2152 ]
2153 }
2154 ];
2155
2156 const me = this;
2157 const dialog = new frappe.ui.Dialog({
2158 title: __("Select Items for Quality Inspection"),
s-aga-rc9ae9df2023-08-23 13:34:42 +05302159 size: "extra-large",
Rohan Bansala93b5142021-04-06 17:10:52 +05302160 fields: fields,
2161 primary_action: function () {
2162 const data = dialog.get_values();
2163 frappe.call({
Rohan Bansal7f8b95e2021-04-14 14:12:03 +05302164 method: "erpnext.controllers.stock_controller.make_quality_inspections",
Rohan Bansala93b5142021-04-06 17:10:52 +05302165 args: {
2166 doctype: me.frm.doc.doctype,
2167 docname: me.frm.doc.name,
Rohan Bansala06ec032021-06-02 14:55:31 +05302168 items: data.items
Rohan Bansala93b5142021-04-06 17:10:52 +05302169 },
2170 freeze: true,
2171 callback: function (r) {
Rohan Bansal1cdf5a02021-05-26 14:42:15 +05302172 if (r.message.length > 0) {
2173 if (r.message.length === 1) {
2174 frappe.set_route("Form", "Quality Inspection", r.message[0]);
2175 } else {
2176 frappe.route_options = {
2177 "reference_type": me.frm.doc.doctype,
2178 "reference_name": me.frm.doc.name
2179 };
2180 frappe.set_route("List", "Quality Inspection");
2181 }
Rohan Bansala93b5142021-04-06 17:10:52 +05302182 }
2183 dialog.hide();
2184 }
2185 });
2186 },
2187 primary_action_label: __("Create")
2188 });
2189
2190 this.frm.doc.items.forEach(item => {
2191 if (!item.quality_inspection) {
2192 let dialog_items = dialog.fields_dict.items;
2193 dialog_items.df.data.push({
2194 "docname": item.name,
2195 "item_code": item.item_code,
2196 "item_name": item.item_name,
2197 "qty": item.qty,
2198 "description": item.description,
2199 "serial_no": item.serial_no,
Marc de Lima Lucio048c0372022-07-21 10:16:59 +02002200 "batch_no": item.batch_no,
2201 "sample_size": item.sample_quantity
Rohan Bansala93b5142021-04-06 17:10:52 +05302202 });
2203 dialog_items.grid.refresh();
2204 }
Rohan Bansal03f711e2021-04-14 14:41:55 +05302205 });
Rohan Bansala93b5142021-04-06 17:10:52 +05302206
2207 data = dialog.fields_dict.items.df.data;
2208 if (!data.length) {
2209 frappe.msgprint(__("All items in this document already have a linked Quality Inspection."));
2210 } else {
2211 dialog.show();
2212 }
Ankushfd848472021-06-16 11:14:40 +05302213 }
Rohan Bansala93b5142021-04-06 17:10:52 +05302214
Ankushfd848472021-06-16 11:14:40 +05302215 get_method_for_payment() {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302216 var method = "erpnext.accounts.doctype.payment_entry.payment_entry.get_payment_entry";
Rohit Waghchaure7d529892016-10-06 14:35:04 +05302217 if(cur_frm.doc.__onload && cur_frm.doc.__onload.make_payment_via_journal_entry){
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302218 if(in_list(['Sales Invoice', 'Purchase Invoice'], cur_frm.doc.doctype)){
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302219 method = "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_invoice";
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302220 }else {
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302221 method= "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_order";
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05302222 }
2223 }
2224
2225 return method
Faris Ansari1fe891b2021-04-23 08:04:00 +05302226 }
Makarand Bauskarc196d742017-06-02 17:28:40 +05302227
Faris Ansari1fe891b2021-04-23 08:04:00 +05302228 set_query_for_batch(doc, cdt, cdn) {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302229 // Show item's batches in the dropdown of batch no
2230
2231 var me = this;
2232 var item = frappe.get_doc(cdt, cdn);
2233
2234 if(!item.item_code) {
2235 frappe.throw(__("Please enter Item Code to get batch no"));
Rushabh Mehta36311022017-06-20 09:30:53 +05302236 } else if (doc.doctype == "Purchase Receipt" ||
Makarand Bauskarc196d742017-06-02 17:28:40 +05302237 (doc.doctype == "Purchase Invoice" && doc.update_stock)) {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302238 return {
2239 filters: {'item': item.item_code}
2240 }
2241 } else {
Rushabh Mehta98aa5812017-11-14 09:32:32 +05302242 let filters = {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302243 'item_code': item.item_code,
2244 'posting_date': me.frm.doc.posting_date || frappe.datetime.nowdate(),
2245 }
Rohit Waghchaured8ddd1e2019-10-22 14:03:27 +05302246
2247 if (doc.is_return) {
2248 filters["is_return"] = 1;
2249 }
2250
Rushabh Mehta30dc9a12017-11-17 14:31:09 +05302251 if (item.warehouse) filters["warehouse"] = item.warehouse;
Makarand Bauskarc196d742017-06-02 17:28:40 +05302252
KanchanChauhan0fe455a2017-11-17 20:08:15 +05302253 return {
Makarand Bauskarc196d742017-06-02 17:28:40 +05302254 query : "erpnext.controllers.queries.get_batch_no",
2255 filters: filters
2256 }
2257 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302258 }
Nabin Hait92759692017-08-15 08:23:51 +05302259
Faris Ansari1fe891b2021-04-23 08:04:00 +05302260 set_query_for_item_tax_template(doc, cdt, cdn) {
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302261 var item = frappe.get_doc(cdt, cdn);
2262 if(!item.item_code) {
casesolved-co-uka7803062021-02-16 05:48:50 +00002263 return doc.company ? {filters: {company: doc.company}} : {};
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302264 } else {
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302265 let filters = {
2266 'item_code': item.item_code,
Marica0fcb05a2020-08-10 14:48:13 +05302267 'valid_from': ["<=", doc.transaction_date || doc.bill_date || doc.posting_date],
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302268 'item_group': item.item_group,
2269 }
2270
2271 if (doc.tax_category)
2272 filters['tax_category'] = doc.tax_category;
mohammadahmad199041c0c9f2020-06-18 11:18:44 +05002273 if (doc.company)
2274 filters['company'] = doc.company;
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302275 return {
2276 query: "erpnext.controllers.queries.get_tax_template",
2277 filters: filters
2278 }
2279 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302280 }
Deepesh Gargef0d26c2020-01-06 15:34:15 +05302281
Faris Ansari1fe891b2021-04-23 08:04:00 +05302282 payment_terms_template() {
Nabin Hait92759692017-08-15 08:23:51 +05302283 var me = this;
tundebabzy8f44d1c2018-01-05 08:16:50 +01002284 const doc = this.frm.doc;
2285 if(doc.payment_terms_template && doc.doctype !== 'Delivery Note') {
Shreya Shah3a9eec22018-02-16 13:05:21 +05302286 var posting_date = doc.posting_date || doc.transaction_date;
Nabin Hait92759692017-08-15 08:23:51 +05302287 frappe.call({
2288 method: "erpnext.controllers.accounts_controller.get_payment_terms",
2289 args: {
tundebabzy8f44d1c2018-01-05 08:16:50 +01002290 terms_template: doc.payment_terms_template,
rohitwaghchaureda941af2018-01-17 16:23:04 +05302291 posting_date: posting_date,
Shreya Shah3a9eec22018-02-16 13:05:21 +05302292 grand_total: doc.rounded_total || doc.grand_total,
Saqib Ansarid552fe62021-04-23 14:46:52 +05302293 base_grand_total: doc.base_rounded_total || doc.base_grand_total,
Shreya Shah3a9eec22018-02-16 13:05:21 +05302294 bill_date: doc.bill_date
Nabin Hait92759692017-08-15 08:23:51 +05302295 },
2296 callback: function(r) {
2297 if(r.message && !r.exc) {
2298 me.frm.set_value("payment_schedule", r.message);
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05302299 const company_currency = me.get_company_currency();
Deepesh Garga0ed5172021-05-04 21:01:12 +05302300 me.update_payment_schedule_grid_labels(company_currency);
Nabin Hait92759692017-08-15 08:23:51 +05302301 }
2302 }
2303 })
2304 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302305 }
Nabin Hait92759692017-08-15 08:23:51 +05302306
Faris Ansari1fe891b2021-04-23 08:04:00 +05302307 payment_term(doc, cdt, cdn) {
Saqib Ansari6fb41752021-04-29 14:05:20 +05302308 const me = this;
Nabin Hait92759692017-08-15 08:23:51 +05302309 var row = locals[cdt][cdn];
2310 if(row.payment_term) {
2311 frappe.call({
2312 method: "erpnext.controllers.accounts_controller.get_payment_term_details",
2313 args: {
2314 term: row.payment_term,
Shreya Shah3a9eec22018-02-16 13:05:21 +05302315 bill_date: this.frm.doc.bill_date,
Nabin Hait92759692017-08-15 08:23:51 +05302316 posting_date: this.frm.doc.posting_date || this.frm.doc.transaction_date,
Saqib Ansarid552fe62021-04-23 14:46:52 +05302317 grand_total: this.frm.doc.rounded_total || this.frm.doc.grand_total,
2318 base_grand_total: this.frm.doc.base_rounded_total || this.frm.doc.base_grand_total
Nabin Hait92759692017-08-15 08:23:51 +05302319 },
2320 callback: function(r) {
2321 if(r.message && !r.exc) {
2322 for (var d in r.message) {
2323 frappe.model.set_value(cdt, cdn, d, r.message[d]);
Saqib Ansaric5c9f9a2021-04-23 15:34:58 +05302324 const company_currency = me.get_company_currency();
Saqib Ansari6fb41752021-04-29 14:05:20 +05302325 me.update_payment_schedule_grid_labels(company_currency);
Nabin Hait92759692017-08-15 08:23:51 +05302326 }
2327 }
2328 }
2329 })
2330 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302331 }
Manas Solankie5e87f72018-05-28 20:07:08 +05302332
Faris Ansari1fe891b2021-04-23 08:04:00 +05302333 against_blanket_order(doc, cdt, cdn) {
ronelvcabrera370cdc02019-12-04 18:37:11 +08002334 var item = locals[cdt][cdn];
2335 if(!item.against_blanket_order) {
2336 frappe.model.set_value(this.frm.doctype + " Item", item.name, "blanket_order", null);
2337 frappe.model.set_value(this.frm.doctype + " Item", item.name, "blanket_order_rate", 0.00);
2338 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302339 }
ronelvcabrera370cdc02019-12-04 18:37:11 +08002340
Faris Ansari1fe891b2021-04-23 08:04:00 +05302341 blanket_order(doc, cdt, cdn) {
Manas Solankie5e87f72018-05-28 20:07:08 +05302342 var me = this;
2343 var item = locals[cdt][cdn];
2344 if (item.blanket_order && (item.parenttype=="Sales Order" || item.parenttype=="Purchase Order")) {
2345 frappe.call({
2346 method: "erpnext.stock.get_item_details.get_blanket_order_details",
2347 args: {
2348 args:{
2349 item_code: item.item_code,
2350 customer: doc.customer,
2351 supplier: doc.supplier,
2352 company: doc.company,
2353 transaction_date: doc.transaction_date,
2354 blanket_order: item.blanket_order
2355 }
2356 },
2357 callback: function(r) {
2358 if (!r.message) {
Manas Solanki2df1b312018-05-29 12:56:14 +05302359 frappe.throw(__("Invalid Blanket Order for the selected Customer and Item"));
Manas Solankie5e87f72018-05-28 20:07:08 +05302360 } else {
2361 frappe.run_serially([
2362 () => frappe.model.set_value(cdt, cdn, "blanket_order_rate", r.message.blanket_order_rate),
2363 () => me.frm.script_manager.trigger("price_list_rate", cdt, cdn)
2364 ]);
2365 }
2366 }
2367 })
2368 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302369 }
Saif60ec88b2018-11-13 12:07:53 +05002370
Faris Ansari1fe891b2021-04-23 08:04:00 +05302371 set_reserve_warehouse() {
marination8a30cb22020-04-23 00:18:21 +05302372 this.autofill_warehouse(this.frm.doc.supplied_items, "reserve_warehouse", this.frm.doc.set_reserve_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302373 }
Marica93cb64e2019-12-23 18:24:56 +05302374
Faris Ansari1fe891b2021-04-23 08:04:00 +05302375 set_warehouse() {
marination8a30cb22020-04-23 00:18:21 +05302376 this.autofill_warehouse(this.frm.doc.items, "warehouse", this.frm.doc.set_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302377 }
Marica93cb64e2019-12-23 18:24:56 +05302378
Faris Ansari1fe891b2021-04-23 08:04:00 +05302379 set_target_warehouse() {
Deepesh Gargb4be2922021-01-28 13:09:56 +05302380 this.autofill_warehouse(this.frm.doc.items, "target_warehouse", this.frm.doc.set_target_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302381 }
Deepesh Gargb4be2922021-01-28 13:09:56 +05302382
Faris Ansari1fe891b2021-04-23 08:04:00 +05302383 set_from_warehouse() {
Deepesh Gargb4be2922021-01-28 13:09:56 +05302384 this.autofill_warehouse(this.frm.doc.items, "from_warehouse", this.frm.doc.set_from_warehouse);
Faris Ansari1fe891b2021-04-23 08:04:00 +05302385 }
Deepesh Gargb4be2922021-01-28 13:09:56 +05302386
Faris Ansari1fe891b2021-04-23 08:04:00 +05302387 autofill_warehouse(child_table, warehouse_field, warehouse) {
marinationb7f68782020-04-28 19:18:45 +05302388 if (warehouse && child_table && child_table.length) {
2389 let doctype = child_table[0].doctype;
Marica93cb64e2019-12-23 18:24:56 +05302390 $.each(child_table || [], function(i, item) {
2391 frappe.model.set_value(doctype, item.name, warehouse_field, warehouse);
Saif60ec88b2018-11-13 12:07:53 +05002392 });
2393 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302394 }
Marica93cb64e2019-12-23 18:24:56 +05302395
Faris Ansari1fe891b2021-04-23 08:04:00 +05302396 coupon_code() {
Saqib Ansari81514512022-02-25 15:18:06 +05302397 if (this.frm.doc.coupon_code || this.frm._last_coupon_code) {
2398 // reset pricing rules if coupon code is set or is unset
2399 const _ignore_pricing_rule = this.frm.doc.ignore_pricing_rule;
2400 return frappe.run_serially([
2401 () => this.frm.doc.ignore_pricing_rule=1,
2402 () => this.frm.trigger('ignore_pricing_rule'),
2403 () => this.frm.doc.ignore_pricing_rule=_ignore_pricing_rule,
2404 () => this.frm.trigger('apply_pricing_rule'),
2405 () => this.frm._last_coupon_code = this.frm.doc.coupon_code
2406 ]);
2407 }
Nabin Hait92759692017-08-15 08:23:51 +05302408 }
Faris Ansari1fe891b2021-04-23 08:04:00 +05302409};
pratu16x7ae450fc2017-06-26 15:31:46 +05302410
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05302411erpnext.show_serial_batch_selector = function (frm, item_row, callback, on_close, show_dialog) {
Rohan73726722019-12-24 18:19:58 +05302412 let warehouse, receiving_stock, existing_stock;
Rohit Waghchaureacd12c52023-06-04 16:09:01 +05302413
2414 let warehouse_field = "warehouse";
Rohan73726722019-12-24 18:19:58 +05302415 if (frm.doc.is_return) {
2416 if (["Purchase Receipt", "Purchase Invoice"].includes(frm.doc.doctype)) {
2417 existing_stock = true;
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05302418 warehouse = item_row.warehouse;
Rohan73726722019-12-24 18:19:58 +05302419 } else if (["Delivery Note", "Sales Invoice"].includes(frm.doc.doctype)) {
2420 receiving_stock = true;
2421 }
2422 } else {
2423 if (frm.doc.doctype == "Stock Entry") {
2424 if (frm.doc.purpose == "Material Receipt") {
2425 receiving_stock = true;
2426 } else {
2427 existing_stock = true;
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05302428 warehouse = item_row.s_warehouse;
Rohan73726722019-12-24 18:19:58 +05302429 }
Rohit Waghchaureacd12c52023-06-04 16:09:01 +05302430
2431 if (in_list([
2432 "Material Transfer",
2433 "Send to Subcontractor",
2434 "Material Issue",
2435 "Material Consumption for Manufacture",
2436 "Material Transfer for Manufacture"
2437 ], frm.doc.purpose)
2438 ) {
2439 warehouse_field = "s_warehouse";
2440 } else {
2441 warehouse_field = "t_warehouse";
2442 }
Rohan73726722019-12-24 18:19:58 +05302443 } else {
2444 existing_stock = true;
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05302445 warehouse = item_row.warehouse;
Rohan73726722019-12-24 18:19:58 +05302446 }
2447 }
2448
2449 if (!warehouse) {
2450 if (receiving_stock) {
2451 warehouse = ["like", ""];
2452 } else if (existing_stock) {
2453 warehouse = ["!=", ""];
2454 }
2455 }
2456
pratu16x7ae450fc2017-06-26 15:31:46 +05302457 frappe.require("assets/erpnext/js/utils/serial_no_batch_selector.js", function() {
Rohit Waghchaure5bb31732023-03-21 10:54:41 +05302458 if (in_list(["Sales Invoice", "Delivery Note"], frm.doc.doctype)) {
Rohit Waghchaure1c2fe082023-06-15 12:54:43 +05302459 item_row.type_of_transaction = frm.doc.is_return ? "Inward" : "Outward";
Rohit Waghchaure5bb31732023-03-21 10:54:41 +05302460 } else {
Rohit Waghchaure1c2fe082023-06-15 12:54:43 +05302461 item_row.type_of_transaction = frm.doc.is_return ? "Outward" : "Inward";
Rohit Waghchaure5bb31732023-03-21 10:54:41 +05302462 }
2463
Rohit Waghchaure5bb31732023-03-21 10:54:41 +05302464 new erpnext.SerialBatchPackageSelector(frm, item_row, (r) => {
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05302465 if (r) {
Rohit Waghchaureacd12c52023-06-04 16:09:01 +05302466 let update_values = {
Rohit Waghchaurec1132d12023-03-24 10:14:09 +05302467 "serial_and_batch_bundle": r.name,
2468 "qty": Math.abs(r.total_qty)
Rohit Waghchaureacd12c52023-06-04 16:09:01 +05302469 }
2470
2471 if (r.warehouse) {
2472 update_values[warehouse_field] = r.warehouse;
2473 }
2474
2475 frappe.model.set_value(item_row.doctype, item_row.name, update_values);
Rohit Waghchaure6c9b2122022-12-05 14:48:18 +05302476 }
2477 });
pratu16x7ae450fc2017-06-26 15:31:46 +05302478 });
2479}
marination0f3cfc52020-12-08 19:11:51 +05302480
marinationc47d38d2020-12-14 11:48:04 +05302481erpnext.apply_putaway_rule = (frm, purpose=null) => {
marination0f3cfc52020-12-08 19:11:51 +05302482 if (!frm.doc.company) {
2483 frappe.throw({message: __("Please select a Company first."), title: __("Mandatory")});
2484 }
2485 if (!frm.doc.items.length) return;
2486
2487 frappe.call({
2488 method: "erpnext.stock.doctype.putaway_rule.putaway_rule.apply_putaway_rule",
2489 args: {
2490 doctype: frm.doctype,
2491 items: frm.doc.items,
2492 company: frm.doc.company,
marinationc47d38d2020-12-14 11:48:04 +05302493 sync: true,
2494 purpose: purpose
marination0f3cfc52020-12-08 19:11:51 +05302495 },
2496 callback: (result) => {
2497 if (!result.exc && result.message) {
2498 frm.clear_table("items");
2499
2500 let items = result.message;
2501 items.forEach((row) => {
marinationa5d8d322020-12-09 16:27:18 +05302502 delete row["name"]; // dont overwrite name from server side
marination0f3cfc52020-12-08 19:11:51 +05302503 let child = frm.add_child("items");
2504 Object.assign(child, row);
marinationa5d8d322020-12-09 16:27:18 +05302505 frm.script_manager.trigger("qty", child.doctype, child.name);
marination0f3cfc52020-12-08 19:11:51 +05302506 });
2507 frm.get_field("items").grid.refresh();
2508 }
2509 }
2510 });
casesolved-co-uka7803062021-02-16 05:48:50 +00002511};