blob: a583f7d05b356a385c8ea028f9d84c5dc29f2931 [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
Nabin Haitb4a3dfa2015-01-22 17:13:13 +05304erpnext.TransactionController = erpnext.taxes_and_totals.extend({
Rushabh Mehtabe2ee182016-04-29 17:22:42 +05305 setup: function() {
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +05306 this._super();
Rushabh Mehtabe2ee182016-04-29 17:22:42 +05307 frappe.ui.form.on(this.frm.doctype + " Item", "rate", function(frm, cdt, cdn) {
8 var item = frappe.get_doc(cdt, cdn);
9 frappe.model.round_floats_in(item, ["rate", "price_list_rate"]);
10
11 if(item.price_list_rate) {
12 item.discount_percentage = flt((1 - item.rate / item.price_list_rate) * 100.0, precision("discount_percentage", item));
13 } else {
14 item.discount_percentage = 0.0;
15 }
16
17 cur_frm.cscript.set_gross_profit(item);
18 cur_frm.cscript.calculate_taxes_and_totals();
19 })
20
21 frappe.ui.form.on(this.frm.cscript.tax_table, "rate", function(frm, cdt, cdn) {
22 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053023 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053024
25 frappe.ui.form.on(this.frm.cscript.tax_table, "tax_amount", function(frm, cdt, cdn) {
26 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053027 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053028
29 frappe.ui.form.on(this.frm.cscript.tax_table, "row_id", function(frm, cdt, cdn) {
30 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053031 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053032
33 frappe.ui.form.on(this.frm.cscript.tax_table, "included_in_print_rate", function(frm, cdt, cdn) {
34 cur_frm.cscript.set_dynamic_labels();
35 cur_frm.cscript.calculate_taxes_and_totals();
Rushabh Mehta764aa922016-05-02 13:28:46 +053036 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053037
38 frappe.ui.form.on(this.frm.doctype, "apply_discount_on", function(frm) {
39 if(frm.doc.additional_discount_percentage) {
40 frm.trigger("additional_discount_percentage");
41 } else {
42 cur_frm.cscript.calculate_taxes_and_totals();
43 }
Rushabh Mehta764aa922016-05-02 13:28:46 +053044 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053045
46 frappe.ui.form.on(this.frm.doctype, "additional_discount_percentage", function(frm) {
47 if (frm.via_discount_amount) {
48 return;
49 }
50
51 if(!frm.doc.apply_discount_on) {
52 frappe.msgprint(__("Please set 'Apply Additional Discount On'"));
53 return
54 }
55
56 frm.via_discount_percentage = true;
57
58 if(frm.doc.additional_discount_percentage && frm.doc.discount_amount) {
59 // Reset discount amount and net / grand total
60 frm.set_value("discount_amount", 0);
61 }
62
63 var total = flt(frm.doc[frappe.model.scrub(frm.doc.apply_discount_on)]);
64 var discount_amount = flt(total*flt(frm.doc.additional_discount_percentage) / 100,
65 precision("discount_amount"));
66
67 frm.set_value("discount_amount", discount_amount);
68 delete frm.via_discount_percentage;
69 });
70
71 frappe.ui.form.on(this.frm.doctype, "discount_amount", function(frm) {
72 frm.cscript.set_dynamic_labels();
73
74 if (!frm.via_discount_percentage) {
75 frm.via_discount_amount = true;
76 frm.set_value("additional_discount_percentage", 0);
77 delete frm.via_discount_amount;
78 }
79
80 frm.cscript.calculate_taxes_and_totals();
81 });
Rushabh Mehtabe2ee182016-04-29 17:22:42 +053082 },
Anand Doshi3543f302013-05-24 19:25:01 +053083 onload: function() {
Anand Doshi1e4fb682013-08-23 12:56:33 +053084 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +053085 if(this.frm.doc.__islocal) {
Anand Doshi1e4fb682013-08-23 12:56:33 +053086 var today = get_today(),
Nabin Hait73083dc2014-03-14 15:10:42 +053087 currency = frappe.defaults.get_user_default("currency");
Rushabh Mehtaff938022014-04-15 18:40:00 +053088
Anand Doshi3543f302013-05-24 19:25:01 +053089 $.each({
Anand Doshifc777182013-05-27 19:29:07 +053090 currency: currency,
91 price_list_currency: currency,
92 status: "Draft",
Anand Doshifc777182013-05-27 19:29:07 +053093 is_subcontracted: "No",
Anand Doshi3543f302013-05-24 19:25:01 +053094 }, function(fieldname, value) {
95 if(me.frm.fields_dict[fieldname] && !me.frm.doc[fieldname])
96 me.frm.set_value(fieldname, value);
Rushabh Mehtaff938022014-04-15 18:40:00 +053097 });
nabinhaitbc408d82014-07-07 16:51:52 +053098
nabinhaitb7392642014-07-28 14:55:08 +053099 if(this.frm.doc.company && !this.frm.doc.amended_from) {
Rushabh Mehtab66edd12017-03-30 21:21:56 +0530100 this.frm.trigger("company");
nabinhaitbc408d82014-07-07 16:51:52 +0530101 }
Anand Doshi3543f302013-05-24 19:25:01 +0530102 }
Akhilesh Darjee564c6212013-10-17 11:31:11 +0530103
Nabin Haitdd38a262014-12-26 13:15:21 +0530104 if(this.frm.fields_dict["taxes"]) {
105 this["taxes_remove"] = this.calculate_taxes_and_totals;
Anand Doshia91c95f2013-08-23 13:00:47 +0530106 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530107
Nabin Haitdd38a262014-12-26 13:15:21 +0530108 if(this.frm.fields_dict["items"]) {
109 this["items_remove"] = this.calculate_taxes_and_totals;
Anand Doshi1e4fb682013-08-23 12:56:33 +0530110 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530111
Neil Trini Lasradoe2d8dd02015-06-22 19:06:15 +0530112 if(this.frm.fields_dict["recurring_print_format"]) {
113 this.frm.set_query("recurring_print_format", function(doc) {
114 return{
115 filters: [
116 ['Print Format', 'doc_type', '=', cur_frm.doctype],
117 ]
118 }
119 });
120 }
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530121
Nabin Hait1d218422015-07-17 15:19:02 +0530122 if(this.frm.fields_dict["return_against"]) {
123 this.frm.set_query("return_against", function(doc) {
124 var filters = {
125 "docstatus": 1,
126 "is_return": 0,
127 "company": doc.company
128 };
129 if (me.frm.fields_dict["customer"] && doc.customer) filters["customer"] = doc.customer;
130 if (me.frm.fields_dict["supplier"] && doc.supplier) filters["supplier"] = doc.supplier;
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530131
Nabin Hait1d218422015-07-17 15:19:02 +0530132 return {
133 filters: filters
134 }
135 });
136 }
Rushabh Mehta6b537922017-03-14 16:59:11 +0530137
Nabin Hait8af429d2016-11-16 17:21:59 +0530138 this.setup_quality_inspection();
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530139 },
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530140
Nabin Hait8af429d2016-11-16 17:21:59 +0530141 setup_quality_inspection: function() {
142 if(!in_list(["Delivery Note", "Sales Invoice", "Purchase Receipt", "Purchase Invoice"], this.frm.doc.doctype)) {
143 return;
144 }
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530145 var me = this;
Rushabh Mehta6b537922017-03-14 16:59:11 +0530146 var inspection_type = in_list(["Purchase Receipt", "Purchase Invoice"], this.frm.doc.doctype)
Nabin Hait8af429d2016-11-16 17:21:59 +0530147 ? "Incoming" : "Outgoing";
Rushabh Mehta6b537922017-03-14 16:59:11 +0530148
Manas Solankia8d1bc72016-11-15 14:48:23 +0530149 var quality_inspection_field = this.frm.get_docfield("items", "quality_inspection");
Nabin Hait8af429d2016-11-16 17:21:59 +0530150 quality_inspection_field.get_route_options_for_new_doc = function(row) {
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530151 if(me.frm.is_new()) return;
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530152 return {
153 "inspection_type": inspection_type,
Manas Solanki34feab12016-11-16 14:36:28 +0530154 "reference_type": me.frm.doc.doctype,
Manas Solankidbc25112016-11-16 15:06:08 +0530155 "reference_name": me.frm.doc.name,
Nabin Hait8af429d2016-11-16 17:21:59 +0530156 "item_code": row.doc.item_code,
157 "description": row.doc.description,
158 "item_serial_no": row.doc.serial_no ? row.doc.serial_no.split("\n")[0] : null,
159 "batch_no": row.doc.batch_no
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530160 }
161 }
Rushabh Mehta6b537922017-03-14 16:59:11 +0530162
Manas Solankic2cd3fd2016-11-14 21:57:05 +0530163 this.frm.set_query("quality_inspection", "items", function(doc, cdt, cdn) {
164 var d = locals[cdt][cdn];
165 return {
166 filters: {
167 docstatus: 1,
168 inspection_type: inspection_type,
169 item_code: d.item_code
170 }
171 }
172 });
Anand Doshi3543f302013-05-24 19:25:01 +0530173 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530174
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530175 onload_post_render: function() {
Akhilesh Darjee61b5c592013-10-15 20:24:34 +0530176 var me = this;
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530177 if(this.frm.doc.__islocal && !(this.frm.doc.taxes || []).length
178 && !(this.frm.doc.__onload ? this.frm.doc.__onload.load_after_mapping : false)) {
179 this.apply_default_taxes();
Anand Doshi70f57eb2015-11-27 14:37:40 +0530180 } else if(this.frm.doc.__islocal && this.frm.doc.company && this.frm.doc["items"]
Nabin Haitbdfb0702015-10-28 15:38:08 +0530181 && !this.frm.doc.is_pos) {
182 me.calculate_taxes_and_totals();
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530183 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530184 if(frappe.meta.get_docfield(this.frm.doc.doctype + " Item", "item_code")) {
Rushabh Mehta203cc962016-04-07 15:25:43 +0530185 this.setup_item_selector();
Rushabh Mehtab6843f22014-06-04 13:10:41 +0530186 }
Anand Doshi5e4e5d72013-08-06 17:23:44 +0530187 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530188
Anand Doshi3543f302013-05-24 19:25:01 +0530189 refresh: function() {
Anand Doshi8bde7f92014-04-24 18:11:49 +0530190 erpnext.toggle_naming_series();
Anand Doshibdee6e02013-07-09 13:03:39 +0530191 erpnext.hide_company();
Anand Doshi3543f302013-05-24 19:25:01 +0530192 this.show_item_wise_taxes();
Nabin Hait1f996c32013-07-29 19:00:53 +0530193 this.set_dynamic_labels();
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530194 this.setup_sms();
195 },
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530196
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530197 apply_default_taxes: function() {
198 var me = this;
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530199 var taxes_and_charges_field = frappe.meta.get_docfield(me.frm.doc.doctype, "taxes_and_charges",
200 me.frm.doc.name);
201
202 if(taxes_and_charges_field) {
Nabin Haitbdfb0702015-10-28 15:38:08 +0530203 return frappe.call({
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530204 method: "erpnext.controllers.accounts_controller.get_default_taxes_and_charges",
205 args: {
206 "master_doctype": taxes_and_charges_field.options
207 },
208 callback: function(r) {
209 if(!r.exc) {
210 me.frm.set_value("taxes", r.message);
Nabin Haitbdfb0702015-10-28 15:38:08 +0530211 me.calculate_taxes_and_totals();
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530212 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530213 }
Rushabh Mehta4984bcc2015-05-21 12:51:07 +0530214 });
215 }
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530216 },
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530217
218 setup_sms: function() {
219 var me = this;
Nabin Hait7132bd32016-04-13 15:19:37 +0530220 if(this.frm.doc.docstatus===1 && !in_list(["Lost", "Stopped", "Closed"], this.frm.doc.status)
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530221 && this.frm.doctype != "Purchase Invoice") {
Rushabh Mehta614e7ab2015-02-18 19:51:48 +0530222 this.frm.page.add_menu_item(__('Send SMS'), function() { me.send_sms(); });
223 }
224 },
225
226 send_sms: function() {
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530227 var sms_man = new SMSManager(this.frm.doc);
Nabin Hait239c2c32015-01-15 14:21:41 +0530228 },
Anand Doshi50d7e8c2015-01-06 17:14:13 +0530229
Neil Trini Lasradod0151952015-06-09 15:21:50 +0530230 barcode: function(doc, cdt, cdn) {
231 var d = locals[cdt][cdn];
232 if(d.barcode=="" || d.barcode==null) {
233 // barcode cleared, remove item
234 d.item_code = "";
235 }
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530236 this.item_code(doc, cdt, cdn, true);
Neil Trini Lasradod0151952015-06-09 15:21:50 +0530237 },
238
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530239 item_code: function(doc, cdt, cdn, from_barcode) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530240 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530241 var item = frappe.get_doc(cdt, cdn);
Rushabh Mehta675f9c62016-06-02 16:34:00 +0530242
243 // clear barcode if setting item (else barcode will take priority)
244 if(!from_barcode) {
245 item.barcode = null;
246 }
Nabin Hait139dc7b2014-02-12 14:53:18 +0530247 if(item.item_code || item.barcode || item.serial_no) {
248 if(!this.validate_company_and_party()) {
Nabin Haitdd38a262014-12-26 13:15:21 +0530249 cur_frm.fields_dict["items"].grid.grid_rows[item.idx - 1].remove();
Nabin Hait139dc7b2014-02-12 14:53:18 +0530250 } else {
251 return this.frm.call({
252 method: "erpnext.stock.get_item_details.get_item_details",
253 child: item,
254 args: {
255 args: {
256 item_code: item.item_code,
257 barcode: item.barcode,
258 serial_no: item.serial_no,
259 warehouse: item.warehouse,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530260 customer: me.frm.doc.customer,
261 supplier: me.frm.doc.supplier,
262 currency: me.frm.doc.currency,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530263 update_stock: in_list(['Sales Invoice', 'Purchase Invoice'], me.frm.doc.doctype) ? cint(me.frm.doc.update_stock) : 0,
Nabin Hait139dc7b2014-02-12 14:53:18 +0530264 conversion_rate: me.frm.doc.conversion_rate,
265 price_list: me.frm.doc.selling_price_list ||
266 me.frm.doc.buying_price_list,
267 price_list_currency: me.frm.doc.price_list_currency,
268 plc_conversion_rate: me.frm.doc.plc_conversion_rate,
269 company: me.frm.doc.company,
270 order_type: me.frm.doc.order_type,
271 is_pos: cint(me.frm.doc.is_pos),
272 is_subcontracted: me.frm.doc.is_subcontracted,
Nabin Haita1bf43b2015-03-17 10:50:47 +0530273 transaction_date: me.frm.doc.transaction_date || me.frm.doc.posting_date,
Nabin Hait444f9562014-06-20 15:59:49 +0530274 ignore_pricing_rule: me.frm.doc.ignore_pricing_rule,
Anand Doshiafe85bd2016-01-21 21:04:16 +0530275 doctype: me.frm.doc.doctype,
276 name: me.frm.doc.name,
Neil Trini Lasrado6e343e22016-03-09 17:02:59 +0530277 project: item.project || me.frm.doc.project,
Nabin Haite68f32c2017-03-03 15:00:41 +0530278 qty: item.qty,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530279 stock_qty: item.stock_qty,
280 conversion_factor: item.conversion_factor
Nabin Hait139dc7b2014-02-12 14:53:18 +0530281 }
282 },
Anand Doshi13945092014-09-21 19:45:49 +0530283
Nabin Hait139dc7b2014-02-12 14:53:18 +0530284 callback: function(r) {
285 if(!r.exc) {
286 me.frm.script_manager.trigger("price_list_rate", cdt, cdn);
287 }
288 }
289 });
290 }
291 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530292 },
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530293
294 serial_no: function(doc, cdt, cdn) {
295 var me = this;
Rushabh Mehta66d52b52014-03-27 14:17:33 +0530296 var item = frappe.get_doc(cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530297
298 if (item.serial_no) {
299 if (!item.item_code) {
Rushabh Mehtab66edd12017-03-30 21:21:56 +0530300 this.frm.trigger("item_code", cdt, cdn);
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530301 }
302 else {
303 var sr_no = [];
304
305 // Replacing all occurences of comma with carriage return
306 var serial_nos = item.serial_no.trim().replace(/,/g, '\n');
307
308 serial_nos = serial_nos.trim().split('\n');
Rushabh Mehtaff938022014-04-15 18:40:00 +0530309
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530310 // Trim each string and push unique string to new list
311 for (var x=0; x<=serial_nos.length - 1; x++) {
312 if (serial_nos[x].trim() != "" && sr_no.indexOf(serial_nos[x].trim()) == -1) {
313 sr_no.push(serial_nos[x].trim());
314 }
315 }
316
317 // Add the new list to the serial no. field in grid with each in new line
318 item.serial_no = "";
319 for (var x=0; x<=sr_no.length - 1; x++)
320 item.serial_no += sr_no[x] + '\n';
321
322 refresh_field("serial_no", item.name, item.parentfield);
Nabin Haitb7c0c552015-08-04 12:18:12 +0530323 if(!doc.is_return) {
Rushabh Mehta6b537922017-03-14 16:59:11 +0530324 frappe.model.set_value(item.doctype, item.name,
Nabin Haite68f32c2017-03-03 15:00:41 +0530325 "qty", sr_no.length / item.conversion_factor);
326 frappe.model.set_value(item.doctype, item.name, "stock_qty", sr_no.length);
Nabin Haitb7c0c552015-08-04 12:18:12 +0530327 }
Akhilesh Darjeefcd70d02013-10-18 14:24:21 +0530328 }
329 }
330 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530331
Anand Doshi923d41d2013-05-28 17:23:36 +0530332 validate: function() {
Anand Doshi652bc072014-04-16 15:21:46 +0530333 this.calculate_taxes_and_totals(false);
Anand Doshi923d41d2013-05-28 17:23:36 +0530334 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530335
Anand Doshi3543f302013-05-24 19:25:01 +0530336 company: function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530337 var me = this;
Nabin Haita731ad42016-02-04 17:21:28 +0530338 var set_pricing = function() {
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530339 if(me.frm.doc.company && me.frm.fields_dict.currency) {
340 var company_currency = me.get_company_currency();
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530341 var company_doc = frappe.get_doc(":Company", me.frm.doc.company);
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530342 if (!me.frm.doc.currency) {
343 me.frm.set_value("currency", company_currency);
344 }
Rushabh Mehtaff938022014-04-15 18:40:00 +0530345
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530346 if (me.frm.doc.currency == company_currency) {
347 me.frm.set_value("conversion_rate", 1.0);
348 }
349 if (me.frm.doc.price_list_currency == company_currency) {
350 me.frm.set_value('plc_conversion_rate', 1.0);
351 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530352 if (company_doc.default_letter_head) {
Rushabh Mehtac1857342015-05-27 12:29:57 +0530353 if(me.frm.fields_dict.letter_head) {
354 me.frm.set_value("letter_head", company_doc.default_letter_head);
355 }
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530356 }
Rohit Waghchaure585448b2016-12-30 15:41:55 +0530357 if (company_doc.default_terms && me.frm.doc.doctype != "Purchase Invoice" && frappe.meta.has_field(me.frm.doc.doctype, "tc_name")) {
Rushabh Mehta5495bc52015-05-19 12:00:34 +0530358 me.frm.set_value("tc_name", company_doc.default_terms);
359 }
Akhilesh Darjee1797cfe2013-10-11 13:34:10 +0530360
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530361 me.frm.script_manager.trigger("currency");
362 me.apply_pricing_rule();
Nabin Haitdd38a262014-12-26 13:15:21 +0530363 }
Anand Doshi3543f302013-05-24 19:25:01 +0530364 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530365
Nabin Haita731ad42016-02-04 17:21:28 +0530366 var set_party_account = function(set_pricing) {
367 if (in_list(["Sales Invoice", "Purchase Invoice"], me.frm.doc.doctype)) {
368 if(me.frm.doc.doctype=="Sales Invoice") {
369 var party_type = "Customer";
370 var party_account_field = 'debit_to';
371 } else {
372 var party_type = "Supplier";
373 var party_account_field = 'credit_to';
374 }
Anand Doshi39a28912016-02-15 11:42:18 +0530375
Nabin Haitef864402016-02-10 14:47:25 +0530376 var party = me.frm.doc[frappe.model.scrub(party_type)];
377 if(party) {
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530378 return frappe.call({
379 method: "erpnext.accounts.party.get_party_account",
380 args: {
381 company: me.frm.doc.company,
382 party_type: party_type,
Nabin Haitef864402016-02-10 14:47:25 +0530383 party: party
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530384 },
385 callback: function(r) {
386 if(!r.exc && r.message) {
387 me.frm.set_value(party_account_field, r.message);
388 set_pricing();
389 }
Nabin Haita731ad42016-02-04 17:21:28 +0530390 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530391 });
Nabin Haitef864402016-02-10 14:47:25 +0530392 } else {
393 set_pricing();
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530394 }
Nabin Haita731ad42016-02-04 17:21:28 +0530395 } else {
396 set_pricing();
397 }
Rushabh Mehta8d1c7a22016-02-10 13:08:42 +0530398
Nabin Haita731ad42016-02-04 17:21:28 +0530399 }
Nabin Haitdd38a262014-12-26 13:15:21 +0530400
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530401 if (this.frm.doc.posting_date) var date = this.frm.doc.posting_date;
402 else var date = this.frm.doc.transaction_date;
Rushabh Mehta5dfe20c2016-04-26 12:59:08 +0530403
404 if (frappe.meta.get_docfield(this.frm.doctype, "shipping_address") &&
Rohit Waghchaureb2e7a1f2016-04-11 12:10:20 +0530405 in_list(['Purchase Order', 'Purchase Receipt', 'Purchase Invoice'], this.frm.doctype)){
406 erpnext.utils.get_shipping_address(this.frm, function(){
407 set_party_account(set_pricing);
408 })
409 }else{
410 set_party_account(set_pricing);
411 }
Rushabh Mehta45ca8a42015-04-28 16:02:09 +0530412
413 if(this.frm.doc.company) {
414 erpnext.last_selected_company = this.frm.doc.company;
415 }
Neil Trini Lasradoeaae58f2014-10-09 15:00:10 +0530416 },
417
418 transaction_date: function() {
Anand Doshi87da6622015-10-19 14:59:32 +0530419 if (this.frm.doc.transaction_date) {
420 this.frm.transaction_date = this.frm.doc.transaction_date;
Nabin Hait288a18e2016-12-08 15:36:23 +0530421 frappe.ui.form.trigger(this.frm.doc.doctype, "currency");
Anand Doshi87da6622015-10-19 14:59:32 +0530422 }
Neil Trini Lasrado78fa6952014-10-03 17:43:02 +0530423 },
424
425 posting_date: function() {
Nabin Hait40e92b62015-07-09 17:12:23 +0530426 var me = this;
427 if (this.frm.doc.posting_date) {
Anand Doshi87da6622015-10-19 14:59:32 +0530428 this.frm.posting_date = this.frm.doc.posting_date;
429
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530430 if ((this.frm.doc.doctype == "Sales Invoice" && this.frm.doc.customer) ||
Nabin Hait40e92b62015-07-09 17:12:23 +0530431 (this.frm.doc.doctype == "Purchase Invoice" && this.frm.doc.supplier)) {
432 return frappe.call({
433 method: "erpnext.accounts.party.get_due_date",
434 args: {
435 "posting_date": me.frm.doc.posting_date,
436 "party_type": me.frm.doc.doctype == "Sales Invoice" ? "Customer" : "Supplier",
437 "party": me.frm.doc.doctype == "Sales Invoice" ? me.frm.doc.customer : me.frm.doc.supplier,
438 "company": me.frm.doc.company
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530439 },
Nabin Hait40e92b62015-07-09 17:12:23 +0530440 callback: function(r, rt) {
441 if(r.message) {
442 me.frm.set_value("due_date", r.message);
Nabin Hait87d70272016-12-08 14:43:11 +0530443 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
Nabin Hait40e92b62015-07-09 17:12:23 +0530444 }
Nabin Hait40e92b62015-07-09 17:12:23 +0530445 }
446 })
Nabin Hait87d70272016-12-08 14:43:11 +0530447 } else {
448 frappe.ui.form.trigger(me.frm.doc.doctype, "currency");
Nabin Hait40e92b62015-07-09 17:12:23 +0530449 }
450 }
Anand Doshi3543f302013-05-24 19:25:01 +0530451 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530452
Anand Doshi3543f302013-05-24 19:25:01 +0530453 get_company_currency: function() {
454 return erpnext.get_currency(this.frm.doc.company);
455 },
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530456
Neil Trini Lasrado09a66c42015-07-07 16:41:37 +0530457 contact_person: function() {
458 erpnext.utils.get_contact_details(this.frm);
459 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530460
Anand Doshi3543f302013-05-24 19:25:01 +0530461 currency: function() {
Chude Osiegbu256ec172016-09-19 03:53:37 +0100462 /* manqala 19/09/2016: let the translation date be whichever of the transaction_date or posting_date is available */
Nabin Hait288a18e2016-12-08 15:36:23 +0530463 var transaction_date = this.frm.doc.transaction_date || this.frm.doc.posting_date;
Chude Osiegbu256ec172016-09-19 03:53:37 +0100464 /* end manqala */
Rushabh Mehta6b537922017-03-14 16:59:11 +0530465
Anand Doshi61a2f682013-06-21 17:55:31 +0530466 var me = this;
467 this.set_dynamic_labels();
Akhilesh Darjee78378272013-10-11 19:06:30 +0530468
Anand Doshi61a2f682013-06-21 17:55:31 +0530469 var company_currency = this.get_company_currency();
Nabin Hait69cdf592015-05-02 18:46:10 +0530470 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
Rushabh Mehta76b13412016-07-18 14:30:18 +0530471 if(this.frm.doc.currency && this.frm.doc.currency !== company_currency
Nabin Hait39505072016-07-07 11:11:32 +0530472 && !this.frm.doc.ignore_pricing_rule) {
Nabin Hait288a18e2016-12-08 15:36:23 +0530473 this.get_exchange_rate(transaction_date, this.frm.doc.currency, company_currency,
Anand Doshi61a2f682013-06-21 17:55:31 +0530474 function(exchange_rate) {
Akhilesh Darjee78378272013-10-11 19:06:30 +0530475 me.frm.set_value("conversion_rate", exchange_rate);
Anand Doshi61a2f682013-06-21 17:55:31 +0530476 });
477 } else {
Rushabh Mehtaff938022014-04-15 18:40:00 +0530478 this.conversion_rate();
Anand Doshi61a2f682013-06-21 17:55:31 +0530479 }
480 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530481
Anand Doshi61a2f682013-06-21 17:55:31 +0530482 conversion_rate: function() {
Anand Doshi535d8332013-07-19 13:51:07 +0530483 if(this.frm.doc.currency === this.get_company_currency()) {
484 this.frm.set_value("conversion_rate", 1.0);
Akhilesh Darjeeacf65a72013-10-17 13:04:26 +0530485 }
486 if(this.frm.doc.currency === this.frm.doc.price_list_currency &&
Anand Doshi61a2f682013-06-21 17:55:31 +0530487 this.frm.doc.plc_conversion_rate !== this.frm.doc.conversion_rate) {
488 this.frm.set_value("plc_conversion_rate", this.frm.doc.conversion_rate);
489 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530490
Nabin Haita3dd72a2014-05-28 12:49:20 +0530491 if(flt(this.frm.doc.conversion_rate)>0.0) {
Nabin Hait444f9562014-06-20 15:59:49 +0530492 if(this.frm.doc.ignore_pricing_rule) {
493 this.calculate_taxes_and_totals();
Anand Doshi51f722d2014-07-04 15:44:26 +0530494 } else if (!this.in_apply_price_list){
495 this.apply_price_list();
Nabin Hait444f9562014-06-20 15:59:49 +0530496 }
497
Nabin Haita3dd72a2014-05-28 12:49:20 +0530498 }
Anand Doshi3543f302013-05-24 19:25:01 +0530499 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530500
Nabin Hait288a18e2016-12-08 15:36:23 +0530501 get_exchange_rate: function(transaction_date, from_currency, to_currency, callback) {
Nabin Haitbdfb0702015-10-28 15:38:08 +0530502 return frappe.call({
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +0530503 method: "erpnext.setup.utils.get_exchange_rate",
504 args: {
Nabin Hait288a18e2016-12-08 15:36:23 +0530505 transaction_date: transaction_date,
Rushabh Mehta66fa1ff2015-05-07 12:25:33 +0530506 from_currency: from_currency,
507 to_currency: to_currency
508 },
509 callback: function(r) {
510 callback(flt(r.message));
511 }
Anand Doshi61a2f682013-06-21 17:55:31 +0530512 });
513 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530514
Anand Doshi3543f302013-05-24 19:25:01 +0530515 price_list_currency: function() {
Akhilesh Darjeedb59ffb2013-09-11 13:05:24 +0530516 var me=this;
Anand Doshi3543f302013-05-24 19:25:01 +0530517 this.set_dynamic_labels();
Nabin Haitec361ea2015-05-11 18:14:45 +0530518
519 var company_currency = this.get_company_currency();
520 // Added `ignore_pricing_rule` to determine if document is loading after mapping from another doc
521 if(this.frm.doc.price_list_currency !== company_currency && !this.frm.doc.ignore_pricing_rule) {
Chude Osiegbufbf27b52016-09-07 03:06:08 +0100522 this.get_exchange_rate(this.frm.doc.posting_date, this.frm.doc.price_list_currency, company_currency,
Nabin Haitec361ea2015-05-11 18:14:45 +0530523 function(exchange_rate) {
524 me.frm.set_value("plc_conversion_rate", exchange_rate);
525 });
526 } else {
527 this.plc_conversion_rate();
528 }
Anand Doshi3543f302013-05-24 19:25:01 +0530529 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530530
Anand Doshi3543f302013-05-24 19:25:01 +0530531 plc_conversion_rate: function() {
Anand Doshi61a2f682013-06-21 17:55:31 +0530532 if(this.frm.doc.price_list_currency === this.get_company_currency()) {
533 this.frm.set_value("plc_conversion_rate", 1.0);
Rushabh Mehtaa208c562015-08-03 13:18:54 +0530534 } else if(this.frm.doc.price_list_currency === this.frm.doc.currency
Nabin Hait1d218422015-07-17 15:19:02 +0530535 && this.frm.doc.plc_conversion_rate && cint(this.frm.doc.plc_conversion_rate) != 1 &&
Nabin Haitec361ea2015-05-11 18:14:45 +0530536 cint(this.frm.doc.plc_conversion_rate) != cint(this.frm.doc.conversion_rate)) {
537 this.frm.set_value("conversion_rate", this.frm.doc.plc_conversion_rate);
Akhilesh Darjee564c6212013-10-17 11:31:11 +0530538 }
Rushabh Mehta4a3c8052015-05-19 11:10:12 +0530539
Nabin Haitec361ea2015-05-11 18:14:45 +0530540 if(!this.in_apply_price_list) {
541 this.apply_price_list();
Anand Doshi61a2f682013-06-21 17:55:31 +0530542 }
Anand Doshi3543f302013-05-24 19:25:01 +0530543 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530544
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +0530545 uom: function(doc, cdt, cdn) {
546 var me = this;
547 var item = frappe.get_doc(cdt, cdn);
548 if(item.item_code && item.uom) {
549 return this.frm.call({
550 method: "erpnext.stock.get_item_details.get_conversion_factor",
551 child: item,
552 args: {
553 item_code: item.item_code,
554 uom: item.uom
555 },
556 callback: function(r) {
557 if(!r.exc) {
558 me.conversion_factor(me.frm.doc, cdt, cdn);
559 }
560 }
561 });
562 }
563 },
564
565 conversion_factor: function(doc, cdt, cdn) {
566 if(frappe.meta.get_docfield(cdt, "stock_qty", cdn)) {
567 var item = frappe.get_doc(cdt, cdn);
568 frappe.model.round_floats_in(item, ["qty", "conversion_factor"]);
569 item.stock_qty = flt(item.qty * item.conversion_factor, precision("stock_qty", item));
570 refresh_field("stock_qty", item.name, item.parentfield);
571 }
572 },
573
Anand Doshi3543f302013-05-24 19:25:01 +0530574 qty: function(doc, cdt, cdn) {
Nabin Hait444f9562014-06-20 15:59:49 +0530575 this.apply_pricing_rule(frappe.get_doc(cdt, cdn), true);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +0530576 this.conversion_factor(doc, cdt, cdn);
Anand Doshi3543f302013-05-24 19:25:01 +0530577 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530578
Anand Doshi61a2f682013-06-21 17:55:31 +0530579 set_dynamic_labels: function() {
580 // What TODO? should we make price list system non-mandatory?
581 this.frm.toggle_reqd("plc_conversion_rate",
582 !!(this.frm.doc.price_list_name && this.frm.doc.price_list_currency));
Rushabh Mehtaff938022014-04-15 18:40:00 +0530583
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +0530584 if(this.frm.doc_currency!==this.frm.doc.currency) {
585 // reset names only when the currency is different
586
587 var company_currency = this.get_company_currency();
588 this.change_form_labels(company_currency);
589 this.change_grid_labels(company_currency);
590 this.frm.refresh_fields();
591 this.frm.doc_currency = this.frm.doc.currency;
592 }
Anand Doshi61a2f682013-06-21 17:55:31 +0530593 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530594
Nabin Hait613d0812015-02-23 11:58:15 +0530595 change_form_labels: function(company_currency) {
596 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +0530597
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530598 this.frm.set_currency_labels(["base_total", "base_net_total", "base_total_taxes_and_charges",
Nabin Hait613d0812015-02-23 11:58:15 +0530599 "base_discount_amount", "base_grand_total", "base_rounded_total", "base_in_words",
600 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted", "total_amount_to_pay",
Rushabh Mehta6b537922017-03-14 16:59:11 +0530601 "base_paid_amount", "base_write_off_amount", "base_change_amount", "base_operating_cost",
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530602 "base_raw_material_cost", "base_total_cost", "base_scrap_material_cost"
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530603 ], company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +0530604
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530605 this.frm.set_currency_labels(["total", "net_total", "total_taxes_and_charges", "discount_amount",
Nabin Hait613d0812015-02-23 11:58:15 +0530606 "grand_total", "taxes_and_charges_added", "taxes_and_charges_deducted",
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530607 "rounded_total", "in_words", "paid_amount", "write_off_amount", "operating_cost", "scrap_material_cost",
608 "raw_material_cost", "total_cost"], this.frm.doc.currency);
Anand Doshi87da6622015-10-19 14:59:32 +0530609
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530610 this.frm.set_currency_labels(["outstanding_amount", "total_advance"], this.frm.doc.party_account_currency);
Nabin Hait613d0812015-02-23 11:58:15 +0530611
612 cur_frm.set_df_property("conversion_rate", "description", "1 " + this.frm.doc.currency
613 + " = [?] " + company_currency)
614
615 if(this.frm.doc.price_list_currency && this.frm.doc.price_list_currency!=company_currency) {
616 cur_frm.set_df_property("plc_conversion_rate", "description", "1 " + this.frm.doc.price_list_currency
617 + " = [?] " + company_currency)
618 }
619
620 // toggle fields
621 this.frm.toggle_display(["conversion_rate", "base_total", "base_net_total", "base_total_taxes_and_charges",
622 "base_taxes_and_charges_added", "base_taxes_and_charges_deducted",
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530623 "base_grand_total", "base_rounded_total", "base_in_words", "base_discount_amount",
Rushabh Mehta6b537922017-03-14 16:59:11 +0530624 "base_paid_amount", "base_write_off_amount", "base_operating_cost",
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530625 "base_raw_material_cost", "base_total_cost", "base_scrap_material_cost"],
Nabin Hait613d0812015-02-23 11:58:15 +0530626 this.frm.doc.currency != company_currency);
627
628 this.frm.toggle_display(["plc_conversion_rate", "price_list_currency"],
629 this.frm.doc.price_list_currency != company_currency);
630
Nabin Hait903c42a2015-02-24 15:24:49 +0530631 var show =cint(cur_frm.doc.discount_amount) ||
632 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
633
634 if(frappe.meta.get_docfield(cur_frm.doctype, "net_total"))
635 cur_frm.toggle_display("net_total", show);
636
637 if(frappe.meta.get_docfield(cur_frm.doctype, "base_net_total"))
638 cur_frm.toggle_display("base_net_total", (show && (me.frm.doc.currency != company_currency)));
639
Nabin Hait613d0812015-02-23 11:58:15 +0530640 },
641
642 change_grid_labels: function(company_currency) {
643 var me = this;
Nabin Hait613d0812015-02-23 11:58:15 +0530644
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530645 this.frm.set_currency_labels(["base_rate", "base_net_rate", "base_price_list_rate", "base_amount", "base_net_amount"],
646 company_currency, "items");
647
648 this.frm.set_currency_labels(["rate", "net_rate", "price_list_rate", "amount", "net_amount"],
649 this.frm.doc.currency, "items");
650
651 if(this.frm.fields_dict["operations"]) {
652 this.frm.set_currency_labels(["operating_cost", "hour_rate"], this.frm.doc.currency, "operations");
653 this.frm.set_currency_labels(["base_operating_cost", "base_hour_rate"], company_currency, "operations");
654
655 var item_grid = this.frm.fields_dict["operations"].grid;
656 $.each(["base_operating_cost", "base_hour_rate"], function(i, fname) {
657 if(frappe.meta.get_docfield(item_grid.doctype, fname))
658 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
Nabin Hait613d0812015-02-23 11:58:15 +0530659 });
660 }
661
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530662 if(this.frm.fields_dict["scrap_items"]) {
663 this.frm.set_currency_labels(["rate", "amount"], this.frm.doc.currency, "scrap_items");
664 this.frm.set_currency_labels(["base_rate", "base_amount"], company_currency, "scrap_items");
Nabin Hait613d0812015-02-23 11:58:15 +0530665
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530666 var item_grid = this.frm.fields_dict["scrap_items"].grid;
667 $.each(["base_rate", "base_amount"], function(i, fname) {
668 if(frappe.meta.get_docfield(item_grid.doctype, fname))
669 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
670 });
671 }
Nabin Hait613d0812015-02-23 11:58:15 +0530672
673 if(this.frm.fields_dict["taxes"]) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530674 this.frm.set_currency_labels(["tax_amount", "total", "tax_amount_after_discount"], this.frm.doc.currency, "taxes");
Nabin Hait613d0812015-02-23 11:58:15 +0530675
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530676 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 +0530677 }
678
679 if(this.frm.fields_dict["advances"]) {
Rohit Waghchaureb1b32882016-10-21 19:31:54 +0530680 this.frm.set_currency_labels(["advance_amount", "allocated_amount"],
Nabin Haitaa015902015-10-16 13:08:33 +0530681 this.frm.doc.party_account_currency, "advances");
Nabin Hait613d0812015-02-23 11:58:15 +0530682 }
683
684 // toggle columns
685 var item_grid = this.frm.fields_dict["items"].grid;
686 $.each(["base_rate", "base_price_list_rate", "base_amount"], function(i, fname) {
687 if(frappe.meta.get_docfield(item_grid.doctype, fname))
688 item_grid.set_column_disp(fname, me.frm.doc.currency != company_currency);
689 });
690
691 var show = (cint(cur_frm.doc.discount_amount)) ||
692 ((cur_frm.doc.taxes || []).filter(function(d) {return d.included_in_print_rate===1}).length);
693
694 $.each(["net_rate", "net_amount"], function(i, fname) {
695 if(frappe.meta.get_docfield(item_grid.doctype, fname))
696 item_grid.set_column_disp(fname, show);
697 });
698
699 $.each(["base_net_rate", "base_net_amount"], function(i, fname) {
700 if(frappe.meta.get_docfield(item_grid.doctype, fname))
701 item_grid.set_column_disp(fname, (show && (me.frm.doc.currency != company_currency)));
702 });
703
704 // set labels
705 var $wrapper = $(this.frm.wrapper);
Nabin Hait613d0812015-02-23 11:58:15 +0530706 },
707
Anand Doshi923d41d2013-05-28 17:23:36 +0530708 recalculate: function() {
709 this.calculate_taxes_and_totals();
710 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530711
Anand Doshi923d41d2013-05-28 17:23:36 +0530712 recalculate_values: function() {
713 this.calculate_taxes_and_totals();
714 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530715
Anand Doshid0b00722013-05-28 18:54:48 +0530716 calculate_charges: function() {
717 this.calculate_taxes_and_totals();
718 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530719
Nabin Hait444f9562014-06-20 15:59:49 +0530720 ignore_pricing_rule: function() {
721 this.apply_pricing_rule();
722 },
723
724 apply_pricing_rule: function(item, calculate_taxes_and_totals) {
Nabin Haita3dd72a2014-05-28 12:49:20 +0530725 var me = this;
Anand Doshi70f57eb2015-11-27 14:37:40 +0530726 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530727 if (!(args.items && args.items.length)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +0530728 if(calculate_taxes_and_totals) me.calculate_taxes_and_totals();
729 return;
730 }
731
Anand Doshidffec8f2014-07-01 17:45:15 +0530732 return this.frm.call({
733 method: "erpnext.accounts.doctype.pricing_rule.pricing_rule.apply_pricing_rule",
Anand Doshi70f57eb2015-11-27 14:37:40 +0530734 args: { args: args },
Anand Doshidffec8f2014-07-01 17:45:15 +0530735 callback: function(r) {
Anand Doshif214bfc2014-07-16 17:52:08 +0530736 if (!r.exc && r.message) {
Anand Doshidffec8f2014-07-01 17:45:15 +0530737 me._set_values_for_item_list(r.message);
Saurabh2d7af632016-02-26 11:09:20 +0530738 if(item) me.set_gross_profit(item);
Anand Doshidffec8f2014-07-01 17:45:15 +0530739 if(calculate_taxes_and_totals) me.calculate_taxes_and_totals();
Rohit Waghchauredeaee7c2016-09-22 14:02:53 +0530740 if(me.frm.doc.apply_discount_on) me.frm.trigger("apply_discount_on")
Anand Doshidffec8f2014-07-01 17:45:15 +0530741 }
742 }
743 });
744 },
745
746 _get_args: function(item) {
747 var me = this;
748 return {
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530749 "items": this._get_item_list(item),
Nabin Hait444f9562014-06-20 15:59:49 +0530750 "customer": me.frm.doc.customer,
751 "customer_group": me.frm.doc.customer_group,
752 "territory": me.frm.doc.territory,
753 "supplier": me.frm.doc.supplier,
754 "supplier_type": me.frm.doc.supplier_type,
755 "currency": me.frm.doc.currency,
756 "conversion_rate": me.frm.doc.conversion_rate,
757 "price_list": me.frm.doc.selling_price_list || me.frm.doc.buying_price_list,
Nabin Haitdd82bf22015-05-11 16:49:17 +0530758 "price_list_currency": me.frm.doc.price_list_currency,
Nabin Hait444f9562014-06-20 15:59:49 +0530759 "plc_conversion_rate": me.frm.doc.plc_conversion_rate,
760 "company": me.frm.doc.company,
761 "transaction_date": me.frm.doc.transaction_date || me.frm.doc.posting_date,
762 "campaign": me.frm.doc.campaign,
763 "sales_partner": me.frm.doc.sales_partner,
764 "ignore_pricing_rule": me.frm.doc.ignore_pricing_rule,
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530765 "doctype": me.frm.doc.doctype,
Rohit Waghchaure5ecbaa42017-03-28 12:09:07 +0530766 "name": me.frm.doc.name,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530767 "is_return": cint(me.frm.doc.is_return),
768 "update_stock": in_list(['Sales Invoice', 'Purchase Invoice'], me.frm.doc.doctype) ? cint(me.frm.doc.update_stock) : 0,
Nabin Hait444f9562014-06-20 15:59:49 +0530769 };
Nabin Hait444f9562014-06-20 15:59:49 +0530770 },
771
772 _get_item_list: function(item) {
773 var item_list = [];
774 var append_item = function(d) {
Anand Doshi39edcbc2014-07-28 16:00:19 +0530775 if (d.item_code) {
776 item_list.push({
777 "doctype": d.doctype,
778 "name": d.name,
779 "item_code": d.item_code,
780 "item_group": d.item_group,
781 "brand": d.brand,
Anand Doshi39a28912016-02-15 11:42:18 +0530782 "qty": d.qty,
783 "parenttype": d.parenttype,
Rohit Waghchaure43b50802016-10-24 14:04:46 +0530784 "parent": d.parent,
Kanchan Chauhanaf0d6372016-11-13 21:19:09 +0530785 "pricing_rule": d.pricing_rule,
786 "warehouse": d.warehouse,
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530787 "serial_no": d.serial_no,
788 "conversion_factor": d.conversion_factor
Anand Doshi39edcbc2014-07-28 16:00:19 +0530789 });
mbauskarc79415e2016-01-18 16:32:24 +0530790
791 // if doctype is Quotation Item / Sales Order Iten then add Margin Type and rate in item_list
mbauskara52472c2016-03-05 15:10:25 +0530792 if (in_list(["Quotation Item", "Sales Order Item", "Delivery Note Item", "Sales Invoice Item"]), d.doctype){
793 item_list[0]["margin_type"] = d.margin_type
794 item_list[0]["margin_rate_or_amount"] = d.margin_rate_or_amount
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +0530795 }
Anand Doshi39edcbc2014-07-28 16:00:19 +0530796 }
Nabin Hait444f9562014-06-20 15:59:49 +0530797 };
Nabin Haita3dd72a2014-05-28 12:49:20 +0530798
Nabin Hait444f9562014-06-20 15:59:49 +0530799 if (item) {
800 append_item(item);
Nabin Haitc1367d92014-05-30 11:43:00 +0530801 } else {
Nabin Hait96339342015-01-21 17:22:11 +0530802 $.each(this.frm.doc["items"] || [], function(i, d) {
Nabin Hait444f9562014-06-20 15:59:49 +0530803 append_item(d);
Nabin Haita3dd72a2014-05-28 12:49:20 +0530804 });
805 }
Nabin Hait444f9562014-06-20 15:59:49 +0530806 return item_list;
Nabin Haita3dd72a2014-05-28 12:49:20 +0530807 },
808
Anand Doshidffec8f2014-07-01 17:45:15 +0530809 _set_values_for_item_list: function(children) {
Nabin Hait49a27292014-12-17 11:21:32 +0530810 var me = this;
Nabin Hait7d8fa802014-12-30 15:35:45 +0530811 var price_list_rate_changed = false;
Anand Doshidea3fb02015-02-05 15:05:58 +0530812 for(var i=0, l=children.length; i<l; i++) {
813 var d = children[i];
Nabin Hait49a27292014-12-17 11:21:32 +0530814 var existing_pricing_rule = frappe.model.get_value(d.doctype, d.name, "pricing_rule");
Anand Doshidea3fb02015-02-05 15:05:58 +0530815
816 for(var k in d) {
817 var v = d[k];
Anand Doshidffec8f2014-07-01 17:45:15 +0530818 if (["doctype", "name"].indexOf(k)===-1) {
Nabin Hait7d8fa802014-12-30 15:35:45 +0530819 if(k=="price_list_rate") {
820 if(flt(v) != flt(d.price_list_rate)) price_list_rate_changed = true;
821 }
Rohit Waghchaure2087e572017-02-27 13:43:04 +0530822 if(v) {
823 frappe.model.set_value(d.doctype, d.name, k, v);
824 }
Anand Doshidffec8f2014-07-01 17:45:15 +0530825 }
Anand Doshidea3fb02015-02-05 15:05:58 +0530826 }
827
Nabin Hait49a27292014-12-17 11:21:32 +0530828 // if pricing rule set as blank from an existing value, apply price_list
Nabin Haitcfe3c542014-12-22 10:42:48 +0530829 if(!me.frm.doc.ignore_pricing_rule && existing_pricing_rule && !d.pricing_rule) {
Nabin Hait49a27292014-12-17 11:21:32 +0530830 me.apply_price_list(frappe.get_doc(d.doctype, d.name));
831 }
Anand Doshidea3fb02015-02-05 15:05:58 +0530832 }
Nabin Hait7d8fa802014-12-30 15:35:45 +0530833
Anand Doshidea3fb02015-02-05 15:05:58 +0530834 if(!price_list_rate_changed) me.calculate_taxes_and_totals();
Anand Doshidffec8f2014-07-01 17:45:15 +0530835 },
836
Nabin Hait49a27292014-12-17 11:21:32 +0530837 apply_price_list: function(item) {
Anand Doshidffec8f2014-07-01 17:45:15 +0530838 var me = this;
Rushabh Mehta052bd622015-01-30 16:57:24 +0530839 var args = this._get_args(item);
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530840 if (!((args.items && args.items.length) || args.price_list)) {
Anand Doshi70f57eb2015-11-27 14:37:40 +0530841 return;
842 }
Nabin Hait37b047d2015-02-23 16:01:33 +0530843
Anand Doshidffec8f2014-07-01 17:45:15 +0530844 return this.frm.call({
845 method: "erpnext.stock.get_item_details.apply_price_list",
Rushabh Mehta052bd622015-01-30 16:57:24 +0530846 args: { args: args },
Anand Doshidffec8f2014-07-01 17:45:15 +0530847 callback: function(r) {
848 if (!r.exc) {
Anand Doshi51f722d2014-07-04 15:44:26 +0530849 me.in_apply_price_list = true;
Anand Doshidffec8f2014-07-01 17:45:15 +0530850 me.frm.set_value("price_list_currency", r.message.parent.price_list_currency);
851 me.frm.set_value("plc_conversion_rate", r.message.parent.plc_conversion_rate);
Anand Doshi51f722d2014-07-04 15:44:26 +0530852 me.in_apply_price_list = false;
Nabin Hait37b047d2015-02-23 16:01:33 +0530853
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530854 if(args.items.length) {
Nabin Hait37b047d2015-02-23 16:01:33 +0530855 me._set_values_for_item_list(r.message.children);
856 }
Anand Doshidffec8f2014-07-01 17:45:15 +0530857 }
858 }
859 });
860 },
861
Anand Doshi3543f302013-05-24 19:25:01 +0530862 get_item_wise_taxes_html: function() {
863 var item_tax = {};
864 var tax_accounts = [];
865 var company_currency = this.get_company_currency();
Rushabh Mehtaff938022014-04-15 18:40:00 +0530866
Nabin Hait96339342015-01-21 17:22:11 +0530867 $.each(this.frm.doc["taxes"] || [], function(i, tax) {
Anand Doshi3543f302013-05-24 19:25:01 +0530868 var tax_amount_precision = precision("tax_amount", tax);
Anand Doshi53b73422013-05-31 11:50:01 +0530869 var tax_rate_precision = precision("rate", tax);
Rushabh Mehtaff938022014-04-15 18:40:00 +0530870 $.each(JSON.parse(tax.item_wise_tax_detail || '{}'),
Anand Doshi53b73422013-05-31 11:50:01 +0530871 function(item_code, tax_data) {
Anand Doshi3543f302013-05-24 19:25:01 +0530872 if(!item_tax[item_code]) item_tax[item_code] = {};
Anand Doshi53b73422013-05-31 11:50:01 +0530873 if($.isArray(tax_data)) {
Anand Doshi1e4fb682013-08-23 12:56:33 +0530874 var tax_rate = "";
875 if(tax_data[0] != null) {
876 tax_rate = (tax.charge_type === "Actual") ?
877 format_currency(flt(tax_data[0], tax_amount_precision), company_currency, tax_amount_precision) :
878 (flt(tax_data[0], tax_rate_precision) + "%");
879 }
880 var tax_amount = format_currency(flt(tax_data[1], tax_amount_precision), company_currency,
881 tax_amount_precision);
Rushabh Mehtaff938022014-04-15 18:40:00 +0530882
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530883 item_tax[item_code][tax.name] = [tax_rate, tax_amount];
Anand Doshi53b73422013-05-31 11:50:01 +0530884 } else {
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530885 item_tax[item_code][tax.name] = [flt(tax_data, tax_rate_precision) + "%", ""];
Anand Doshi53b73422013-05-31 11:50:01 +0530886 }
Anand Doshi3543f302013-05-24 19:25:01 +0530887 });
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530888 tax_accounts.push([tax.name, tax.account_head]);
Anand Doshi3543f302013-05-24 19:25:01 +0530889 });
Rushabh Mehtaff938022014-04-15 18:40:00 +0530890
891 var headings = $.map([__("Item Name")].concat($.map(tax_accounts, function(head) { return head[1]; })),
Anand Doshi3543f302013-05-24 19:25:01 +0530892 function(head) { return '<th style="min-width: 100px;">' + (head || "") + "</th>" }).join("\n");
Rushabh Mehtaff938022014-04-15 18:40:00 +0530893
Anand Doshi179e3772013-09-05 16:53:57 +0530894 var distinct_item_names = [];
895 var distinct_items = [];
Nabin Hait96339342015-01-21 17:22:11 +0530896 $.each(this.frm.doc["items"] || [], function(i, item) {
Anand Doshi179e3772013-09-05 16:53:57 +0530897 if(distinct_item_names.indexOf(item.item_code || item.item_name)===-1) {
898 distinct_item_names.push(item.item_code || item.item_name);
899 distinct_items.push(item);
900 }
901 });
Rushabh Mehtaff938022014-04-15 18:40:00 +0530902
Anand Doshi179e3772013-09-05 16:53:57 +0530903 var rows = $.map(distinct_items, function(item) {
Anand Doshi3543f302013-05-24 19:25:01 +0530904 var item_tax_record = item_tax[item.item_code || item.item_name];
Anand Doshi53b73422013-05-31 11:50:01 +0530905 if(!item_tax_record) { return null; }
Anand Doshi3543f302013-05-24 19:25:01 +0530906 return repl("<tr><td>%(item_name)s</td>%(taxes)s</tr>", {
907 item_name: item.item_name,
908 taxes: $.map(tax_accounts, function(head) {
Anand Doshiaa71b5b2013-08-05 13:00:53 +0530909 return item_tax_record[head[0]] ?
910 "<td>(" + item_tax_record[head[0]][0] + ") " + item_tax_record[head[0]][1] + "</td>" :
Anand Doshi64f316b2013-07-17 15:12:22 +0530911 "<td></td>";
Anand Doshi3543f302013-05-24 19:25:01 +0530912 }).join("\n")
913 });
914 }).join("\n");
Rushabh Mehtaff938022014-04-15 18:40:00 +0530915
Anand Doshi53b73422013-05-31 11:50:01 +0530916 if(!rows) return "";
Rushabh Mehtaf24f6042015-08-20 18:01:40 +0530917 return '<p><a class="h6 text-muted" href="#" onclick="$(\'.tax-break-up\').toggleClass(\'hide\'); return false;">'
Rushabh Mehtaf340e192017-03-15 15:12:43 +0530918 + __("Show tax break-up") + '</a></p>\
Rushabh Mehta7d8b1892013-11-08 16:27:18 +0530919 <div class="tax-break-up hide" style="overflow-x: auto;"><table class="table table-bordered table-hover">\
Anand Doshi3543f302013-05-24 19:25:01 +0530920 <thead><tr>' + headings + '</tr></thead> \
921 <tbody>' + rows + '</tbody> \
922 </table></div>';
923 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530924
Nabin Hait139dc7b2014-02-12 14:53:18 +0530925 validate_company_and_party: function() {
Anand Doshi923d41d2013-05-28 17:23:36 +0530926 var me = this;
Anand Doshi3543f302013-05-24 19:25:01 +0530927 var valid = true;
Rushabh Mehtaff938022014-04-15 18:40:00 +0530928
Nabin Hait0f231062014-02-20 11:27:47 +0530929 $.each(["company", "customer"], function(i, fieldname) {
Saurabh8a8ef852015-10-21 19:28:53 +0530930 if(frappe.meta.has_field(me.frm.doc.doctype, fieldname && me.frm.doc.doctype != "Purchase Order")) {
Nabin Hait139dc7b2014-02-12 14:53:18 +0530931 if (!me.frm.doc[fieldname]) {
Rushabh Mehtaff938022014-04-15 18:40:00 +0530932 msgprint(__("Please specify") + ": " +
933 frappe.meta.get_label(me.frm.doc.doctype, fieldname, me.frm.doc.name) +
Pratik Vyasb52618c2014-04-14 16:25:30 +0530934 ". " + __("It is needed to fetch Item Details."));
Nabin Hait139dc7b2014-02-12 14:53:18 +0530935 valid = false;
936 }
Anand Doshi3543f302013-05-24 19:25:01 +0530937 }
938 });
939 return valid;
940 },
Rushabh Mehtaff938022014-04-15 18:40:00 +0530941
Anand Doshibf3e54a2013-06-05 14:11:32 +0530942 get_terms: function() {
943 var me = this;
944 if(this.frm.doc.tc_name) {
Kanchan Chauhanb6426252016-12-12 17:22:27 +0530945 return frappe.call({
946 method: 'erpnext.setup.doctype.terms_and_conditions.terms_and_conditions.get_terms_and_conditions',
Anand Doshibf3e54a2013-06-05 14:11:32 +0530947 args: {
Kanchan Chauhanb6426252016-12-12 17:22:27 +0530948 template_name: this.frm.doc.tc_name,
949 doc: this.frm.doc
Anand Doshibf3e54a2013-06-05 14:11:32 +0530950 },
Kanchan Chauhanb6426252016-12-12 17:22:27 +0530951 callback: function(r) {
952 if(!r.exc) {
953 me.frm.set_value("terms", r.message);
954 }
955 }
Anand Doshibf3e54a2013-06-05 14:11:32 +0530956 });
957 }
958 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530959
960 taxes_and_charges: function() {
961 var me = this;
962 if(this.frm.doc.taxes_and_charges) {
963 return this.frm.call({
Nabin Hait6b039142014-05-02 15:45:10 +0530964 method: "erpnext.controllers.accounts_controller.get_taxes_and_charges",
965 args: {
Nabin Hait03f3a8a2014-05-13 16:38:31 +0530966 "master_doctype": frappe.meta.get_docfield(this.frm.doc.doctype, "taxes_and_charges",
967 this.frm.doc.name).options,
Nabin Hait6b039142014-05-02 15:45:10 +0530968 "master_name": this.frm.doc.taxes_and_charges,
Nabin Hait6b039142014-05-02 15:45:10 +0530969 },
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530970 callback: function(r) {
971 if(!r.exc) {
Nabin Haitdd38a262014-12-26 13:15:21 +0530972 me.frm.set_value("taxes", r.message);
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530973 me.calculate_taxes_and_totals();
974 }
975 }
976 });
Nabin Haitbc83b9c2014-05-02 17:03:18 +0530977 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530978 },
979
980 show_item_wise_taxes: function() {
981 if(this.frm.fields_dict.other_charges_calculation) {
Anand Doshidd942bb2015-02-04 18:52:35 +0530982 var html = this.get_item_wise_taxes_html();
983 if (html) {
984 this.frm.toggle_display("other_charges_calculation", true);
985 $(this.frm.fields_dict.other_charges_calculation.wrapper).html(html);
986 } else {
987 this.frm.toggle_display("other_charges_calculation", false);
988 }
Akhilesh Darjee4f721562014-01-29 16:31:38 +0530989 }
990 },
Anand Doshi13945092014-09-21 19:45:49 +0530991
992 is_recurring: function() {
993 // set default values for recurring documents
Rushabh Mehta756e5182016-03-03 13:00:17 +0530994 if(this.frm.doc.is_recurring && this.frm.doc.__islocal) {
995 frappe.msgprint(__("Please set recurring after saving"));
996 this.frm.set_value('is_recurring', 0);
997 return;
998 }
999
Anand Doshi13945092014-09-21 19:45:49 +05301000 if(this.frm.doc.is_recurring) {
Nabin Hait68a628e2016-03-21 12:03:16 +05301001 if(!this.frm.doc.recurring_id) {
1002 this.frm.set_value('recurring_id', this.frm.doc.name);
1003 }
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301004
Anand Doshi13945092014-09-21 19:45:49 +05301005 var owner_email = this.frm.doc.owner=="Administrator"
1006 ? frappe.user_info("Administrator").email
1007 : this.frm.doc.owner;
1008
1009 this.frm.doc.notification_email_address = $.map([cstr(owner_email),
1010 cstr(this.frm.doc.contact_email)], function(v) { return v || null; }).join(", ");
1011 this.frm.doc.repeat_on_day_of_month = frappe.datetime.str_to_obj(this.frm.doc.posting_date).getDate();
1012 }
1013
1014 refresh_many(["notification_email_address", "repeat_on_day_of_month"]);
1015 },
1016
1017 from_date: function() {
1018 // set to_date
1019 if(this.frm.doc.from_date) {
1020 var recurring_type_map = {'Monthly': 1, 'Quarterly': 3, 'Half-yearly': 6,
1021 'Yearly': 12};
1022
1023 var months = recurring_type_map[this.frm.doc.recurring_type];
1024 if(months) {
1025 var to_date = frappe.datetime.add_months(this.frm.doc.from_date,
1026 months);
1027 this.frm.doc.to_date = frappe.datetime.add_days(to_date, -1);
1028 refresh_field('to_date');
1029 }
1030 }
Saurabhd3135532016-02-25 18:59:20 +05301031 },
Rushabh Mehtabb8c6de2016-03-29 17:52:22 +05301032
Saurabh2d7af632016-02-26 11:09:20 +05301033 set_gross_profit: function(item) {
Saurabh5ada14b2016-02-26 18:02:55 +05301034 if (this.frm.doc.doctype == "Sales Order" && item.valuation_rate) {
Saurabh3fbf3ce2016-03-09 15:31:04 +05301035 rate = flt(item.rate) * flt(this.frm.doc.conversion_rate || 1);
Kanchan Chauhan5a980ac2017-02-10 14:27:11 +05301036 item.gross_profit = flt(((rate - item.valuation_rate) * item.stock_qty), precision("amount", item));
Saurabh2d7af632016-02-26 11:09:20 +05301037 }
Rushabh Mehta203cc962016-04-07 15:25:43 +05301038 },
1039
1040 setup_item_selector: function() {
Rushabh Mehtabc928242016-05-29 23:08:22 +05301041 // TODO: remove item selector
1042
1043 return;
Rushabh Mehta203cc962016-04-07 15:25:43 +05301044 if(!this.item_selector) {
1045 this.item_selector = new erpnext.ItemSelector({frm: this.frm});
1046 }
Nabin Hait28a05282016-06-27 17:41:39 +05301047 },
Rushabh Mehta76b13412016-07-18 14:30:18 +05301048
Nabin Hait28a05282016-06-27 17:41:39 +05301049 get_advances: function() {
1050 if(!this.frm.is_return) {
1051 return this.frm.call({
1052 method: "set_advances",
1053 doc: this.frm.doc,
1054 callback: function(r, rt) {
1055 refresh_field("advances");
1056 }
1057 })
1058 }
Nabin Hait05aefbb2016-06-28 19:42:19 +05301059 },
Rushabh Mehta76b13412016-07-18 14:30:18 +05301060
Nabin Hait05aefbb2016-06-28 19:42:19 +05301061 make_payment_entry: function() {
1062 return frappe.call({
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301063 method: cur_frm.cscript.get_method_for_payment(),
Nabin Hait05aefbb2016-06-28 19:42:19 +05301064 args: {
1065 "dt": cur_frm.doc.doctype,
1066 "dn": cur_frm.doc.name
1067 },
1068 callback: function(r) {
1069 var doclist = frappe.model.sync(r.message);
1070 frappe.set_route("Form", doclist[0].doctype, doclist[0].name);
Nabin Hait56548cb2016-07-01 15:58:39 +05301071 // cur_frm.refresh_fields()
Nabin Hait05aefbb2016-06-28 19:42:19 +05301072 }
1073 });
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301074 },
1075
1076 get_method_for_payment: function(){
1077 method = "erpnext.accounts.doctype.payment_entry.payment_entry.get_payment_entry"
Rohit Waghchaure7d529892016-10-06 14:35:04 +05301078 if(cur_frm.doc.__onload && cur_frm.doc.__onload.make_payment_via_journal_entry){
Rohit Waghchaureb7a55022016-10-05 16:24:41 +05301079 if(in_list(['Sales Invoice', 'Purchase Invoice'], cur_frm.doc.doctype)){
1080 method = "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_invoice"
1081 }else {
1082 method= "erpnext.accounts.doctype.journal_entry.journal_entry.get_payment_entry_against_order"
1083 }
1084 }
1085
1086 return method
Manas Solankicc902412016-11-10 19:15:11 +05301087 },
Rushabh Mehtabe2ee182016-04-29 17:22:42 +05301088});