blob: 87d5648f6ed0adfbf8e16301b1496ef5d79a47b6 [file] [log] [blame]
Anand Doshi885e0742015-03-03 14:55:30 +05301# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
Rushabh Mehtae67d1fb2013-08-05 14:59:54 +05302# License: GNU General Public License v3. See license.txt
Nabin Hait2df4d542013-01-29 11:34:39 +05303
4from __future__ import unicode_literals
Chillar Anand915b3432021-09-02 16:44:59 +05305
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08006import json
Chillar Anand915b3432021-09-02 16:44:59 +05307
8import frappe
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05309from frappe import _, throw
Chillar Anand915b3432021-09-02 16:44:59 +053010from frappe.model.workflow import get_workflow_name, is_transition_condition_satisfied
11from frappe.utils import (
12 add_days,
13 add_months,
14 cint,
15 flt,
16 fmt_money,
17 formatdate,
18 get_last_day,
19 get_link_to_form,
20 getdate,
21 nowdate,
22 today,
23)
Achilles Rasquinha90509982018-03-08 12:55:41 +053024from six import text_type
Chillar Anand915b3432021-09-02 16:44:59 +053025
26import erpnext
27from erpnext.accounts.doctype.accounting_dimension.accounting_dimension import (
28 get_accounting_dimensions,
29)
30from erpnext.accounts.doctype.pricing_rule.utils import (
31 apply_pricing_rule_for_free_items,
32 apply_pricing_rule_on_transaction,
33 get_applied_pricing_rules,
34)
35from erpnext.accounts.party import (
36 get_party_account,
37 get_party_account_currency,
38 validate_party_frozen_disabled,
39)
40from erpnext.accounts.utils import get_account_currency, get_fiscal_years, validate_fiscal_year
41from erpnext.buying.utils import update_last_purchase_rate
42from erpnext.controllers.print_settings import (
43 set_print_templates_for_item_table,
44 set_print_templates_for_taxes,
45)
46from erpnext.controllers.sales_and_purchase_return import validate_return
47from erpnext.exceptions import InvalidCurrency
48from erpnext.setup.utils import get_exchange_rate
Marica3dee5272020-06-23 10:33:47 +053049from erpnext.stock.doctype.packed_item.packed_item import make_packing_list
Chillar Anand915b3432021-09-02 16:44:59 +053050from erpnext.stock.get_item_details import (
51 _get_item_tax_template,
52 get_conversion_factor,
53 get_item_details,
54 get_item_tax_map,
55 get_item_warehouse,
56)
57from erpnext.utilities.transaction_base import TransactionBase
58
Nabin Hait1d218422015-07-17 15:19:02 +053059
marination53b1a9a2020-11-03 15:45:25 +053060class AccountMissingError(frappe.ValidationError): pass
61
Rohit Waghchaurebde159a2021-03-22 23:36:48 +053062force_item_fields = ("item_group", "brand", "stock_uom", "is_fixed_asset", "item_tax_rate",
63 "pricing_rules", "weight_per_unit", "weight_uom", "total_weight")
Doridel Cahanap6f06cc22018-05-17 16:28:58 +080064
Nabin Haitbf495c92013-01-30 12:49:08 +053065class AccountsController(TransactionBase):
Nabin Hait7eba1a32017-10-02 15:59:27 +053066 def __init__(self, *args, **kwargs):
67 super(AccountsController, self).__init__(*args, **kwargs)
Anand Doshi979326b2015-09-11 16:22:37 +053068
prssanna71e5b602020-10-29 14:19:34 +053069 def get_print_settings(self):
70 print_setting_fields = []
71 items_field = self.meta.get_field('items')
72
73 if items_field and items_field.fieldtype == 'Table':
74 print_setting_fields += ['compact_item_print', 'print_uom_after_quantity']
75
76 taxes_field = self.meta.get_field('taxes')
77 if taxes_field and taxes_field.fieldtype == 'Table':
78 print_setting_fields += ['print_taxes_with_zero_amount']
79
80 return print_setting_fields
81
Nabin Hait4ffd7f32015-08-27 12:28:36 +053082 @property
83 def company_currency(self):
84 if not hasattr(self, "__company_currency"):
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +053085 self.__company_currency = erpnext.get_company_currency(self.company)
Anand Doshi979326b2015-09-11 16:22:37 +053086
Nabin Hait4ffd7f32015-08-27 12:28:36 +053087 return self.__company_currency
Anand Doshi979326b2015-09-11 16:22:37 +053088
Rohit Waghchaure7d529892016-10-06 14:35:04 +053089 def onload(self):
Nabin Hait34c551d2019-07-03 10:34:31 +053090 self.set_onload("make_payment_via_journal_entry",
91 frappe.db.get_single_value('Accounts Settings', 'make_payment_via_journal_entry'))
Nabin Hait0551f7b2017-11-21 19:58:16 +053092
tundee52bb822017-09-25 09:02:23 +010093 if self.is_new():
Nabin Hait0551f7b2017-11-21 19:58:16 +053094 relevant_docs = ("Quotation", "Purchase Order", "Sales Order",
Doridel Cahanap6f06cc22018-05-17 16:28:58 +080095 "Purchase Invoice", "Sales Invoice")
tundee52bb822017-09-25 09:02:23 +010096 if self.doctype in relevant_docs:
97 self.set_payment_schedule()
Rohit Waghchaure7d529892016-10-06 14:35:04 +053098
tundebabzyad08d4c2018-05-16 07:01:41 +010099 def ensure_supplier_is_not_blocked(self):
100 is_supplier_payment = self.doctype == 'Payment Entry' and self.party_type == 'Supplier'
101 is_buying_invoice = self.doctype in ['Purchase Invoice', 'Purchase Order']
102 supplier = None
103 supplier_name = None
104
105 if is_buying_invoice or is_supplier_payment:
106 supplier_name = self.supplier if is_buying_invoice else self.party
107 supplier = frappe.get_doc('Supplier', supplier_name)
108
109 if supplier and supplier_name and supplier.on_hold:
110 if (is_buying_invoice and supplier.hold_type in ['All', 'Invoices']) or \
111 (is_supplier_payment and supplier.hold_type in ['All', 'Payments']):
112 if not supplier.release_date or getdate(nowdate()) <= supplier.release_date:
113 frappe.msgprint(
Suraj Shetty48e9bc32020-01-29 15:06:18 +0530114 _('{0} is blocked so this transaction cannot proceed').format(supplier_name), raise_exception=1)
tundebabzyad08d4c2018-05-16 07:01:41 +0100115
Saurabh6f753182013-03-20 12:55:28 +0530116 def validate(self):
Deepesh Gargd301d262019-07-31 15:58:19 +0530117 if not self.get('is_return'):
118 self.validate_qty_is_not_zero()
119
nabinhait23cce732014-07-03 12:25:06 +0530120 if self.get("_action") and self._action != "update_after_submit":
Nabin Hait704a4532014-06-05 16:55:31 +0530121 self.set_missing_values(for_validate=True)
tunde62af5c52017-09-22 15:16:38 +0100122
tundebabzyad08d4c2018-05-16 07:01:41 +0100123 self.ensure_supplier_is_not_blocked()
124
Nabin Haitcfecd2b2013-07-11 17:49:18 +0530125 self.validate_date_with_fiscal_year()
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530126 self.validate_party_accounts()
127
Deepesh Gargb4be2922021-01-28 13:09:56 +0530128 self.validate_inter_company_reference()
129
130 self.set_incoming_rate()
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530131
Anand Doshi3543f302013-05-24 19:25:01 +0530132 if self.meta.get_field("currency"):
Anand Doshi923d41d2013-05-28 17:23:36 +0530133 self.calculate_taxes_and_totals()
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530134
Nabin Hait1d218422015-07-17 15:19:02 +0530135 if not self.meta.get_field("is_return") or not self.is_return:
136 self.validate_value("base_grand_total", ">=", 0)
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530137
Nabin Hait3cf67a42015-07-24 13:26:36 +0530138 validate_return(self)
Anand Doshi3543f302013-05-24 19:25:01 +0530139 self.set_total_in_words()
Anand Doshid2946502014-04-08 20:10:03 +0530140
tunde62af5c52017-09-22 15:16:38 +0100141 self.validate_all_documents_schedule()
Anand Doshid2946502014-04-08 20:10:03 +0530142
ankitjavalkarwork6c29d872014-10-06 13:20:53 +0530143 if self.meta.get_field("taxes_and_charges"):
144 self.validate_enabled_taxes_and_charges()
Nabin Haita2426fc2018-01-15 17:45:46 +0530145 self.validate_tax_account_company()
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530146
Neil Trini Lasrado3fbbb712015-07-17 12:10:12 +0530147 self.validate_party()
Nabin Hait895029d2015-08-20 14:55:39 +0530148 self.validate_currency()
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +0530149
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530150 if self.doctype == 'Purchase Invoice':
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530151 self.calculate_paid_amount()
Deepesh Garg911818a2021-06-09 22:55:10 +0530152 # apply tax withholding only if checked and applicable
153 self.set_tax_withholding()
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530154
Nabin Hait041a5c22018-08-01 18:07:39 +0530155 if self.doctype in ['Purchase Invoice', 'Sales Invoice']:
Nabin Hait4a994d42019-04-25 17:47:26 +0530156 pos_check_field = "is_pos" if self.doctype=="Sales Invoice" else "is_paid"
157 if cint(self.allocate_advances_automatically) and not cint(self.get(pos_check_field)):
Nabin Hait041a5c22018-08-01 18:07:39 +0530158 self.set_advances()
159
Saqiba20999c2021-07-12 14:33:23 +0530160 self.set_advance_gain_or_loss()
161
Nabin Hait041a5c22018-08-01 18:07:39 +0530162 if self.is_return:
163 self.validate_qty()
Nabin Haitacdd5082019-12-04 15:30:01 +0530164 else:
165 self.validate_deferred_start_and_end_date()
rohitwaghchaure70489252018-06-11 12:02:14 +0530166
Deepesh Gargf17ea2c2020-12-11 21:30:39 +0530167 self.set_inter_company_account()
168
Gauravf1e28e02019-02-13 16:46:24 +0530169 validate_regional(self)
Deepesh Garg7c300852020-12-26 20:14:51 +0530170
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530171 if self.doctype != 'Material Request':
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530172 apply_pricing_rule_on_transaction(self)
Gauravf1e28e02019-02-13 16:46:24 +0530173
Saqib8e556772021-01-28 12:26:45 +0530174 def on_trash(self):
175 # delete sl and gl entries on deletion of transaction
176 if frappe.db.get_single_value('Accounts Settings', 'delete_linked_ledger_entries'):
177 frappe.db.sql("delete from `tabGL Entry` where voucher_type=%s and voucher_no=%s", (self.doctype, self.name))
178 frappe.db.sql("delete from `tabStock Ledger Entry` where voucher_type=%s and voucher_no=%s", (self.doctype, self.name))
Nabin Hait0551f7b2017-11-21 19:58:16 +0530179
Nabin Haitacdd5082019-12-04 15:30:01 +0530180 def validate_deferred_start_and_end_date(self):
181 for d in self.items:
182 if d.get("enable_deferred_revenue") or d.get("enable_deferred_expense"):
183 if not (d.service_start_date and d.service_end_date):
184 frappe.throw(_("Row #{0}: Service Start and End Date is required for deferred accounting").format(d.idx))
185 elif getdate(d.service_start_date) > getdate(d.service_end_date):
186 frappe.throw(_("Row #{0}: Service Start Date cannot be greater than Service End Date").format(d.idx))
187 elif getdate(self.posting_date) > getdate(d.service_end_date):
188 frappe.throw(_("Row #{0}: Service End Date cannot be before Invoice Posting Date").format(d.idx))
189
tunde62af5c52017-09-22 15:16:38 +0100190 def validate_invoice_documents_schedule(self):
Nabin Hait0551f7b2017-11-21 19:58:16 +0530191 self.validate_payment_schedule_dates()
192 self.set_due_date()
Nabin Hait0551f7b2017-11-21 19:58:16 +0530193 self.set_payment_schedule()
194 self.validate_payment_schedule_amount()
Deepesh Gargbd709f82021-08-23 19:05:52 +0530195 if not self.get('ignore_default_payment_terms_template'):
196 self.validate_due_date()
tunde62af5c52017-09-22 15:16:38 +0100197 self.validate_advance_entries()
198
199 def validate_non_invoice_documents_schedule(self):
Nabin Hait0551f7b2017-11-21 19:58:16 +0530200 self.set_payment_schedule()
Nabin Hait2f9f4f92017-12-20 12:24:59 +0530201 self.validate_payment_schedule_dates()
Nabin Hait0551f7b2017-11-21 19:58:16 +0530202 self.validate_payment_schedule_amount()
tunde62af5c52017-09-22 15:16:38 +0100203
204 def validate_all_documents_schedule(self):
205 if self.doctype in ("Sales Invoice", "Purchase Invoice") and not self.is_return:
206 self.validate_invoice_documents_schedule()
207 elif self.doctype in ("Quotation", "Purchase Order", "Sales Order"):
208 self.validate_non_invoice_documents_schedule()
209
prssanna71e5b602020-10-29 14:19:34 +0530210 def before_print(self, settings=None):
Zarrarb9f54ca2018-05-28 17:41:09 +0530211 if self.doctype in ['Purchase Order', 'Sales Order', 'Sales Invoice', 'Purchase Invoice',
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800212 'Supplier Quotation', 'Purchase Receipt', 'Delivery Note', 'Quotation']:
KanchanChauhan49a50fe2016-11-18 13:57:53 +0530213 if self.get("group_same_items"):
214 self.group_similar_items()
215
Zarrar5be6d192018-11-08 12:16:26 +0530216 df = self.meta.get_field("discount_amount")
217 if self.get("discount_amount") and hasattr(self, "taxes") and not len(self.taxes):
218 df.set("print_hide", 0)
219 self.discount_amount = -self.discount_amount
220 else:
221 df.set("print_hide", 1)
222
prssanna71e5b602020-10-29 14:19:34 +0530223 set_print_templates_for_item_table(self, settings)
224 set_print_templates_for_taxes(self, settings)
225
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530226 def calculate_paid_amount(self):
Saurabh43520f92016-03-21 18:32:48 +0530227 if hasattr(self, "is_pos") or hasattr(self, "is_paid"):
228 is_paid = self.get("is_pos") or self.get("is_paid")
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530229
230 if is_paid:
231 if not self.cash_bank_account:
232 # show message that the amount is not paid
233 frappe.throw(_("Note: Payment Entry will not be created since 'Cash or Bank Account' was not specified"))
Marica23d7b092019-09-25 17:17:36 +0530234
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530235 if cint(self.is_return) and self.grand_total > self.paid_amount:
236 self.paid_amount = flt(flt(self.grand_total), self.precision("paid_amount"))
237
238 elif not flt(self.paid_amount) and flt(self.outstanding_amount) > 0:
239 self.paid_amount = flt(flt(self.outstanding_amount), self.precision("paid_amount"))
240
241 self.base_paid_amount = flt(self.paid_amount * self.conversion_rate,
242 self.precision("base_paid_amount"))
Saurabh43520f92016-03-21 18:32:48 +0530243
Anand Doshiabc10032013-06-14 17:44:03 +0530244 def set_missing_values(self, for_validate=False):
Rohit Waghchaure5d97d892016-05-12 12:58:29 +0530245 if frappe.flags.in_test:
tunde62af5c52017-09-22 15:16:38 +0100246 for fieldname in ["posting_date", "transaction_date"]:
Rohit Waghchaure5d97d892016-05-12 12:58:29 +0530247 if self.meta.get_field(fieldname) and not self.get(fieldname):
248 self.set(fieldname, today())
249 break
Anand Doshid2946502014-04-08 20:10:03 +0530250
Nabin Hait3237c752015-02-17 11:11:11 +0530251 def calculate_taxes_and_totals(self):
Nabin Haitfe81da22015-02-18 12:23:18 +0530252 from erpnext.controllers.taxes_and_totals import calculate_taxes_and_totals
253 calculate_taxes_and_totals(self)
Nabin Hait3237c752015-02-17 11:11:11 +0530254
255 if self.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]:
256 self.calculate_commission()
257 self.calculate_contribution()
258
Nabin Haitcfecd2b2013-07-11 17:49:18 +0530259 def validate_date_with_fiscal_year(self):
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800260 if self.meta.get_field("fiscal_year"):
Rohan Bansal1e3a3b22021-05-26 15:18:10 +0530261 date_field = None
Nabin Haitcfecd2b2013-07-11 17:49:18 +0530262 if self.meta.get_field("posting_date"):
263 date_field = "posting_date"
264 elif self.meta.get_field("transaction_date"):
265 date_field = "transaction_date"
Anand Doshid2946502014-04-08 20:10:03 +0530266
Rushabh Mehtaf2227d02014-03-31 23:37:40 +0530267 if date_field and self.get(date_field):
Rushabh Mehta66958302017-01-16 16:57:53 +0530268 validate_fiscal_year(self.get(date_field), self.fiscal_year, self.company,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800269 self.meta.get_label(date_field), self)
Anand Doshid2946502014-04-08 20:10:03 +0530270
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530271 def validate_party_accounts(self):
272 if self.doctype not in ('Sales Invoice', 'Purchase Invoice'):
273 return
274
275 if self.doctype == 'Sales Invoice':
276 party_account_field = 'debit_to'
277 item_field = 'income_account'
278 else:
279 party_account_field = 'credit_to'
280 item_field = 'expense_account'
281
282 for item in self.get('items'):
283 if item.get(item_field) == self.get(party_account_field):
284 frappe.throw(_("Row {0}: {1} {2} cannot be same as {3} (Party Account) {4}").format(item.idx,
285 frappe.bold(frappe.unscrub(item_field)), item.get(item_field),
286 frappe.bold(frappe.unscrub(party_account_field)), self.get(party_account_field)))
287
Deepesh Gargb4be2922021-01-28 13:09:56 +0530288 def validate_inter_company_reference(self):
289 if self.doctype not in ('Purchase Invoice', 'Purchase Receipt', 'Purchase Order'):
290 return
291
292 if self.is_internal_transfer():
293 if not (self.get('inter_company_reference') or self.get('inter_company_invoice_reference')
294 or self.get('inter_company_order_reference')):
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530295 msg = _("Internal Sale or Delivery Reference missing.")
Deepesh Gargb4be2922021-01-28 13:09:56 +0530296 msg += _("Please create purchase from internal sale or delivery document itself")
297 frappe.throw(msg, title=_("Internal Sales Reference Missing"))
298
Nabin Haite9daefe2014-08-27 16:46:33 +0530299 def validate_due_date(self):
rohitwaghchaureea943c62018-07-06 12:28:58 +0530300 if self.get('is_pos'): return
301
Nabin Haite9daefe2014-08-27 16:46:33 +0530302 from erpnext.accounts.party import validate_due_date
303 if self.doctype == "Sales Invoice":
Nabin Hait04d244a2015-07-22 17:47:49 +0530304 if not self.due_date:
305 frappe.throw(_("Due Date is mandatory"))
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530306
rohitwaghchaure3ffe8962018-07-13 17:40:48 +0530307 validate_due_date(self.posting_date, self.due_date,
308 "Customer", self.customer, self.company, self.payment_terms_template)
Nabin Haite9daefe2014-08-27 16:46:33 +0530309 elif self.doctype == "Purchase Invoice":
Rohit Waghchaured1a85a32018-11-26 18:42:29 +0530310 validate_due_date(self.bill_date or self.posting_date, self.due_date,
Saurabhd7897f12018-07-18 17:08:16 +0530311 "Supplier", self.supplier, self.company, self.bill_date, self.payment_terms_template)
Nabin Haite9daefe2014-08-27 16:46:33 +0530312
Nabin Hait096d3632013-10-17 17:01:14 +0530313 def set_price_list_currency(self, buying_or_selling):
Nabin Hait1cc55fb2016-12-08 14:09:23 +0530314 if self.meta.get_field("posting_date"):
Nabin Hait288a18e2016-12-08 15:36:23 +0530315 transaction_date = self.posting_date
Nabin Hait1cc55fb2016-12-08 14:09:23 +0530316 else:
Nabin Hait288a18e2016-12-08 15:36:23 +0530317 transaction_date = self.transaction_date
Rushabh Mehta66958302017-01-16 16:57:53 +0530318
Rushabh Mehta4a404e92013-08-09 18:11:35 +0530319 if self.meta.get_field("currency"):
Nabin Hait7a75e102013-09-17 10:21:20 +0530320 # price list part
Shreya3f778522018-05-15 16:59:20 +0530321 if buying_or_selling.lower() == "selling":
322 fieldname = "selling_price_list"
323 args = "for_selling"
324 else:
325 fieldname = "buying_price_list"
326 args = "for_buying"
327
Anand Doshif78d1ae2014-03-28 13:55:00 +0530328 if self.meta.get_field(fieldname) and self.get(fieldname):
329 self.price_list_currency = frappe.db.get_value("Price List",
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800330 self.get(fieldname), "currency")
Anand Doshid2946502014-04-08 20:10:03 +0530331
Nabin Hait6e439a52015-08-28 19:24:22 +0530332 if self.price_list_currency == self.company_currency:
Anand Doshif78d1ae2014-03-28 13:55:00 +0530333 self.plc_conversion_rate = 1.0
Nabin Hait11f41952013-09-24 14:36:55 +0530334
Anand Doshif78d1ae2014-03-28 13:55:00 +0530335 elif not self.plc_conversion_rate:
Rushabh Mehta66958302017-01-16 16:57:53 +0530336 self.plc_conversion_rate = get_exchange_rate(self.price_list_currency,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800337 self.company_currency, transaction_date, args)
Anand Doshid2946502014-04-08 20:10:03 +0530338
Nabin Hait7a75e102013-09-17 10:21:20 +0530339 # currency
Anand Doshif78d1ae2014-03-28 13:55:00 +0530340 if not self.currency:
341 self.currency = self.price_list_currency
342 self.conversion_rate = self.plc_conversion_rate
Nabin Hait6e439a52015-08-28 19:24:22 +0530343 elif self.currency == self.company_currency:
Anand Doshif78d1ae2014-03-28 13:55:00 +0530344 self.conversion_rate = 1.0
345 elif not self.conversion_rate:
Anand Doshidffec8f2014-07-01 17:45:15 +0530346 self.conversion_rate = get_exchange_rate(self.currency,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800347 self.company_currency, transaction_date, args)
Nabin Hait7a75e102013-09-17 10:21:20 +0530348
Nabin Haitcccc45e2016-10-05 17:15:43 +0530349 def set_missing_item_details(self, for_validate=False):
Anand Doshi3543f302013-05-24 19:25:01 +0530350 """set missing item values"""
Nabin Haitf37d43d2017-07-18 12:14:42 +0530351 from erpnext.stock.doctype.serial_no.serial_no import get_serial_nos
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530352
Nabin Haitdd38a262014-12-26 13:15:21 +0530353 if hasattr(self, "items"):
Nabin Hait444f9562014-06-20 15:59:49 +0530354 parent_dict = {}
Pratik Vyasf7daab72014-04-10 17:53:30 +0530355 for fieldname in self.meta.get_valid_columns():
356 parent_dict[fieldname] = self.get(fieldname)
357
mbauskara52472c2016-03-05 15:10:25 +0530358 if self.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]:
359 document_type = "{} Item".format(self.doctype)
mbauskarc97becb2016-01-18 16:28:21 +0530360 parent_dict.update({"document_type": document_type})
361
Nabin Hait34c551d2019-07-03 10:34:31 +0530362 # party_name field used for customer in quotation
363 if self.doctype == "Quotation" and self.quotation_to == "Customer" and parent_dict.get("party_name"):
364 parent_dict.update({"customer": parent_dict.get("party_name")})
365
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530366 self.pricing_rules = []
Nabin Haitdd38a262014-12-26 13:15:21 +0530367 for item in self.get("items"):
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530368 if item.get("item_code"):
Nabin Hait444f9562014-06-20 15:59:49 +0530369 args = parent_dict.copy()
370 args.update(item.as_dict())
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530371
Nabin Hait34d28222016-01-19 15:45:49 +0530372 args["doctype"] = self.doctype
373 args["name"] = self.name
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530374 args["child_docname"] = item.name
Saqibac9e6ff2021-01-28 17:58:55 +0530375 args["ignore_pricing_rule"] = self.ignore_pricing_rule if hasattr(self, 'ignore_pricing_rule') else 0
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530376
Nabin Haite2f054c2015-03-09 14:54:37 +0530377 if not args.get("transaction_date"):
378 args["transaction_date"] = args.get("posting_date")
Anand Doshi2b2b6392015-03-20 14:18:09 +0530379
380 if self.get("is_subcontracted"):
381 args["is_subcontracted"] = self.is_subcontracted
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530382
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530383 ret = get_item_details(args, self, for_validate=True, overwrite_warehouse=False)
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530384
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530385 for fieldname, value in ret.items():
Anand Doshi602e8252015-11-16 19:05:46 +0530386 if item.meta.get_field(fieldname) and value is not None:
387 if (item.get(fieldname) is None or fieldname in force_item_fields):
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530388 item.set(fieldname, value)
Anand Doshid2946502014-04-08 20:10:03 +0530389
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530390 elif fieldname in ['cost_center', 'conversion_factor'] and not item.get(fieldname):
Anand Doshi602e8252015-11-16 19:05:46 +0530391 item.set(fieldname, value)
392
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530393 elif fieldname == "serial_no":
Alchez9155e402018-07-09 16:57:42 +0530394 # Ensure that serial numbers are matched against Stock UOM
395 item_conversion_factor = item.get("conversion_factor") or 1.0
396 item_qty = abs(item.get("qty")) * item_conversion_factor
Alchez8f2a0f32018-07-06 14:36:52 +0530397
398 if item_qty != len(get_serial_nos(item.get('serial_no'))):
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530399 item.set(fieldname, value)
Nabin Haita74468b2014-12-30 18:33:52 +0530400
Rohit Waghchauref6f503a2018-12-19 15:06:44 +0530401 if self.doctype in ["Purchase Invoice", "Sales Invoice"] and item.meta.get_field('is_fixed_asset'):
402 item.set('is_fixed_asset', ret.get('is_fixed_asset', 0))
403
Deepesh Garga60c3082021-05-11 16:38:33 +0530404 # Double check for cost center
405 # Items add via promotional scheme may not have cost center set
406 if hasattr(item, 'cost_center') and not item.get('cost_center'):
407 item.set('cost_center', self.get('cost_center') or erpnext.get_default_cost_center(self.company))
408
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530409 if ret.get("pricing_rules"):
410 self.apply_pricing_rule_on_items(item, ret)
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530411 self.set_pricing_rule_details(item, ret)
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530412
Nabin Hait14aa9c52016-04-18 15:54:01 +0530413 if self.doctype == "Purchase Invoice":
Nabin Haitcccc45e2016-10-05 17:15:43 +0530414 self.set_expense_account(for_validate)
Nabin Haita3dd72a2014-05-28 12:49:20 +0530415
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530416 def apply_pricing_rule_on_items(self, item, pricing_rule_args):
417 if not pricing_rule_args.get("validate_applied_rule", 0):
418 # if user changed the discount percentage then set user's discount percentage ?
419 if pricing_rule_args.get("price_or_product_discount") == 'Price':
420 item.set("pricing_rules", pricing_rule_args.get("pricing_rules"))
421 item.set("discount_percentage", pricing_rule_args.get("discount_percentage"))
422 item.set("discount_amount", pricing_rule_args.get("discount_amount"))
423 if pricing_rule_args.get("pricing_rule_for") == "Rate":
424 item.set("price_list_rate", pricing_rule_args.get("price_list_rate"))
425
426 if item.get("price_list_rate"):
427 item.rate = flt(item.price_list_rate *
428 (1.0 - (flt(item.discount_percentage) / 100.0)), item.precision("rate"))
429
430 if item.get('discount_amount'):
431 item.rate = item.price_list_rate - item.discount_amount
432
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530433 if item.get("apply_discount_on_discounted_rate") and pricing_rule_args.get("rate"):
434 item.rate = pricing_rule_args.get("rate")
435
Rohit Waghchaure21fe97e2019-12-13 16:18:38 +0530436 elif pricing_rule_args.get('free_item_data'):
437 apply_pricing_rule_for_free_items(self, pricing_rule_args.get('free_item_data'))
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530438
439 elif pricing_rule_args.get("validate_applied_rule"):
Rushabh Mehtaff5d1962020-08-25 11:59:57 +0530440 for pricing_rule in get_applied_pricing_rules(item.get('pricing_rules')):
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530441 pricing_rule_doc = frappe.get_cached_doc("Pricing Rule", pricing_rule)
442 for field in ['discount_percentage', 'discount_amount', 'rate']:
443 if item.get(field) < pricing_rule_doc.get(field):
444 title = get_link_to_form("Pricing Rule", pricing_rule)
445
446 frappe.msgprint(_("Row {0}: user has not applied the rule {1} on the item {2}")
447 .format(item.idx, frappe.bold(title), frappe.bold(item.item_code)))
448
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530449 def set_pricing_rule_details(self, item_row, args):
450 pricing_rules = get_applied_pricing_rules(args.get("pricing_rules"))
451 if not pricing_rules: return
452
453 for pricing_rule in pricing_rules:
454 self.append("pricing_rules", {
455 "pricing_rule": pricing_rule,
456 "item_code": item_row.item_code,
457 "child_docname": item_row.name,
458 "rule_applied": True
459 })
460
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530461 def set_taxes(self):
462 if not self.meta.get_field("taxes"):
Anand Doshi3543f302013-05-24 19:25:01 +0530463 return
Anand Doshid2946502014-04-08 20:10:03 +0530464
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530465 tax_master_doctype = self.meta.get_field("taxes_and_charges").options
Anand Doshid2946502014-04-08 20:10:03 +0530466
rohitwaghchaure57914f12018-04-24 19:19:47 +0530467 if (self.is_new() or self.is_pos_profile_changed()) and not self.get("taxes"):
rohitwaghchaure505661b2017-12-11 14:52:28 +0530468 if self.company and not self.get("taxes_and_charges"):
Anand Doshi3543f302013-05-24 19:25:01 +0530469 # get the default tax master
rohitwaghchaure505661b2017-12-11 14:52:28 +0530470 self.taxes_and_charges = frappe.db.get_value(tax_master_doctype,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800471 {"is_default": 1, 'company': self.company})
Anand Doshid2946502014-04-08 20:10:03 +0530472
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530473 self.append_taxes_from_master(tax_master_doctype)
Anand Doshid2946502014-04-08 20:10:03 +0530474
rohitwaghchaure57914f12018-04-24 19:19:47 +0530475 def is_pos_profile_changed(self):
476 if (self.doctype == 'Sales Invoice' and self.is_pos and
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800477 self.pos_profile != frappe.db.get_value('Sales Invoice', self.name, 'pos_profile')):
rohitwaghchaure57914f12018-04-24 19:19:47 +0530478 return True
479
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530480 def append_taxes_from_master(self, tax_master_doctype=None):
481 if self.get("taxes_and_charges"):
Anand Doshi99100a42013-07-04 17:13:53 +0530482 if not tax_master_doctype:
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530483 tax_master_doctype = self.meta.get_field("taxes_and_charges").options
Anand Doshid2946502014-04-08 20:10:03 +0530484
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530485 self.extend("taxes", get_taxes_and_charges(tax_master_doctype, self.get("taxes_and_charges")))
Akhilesh Darjee4cdb7992014-01-30 13:56:57 +0530486
Anand Doshiac32bad2014-04-18 01:30:14 +0530487 def set_other_charges(self):
Nabin Haite7d15362014-12-25 16:01:55 +0530488 self.set("taxes", [])
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530489 self.set_taxes()
Anand Doshid2946502014-04-08 20:10:03 +0530490
ankitjavalkarwork6c29d872014-10-06 13:20:53 +0530491 def validate_enabled_taxes_and_charges(self):
492 taxes_and_charges_doctype = self.meta.get_options("taxes_and_charges")
493 if frappe.db.get_value(taxes_and_charges_doctype, self.taxes_and_charges, "disabled"):
494 frappe.throw(_("{0} '{1}' is disabled").format(taxes_and_charges_doctype, self.taxes_and_charges))
495
Nabin Haita2426fc2018-01-15 17:45:46 +0530496 def validate_tax_account_company(self):
497 for d in self.get("taxes"):
498 if d.account_head:
499 tax_account_company = frappe.db.get_value("Account", d.account_head, "company")
500 if tax_account_company != self.company:
501 frappe.throw(_("Row #{0}: Account {1} does not belong to company {2}")
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800502 .format(d.idx, d.account_head, self.company))
Nabin Haita2426fc2018-01-15 17:45:46 +0530503
deepeshgarg0073d11ac02019-05-19 00:02:01 +0530504 def get_gl_dict(self, args, account_currency=None, item=None):
Nabin Hait2df4d542013-01-29 11:34:39 +0530505 """this method populates the common properties of a gl entry record"""
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +0530506
Rohit Waghchaureaa7b4342018-05-11 01:56:05 +0530507 posting_date = args.get('posting_date') or self.get('posting_date')
508 fiscal_years = get_fiscal_years(posting_date, company=self.company)
Nabin Hait2ed0b592016-03-29 13:14:17 +0530509 if len(fiscal_years) > 1:
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800510 frappe.throw(_("Multiple fiscal years exist for the date {0}. Please set company in Fiscal Year").format(
511 formatdate(posting_date)))
Nabin Hait2ed0b592016-03-29 13:14:17 +0530512 else:
513 fiscal_year = fiscal_years[0][0]
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +0530514
Rushabh Mehta793ba6b2014-02-14 15:47:51 +0530515 gl_dict = frappe._dict({
Anand Doshid2946502014-04-08 20:10:03 +0530516 'company': self.company,
Rohit Waghchaureaa7b4342018-05-11 01:56:05 +0530517 'posting_date': posting_date,
Nabin Hait2ed0b592016-03-29 13:14:17 +0530518 'fiscal_year': fiscal_year,
Anand Doshif78d1ae2014-03-28 13:55:00 +0530519 'voucher_type': self.doctype,
520 'voucher_no': self.name,
Nabin Hait5cd04a62019-05-27 11:44:06 +0530521 'remarks': self.get("remarks") or self.get("remark"),
Nabin Hait2df4d542013-01-29 11:34:39 +0530522 'debit': 0,
523 'credit': 0,
Nabin Hait46bcbaf2015-08-19 13:49:10 +0530524 'debit_in_account_currency': 0,
525 'credit_in_account_currency': 0,
Anand Doshif78d1ae2014-03-28 13:55:00 +0530526 'is_opening': self.get("is_opening") or "No",
Nabin Hait32251022014-08-29 11:18:32 +0530527 'party_type': None,
Nabin Hait591a5ab2016-05-26 17:41:39 +0530528 'party': None,
529 'project': self.get("project")
Nabin Hait2e296fa2013-08-28 18:53:11 +0530530 })
deepeshgarg007d83cf652019-05-12 18:34:23 +0530531
532 accounting_dimensions = get_accounting_dimensions()
533 dimension_dict = frappe._dict()
534
535 for dimension in accounting_dimensions:
536 dimension_dict[dimension] = self.get(dimension)
deepeshgarg0073d11ac02019-05-19 00:02:01 +0530537 if item and item.get(dimension):
538 dimension_dict[dimension] = item.get(dimension)
deepeshgarg007d83cf652019-05-12 18:34:23 +0530539
540 gl_dict.update(dimension_dict)
Nabin Hait2df4d542013-01-29 11:34:39 +0530541 gl_dict.update(args)
Anand Doshi979326b2015-09-11 16:22:37 +0530542
Nabin Hait895029d2015-08-20 14:55:39 +0530543 if not account_currency:
Anand Doshicd0989e2015-09-28 13:31:17 +0530544 account_currency = get_account_currency(gl_dict.account)
Anand Doshi979326b2015-09-11 16:22:37 +0530545
Rushabh Mehtabc4e2cd2017-10-17 12:30:34 +0530546 if gl_dict.account and self.doctype not in ["Journal Entry",
Deepesh Gargbfc17e42020-12-25 18:34:39 +0530547 "Period Closing Voucher", "Payment Entry", "Purchase Receipt", "Purchase Invoice", "Stock Entry"]:
Anand Doshibe6cfdd2015-09-17 21:07:04 +0530548 self.validate_account_currency(gl_dict.account, account_currency)
Deepesh Garg7c300852020-12-26 20:14:51 +0530549
550 if gl_dict.account and self.doctype not in ["Journal Entry", "Period Closing Voucher", "Payment Entry"]:
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800551 set_balance_in_account_currency(gl_dict, account_currency, self.get("conversion_rate"),
552 self.company_currency)
Anand Doshi979326b2015-09-11 16:22:37 +0530553
Nabin Haitc561a492015-08-19 19:22:34 +0530554 return gl_dict
Anand Doshi979326b2015-09-11 16:22:37 +0530555
Anurag Mishrae657fe82018-11-26 15:19:17 +0530556 def validate_qty_is_not_zero(self):
Maricac68a9402019-12-03 12:59:22 +0530557 if self.doctype != "Purchase Receipt":
558 for item in self.items:
559 if not item.qty:
560 frappe.throw(_("Item quantity can not be zero"))
Anurag Mishrae657fe82018-11-26 15:19:17 +0530561
Nabin Hait895029d2015-08-20 14:55:39 +0530562 def validate_account_currency(self, account, account_currency=None):
Nabin Hait6e439a52015-08-28 19:24:22 +0530563 valid_currency = [self.company_currency]
564 if self.get("currency") and self.currency != self.company_currency:
565 valid_currency.append(self.currency)
566
Nabin Hait895029d2015-08-20 14:55:39 +0530567 if account_currency not in valid_currency:
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530568 frappe.throw(_("Account {0} is invalid. Account Currency must be {1}")
Suraj Shettyda6806e2020-04-08 09:32:41 +0530569 .format(account, (' ' + _("or") + ' ').join(valid_currency)))
Anand Doshi979326b2015-09-11 16:22:37 +0530570
Anand Doshi613cb6a2013-02-06 17:33:46 +0530571 def clear_unallocated_advances(self, childtype, parentfield):
Rushabh Mehtaf191f852014-04-02 18:09:34 +0530572 self.set(parentfield, self.get(parentfield, {"allocated_amount": ["not in", [0, None, ""]]}))
573
Anand Doshid2946502014-04-08 20:10:03 +0530574 frappe.db.sql("""delete from `tab%s` where parentfield=%s and parent = %s
Anand Doshi602e8252015-11-16 19:05:46 +0530575 and allocated_amount = 0""" % (childtype, '%s', '%s'), (parentfield, self.name))
Anand Doshid2946502014-04-08 20:10:03 +0530576
Walstan Baptistad6360752021-03-31 12:30:32 +0530577 @frappe.whitelist()
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530578 def apply_shipping_rule(self):
579 if self.shipping_rule:
580 shipping_rule = frappe.get_doc("Shipping Rule", self.shipping_rule)
581 shipping_rule.apply(self)
582 self.calculate_taxes_and_totals()
583
584 def get_shipping_address(self):
585 '''Returns Address object from shipping address fields if present'''
586
587 # shipping address fields can be `shipping_address_name` or `shipping_address`
588 # try getting value from both
589
590 for fieldname in ('shipping_address_name', 'shipping_address'):
591 shipping_field = self.meta.get_field(fieldname)
592 if shipping_field and shipping_field.fieldtype == 'Link':
593 if self.get(fieldname):
594 return frappe.get_doc('Address', self.get(fieldname))
595
596 return {}
597
Walstan Baptistad6360752021-03-31 12:30:32 +0530598 @frappe.whitelist()
Nabin Hait041a5c22018-08-01 18:07:39 +0530599 def set_advances(self):
600 """Returns list of advances against Account, Party, Reference"""
601
602 res = self.get_advance_entries()
603
604 self.set("advances", [])
605 advance_allocated = 0
606 for d in res:
607 if d.against_order:
608 allocated_amount = flt(d.amount)
609 else:
Deepesh Garg26210162020-08-11 16:06:13 +0530610 if self.get('party_account_currency') == self.company_currency:
611 amount = self.get('base_rounded_total') or self.base_grand_total
612 else:
613 amount = self.get('rounded_total') or self.grand_total
614
Rohit Waghchaure6cc2f522018-11-27 12:07:03 +0530615 allocated_amount = min(amount - advance_allocated, d.amount)
Nabin Hait041a5c22018-08-01 18:07:39 +0530616 advance_allocated += flt(allocated_amount)
Rushabh Mehta708e47a2018-08-08 16:37:31 +0530617
Saqiba20999c2021-07-12 14:33:23 +0530618 advance_row = {
Nabin Hait041a5c22018-08-01 18:07:39 +0530619 "doctype": self.doctype + " Advance",
620 "reference_type": d.reference_type,
621 "reference_name": d.reference_name,
622 "reference_row": d.reference_row,
623 "remarks": d.remarks,
624 "advance_amount": flt(d.amount),
Saqiba20999c2021-07-12 14:33:23 +0530625 "allocated_amount": allocated_amount,
626 "ref_exchange_rate": flt(d.exchange_rate) # exchange_rate of advance entry
627 }
628
629 self.append("advances", advance_row)
Nabin Hait041a5c22018-08-01 18:07:39 +0530630
Nabin Hait28a05282016-06-27 17:41:39 +0530631 def get_advance_entries(self, include_unallocated=True):
632 if self.doctype == "Sales Invoice":
633 party_account = self.debit_to
634 party_type = "Customer"
635 party = self.customer
636 amount_field = "credit_in_account_currency"
637 order_field = "sales_order"
638 order_doctype = "Sales Order"
639 else:
640 party_account = self.credit_to
641 party_type = "Supplier"
642 party = self.supplier
643 amount_field = "debit_in_account_currency"
644 order_field = "purchase_order"
645 order_doctype = "Purchase Order"
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530646
Ankush Menat98917802021-06-11 18:40:22 +0530647 order_list = list(set(d.get(order_field)
648 for d in self.get("items") if d.get(order_field)))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530649
650 journal_entries = get_advance_journal_entries(party_type, party, party_account,
Nabin Hait868766d2019-07-15 18:02:58 +0530651 amount_field, order_doctype, order_list, include_unallocated)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530652
653 payment_entries = get_advance_payment_entries(party_type, party, party_account,
Nabin Hait868766d2019-07-15 18:02:58 +0530654 order_doctype, order_list, include_unallocated)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530655
Nabin Hait28a05282016-06-27 17:41:39 +0530656 res = journal_entries + payment_entries
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530657
Nabin Hait28a05282016-06-27 17:41:39 +0530658 return res
Nabin Hait48f5fa62014-09-18 15:03:54 +0530659
rohitwaghchaurebf4c1142018-01-08 15:20:15 +0530660 def is_inclusive_tax(self):
Nabin Hait868766d2019-07-15 18:02:58 +0530661 is_inclusive = cint(frappe.db.get_single_value("Accounts Settings", "show_inclusive_tax_in_print"))
rohitwaghchaurebf4c1142018-01-08 15:20:15 +0530662
663 if is_inclusive:
664 is_inclusive = 0
665 if self.get("taxes", filters={"included_in_print_rate": 1}):
666 is_inclusive = 1
667
668 return is_inclusive
669
Nabin Hait28a05282016-06-27 17:41:39 +0530670 def validate_advance_entries(self):
Nabin Hait05aefbb2016-06-28 19:42:19 +0530671 order_field = "sales_order" if self.doctype == "Sales Invoice" else "purchase_order"
Ankush Menat98917802021-06-11 18:40:22 +0530672 order_list = list(set(d.get(order_field)
673 for d in self.get("items") if d.get(order_field)))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530674
Nabin Hait05aefbb2016-06-28 19:42:19 +0530675 if not order_list: return
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530676
Nabin Hait28a05282016-06-27 17:41:39 +0530677 advance_entries = self.get_advance_entries(include_unallocated=False)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530678
Nabin Hait28a05282016-06-27 17:41:39 +0530679 if advance_entries:
680 advance_entries_against_si = [d.reference_name for d in self.get("advances")]
681 for d in advance_entries:
682 if not advance_entries_against_si or d.reference_name not in advance_entries_against_si:
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800683 frappe.msgprint(_(
684 "Payment Entry {0} is linked against Order {1}, check if it should be pulled as advance in this invoice.")
Nabin Hait868766d2019-07-15 18:02:58 +0530685 .format(d.reference_name, d.against_order))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530686
Saqiba20999c2021-07-12 14:33:23 +0530687 def set_advance_gain_or_loss(self):
688 if not self.get("advances"):
689 return
690
691 for d in self.get("advances"):
692 advance_exchange_rate = d.ref_exchange_rate
693 if (d.allocated_amount and self.conversion_rate != 1
694 and self.conversion_rate != advance_exchange_rate):
695
696 base_allocated_amount_in_ref_rate = advance_exchange_rate * d.allocated_amount
697 base_allocated_amount_in_inv_rate = self.conversion_rate * d.allocated_amount
698 difference = base_allocated_amount_in_ref_rate - base_allocated_amount_in_inv_rate
699
700 d.exchange_gain_loss = difference
701
702 def make_exchange_gain_loss_gl_entries(self, gl_entries):
703 if self.get('doctype') in ['Purchase Invoice', 'Sales Invoice']:
704 for d in self.get("advances"):
705 if d.exchange_gain_loss:
Saqibd4ae1fe2021-07-30 11:21:49 +0530706 is_purchase_invoice = self.get('doctype') == 'Purchase Invoice'
707 party = self.supplier if is_purchase_invoice else self.customer
708 party_account = self.credit_to if is_purchase_invoice else self.debit_to
709 party_type = "Supplier" if is_purchase_invoice else "Customer"
Saqiba20999c2021-07-12 14:33:23 +0530710
711 gain_loss_account = frappe.db.get_value('Company', self.company, 'exchange_gain_loss_account')
Saqibd4ae1fe2021-07-30 11:21:49 +0530712 if not gain_loss_account:
713 frappe.throw(_("Please set Default Exchange Gain/Loss Account in Company {}")
714 .format(self.get('company')))
Saqiba20999c2021-07-12 14:33:23 +0530715 account_currency = get_account_currency(gain_loss_account)
716 if account_currency != self.company_currency:
Saqibd4ae1fe2021-07-30 11:21:49 +0530717 frappe.throw(_("Currency for {0} must be {1}").format(gain_loss_account, self.company_currency))
Saqiba20999c2021-07-12 14:33:23 +0530718
719 # for purchase
720 dr_or_cr = 'debit' if d.exchange_gain_loss > 0 else 'credit'
Saqibd4ae1fe2021-07-30 11:21:49 +0530721 if not is_purchase_invoice:
722 # just reverse for sales?
723 dr_or_cr = 'debit' if dr_or_cr == 'credit' else 'credit'
Saqiba20999c2021-07-12 14:33:23 +0530724
725 gl_entries.append(
726 self.get_gl_dict({
727 "account": gain_loss_account,
728 "account_currency": account_currency,
729 "against": party,
730 dr_or_cr + "_in_account_currency": abs(d.exchange_gain_loss),
731 dr_or_cr: abs(d.exchange_gain_loss),
732 "cost_center": self.cost_center,
733 "project": self.project
734 }, item=d)
735 )
736
737 dr_or_cr = 'debit' if dr_or_cr == 'credit' else 'credit'
738
739 gl_entries.append(
740 self.get_gl_dict({
741 "account": party_account,
742 "party_type": party_type,
743 "party": party,
744 "against": gain_loss_account,
745 dr_or_cr + "_in_account_currency": flt(abs(d.exchange_gain_loss) / self.conversion_rate),
746 dr_or_cr: abs(d.exchange_gain_loss),
747 "cost_center": self.cost_center,
748 "project": self.project
749 }, self.party_account_currency, item=self)
750 )
751
Nabin Hait28a05282016-06-27 17:41:39 +0530752 def update_against_document_in_jv(self):
753 """
754 Links invoice and advance voucher:
755 1. cancel advance voucher
756 2. split into multiple rows if partially adjusted, assign against voucher
757 3. submit advance voucher
758 """
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530759
Nabin Hait28a05282016-06-27 17:41:39 +0530760 if self.doctype == "Sales Invoice":
Nabin Haitff2f3ef2016-07-04 11:41:14 +0530761 party_type = "Customer"
Nabin Hait28a05282016-06-27 17:41:39 +0530762 party = self.customer
763 party_account = self.debit_to
764 dr_or_cr = "credit_in_account_currency"
765 else:
Nabin Haitff2f3ef2016-07-04 11:41:14 +0530766 party_type = "Supplier"
Nabin Hait28a05282016-06-27 17:41:39 +0530767 party = self.supplier
768 party_account = self.credit_to
769 dr_or_cr = "debit_in_account_currency"
Nabin Hait48f5fa62014-09-18 15:03:54 +0530770
Nabin Hait28a05282016-06-27 17:41:39 +0530771 lst = []
772 for d in self.get('advances'):
773 if flt(d.allocated_amount) > 0:
774 args = frappe._dict({
775 'voucher_type': d.reference_type,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800776 'voucher_no': d.reference_name,
777 'voucher_detail_no': d.reference_row,
778 'against_voucher_type': self.doctype,
779 'against_voucher': self.name,
780 'account': party_account,
Nabin Haitff2f3ef2016-07-04 11:41:14 +0530781 'party_type': party_type,
Nabin Hait28a05282016-06-27 17:41:39 +0530782 'party': party,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800783 'is_advance': 'Yes',
784 'dr_or_cr': dr_or_cr,
785 'unadjusted_amount': flt(d.advance_amount),
786 'allocated_amount': flt(d.allocated_amount),
Deepesh Gargf54d5962021-03-31 14:06:02 +0530787 'precision': d.precision('advance_amount'),
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530788 'exchange_rate': (self.conversion_rate
Nabin Hait868766d2019-07-15 18:02:58 +0530789 if self.party_account_currency != self.company_currency else 1),
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530790 'grand_total': (self.base_grand_total
Nabin Hait868766d2019-07-15 18:02:58 +0530791 if self.party_account_currency == self.company_currency else self.grand_total),
Saqiba20999c2021-07-12 14:33:23 +0530792 'outstanding_amount': self.outstanding_amount,
793 'difference_account': frappe.db.get_value('Company', self.company, 'exchange_gain_loss_account'),
794 'exchange_gain_loss': flt(d.get('exchange_gain_loss'))
Nabin Hait28a05282016-06-27 17:41:39 +0530795 })
796 lst.append(args)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530797
Nabin Hait28a05282016-06-27 17:41:39 +0530798 if lst:
799 from erpnext.accounts.utils import reconcile_against_document
800 reconcile_against_document(lst)
Anand Doshid2946502014-04-08 20:10:03 +0530801
Rohit Waghchaure5fa9a7a2019-04-01 00:40:38 +0530802 def on_cancel(self):
803 from erpnext.accounts.utils import unlink_ref_doc_from_payment_entries
804
805 if self.doctype in ["Sales Invoice", "Purchase Invoice"]:
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530806 self.update_allocated_advance_taxes_on_cancel()
Rohit Waghchaure5fa9a7a2019-04-01 00:40:38 +0530807 if frappe.db.get_single_value('Accounts Settings', 'unlink_payment_on_cancellation_of_invoice'):
808 unlink_ref_doc_from_payment_entries(self)
809
810 elif self.doctype in ["Sales Order", "Purchase Order"]:
Rohit Waghchaure9835c892019-04-01 01:02:06 +0530811 if frappe.db.get_single_value('Accounts Settings', 'unlink_advance_payment_on_cancelation_of_order'):
Rohit Waghchaure5fa9a7a2019-04-01 00:40:38 +0530812 unlink_ref_doc_from_payment_entries(self)
813
Deepesh Gargd18dde72020-11-29 21:40:04 +0530814 def get_tax_map(self):
815 tax_map = {}
816 for tax in self.get('taxes'):
817 tax_map.setdefault(tax.account_head, 0.0)
818 tax_map[tax.account_head] += tax.tax_amount
819
820 return tax_map
821
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530822 def update_allocated_advance_taxes_on_cancel(self):
Deepesh Gargd18dde72020-11-29 21:40:04 +0530823 if self.get('advances'):
824 tax_accounts = [d.account_head for d in self.get('taxes')]
825 allocated_tax_map = frappe._dict(frappe.get_all('GL Entry', fields=['account', 'sum(credit - debit)'],
826 filters={'voucher_no': self.name, 'account': ('in', tax_accounts)},
827 group_by='account', as_list=1))
828
829 tax_map = self.get_tax_map()
830
831 for pe in self.get('advances'):
Deepesh Garga23aaf42021-05-17 20:58:50 +0530832 if pe.reference_type == 'Payment Entry':
833 pe = frappe.get_doc('Payment Entry', pe.reference_name)
834 for tax in pe.get('taxes'):
835 allocated_amount = tax_map.get(tax.account_head) - allocated_tax_map.get(tax.account_head)
836 if allocated_amount > tax.tax_amount:
837 allocated_amount = tax.tax_amount
Deepesh Gargd18dde72020-11-29 21:40:04 +0530838
Deepesh Garga23aaf42021-05-17 20:58:50 +0530839 if allocated_amount:
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530840 frappe.db.set_value('Advance Taxes and Charges', tax.name, 'allocated_amount',
841 tax.allocated_amount - allocated_amount)
Deepesh Garga23aaf42021-05-17 20:58:50 +0530842 tax_map[tax.account_head] -= allocated_amount
843 allocated_tax_map[tax.account_head] -= allocated_amount
Deepesh Gargd18dde72020-11-29 21:40:04 +0530844
Deepesh Garg92f7a5a2021-07-21 15:25:40 +0530845 def get_amount_and_base_amount(self, item, enable_discount_accounting):
846 amount = item.net_amount
847 base_amount = item.base_net_amount
848
849 if enable_discount_accounting and self.get('discount_amount') and self.get('additional_discount_account'):
850 amount = item.amount
851 base_amount = item.base_amount
852
853 return amount, base_amount
854
855 def get_tax_amounts(self, tax, enable_discount_accounting):
856 amount = tax.tax_amount_after_discount_amount
857 base_amount = tax.base_tax_amount_after_discount_amount
858
859 if enable_discount_accounting and self.get('discount_amount') and self.get('additional_discount_account') \
860 and self.get('apply_discount_on') == 'Grand Total':
861 amount = tax.tax_amount
862 base_amount = tax.base_tax_amount
863
864 return amount, base_amount
865
GangaManoj8f7b0a12021-07-13 03:01:02 +0530866 def make_discount_gl_entries(self, gl_entries):
867 enable_discount_accounting = cint(frappe.db.get_single_value('Accounts Settings', 'enable_discount_accounting'))
868
869 if enable_discount_accounting:
GangaManoj4105e272021-07-20 03:46:02 +0530870 if self.doctype == "Purchase Invoice":
871 dr_or_cr = "credit"
872 rev_dr_cr = "debit"
873 supplier_or_customer = self.supplier
Ankush Menat4551d7d2021-08-19 13:41:10 +0530874
GangaManoj4105e272021-07-20 03:46:02 +0530875 else:
876 dr_or_cr = "debit"
877 rev_dr_cr = "credit"
878 supplier_or_customer = self.customer
879
GangaManoj8f7b0a12021-07-13 03:01:02 +0530880 for item in self.get("items"):
881 if item.get('discount_amount') and item.get('discount_account'):
Deepesh Gargad7bb312021-07-28 11:38:44 +0530882 discount_amount = item.discount_amount * item.qty
GangaManoj8f7b0a12021-07-13 03:01:02 +0530883 if self.doctype == "Purchase Invoice":
GangaManoj8f7b0a12021-07-13 03:01:02 +0530884 income_or_expense_account = (item.expense_account
Ankush Menat4551d7d2021-08-19 13:41:10 +0530885 if (not item.enable_deferred_expense or self.is_return)
GangaManoj8f7b0a12021-07-13 03:01:02 +0530886 else item.deferred_expense_account)
887 else:
GangaManoj8f7b0a12021-07-13 03:01:02 +0530888 income_or_expense_account = (item.income_account
Ankush Menat4551d7d2021-08-19 13:41:10 +0530889 if (not item.enable_deferred_revenue or self.is_return)
GangaManoj8f7b0a12021-07-13 03:01:02 +0530890 else item.deferred_revenue_account)
891
892 account_currency = get_account_currency(item.discount_account)
893 gl_entries.append(
894 self.get_gl_dict({
895 "account": item.discount_account,
896 "against": supplier_or_customer,
Deepesh Gargad7bb312021-07-28 11:38:44 +0530897 dr_or_cr: flt(discount_amount, item.precision('discount_amount')),
Ankush Menat4551d7d2021-08-19 13:41:10 +0530898 dr_or_cr + "_in_account_currency": flt(discount_amount * self.get('conversion_rate'),
Deepesh Gargad7bb312021-07-28 11:38:44 +0530899 item.precision('discount_amount')),
Ganga Manoj980798c2021-07-19 23:43:36 +0530900 "cost_center": item.cost_center,
Ganga Manoj63b7ecd2021-07-19 23:44:21 +0530901 "project": item.project
Ganga Manoj0ea29342021-07-19 23:44:55 +0530902 }, account_currency, item=item)
GangaManoj8f7b0a12021-07-13 03:01:02 +0530903 )
904
905 account_currency = get_account_currency(income_or_expense_account)
906 gl_entries.append(
907 self.get_gl_dict({
908 "account": income_or_expense_account,
909 "against": supplier_or_customer,
Deepesh Gargad7bb312021-07-28 11:38:44 +0530910 rev_dr_cr: flt(discount_amount, item.precision('discount_amount')),
Ankush Menat4551d7d2021-08-19 13:41:10 +0530911 rev_dr_cr + "_in_account_currency": flt(discount_amount * self.get('conversion_rate'),
Deepesh Gargad7bb312021-07-28 11:38:44 +0530912 item.precision('discount_amount')),
GangaManoj8f7b0a12021-07-13 03:01:02 +0530913 "cost_center": item.cost_center,
914 "project": item.project or self.project
915 }, account_currency, item=item)
916 )
GangaManoj857501c2021-07-15 22:03:46 +0530917
GangaManoj4105e272021-07-20 03:46:02 +0530918 if self.get('discount_amount') and self.get('additional_discount_account'):
GangaManoj857501c2021-07-15 22:03:46 +0530919 gl_entries.append(
920 self.get_gl_dict({
921 "account": self.additional_discount_account,
GangaManoj4105e272021-07-20 03:46:02 +0530922 "against": supplier_or_customer,
923 dr_or_cr: self.discount_amount,
924 "cost_center": self.cost_center
925 }, item=self)
Ankush Menat4551d7d2021-08-19 13:41:10 +0530926 )
927
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530928 def allocate_advance_taxes(self, gl_entries):
929 tax_map = self.get_tax_map()
930 for pe in self.get("advances"):
Deepesh Garg911818a2021-06-09 22:55:10 +0530931 if pe.reference_type == "Payment Entry" and \
932 frappe.db.get_value('Payment Entry', pe.reference_name, 'advance_tax_account'):
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530933 pe = frappe.get_doc("Payment Entry", pe.reference_name)
934 for tax in pe.get("taxes"):
935 account_currency = get_account_currency(tax.account_head)
936
937 if self.doctype == "Purchase Invoice":
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530938 dr_or_cr = "debit" if tax.add_deduct_tax == "Add" else "credit"
939 rev_dr_cr = "credit" if tax.add_deduct_tax == "Add" else "debit"
Deepesh Garg4478c542021-07-13 11:22:55 +0530940 else:
941 dr_or_cr = "credit" if tax.add_deduct_tax == "Add" else "debit"
942 rev_dr_cr = "debit" if tax.add_deduct_tax == "Add" else "credit"
Deepesh Gargc9da1fc2021-05-19 18:38:35 +0530943
944 party = self.supplier if self.doctype == "Purchase Invoice" else self.customer
945 unallocated_amount = tax.tax_amount - tax.allocated_amount
946 if tax_map.get(tax.account_head):
947 amount = tax_map.get(tax.account_head)
948 if amount < unallocated_amount:
949 unallocated_amount = amount
950
951 gl_entries.append(
952 self.get_gl_dict({
953 "account": tax.account_head,
954 "against": party,
955 dr_or_cr: unallocated_amount,
956 dr_or_cr + "_in_account_currency": unallocated_amount
957 if account_currency==self.company_currency
958 else unallocated_amount,
959 "cost_center": tax.cost_center
960 }, account_currency, item=tax))
961
962 gl_entries.append(
963 self.get_gl_dict({
964 "account": pe.advance_tax_account,
965 "against": party,
966 rev_dr_cr: unallocated_amount,
967 rev_dr_cr + "_in_account_currency": unallocated_amount
968 if account_currency==self.company_currency
969 else unallocated_amount,
970 "cost_center": tax.cost_center
971 }, account_currency, item=tax))
972
973 frappe.db.set_value("Advance Taxes and Charges", tax.name, "allocated_amount",
974 tax.allocated_amount + unallocated_amount)
975
976 tax_map[tax.account_head] -= unallocated_amount
977
Nabin Hait19d945a2013-07-29 18:35:39 +0530978 def validate_multiple_billing(self, ref_dt, item_ref_dn, based_on, parentfield):
Nabin Hait868766d2019-07-15 18:02:58 +0530979 from erpnext.controllers.status_updater import get_allowance_for
980 item_allowance = {}
981 global_qty_allowance, global_amount_allowance = None, None
Anand Doshid2946502014-04-08 20:10:03 +0530982
Ankush Menat648b2d72021-09-20 15:27:12 +0530983 role_allowed_to_over_bill = frappe.db.get_single_value('Accounts Settings', 'role_allowed_to_over_bill')
984 user_roles = frappe.get_roles()
985
Ankush Menat43bf82b2021-09-20 16:31:20 +0530986 total_overbilled_amt = 0.0
987
Nabin Hait4b8185d2014-12-25 18:19:39 +0530988 for item in self.get("items"):
Ankush Menat5e4fbba2021-09-20 16:36:27 +0530989 if not item.get(item_ref_dn):
990 continue
Anand Doshid2946502014-04-08 20:10:03 +0530991
Ankush Menat5e4fbba2021-09-20 16:36:27 +0530992 ref_amt = flt(frappe.db.get_value(ref_dt + " Item",
993 item.get(item_ref_dn), based_on), self.precision(based_on, item))
994 if not ref_amt:
995 frappe.msgprint(
Ankush Menat21a955d2021-09-20 16:58:23 +0530996 _("System will not check overbilling since amount for Item {0} in {1} is zero")
997 .format(item.item_code, ref_dt), title=_("Warning"), indicator="orange")
Ankush Menat5e4fbba2021-09-20 16:36:27 +0530998 continue
Anand Doshid2946502014-04-08 20:10:03 +0530999
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301000 already_billed = frappe.db.sql("""
1001 select sum(%s)
1002 from `tab%s`
1003 where %s=%s and docstatus=1 and parent != %s
1004 """ % (based_on, self.doctype + " Item", item_ref_dn, '%s', '%s'),
Ankush Menat21a955d2021-09-20 16:58:23 +05301005 (item.get(item_ref_dn), self.name))[0][0]
Anand Doshid2946502014-04-08 20:10:03 +05301006
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301007 total_billed_amt = flt(flt(already_billed) + flt(item.get(based_on)),
1008 self.precision(based_on, item))
Anand Doshid2946502014-04-08 20:10:03 +05301009
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301010 allowance, item_allowance, global_qty_allowance, global_amount_allowance = \
1011 get_allowance_for(item.item_code, item_allowance, global_qty_allowance, global_amount_allowance, "amount")
rohitwaghchaure285344e2019-10-11 11:02:11 +05301012
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301013 max_allowed_amt = flt(ref_amt * (100 + allowance) / 100)
Ankush Menat43bf82b2021-09-20 16:31:20 +05301014
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301015 if total_billed_amt < 0 and max_allowed_amt < 0:
1016 # while making debit note against purchase return entry(purchase receipt) getting overbill error
1017 total_billed_amt = abs(total_billed_amt)
1018 max_allowed_amt = abs(max_allowed_amt)
Afshan53fefd72021-06-24 10:09:02 +05301019
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301020 overbill_amt = total_billed_amt - max_allowed_amt
1021 total_overbilled_amt += overbill_amt
1022
1023 if overbill_amt > 0.01 and role_allowed_to_over_bill not in user_roles:
1024 if self.doctype != "Purchase Invoice":
1025 self.throw_overbill_exception(item, max_allowed_amt)
1026 elif not cint(frappe.db.get_single_value("Buying Settings", "bill_for_rejected_quantity_in_purchase_invoice")):
1027 self.throw_overbill_exception(item, max_allowed_amt)
1028
1029 if role_allowed_to_over_bill in user_roles and total_overbilled_amt > 0.1:
Ankush Menat21a955d2021-09-20 16:58:23 +05301030 frappe.msgprint(_("Overbilling of {} ignored because you have {} role.")
1031 .format(total_overbilled_amt, role_allowed_to_over_bill), title=_("Warning"), indicator="orange")
Ankush Menat43bf82b2021-09-20 16:31:20 +05301032
Afshan53fefd72021-06-24 10:09:02 +05301033 def throw_overbill_exception(self, item, max_allowed_amt):
1034 frappe.throw(_("Cannot overbill for Item {0} in row {1} more than {2}. To allow over-billing, please set allowance in Accounts Settings")
1035 .format(item.item_code, item.idx, max_allowed_amt))
Anand Doshid2946502014-04-08 20:10:03 +05301036
Rohit Waghchaure2a14f252021-07-30 12:36:35 +05301037 def get_company_default(self, fieldname, ignore_validation=False):
Rushabh Mehta1f847992013-12-12 19:12:19 +05301038 from erpnext.accounts.utils import get_company_default
Rohit Waghchaure2a14f252021-07-30 12:36:35 +05301039 return get_company_default(self.company, fieldname, ignore_validation=ignore_validation)
Anand Doshid2946502014-04-08 20:10:03 +05301040
Nabin Haita36adbd2013-08-02 14:50:12 +05301041 def get_stock_items(self):
1042 stock_items = []
Nabin Haitdd38a262014-12-26 13:15:21 +05301043 item_codes = list(set(item.item_code for item in self.get("items")))
Nabin Haita36adbd2013-08-02 14:50:12 +05301044 if item_codes:
Nabin Hait868766d2019-07-15 18:02:58 +05301045 stock_items = [r[0] for r in frappe.db.sql("""
1046 select name from `tabItem`
1047 where name in (%s) and is_stock_item=1
1048 """ % (", ".join((["%s"] * len(item_codes))),), item_codes)]
Anand Doshid2946502014-04-08 20:10:03 +05301049
Nabin Haita36adbd2013-08-02 14:50:12 +05301050 return stock_items
Anand Doshid2946502014-04-08 20:10:03 +05301051
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301052 def set_total_advance_paid(self):
1053 if self.doctype == "Sales Order":
Nabin Hait6e439a52015-08-28 19:24:22 +05301054 dr_or_cr = "credit_in_account_currency"
Deepesh Garg2a9c5ba2020-04-30 10:38:58 +05301055 rev_dr_or_cr = "debit_in_account_currency"
Nabin Haitb2206d12016-01-27 15:43:12 +05301056 party = self.customer
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301057 else:
Nabin Hait6e439a52015-08-28 19:24:22 +05301058 dr_or_cr = "debit_in_account_currency"
Deepesh Garg2a9c5ba2020-04-30 10:38:58 +05301059 rev_dr_or_cr = "credit_in_account_currency"
Nabin Haitb2206d12016-01-27 15:43:12 +05301060 party = self.supplier
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301061
Nabin Haitb2206d12016-01-27 15:43:12 +05301062 advance = frappe.db.sql("""
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301063 select
Deepesh Garg2a9c5ba2020-04-30 10:38:58 +05301064 account_currency, sum({dr_or_cr}) - sum({rev_dr_cr}) as amount
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301065 from
Nabin Hait12e2a512016-06-26 01:37:21 +05301066 `tabGL Entry`
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301067 where
Nabin Hait12e2a512016-06-26 01:37:21 +05301068 against_voucher_type = %s and against_voucher = %s and party=%s
1069 and docstatus = 1
Deepesh Garg2a9c5ba2020-04-30 10:38:58 +05301070 """.format(dr_or_cr=dr_or_cr, rev_dr_cr=rev_dr_or_cr), (self.doctype, self.name, party), as_dict=1) #nosec
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301071
Nabin Haitb2206d12016-01-27 15:43:12 +05301072 if advance:
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301073 advance = advance[0]
Deepesh Garg2a9c5ba2020-04-30 10:38:58 +05301074
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301075 advance_paid = flt(advance.amount, self.precision("advance_paid"))
1076 formatted_advance_paid = fmt_money(advance_paid, precision=self.precision("advance_paid"),
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001077 currency=advance.account_currency)
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301078
1079 frappe.db.set_value(self.doctype, self.name, "party_account_currency",
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001080 advance.account_currency)
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301081
1082 if advance.account_currency == self.currency:
finbyz5efc7972019-01-05 11:12:11 +05301083 order_total = self.get("rounded_total") or self.grand_total
1084 precision = "rounded_total" if self.get("rounded_total") else "grand_total"
Nabin Haitb2206d12016-01-27 15:43:12 +05301085 else:
finbyz5efc7972019-01-05 11:12:11 +05301086 order_total = self.get("base_rounded_total") or self.base_grand_total
1087 precision = "base_rounded_total" if self.get("base_rounded_total") else "base_grand_total"
Sagar Voraf733a392019-01-07 14:24:01 +05301088
finbyz5efc7972019-01-05 11:12:11 +05301089 formatted_order_total = fmt_money(order_total, precision=self.precision(precision),
1090 currency=advance.account_currency)
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301091
Nabin Hait9db1b222016-06-30 12:37:53 +05301092 if self.currency == self.company_currency and advance_paid > order_total:
Nabin Haitb2206d12016-01-27 15:43:12 +05301093 frappe.throw(_("Total advance ({0}) against Order {1} cannot be greater than the Grand Total ({2})")
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001094 .format(formatted_advance_paid, self.name, formatted_order_total))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301095
Nabin Hait13093b42016-06-29 18:04:37 +05301096 frappe.db.set_value(self.doctype, self.name, "advance_paid", advance_paid)
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301097
ankitjavalkarworke60822b2014-08-26 14:29:06 +05301098 @property
1099 def company_abbr(self):
Nabin Hait6a5695f2018-08-09 11:30:21 +05301100 if not hasattr(self, "_abbr"):
1101 self._abbr = frappe.db.get_value('Company', self.company, "abbr")
ankitjavalkarworke60822b2014-08-26 14:29:06 +05301102
1103 return self._abbr
1104
marination4be5b5c2020-10-08 19:08:27 +05301105 def raise_missing_debit_credit_account_error(self, party_type, party):
marination53b1a9a2020-11-03 15:45:25 +05301106 """Raise an error if debit to/credit to account does not exist."""
marination4be5b5c2020-10-08 19:08:27 +05301107 db_or_cr = frappe.bold("Debit To") if self.doctype == "Sales Invoice" else frappe.bold("Credit To")
1108 rec_or_pay = "Receivable" if self.doctype == "Sales Invoice" else "Payable"
1109
1110 link_to_party = frappe.utils.get_link_to_form(party_type, party)
1111 link_to_company = frappe.utils.get_link_to_form("Company", self.company)
1112
1113 message = _("{0} Account not found against Customer {1}.").format(db_or_cr, frappe.bold(party) or '')
1114 message += "<br>" + _("Please set one of the following:") + "<br>"
1115 message += "<br><ul><li>" + _("'Account' in the Accounting section of Customer {0}").format(link_to_party) + "</li>"
1116 message += "<li>" + _("'Default {0} Account' in Company {1}").format(rec_or_pay, link_to_company) + "</li></ul>"
1117
marination53b1a9a2020-11-03 15:45:25 +05301118 frappe.throw(message, title=_("Account Missing"), exc=AccountMissingError)
marination4be5b5c2020-10-08 19:08:27 +05301119
Neil Trini Lasrado3fbbb712015-07-17 12:10:12 +05301120 def validate_party(self):
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301121 party_type, party = self.get_party()
shreyaseba9ca42016-01-26 14:56:52 +05301122 validate_party_frozen_disabled(party_type, party)
Anand Doshi979326b2015-09-11 16:22:37 +05301123
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301124 def get_party(self):
Neil Trini Lasrado79bf2332015-07-20 13:03:48 +05301125 party_type = None
shreyas29b565f2016-01-25 17:30:49 +05301126 if self.doctype in ("Opportunity", "Quotation", "Sales Order", "Delivery Note", "Sales Invoice"):
shreyaseba9ca42016-01-26 14:56:52 +05301127 party_type = 'Customer'
shreyas29b565f2016-01-25 17:30:49 +05301128
1129 elif self.doctype in ("Supplier Quotation", "Purchase Order", "Purchase Receipt", "Purchase Invoice"):
shreyaseba9ca42016-01-26 14:56:52 +05301130 party_type = 'Supplier'
shreyas29b565f2016-01-25 17:30:49 +05301131
1132 elif self.meta.get_field("customer"):
1133 party_type = "Customer"
Neil Trini Lasrado3fbbb712015-07-17 12:10:12 +05301134
Neil Trini Lasrado79bf2332015-07-20 13:03:48 +05301135 elif self.meta.get_field("supplier"):
shreyas29b565f2016-01-25 17:30:49 +05301136 party_type = "Supplier"
Anand Doshi979326b2015-09-11 16:22:37 +05301137
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301138 party = self.get(party_type.lower()) if party_type else None
Anand Doshi979326b2015-09-11 16:22:37 +05301139
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301140 return party_type, party
Anand Doshi979326b2015-09-11 16:22:37 +05301141
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301142 def validate_currency(self):
Nabin Hait6e439a52015-08-28 19:24:22 +05301143 if self.get("currency"):
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301144 party_type, party = self.get_party()
Nabin Hait6e439a52015-08-28 19:24:22 +05301145 if party_type and party:
Anand Doshib20baf82015-09-25 16:17:50 +05301146 party_account_currency = get_party_account_currency(party_type, party, self.company)
Anand Doshi979326b2015-09-11 16:22:37 +05301147
Anand Doshi7afaeb02015-10-01 18:55:25 +05301148 if (party_account_currency
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001149 and party_account_currency != self.company_currency
1150 and self.currency != party_account_currency):
Nabin Hait98096772015-09-03 10:28:08 +05301151 frappe.throw(_("Accounting Entry for {0}: {1} can only be made in currency: {2}")
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001152 .format(party_type, party, party_account_currency), InvalidCurrency)
Anand Doshi979326b2015-09-11 16:22:37 +05301153
shreyas29b565f2016-01-25 17:30:49 +05301154 # Note: not validating with gle account because we don't have the account
1155 # at quotation / sales order level and we shouldn't stop someone
1156 # from creating a sales invoice if sales order is already created
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +05301157
Nabin Hait297d74a2016-11-23 15:58:51 +05301158 def delink_advance_entries(self, linked_doc_name):
1159 total_allocated_amount = 0
1160 for adv in self.advances:
1161 consider_for_total_advance = True
1162 if adv.reference_name == linked_doc_name:
1163 frappe.db.sql("""delete from `tab{0} Advance`
1164 where name = %s""".format(self.doctype), adv.name)
1165 consider_for_total_advance = False
1166
1167 if consider_for_total_advance:
1168 total_allocated_amount += flt(adv.allocated_amount, adv.precision("allocated_amount"))
1169
Rushabh Mehta66958302017-01-16 16:57:53 +05301170 frappe.db.set_value(self.doctype, self.name, "total_advance",
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001171 total_allocated_amount, update_modified=False)
Rohit Waghchaure6087fe12016-04-09 14:31:09 +05301172
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301173 def group_similar_items(self):
1174 group_item_qty = {}
1175 group_item_amount = {}
Shreya Shah785f1aa2018-10-11 10:14:25 +05301176 # to update serial number in print
1177 count = 0
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301178
1179 for item in self.items:
1180 group_item_qty[item.item_code] = group_item_qty.get(item.item_code, 0) + item.qty
1181 group_item_amount[item.item_code] = group_item_amount.get(item.item_code, 0) + item.amount
1182
1183 duplicate_list = []
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301184 for item in self.items:
1185 if item.item_code in group_item_qty:
Shreya Shah785f1aa2018-10-11 10:14:25 +05301186 count += 1
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301187 item.qty = group_item_qty[item.item_code]
1188 item.amount = group_item_amount[item.item_code]
deepeshgarg007e8d21cd2019-06-24 17:46:44 +05301189
1190 if item.qty:
1191 item.rate = flt(flt(item.amount) / flt(item.qty), item.precision("rate"))
1192 else:
1193 item.rate = 0
1194
Shreya Shah785f1aa2018-10-11 10:14:25 +05301195 item.idx = count
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301196 del group_item_qty[item.item_code]
1197 else:
1198 duplicate_list.append(item)
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301199 for item in duplicate_list:
1200 self.remove(item)
1201
tunde32aa7c12017-09-07 06:52:15 +01001202 def set_payment_schedule(self):
Manas Solankia7f55892018-04-02 10:32:00 +05301203 if self.doctype == 'Sales Invoice' and self.is_pos:
1204 self.payment_terms_template = ''
1205 return
rohitwaghchauredb9fa782018-03-01 10:32:29 +05301206
Deepesh Garg26210162020-08-11 16:06:13 +05301207 party_account_currency = self.get('party_account_currency')
1208 if not party_account_currency:
1209 party_type, party = self.get_party()
1210
1211 if party_type and party:
1212 party_account_currency = get_party_account_currency(party_type, party, self.company)
1213
rohitwaghchaureda941af2018-01-17 16:23:04 +05301214 posting_date = self.get("bill_date") or self.get("posting_date") or self.get("transaction_date")
tundedf3a1752017-09-11 11:02:57 +01001215 date = self.get("due_date")
1216 due_date = date or posting_date
Deepesh Garg26210162020-08-11 16:06:13 +05301217
Saqib Ansarid552fe62021-04-23 14:46:52 +05301218 base_grand_total = self.get("base_rounded_total") or self.base_grand_total
1219 grand_total = self.get("rounded_total") or self.grand_total
Deepesh Garg26210162020-08-11 16:06:13 +05301220
Nabin Hait2f9f4f92017-12-20 12:24:59 +05301221 if self.doctype in ("Sales Invoice", "Purchase Invoice"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301222 base_grand_total = base_grand_total - flt(self.base_write_off_amount)
Nabin Hait2f9f4f92017-12-20 12:24:59 +05301223 grand_total = grand_total - flt(self.write_off_amount)
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301224 po_or_so, doctype, fieldname = self.get_order_details()
1225 automatically_fetch_payment_terms = cint(frappe.db.get_single_value('Accounts Settings', 'automatically_fetch_payment_terms'))
tunde96b8f222017-09-08 15:35:59 +01001226
Rohit Waghchaure4a267b92019-05-09 19:50:00 +05301227 if self.get("total_advance"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301228 if party_account_currency == self.company_currency:
1229 base_grand_total -= self.get("total_advance")
1230 grand_total = flt(base_grand_total / self.get("conversion_rate"), self.precision("grand_total"))
1231 else:
1232 grand_total -= self.get("total_advance")
1233 base_grand_total = flt(grand_total * self.get("conversion_rate"), self.precision("base_grand_total"))
Rohit Waghchaure4a267b92019-05-09 19:50:00 +05301234
Nabin Hait0551f7b2017-11-21 19:58:16 +05301235 if not self.get("payment_schedule"):
Deepesh Gargbff3b092021-08-07 00:12:57 +05301236 if self.doctype in ["Sales Invoice", "Purchase Invoice"] and automatically_fetch_payment_terms \
1237 and self.linked_order_has_payment_terms(po_or_so, fieldname, doctype):
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301238 self.fetch_payment_terms_from_order(po_or_so, doctype)
1239 if self.get('payment_terms_template'):
1240 self.ignore_default_payment_terms_template = 1
1241 elif self.get("payment_terms_template"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301242 data = get_payment_terms(self.payment_terms_template, posting_date, grand_total, base_grand_total)
Nabin Hait0551f7b2017-11-21 19:58:16 +05301243 for item in data:
1244 self.append("payment_schedule", item)
GangaManoj4323f4b2021-07-22 05:57:42 +05301245 elif self.doctype not in ["Purchase Receipt"]:
Saqib Ansarida5b55c2021-04-28 14:55:33 +05301246 data = dict(due_date=due_date, invoice_portion=100, payment_amount=grand_total, base_payment_amount=base_grand_total)
Nabin Hait0551f7b2017-11-21 19:58:16 +05301247 self.append("payment_schedule", data)
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301248
1249 for d in self.get("payment_schedule"):
1250 if d.invoice_portion:
1251 d.payment_amount = flt(grand_total * flt(d.invoice_portion / 100), d.precision('payment_amount'))
1252 d.base_payment_amount = flt(base_grand_total * flt(d.invoice_portion / 100), d.precision('base_payment_amount'))
1253 d.outstanding = d.payment_amount
1254 elif not d.invoice_portion:
Frappe PR Bot81fb4932021-08-31 19:01:03 +05301255 d.base_payment_amount = flt(d.payment_amount * self.get("conversion_rate"), d.precision('base_payment_amount'))
Subin Tomfac88a32021-07-23 21:23:48 +05301256
tunde43870aa2017-08-18 11:59:30 +01001257
GangaManoj4323f4b2021-07-22 05:57:42 +05301258 def get_order_details(self):
1259 if self.doctype == "Sales Invoice":
1260 po_or_so = self.get('items')[0].get('sales_order')
1261 po_or_so_doctype = "Sales Order"
1262 po_or_so_doctype_name = "sales_order"
1263
tunde43870aa2017-08-18 11:59:30 +01001264 else:
GangaManoj4323f4b2021-07-22 05:57:42 +05301265 po_or_so = self.get('items')[0].get('purchase_order')
1266 po_or_so_doctype = "Purchase Order"
1267 po_or_so_doctype_name = "purchase_order"
Ankush Menat4551d7d2021-08-19 13:41:10 +05301268
GangaManoj4323f4b2021-07-22 05:57:42 +05301269 return po_or_so, po_or_so_doctype, po_or_so_doctype_name
1270
GangaManojc7c90242021-07-29 19:18:35 +05301271 def linked_order_has_payment_terms(self, po_or_so, fieldname, doctype):
GangaManoj4323f4b2021-07-22 05:57:42 +05301272 if po_or_so and self.all_items_have_same_po_or_so(po_or_so, fieldname):
GangaManojc7c90242021-07-29 19:18:35 +05301273 if self.linked_order_has_payment_terms_template(po_or_so, doctype):
GangaManoj4323f4b2021-07-22 05:57:42 +05301274 return True
1275 elif self.linked_order_has_payment_schedule(po_or_so):
1276 return True
Ankush Menat4551d7d2021-08-19 13:41:10 +05301277
GangaManoj4323f4b2021-07-22 05:57:42 +05301278 return False
1279
1280 def all_items_have_same_po_or_so(self, po_or_so, fieldname):
1281 for item in self.get('items'):
1282 if item.get(fieldname) != po_or_so:
1283 return False
Ankush Menat4551d7d2021-08-19 13:41:10 +05301284
GangaManoj4323f4b2021-07-22 05:57:42 +05301285 return True
1286
GangaManojc7c90242021-07-29 19:18:35 +05301287 def linked_order_has_payment_terms_template(self, po_or_so, doctype):
1288 return frappe.get_value(doctype, po_or_so, 'payment_terms_template')
GangaManoj4323f4b2021-07-22 05:57:42 +05301289
1290 def linked_order_has_payment_schedule(self, po_or_so):
1291 return frappe.get_all('Payment Schedule', filters={'parent': po_or_so})
1292
1293 def fetch_payment_terms_from_order(self, po_or_so, po_or_so_doctype):
1294 """
1295 Fetch Payment Terms from Purchase/Sales Order on creating a new Purchase/Sales Invoice.
1296 """
1297 po_or_so = frappe.get_cached_doc(po_or_so_doctype, po_or_so)
1298
1299 self.payment_schedule = []
1300 self.payment_terms_template = po_or_so.payment_terms_template
1301
1302 for schedule in po_or_so.payment_schedule:
1303 payment_schedule = {
1304 'payment_term': schedule.payment_term,
1305 'due_date': schedule.due_date,
1306 'invoice_portion': schedule.invoice_portion,
GangaManoj5b33e752021-08-05 21:50:09 +05301307 'mode_of_payment': schedule.mode_of_payment,
1308 'description': schedule.description
GangaManoj4323f4b2021-07-22 05:57:42 +05301309 }
GangaManoj5b33e752021-08-05 21:50:09 +05301310
1311 if schedule.discount_type == 'Percentage':
1312 payment_schedule['discount_type'] = schedule.discount_type
1313 payment_schedule['discount'] = schedule.discount
1314
GangaManoj4323f4b2021-07-22 05:57:42 +05301315 self.append("payment_schedule", payment_schedule)
tunde43870aa2017-08-18 11:59:30 +01001316
tundebe1b8712017-08-19 08:21:44 +01001317 def set_due_date(self):
Nabin Hait0551f7b2017-11-21 19:58:16 +05301318 due_dates = [d.due_date for d in self.get("payment_schedule") if d.due_date]
1319 if due_dates:
1320 self.due_date = max(due_dates)
tunde62af5c52017-09-22 15:16:38 +01001321
1322 def validate_payment_schedule_dates(self):
tunde77ecacc2017-09-22 23:12:55 +01001323 dates = []
tunde9bed2de2017-09-25 10:19:35 +01001324 li = []
tunde43870aa2017-08-18 11:59:30 +01001325
rohitwaghchauredb9fa782018-03-01 10:32:29 +05301326 if self.doctype == 'Sales Invoice' and self.is_pos: return
1327
tunde43870aa2017-08-18 11:59:30 +01001328 for d in self.get("payment_schedule"):
Nabin Hait2f9f4f92017-12-20 12:24:59 +05301329 if self.doctype == "Sales Order" and getdate(d.due_date) < getdate(self.transaction_date):
Michelle Alva7f2477b2020-04-09 17:23:23 +05301330 frappe.throw(_("Row {0}: Due Date in the Payment Terms table cannot be before Posting Date").format(d.idx))
tunde77ecacc2017-09-22 23:12:55 +01001331 elif d.due_date in dates:
mnatalia5f0e8d62018-05-22 06:38:50 +03001332 li.append(_("{0} in row {1}").format(d.due_date, d.idx))
tunde9bed2de2017-09-25 10:19:35 +01001333 dates.append(d.due_date)
1334
1335 if li:
1336 duplicates = '<br>' + '<br>'.join(li)
Faris Ansari2ab6e0e2018-09-19 13:13:59 +05301337 frappe.throw(_("Rows with duplicate due dates in other rows were found: {0}").format(duplicates))
tunde43870aa2017-08-18 11:59:30 +01001338
tunde62af5c52017-09-22 15:16:38 +01001339 def validate_payment_schedule_amount(self):
rohitwaghchauredb9fa782018-03-01 10:32:29 +05301340 if self.doctype == 'Sales Invoice' and self.is_pos: return
1341
Deepesh Garg26210162020-08-11 16:06:13 +05301342 party_account_currency = self.get('party_account_currency')
1343 if not party_account_currency:
1344 party_type, party = self.get_party()
1345
1346 if party_type and party:
1347 party_account_currency = get_party_account_currency(party_type, party, self.company)
1348
Nabin Hait0551f7b2017-11-21 19:58:16 +05301349 if self.get("payment_schedule"):
1350 total = 0
Saqib Ansarid552fe62021-04-23 14:46:52 +05301351 base_total = 0
Nabin Hait0551f7b2017-11-21 19:58:16 +05301352 for d in self.get("payment_schedule"):
Nabin Haitf592f2c2017-12-19 11:31:34 +05301353 total += flt(d.payment_amount)
Saqib Ansarid552fe62021-04-23 14:46:52 +05301354 base_total += flt(d.base_payment_amount)
tunde43870aa2017-08-18 11:59:30 +01001355
Saqib Ansarid552fe62021-04-23 14:46:52 +05301356 base_grand_total = self.get("base_rounded_total") or self.base_grand_total
1357 grand_total = self.get("rounded_total") or self.grand_total
Rohit Waghchaure4a267b92019-05-09 19:50:00 +05301358
Nabin Haite591c852017-12-21 11:46:30 +05301359 if self.doctype in ("Sales Invoice", "Purchase Invoice"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301360 base_grand_total = base_grand_total - flt(self.base_write_off_amount)
Nabin Haite591c852017-12-21 11:46:30 +05301361 grand_total = grand_total - flt(self.write_off_amount)
Saqib Ansarid552fe62021-04-23 14:46:52 +05301362
1363 if self.get("total_advance"):
1364 if party_account_currency == self.company_currency:
1365 base_grand_total -= self.get("total_advance")
1366 grand_total = flt(base_grand_total / self.get("conversion_rate"), self.precision("grand_total"))
1367 else:
1368 grand_total -= self.get("total_advance")
1369 base_grand_total = flt(grand_total * self.get("conversion_rate"), self.precision("base_grand_total"))
Saqib Ansarid552fe62021-04-23 14:46:52 +05301370 if total != flt(grand_total, self.precision("grand_total")) or \
1371 base_total != flt(base_grand_total, self.precision("base_grand_total")):
Nabin Hait0551f7b2017-11-21 19:58:16 +05301372 frappe.throw(_("Total Payment Amount in Payment Schedule must be equal to Grand / Rounded Total"))
tunde43870aa2017-08-18 11:59:30 +01001373
Nabin Hait877e1bb2017-11-17 12:27:43 +05301374 def is_rounded_total_disabled(self):
1375 if self.meta.get_field("disable_rounded_total"):
1376 return self.disable_rounded_total
1377 else:
1378 return frappe.db.get_single_value("Global Defaults", "disable_rounded_total")
1379
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301380 def set_inter_company_account(self):
1381 """
1382 Set intercompany account for inter warehouse transactions
1383 This account will be used in case billing company and internal customer's
1384 representation company is same
1385 """
1386
1387 if self.is_internal_transfer() and not self.unrealized_profit_loss_account:
1388 unrealized_profit_loss_account = frappe.db.get_value('Company', self.company, 'unrealized_profit_loss_account')
1389
1390 if not unrealized_profit_loss_account:
1391 msg = _("Please select Unrealized Profit / Loss account or add default Unrealized Profit / Loss account account for company {0}").format(
1392 frappe.bold(self.company))
1393 frappe.throw(msg)
1394
1395 self.unrealized_profit_loss_account = unrealized_profit_loss_account
1396
1397 def is_internal_transfer(self):
1398 """
1399 It will an internal transfer if its an internal customer and representation
1400 company is same as billing company
1401 """
Deepesh Gargb4be2922021-01-28 13:09:56 +05301402 if self.doctype in ('Sales Invoice', 'Delivery Note', 'Sales Order'):
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301403 internal_party_field = 'is_internal_customer'
Deepesh Gargb4be2922021-01-28 13:09:56 +05301404 elif self.doctype in ('Purchase Invoice', 'Purchase Receipt', 'Purchase Order'):
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301405 internal_party_field = 'is_internal_supplier'
1406
1407 if self.get(internal_party_field) and (self.represents_company == self.company):
1408 return True
1409
1410 return False
1411
Saqib Ansari977b09b2021-08-19 17:57:30 +05301412 def process_common_party_accounting(self):
1413 is_invoice = self.doctype in ['Sales Invoice', 'Purchase Invoice']
1414 if not is_invoice:
1415 return
1416
1417 if frappe.db.get_single_value('Accounts Settings', 'enable_common_party_accounting'):
1418 party_link = self.get_common_party_link()
1419 if party_link and self.outstanding_amount:
1420 self.create_advance_and_reconcile(party_link)
1421
1422 def get_common_party_link(self):
1423 party_type, party = self.get_party()
Saqib Ansari72543682021-08-25 20:15:23 +05301424 return frappe.db.get_value(
1425 doctype='Party Link',
1426 filters={'secondary_role': party_type, 'secondary_party': party},
1427 fieldname=['primary_role', 'primary_party'],
1428 as_dict=True
1429 )
Saqib Ansari977b09b2021-08-19 17:57:30 +05301430
1431 def create_advance_and_reconcile(self, party_link):
1432 secondary_party_type, secondary_party = self.get_party()
1433 primary_party_type, primary_party = party_link.primary_role, party_link.primary_party
1434
1435 primary_account = get_party_account(primary_party_type, primary_party, self.company)
1436 secondary_account = get_party_account(secondary_party_type, secondary_party, self.company)
1437
1438 jv = frappe.new_doc('Journal Entry')
1439 jv.voucher_type = 'Journal Entry'
Saqib Ansari977b09b2021-08-19 17:57:30 +05301440 jv.posting_date = self.posting_date
1441 jv.company = self.company
1442 jv.remark = 'Adjustment for {} {}'.format(self.doctype, self.name)
1443
1444 reconcilation_entry = frappe._dict()
1445 advance_entry = frappe._dict()
Saqib Ansari977b09b2021-08-19 17:57:30 +05301446
1447 reconcilation_entry.account = secondary_account
1448 reconcilation_entry.party_type = secondary_party_type
1449 reconcilation_entry.party = secondary_party
1450 reconcilation_entry.reference_type = self.doctype
1451 reconcilation_entry.reference_name = self.name
Saqib Ansaric6c7a8b2021-08-25 20:17:04 +05301452 reconcilation_entry.cost_center = self.cost_center
Saqib Ansari977b09b2021-08-19 17:57:30 +05301453
1454 advance_entry.account = primary_account
1455 advance_entry.party_type = primary_party_type
1456 advance_entry.party = primary_party
Saqib Ansaric6c7a8b2021-08-25 20:17:04 +05301457 advance_entry.cost_center = self.cost_center
Saqib Ansari977b09b2021-08-19 17:57:30 +05301458 advance_entry.is_advance = 'Yes'
1459
1460 if self.doctype == 'Sales Invoice':
1461 reconcilation_entry.credit_in_account_currency = self.outstanding_amount
1462 advance_entry.debit_in_account_currency = self.outstanding_amount
1463 else:
1464 advance_entry.credit_in_account_currency = self.outstanding_amount
1465 reconcilation_entry.debit_in_account_currency = self.outstanding_amount
1466
1467 jv.append('accounts', reconcilation_entry)
1468 jv.append('accounts', advance_entry)
1469
1470 jv.save()
1471 jv.submit()
1472
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05301473@frappe.whitelist()
Rushabh Mehtaf56d73c2013-10-10 16:35:09 +05301474def get_tax_rate(account_head):
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +05301475 return frappe.db.get_value("Account", account_head, ["tax_rate", "account_name"], as_dict=True)
Rushabh Mehtaa33d4682015-06-01 17:15:42 +05301476
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001477
Nabin Haitffc7f3f2015-05-12 15:07:02 +05301478@frappe.whitelist()
Nabin Haita2426fc2018-01-15 17:45:46 +05301479def get_default_taxes_and_charges(master_doctype, tax_template=None, company=None):
rohitwaghchaure505661b2017-12-11 14:52:28 +05301480 if not company: return {}
1481
Nabin Haita2426fc2018-01-15 17:45:46 +05301482 if tax_template and company:
1483 tax_template_company = frappe.db.get_value(master_doctype, tax_template, "company")
1484 if tax_template_company == company:
1485 return
1486
1487 default_tax = frappe.db.get_value(master_doctype, {"is_default": 1, "company": company})
rohitwaghchaure505661b2017-12-11 14:52:28 +05301488
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301489 return {
1490 'taxes_and_charges': default_tax,
1491 'taxes': get_taxes_and_charges(master_doctype, default_tax)
1492 }
Nabin Hait6b039142014-05-02 15:45:10 +05301493
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001494
Nabin Hait6b039142014-05-02 15:45:10 +05301495@frappe.whitelist()
Nabin Haitffc7f3f2015-05-12 15:07:02 +05301496def get_taxes_and_charges(master_doctype, master_name):
Nabin Hait1fe50122015-05-16 12:14:39 +05301497 if not master_name:
1498 return
Nabin Hait6b039142014-05-02 15:45:10 +05301499 from frappe.model import default_fields
1500 tax_master = frappe.get_doc(master_doctype, master_name)
1501
1502 taxes_and_charges = []
Nabin Haitffc7f3f2015-05-12 15:07:02 +05301503 for i, tax in enumerate(tax_master.get("taxes")):
Nabin Hait6b039142014-05-02 15:45:10 +05301504 tax = tax.as_dict()
1505
1506 for fieldname in default_fields:
1507 if fieldname in tax:
1508 del tax[fieldname]
1509
1510 taxes_and_charges.append(tax)
1511
1512 return taxes_and_charges
Rushabh Mehta66e08e32014-09-29 12:17:03 +05301513
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001514
Rushabh Mehta66e08e32014-09-29 12:17:03 +05301515def validate_conversion_rate(currency, conversion_rate, conversion_rate_label, company):
1516 """common validation for currency and price list currency"""
1517
Rushabh Mehta708e47a2018-08-08 16:37:31 +05301518 company_currency = frappe.get_cached_value('Company', company, "default_currency")
Rushabh Mehta66e08e32014-09-29 12:17:03 +05301519
1520 if not conversion_rate:
Saqib60212ff2020-10-26 11:17:04 +05301521 throw(
1522 _("{0} is mandatory. Maybe Currency Exchange record is not created for {1} to {2}.")
1523 .format(conversion_rate_label, currency, company_currency)
1524 )
Nabin Hait613d0812015-02-23 11:58:15 +05301525
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001526
Nabin Hait613d0812015-02-23 11:58:15 +05301527def validate_taxes_and_charges(tax):
Deepesh Garg302855e2021-06-14 11:16:39 +05301528 if tax.charge_type in ['Actual', 'On Net Total', 'On Paid Amount'] and tax.row_id:
Nabin Hait613d0812015-02-23 11:58:15 +05301529 frappe.throw(_("Can refer row only if the charge type is 'On Previous Row Amount' or 'Previous Row Total'"))
Nabin Hait37b047d2015-02-23 16:01:33 +05301530 elif tax.charge_type in ['On Previous Row Amount', 'On Previous Row Total']:
Nabin Hait613d0812015-02-23 11:58:15 +05301531 if cint(tax.idx) == 1:
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001532 frappe.throw(
1533 _("Cannot select charge type as 'On Previous Row Amount' or 'On Previous Row Total' for first row"))
Nabin Hait613d0812015-02-23 11:58:15 +05301534 elif not tax.row_id:
Suraj Shetty48e9bc32020-01-29 15:06:18 +05301535 frappe.throw(_("Please specify a valid Row ID for row {0} in table {1}").format(tax.idx, _(tax.doctype)))
Nabin Hait613d0812015-02-23 11:58:15 +05301536 elif tax.row_id and cint(tax.row_id) >= cint(tax.idx):
1537 frappe.throw(_("Cannot refer row number greater than or equal to current row number for this Charge type"))
1538
Rushabh Mehta2a21bc92015-02-25 15:08:42 +05301539 if tax.charge_type == "Actual":
Nabin Haitbc6c3602015-02-27 23:40:56 +05301540 tax.rate = None
Rushabh Mehta2a21bc92015-02-25 15:08:42 +05301541
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001542
Anuja Pawar0e337be2021-08-10 17:26:35 +05301543def validate_account_head(tax, doc):
1544 company = frappe.get_cached_value('Account',
1545 tax.account_head, 'company')
1546
1547 if company != doc.company:
1548 frappe.throw(_('Row {0}: Account {1} does not belong to Company {2}')
1549 .format(tax.idx, frappe.bold(tax.account_head), frappe.bold(doc.company)), title=_('Invalid Account'))
1550
1551
1552def validate_cost_center(tax, doc):
1553 if not tax.cost_center:
1554 return
1555
1556 company = frappe.get_cached_value('Cost Center',
1557 tax.cost_center, 'company')
1558
1559 if company != doc.company:
1560 frappe.throw(_('Row {0}: Cost Center {1} does not belong to Company {2}')
1561 .format(tax.idx, frappe.bold(tax.cost_center), frappe.bold(doc.company)), title=_('Invalid Cost Center'))
1562
1563
Nabin Hait613d0812015-02-23 11:58:15 +05301564def validate_inclusive_tax(tax, doc):
1565 def _on_previous_row_error(row_range):
Deepesh Garg302855e2021-06-14 11:16:39 +05301566 throw(_("To include tax in row {0} in Item rate, taxes in rows {1} must also be included").format(tax.idx, row_range))
Nabin Hait613d0812015-02-23 11:58:15 +05301567
1568 if cint(getattr(tax, "included_in_print_rate", None)):
1569 if tax.charge_type == "Actual":
1570 # inclusive tax cannot be of type Actual
Deepesh Garg5ef9a622021-06-14 14:34:44 +05301571 throw(_("Charge of type 'Actual' in row {0} cannot be included in Item Rate or Paid Amount").format(tax.idx))
Nabin Hait613d0812015-02-23 11:58:15 +05301572 elif tax.charge_type == "On Previous Row Amount" and \
1573 not cint(doc.get("taxes")[cint(tax.row_id) - 1].included_in_print_rate):
1574 # referred row should also be inclusive
1575 _on_previous_row_error(tax.row_id)
1576 elif tax.charge_type == "On Previous Row Total" and \
1577 not all([cint(t.included_in_print_rate) for t in doc.get("taxes")[:cint(tax.row_id) - 1]]):
Deepesh Garg5ef9a622021-06-14 14:34:44 +05301578 # all rows about the referred tax should be inclusive
Nabin Hait613d0812015-02-23 11:58:15 +05301579 _on_previous_row_error("1 - %d" % (tax.row_id,))
Nabin Hait93b3a372015-02-24 17:08:34 +05301580 elif tax.get("category") == "Valuation":
Nabin Hait19ea7212020-08-11 20:34:57 +05301581 frappe.throw(_("Valuation type charges can not be marked as Inclusive"))
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05301582
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05301583
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001584def set_balance_in_account_currency(gl_dict, account_currency=None, conversion_rate=None, company_currency=None):
1585 if (not conversion_rate) and (account_currency != company_currency):
1586 frappe.throw(_("Account: {0} with currency: {1} can not be selected")
1587 .format(gl_dict.account, account_currency))
1588
1589 gl_dict["account_currency"] = company_currency if account_currency == company_currency \
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05301590 else account_currency
1591
1592 # set debit/credit in account currency if not provided
1593 if flt(gl_dict.debit) and not flt(gl_dict.debit_in_account_currency):
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001594 gl_dict.debit_in_account_currency = gl_dict.debit if account_currency == company_currency \
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05301595 else flt(gl_dict.debit / conversion_rate, 2)
1596
1597 if flt(gl_dict.credit) and not flt(gl_dict.credit_in_account_currency):
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001598 gl_dict.credit_in_account_currency = gl_dict.credit if account_currency == company_currency \
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05301599 else flt(gl_dict.credit / conversion_rate, 2)
Nabin Hait1991c7b2016-06-27 20:09:05 +05301600
1601
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301602def get_advance_journal_entries(party_type, party, party_account, amount_field,
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001603 order_doctype, order_list, include_unallocated=True):
1604 dr_or_cr = "credit_in_account_currency" if party_type == "Customer" else "debit_in_account_currency"
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301605
Nabin Hait1991c7b2016-06-27 20:09:05 +05301606 conditions = []
1607 if include_unallocated:
1608 conditions.append("ifnull(t2.reference_name, '')=''")
1609
1610 if order_list:
1611 order_condition = ', '.join(['%s'] * len(order_list))
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001612 conditions.append(" (t2.reference_type = '{0}' and ifnull(t2.reference_name, '') in ({1}))" \
1613 .format(order_doctype, order_condition))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301614
Nabin Hait1991c7b2016-06-27 20:09:05 +05301615 reference_condition = " and (" + " or ".join(conditions) + ")" if conditions else ""
Rushabh Mehta66958302017-01-16 16:57:53 +05301616
Nabin Hait1991c7b2016-06-27 20:09:05 +05301617 journal_entries = frappe.db.sql("""
1618 select
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301619 "Journal Entry" as reference_type, t1.name as reference_name,
Nabin Hait1991c7b2016-06-27 20:09:05 +05301620 t1.remark as remarks, t2.{0} as amount, t2.name as reference_row,
1621 t2.reference_name as against_order
1622 from
1623 `tabJournal Entry` t1, `tabJournal Entry Account` t2
1624 where
1625 t1.name = t2.parent and t2.account = %s
1626 and t2.party_type = %s and t2.party = %s
1627 and t2.is_advance = 'Yes' and t1.docstatus = 1
Nabin Haitca627fb2016-09-05 16:16:53 +05301628 and {1} > 0 {2}
Nabin Hait1991c7b2016-06-27 20:09:05 +05301629 order by t1.posting_date""".format(amount_field, dr_or_cr, reference_condition),
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001630 [party_account, party_type, party] + order_list, as_dict=1)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301631
Nabin Hait1991c7b2016-06-27 20:09:05 +05301632 return list(journal_entries)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301633
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001634
Rohit Waghchauref7258162019-01-15 18:12:04 +05301635def get_advance_payment_entries(party_type, party, party_account, order_doctype,
Anuja Pawar3e404f12021-08-31 18:59:29 +05301636 order_list=None, include_unallocated=True, against_all_orders=False, limit=None, condition=None):
Nabin Hait1991c7b2016-06-27 20:09:05 +05301637 party_account_field = "paid_from" if party_type == "Customer" else "paid_to"
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05301638 currency_field = "paid_from_account_currency" if party_type == "Customer" else "paid_to_account_currency"
Nabin Hait1991c7b2016-06-27 20:09:05 +05301639 payment_type = "Receive" if party_type == "Customer" else "Pay"
Saqiba20999c2021-07-12 14:33:23 +05301640 exchange_rate_field = "source_exchange_rate" if payment_type == "Receive" else "target_exchange_rate"
1641
Nabin Hait1991c7b2016-06-27 20:09:05 +05301642 payment_entries_against_order, unallocated_payment_entries = [], []
Nabin Hait34c551d2019-07-03 10:34:31 +05301643 limit_cond = "limit %s" % limit if limit else ""
Nabin Haitff2f3ef2016-07-04 11:41:14 +05301644
Nabin Hait1991c7b2016-06-27 20:09:05 +05301645 if order_list or against_all_orders:
1646 if order_list:
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001647 reference_condition = " and t2.reference_name in ({0})" \
Nabin Hait1991c7b2016-06-27 20:09:05 +05301648 .format(', '.join(['%s'] * len(order_list)))
1649 else:
1650 reference_condition = ""
1651 order_list = []
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301652
Nabin Hait1991c7b2016-06-27 20:09:05 +05301653 payment_entries_against_order = frappe.db.sql("""
1654 select
1655 "Payment Entry" as reference_type, t1.name as reference_name,
1656 t1.remarks, t2.allocated_amount as amount, t2.name as reference_row,
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05301657 t2.reference_name as against_order, t1.posting_date,
Saqiba20999c2021-07-12 14:33:23 +05301658 t1.{0} as currency, t1.{4} as exchange_rate
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301659 from `tabPayment Entry` t1, `tabPayment Entry Reference` t2
Nabin Hait1991c7b2016-06-27 20:09:05 +05301660 where
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05301661 t1.name = t2.parent and t1.{1} = %s and t1.payment_type = %s
Nabin Hait1991c7b2016-06-27 20:09:05 +05301662 and t1.party_type = %s and t1.party = %s and t1.docstatus = 1
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05301663 and t2.reference_doctype = %s {2}
1664 order by t1.posting_date {3}
Saqiba20999c2021-07-12 14:33:23 +05301665 """.format(currency_field, party_account_field, reference_condition, limit_cond, exchange_rate_field),
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001666 [party_account, payment_type, party_type, party,
1667 order_doctype] + order_list, as_dict=1)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301668
Nabin Hait1991c7b2016-06-27 20:09:05 +05301669 if include_unallocated:
1670 unallocated_payment_entries = frappe.db.sql("""
Anuja Pawar3e404f12021-08-31 18:59:29 +05301671 select "Payment Entry" as reference_type, name as reference_name, posting_date,
1672 remarks, unallocated_amount as amount, {2} as exchange_rate, {3} as currency
Nabin Hait1991c7b2016-06-27 20:09:05 +05301673 from `tabPayment Entry`
1674 where
1675 {0} = %s and party_type = %s and party = %s and payment_type = %s
Anuja Pawar3e404f12021-08-31 18:59:29 +05301676 and docstatus = 1 and unallocated_amount > 0 {condition}
Rohit Waghchauref7258162019-01-15 18:12:04 +05301677 order by posting_date {1}
Anuja Pawar3e404f12021-08-31 18:59:29 +05301678 """.format(party_account_field, limit_cond, exchange_rate_field, currency_field, condition=condition or ""),
Saqiba20999c2021-07-12 14:33:23 +05301679 (party_account, party_type, party, payment_type), as_dict=1)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301680
Rohit Waghchaure2f1db572016-11-08 12:39:33 +05301681 return list(payment_entries_against_order) + list(unallocated_payment_entries)
1682
1683def update_invoice_status():
Sagar Vorac8b9a552021-09-22 12:11:35 +05301684 """Updates status as Overdue for applicable invoices. Runs daily."""
Rohit Waghchaure2f1db572016-11-08 12:39:33 +05301685
Sagar Vorac8b9a552021-09-22 12:11:35 +05301686 for doctype in ("Sales Invoice", "Purchase Invoice"):
1687 frappe.db.sql("""
1688 update `tab{}` as dt set dt.status = 'Overdue'
1689 where dt.docstatus = 1
1690 and dt.status != 'Overdue'
1691 and dt.outstanding_amount > 0
1692 and (dt.grand_total - dt.outstanding_amount) <
1693 (select sum(payment_amount) from `tabPayment Schedule` as ps
1694 where ps.parent = dt.name and ps.due_date < %s)
1695 """.format(doctype), getdate())
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001696
Nabin Hait92759692017-08-15 08:23:51 +05301697@frappe.whitelist()
Saqib Ansarid552fe62021-04-23 14:46:52 +05301698def get_payment_terms(terms_template, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None):
Nabin Hait92759692017-08-15 08:23:51 +05301699 if not terms_template:
1700 return
1701
1702 terms_doc = frappe.get_doc("Payment Terms Template", terms_template)
1703
1704 schedule = []
tundefb144302017-08-19 15:01:40 +01001705 for d in terms_doc.get("terms"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301706 term_details = get_payment_term_details(d, posting_date, grand_total, base_grand_total, bill_date)
Nabin Hait92759692017-08-15 08:23:51 +05301707 schedule.append(term_details)
1708
1709 return schedule
1710
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001711
Nabin Hait92759692017-08-15 08:23:51 +05301712@frappe.whitelist()
Saqib Ansarid552fe62021-04-23 14:46:52 +05301713def get_payment_term_details(term, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None):
Nabin Hait92759692017-08-15 08:23:51 +05301714 term_details = frappe._dict()
Achilles Rasquinha90509982018-03-08 12:55:41 +05301715 if isinstance(term, text_type):
Nabin Hait92759692017-08-15 08:23:51 +05301716 term = frappe.get_doc("Payment Term", term)
1717 else:
1718 term_details.payment_term = term.payment_term
1719 term_details.description = term.description
1720 term_details.invoice_portion = term.invoice_portion
Rohit Waghchaure52bf56d2017-11-27 11:43:52 +05301721 term_details.payment_amount = flt(term.invoice_portion) * flt(grand_total) / 100
Saqib Ansarid552fe62021-04-23 14:46:52 +05301722 term_details.base_payment_amount = flt(term.invoice_portion) * flt(base_grand_total) / 100
Saqib0586b7d2021-03-31 15:03:53 +05301723 term_details.discount_type = term.discount_type
1724 term_details.discount = term.discount
Saqib0586b7d2021-03-31 15:03:53 +05301725 term_details.outstanding = term_details.payment_amount
1726 term_details.mode_of_payment = term.mode_of_payment
1727
Shreya Shah3a9eec22018-02-16 13:05:21 +05301728 if bill_date:
1729 term_details.due_date = get_due_date(term, bill_date)
Saqib0586b7d2021-03-31 15:03:53 +05301730 term_details.discount_date = get_discount_date(term, bill_date)
Shreya Shah3a9eec22018-02-16 13:05:21 +05301731 elif posting_date:
1732 term_details.due_date = get_due_date(term, posting_date)
Saqib0586b7d2021-03-31 15:03:53 +05301733 term_details.discount_date = get_discount_date(term, posting_date)
Shreya Shah3a9eec22018-02-16 13:05:21 +05301734
1735 if getdate(term_details.due_date) < getdate(posting_date):
1736 term_details.due_date = posting_date
1737
Nabin Hait92759692017-08-15 08:23:51 +05301738 return term_details
1739
Shreya Shah3a9eec22018-02-16 13:05:21 +05301740def get_due_date(term, posting_date=None, bill_date=None):
Nabin Hait92759692017-08-15 08:23:51 +05301741 due_date = None
Shreya Shah3a9eec22018-02-16 13:05:21 +05301742 date = bill_date or posting_date
Nabin Hait92759692017-08-15 08:23:51 +05301743 if term.due_date_based_on == "Day(s) after invoice date":
Shreya Shah3a9eec22018-02-16 13:05:21 +05301744 due_date = add_days(date, term.credit_days)
Nabin Hait92759692017-08-15 08:23:51 +05301745 elif term.due_date_based_on == "Day(s) after the end of the invoice month":
Shreya Shah3a9eec22018-02-16 13:05:21 +05301746 due_date = add_days(get_last_day(date), term.credit_days)
Nabin Hait92759692017-08-15 08:23:51 +05301747 elif term.due_date_based_on == "Month(s) after the end of the invoice month":
Shreya Shah3a9eec22018-02-16 13:05:21 +05301748 due_date = add_months(get_last_day(date), term.credit_months)
tunde96b8f222017-09-08 15:35:59 +01001749 return due_date
tundebabzyad08d4c2018-05-16 07:01:41 +01001750
Saqib0586b7d2021-03-31 15:03:53 +05301751def get_discount_date(term, posting_date=None, bill_date=None):
1752 discount_validity = None
1753 date = bill_date or posting_date
1754 if term.discount_validity_based_on == "Day(s) after invoice date":
1755 discount_validity = add_days(date, term.discount_validity)
1756 elif term.discount_validity_based_on == "Day(s) after the end of the invoice month":
1757 discount_validity = add_days(get_last_day(date), term.discount_validity)
1758 elif term.discount_validity_based_on == "Month(s) after the end of the invoice month":
1759 discount_validity = add_months(get_last_day(date), term.discount_validity)
1760 return discount_validity
tundebabzyad08d4c2018-05-16 07:01:41 +01001761
1762def get_supplier_block_status(party_name):
1763 """
1764 Returns a dict containing the values of `on_hold`, `release_date` and `hold_type` of
1765 a `Supplier`
1766 """
1767 supplier = frappe.get_doc('Supplier', party_name)
1768 info = {
1769 'on_hold': supplier.on_hold,
1770 'release_date': supplier.release_date,
1771 'hold_type': supplier.hold_type
1772 }
1773 return info
1774
marination698d9832020-08-19 14:59:46 +05301775def set_child_tax_template_and_map(item, child_item, parent_doc):
1776 args = {
1777 'item_code': item.item_code,
1778 'posting_date': parent_doc.transaction_date,
1779 'tax_category': parent_doc.get('tax_category'),
1780 'company': parent_doc.get('company')
1781 }
1782
1783 child_item.item_tax_template = _get_item_tax_template(args, item.taxes)
1784 if child_item.get("item_tax_template"):
1785 child_item.item_tax_rate = get_item_tax_map(parent_doc.get('company'), child_item.item_tax_template, as_json=True)
1786
Afshanb3bbebd2021-08-09 14:39:32 +05301787def add_taxes_from_tax_template(child_item, parent_doc, db_insert=True):
Marica3b1be2b2020-10-22 17:04:31 +05301788 add_taxes_from_item_tax_template = frappe.db.get_single_value("Accounts Settings", "add_taxes_from_item_tax_template")
1789
1790 if child_item.get("item_tax_rate") and add_taxes_from_item_tax_template:
1791 tax_map = json.loads(child_item.get("item_tax_rate"))
1792 for tax_type in tax_map:
1793 tax_rate = flt(tax_map[tax_type])
1794 taxes = parent_doc.get('taxes') or []
1795 # add new row for tax head only if missing
1796 found = any(tax.account_head == tax_type for tax in taxes)
1797 if not found:
1798 tax_row = parent_doc.append("taxes", {})
1799 tax_row.update({
1800 "description" : str(tax_type).split(' - ')[0],
1801 "charge_type" : "On Net Total",
1802 "account_head" : tax_type,
1803 "rate" : tax_rate
1804 })
1805 if parent_doc.doctype == "Purchase Order":
1806 tax_row.update({
1807 "category" : "Total",
1808 "add_deduct_tax" : "Add"
1809 })
Afshanb3bbebd2021-08-09 14:39:32 +05301810 if db_insert:
1811 tax_row.db_insert()
Marica3b1be2b2020-10-22 17:04:31 +05301812
pateljannat637ddff2021-02-09 16:17:30 +05301813def set_order_defaults(parent_doctype, parent_doctype_name, child_doctype, child_docname, trans_item):
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001814 """
pateljannat637ddff2021-02-09 16:17:30 +05301815 Returns a Sales/Purchase Order Item child item containing the default values
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001816 """
Saqib438e0432020-04-03 10:02:56 +05301817 p_doc = frappe.get_doc(parent_doctype, parent_doctype_name)
pateljannat637ddff2021-02-09 16:17:30 +05301818 child_item = frappe.new_doc(child_doctype, p_doc, child_docname)
Saqib Ansarif53299e2020-04-15 22:08:12 +05301819 item = frappe.get_doc("Item", trans_item.get('item_code'))
marination0673f552021-03-31 01:38:22 +05301820
pateljannat637ddff2021-02-09 16:17:30 +05301821 for field in ("item_code", "item_name", "description", "item_group"):
marination0673f552021-03-31 01:38:22 +05301822 child_item.update({field: item.get(field)})
1823
pateljannat637ddff2021-02-09 16:17:30 +05301824 date_fieldname = "delivery_date" if child_doctype == "Sales Order Item" else "schedule_date"
Jannat Patelbb0d8f82021-02-11 20:59:28 +05301825 child_item.update({date_fieldname: trans_item.get(date_fieldname) or p_doc.get(date_fieldname)})
marination0673f552021-03-31 01:38:22 +05301826 child_item.stock_uom = item.stock_uom
Saqib61314242020-09-15 11:14:31 +05301827 child_item.uom = trans_item.get("uom") or item.stock_uom
Andy Zhu1062d7e2020-10-06 10:51:42 +13001828 child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True)
Saqib61314242020-09-15 11:14:31 +05301829 conversion_factor = flt(get_conversion_factor(item.item_code, child_item.uom).get("conversion_factor"))
1830 child_item.conversion_factor = flt(trans_item.get('conversion_factor')) or conversion_factor
marination0673f552021-03-31 01:38:22 +05301831
pateljannat637ddff2021-02-09 16:17:30 +05301832 if child_doctype == "Purchase Order Item":
marination0673f552021-03-31 01:38:22 +05301833 # Initialized value will update in parent validation
1834 child_item.base_rate = 1
1835 child_item.base_amount = 1
pateljannat637ddff2021-02-09 16:17:30 +05301836 if child_doctype == "Sales Order Item":
1837 child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True)
1838 if not child_item.warehouse:
1839 frappe.throw(_("Cannot find {} for item {}. Please set the same in Item Master or Stock Settings.")
1840 .format(frappe.bold("default warehouse"), frappe.bold(item.item_code)))
marination0673f552021-03-31 01:38:22 +05301841
marination698d9832020-08-19 14:59:46 +05301842 set_child_tax_template_and_map(item, child_item, p_doc)
Marica3b1be2b2020-10-22 17:04:31 +05301843 add_taxes_from_tax_template(child_item, p_doc)
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001844 return child_item
1845
marination0673f552021-03-31 01:38:22 +05301846def validate_child_on_delete(row, parent):
1847 """Check if partially transacted item (row) is being deleted."""
1848 if parent.doctype == "Sales Order":
1849 if flt(row.delivered_qty):
1850 frappe.throw(_("Row #{0}: Cannot delete item {1} which has already been delivered").format(row.idx, row.item_code))
1851 if flt(row.work_order_qty):
1852 frappe.throw(_("Row #{0}: Cannot delete item {1} which has work order assigned to it.").format(row.idx, row.item_code))
1853 if flt(row.ordered_qty):
1854 frappe.throw(_("Row #{0}: Cannot delete item {1} which is assigned to customer's purchase order.").format(row.idx, row.item_code))
1855
1856 if parent.doctype == "Purchase Order" and flt(row.received_qty):
1857 frappe.throw(_("Row #{0}: Cannot delete item {1} which has already been received").format(row.idx, row.item_code))
1858
1859 if flt(row.billed_amt):
1860 frappe.throw(_("Row #{0}: Cannot delete item {1} which has already been billed.").format(row.idx, row.item_code))
1861
1862def update_bin_on_delete(row, doctype):
1863 """Update bin for deleted item (row)."""
Chillar Anand915b3432021-09-02 16:44:59 +05301864 from erpnext.stock.stock_balance import (
1865 get_indented_qty,
1866 get_ordered_qty,
1867 get_reserved_qty,
1868 update_bin_qty,
1869 )
marination0673f552021-03-31 01:38:22 +05301870 qty_dict = {}
1871
1872 if doctype == "Sales Order":
1873 qty_dict["reserved_qty"] = get_reserved_qty(row.item_code, row.warehouse)
1874 else:
1875 if row.material_request_item:
1876 qty_dict["indented_qty"] = get_indented_qty(row.item_code, row.warehouse)
1877
1878 qty_dict["ordered_qty"] = get_ordered_qty(row.item_code, row.warehouse)
1879
1880 update_bin_qty(row.item_code, row.warehouse, qty_dict)
1881
Saqib6db92fb2020-09-14 19:54:17 +05301882def validate_and_delete_children(parent, data):
Saqib0ad74492019-12-24 16:42:30 +05301883 deleted_children = []
1884 updated_item_names = [d.get("docname") for d in data]
1885 for item in parent.items:
1886 if item.name not in updated_item_names:
1887 deleted_children.append(item)
1888
1889 for d in deleted_children:
marination0673f552021-03-31 01:38:22 +05301890 validate_child_on_delete(d, parent)
Saqib0ad74492019-12-24 16:42:30 +05301891 d.cancel()
1892 d.delete()
marination0673f552021-03-31 01:38:22 +05301893
1894 # need to update ordered qty in Material Request first
1895 # bin uses Material Request Items to recalculate & update
1896 parent.update_prevdoc_status()
1897
1898 for d in deleted_children:
1899 update_bin_on_delete(d, parent.doctype)
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001900
Rohan Bansala93b5142021-04-06 17:10:52 +05301901
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001902@frappe.whitelist()
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001903def update_child_qty_rate(parent_doctype, trans_items, parent_doctype_name, child_docname="items"):
Saqib6db92fb2020-09-14 19:54:17 +05301904 def check_doc_permissions(doc, perm_type='create'):
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05301905 try:
1906 doc.check_permission(perm_type)
Saqib6db92fb2020-09-14 19:54:17 +05301907 except frappe.PermissionError:
marination661bf642020-09-29 18:16:45 +05301908 actions = { 'create': 'add', 'write': 'update'}
Saqib6db92fb2020-09-14 19:54:17 +05301909
1910 frappe.throw(_("You do not have permissions to {} items in a {}.")
1911 .format(actions[perm_type], parent_doctype), title=_("Insufficient Permissions"))
marination665c27a2020-09-15 12:04:38 +05301912
Saqib6db92fb2020-09-14 19:54:17 +05301913 def validate_workflow_conditions(doc):
1914 workflow = get_workflow_name(doc.doctype)
1915 if not workflow:
1916 return
1917
1918 workflow_doc = frappe.get_doc("Workflow", workflow)
1919 current_state = doc.get(workflow_doc.workflow_state_field)
1920 roles = frappe.get_roles()
1921
1922 transitions = []
1923 for transition in workflow_doc.transitions:
1924 if transition.next_state == current_state and transition.allowed in roles:
1925 if not is_transition_condition_satisfied(transition, doc):
1926 continue
1927 transitions.append(transition.as_dict())
1928
1929 if not transitions:
Saqib18318932020-09-23 13:01:49 +05301930 frappe.throw(
1931 _("You are not allowed to update as per the conditions set in {} Workflow.").format(get_link_to_form("Workflow", workflow)),
1932 title=_("Insufficient Permissions")
1933 )
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05301934
Rohit Waghchaure8d5380a2020-06-18 14:06:31 +05301935 def get_new_child_item(item_row):
Rohit Waghchaureff70e612021-03-06 22:08:08 +05301936 child_doctype = "Sales Order Item" if parent_doctype == "Sales Order" else "Purchase Order Item"
pateljannat637ddff2021-02-09 16:17:30 +05301937 return set_order_defaults(parent_doctype, parent_doctype_name, child_doctype, child_docname, item_row)
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05301938
1939 def validate_quantity(child_item, d):
1940 if parent_doctype == "Sales Order" and flt(d.get("qty")) < flt(child_item.delivered_qty):
1941 frappe.throw(_("Cannot set quantity less than delivered quantity"))
1942
1943 if parent_doctype == "Purchase Order" and flt(d.get("qty")) < flt(child_item.received_qty):
1944 frappe.throw(_("Cannot set quantity less than received quantity"))
1945
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001946 data = json.loads(trans_items)
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001947
rohitwaghchaure81c21752019-10-31 15:56:10 +05301948 sales_doctypes = ['Sales Order', 'Sales Invoice', 'Delivery Note', 'Quotation']
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05301949 parent = frappe.get_doc(parent_doctype, parent_doctype_name)
marination665c27a2020-09-15 12:04:38 +05301950
marination661bf642020-09-29 18:16:45 +05301951 check_doc_permissions(parent, 'write')
Saqib6db92fb2020-09-14 19:54:17 +05301952 validate_and_delete_children(parent, data)
Saqib0ad74492019-12-24 16:42:30 +05301953
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001954 for d in data:
1955 new_child_flag = False
Ankush Menat6de7b8e2021-08-24 12:18:40 +05301956
1957 if not d.get("item_code"):
1958 # ignore empty rows
1959 continue
1960
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001961 if not d.get("docname"):
1962 new_child_flag = True
Saqib6db92fb2020-09-14 19:54:17 +05301963 check_doc_permissions(parent, 'create')
Rohit Waghchaure8d5380a2020-06-18 14:06:31 +05301964 child_item = get_new_child_item(d)
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001965 else:
Saqib6db92fb2020-09-14 19:54:17 +05301966 check_doc_permissions(parent, 'write')
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001967 child_item = frappe.get_doc(parent_doctype + ' Item', d.get("docname"))
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05301968
Saqib Ansaric579b082020-05-29 22:21:50 +05301969 prev_rate, new_rate = flt(child_item.get("rate")), flt(d.get("rate"))
1970 prev_qty, new_qty = flt(child_item.get("qty")), flt(d.get("qty"))
1971 prev_con_fac, new_con_fac = flt(child_item.get("conversion_factor")), flt(d.get("conversion_factor"))
Saqib61314242020-09-15 11:14:31 +05301972 prev_uom, new_uom = child_item.get("uom"), d.get("uom")
Saqib Ansaric579b082020-05-29 22:21:50 +05301973
1974 if parent_doctype == 'Sales Order':
1975 prev_date, new_date = child_item.get("delivery_date"), d.get("delivery_date")
1976 elif parent_doctype == 'Purchase Order':
marinationb7e94cc2020-06-15 11:32:42 +05301977 prev_date, new_date = child_item.get("schedule_date"), d.get("schedule_date")
Saqib Ansaric579b082020-05-29 22:21:50 +05301978
1979 rate_unchanged = prev_rate == new_rate
marinationf9c4b202020-06-12 15:49:53 +05301980 qty_unchanged = prev_qty == new_qty
Saqib61314242020-09-15 11:14:31 +05301981 uom_unchanged = prev_uom == new_uom
Saqib Ansaric579b082020-05-29 22:21:50 +05301982 conversion_factor_unchanged = prev_con_fac == new_con_fac
Frappe PR Bot44434ff2021-08-18 18:33:06 +05301983 date_unchanged = prev_date == getdate(new_date) if prev_date and new_date else False # in case of delivery note etc
Saqib61314242020-09-15 11:14:31 +05301984 if rate_unchanged and qty_unchanged and conversion_factor_unchanged and uom_unchanged and date_unchanged:
Saqibdd374ff2020-02-27 12:51:31 +05301985 continue
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001986
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05301987 validate_quantity(child_item, d)
deepeshgarg00777cde832018-12-27 15:56:51 +05301988
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01001989 child_item.qty = flt(d.get("qty"))
Saqib56fea7d2020-10-09 21:19:25 +05301990 rate_precision = child_item.precision("rate") or 2
1991 conv_fac_precision = child_item.precision("conversion_factor") or 2
1992 qty_precision = child_item.precision("qty") or 2
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001993
Saqib56fea7d2020-10-09 21:19:25 +05301994 if flt(child_item.billed_amt, rate_precision) > flt(flt(d.get("rate"), rate_precision) * flt(d.get("qty"), qty_precision), rate_precision):
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001995 frappe.throw(_("Row #{0}: Cannot set Rate if amount is greater than billed amount for Item {1}.")
1996 .format(child_item.idx, child_item.item_code))
1997 else:
Saqib56fea7d2020-10-09 21:19:25 +05301998 child_item.rate = flt(d.get("rate"), rate_precision)
marinationf9c4b202020-06-12 15:49:53 +05301999
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302000 if d.get("conversion_factor"):
marinationf9c4b202020-06-12 15:49:53 +05302001 if child_item.stock_uom == child_item.uom:
2002 child_item.conversion_factor = 1
2003 else:
Saqib56fea7d2020-10-09 21:19:25 +05302004 child_item.conversion_factor = flt(d.get('conversion_factor'), conv_fac_precision)
marination665c27a2020-09-15 12:04:38 +05302005
Saqib61314242020-09-15 11:14:31 +05302006 if d.get("uom"):
2007 child_item.uom = d.get("uom")
2008 conversion_factor = flt(get_conversion_factor(child_item.item_code, child_item.uom).get("conversion_factor"))
Saqib56fea7d2020-10-09 21:19:25 +05302009 child_item.conversion_factor = flt(d.get('conversion_factor'), conv_fac_precision) or conversion_factor
Mangesh-Khairnara3d52002019-08-05 10:16:40 +05302010
Saqib Ansaric579b082020-05-29 22:21:50 +05302011 if d.get("delivery_date") and parent_doctype == 'Sales Order':
2012 child_item.delivery_date = d.get('delivery_date')
marinationf9c4b202020-06-12 15:49:53 +05302013
Saqib Ansaric579b082020-05-29 22:21:50 +05302014 if d.get("schedule_date") and parent_doctype == 'Purchase Order':
2015 child_item.schedule_date = d.get('schedule_date')
2016
Mangesh-Khairnara3d52002019-08-05 10:16:40 +05302017 if flt(child_item.price_list_rate):
Maricaf0674472019-10-11 10:47:09 +05302018 if flt(child_item.rate) > flt(child_item.price_list_rate):
2019 # if rate is greater than price_list_rate, set margin
2020 # or set discount
2021 child_item.discount_percentage = 0
rohitwaghchaure81c21752019-10-31 15:56:10 +05302022
2023 if parent_doctype in sales_doctypes:
2024 child_item.margin_type = "Amount"
2025 child_item.margin_rate_or_amount = flt(child_item.rate - child_item.price_list_rate,
2026 child_item.precision("margin_rate_or_amount"))
2027 child_item.rate_with_margin = child_item.rate
Maricaf0674472019-10-11 10:47:09 +05302028 else:
2029 child_item.discount_percentage = flt((1 - flt(child_item.rate) / flt(child_item.price_list_rate)) * 100.0,
2030 child_item.precision("discount_percentage"))
2031 child_item.discount_amount = flt(
2032 child_item.price_list_rate) - flt(child_item.rate)
rohitwaghchaure81c21752019-10-31 15:56:10 +05302033
2034 if parent_doctype in sales_doctypes:
2035 child_item.margin_type = ""
2036 child_item.margin_rate_or_amount = 0
2037 child_item.rate_with_margin = 0
Mangesh-Khairnara3d52002019-08-05 10:16:40 +05302038
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002039 child_item.flags.ignore_validate_update_after_submit = True
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002040 if new_child_flag:
Saqib Ansarif53299e2020-04-15 22:08:12 +05302041 parent.load_from_db()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302042 child_item.idx = len(parent.items) + 1
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002043 child_item.insert()
2044 else:
2045 child_item.save()
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002046
Rushabh Mehtafafbb022018-12-24 22:09:15 +05302047 parent.reload()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302048 parent.flags.ignore_validate_update_after_submit = True
2049 parent.set_qty_as_per_stock_uom()
2050 parent.calculate_taxes_and_totals()
Ankush Menatdf6e2082021-02-11 11:04:39 +05302051 parent.set_total_in_words()
Nabin Hait49a46f02019-10-21 13:35:43 +05302052 if parent_doctype == "Sales Order":
Marica3dee5272020-06-23 10:33:47 +05302053 make_packing_list(parent)
Nabin Hait49a46f02019-10-21 13:35:43 +05302054 parent.set_gross_profit()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302055 frappe.get_doc('Authorization Control').validate_approving_authority(parent.doctype,
2056 parent.company, parent.base_grand_total)
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002057
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302058 parent.set_payment_schedule()
Nabin Haitb2da0822018-07-13 17:01:40 +05302059 if parent_doctype == 'Purchase Order':
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302060 parent.validate_minimum_order_qty()
2061 parent.validate_budget()
2062 if parent.is_against_so():
2063 parent.update_status_updater()
Nabin Haitb2da0822018-07-13 17:01:40 +05302064 else:
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302065 parent.check_credit_limit()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302066 parent.save()
Nabin Haitb2da0822018-07-13 17:01:40 +05302067
2068 if parent_doctype == 'Purchase Order':
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302069 update_last_purchase_rate(parent, is_submit = 1)
2070 parent.update_prevdoc_status()
2071 parent.update_requested_qty()
2072 parent.update_ordered_qty()
2073 parent.update_ordered_and_reserved_qty()
2074 parent.update_receiving_percentage()
2075 if parent.is_subcontracted == "Yes":
2076 parent.update_reserved_qty_for_subcontract()
Saqib61314242020-09-15 11:14:31 +05302077 parent.create_raw_materials_supplied("supplied_items")
2078 parent.save()
Nabin Haitb2da0822018-07-13 17:01:40 +05302079 else:
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302080 parent.update_reserved_qty()
2081 parent.update_project()
2082 parent.update_prevdoc_status('submit')
2083 parent.update_delivery_status()
Nabin Haitb2da0822018-07-13 17:01:40 +05302084
Saqib6db92fb2020-09-14 19:54:17 +05302085 parent.reload()
2086 validate_workflow_conditions(parent)
2087
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302088 parent.update_blanket_order()
2089 parent.update_billing_percentage()
2090 parent.set_status()
Gauravf1e28e02019-02-13 16:46:24 +05302091
2092@erpnext.allow_regional
2093def validate_regional(doc):
2094 pass