blob: 707db8a6a2be6c2164511ea590c3d05c4e975ec4 [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
Chillar Anand915b3432021-09-02 16:44:59 +05304
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08005import json
Chillar Anand915b3432021-09-02 16:44:59 +05306
7import frappe
Rohit Waghchaure19911b42023-04-21 16:49:48 +05308from frappe import _, bold, throw
Chillar Anand915b3432021-09-02 16:44:59 +05309from frappe.model.workflow import get_workflow_name, is_transition_condition_satisfied
ruthra kumar44870652022-11-01 10:11:38 +053010from frappe.query_builder.functions import Abs, Sum
Chillar Anand915b3432021-09-02 16:44:59 +053011from 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,
GangaManojd24cfff2021-10-28 20:06:48 +053022 today,
Chillar Anand915b3432021-09-02 16:44:59 +053023)
Chillar Anand915b3432021-09-02 16:44:59 +053024
25import erpnext
26from erpnext.accounts.doctype.accounting_dimension.accounting_dimension import (
27 get_accounting_dimensions,
28)
29from erpnext.accounts.doctype.pricing_rule.utils import (
30 apply_pricing_rule_for_free_items,
31 apply_pricing_rule_on_transaction,
32 get_applied_pricing_rules,
33)
34from erpnext.accounts.party import (
35 get_party_account,
36 get_party_account_currency,
Deepesh Garga7f15a02021-12-12 21:09:11 +053037 get_party_gle_currency,
Chillar Anand915b3432021-09-02 16:44:59 +053038 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
Ankush Menat10583eb2022-06-17 12:13:27 +053049from erpnext.stock.doctype.item.item import get_uom_conv_factor
Marica3dee5272020-06-23 10:33:47 +053050from erpnext.stock.doctype.packed_item.packed_item import make_packing_list
Chillar Anand915b3432021-09-02 16:44:59 +053051from erpnext.stock.get_item_details import (
52 _get_item_tax_template,
53 get_conversion_factor,
54 get_item_details,
55 get_item_tax_map,
56 get_item_warehouse,
57)
58from erpnext.utilities.transaction_base import TransactionBase
59
Nabin Hait1d218422015-07-17 15:19:02 +053060
Ankush Menat494bd9e2022-03-28 18:52:46 +053061class AccountMissingError(frappe.ValidationError):
62 pass
marination53b1a9a2020-11-03 15:45:25 +053063
Ankush Menat494bd9e2022-03-28 18:52:46 +053064
65force_item_fields = (
66 "item_group",
67 "brand",
68 "stock_uom",
69 "is_fixed_asset",
70 "item_tax_rate",
71 "pricing_rules",
72 "weight_per_unit",
73 "weight_uom",
74 "total_weight",
75)
76
Doridel Cahanap6f06cc22018-05-17 16:28:58 +080077
Nabin Haitbf495c92013-01-30 12:49:08 +053078class AccountsController(TransactionBase):
Nabin Hait7eba1a32017-10-02 15:59:27 +053079 def __init__(self, *args, **kwargs):
80 super(AccountsController, self).__init__(*args, **kwargs)
Anand Doshi979326b2015-09-11 16:22:37 +053081
prssanna71e5b602020-10-29 14:19:34 +053082 def get_print_settings(self):
83 print_setting_fields = []
Ankush Menat494bd9e2022-03-28 18:52:46 +053084 items_field = self.meta.get_field("items")
prssanna71e5b602020-10-29 14:19:34 +053085
Ankush Menat494bd9e2022-03-28 18:52:46 +053086 if items_field and items_field.fieldtype == "Table":
87 print_setting_fields += ["compact_item_print", "print_uom_after_quantity"]
prssanna71e5b602020-10-29 14:19:34 +053088
Ankush Menat494bd9e2022-03-28 18:52:46 +053089 taxes_field = self.meta.get_field("taxes")
90 if taxes_field and taxes_field.fieldtype == "Table":
91 print_setting_fields += ["print_taxes_with_zero_amount"]
prssanna71e5b602020-10-29 14:19:34 +053092
93 return print_setting_fields
94
Nabin Hait4ffd7f32015-08-27 12:28:36 +053095 @property
96 def company_currency(self):
97 if not hasattr(self, "__company_currency"):
Rushabh Mehtacc8b2b22017-03-31 12:44:29 +053098 self.__company_currency = erpnext.get_company_currency(self.company)
Anand Doshi979326b2015-09-11 16:22:37 +053099
Nabin Hait4ffd7f32015-08-27 12:28:36 +0530100 return self.__company_currency
Anand Doshi979326b2015-09-11 16:22:37 +0530101
Rohit Waghchaure7d529892016-10-06 14:35:04 +0530102 def onload(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530103 self.set_onload(
104 "make_payment_via_journal_entry",
105 frappe.db.get_single_value("Accounts Settings", "make_payment_via_journal_entry"),
106 )
Nabin Hait0551f7b2017-11-21 19:58:16 +0530107
tundee52bb822017-09-25 09:02:23 +0100108 if self.is_new():
Ankush Menat494bd9e2022-03-28 18:52:46 +0530109 relevant_docs = (
110 "Quotation",
111 "Purchase Order",
112 "Sales Order",
113 "Purchase Invoice",
114 "Sales Invoice",
115 )
tundee52bb822017-09-25 09:02:23 +0100116 if self.doctype in relevant_docs:
117 self.set_payment_schedule()
Rohit Waghchaure7d529892016-10-06 14:35:04 +0530118
tundebabzyad08d4c2018-05-16 07:01:41 +0100119 def ensure_supplier_is_not_blocked(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530120 is_supplier_payment = self.doctype == "Payment Entry" and self.party_type == "Supplier"
121 is_buying_invoice = self.doctype in ["Purchase Invoice", "Purchase Order"]
tundebabzyad08d4c2018-05-16 07:01:41 +0100122 supplier = None
123 supplier_name = None
124
125 if is_buying_invoice or is_supplier_payment:
126 supplier_name = self.supplier if is_buying_invoice else self.party
Ankush Menat494bd9e2022-03-28 18:52:46 +0530127 supplier = frappe.get_doc("Supplier", supplier_name)
tundebabzyad08d4c2018-05-16 07:01:41 +0100128
129 if supplier and supplier_name and supplier.on_hold:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530130 if (is_buying_invoice and supplier.hold_type in ["All", "Invoices"]) or (
131 is_supplier_payment and supplier.hold_type in ["All", "Payments"]
132 ):
tundebabzyad08d4c2018-05-16 07:01:41 +0100133 if not supplier.release_date or getdate(nowdate()) <= supplier.release_date:
134 frappe.msgprint(
Ankush Menat494bd9e2022-03-28 18:52:46 +0530135 _("{0} is blocked so this transaction cannot proceed").format(supplier_name),
136 raise_exception=1,
137 )
tundebabzyad08d4c2018-05-16 07:01:41 +0100138
Saurabh6f753182013-03-20 12:55:28 +0530139 def validate(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530140 if not self.get("is_return") and not self.get("is_debit_note"):
Deepesh Gargd301d262019-07-31 15:58:19 +0530141 self.validate_qty_is_not_zero()
142
nabinhait23cce732014-07-03 12:25:06 +0530143 if self.get("_action") and self._action != "update_after_submit":
Nabin Hait704a4532014-06-05 16:55:31 +0530144 self.set_missing_values(for_validate=True)
tunde62af5c52017-09-22 15:16:38 +0100145
tundebabzyad08d4c2018-05-16 07:01:41 +0100146 self.ensure_supplier_is_not_blocked()
147
Nabin Haitcfecd2b2013-07-11 17:49:18 +0530148 self.validate_date_with_fiscal_year()
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530149 self.validate_party_accounts()
150
Deepesh Gargb4be2922021-01-28 13:09:56 +0530151 self.validate_inter_company_reference()
152
Ankush Menat3714e362022-05-16 18:09:14 +0530153 self.disable_pricing_rule_on_internal_transfer()
Deepesh Garg8d30ebb2022-11-05 20:51:15 +0530154 self.disable_tax_included_prices_for_internal_transfer()
Deepesh Gargb4be2922021-01-28 13:09:56 +0530155 self.set_incoming_rate()
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530156
Anand Doshi3543f302013-05-24 19:25:01 +0530157 if self.meta.get_field("currency"):
Anand Doshi923d41d2013-05-28 17:23:36 +0530158 self.calculate_taxes_and_totals()
Rohit Waghchaure6087fe12016-04-09 14:31:09 +0530159
Nabin Hait1d218422015-07-17 15:19:02 +0530160 if not self.meta.get_field("is_return") or not self.is_return:
161 self.validate_value("base_grand_total", ">=", 0)
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530162
Nabin Hait3cf67a42015-07-24 13:26:36 +0530163 validate_return(self)
Anand Doshi3543f302013-05-24 19:25:01 +0530164 self.set_total_in_words()
Anand Doshid2946502014-04-08 20:10:03 +0530165
tunde62af5c52017-09-22 15:16:38 +0100166 self.validate_all_documents_schedule()
Anand Doshid2946502014-04-08 20:10:03 +0530167
ankitjavalkarwork6c29d872014-10-06 13:20:53 +0530168 if self.meta.get_field("taxes_and_charges"):
169 self.validate_enabled_taxes_and_charges()
Nabin Haita2426fc2018-01-15 17:45:46 +0530170 self.validate_tax_account_company()
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530171
Neil Trini Lasrado3fbbb712015-07-17 12:10:12 +0530172 self.validate_party()
Nabin Hait895029d2015-08-20 14:55:39 +0530173 self.validate_currency()
Deepesh Garg80c85dd2021-08-12 15:39:07 +0530174 self.validate_party_account_currency()
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +0530175
Ankush Menat494bd9e2022-03-28 18:52:46 +0530176 if self.doctype in ["Purchase Invoice", "Sales Invoice"]:
177 pos_check_field = "is_pos" if self.doctype == "Sales Invoice" else "is_paid"
Nabin Hait4a994d42019-04-25 17:47:26 +0530178 if cint(self.allocate_advances_automatically) and not cint(self.get(pos_check_field)):
Nabin Hait041a5c22018-08-01 18:07:39 +0530179 self.set_advances()
180
Saqiba20999c2021-07-12 14:33:23 +0530181 self.set_advance_gain_or_loss()
182
Nabin Hait041a5c22018-08-01 18:07:39 +0530183 if self.is_return:
184 self.validate_qty()
Nabin Haitacdd5082019-12-04 15:30:01 +0530185 else:
186 self.validate_deferred_start_and_end_date()
rohitwaghchaure70489252018-06-11 12:02:14 +0530187
Deepesh Garg9bf5f762022-04-06 17:33:46 +0530188 self.validate_deferred_income_expense_account()
Deepesh Gargf17ea2c2020-12-11 21:30:39 +0530189 self.set_inter_company_account()
190
Ankush Menat494bd9e2022-03-28 18:52:46 +0530191 if self.doctype == "Purchase Invoice":
Deepesh Garg7f06c8c2021-11-26 10:27:57 +0530192 self.calculate_paid_amount()
193 # apply tax withholding only if checked and applicable
194 self.set_tax_withholding()
195
Gauravf1e28e02019-02-13 16:46:24 +0530196 validate_regional(self)
Deepesh Garg7c300852020-12-26 20:14:51 +0530197
Saqib Ansaric5782b02022-01-27 20:09:56 +0530198 validate_einvoice_fields(self)
199
Deepesh Gargb741ae12022-12-02 17:14:06 +0530200 if self.doctype != "Material Request" and not self.ignore_pricing_rule:
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530201 apply_pricing_rule_on_transaction(self)
Gauravf1e28e02019-02-13 16:46:24 +0530202
Saqib Ansaric5782b02022-01-27 20:09:56 +0530203 def before_cancel(self):
204 validate_einvoice_fields(self)
205
Saqib8e556772021-01-28 12:26:45 +0530206 def on_trash(self):
ruthra kumarc722f282023-02-19 12:09:10 +0530207 # delete references in 'Repost Payment Ledger'
208 rpi = frappe.qb.DocType("Repost Payment Ledger Items")
209 frappe.qb.from_(rpi).delete().where(
210 (rpi.voucher_type == self.doctype) & (rpi.voucher_no == self.name)
211 ).run()
212
Saqib8e556772021-01-28 12:26:45 +0530213 # delete sl and gl entries on deletion of transaction
Ankush Menat494bd9e2022-03-28 18:52:46 +0530214 if frappe.db.get_single_value("Accounts Settings", "delete_linked_ledger_entries"):
ruthra kumar70313df2022-09-08 18:53:30 +0530215 ple = frappe.qb.DocType("Payment Ledger Entry")
216 frappe.qb.from_(ple).delete().where(
217 (ple.voucher_type == self.doctype) & (ple.voucher_no == self.name)
218 ).run()
Ankush Menat494bd9e2022-03-28 18:52:46 +0530219 frappe.db.sql(
220 "delete from `tabGL Entry` where voucher_type=%s and voucher_no=%s", (self.doctype, self.name)
221 )
222 frappe.db.sql(
223 "delete from `tabStock Ledger Entry` where voucher_type=%s and voucher_no=%s",
224 (self.doctype, self.name),
225 )
Nabin Hait0551f7b2017-11-21 19:58:16 +0530226
Deepesh Garg9bf5f762022-04-06 17:33:46 +0530227 def validate_deferred_income_expense_account(self):
228 field_map = {
229 "Sales Invoice": "deferred_revenue_account",
230 "Purchase Invoice": "deferred_expense_account",
231 }
232
233 for item in self.get("items"):
234 if item.get("enable_deferred_revenue") or item.get("enable_deferred_expense"):
235 if not item.get(field_map.get(self.doctype)):
Daizy Modi4efc9472022-11-07 09:21:03 +0530236 default_deferred_account = frappe.get_cached_value(
Deepesh Garg9bf5f762022-04-06 17:33:46 +0530237 "Company", self.company, "default_" + field_map.get(self.doctype)
238 )
239 if not default_deferred_account:
240 frappe.throw(
241 _(
242 "Row #{0}: Please update deferred revenue/expense account in item row or default account in company master"
243 ).format(item.idx)
244 )
245 else:
246 item.set(field_map.get(self.doctype), default_deferred_account)
247
Deepesh Gargfa152212022-11-28 19:22:35 +0530248 def validate_auto_repeat_subscription_dates(self):
Deepesh Garg6a47fb62022-11-28 22:47:44 +0530249 if (
250 self.get("from_date")
251 and self.get("to_date")
252 and getdate(self.from_date) > getdate(self.to_date)
253 ):
Deepesh Gargfa152212022-11-28 19:22:35 +0530254 frappe.throw(_("To Date cannot be before From Date"), title=_("Invalid Auto Repeat Date"))
255
Nabin Haitacdd5082019-12-04 15:30:01 +0530256 def validate_deferred_start_and_end_date(self):
257 for d in self.items:
258 if d.get("enable_deferred_revenue") or d.get("enable_deferred_expense"):
259 if not (d.service_start_date and d.service_end_date):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530260 frappe.throw(
261 _("Row #{0}: Service Start and End Date is required for deferred accounting").format(d.idx)
262 )
Nabin Haitacdd5082019-12-04 15:30:01 +0530263 elif getdate(d.service_start_date) > getdate(d.service_end_date):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530264 frappe.throw(
265 _("Row #{0}: Service Start Date cannot be greater than Service End Date").format(d.idx)
266 )
Nabin Haitacdd5082019-12-04 15:30:01 +0530267 elif getdate(self.posting_date) > getdate(d.service_end_date):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530268 frappe.throw(
269 _("Row #{0}: Service End Date cannot be before Invoice Posting Date").format(d.idx)
270 )
Nabin Haitacdd5082019-12-04 15:30:01 +0530271
tunde62af5c52017-09-22 15:16:38 +0100272 def validate_invoice_documents_schedule(self):
Nabin Hait0551f7b2017-11-21 19:58:16 +0530273 self.validate_payment_schedule_dates()
274 self.set_due_date()
Nabin Hait0551f7b2017-11-21 19:58:16 +0530275 self.set_payment_schedule()
Ankush Menat494bd9e2022-03-28 18:52:46 +0530276 if not self.get("ignore_default_payment_terms_template"):
Deepesh Garg5c758942023-04-16 17:11:24 +0530277 self.validate_payment_schedule_amount()
Deepesh Gargbd709f82021-08-23 19:05:52 +0530278 self.validate_due_date()
tunde62af5c52017-09-22 15:16:38 +0100279 self.validate_advance_entries()
280
281 def validate_non_invoice_documents_schedule(self):
Nabin Hait0551f7b2017-11-21 19:58:16 +0530282 self.set_payment_schedule()
Nabin Hait2f9f4f92017-12-20 12:24:59 +0530283 self.validate_payment_schedule_dates()
Nabin Hait0551f7b2017-11-21 19:58:16 +0530284 self.validate_payment_schedule_amount()
tunde62af5c52017-09-22 15:16:38 +0100285
286 def validate_all_documents_schedule(self):
287 if self.doctype in ("Sales Invoice", "Purchase Invoice") and not self.is_return:
288 self.validate_invoice_documents_schedule()
289 elif self.doctype in ("Quotation", "Purchase Order", "Sales Order"):
290 self.validate_non_invoice_documents_schedule()
291
prssanna71e5b602020-10-29 14:19:34 +0530292 def before_print(self, settings=None):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530293 if self.doctype in [
294 "Purchase Order",
295 "Sales Order",
296 "Sales Invoice",
297 "Purchase Invoice",
298 "Supplier Quotation",
299 "Purchase Receipt",
300 "Delivery Note",
301 "Quotation",
302 ]:
KanchanChauhan49a50fe2016-11-18 13:57:53 +0530303 if self.get("group_same_items"):
304 self.group_similar_items()
305
Zarrar5be6d192018-11-08 12:16:26 +0530306 df = self.meta.get_field("discount_amount")
307 if self.get("discount_amount") and hasattr(self, "taxes") and not len(self.taxes):
308 df.set("print_hide", 0)
309 self.discount_amount = -self.discount_amount
310 else:
311 df.set("print_hide", 1)
312
prssanna71e5b602020-10-29 14:19:34 +0530313 set_print_templates_for_item_table(self, settings)
314 set_print_templates_for_taxes(self, settings)
315
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530316 def calculate_paid_amount(self):
Saurabh43520f92016-03-21 18:32:48 +0530317 if hasattr(self, "is_pos") or hasattr(self, "is_paid"):
318 is_paid = self.get("is_pos") or self.get("is_paid")
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530319
320 if is_paid:
321 if not self.cash_bank_account:
322 # show message that the amount is not paid
Ankush Menat494bd9e2022-03-28 18:52:46 +0530323 frappe.throw(
324 _("Note: Payment Entry will not be created since 'Cash or Bank Account' was not specified")
325 )
Marica23d7b092019-09-25 17:17:36 +0530326
Mangesh-Khairnar7bcb24e2019-09-11 10:49:33 +0530327 if cint(self.is_return) and self.grand_total > self.paid_amount:
328 self.paid_amount = flt(flt(self.grand_total), self.precision("paid_amount"))
329
330 elif not flt(self.paid_amount) and flt(self.outstanding_amount) > 0:
331 self.paid_amount = flt(flt(self.outstanding_amount), self.precision("paid_amount"))
332
Ankush Menat494bd9e2022-03-28 18:52:46 +0530333 self.base_paid_amount = flt(
334 self.paid_amount * self.conversion_rate, self.precision("base_paid_amount")
335 )
Saurabh43520f92016-03-21 18:32:48 +0530336
Anand Doshiabc10032013-06-14 17:44:03 +0530337 def set_missing_values(self, for_validate=False):
Rohit Waghchaure5d97d892016-05-12 12:58:29 +0530338 if frappe.flags.in_test:
tunde62af5c52017-09-22 15:16:38 +0100339 for fieldname in ["posting_date", "transaction_date"]:
Rohit Waghchaure5d97d892016-05-12 12:58:29 +0530340 if self.meta.get_field(fieldname) and not self.get(fieldname):
341 self.set(fieldname, today())
342 break
Anand Doshid2946502014-04-08 20:10:03 +0530343
Nabin Hait3237c752015-02-17 11:11:11 +0530344 def calculate_taxes_and_totals(self):
Nabin Haitfe81da22015-02-18 12:23:18 +0530345 from erpnext.controllers.taxes_and_totals import calculate_taxes_and_totals
Ankush Menat494bd9e2022-03-28 18:52:46 +0530346
Nabin Haitfe81da22015-02-18 12:23:18 +0530347 calculate_taxes_and_totals(self)
Nabin Hait3237c752015-02-17 11:11:11 +0530348
Raffael Meyere10ab162021-11-30 13:24:18 +0100349 if self.doctype in (
Ankush Menat494bd9e2022-03-28 18:52:46 +0530350 "Sales Order",
351 "Delivery Note",
352 "Sales Invoice",
353 "POS Invoice",
Raffael Meyere10ab162021-11-30 13:24:18 +0100354 ):
Nabin Hait3237c752015-02-17 11:11:11 +0530355 self.calculate_commission()
356 self.calculate_contribution()
357
Nabin Haitcfecd2b2013-07-11 17:49:18 +0530358 def validate_date_with_fiscal_year(self):
Doridel Cahanap6f06cc22018-05-17 16:28:58 +0800359 if self.meta.get_field("fiscal_year"):
Rohan Bansal1e3a3b22021-05-26 15:18:10 +0530360 date_field = None
Nabin Haitcfecd2b2013-07-11 17:49:18 +0530361 if self.meta.get_field("posting_date"):
362 date_field = "posting_date"
363 elif self.meta.get_field("transaction_date"):
364 date_field = "transaction_date"
Anand Doshid2946502014-04-08 20:10:03 +0530365
Rushabh Mehtaf2227d02014-03-31 23:37:40 +0530366 if date_field and self.get(date_field):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530367 validate_fiscal_year(
368 self.get(date_field), self.fiscal_year, self.company, self.meta.get_label(date_field), self
369 )
Anand Doshid2946502014-04-08 20:10:03 +0530370
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530371 def validate_party_accounts(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530372 if self.doctype not in ("Sales Invoice", "Purchase Invoice"):
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530373 return
374
Ankush Menat494bd9e2022-03-28 18:52:46 +0530375 if self.doctype == "Sales Invoice":
376 party_account_field = "debit_to"
377 item_field = "income_account"
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530378 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530379 party_account_field = "credit_to"
380 item_field = "expense_account"
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530381
Ankush Menat494bd9e2022-03-28 18:52:46 +0530382 for item in self.get("items"):
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530383 if item.get(item_field) == self.get(party_account_field):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530384 frappe.throw(
385 _("Row {0}: {1} {2} cannot be same as {3} (Party Account) {4}").format(
386 item.idx,
387 frappe.bold(frappe.unscrub(item_field)),
388 item.get(item_field),
389 frappe.bold(frappe.unscrub(party_account_field)),
390 self.get(party_account_field),
391 )
392 )
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530393
Deepesh Gargb4be2922021-01-28 13:09:56 +0530394 def validate_inter_company_reference(self):
Rohit Waghchaure38aaba52023-05-13 13:00:05 +0530395 if self.get("is_return"):
396 return
397
Rohit Waghchaureb4a102d2022-09-06 16:22:00 +0530398 if self.doctype not in ("Purchase Invoice", "Purchase Receipt"):
Deepesh Gargb4be2922021-01-28 13:09:56 +0530399 return
400
401 if self.is_internal_transfer():
Ankush Menat494bd9e2022-03-28 18:52:46 +0530402 if not (
403 self.get("inter_company_reference")
404 or self.get("inter_company_invoice_reference")
405 or self.get("inter_company_order_reference")
Deepesh Garg906ad102023-01-15 17:32:57 +0530406 ) and not self.get("is_return"):
Deepesh Garg4c8d15b2021-04-26 15:24:34 +0530407 msg = _("Internal Sale or Delivery Reference missing.")
Deepesh Gargb4be2922021-01-28 13:09:56 +0530408 msg += _("Please create purchase from internal sale or delivery document itself")
409 frappe.throw(msg, title=_("Internal Sales Reference Missing"))
410
Rohit Waghchaure19911b42023-04-21 16:49:48 +0530411 label = "Delivery Note Item" if self.doctype == "Purchase Receipt" else "Sales Invoice Item"
412
413 field = frappe.scrub(label)
414
415 for row in self.get("items"):
416 if not row.get(field):
417 msg = f"At Row {row.idx}: The field {bold(label)} is mandatory for internal transfer"
418 frappe.throw(_(msg), title=_("Internal Transfer Reference Missing"))
419
Ankush Menat3714e362022-05-16 18:09:14 +0530420 def disable_pricing_rule_on_internal_transfer(self):
421 if not self.get("ignore_pricing_rule") and self.is_internal_transfer():
422 self.ignore_pricing_rule = 1
423 frappe.msgprint(
424 _("Disabled pricing rules since this {} is an internal transfer").format(self.doctype),
425 alert=1,
426 )
427
Deepesh Garg8d30ebb2022-11-05 20:51:15 +0530428 def disable_tax_included_prices_for_internal_transfer(self):
429 if self.is_internal_transfer():
430 tax_updated = False
431 for tax in self.get("taxes"):
432 if tax.get("included_in_print_rate"):
433 tax.included_in_print_rate = 0
434 tax_updated = True
435
436 if tax_updated:
437 frappe.msgprint(
438 _("Disabled tax included prices since this {} is an internal transfer").format(self.doctype),
439 alert=1,
440 )
441
Nabin Haite9daefe2014-08-27 16:46:33 +0530442 def validate_due_date(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530443 if self.get("is_pos"):
444 return
rohitwaghchaureea943c62018-07-06 12:28:58 +0530445
Nabin Haite9daefe2014-08-27 16:46:33 +0530446 from erpnext.accounts.party import validate_due_date
Ankush Menat494bd9e2022-03-28 18:52:46 +0530447
Nabin Haite9daefe2014-08-27 16:46:33 +0530448 if self.doctype == "Sales Invoice":
Nabin Hait04d244a2015-07-22 17:47:49 +0530449 if not self.due_date:
450 frappe.throw(_("Due Date is mandatory"))
Rushabh Mehtab16b9cd2015-08-03 16:13:33 +0530451
Ankush Menat494bd9e2022-03-28 18:52:46 +0530452 validate_due_date(
453 self.posting_date,
454 self.due_date,
455 "Customer",
456 self.customer,
457 self.company,
458 self.payment_terms_template,
459 )
Nabin Haite9daefe2014-08-27 16:46:33 +0530460 elif self.doctype == "Purchase Invoice":
Ankush Menat494bd9e2022-03-28 18:52:46 +0530461 validate_due_date(
462 self.bill_date or self.posting_date,
463 self.due_date,
464 "Supplier",
465 self.supplier,
466 self.company,
467 self.bill_date,
468 self.payment_terms_template,
469 )
Nabin Haite9daefe2014-08-27 16:46:33 +0530470
Nabin Hait096d3632013-10-17 17:01:14 +0530471 def set_price_list_currency(self, buying_or_selling):
Nabin Hait1cc55fb2016-12-08 14:09:23 +0530472 if self.meta.get_field("posting_date"):
Nabin Hait288a18e2016-12-08 15:36:23 +0530473 transaction_date = self.posting_date
Nabin Hait1cc55fb2016-12-08 14:09:23 +0530474 else:
Nabin Hait288a18e2016-12-08 15:36:23 +0530475 transaction_date = self.transaction_date
Rushabh Mehta66958302017-01-16 16:57:53 +0530476
Rushabh Mehta4a404e92013-08-09 18:11:35 +0530477 if self.meta.get_field("currency"):
Nabin Hait7a75e102013-09-17 10:21:20 +0530478 # price list part
Shreya3f778522018-05-15 16:59:20 +0530479 if buying_or_selling.lower() == "selling":
480 fieldname = "selling_price_list"
481 args = "for_selling"
482 else:
483 fieldname = "buying_price_list"
484 args = "for_buying"
485
Anand Doshif78d1ae2014-03-28 13:55:00 +0530486 if self.meta.get_field(fieldname) and self.get(fieldname):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530487 self.price_list_currency = frappe.db.get_value("Price List", self.get(fieldname), "currency")
Anand Doshid2946502014-04-08 20:10:03 +0530488
Nabin Hait6e439a52015-08-28 19:24:22 +0530489 if self.price_list_currency == self.company_currency:
Anand Doshif78d1ae2014-03-28 13:55:00 +0530490 self.plc_conversion_rate = 1.0
Nabin Hait11f41952013-09-24 14:36:55 +0530491
Anand Doshif78d1ae2014-03-28 13:55:00 +0530492 elif not self.plc_conversion_rate:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530493 self.plc_conversion_rate = get_exchange_rate(
494 self.price_list_currency, self.company_currency, transaction_date, args
495 )
Anand Doshid2946502014-04-08 20:10:03 +0530496
Nabin Hait7a75e102013-09-17 10:21:20 +0530497 # currency
Anand Doshif78d1ae2014-03-28 13:55:00 +0530498 if not self.currency:
499 self.currency = self.price_list_currency
500 self.conversion_rate = self.plc_conversion_rate
Nabin Hait6e439a52015-08-28 19:24:22 +0530501 elif self.currency == self.company_currency:
Anand Doshif78d1ae2014-03-28 13:55:00 +0530502 self.conversion_rate = 1.0
503 elif not self.conversion_rate:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530504 self.conversion_rate = get_exchange_rate(
505 self.currency, self.company_currency, transaction_date, args
506 )
Nabin Hait7a75e102013-09-17 10:21:20 +0530507
Nabin Haitcccc45e2016-10-05 17:15:43 +0530508 def set_missing_item_details(self, for_validate=False):
Anand Doshi3543f302013-05-24 19:25:01 +0530509 """set missing item values"""
Nabin Haitf37d43d2017-07-18 12:14:42 +0530510 from erpnext.stock.doctype.serial_no.serial_no import get_serial_nos
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530511
Nabin Haitdd38a262014-12-26 13:15:21 +0530512 if hasattr(self, "items"):
Nabin Hait444f9562014-06-20 15:59:49 +0530513 parent_dict = {}
Pratik Vyasf7daab72014-04-10 17:53:30 +0530514 for fieldname in self.meta.get_valid_columns():
515 parent_dict[fieldname] = self.get(fieldname)
516
mbauskara52472c2016-03-05 15:10:25 +0530517 if self.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]:
518 document_type = "{} Item".format(self.doctype)
mbauskarc97becb2016-01-18 16:28:21 +0530519 parent_dict.update({"document_type": document_type})
520
Nabin Hait34c551d2019-07-03 10:34:31 +0530521 # party_name field used for customer in quotation
Ankush Menat494bd9e2022-03-28 18:52:46 +0530522 if (
523 self.doctype == "Quotation"
524 and self.quotation_to == "Customer"
525 and parent_dict.get("party_name")
526 ):
Nabin Hait34c551d2019-07-03 10:34:31 +0530527 parent_dict.update({"customer": parent_dict.get("party_name")})
528
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530529 self.pricing_rules = []
Deepesh Garg4c61ee32023-04-02 09:35:27 +0530530
Nabin Haitdd38a262014-12-26 13:15:21 +0530531 for item in self.get("items"):
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530532 if item.get("item_code"):
Nabin Hait444f9562014-06-20 15:59:49 +0530533 args = parent_dict.copy()
534 args.update(item.as_dict())
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530535
Nabin Hait34d28222016-01-19 15:45:49 +0530536 args["doctype"] = self.doctype
537 args["name"] = self.name
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530538 args["child_docname"] = item.name
Ankush Menat494bd9e2022-03-28 18:52:46 +0530539 args["ignore_pricing_rule"] = (
540 self.ignore_pricing_rule if hasattr(self, "ignore_pricing_rule") else 0
541 )
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530542
Nabin Haite2f054c2015-03-09 14:54:37 +0530543 if not args.get("transaction_date"):
544 args["transaction_date"] = args.get("posting_date")
Anand Doshi2b2b6392015-03-20 14:18:09 +0530545
546 if self.get("is_subcontracted"):
547 args["is_subcontracted"] = self.is_subcontracted
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530548
Deepesh Garga7051cb2023-04-14 09:59:42 +0530549 ret = get_item_details(args, self, for_validate=True, overwrite_warehouse=False)
Rohit Waghchaure8bfe3302019-03-18 14:34:19 +0530550
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530551 for fieldname, value in ret.items():
Anand Doshi602e8252015-11-16 19:05:46 +0530552 if item.meta.get_field(fieldname) and value is not None:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530553 if item.get(fieldname) is None or fieldname in force_item_fields:
Rushabh Mehtaf14b8092014-04-03 14:30:42 +0530554 item.set(fieldname, value)
Anand Doshid2946502014-04-08 20:10:03 +0530555
Ankush Menat494bd9e2022-03-28 18:52:46 +0530556 elif fieldname in ["cost_center", "conversion_factor"] and not item.get(fieldname):
Anand Doshi602e8252015-11-16 19:05:46 +0530557 item.set(fieldname, value)
558
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530559 elif fieldname == "serial_no":
Alchez9155e402018-07-09 16:57:42 +0530560 # Ensure that serial numbers are matched against Stock UOM
561 item_conversion_factor = item.get("conversion_factor") or 1.0
562 item_qty = abs(item.get("qty")) * item_conversion_factor
Alchez8f2a0f32018-07-06 14:36:52 +0530563
Ankush Menat494bd9e2022-03-28 18:52:46 +0530564 if item_qty != len(get_serial_nos(item.get("serial_no"))):
Rohit Waghchauredc981dc2017-04-03 14:17:08 +0530565 item.set(fieldname, value)
Nabin Haita74468b2014-12-30 18:33:52 +0530566
Saqib Ansariab36b272022-02-09 10:10:17 +0530567 elif (
568 ret.get("pricing_rule_removed")
569 and value is not None
570 and fieldname
571 in [
572 "discount_percentage",
573 "discount_amount",
574 "rate",
575 "margin_rate_or_amount",
576 "margin_type",
577 "remove_free_item",
578 ]
579 ):
Saqib Ansarib8c41e32022-01-20 13:06:08 +0530580 # reset pricing rule fields if pricing_rule_removed
581 item.set(fieldname, value)
582
Ankush Menat494bd9e2022-03-28 18:52:46 +0530583 if self.doctype in ["Purchase Invoice", "Sales Invoice"] and item.meta.get_field(
584 "is_fixed_asset"
585 ):
586 item.set("is_fixed_asset", ret.get("is_fixed_asset", 0))
Rohit Waghchauref6f503a2018-12-19 15:06:44 +0530587
Deepesh Garga60c3082021-05-11 16:38:33 +0530588 # Double check for cost center
589 # Items add via promotional scheme may not have cost center set
Ankush Menat494bd9e2022-03-28 18:52:46 +0530590 if hasattr(item, "cost_center") and not item.get("cost_center"):
591 item.set(
592 "cost_center", self.get("cost_center") or erpnext.get_default_cost_center(self.company)
593 )
Deepesh Garga60c3082021-05-11 16:38:33 +0530594
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530595 if ret.get("pricing_rules"):
596 self.apply_pricing_rule_on_items(item, ret)
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530597 self.set_pricing_rule_details(item, ret)
Ankush Menat10583eb2022-06-17 12:13:27 +0530598 else:
599 # Transactions line item without item code
600
601 uom = item.get("uom")
602 stock_uom = item.get("stock_uom")
603 if bool(uom) != bool(stock_uom): # xor
604 item.stock_uom = item.uom = uom or stock_uom
605
Deepesh Garg61751832022-12-29 10:41:36 +0530606 # UOM cannot be zero so substitute as 1
607 item.conversion_factor = (
608 get_uom_conv_factor(item.get("uom"), item.get("stock_uom"))
609 or item.get("conversion_factor")
610 or 1
611 )
Rushabh Mehtab46069d2016-01-15 16:59:26 +0530612
Nabin Hait14aa9c52016-04-18 15:54:01 +0530613 if self.doctype == "Purchase Invoice":
Nabin Haitcccc45e2016-10-05 17:15:43 +0530614 self.set_expense_account(for_validate)
Nabin Haita3dd72a2014-05-28 12:49:20 +0530615
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530616 def apply_pricing_rule_on_items(self, item, pricing_rule_args):
617 if not pricing_rule_args.get("validate_applied_rule", 0):
618 # if user changed the discount percentage then set user's discount percentage ?
Ankush Menat494bd9e2022-03-28 18:52:46 +0530619 if pricing_rule_args.get("price_or_product_discount") == "Price":
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530620 item.set("pricing_rules", pricing_rule_args.get("pricing_rules"))
Rohit Waghchauref5bd3fa2022-09-16 15:23:10 +0530621 if pricing_rule_args.get("apply_rule_on_other_items"):
622 other_items = json.loads(pricing_rule_args.get("apply_rule_on_other_items"))
623 if other_items and item.item_code not in other_items:
624 return
625
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530626 item.set("discount_percentage", pricing_rule_args.get("discount_percentage"))
627 item.set("discount_amount", pricing_rule_args.get("discount_amount"))
628 if pricing_rule_args.get("pricing_rule_for") == "Rate":
629 item.set("price_list_rate", pricing_rule_args.get("price_list_rate"))
630
631 if item.get("price_list_rate"):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530632 item.rate = flt(
633 item.price_list_rate * (1.0 - (flt(item.discount_percentage) / 100.0)),
634 item.precision("rate"),
635 )
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530636
Ankush Menat494bd9e2022-03-28 18:52:46 +0530637 if item.get("discount_amount"):
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530638 item.rate = item.price_list_rate - item.discount_amount
639
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530640 if item.get("apply_discount_on_discounted_rate") and pricing_rule_args.get("rate"):
641 item.rate = pricing_rule_args.get("rate")
642
Ankush Menat494bd9e2022-03-28 18:52:46 +0530643 elif pricing_rule_args.get("free_item_data"):
644 apply_pricing_rule_for_free_items(self, pricing_rule_args.get("free_item_data"))
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530645
646 elif pricing_rule_args.get("validate_applied_rule"):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530647 for pricing_rule in get_applied_pricing_rules(item.get("pricing_rules")):
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530648 pricing_rule_doc = frappe.get_cached_doc("Pricing Rule", pricing_rule)
Ankush Menat494bd9e2022-03-28 18:52:46 +0530649 for field in ["discount_percentage", "discount_amount", "rate"]:
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530650 if item.get(field) < pricing_rule_doc.get(field):
651 title = get_link_to_form("Pricing Rule", pricing_rule)
652
Ankush Menat494bd9e2022-03-28 18:52:46 +0530653 frappe.msgprint(
654 _("Row {0}: user has not applied the rule {1} on the item {2}").format(
655 item.idx, frappe.bold(title), frappe.bold(item.item_code)
656 )
657 )
rohitwaghchaurea85ddf22019-11-19 18:47:48 +0530658
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530659 def set_pricing_rule_details(self, item_row, args):
660 pricing_rules = get_applied_pricing_rules(args.get("pricing_rules"))
Ankush Menat494bd9e2022-03-28 18:52:46 +0530661 if not pricing_rules:
662 return
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530663
664 for pricing_rule in pricing_rules:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530665 self.append(
666 "pricing_rules",
667 {
668 "pricing_rule": pricing_rule,
669 "item_code": item_row.item_code,
670 "child_docname": item_row.name,
671 "rule_applied": True,
672 },
673 )
Rohit Waghchaurea248dfb2020-07-16 17:27:26 +0530674
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530675 def set_taxes(self):
676 if not self.meta.get_field("taxes"):
Anand Doshi3543f302013-05-24 19:25:01 +0530677 return
Anand Doshid2946502014-04-08 20:10:03 +0530678
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530679 tax_master_doctype = self.meta.get_field("taxes_and_charges").options
Anand Doshid2946502014-04-08 20:10:03 +0530680
rohitwaghchaure57914f12018-04-24 19:19:47 +0530681 if (self.is_new() or self.is_pos_profile_changed()) and not self.get("taxes"):
rohitwaghchaure505661b2017-12-11 14:52:28 +0530682 if self.company and not self.get("taxes_and_charges"):
Anand Doshi3543f302013-05-24 19:25:01 +0530683 # get the default tax master
Ankush Menat494bd9e2022-03-28 18:52:46 +0530684 self.taxes_and_charges = frappe.db.get_value(
685 tax_master_doctype, {"is_default": 1, "company": self.company}
686 )
Anand Doshid2946502014-04-08 20:10:03 +0530687
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530688 self.append_taxes_from_master(tax_master_doctype)
Anand Doshid2946502014-04-08 20:10:03 +0530689
rohitwaghchaure57914f12018-04-24 19:19:47 +0530690 def is_pos_profile_changed(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530691 if (
692 self.doctype == "Sales Invoice"
693 and self.is_pos
694 and self.pos_profile != frappe.db.get_value("Sales Invoice", self.name, "pos_profile")
695 ):
rohitwaghchaure57914f12018-04-24 19:19:47 +0530696 return True
697
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530698 def append_taxes_from_master(self, tax_master_doctype=None):
699 if self.get("taxes_and_charges"):
Anand Doshi99100a42013-07-04 17:13:53 +0530700 if not tax_master_doctype:
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530701 tax_master_doctype = self.meta.get_field("taxes_and_charges").options
Anand Doshid2946502014-04-08 20:10:03 +0530702
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530703 self.extend("taxes", get_taxes_and_charges(tax_master_doctype, self.get("taxes_and_charges")))
Akhilesh Darjee4cdb7992014-01-30 13:56:57 +0530704
Anand Doshiac32bad2014-04-18 01:30:14 +0530705 def set_other_charges(self):
Nabin Haite7d15362014-12-25 16:01:55 +0530706 self.set("taxes", [])
Nabin Haitffc7f3f2015-05-12 15:07:02 +0530707 self.set_taxes()
Anand Doshid2946502014-04-08 20:10:03 +0530708
ankitjavalkarwork6c29d872014-10-06 13:20:53 +0530709 def validate_enabled_taxes_and_charges(self):
710 taxes_and_charges_doctype = self.meta.get_options("taxes_and_charges")
Daizy Modi4efc9472022-11-07 09:21:03 +0530711 if frappe.get_cached_value(taxes_and_charges_doctype, self.taxes_and_charges, "disabled"):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530712 frappe.throw(
713 _("{0} '{1}' is disabled").format(taxes_and_charges_doctype, self.taxes_and_charges)
714 )
ankitjavalkarwork6c29d872014-10-06 13:20:53 +0530715
Nabin Haita2426fc2018-01-15 17:45:46 +0530716 def validate_tax_account_company(self):
717 for d in self.get("taxes"):
718 if d.account_head:
Daizy Modi4efc9472022-11-07 09:21:03 +0530719 tax_account_company = frappe.get_cached_value("Account", d.account_head, "company")
Nabin Haita2426fc2018-01-15 17:45:46 +0530720 if tax_account_company != self.company:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530721 frappe.throw(
722 _("Row #{0}: Account {1} does not belong to company {2}").format(
723 d.idx, d.account_head, self.company
724 )
725 )
Nabin Haita2426fc2018-01-15 17:45:46 +0530726
deepeshgarg0073d11ac02019-05-19 00:02:01 +0530727 def get_gl_dict(self, args, account_currency=None, item=None):
Nabin Hait2df4d542013-01-29 11:34:39 +0530728 """this method populates the common properties of a gl entry record"""
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +0530729
Ankush Menat494bd9e2022-03-28 18:52:46 +0530730 posting_date = args.get("posting_date") or self.get("posting_date")
Rohit Waghchaureaa7b4342018-05-11 01:56:05 +0530731 fiscal_years = get_fiscal_years(posting_date, company=self.company)
Nabin Hait2ed0b592016-03-29 13:14:17 +0530732 if len(fiscal_years) > 1:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530733 frappe.throw(
734 _("Multiple fiscal years exist for the date {0}. Please set company in Fiscal Year").format(
735 formatdate(posting_date)
736 )
737 )
Nabin Hait2ed0b592016-03-29 13:14:17 +0530738 else:
739 fiscal_year = fiscal_years[0][0]
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +0530740
Ankush Menat494bd9e2022-03-28 18:52:46 +0530741 gl_dict = frappe._dict(
742 {
743 "company": self.company,
744 "posting_date": posting_date,
745 "fiscal_year": fiscal_year,
746 "voucher_type": self.doctype,
747 "voucher_no": self.name,
748 "remarks": self.get("remarks") or self.get("remark"),
749 "debit": 0,
750 "credit": 0,
751 "debit_in_account_currency": 0,
752 "credit_in_account_currency": 0,
753 "is_opening": self.get("is_opening") or "No",
754 "party_type": None,
755 "party": None,
756 "project": self.get("project"),
757 "post_net_value": args.get("post_net_value"),
758 }
759 )
deepeshgarg007d83cf652019-05-12 18:34:23 +0530760
761 accounting_dimensions = get_accounting_dimensions()
762 dimension_dict = frappe._dict()
763
764 for dimension in accounting_dimensions:
765 dimension_dict[dimension] = self.get(dimension)
deepeshgarg0073d11ac02019-05-19 00:02:01 +0530766 if item and item.get(dimension):
767 dimension_dict[dimension] = item.get(dimension)
deepeshgarg007d83cf652019-05-12 18:34:23 +0530768
769 gl_dict.update(dimension_dict)
Nabin Hait2df4d542013-01-29 11:34:39 +0530770 gl_dict.update(args)
Anand Doshi979326b2015-09-11 16:22:37 +0530771
Nabin Hait895029d2015-08-20 14:55:39 +0530772 if not account_currency:
Anand Doshicd0989e2015-09-28 13:31:17 +0530773 account_currency = get_account_currency(gl_dict.account)
Anand Doshi979326b2015-09-11 16:22:37 +0530774
Ankush Menat494bd9e2022-03-28 18:52:46 +0530775 if gl_dict.account and self.doctype not in [
776 "Journal Entry",
777 "Period Closing Voucher",
778 "Payment Entry",
779 "Purchase Receipt",
780 "Purchase Invoice",
781 "Stock Entry",
782 ]:
Anand Doshibe6cfdd2015-09-17 21:07:04 +0530783 self.validate_account_currency(gl_dict.account, account_currency)
Deepesh Garg7c300852020-12-26 20:14:51 +0530784
Ankush Menat494bd9e2022-03-28 18:52:46 +0530785 if gl_dict.account and self.doctype not in [
786 "Journal Entry",
787 "Period Closing Voucher",
788 "Payment Entry",
789 ]:
790 set_balance_in_account_currency(
791 gl_dict, account_currency, self.get("conversion_rate"), self.company_currency
792 )
Anand Doshi979326b2015-09-11 16:22:37 +0530793
Nabin Haitc561a492015-08-19 19:22:34 +0530794 return gl_dict
Anand Doshi979326b2015-09-11 16:22:37 +0530795
Anurag Mishrae657fe82018-11-26 15:19:17 +0530796 def validate_qty_is_not_zero(self):
Maricac68a9402019-12-03 12:59:22 +0530797 if self.doctype != "Purchase Receipt":
798 for item in self.items:
799 if not item.qty:
800 frappe.throw(_("Item quantity can not be zero"))
Anurag Mishrae657fe82018-11-26 15:19:17 +0530801
Nabin Hait895029d2015-08-20 14:55:39 +0530802 def validate_account_currency(self, account, account_currency=None):
Nabin Hait6e439a52015-08-28 19:24:22 +0530803 valid_currency = [self.company_currency]
804 if self.get("currency") and self.currency != self.company_currency:
805 valid_currency.append(self.currency)
806
Nabin Hait895029d2015-08-20 14:55:39 +0530807 if account_currency not in valid_currency:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530808 frappe.throw(
809 _("Account {0} is invalid. Account Currency must be {1}").format(
810 account, (" " + _("or") + " ").join(valid_currency)
811 )
812 )
Anand Doshi979326b2015-09-11 16:22:37 +0530813
Anand Doshi613cb6a2013-02-06 17:33:46 +0530814 def clear_unallocated_advances(self, childtype, parentfield):
Rushabh Mehtaf191f852014-04-02 18:09:34 +0530815 self.set(parentfield, self.get(parentfield, {"allocated_amount": ["not in", [0, None, ""]]}))
816
Ankush Menat494bd9e2022-03-28 18:52:46 +0530817 frappe.db.sql(
818 """delete from `tab%s` where parentfield=%s and parent = %s
819 and allocated_amount = 0"""
820 % (childtype, "%s", "%s"),
821 (parentfield, self.name),
822 )
Anand Doshid2946502014-04-08 20:10:03 +0530823
Walstan Baptistad6360752021-03-31 12:30:32 +0530824 @frappe.whitelist()
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530825 def apply_shipping_rule(self):
826 if self.shipping_rule:
827 shipping_rule = frappe.get_doc("Shipping Rule", self.shipping_rule)
828 shipping_rule.apply(self)
829 self.calculate_taxes_and_totals()
830
831 def get_shipping_address(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530832 """Returns Address object from shipping address fields if present"""
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530833
834 # shipping address fields can be `shipping_address_name` or `shipping_address`
835 # try getting value from both
836
Ankush Menat494bd9e2022-03-28 18:52:46 +0530837 for fieldname in ("shipping_address_name", "shipping_address"):
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530838 shipping_field = self.meta.get_field(fieldname)
Ankush Menat494bd9e2022-03-28 18:52:46 +0530839 if shipping_field and shipping_field.fieldtype == "Link":
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530840 if self.get(fieldname):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530841 return frappe.get_doc("Address", self.get(fieldname))
Rushabh Mehta30dc9a12017-11-17 14:31:09 +0530842
843 return {}
844
Walstan Baptistad6360752021-03-31 12:30:32 +0530845 @frappe.whitelist()
Nabin Hait041a5c22018-08-01 18:07:39 +0530846 def set_advances(self):
847 """Returns list of advances against Account, Party, Reference"""
848
Deepesh Gargfd3fb642023-04-05 12:02:44 +0530849 res = self.get_advance_entries(
850 include_unallocated=not cint(self.get("only_include_allocated_payments"))
851 )
Nabin Hait041a5c22018-08-01 18:07:39 +0530852
853 self.set("advances", [])
854 advance_allocated = 0
855 for d in res:
Deepesh Garg181df2f2022-11-04 15:49:37 +0530856 if self.get("party_account_currency") == self.company_currency:
857 amount = self.get("base_rounded_total") or self.base_grand_total
Nabin Hait041a5c22018-08-01 18:07:39 +0530858 else:
Deepesh Garg181df2f2022-11-04 15:49:37 +0530859 amount = self.get("rounded_total") or self.grand_total
Deepesh Garg26210162020-08-11 16:06:13 +0530860
Deepesh Garg181df2f2022-11-04 15:49:37 +0530861 allocated_amount = min(amount - advance_allocated, d.amount)
Nabin Hait041a5c22018-08-01 18:07:39 +0530862 advance_allocated += flt(allocated_amount)
Rushabh Mehta708e47a2018-08-08 16:37:31 +0530863
Saqiba20999c2021-07-12 14:33:23 +0530864 advance_row = {
Nabin Hait041a5c22018-08-01 18:07:39 +0530865 "doctype": self.doctype + " Advance",
866 "reference_type": d.reference_type,
867 "reference_name": d.reference_name,
868 "reference_row": d.reference_row,
869 "remarks": d.remarks,
870 "advance_amount": flt(d.amount),
Saqiba20999c2021-07-12 14:33:23 +0530871 "allocated_amount": allocated_amount,
Ankush Menat494bd9e2022-03-28 18:52:46 +0530872 "ref_exchange_rate": flt(d.exchange_rate), # exchange_rate of advance entry
Saqiba20999c2021-07-12 14:33:23 +0530873 }
874
875 self.append("advances", advance_row)
Nabin Hait041a5c22018-08-01 18:07:39 +0530876
Nabin Hait28a05282016-06-27 17:41:39 +0530877 def get_advance_entries(self, include_unallocated=True):
878 if self.doctype == "Sales Invoice":
879 party_account = self.debit_to
880 party_type = "Customer"
881 party = self.customer
882 amount_field = "credit_in_account_currency"
883 order_field = "sales_order"
884 order_doctype = "Sales Order"
885 else:
886 party_account = self.credit_to
887 party_type = "Supplier"
888 party = self.supplier
889 amount_field = "debit_in_account_currency"
890 order_field = "purchase_order"
891 order_doctype = "Purchase Order"
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530892
Ankush Menat494bd9e2022-03-28 18:52:46 +0530893 order_list = list(set(d.get(order_field) for d in self.get("items") if d.get(order_field)))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530894
Ankush Menat494bd9e2022-03-28 18:52:46 +0530895 journal_entries = get_advance_journal_entries(
896 party_type, party, party_account, amount_field, order_doctype, order_list, include_unallocated
897 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530898
Ankush Menat494bd9e2022-03-28 18:52:46 +0530899 payment_entries = get_advance_payment_entries(
900 party_type, party, party_account, order_doctype, order_list, include_unallocated
901 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530902
Nabin Hait28a05282016-06-27 17:41:39 +0530903 res = journal_entries + payment_entries
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530904
Nabin Hait28a05282016-06-27 17:41:39 +0530905 return res
Nabin Hait48f5fa62014-09-18 15:03:54 +0530906
rohitwaghchaurebf4c1142018-01-08 15:20:15 +0530907 def is_inclusive_tax(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530908 is_inclusive = cint(
909 frappe.db.get_single_value("Accounts Settings", "show_inclusive_tax_in_print")
910 )
rohitwaghchaurebf4c1142018-01-08 15:20:15 +0530911
912 if is_inclusive:
913 is_inclusive = 0
914 if self.get("taxes", filters={"included_in_print_rate": 1}):
915 is_inclusive = 1
916
917 return is_inclusive
918
Nabin Hait28a05282016-06-27 17:41:39 +0530919 def validate_advance_entries(self):
Nabin Hait05aefbb2016-06-28 19:42:19 +0530920 order_field = "sales_order" if self.doctype == "Sales Invoice" else "purchase_order"
Ankush Menat494bd9e2022-03-28 18:52:46 +0530921 order_list = list(set(d.get(order_field) for d in self.get("items") if d.get(order_field)))
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530922
Ankush Menat494bd9e2022-03-28 18:52:46 +0530923 if not order_list:
924 return
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530925
Nabin Hait28a05282016-06-27 17:41:39 +0530926 advance_entries = self.get_advance_entries(include_unallocated=False)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530927
Nabin Hait28a05282016-06-27 17:41:39 +0530928 if advance_entries:
929 advance_entries_against_si = [d.reference_name for d in self.get("advances")]
930 for d in advance_entries:
931 if not advance_entries_against_si or d.reference_name not in advance_entries_against_si:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530932 frappe.msgprint(
933 _(
934 "Payment Entry {0} is linked against Order {1}, check if it should be pulled as advance in this invoice."
935 ).format(d.reference_name, d.against_order)
936 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +0530937
Saqiba20999c2021-07-12 14:33:23 +0530938 def set_advance_gain_or_loss(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530939 if self.get("conversion_rate") == 1 or not self.get("advances"):
Saqib Ansari64efe8b2021-09-26 15:46:13 +0530940 return
941
Ankush Menat494bd9e2022-03-28 18:52:46 +0530942 is_purchase_invoice = self.doctype == "Purchase Invoice"
Saqib Ansari64efe8b2021-09-26 15:46:13 +0530943 party_account = self.credit_to if is_purchase_invoice else self.debit_to
944 if get_account_currency(party_account) != self.currency:
Saqiba20999c2021-07-12 14:33:23 +0530945 return
946
947 for d in self.get("advances"):
948 advance_exchange_rate = d.ref_exchange_rate
Ankush Menat494bd9e2022-03-28 18:52:46 +0530949 if d.allocated_amount and self.conversion_rate != advance_exchange_rate:
Saqiba20999c2021-07-12 14:33:23 +0530950
951 base_allocated_amount_in_ref_rate = advance_exchange_rate * d.allocated_amount
952 base_allocated_amount_in_inv_rate = self.conversion_rate * d.allocated_amount
953 difference = base_allocated_amount_in_ref_rate - base_allocated_amount_in_inv_rate
954
955 d.exchange_gain_loss = difference
956
957 def make_exchange_gain_loss_gl_entries(self, gl_entries):
Ankush Menat494bd9e2022-03-28 18:52:46 +0530958 if self.get("doctype") in ["Purchase Invoice", "Sales Invoice"]:
Saqiba20999c2021-07-12 14:33:23 +0530959 for d in self.get("advances"):
960 if d.exchange_gain_loss:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530961 is_purchase_invoice = self.get("doctype") == "Purchase Invoice"
Saqibd4ae1fe2021-07-30 11:21:49 +0530962 party = self.supplier if is_purchase_invoice else self.customer
963 party_account = self.credit_to if is_purchase_invoice else self.debit_to
964 party_type = "Supplier" if is_purchase_invoice else "Customer"
Saqiba20999c2021-07-12 14:33:23 +0530965
Daizy Modi4efc9472022-11-07 09:21:03 +0530966 gain_loss_account = frappe.get_cached_value(
967 "Company", self.company, "exchange_gain_loss_account"
968 )
Saqibd4ae1fe2021-07-30 11:21:49 +0530969 if not gain_loss_account:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530970 frappe.throw(
971 _("Please set default Exchange Gain/Loss Account in Company {}").format(self.get("company"))
972 )
Saqiba20999c2021-07-12 14:33:23 +0530973 account_currency = get_account_currency(gain_loss_account)
974 if account_currency != self.company_currency:
Ankush Menat494bd9e2022-03-28 18:52:46 +0530975 frappe.throw(
976 _("Currency for {0} must be {1}").format(gain_loss_account, self.company_currency)
977 )
Saqiba20999c2021-07-12 14:33:23 +0530978
979 # for purchase
Ankush Menat494bd9e2022-03-28 18:52:46 +0530980 dr_or_cr = "debit" if d.exchange_gain_loss > 0 else "credit"
Saqibd4ae1fe2021-07-30 11:21:49 +0530981 if not is_purchase_invoice:
982 # just reverse for sales?
Ankush Menat494bd9e2022-03-28 18:52:46 +0530983 dr_or_cr = "debit" if dr_or_cr == "credit" else "credit"
Saqiba20999c2021-07-12 14:33:23 +0530984
985 gl_entries.append(
Ankush Menat494bd9e2022-03-28 18:52:46 +0530986 self.get_gl_dict(
987 {
988 "account": gain_loss_account,
989 "account_currency": account_currency,
990 "against": party,
991 dr_or_cr + "_in_account_currency": abs(d.exchange_gain_loss),
992 dr_or_cr: abs(d.exchange_gain_loss),
993 "cost_center": self.cost_center or erpnext.get_default_cost_center(self.company),
994 "project": self.project,
995 },
996 item=d,
997 )
Saqiba20999c2021-07-12 14:33:23 +0530998 )
999
Ankush Menat494bd9e2022-03-28 18:52:46 +05301000 dr_or_cr = "debit" if dr_or_cr == "credit" else "credit"
Saqiba20999c2021-07-12 14:33:23 +05301001
1002 gl_entries.append(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301003 self.get_gl_dict(
1004 {
1005 "account": party_account,
1006 "party_type": party_type,
1007 "party": party,
1008 "against": gain_loss_account,
1009 dr_or_cr + "_in_account_currency": flt(abs(d.exchange_gain_loss) / self.conversion_rate),
1010 dr_or_cr: abs(d.exchange_gain_loss),
1011 "cost_center": self.cost_center,
1012 "project": self.project,
1013 },
1014 self.party_account_currency,
1015 item=self,
1016 )
Saqiba20999c2021-07-12 14:33:23 +05301017 )
1018
Nabin Hait28a05282016-06-27 17:41:39 +05301019 def update_against_document_in_jv(self):
1020 """
Ankush Menat494bd9e2022-03-28 18:52:46 +05301021 Links invoice and advance voucher:
1022 1. cancel advance voucher
1023 2. split into multiple rows if partially adjusted, assign against voucher
1024 3. submit advance voucher
Nabin Hait28a05282016-06-27 17:41:39 +05301025 """
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301026
Nabin Hait28a05282016-06-27 17:41:39 +05301027 if self.doctype == "Sales Invoice":
Nabin Haitff2f3ef2016-07-04 11:41:14 +05301028 party_type = "Customer"
Nabin Hait28a05282016-06-27 17:41:39 +05301029 party = self.customer
1030 party_account = self.debit_to
1031 dr_or_cr = "credit_in_account_currency"
1032 else:
Nabin Haitff2f3ef2016-07-04 11:41:14 +05301033 party_type = "Supplier"
Nabin Hait28a05282016-06-27 17:41:39 +05301034 party = self.supplier
1035 party_account = self.credit_to
1036 dr_or_cr = "debit_in_account_currency"
Nabin Hait48f5fa62014-09-18 15:03:54 +05301037
Nabin Hait28a05282016-06-27 17:41:39 +05301038 lst = []
Ankush Menat494bd9e2022-03-28 18:52:46 +05301039 for d in self.get("advances"):
Nabin Hait28a05282016-06-27 17:41:39 +05301040 if flt(d.allocated_amount) > 0:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301041 args = frappe._dict(
1042 {
1043 "voucher_type": d.reference_type,
1044 "voucher_no": d.reference_name,
1045 "voucher_detail_no": d.reference_row,
1046 "against_voucher_type": self.doctype,
1047 "against_voucher": self.name,
1048 "account": party_account,
1049 "party_type": party_type,
1050 "party": party,
1051 "is_advance": "Yes",
1052 "dr_or_cr": dr_or_cr,
1053 "unadjusted_amount": flt(d.advance_amount),
1054 "allocated_amount": flt(d.allocated_amount),
1055 "precision": d.precision("advance_amount"),
1056 "exchange_rate": (
1057 self.conversion_rate if self.party_account_currency != self.company_currency else 1
1058 ),
1059 "grand_total": (
1060 self.base_grand_total
1061 if self.party_account_currency == self.company_currency
1062 else self.grand_total
1063 ),
1064 "outstanding_amount": self.outstanding_amount,
Daizy Modi4efc9472022-11-07 09:21:03 +05301065 "difference_account": frappe.get_cached_value(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301066 "Company", self.company, "exchange_gain_loss_account"
1067 ),
1068 "exchange_gain_loss": flt(d.get("exchange_gain_loss")),
1069 }
1070 )
Nabin Hait28a05282016-06-27 17:41:39 +05301071 lst.append(args)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301072
Nabin Hait28a05282016-06-27 17:41:39 +05301073 if lst:
1074 from erpnext.accounts.utils import reconcile_against_document
Ankush Menat494bd9e2022-03-28 18:52:46 +05301075
Nabin Hait28a05282016-06-27 17:41:39 +05301076 reconcile_against_document(lst)
Anand Doshid2946502014-04-08 20:10:03 +05301077
Rohit Waghchaure5fa9a7a2019-04-01 00:40:38 +05301078 def on_cancel(self):
1079 from erpnext.accounts.utils import unlink_ref_doc_from_payment_entries
1080
1081 if self.doctype in ["Sales Invoice", "Purchase Invoice"]:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301082 if frappe.db.get_single_value("Accounts Settings", "unlink_payment_on_cancellation_of_invoice"):
Rohit Waghchaure5fa9a7a2019-04-01 00:40:38 +05301083 unlink_ref_doc_from_payment_entries(self)
1084
1085 elif self.doctype in ["Sales Order", "Purchase Order"]:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301086 if frappe.db.get_single_value(
1087 "Accounts Settings", "unlink_advance_payment_on_cancelation_of_order"
1088 ):
Rohit Waghchaure5fa9a7a2019-04-01 00:40:38 +05301089 unlink_ref_doc_from_payment_entries(self)
1090
GangaManoj8396f242021-09-20 19:01:46 +05301091 if self.doctype == "Sales Order":
1092 self.unlink_ref_doc_from_po()
1093
1094 def unlink_ref_doc_from_po(self):
GangaManoj8396f242021-09-20 19:01:46 +05301095 so_items = []
1096 for item in self.items:
1097 so_items.append(item.name)
1098
Ankush Menat494bd9e2022-03-28 18:52:46 +05301099 linked_po = list(
1100 set(
1101 frappe.get_all(
1102 "Purchase Order Item",
1103 filters={
1104 "sales_order": self.name,
1105 "sales_order_item": ["in", so_items],
1106 "docstatus": ["<", 2],
1107 },
1108 pluck="parent",
1109 )
1110 )
1111 )
GangaManoj8396f242021-09-20 19:01:46 +05301112
GangaManoj8396f242021-09-20 19:01:46 +05301113 if linked_po:
GangaManoje77534f2021-09-20 19:01:46 +05301114 frappe.db.set_value(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301115 "Purchase Order Item",
1116 {"sales_order": self.name, "sales_order_item": ["in", so_items], "docstatus": ["<", 2]},
1117 {"sales_order": None, "sales_order_item": None},
GangaManoje77534f2021-09-20 19:01:46 +05301118 )
GangaManoj8396f242021-09-20 19:01:46 +05301119
1120 frappe.msgprint(_("Purchase Orders {0} are un-linked").format("\n".join(linked_po)))
1121
Deepesh Gargd18dde72020-11-29 21:40:04 +05301122 def get_tax_map(self):
1123 tax_map = {}
Ankush Menat494bd9e2022-03-28 18:52:46 +05301124 for tax in self.get("taxes"):
Deepesh Gargd18dde72020-11-29 21:40:04 +05301125 tax_map.setdefault(tax.account_head, 0.0)
1126 tax_map[tax.account_head] += tax.tax_amount
1127
1128 return tax_map
1129
Deepesh Garg92f7a5a2021-07-21 15:25:40 +05301130 def get_amount_and_base_amount(self, item, enable_discount_accounting):
1131 amount = item.net_amount
1132 base_amount = item.base_net_amount
1133
Ankush Menat494bd9e2022-03-28 18:52:46 +05301134 if (
1135 enable_discount_accounting
1136 and self.get("discount_amount")
1137 and self.get("additional_discount_account")
1138 ):
Deepesh Garg92f7a5a2021-07-21 15:25:40 +05301139 amount = item.amount
1140 base_amount = item.base_amount
1141
1142 return amount, base_amount
1143
1144 def get_tax_amounts(self, tax, enable_discount_accounting):
1145 amount = tax.tax_amount_after_discount_amount
1146 base_amount = tax.base_tax_amount_after_discount_amount
1147
Ankush Menat494bd9e2022-03-28 18:52:46 +05301148 if (
1149 enable_discount_accounting
1150 and self.get("discount_amount")
1151 and self.get("additional_discount_account")
1152 and self.get("apply_discount_on") == "Grand Total"
1153 ):
Deepesh Garg92f7a5a2021-07-21 15:25:40 +05301154 amount = tax.tax_amount
1155 base_amount = tax.base_tax_amount
1156
1157 return amount, base_amount
1158
GangaManoj8f7b0a12021-07-13 03:01:02 +05301159 def make_discount_gl_entries(self, gl_entries):
rahib-hassanf3fa6ac2022-04-20 16:01:12 +05301160 if self.doctype == "Purchase Invoice":
1161 enable_discount_accounting = cint(
1162 frappe.db.get_single_value("Buying Settings", "enable_discount_accounting")
1163 )
1164 elif self.doctype == "Sales Invoice":
1165 enable_discount_accounting = cint(
1166 frappe.db.get_single_value("Selling Settings", "enable_discount_accounting")
1167 )
GangaManoj8f7b0a12021-07-13 03:01:02 +05301168
Deepesh Garg3b159662022-08-21 17:51:05 +05301169 if self.doctype == "Purchase Invoice":
1170 dr_or_cr = "credit"
1171 rev_dr_cr = "debit"
1172 supplier_or_customer = self.supplier
1173
1174 else:
1175 dr_or_cr = "debit"
1176 rev_dr_cr = "credit"
1177 supplier_or_customer = self.customer
1178
GangaManoj8f7b0a12021-07-13 03:01:02 +05301179 if enable_discount_accounting:
1180 for item in self.get("items"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301181 if item.get("discount_amount") and item.get("discount_account"):
Deepesh Gargad7bb312021-07-28 11:38:44 +05301182 discount_amount = item.discount_amount * item.qty
GangaManoj8f7b0a12021-07-13 03:01:02 +05301183 if self.doctype == "Purchase Invoice":
Ankush Menat494bd9e2022-03-28 18:52:46 +05301184 income_or_expense_account = (
1185 item.expense_account
Ankush Menat4551d7d2021-08-19 13:41:10 +05301186 if (not item.enable_deferred_expense or self.is_return)
Ankush Menat494bd9e2022-03-28 18:52:46 +05301187 else item.deferred_expense_account
1188 )
GangaManoj8f7b0a12021-07-13 03:01:02 +05301189 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301190 income_or_expense_account = (
1191 item.income_account
Ankush Menat4551d7d2021-08-19 13:41:10 +05301192 if (not item.enable_deferred_revenue or self.is_return)
Ankush Menat494bd9e2022-03-28 18:52:46 +05301193 else item.deferred_revenue_account
1194 )
GangaManoj8f7b0a12021-07-13 03:01:02 +05301195
1196 account_currency = get_account_currency(item.discount_account)
1197 gl_entries.append(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301198 self.get_gl_dict(
1199 {
1200 "account": item.discount_account,
1201 "against": supplier_or_customer,
Saqib Ansarif915a9c2022-05-17 11:22:01 +05301202 dr_or_cr: flt(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301203 discount_amount * self.get("conversion_rate"), item.precision("discount_amount")
1204 ),
Saqib Ansarif915a9c2022-05-17 11:22:01 +05301205 dr_or_cr + "_in_account_currency": flt(discount_amount, item.precision("discount_amount")),
Ankush Menat494bd9e2022-03-28 18:52:46 +05301206 "cost_center": item.cost_center,
1207 "project": item.project,
1208 },
1209 account_currency,
1210 item=item,
1211 )
GangaManoj8f7b0a12021-07-13 03:01:02 +05301212 )
1213
1214 account_currency = get_account_currency(income_or_expense_account)
1215 gl_entries.append(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301216 self.get_gl_dict(
1217 {
1218 "account": income_or_expense_account,
1219 "against": supplier_or_customer,
Saqib Ansarif915a9c2022-05-17 11:22:01 +05301220 rev_dr_cr: flt(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301221 discount_amount * self.get("conversion_rate"), item.precision("discount_amount")
1222 ),
Saqib Ansarif915a9c2022-05-17 11:22:01 +05301223 rev_dr_cr
1224 + "_in_account_currency": flt(discount_amount, item.precision("discount_amount")),
Ankush Menat494bd9e2022-03-28 18:52:46 +05301225 "cost_center": item.cost_center,
1226 "project": item.project or self.project,
1227 },
1228 account_currency,
1229 item=item,
1230 )
GangaManoj8f7b0a12021-07-13 03:01:02 +05301231 )
GangaManoj857501c2021-07-15 22:03:46 +05301232
Deepesh Garg3b159662022-08-21 17:51:05 +05301233 if (
Deepesh Gargae3dce02022-08-22 08:57:58 +05301234 (enable_discount_accounting or self.get("is_cash_or_non_trade_discount"))
Deepesh Garg3b159662022-08-21 17:51:05 +05301235 and self.get("additional_discount_account")
1236 and self.get("discount_amount")
1237 ):
1238 gl_entries.append(
1239 self.get_gl_dict(
1240 {
1241 "account": self.additional_discount_account,
1242 "against": supplier_or_customer,
1243 dr_or_cr: self.discount_amount,
1244 "cost_center": self.cost_center,
1245 },
1246 item=self,
Ankush Menat4551d7d2021-08-19 13:41:10 +05301247 )
Deepesh Garg3b159662022-08-21 17:51:05 +05301248 )
Ankush Menat4551d7d2021-08-19 13:41:10 +05301249
Deepesh Garg4c61ee32023-04-02 09:35:27 +05301250 def validate_multiple_billing(self, ref_dt, item_ref_dn, based_on):
Nabin Hait868766d2019-07-15 18:02:58 +05301251 from erpnext.controllers.status_updater import get_allowance_for
Saqib9c913c92021-11-26 12:00:13 +05301252
Nabin Hait868766d2019-07-15 18:02:58 +05301253 item_allowance = {}
1254 global_qty_allowance, global_amount_allowance = None, None
Anand Doshid2946502014-04-08 20:10:03 +05301255
Ankush Menat494bd9e2022-03-28 18:52:46 +05301256 role_allowed_to_over_bill = frappe.db.get_single_value(
1257 "Accounts Settings", "role_allowed_to_over_bill"
1258 )
Ankush Menat648b2d72021-09-20 15:27:12 +05301259 user_roles = frappe.get_roles()
1260
Ankush Menat43bf82b2021-09-20 16:31:20 +05301261 total_overbilled_amt = 0.0
1262
Deepesh Garg4c61ee32023-04-02 09:35:27 +05301263 reference_names = [d.get(item_ref_dn) for d in self.get("items") if d.get(item_ref_dn)]
1264 reference_details = self.get_billing_reference_details(
1265 reference_names, ref_dt + " Item", based_on
1266 )
1267
Nabin Hait4b8185d2014-12-25 18:19:39 +05301268 for item in self.get("items"):
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301269 if not item.get(item_ref_dn):
1270 continue
Anand Doshid2946502014-04-08 20:10:03 +05301271
Deepesh Garg4c61ee32023-04-02 09:35:27 +05301272 ref_amt = flt(reference_details.get(item.get(item_ref_dn)), self.precision(based_on, item))
1273
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301274 if not ref_amt:
1275 frappe.msgprint(
Deepesh Garg4c61ee32023-04-02 09:35:27 +05301276 _("System will not check over billing since amount for Item {0} in {1} is zero").format(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301277 item.item_code, ref_dt
1278 ),
1279 title=_("Warning"),
1280 indicator="orange",
1281 )
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301282 continue
Anand Doshid2946502014-04-08 20:10:03 +05301283
Saqib9c913c92021-11-26 12:00:13 +05301284 already_billed = self.get_billed_amount_for_item(item, item_ref_dn, based_on)
Anand Doshid2946502014-04-08 20:10:03 +05301285
Ankush Menat494bd9e2022-03-28 18:52:46 +05301286 total_billed_amt = flt(
1287 flt(already_billed) + flt(item.get(based_on)), self.precision(based_on, item)
1288 )
Anand Doshid2946502014-04-08 20:10:03 +05301289
Ankush Menat494bd9e2022-03-28 18:52:46 +05301290 allowance, item_allowance, global_qty_allowance, global_amount_allowance = get_allowance_for(
1291 item.item_code, item_allowance, global_qty_allowance, global_amount_allowance, "amount"
1292 )
rohitwaghchaure285344e2019-10-11 11:02:11 +05301293
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301294 max_allowed_amt = flt(ref_amt * (100 + allowance) / 100)
Deepesh Gargcb718fc2021-04-19 13:25:15 +05301295
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301296 if total_billed_amt < 0 and max_allowed_amt < 0:
1297 # while making debit note against purchase return entry(purchase receipt) getting overbill error
1298 total_billed_amt = abs(total_billed_amt)
1299 max_allowed_amt = abs(max_allowed_amt)
Afshan53fefd72021-06-24 10:09:02 +05301300
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301301 overbill_amt = total_billed_amt - max_allowed_amt
1302 total_overbilled_amt += overbill_amt
1303
1304 if overbill_amt > 0.01 and role_allowed_to_over_bill not in user_roles:
1305 if self.doctype != "Purchase Invoice":
1306 self.throw_overbill_exception(item, max_allowed_amt)
Ankush Menat494bd9e2022-03-28 18:52:46 +05301307 elif not cint(
1308 frappe.db.get_single_value(
1309 "Buying Settings", "bill_for_rejected_quantity_in_purchase_invoice"
1310 )
1311 ):
Ankush Menat5e4fbba2021-09-20 16:36:27 +05301312 self.throw_overbill_exception(item, max_allowed_amt)
1313
1314 if role_allowed_to_over_bill in user_roles and total_overbilled_amt > 0.1:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301315 frappe.msgprint(
1316 _("Overbilling of {} ignored because you have {} role.").format(
1317 total_overbilled_amt, role_allowed_to_over_bill
1318 ),
1319 indicator="orange",
1320 alert=True,
1321 )
Afshan53fefd72021-06-24 10:09:02 +05301322
Deepesh Garg4c61ee32023-04-02 09:35:27 +05301323 def get_billing_reference_details(self, reference_names, reference_doctype, based_on):
1324 return frappe._dict(
1325 frappe.get_all(
1326 reference_doctype,
1327 filters={"name": ("in", reference_names)},
1328 fields=["name", based_on],
1329 as_list=1,
1330 )
1331 )
1332
Saqib9c913c92021-11-26 12:00:13 +05301333 def get_billed_amount_for_item(self, item, item_ref_dn, based_on):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301334 """
1335 Returns Sum of Amount of
1336 Sales/Purchase Invoice Items
1337 that are linked to `item_ref_dn` (`dn_detail` / `pr_detail`)
1338 that are submitted OR not submitted but are under current invoice
1339 """
Saqib9c913c92021-11-26 12:00:13 +05301340
1341 from frappe.query_builder import Criterion
1342 from frappe.query_builder.functions import Sum
1343
1344 item_doctype = frappe.qb.DocType(item.doctype)
1345 based_on_field = frappe.qb.Field(based_on)
1346 join_field = frappe.qb.Field(item_ref_dn)
1347
1348 result = (
1349 frappe.qb.from_(item_doctype)
1350 .select(Sum(based_on_field))
Ankush Menat494bd9e2022-03-28 18:52:46 +05301351 .where(join_field == item.get(item_ref_dn))
Saqib9c913c92021-11-26 12:00:13 +05301352 .where(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301353 Criterion.any(
1354 [ # select all items from other invoices OR current invoices
1355 Criterion.all(
1356 [ # for selecting items from other invoices
1357 item_doctype.docstatus == 1,
1358 item_doctype.parent != self.name,
1359 ]
1360 ),
1361 Criterion.all(
1362 [ # for selecting items from current invoice, that are linked to same reference
1363 item_doctype.docstatus == 0,
1364 item_doctype.parent == self.name,
1365 item_doctype.name != item.name,
1366 ]
1367 ),
1368 ]
1369 )
Saqib9c913c92021-11-26 12:00:13 +05301370 )
1371 ).run()
1372
1373 return result[0][0] if result else 0
1374
Afshan53fefd72021-06-24 10:09:02 +05301375 def throw_overbill_exception(self, item, max_allowed_amt):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301376 frappe.throw(
1377 _(
1378 "Cannot overbill for Item {0} in row {1} more than {2}. To allow over-billing, please set allowance in Accounts Settings"
1379 ).format(item.item_code, item.idx, max_allowed_amt)
1380 )
Anand Doshid2946502014-04-08 20:10:03 +05301381
Rohit Waghchaure2a14f252021-07-30 12:36:35 +05301382 def get_company_default(self, fieldname, ignore_validation=False):
Rushabh Mehta1f847992013-12-12 19:12:19 +05301383 from erpnext.accounts.utils import get_company_default
Ankush Menat494bd9e2022-03-28 18:52:46 +05301384
Rohit Waghchaure2a14f252021-07-30 12:36:35 +05301385 return get_company_default(self.company, fieldname, ignore_validation=ignore_validation)
Anand Doshid2946502014-04-08 20:10:03 +05301386
Nabin Haita36adbd2013-08-02 14:50:12 +05301387 def get_stock_items(self):
1388 stock_items = []
Nabin Haitdd38a262014-12-26 13:15:21 +05301389 item_codes = list(set(item.item_code for item in self.get("items")))
Nabin Haita36adbd2013-08-02 14:50:12 +05301390 if item_codes:
Saqib Ansari199a6da2022-03-31 11:41:52 +05301391 stock_items = frappe.db.get_values(
1392 "Item", {"name": ["in", item_codes], "is_stock_item": 1}, pluck="name", cache=True
1393 )
Anand Doshid2946502014-04-08 20:10:03 +05301394
Nabin Haita36adbd2013-08-02 14:50:12 +05301395 return stock_items
Anand Doshid2946502014-04-08 20:10:03 +05301396
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301397 def set_total_advance_paid(self):
ruthra kumar44870652022-11-01 10:11:38 +05301398 ple = frappe.qb.DocType("Payment Ledger Entry")
1399 party = self.customer if self.doctype == "Sales Order" else self.supplier
1400 advance = (
1401 frappe.qb.from_(ple)
ruthra kumarbf76b852022-11-22 12:16:11 +05301402 .select(ple.account_currency, Abs(Sum(ple.amount_in_account_currency)).as_("amount"))
ruthra kumar44870652022-11-01 10:11:38 +05301403 .where(
1404 (ple.against_voucher_type == self.doctype)
1405 & (ple.against_voucher_no == self.name)
1406 & (ple.party == party)
ruthra kumarbf76b852022-11-22 12:16:11 +05301407 & (ple.docstatus == 1)
ruthra kumar44870652022-11-01 10:11:38 +05301408 & (ple.company == self.company)
1409 )
1410 .run(as_dict=True)
1411 )
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301412
Nabin Haitb2206d12016-01-27 15:43:12 +05301413 if advance:
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301414 advance = advance[0]
Deepesh Garg2a9c5ba2020-04-30 10:38:58 +05301415
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301416 advance_paid = flt(advance.amount, self.precision("advance_paid"))
Ankush Menat494bd9e2022-03-28 18:52:46 +05301417 formatted_advance_paid = fmt_money(
1418 advance_paid, precision=self.precision("advance_paid"), currency=advance.account_currency
1419 )
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301420
Ankush Menat494bd9e2022-03-28 18:52:46 +05301421 frappe.db.set_value(self.doctype, self.name, "party_account_currency", advance.account_currency)
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301422
1423 if advance.account_currency == self.currency:
finbyz5efc7972019-01-05 11:12:11 +05301424 order_total = self.get("rounded_total") or self.grand_total
1425 precision = "rounded_total" if self.get("rounded_total") else "grand_total"
Nabin Haitb2206d12016-01-27 15:43:12 +05301426 else:
finbyz5efc7972019-01-05 11:12:11 +05301427 order_total = self.get("base_rounded_total") or self.base_grand_total
1428 precision = "base_rounded_total" if self.get("base_rounded_total") else "base_grand_total"
Sagar Voraf733a392019-01-07 14:24:01 +05301429
Ankush Menat494bd9e2022-03-28 18:52:46 +05301430 formatted_order_total = fmt_money(
1431 order_total, precision=self.precision(precision), currency=advance.account_currency
1432 )
Anand Doshi7c0a58a2016-01-29 12:16:24 +05301433
Nabin Hait9db1b222016-06-30 12:37:53 +05301434 if self.currency == self.company_currency and advance_paid > order_total:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301435 frappe.throw(
1436 _(
1437 "Total advance ({0}) against Order {1} cannot be greater than the Grand Total ({2})"
1438 ).format(formatted_advance_paid, self.name, formatted_order_total)
1439 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05301440
Nabin Hait13093b42016-06-29 18:04:37 +05301441 frappe.db.set_value(self.doctype, self.name, "advance_paid", advance_paid)
Ankit Javalkar8e7ca412014-09-12 15:18:53 +05301442
ankitjavalkarworke60822b2014-08-26 14:29:06 +05301443 @property
1444 def company_abbr(self):
Nabin Hait6a5695f2018-08-09 11:30:21 +05301445 if not hasattr(self, "_abbr"):
Daizy Modi4efc9472022-11-07 09:21:03 +05301446 self._abbr = frappe.get_cached_value("Company", self.company, "abbr")
ankitjavalkarworke60822b2014-08-26 14:29:06 +05301447
1448 return self._abbr
1449
marination4be5b5c2020-10-08 19:08:27 +05301450 def raise_missing_debit_credit_account_error(self, party_type, party):
marination53b1a9a2020-11-03 15:45:25 +05301451 """Raise an error if debit to/credit to account does not exist."""
Ankush Menat494bd9e2022-03-28 18:52:46 +05301452 db_or_cr = (
1453 frappe.bold("Debit To") if self.doctype == "Sales Invoice" else frappe.bold("Credit To")
1454 )
marination4be5b5c2020-10-08 19:08:27 +05301455 rec_or_pay = "Receivable" if self.doctype == "Sales Invoice" else "Payable"
1456
1457 link_to_party = frappe.utils.get_link_to_form(party_type, party)
1458 link_to_company = frappe.utils.get_link_to_form("Company", self.company)
1459
Ankush Menat494bd9e2022-03-28 18:52:46 +05301460 message = _("{0} Account not found against Customer {1}.").format(
1461 db_or_cr, frappe.bold(party) or ""
1462 )
marination4be5b5c2020-10-08 19:08:27 +05301463 message += "<br>" + _("Please set one of the following:") + "<br>"
Ankush Menat494bd9e2022-03-28 18:52:46 +05301464 message += (
1465 "<br><ul><li>"
1466 + _("'Account' in the Accounting section of Customer {0}").format(link_to_party)
1467 + "</li>"
1468 )
1469 message += (
1470 "<li>"
1471 + _("'Default {0} Account' in Company {1}").format(rec_or_pay, link_to_company)
1472 + "</li></ul>"
1473 )
marination4be5b5c2020-10-08 19:08:27 +05301474
marination53b1a9a2020-11-03 15:45:25 +05301475 frappe.throw(message, title=_("Account Missing"), exc=AccountMissingError)
marination4be5b5c2020-10-08 19:08:27 +05301476
Neil Trini Lasrado3fbbb712015-07-17 12:10:12 +05301477 def validate_party(self):
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301478 party_type, party = self.get_party()
shreyaseba9ca42016-01-26 14:56:52 +05301479 validate_party_frozen_disabled(party_type, party)
Anand Doshi979326b2015-09-11 16:22:37 +05301480
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301481 def get_party(self):
Neil Trini Lasrado79bf2332015-07-20 13:03:48 +05301482 party_type = None
shreyas29b565f2016-01-25 17:30:49 +05301483 if self.doctype in ("Opportunity", "Quotation", "Sales Order", "Delivery Note", "Sales Invoice"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301484 party_type = "Customer"
shreyas29b565f2016-01-25 17:30:49 +05301485
Ankush Menat494bd9e2022-03-28 18:52:46 +05301486 elif self.doctype in (
1487 "Supplier Quotation",
1488 "Purchase Order",
1489 "Purchase Receipt",
1490 "Purchase Invoice",
1491 ):
1492 party_type = "Supplier"
shreyas29b565f2016-01-25 17:30:49 +05301493
1494 elif self.meta.get_field("customer"):
1495 party_type = "Customer"
Neil Trini Lasrado3fbbb712015-07-17 12:10:12 +05301496
Neil Trini Lasrado79bf2332015-07-20 13:03:48 +05301497 elif self.meta.get_field("supplier"):
shreyas29b565f2016-01-25 17:30:49 +05301498 party_type = "Supplier"
Anand Doshi979326b2015-09-11 16:22:37 +05301499
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301500 party = self.get(party_type.lower()) if party_type else None
Anand Doshi979326b2015-09-11 16:22:37 +05301501
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301502 return party_type, party
Anand Doshi979326b2015-09-11 16:22:37 +05301503
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301504 def validate_currency(self):
Nabin Hait6e439a52015-08-28 19:24:22 +05301505 if self.get("currency"):
Nabin Hait4ffd7f32015-08-27 12:28:36 +05301506 party_type, party = self.get_party()
Nabin Hait6e439a52015-08-28 19:24:22 +05301507 if party_type and party:
Anand Doshib20baf82015-09-25 16:17:50 +05301508 party_account_currency = get_party_account_currency(party_type, party, self.company)
Anand Doshi979326b2015-09-11 16:22:37 +05301509
Ankush Menat494bd9e2022-03-28 18:52:46 +05301510 if (
1511 party_account_currency
1512 and party_account_currency != self.company_currency
1513 and self.currency != party_account_currency
1514 ):
1515 frappe.throw(
1516 _("Accounting Entry for {0}: {1} can only be made in currency: {2}").format(
1517 party_type, party, party_account_currency
1518 ),
1519 InvalidCurrency,
1520 )
Anand Doshi979326b2015-09-11 16:22:37 +05301521
shreyas29b565f2016-01-25 17:30:49 +05301522 # Note: not validating with gle account because we don't have the account
1523 # at quotation / sales order level and we shouldn't stop someone
1524 # from creating a sales invoice if sales order is already created
Rushabh Mehta2cb7a9f2016-06-15 16:45:03 +05301525
Deepesh Garg80c85dd2021-08-12 15:39:07 +05301526 def validate_party_account_currency(self):
Deepesh Garg33d97672022-05-12 16:40:29 +05301527 if self.doctype not in ("Sales Invoice", "Purchase Invoice"):
Deepesh Garg80c85dd2021-08-12 15:39:07 +05301528 return
1529
Deepesh Garg33d97672022-05-12 16:40:29 +05301530 if self.is_opening == "Yes":
Deepesh Garg60915e82021-08-21 23:05:48 +05301531 return
1532
Deepesh Garg80c85dd2021-08-12 15:39:07 +05301533 party_type, party = self.get_party()
1534 party_gle_currency = get_party_gle_currency(party_type, party, self.company)
Deepesh Garg33d97672022-05-12 16:40:29 +05301535 party_account = (
1536 self.get("debit_to") if self.doctype == "Sales Invoice" else self.get("credit_to")
1537 )
Deepesh Garg80c85dd2021-08-12 15:39:07 +05301538 party_account_currency = get_account_currency(party_account)
Deepesh Garge04e67c2022-07-11 19:25:18 +05301539 allow_multi_currency_invoices_against_single_party_account = frappe.db.get_singles_value(
Deepesh Garg3cf609f2022-07-11 13:46:59 +05301540 "Accounts Settings", "allow_multi_currency_invoices_against_single_party_account"
1541 )
Deepesh Garg80c85dd2021-08-12 15:39:07 +05301542
Deepesh Garg3cf609f2022-07-11 13:46:59 +05301543 if (
1544 not party_gle_currency
1545 and (party_account_currency != self.currency)
1546 and not allow_multi_currency_invoices_against_single_party_account
1547 ):
Deepesh Garg33d97672022-05-12 16:40:29 +05301548 frappe.throw(
Devin Slauenwhite3a1c9232022-06-02 14:15:50 -04001549 _("Party Account {0} currency ({1}) and document currency ({2}) should be same").format(
Devin Slauenwhiteb061ea42022-06-02 14:23:54 -04001550 frappe.bold(party_account), party_account_currency, self.currency
Deepesh Garg33d97672022-05-12 16:40:29 +05301551 )
1552 )
Deepesh Garg80c85dd2021-08-12 15:39:07 +05301553
Nabin Hait297d74a2016-11-23 15:58:51 +05301554 def delink_advance_entries(self, linked_doc_name):
1555 total_allocated_amount = 0
1556 for adv in self.advances:
1557 consider_for_total_advance = True
1558 if adv.reference_name == linked_doc_name:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301559 frappe.db.sql(
1560 """delete from `tab{0} Advance`
1561 where name = %s""".format(
1562 self.doctype
1563 ),
1564 adv.name,
1565 )
Nabin Hait297d74a2016-11-23 15:58:51 +05301566 consider_for_total_advance = False
1567
1568 if consider_for_total_advance:
1569 total_allocated_amount += flt(adv.allocated_amount, adv.precision("allocated_amount"))
1570
Ankush Menat494bd9e2022-03-28 18:52:46 +05301571 frappe.db.set_value(
1572 self.doctype, self.name, "total_advance", total_allocated_amount, update_modified=False
1573 )
Rohit Waghchaure6087fe12016-04-09 14:31:09 +05301574
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301575 def group_similar_items(self):
1576 group_item_qty = {}
1577 group_item_amount = {}
Shreya Shah785f1aa2018-10-11 10:14:25 +05301578 # to update serial number in print
1579 count = 0
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301580
1581 for item in self.items:
1582 group_item_qty[item.item_code] = group_item_qty.get(item.item_code, 0) + item.qty
1583 group_item_amount[item.item_code] = group_item_amount.get(item.item_code, 0) + item.amount
1584
1585 duplicate_list = []
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301586 for item in self.items:
1587 if item.item_code in group_item_qty:
Shreya Shah785f1aa2018-10-11 10:14:25 +05301588 count += 1
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301589 item.qty = group_item_qty[item.item_code]
1590 item.amount = group_item_amount[item.item_code]
deepeshgarg007e8d21cd2019-06-24 17:46:44 +05301591
1592 if item.qty:
1593 item.rate = flt(flt(item.amount) / flt(item.qty), item.precision("rate"))
1594 else:
1595 item.rate = 0
1596
Shreya Shah785f1aa2018-10-11 10:14:25 +05301597 item.idx = count
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301598 del group_item_qty[item.item_code]
1599 else:
1600 duplicate_list.append(item)
KanchanChauhan49a50fe2016-11-18 13:57:53 +05301601 for item in duplicate_list:
1602 self.remove(item)
1603
tunde32aa7c12017-09-07 06:52:15 +01001604 def set_payment_schedule(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301605 if self.doctype == "Sales Invoice" and self.is_pos:
1606 self.payment_terms_template = ""
Manas Solankia7f55892018-04-02 10:32:00 +05301607 return
rohitwaghchauredb9fa782018-03-01 10:32:29 +05301608
Ankush Menat494bd9e2022-03-28 18:52:46 +05301609 party_account_currency = self.get("party_account_currency")
Deepesh Garg26210162020-08-11 16:06:13 +05301610 if not party_account_currency:
1611 party_type, party = self.get_party()
1612
1613 if party_type and party:
1614 party_account_currency = get_party_account_currency(party_type, party, self.company)
1615
rohitwaghchaureda941af2018-01-17 16:23:04 +05301616 posting_date = self.get("bill_date") or self.get("posting_date") or self.get("transaction_date")
tundedf3a1752017-09-11 11:02:57 +01001617 date = self.get("due_date")
1618 due_date = date or posting_date
Deepesh Garg26210162020-08-11 16:06:13 +05301619
Saqib Ansarid552fe62021-04-23 14:46:52 +05301620 base_grand_total = self.get("base_rounded_total") or self.base_grand_total
1621 grand_total = self.get("rounded_total") or self.grand_total
Deepesh Garg5c758942023-04-16 17:11:24 +05301622 automatically_fetch_payment_terms = 0
Deepesh Garg26210162020-08-11 16:06:13 +05301623
Nabin Hait2f9f4f92017-12-20 12:24:59 +05301624 if self.doctype in ("Sales Invoice", "Purchase Invoice"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301625 base_grand_total = base_grand_total - flt(self.base_write_off_amount)
Nabin Hait2f9f4f92017-12-20 12:24:59 +05301626 grand_total = grand_total - flt(self.write_off_amount)
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301627 po_or_so, doctype, fieldname = self.get_order_details()
Ankush Menat494bd9e2022-03-28 18:52:46 +05301628 automatically_fetch_payment_terms = cint(
1629 frappe.db.get_single_value("Accounts Settings", "automatically_fetch_payment_terms")
1630 )
tunde96b8f222017-09-08 15:35:59 +01001631
Rohit Waghchaure4a267b92019-05-09 19:50:00 +05301632 if self.get("total_advance"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301633 if party_account_currency == self.company_currency:
1634 base_grand_total -= self.get("total_advance")
Ankush Menat494bd9e2022-03-28 18:52:46 +05301635 grand_total = flt(
1636 base_grand_total / self.get("conversion_rate"), self.precision("grand_total")
1637 )
Saqib Ansarid552fe62021-04-23 14:46:52 +05301638 else:
1639 grand_total -= self.get("total_advance")
Ankush Menat494bd9e2022-03-28 18:52:46 +05301640 base_grand_total = flt(
1641 grand_total * self.get("conversion_rate"), self.precision("base_grand_total")
1642 )
Rohit Waghchaure4a267b92019-05-09 19:50:00 +05301643
Nabin Hait0551f7b2017-11-21 19:58:16 +05301644 if not self.get("payment_schedule"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301645 if (
1646 self.doctype in ["Sales Invoice", "Purchase Invoice"]
1647 and automatically_fetch_payment_terms
1648 and self.linked_order_has_payment_terms(po_or_so, fieldname, doctype)
1649 ):
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301650 self.fetch_payment_terms_from_order(po_or_so, doctype)
Ankush Menat494bd9e2022-03-28 18:52:46 +05301651 if self.get("payment_terms_template"):
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301652 self.ignore_default_payment_terms_template = 1
1653 elif self.get("payment_terms_template"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301654 data = get_payment_terms(
1655 self.payment_terms_template, posting_date, grand_total, base_grand_total
1656 )
Nabin Hait0551f7b2017-11-21 19:58:16 +05301657 for item in data:
1658 self.append("payment_schedule", item)
GangaManoj4323f4b2021-07-22 05:57:42 +05301659 elif self.doctype not in ["Purchase Receipt"]:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301660 data = dict(
1661 due_date=due_date,
1662 invoice_portion=100,
1663 payment_amount=grand_total,
1664 base_payment_amount=base_grand_total,
1665 )
Nabin Hait0551f7b2017-11-21 19:58:16 +05301666 self.append("payment_schedule", data)
Deepesh Gargbcf56e62021-08-06 23:53:16 +05301667
Deepesh Gargf7b50f22023-04-25 19:18:45 +05301668 if not (
1669 automatically_fetch_payment_terms
1670 and self.linked_order_has_payment_terms(po_or_so, fieldname, doctype)
1671 ):
Deepesh Garg5c758942023-04-16 17:11:24 +05301672 for d in self.get("payment_schedule"):
1673 if d.invoice_portion:
1674 d.payment_amount = flt(
1675 grand_total * flt(d.invoice_portion / 100), d.precision("payment_amount")
1676 )
1677 d.base_payment_amount = flt(
1678 base_grand_total * flt(d.invoice_portion / 100), d.precision("base_payment_amount")
1679 )
1680 d.outstanding = d.payment_amount
1681 elif not d.invoice_portion:
1682 d.base_payment_amount = flt(
1683 d.payment_amount * self.get("conversion_rate"), d.precision("base_payment_amount")
1684 )
ruthra kumar0da6c162023-05-16 18:57:42 +05301685 else:
1686 self.fetch_payment_terms_from_order(po_or_so, doctype)
1687 self.ignore_default_payment_terms_template = 1
tunde43870aa2017-08-18 11:59:30 +01001688
GangaManoj4323f4b2021-07-22 05:57:42 +05301689 def get_order_details(self):
1690 if self.doctype == "Sales Invoice":
Ankush Menat494bd9e2022-03-28 18:52:46 +05301691 po_or_so = self.get("items")[0].get("sales_order")
GangaManoj4323f4b2021-07-22 05:57:42 +05301692 po_or_so_doctype = "Sales Order"
1693 po_or_so_doctype_name = "sales_order"
1694
tunde43870aa2017-08-18 11:59:30 +01001695 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301696 po_or_so = self.get("items")[0].get("purchase_order")
GangaManoj4323f4b2021-07-22 05:57:42 +05301697 po_or_so_doctype = "Purchase Order"
1698 po_or_so_doctype_name = "purchase_order"
Ankush Menat4551d7d2021-08-19 13:41:10 +05301699
GangaManoj4323f4b2021-07-22 05:57:42 +05301700 return po_or_so, po_or_so_doctype, po_or_so_doctype_name
1701
GangaManojc7c90242021-07-29 19:18:35 +05301702 def linked_order_has_payment_terms(self, po_or_so, fieldname, doctype):
GangaManoj4323f4b2021-07-22 05:57:42 +05301703 if po_or_so and self.all_items_have_same_po_or_so(po_or_so, fieldname):
GangaManojc7c90242021-07-29 19:18:35 +05301704 if self.linked_order_has_payment_terms_template(po_or_so, doctype):
GangaManoj4323f4b2021-07-22 05:57:42 +05301705 return True
1706 elif self.linked_order_has_payment_schedule(po_or_so):
1707 return True
Ankush Menat4551d7d2021-08-19 13:41:10 +05301708
GangaManoj4323f4b2021-07-22 05:57:42 +05301709 return False
1710
1711 def all_items_have_same_po_or_so(self, po_or_so, fieldname):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301712 for item in self.get("items"):
GangaManoj4323f4b2021-07-22 05:57:42 +05301713 if item.get(fieldname) != po_or_so:
1714 return False
Ankush Menat4551d7d2021-08-19 13:41:10 +05301715
GangaManoj4323f4b2021-07-22 05:57:42 +05301716 return True
1717
GangaManojc7c90242021-07-29 19:18:35 +05301718 def linked_order_has_payment_terms_template(self, po_or_so, doctype):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301719 return frappe.get_value(doctype, po_or_so, "payment_terms_template")
GangaManoj4323f4b2021-07-22 05:57:42 +05301720
1721 def linked_order_has_payment_schedule(self, po_or_so):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301722 return frappe.get_all("Payment Schedule", filters={"parent": po_or_so})
GangaManoj4323f4b2021-07-22 05:57:42 +05301723
1724 def fetch_payment_terms_from_order(self, po_or_so, po_or_so_doctype):
1725 """
Ankush Menat494bd9e2022-03-28 18:52:46 +05301726 Fetch Payment Terms from Purchase/Sales Order on creating a new Purchase/Sales Invoice.
GangaManoj4323f4b2021-07-22 05:57:42 +05301727 """
1728 po_or_so = frappe.get_cached_doc(po_or_so_doctype, po_or_so)
1729
1730 self.payment_schedule = []
1731 self.payment_terms_template = po_or_so.payment_terms_template
1732
1733 for schedule in po_or_so.payment_schedule:
1734 payment_schedule = {
Ankush Menat494bd9e2022-03-28 18:52:46 +05301735 "payment_term": schedule.payment_term,
1736 "due_date": schedule.due_date,
1737 "invoice_portion": schedule.invoice_portion,
1738 "mode_of_payment": schedule.mode_of_payment,
1739 "description": schedule.description,
Deepesh Garg5c758942023-04-16 17:11:24 +05301740 "payment_amount": schedule.payment_amount,
1741 "base_payment_amount": schedule.base_payment_amount,
1742 "outstanding": schedule.outstanding,
1743 "paid_amount": schedule.paid_amount,
GangaManoj4323f4b2021-07-22 05:57:42 +05301744 }
GangaManoj5b33e752021-08-05 21:50:09 +05301745
Ankush Menat494bd9e2022-03-28 18:52:46 +05301746 if schedule.discount_type == "Percentage":
1747 payment_schedule["discount_type"] = schedule.discount_type
1748 payment_schedule["discount"] = schedule.discount
GangaManoj5b33e752021-08-05 21:50:09 +05301749
ruthra kumar9bd56b02022-02-01 14:14:04 +05301750 if not schedule.invoice_portion:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301751 payment_schedule["payment_amount"] = schedule.payment_amount
ruthra kumar9bd56b02022-02-01 14:14:04 +05301752
GangaManoj4323f4b2021-07-22 05:57:42 +05301753 self.append("payment_schedule", payment_schedule)
tunde43870aa2017-08-18 11:59:30 +01001754
tundebe1b8712017-08-19 08:21:44 +01001755 def set_due_date(self):
Nabin Hait0551f7b2017-11-21 19:58:16 +05301756 due_dates = [d.due_date for d in self.get("payment_schedule") if d.due_date]
1757 if due_dates:
1758 self.due_date = max(due_dates)
tunde62af5c52017-09-22 15:16:38 +01001759
1760 def validate_payment_schedule_dates(self):
tunde77ecacc2017-09-22 23:12:55 +01001761 dates = []
tunde9bed2de2017-09-25 10:19:35 +01001762 li = []
tunde43870aa2017-08-18 11:59:30 +01001763
Ankush Menat494bd9e2022-03-28 18:52:46 +05301764 if self.doctype == "Sales Invoice" and self.is_pos:
1765 return
rohitwaghchauredb9fa782018-03-01 10:32:29 +05301766
tunde43870aa2017-08-18 11:59:30 +01001767 for d in self.get("payment_schedule"):
Nabin Hait2f9f4f92017-12-20 12:24:59 +05301768 if self.doctype == "Sales Order" and getdate(d.due_date) < getdate(self.transaction_date):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301769 frappe.throw(
1770 _("Row {0}: Due Date in the Payment Terms table cannot be before Posting Date").format(d.idx)
1771 )
tunde77ecacc2017-09-22 23:12:55 +01001772 elif d.due_date in dates:
mnatalia5f0e8d62018-05-22 06:38:50 +03001773 li.append(_("{0} in row {1}").format(d.due_date, d.idx))
tunde9bed2de2017-09-25 10:19:35 +01001774 dates.append(d.due_date)
1775
1776 if li:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301777 duplicates = "<br>" + "<br>".join(li)
1778 frappe.throw(
1779 _("Rows with duplicate due dates in other rows were found: {0}").format(duplicates)
1780 )
tunde43870aa2017-08-18 11:59:30 +01001781
tunde62af5c52017-09-22 15:16:38 +01001782 def validate_payment_schedule_amount(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301783 if self.doctype == "Sales Invoice" and self.is_pos:
1784 return
rohitwaghchauredb9fa782018-03-01 10:32:29 +05301785
Ankush Menat494bd9e2022-03-28 18:52:46 +05301786 party_account_currency = self.get("party_account_currency")
Deepesh Garg26210162020-08-11 16:06:13 +05301787 if not party_account_currency:
1788 party_type, party = self.get_party()
1789
1790 if party_type and party:
1791 party_account_currency = get_party_account_currency(party_type, party, self.company)
1792
Nabin Hait0551f7b2017-11-21 19:58:16 +05301793 if self.get("payment_schedule"):
1794 total = 0
Saqib Ansarid552fe62021-04-23 14:46:52 +05301795 base_total = 0
Nabin Hait0551f7b2017-11-21 19:58:16 +05301796 for d in self.get("payment_schedule"):
Deepesh Garg9c170522021-10-25 20:06:24 +05301797 total += flt(d.payment_amount, d.precision("payment_amount"))
1798 base_total += flt(d.base_payment_amount, d.precision("base_payment_amount"))
tunde43870aa2017-08-18 11:59:30 +01001799
Saqib Ansarid552fe62021-04-23 14:46:52 +05301800 base_grand_total = self.get("base_rounded_total") or self.base_grand_total
1801 grand_total = self.get("rounded_total") or self.grand_total
Rohit Waghchaure4a267b92019-05-09 19:50:00 +05301802
Nabin Haite591c852017-12-21 11:46:30 +05301803 if self.doctype in ("Sales Invoice", "Purchase Invoice"):
Saqib Ansarid552fe62021-04-23 14:46:52 +05301804 base_grand_total = base_grand_total - flt(self.base_write_off_amount)
Nabin Haite591c852017-12-21 11:46:30 +05301805 grand_total = grand_total - flt(self.write_off_amount)
Saqib Ansarid552fe62021-04-23 14:46:52 +05301806
1807 if self.get("total_advance"):
1808 if party_account_currency == self.company_currency:
1809 base_grand_total -= self.get("total_advance")
Ankush Menat494bd9e2022-03-28 18:52:46 +05301810 grand_total = flt(
1811 base_grand_total / self.get("conversion_rate"), self.precision("grand_total")
1812 )
Saqib Ansarid552fe62021-04-23 14:46:52 +05301813 else:
1814 grand_total -= self.get("total_advance")
Ankush Menat494bd9e2022-03-28 18:52:46 +05301815 base_grand_total = flt(
1816 grand_total * self.get("conversion_rate"), self.precision("base_grand_total")
1817 )
Deepesh Garg9c170522021-10-25 20:06:24 +05301818
Ankush Menat494bd9e2022-03-28 18:52:46 +05301819 if (
1820 flt(total, self.precision("grand_total")) - flt(grand_total, self.precision("grand_total"))
1821 > 0.1
1822 or flt(base_total, self.precision("base_grand_total"))
1823 - flt(base_grand_total, self.precision("base_grand_total"))
1824 > 0.1
1825 ):
1826 frappe.throw(
1827 _("Total Payment Amount in Payment Schedule must be equal to Grand / Rounded Total")
1828 )
tunde43870aa2017-08-18 11:59:30 +01001829
Nabin Hait877e1bb2017-11-17 12:27:43 +05301830 def is_rounded_total_disabled(self):
1831 if self.meta.get_field("disable_rounded_total"):
1832 return self.disable_rounded_total
1833 else:
1834 return frappe.db.get_single_value("Global Defaults", "disable_rounded_total")
1835
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301836 def set_inter_company_account(self):
1837 """
Ankush Menat494bd9e2022-03-28 18:52:46 +05301838 Set intercompany account for inter warehouse transactions
1839 This account will be used in case billing company and internal customer's
1840 representation company is same
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301841 """
1842
1843 if self.is_internal_transfer() and not self.unrealized_profit_loss_account:
Daizy Modi4efc9472022-11-07 09:21:03 +05301844 unrealized_profit_loss_account = frappe.get_cached_value(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301845 "Company", self.company, "unrealized_profit_loss_account"
1846 )
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301847
1848 if not unrealized_profit_loss_account:
Ankush Menat494bd9e2022-03-28 18:52:46 +05301849 msg = _(
1850 "Please select Unrealized Profit / Loss account or add default Unrealized Profit / Loss account account for company {0}"
1851 ).format(frappe.bold(self.company))
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301852 frappe.throw(msg)
1853
1854 self.unrealized_profit_loss_account = unrealized_profit_loss_account
1855
1856 def is_internal_transfer(self):
1857 """
Ankush Menat494bd9e2022-03-28 18:52:46 +05301858 It will an internal transfer if its an internal customer and representation
1859 company is same as billing company
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301860 """
Ankush Menat494bd9e2022-03-28 18:52:46 +05301861 if self.doctype in ("Sales Invoice", "Delivery Note", "Sales Order"):
1862 internal_party_field = "is_internal_customer"
1863 elif self.doctype in ("Purchase Invoice", "Purchase Receipt", "Purchase Order"):
1864 internal_party_field = "is_internal_supplier"
Ankush Menat3714e362022-05-16 18:09:14 +05301865 else:
1866 return False
Deepesh Gargf17ea2c2020-12-11 21:30:39 +05301867
1868 if self.get(internal_party_field) and (self.represents_company == self.company):
1869 return True
1870
1871 return False
1872
Saqib Ansari977b09b2021-08-19 17:57:30 +05301873 def process_common_party_accounting(self):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301874 is_invoice = self.doctype in ["Sales Invoice", "Purchase Invoice"]
Saqib Ansari977b09b2021-08-19 17:57:30 +05301875 if not is_invoice:
1876 return
1877
Ankush Menat494bd9e2022-03-28 18:52:46 +05301878 if frappe.db.get_single_value("Accounts Settings", "enable_common_party_accounting"):
Saqib Ansari977b09b2021-08-19 17:57:30 +05301879 party_link = self.get_common_party_link()
1880 if party_link and self.outstanding_amount:
1881 self.create_advance_and_reconcile(party_link)
1882
1883 def get_common_party_link(self):
1884 party_type, party = self.get_party()
Saqib Ansari72543682021-08-25 20:15:23 +05301885 return frappe.db.get_value(
Ankush Menat494bd9e2022-03-28 18:52:46 +05301886 doctype="Party Link",
1887 filters={"secondary_role": party_type, "secondary_party": party},
1888 fieldname=["primary_role", "primary_party"],
1889 as_dict=True,
Saqib Ansari72543682021-08-25 20:15:23 +05301890 )
Saqib Ansari977b09b2021-08-19 17:57:30 +05301891
1892 def create_advance_and_reconcile(self, party_link):
1893 secondary_party_type, secondary_party = self.get_party()
1894 primary_party_type, primary_party = party_link.primary_role, party_link.primary_party
1895
1896 primary_account = get_party_account(primary_party_type, primary_party, self.company)
1897 secondary_account = get_party_account(secondary_party_type, secondary_party, self.company)
1898
Ankush Menat494bd9e2022-03-28 18:52:46 +05301899 jv = frappe.new_doc("Journal Entry")
1900 jv.voucher_type = "Journal Entry"
Saqib Ansari977b09b2021-08-19 17:57:30 +05301901 jv.posting_date = self.posting_date
1902 jv.company = self.company
Ankush Menat494bd9e2022-03-28 18:52:46 +05301903 jv.remark = "Adjustment for {} {}".format(self.doctype, self.name)
Saqib Ansari977b09b2021-08-19 17:57:30 +05301904
1905 reconcilation_entry = frappe._dict()
1906 advance_entry = frappe._dict()
Saqib Ansari977b09b2021-08-19 17:57:30 +05301907
1908 reconcilation_entry.account = secondary_account
1909 reconcilation_entry.party_type = secondary_party_type
1910 reconcilation_entry.party = secondary_party
1911 reconcilation_entry.reference_type = self.doctype
1912 reconcilation_entry.reference_name = self.name
Deepesh Gargf88431a2023-04-25 20:54:22 +05301913 reconcilation_entry.cost_center = self.cost_center or erpnext.get_default_cost_center(
1914 self.company
1915 )
Saqib Ansari977b09b2021-08-19 17:57:30 +05301916
1917 advance_entry.account = primary_account
1918 advance_entry.party_type = primary_party_type
1919 advance_entry.party = primary_party
Deepesh Gargf88431a2023-04-25 20:54:22 +05301920 advance_entry.cost_center = self.cost_center or erpnext.get_default_cost_center(self.company)
Ankush Menat494bd9e2022-03-28 18:52:46 +05301921 advance_entry.is_advance = "Yes"
Saqib Ansari977b09b2021-08-19 17:57:30 +05301922
Ankush Menat494bd9e2022-03-28 18:52:46 +05301923 if self.doctype == "Sales Invoice":
Saqib Ansari977b09b2021-08-19 17:57:30 +05301924 reconcilation_entry.credit_in_account_currency = self.outstanding_amount
1925 advance_entry.debit_in_account_currency = self.outstanding_amount
1926 else:
1927 advance_entry.credit_in_account_currency = self.outstanding_amount
1928 reconcilation_entry.debit_in_account_currency = self.outstanding_amount
1929
Ankush Menat494bd9e2022-03-28 18:52:46 +05301930 jv.append("accounts", reconcilation_entry)
1931 jv.append("accounts", advance_entry)
Saqib Ansari977b09b2021-08-19 17:57:30 +05301932
1933 jv.save()
1934 jv.submit()
1935
Deepesh Gargd05d1532022-06-14 12:50:49 +05301936 def check_conversion_rate(self):
1937 default_currency = erpnext.get_company_currency(self.company)
1938 if not default_currency:
1939 throw(_("Please enter default currency in Company Master"))
1940 if (
1941 (self.currency == default_currency and flt(self.conversion_rate) != 1.00)
1942 or not self.conversion_rate
1943 or (self.currency != default_currency and flt(self.conversion_rate) == 1.00)
1944 ):
1945 throw(_("Conversion rate cannot be 0 or 1"))
1946
Saif Ur Rehman7a5d75b2021-09-13 23:01:52 +05001947 def check_finance_books(self, item, asset):
Nabin Haitfefe9502022-09-09 14:40:36 +05301948 if (
1949 len(asset.finance_books) > 1
1950 and not item.get("finance_book")
1951 and not self.get("finance_book")
1952 and asset.finance_books[0].finance_book
1953 ):
1954 frappe.throw(
1955 _("Select finance book for the item {0} at row {1}").format(item.item_code, item.idx)
1956 )
Saif Ur Rehman7a5d75b2021-09-13 23:01:52 +05001957
Ankush Menat494bd9e2022-03-28 18:52:46 +05301958
Rushabh Mehta793ba6b2014-02-14 15:47:51 +05301959@frappe.whitelist()
Rushabh Mehtaf56d73c2013-10-10 16:35:09 +05301960def get_tax_rate(account_head):
Daizy Modi4efc9472022-11-07 09:21:03 +05301961 return frappe.get_cached_value(
1962 "Account", account_head, ["tax_rate", "account_name"], as_dict=True
1963 )
Rushabh Mehtaa33d4682015-06-01 17:15:42 +05301964
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001965
Nabin Haitffc7f3f2015-05-12 15:07:02 +05301966@frappe.whitelist()
Nabin Haita2426fc2018-01-15 17:45:46 +05301967def get_default_taxes_and_charges(master_doctype, tax_template=None, company=None):
Ankush Menat494bd9e2022-03-28 18:52:46 +05301968 if not company:
1969 return {}
rohitwaghchaure505661b2017-12-11 14:52:28 +05301970
Nabin Haita2426fc2018-01-15 17:45:46 +05301971 if tax_template and company:
Daizy Modi4efc9472022-11-07 09:21:03 +05301972 tax_template_company = frappe.get_cached_value(master_doctype, tax_template, "company")
Nabin Haita2426fc2018-01-15 17:45:46 +05301973 if tax_template_company == company:
1974 return
1975
1976 default_tax = frappe.db.get_value(master_doctype, {"is_default": 1, "company": company})
rohitwaghchaure505661b2017-12-11 14:52:28 +05301977
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301978 return {
Ankush Menat494bd9e2022-03-28 18:52:46 +05301979 "taxes_and_charges": default_tax,
1980 "taxes": get_taxes_and_charges(master_doctype, default_tax),
Rushabh Mehta98aa5812017-11-14 09:32:32 +05301981 }
Nabin Hait6b039142014-05-02 15:45:10 +05301982
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08001983
Nabin Hait6b039142014-05-02 15:45:10 +05301984@frappe.whitelist()
Nabin Haitffc7f3f2015-05-12 15:07:02 +05301985def get_taxes_and_charges(master_doctype, master_name):
Nabin Hait1fe50122015-05-16 12:14:39 +05301986 if not master_name:
1987 return
Ankush Menat77dcdff2022-06-01 22:01:07 +05301988 from frappe.model import child_table_fields, default_fields
Ankush Menat494bd9e2022-03-28 18:52:46 +05301989
Nabin Hait6b039142014-05-02 15:45:10 +05301990 tax_master = frappe.get_doc(master_doctype, master_name)
1991
1992 taxes_and_charges = []
Nabin Haitffc7f3f2015-05-12 15:07:02 +05301993 for i, tax in enumerate(tax_master.get("taxes")):
Nabin Hait6b039142014-05-02 15:45:10 +05301994 tax = tax.as_dict()
1995
Ankush Menat77dcdff2022-06-01 22:01:07 +05301996 for fieldname in default_fields + child_table_fields:
Nabin Hait6b039142014-05-02 15:45:10 +05301997 if fieldname in tax:
1998 del tax[fieldname]
1999
2000 taxes_and_charges.append(tax)
2001
2002 return taxes_and_charges
Rushabh Mehta66e08e32014-09-29 12:17:03 +05302003
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002004
Rushabh Mehta66e08e32014-09-29 12:17:03 +05302005def validate_conversion_rate(currency, conversion_rate, conversion_rate_label, company):
2006 """common validation for currency and price list currency"""
2007
Ankush Menat494bd9e2022-03-28 18:52:46 +05302008 company_currency = frappe.get_cached_value("Company", company, "default_currency")
Rushabh Mehta66e08e32014-09-29 12:17:03 +05302009
2010 if not conversion_rate:
Saqib60212ff2020-10-26 11:17:04 +05302011 throw(
Ankush Menat494bd9e2022-03-28 18:52:46 +05302012 _("{0} is mandatory. Maybe Currency Exchange record is not created for {1} to {2}.").format(
2013 conversion_rate_label, currency, company_currency
2014 )
Saqib60212ff2020-10-26 11:17:04 +05302015 )
Nabin Hait613d0812015-02-23 11:58:15 +05302016
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002017
Nabin Hait613d0812015-02-23 11:58:15 +05302018def validate_taxes_and_charges(tax):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302019 if tax.charge_type in ["Actual", "On Net Total", "On Paid Amount"] and tax.row_id:
2020 frappe.throw(
2021 _("Can refer row only if the charge type is 'On Previous Row Amount' or 'Previous Row Total'")
2022 )
2023 elif tax.charge_type in ["On Previous Row Amount", "On Previous Row Total"]:
Nabin Hait613d0812015-02-23 11:58:15 +05302024 if cint(tax.idx) == 1:
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002025 frappe.throw(
Ankush Menat494bd9e2022-03-28 18:52:46 +05302026 _(
2027 "Cannot select charge type as 'On Previous Row Amount' or 'On Previous Row Total' for first row"
2028 )
2029 )
Nabin Hait613d0812015-02-23 11:58:15 +05302030 elif not tax.row_id:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302031 frappe.throw(
2032 _("Please specify a valid Row ID for row {0} in table {1}").format(tax.idx, _(tax.doctype))
2033 )
Nabin Hait613d0812015-02-23 11:58:15 +05302034 elif tax.row_id and cint(tax.row_id) >= cint(tax.idx):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302035 frappe.throw(
2036 _("Cannot refer row number greater than or equal to current row number for this Charge type")
2037 )
Nabin Hait613d0812015-02-23 11:58:15 +05302038
Rushabh Mehta2a21bc92015-02-25 15:08:42 +05302039 if tax.charge_type == "Actual":
Nabin Haitbc6c3602015-02-27 23:40:56 +05302040 tax.rate = None
Rushabh Mehta2a21bc92015-02-25 15:08:42 +05302041
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002042
Ankush Menat494bd9e2022-03-28 18:52:46 +05302043def validate_account_head(idx, account, company, context=""):
2044 account_company = frappe.get_cached_value("Account", account, "company")
Anuja Pawar0e337be2021-08-10 17:26:35 +05302045
Deepesh Garg5a2b5712022-02-18 20:05:49 +05302046 if account_company != company:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302047 frappe.throw(
2048 _("Row {0}: {3} Account {1} does not belong to Company {2}").format(
2049 idx, frappe.bold(account), frappe.bold(company), context
2050 ),
2051 title=_("Invalid Account"),
2052 )
Anuja Pawar0e337be2021-08-10 17:26:35 +05302053
2054
2055def validate_cost_center(tax, doc):
2056 if not tax.cost_center:
2057 return
2058
Ankush Menat494bd9e2022-03-28 18:52:46 +05302059 company = frappe.get_cached_value("Cost Center", tax.cost_center, "company")
Anuja Pawar0e337be2021-08-10 17:26:35 +05302060
2061 if company != doc.company:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302062 frappe.throw(
2063 _("Row {0}: Cost Center {1} does not belong to Company {2}").format(
2064 tax.idx, frappe.bold(tax.cost_center), frappe.bold(doc.company)
2065 ),
2066 title=_("Invalid Cost Center"),
2067 )
Anuja Pawar0e337be2021-08-10 17:26:35 +05302068
2069
Nabin Hait613d0812015-02-23 11:58:15 +05302070def validate_inclusive_tax(tax, doc):
2071 def _on_previous_row_error(row_range):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302072 throw(
2073 _("To include tax in row {0} in Item rate, taxes in rows {1} must also be included").format(
2074 tax.idx, row_range
2075 )
2076 )
Nabin Hait613d0812015-02-23 11:58:15 +05302077
2078 if cint(getattr(tax, "included_in_print_rate", None)):
2079 if tax.charge_type == "Actual":
2080 # inclusive tax cannot be of type Actual
Ankush Menat494bd9e2022-03-28 18:52:46 +05302081 throw(
2082 _("Charge of type 'Actual' in row {0} cannot be included in Item Rate or Paid Amount").format(
2083 tax.idx
2084 )
2085 )
2086 elif tax.charge_type == "On Previous Row Amount" and not cint(
2087 doc.get("taxes")[cint(tax.row_id) - 1].included_in_print_rate
2088 ):
Nabin Hait613d0812015-02-23 11:58:15 +05302089 # referred row should also be inclusive
2090 _on_previous_row_error(tax.row_id)
Ankush Menat494bd9e2022-03-28 18:52:46 +05302091 elif tax.charge_type == "On Previous Row Total" and not all(
2092 [cint(t.included_in_print_rate) for t in doc.get("taxes")[: cint(tax.row_id) - 1]]
2093 ):
Deepesh Garg5ef9a622021-06-14 14:34:44 +05302094 # all rows about the referred tax should be inclusive
Nabin Hait613d0812015-02-23 11:58:15 +05302095 _on_previous_row_error("1 - %d" % (tax.row_id,))
Nabin Hait93b3a372015-02-24 17:08:34 +05302096 elif tax.get("category") == "Valuation":
Nabin Hait19ea7212020-08-11 20:34:57 +05302097 frappe.throw(_("Valuation type charges can not be marked as Inclusive"))
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05302098
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05302099
Ankush Menat494bd9e2022-03-28 18:52:46 +05302100def set_balance_in_account_currency(
2101 gl_dict, account_currency=None, conversion_rate=None, company_currency=None
2102):
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002103 if (not conversion_rate) and (account_currency != company_currency):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302104 frappe.throw(
2105 _("Account: {0} with currency: {1} can not be selected").format(
2106 gl_dict.account, account_currency
2107 )
2108 )
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002109
Ankush Menat494bd9e2022-03-28 18:52:46 +05302110 gl_dict["account_currency"] = (
2111 company_currency if account_currency == company_currency else account_currency
2112 )
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05302113
2114 # set debit/credit in account currency if not provided
2115 if flt(gl_dict.debit) and not flt(gl_dict.debit_in_account_currency):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302116 gl_dict.debit_in_account_currency = (
2117 gl_dict.debit
2118 if account_currency == company_currency
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05302119 else flt(gl_dict.debit / conversion_rate, 2)
Ankush Menat494bd9e2022-03-28 18:52:46 +05302120 )
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05302121
2122 if flt(gl_dict.credit) and not flt(gl_dict.credit_in_account_currency):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302123 gl_dict.credit_in_account_currency = (
2124 gl_dict.credit
2125 if account_currency == company_currency
Revant Nandgaonkar5da941b2016-02-18 16:02:05 +05302126 else flt(gl_dict.credit / conversion_rate, 2)
Ankush Menat494bd9e2022-03-28 18:52:46 +05302127 )
Nabin Hait1991c7b2016-06-27 20:09:05 +05302128
2129
Ankush Menat494bd9e2022-03-28 18:52:46 +05302130def get_advance_journal_entries(
2131 party_type,
2132 party,
2133 party_account,
2134 amount_field,
2135 order_doctype,
2136 order_list,
2137 include_unallocated=True,
2138):
2139 dr_or_cr = (
2140 "credit_in_account_currency" if party_type == "Customer" else "debit_in_account_currency"
2141 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302142
Nabin Hait1991c7b2016-06-27 20:09:05 +05302143 conditions = []
2144 if include_unallocated:
2145 conditions.append("ifnull(t2.reference_name, '')=''")
2146
2147 if order_list:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302148 order_condition = ", ".join(["%s"] * len(order_list))
2149 conditions.append(
2150 " (t2.reference_type = '{0}' and ifnull(t2.reference_name, '') in ({1}))".format(
2151 order_doctype, order_condition
2152 )
2153 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302154
Nabin Hait1991c7b2016-06-27 20:09:05 +05302155 reference_condition = " and (" + " or ".join(conditions) + ")" if conditions else ""
Rushabh Mehta66958302017-01-16 16:57:53 +05302156
Deepesh Gargc38be532022-04-14 13:26:47 +05302157 # nosemgrep
Ankush Menat494bd9e2022-03-28 18:52:46 +05302158 journal_entries = frappe.db.sql(
2159 """
Nabin Hait1991c7b2016-06-27 20:09:05 +05302160 select
Conor74a782d2022-06-17 06:31:27 -05002161 'Journal Entry' as reference_type, t1.name as reference_name,
Nabin Hait1991c7b2016-06-27 20:09:05 +05302162 t1.remark as remarks, t2.{0} as amount, t2.name as reference_row,
Deepesh Garg31883b62022-04-13 20:52:25 +05302163 t2.reference_name as against_order, t2.exchange_rate
Nabin Hait1991c7b2016-06-27 20:09:05 +05302164 from
2165 `tabJournal Entry` t1, `tabJournal Entry Account` t2
2166 where
2167 t1.name = t2.parent and t2.account = %s
2168 and t2.party_type = %s and t2.party = %s
2169 and t2.is_advance = 'Yes' and t1.docstatus = 1
Nabin Haitca627fb2016-09-05 16:16:53 +05302170 and {1} > 0 {2}
Ankush Menat494bd9e2022-03-28 18:52:46 +05302171 order by t1.posting_date""".format(
2172 amount_field, dr_or_cr, reference_condition
2173 ),
2174 [party_account, party_type, party] + order_list,
2175 as_dict=1,
2176 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302177
Nabin Hait1991c7b2016-06-27 20:09:05 +05302178 return list(journal_entries)
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302179
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002180
Ankush Menat494bd9e2022-03-28 18:52:46 +05302181def get_advance_payment_entries(
2182 party_type,
2183 party,
2184 party_account,
2185 order_doctype,
2186 order_list=None,
2187 include_unallocated=True,
2188 against_all_orders=False,
2189 limit=None,
2190 condition=None,
2191):
Nabin Hait1991c7b2016-06-27 20:09:05 +05302192 party_account_field = "paid_from" if party_type == "Customer" else "paid_to"
Ankush Menat494bd9e2022-03-28 18:52:46 +05302193 currency_field = (
2194 "paid_from_account_currency" if party_type == "Customer" else "paid_to_account_currency"
2195 )
Nabin Hait1991c7b2016-06-27 20:09:05 +05302196 payment_type = "Receive" if party_type == "Customer" else "Pay"
Ankush Menat494bd9e2022-03-28 18:52:46 +05302197 exchange_rate_field = (
2198 "source_exchange_rate" if payment_type == "Receive" else "target_exchange_rate"
2199 )
Saqiba20999c2021-07-12 14:33:23 +05302200
Nabin Hait1991c7b2016-06-27 20:09:05 +05302201 payment_entries_against_order, unallocated_payment_entries = [], []
Nabin Hait34c551d2019-07-03 10:34:31 +05302202 limit_cond = "limit %s" % limit if limit else ""
Nabin Haitff2f3ef2016-07-04 11:41:14 +05302203
Nabin Hait1991c7b2016-06-27 20:09:05 +05302204 if order_list or against_all_orders:
2205 if order_list:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302206 reference_condition = " and t2.reference_name in ({0})".format(
2207 ", ".join(["%s"] * len(order_list))
2208 )
Nabin Hait1991c7b2016-06-27 20:09:05 +05302209 else:
2210 reference_condition = ""
2211 order_list = []
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302212
Ankush Menat494bd9e2022-03-28 18:52:46 +05302213 payment_entries_against_order = frappe.db.sql(
2214 """
Nabin Hait1991c7b2016-06-27 20:09:05 +05302215 select
Conor74a782d2022-06-17 06:31:27 -05002216 'Payment Entry' as reference_type, t1.name as reference_name,
Nabin Hait1991c7b2016-06-27 20:09:05 +05302217 t1.remarks, t2.allocated_amount as amount, t2.name as reference_row,
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05302218 t2.reference_name as against_order, t1.posting_date,
Saqiba20999c2021-07-12 14:33:23 +05302219 t1.{0} as currency, t1.{4} as exchange_rate
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302220 from `tabPayment Entry` t1, `tabPayment Entry Reference` t2
Nabin Hait1991c7b2016-06-27 20:09:05 +05302221 where
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05302222 t1.name = t2.parent and t1.{1} = %s and t1.payment_type = %s
Nabin Hait1991c7b2016-06-27 20:09:05 +05302223 and t1.party_type = %s and t1.party = %s and t1.docstatus = 1
Deepesh Gargc7eadfc2020-07-22 17:59:37 +05302224 and t2.reference_doctype = %s {2}
2225 order by t1.posting_date {3}
Ankush Menat494bd9e2022-03-28 18:52:46 +05302226 """.format(
2227 currency_field, party_account_field, reference_condition, limit_cond, exchange_rate_field
2228 ),
2229 [party_account, payment_type, party_type, party, order_doctype] + order_list,
2230 as_dict=1,
2231 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302232
Nabin Hait1991c7b2016-06-27 20:09:05 +05302233 if include_unallocated:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302234 unallocated_payment_entries = frappe.db.sql(
2235 """
Conor74a782d2022-06-17 06:31:27 -05002236 select 'Payment Entry' as reference_type, name as reference_name, posting_date,
Anuja Pawar3e404f12021-08-31 18:59:29 +05302237 remarks, unallocated_amount as amount, {2} as exchange_rate, {3} as currency
Nabin Hait1991c7b2016-06-27 20:09:05 +05302238 from `tabPayment Entry`
2239 where
2240 {0} = %s and party_type = %s and party = %s and payment_type = %s
Anuja Pawar3e404f12021-08-31 18:59:29 +05302241 and docstatus = 1 and unallocated_amount > 0 {condition}
Rohit Waghchauref7258162019-01-15 18:12:04 +05302242 order by posting_date {1}
Ankush Menat494bd9e2022-03-28 18:52:46 +05302243 """.format(
2244 party_account_field, limit_cond, exchange_rate_field, currency_field, condition=condition or ""
2245 ),
2246 (party_account, party_type, party, payment_type),
2247 as_dict=1,
2248 )
Rushabh Mehtaea0ff232016-07-07 14:02:26 +05302249
Rohit Waghchaure2f1db572016-11-08 12:39:33 +05302250 return list(payment_entries_against_order) + list(unallocated_payment_entries)
2251
Ankush Menat494bd9e2022-03-28 18:52:46 +05302252
Rohit Waghchaure2f1db572016-11-08 12:39:33 +05302253def update_invoice_status():
Sagar Vorac8b9a552021-09-22 12:11:35 +05302254 """Updates status as Overdue for applicable invoices. Runs daily."""
Sagar Vora8d9d0982021-10-20 19:15:35 +05302255 today = getdate()
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302256 payment_schedule = frappe.qb.DocType("Payment Schedule")
Sagar Vorac8b9a552021-09-22 12:11:35 +05302257 for doctype in ("Sales Invoice", "Purchase Invoice"):
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302258 invoice = frappe.qb.DocType(doctype)
2259
2260 consider_base_amount = invoice.party_account_currency != invoice.currency
2261 payment_amount = (
2262 frappe.qb.terms.Case()
2263 .when(consider_base_amount, payment_schedule.base_payment_amount)
2264 .else_(payment_schedule.payment_amount)
Sagar Vora8d9d0982021-10-20 19:15:35 +05302265 )
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002266
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302267 payable_amount = (
2268 frappe.qb.from_(payment_schedule)
2269 .select(Sum(payment_amount))
Ankush Menat494bd9e2022-03-28 18:52:46 +05302270 .where((payment_schedule.parent == invoice.name) & (payment_schedule.due_date < today))
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302271 )
2272
2273 total = (
2274 frappe.qb.terms.Case()
2275 .when(invoice.disable_rounded_total, invoice.grand_total)
2276 .else_(invoice.rounded_total)
2277 )
2278
2279 base_total = (
2280 frappe.qb.terms.Case()
2281 .when(invoice.disable_rounded_total, invoice.base_grand_total)
2282 .else_(invoice.base_rounded_total)
2283 )
2284
Ankush Menat494bd9e2022-03-28 18:52:46 +05302285 total_amount = frappe.qb.terms.Case().when(consider_base_amount, base_total).else_(total)
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302286
2287 is_overdue = total_amount - invoice.outstanding_amount < payable_amount
2288
2289 conditions = (
2290 (invoice.docstatus == 1)
2291 & (invoice.outstanding_amount > 0)
Ankush Menat494bd9e2022-03-28 18:52:46 +05302292 & (invoice.status.like("Unpaid%") | invoice.status.like("Partly Paid%"))
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302293 & (
Pruthvi Patel16a90d32021-12-20 13:24:19 +05302294 ((invoice.is_pos & invoice.due_date < today) | is_overdue)
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302295 if doctype == "Sales Invoice"
2296 else is_overdue
2297 )
2298 )
2299
Pruthvi Patel0799f372021-11-12 12:56:29 +05302300 status = (
2301 frappe.qb.terms.Case()
2302 .when(invoice.status.like("%Discounted"), "Overdue and Discounted")
2303 .else_("Overdue")
2304 )
2305
2306 frappe.qb.update(invoice).set("status", status).where(conditions).run()
Pruthvi Patel6c96ed42021-10-30 16:44:15 +05302307
2308
Nabin Hait92759692017-08-15 08:23:51 +05302309@frappe.whitelist()
Ankush Menat494bd9e2022-03-28 18:52:46 +05302310def get_payment_terms(
2311 terms_template, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None
2312):
Nabin Hait92759692017-08-15 08:23:51 +05302313 if not terms_template:
2314 return
2315
2316 terms_doc = frappe.get_doc("Payment Terms Template", terms_template)
2317
2318 schedule = []
tundefb144302017-08-19 15:01:40 +01002319 for d in terms_doc.get("terms"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302320 term_details = get_payment_term_details(
2321 d, posting_date, grand_total, base_grand_total, bill_date
2322 )
Nabin Hait92759692017-08-15 08:23:51 +05302323 schedule.append(term_details)
2324
2325 return schedule
2326
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002327
Nabin Hait92759692017-08-15 08:23:51 +05302328@frappe.whitelist()
Ankush Menat494bd9e2022-03-28 18:52:46 +05302329def get_payment_term_details(
2330 term, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None
2331):
Nabin Hait92759692017-08-15 08:23:51 +05302332 term_details = frappe._dict()
Ankush Menat8fe5feb2021-11-04 19:48:32 +05302333 if isinstance(term, str):
Nabin Hait92759692017-08-15 08:23:51 +05302334 term = frappe.get_doc("Payment Term", term)
2335 else:
2336 term_details.payment_term = term.payment_term
2337 term_details.description = term.description
2338 term_details.invoice_portion = term.invoice_portion
Rohit Waghchaure52bf56d2017-11-27 11:43:52 +05302339 term_details.payment_amount = flt(term.invoice_portion) * flt(grand_total) / 100
Saqib Ansarid552fe62021-04-23 14:46:52 +05302340 term_details.base_payment_amount = flt(term.invoice_portion) * flt(base_grand_total) / 100
Saqib0586b7d2021-03-31 15:03:53 +05302341 term_details.discount_type = term.discount_type
2342 term_details.discount = term.discount
Saqib0586b7d2021-03-31 15:03:53 +05302343 term_details.outstanding = term_details.payment_amount
2344 term_details.mode_of_payment = term.mode_of_payment
2345
Shreya Shah3a9eec22018-02-16 13:05:21 +05302346 if bill_date:
2347 term_details.due_date = get_due_date(term, bill_date)
Saqib0586b7d2021-03-31 15:03:53 +05302348 term_details.discount_date = get_discount_date(term, bill_date)
Shreya Shah3a9eec22018-02-16 13:05:21 +05302349 elif posting_date:
2350 term_details.due_date = get_due_date(term, posting_date)
Saqib0586b7d2021-03-31 15:03:53 +05302351 term_details.discount_date = get_discount_date(term, posting_date)
Shreya Shah3a9eec22018-02-16 13:05:21 +05302352
2353 if getdate(term_details.due_date) < getdate(posting_date):
2354 term_details.due_date = posting_date
2355
Nabin Hait92759692017-08-15 08:23:51 +05302356 return term_details
2357
Ankush Menat494bd9e2022-03-28 18:52:46 +05302358
Shreya Shah3a9eec22018-02-16 13:05:21 +05302359def get_due_date(term, posting_date=None, bill_date=None):
Nabin Hait92759692017-08-15 08:23:51 +05302360 due_date = None
Shreya Shah3a9eec22018-02-16 13:05:21 +05302361 date = bill_date or posting_date
Nabin Hait92759692017-08-15 08:23:51 +05302362 if term.due_date_based_on == "Day(s) after invoice date":
Shreya Shah3a9eec22018-02-16 13:05:21 +05302363 due_date = add_days(date, term.credit_days)
Nabin Hait92759692017-08-15 08:23:51 +05302364 elif term.due_date_based_on == "Day(s) after the end of the invoice month":
Shreya Shah3a9eec22018-02-16 13:05:21 +05302365 due_date = add_days(get_last_day(date), term.credit_days)
Nabin Hait92759692017-08-15 08:23:51 +05302366 elif term.due_date_based_on == "Month(s) after the end of the invoice month":
Deepesh Gargbfb81ef2022-11-30 20:53:41 +05302367 due_date = get_last_day(add_months(date, term.credit_months))
tunde96b8f222017-09-08 15:35:59 +01002368 return due_date
tundebabzyad08d4c2018-05-16 07:01:41 +01002369
Ankush Menat494bd9e2022-03-28 18:52:46 +05302370
Saqib0586b7d2021-03-31 15:03:53 +05302371def get_discount_date(term, posting_date=None, bill_date=None):
2372 discount_validity = None
2373 date = bill_date or posting_date
2374 if term.discount_validity_based_on == "Day(s) after invoice date":
2375 discount_validity = add_days(date, term.discount_validity)
2376 elif term.discount_validity_based_on == "Day(s) after the end of the invoice month":
2377 discount_validity = add_days(get_last_day(date), term.discount_validity)
2378 elif term.discount_validity_based_on == "Month(s) after the end of the invoice month":
Deepesh Gargbfb81ef2022-11-30 20:53:41 +05302379 discount_validity = get_last_day(add_months(date, term.discount_validity))
Saqib0586b7d2021-03-31 15:03:53 +05302380 return discount_validity
tundebabzyad08d4c2018-05-16 07:01:41 +01002381
Ankush Menat494bd9e2022-03-28 18:52:46 +05302382
tundebabzyad08d4c2018-05-16 07:01:41 +01002383def get_supplier_block_status(party_name):
2384 """
2385 Returns a dict containing the values of `on_hold`, `release_date` and `hold_type` of
2386 a `Supplier`
2387 """
Ankush Menat494bd9e2022-03-28 18:52:46 +05302388 supplier = frappe.get_doc("Supplier", party_name)
tundebabzyad08d4c2018-05-16 07:01:41 +01002389 info = {
Ankush Menat494bd9e2022-03-28 18:52:46 +05302390 "on_hold": supplier.on_hold,
2391 "release_date": supplier.release_date,
2392 "hold_type": supplier.hold_type,
tundebabzyad08d4c2018-05-16 07:01:41 +01002393 }
2394 return info
2395
Ankush Menat494bd9e2022-03-28 18:52:46 +05302396
marination698d9832020-08-19 14:59:46 +05302397def set_child_tax_template_and_map(item, child_item, parent_doc):
2398 args = {
Ankush Menat494bd9e2022-03-28 18:52:46 +05302399 "item_code": item.item_code,
2400 "posting_date": parent_doc.transaction_date,
2401 "tax_category": parent_doc.get("tax_category"),
2402 "company": parent_doc.get("company"),
2403 }
marination698d9832020-08-19 14:59:46 +05302404
2405 child_item.item_tax_template = _get_item_tax_template(args, item.taxes)
2406 if child_item.get("item_tax_template"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302407 child_item.item_tax_rate = get_item_tax_map(
2408 parent_doc.get("company"), child_item.item_tax_template, as_json=True
2409 )
2410
marination698d9832020-08-19 14:59:46 +05302411
Afshanb3bbebd2021-08-09 14:39:32 +05302412def add_taxes_from_tax_template(child_item, parent_doc, db_insert=True):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302413 add_taxes_from_item_tax_template = frappe.db.get_single_value(
2414 "Accounts Settings", "add_taxes_from_item_tax_template"
2415 )
Marica3b1be2b2020-10-22 17:04:31 +05302416
2417 if child_item.get("item_tax_rate") and add_taxes_from_item_tax_template:
2418 tax_map = json.loads(child_item.get("item_tax_rate"))
2419 for tax_type in tax_map:
2420 tax_rate = flt(tax_map[tax_type])
Ankush Menat494bd9e2022-03-28 18:52:46 +05302421 taxes = parent_doc.get("taxes") or []
Marica3b1be2b2020-10-22 17:04:31 +05302422 # add new row for tax head only if missing
2423 found = any(tax.account_head == tax_type for tax in taxes)
2424 if not found:
2425 tax_row = parent_doc.append("taxes", {})
Ankush Menat494bd9e2022-03-28 18:52:46 +05302426 tax_row.update(
2427 {
2428 "description": str(tax_type).split(" - ")[0],
2429 "charge_type": "On Net Total",
2430 "account_head": tax_type,
2431 "rate": tax_rate,
2432 }
2433 )
Marica3b1be2b2020-10-22 17:04:31 +05302434 if parent_doc.doctype == "Purchase Order":
Ankush Menat494bd9e2022-03-28 18:52:46 +05302435 tax_row.update({"category": "Total", "add_deduct_tax": "Add"})
Afshanb3bbebd2021-08-09 14:39:32 +05302436 if db_insert:
2437 tax_row.db_insert()
Marica3b1be2b2020-10-22 17:04:31 +05302438
Ankush Menat494bd9e2022-03-28 18:52:46 +05302439
2440def set_order_defaults(
2441 parent_doctype, parent_doctype_name, child_doctype, child_docname, trans_item
2442):
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002443 """
pateljannat637ddff2021-02-09 16:17:30 +05302444 Returns a Sales/Purchase Order Item child item containing the default values
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002445 """
Saqib438e0432020-04-03 10:02:56 +05302446 p_doc = frappe.get_doc(parent_doctype, parent_doctype_name)
Ankush Menat686685b2023-05-31 12:50:14 +05302447 child_item = frappe.new_doc(child_doctype, parent_doc=p_doc, parentfield=child_docname)
Ankush Menat494bd9e2022-03-28 18:52:46 +05302448 item = frappe.get_doc("Item", trans_item.get("item_code"))
marination0673f552021-03-31 01:38:22 +05302449
pateljannat637ddff2021-02-09 16:17:30 +05302450 for field in ("item_code", "item_name", "description", "item_group"):
marination0673f552021-03-31 01:38:22 +05302451 child_item.update({field: item.get(field)})
2452
pateljannat637ddff2021-02-09 16:17:30 +05302453 date_fieldname = "delivery_date" if child_doctype == "Sales Order Item" else "schedule_date"
Jannat Patelbb0d8f82021-02-11 20:59:28 +05302454 child_item.update({date_fieldname: trans_item.get(date_fieldname) or p_doc.get(date_fieldname)})
marination0673f552021-03-31 01:38:22 +05302455 child_item.stock_uom = item.stock_uom
Saqib61314242020-09-15 11:14:31 +05302456 child_item.uom = trans_item.get("uom") or item.stock_uom
Andy Zhu1062d7e2020-10-06 10:51:42 +13002457 child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True)
Ankush Menat494bd9e2022-03-28 18:52:46 +05302458 conversion_factor = flt(
2459 get_conversion_factor(item.item_code, child_item.uom).get("conversion_factor")
2460 )
2461 child_item.conversion_factor = flt(trans_item.get("conversion_factor")) or conversion_factor
marination0673f552021-03-31 01:38:22 +05302462
pateljannat637ddff2021-02-09 16:17:30 +05302463 if child_doctype == "Purchase Order Item":
marination0673f552021-03-31 01:38:22 +05302464 # Initialized value will update in parent validation
2465 child_item.base_rate = 1
2466 child_item.base_amount = 1
pateljannat637ddff2021-02-09 16:17:30 +05302467 if child_doctype == "Sales Order Item":
2468 child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True)
2469 if not child_item.warehouse:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302470 frappe.throw(
2471 _("Cannot find {} for item {}. Please set the same in Item Master or Stock Settings.").format(
2472 frappe.bold("default warehouse"), frappe.bold(item.item_code)
2473 )
2474 )
marination0673f552021-03-31 01:38:22 +05302475
marination698d9832020-08-19 14:59:46 +05302476 set_child_tax_template_and_map(item, child_item, p_doc)
Marica3b1be2b2020-10-22 17:04:31 +05302477 add_taxes_from_tax_template(child_item, p_doc)
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002478 return child_item
2479
Ankush Menat494bd9e2022-03-28 18:52:46 +05302480
marination0673f552021-03-31 01:38:22 +05302481def validate_child_on_delete(row, parent):
2482 """Check if partially transacted item (row) is being deleted."""
2483 if parent.doctype == "Sales Order":
2484 if flt(row.delivered_qty):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302485 frappe.throw(
2486 _("Row #{0}: Cannot delete item {1} which has already been delivered").format(
2487 row.idx, row.item_code
2488 )
2489 )
marination0673f552021-03-31 01:38:22 +05302490 if flt(row.work_order_qty):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302491 frappe.throw(
2492 _("Row #{0}: Cannot delete item {1} which has work order assigned to it.").format(
2493 row.idx, row.item_code
2494 )
2495 )
marination0673f552021-03-31 01:38:22 +05302496 if flt(row.ordered_qty):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302497 frappe.throw(
2498 _("Row #{0}: Cannot delete item {1} which is assigned to customer's purchase order.").format(
2499 row.idx, row.item_code
2500 )
2501 )
marination0673f552021-03-31 01:38:22 +05302502
2503 if parent.doctype == "Purchase Order" and flt(row.received_qty):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302504 frappe.throw(
2505 _("Row #{0}: Cannot delete item {1} which has already been received").format(
2506 row.idx, row.item_code
2507 )
2508 )
marination0673f552021-03-31 01:38:22 +05302509
2510 if flt(row.billed_amt):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302511 frappe.throw(
2512 _("Row #{0}: Cannot delete item {1} which has already been billed.").format(
2513 row.idx, row.item_code
2514 )
2515 )
2516
marination0673f552021-03-31 01:38:22 +05302517
2518def update_bin_on_delete(row, doctype):
2519 """Update bin for deleted item (row)."""
Chillar Anand915b3432021-09-02 16:44:59 +05302520 from erpnext.stock.stock_balance import (
2521 get_indented_qty,
2522 get_ordered_qty,
2523 get_reserved_qty,
2524 update_bin_qty,
2525 )
Ankush Menat494bd9e2022-03-28 18:52:46 +05302526
marination0673f552021-03-31 01:38:22 +05302527 qty_dict = {}
2528
2529 if doctype == "Sales Order":
2530 qty_dict["reserved_qty"] = get_reserved_qty(row.item_code, row.warehouse)
2531 else:
2532 if row.material_request_item:
2533 qty_dict["indented_qty"] = get_indented_qty(row.item_code, row.warehouse)
2534
2535 qty_dict["ordered_qty"] = get_ordered_qty(row.item_code, row.warehouse)
2536
Deepesh Garga61790c2022-02-22 20:58:10 +05302537 if row.warehouse:
2538 update_bin_qty(row.item_code, row.warehouse, qty_dict)
marination0673f552021-03-31 01:38:22 +05302539
Ankush Menat494bd9e2022-03-28 18:52:46 +05302540
Ankush Menatdd11f262022-06-27 15:55:08 +05302541def validate_and_delete_children(parent, data) -> bool:
Saqib0ad74492019-12-24 16:42:30 +05302542 deleted_children = []
2543 updated_item_names = [d.get("docname") for d in data]
2544 for item in parent.items:
2545 if item.name not in updated_item_names:
2546 deleted_children.append(item)
2547
2548 for d in deleted_children:
marination0673f552021-03-31 01:38:22 +05302549 validate_child_on_delete(d, parent)
Saqib0ad74492019-12-24 16:42:30 +05302550 d.cancel()
2551 d.delete()
marination0673f552021-03-31 01:38:22 +05302552
2553 # need to update ordered qty in Material Request first
2554 # bin uses Material Request Items to recalculate & update
2555 parent.update_prevdoc_status()
2556
2557 for d in deleted_children:
2558 update_bin_on_delete(d, parent.doctype)
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002559
Ankush Menatdd11f262022-06-27 15:55:08 +05302560 return bool(deleted_children)
2561
Rohan Bansala93b5142021-04-06 17:10:52 +05302562
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002563@frappe.whitelist()
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002564def update_child_qty_rate(parent_doctype, trans_items, parent_doctype_name, child_docname="items"):
Ankush Menat494bd9e2022-03-28 18:52:46 +05302565 def check_doc_permissions(doc, perm_type="create"):
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302566 try:
2567 doc.check_permission(perm_type)
Saqib6db92fb2020-09-14 19:54:17 +05302568 except frappe.PermissionError:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302569 actions = {"create": "add", "write": "update"}
Saqib6db92fb2020-09-14 19:54:17 +05302570
Ankush Menat494bd9e2022-03-28 18:52:46 +05302571 frappe.throw(
2572 _("You do not have permissions to {} items in a {}.").format(
2573 actions[perm_type], parent_doctype
2574 ),
2575 title=_("Insufficient Permissions"),
2576 )
marination665c27a2020-09-15 12:04:38 +05302577
Saqib6db92fb2020-09-14 19:54:17 +05302578 def validate_workflow_conditions(doc):
2579 workflow = get_workflow_name(doc.doctype)
2580 if not workflow:
2581 return
2582
2583 workflow_doc = frappe.get_doc("Workflow", workflow)
2584 current_state = doc.get(workflow_doc.workflow_state_field)
2585 roles = frappe.get_roles()
2586
2587 transitions = []
2588 for transition in workflow_doc.transitions:
2589 if transition.next_state == current_state and transition.allowed in roles:
2590 if not is_transition_condition_satisfied(transition, doc):
2591 continue
2592 transitions.append(transition.as_dict())
2593
2594 if not transitions:
Saqib18318932020-09-23 13:01:49 +05302595 frappe.throw(
Ankush Menat494bd9e2022-03-28 18:52:46 +05302596 _("You are not allowed to update as per the conditions set in {} Workflow.").format(
2597 get_link_to_form("Workflow", workflow)
2598 ),
2599 title=_("Insufficient Permissions"),
Saqib18318932020-09-23 13:01:49 +05302600 )
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302601
Rohit Waghchaure8d5380a2020-06-18 14:06:31 +05302602 def get_new_child_item(item_row):
Rohit Waghchaureff70e612021-03-06 22:08:08 +05302603 child_doctype = "Sales Order Item" if parent_doctype == "Sales Order" else "Purchase Order Item"
Ankush Menat494bd9e2022-03-28 18:52:46 +05302604 return set_order_defaults(
2605 parent_doctype, parent_doctype_name, child_doctype, child_docname, item_row
2606 )
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302607
marination0c915432022-05-10 18:04:02 +05302608 def validate_quantity(child_item, new_data):
2609 if not flt(new_data.get("qty")):
2610 frappe.throw(
2611 _("Row # {0}: Quantity for Item {1} cannot be zero").format(
2612 new_data.get("idx"), frappe.bold(new_data.get("item_code"))
2613 ),
2614 title=_("Invalid Qty"),
2615 )
2616
2617 if parent_doctype == "Sales Order" and flt(new_data.get("qty")) < flt(child_item.delivered_qty):
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302618 frappe.throw(_("Cannot set quantity less than delivered quantity"))
2619
marination0c915432022-05-10 18:04:02 +05302620 if parent_doctype == "Purchase Order" and flt(new_data.get("qty")) < flt(
2621 child_item.received_qty
2622 ):
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302623 frappe.throw(_("Cannot set quantity less than received quantity"))
2624
Ankush Menatdd11f262022-06-27 15:55:08 +05302625 def should_update_supplied_items(doc) -> bool:
2626 """Subcontracted PO can allow following changes *after submit*:
2627
2628 1. Change rate of subcontracting - regardless of other changes.
2629 2. Change qty and/or add new items and/or remove items
2630 Exception: Transfer/Consumption is already made, qty change not allowed.
2631 """
2632
2633 supplied_items_processed = any(
2634 item.supplied_qty or item.consumed_qty or item.returned_qty for item in doc.supplied_items
2635 )
2636
2637 update_supplied_items = (
2638 any_qty_changed or items_added_or_removed or any_conversion_factor_changed
2639 )
2640 if update_supplied_items and supplied_items_processed:
2641 frappe.throw(_("Item qty can not be updated as raw materials are already processed."))
2642
2643 return update_supplied_items
2644
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002645 data = json.loads(trans_items)
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002646
Ankush Menatdd11f262022-06-27 15:55:08 +05302647 any_qty_changed = False # updated to true if any item's qty changes
2648 items_added_or_removed = False # updated to true if any new item is added or removed
2649 any_conversion_factor_changed = False
2650
Ankush Menat494bd9e2022-03-28 18:52:46 +05302651 sales_doctypes = ["Sales Order", "Sales Invoice", "Delivery Note", "Quotation"]
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302652 parent = frappe.get_doc(parent_doctype, parent_doctype_name)
marination665c27a2020-09-15 12:04:38 +05302653
Ankush Menat494bd9e2022-03-28 18:52:46 +05302654 check_doc_permissions(parent, "write")
Ankush Menatdd11f262022-06-27 15:55:08 +05302655 _removed_items = validate_and_delete_children(parent, data)
2656 items_added_or_removed |= _removed_items
Saqib0ad74492019-12-24 16:42:30 +05302657
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002658 for d in data:
2659 new_child_flag = False
Ankush Menat6de7b8e2021-08-24 12:18:40 +05302660
2661 if not d.get("item_code"):
2662 # ignore empty rows
2663 continue
2664
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002665 if not d.get("docname"):
2666 new_child_flag = True
Ankush Menatdd11f262022-06-27 15:55:08 +05302667 items_added_or_removed = True
Ankush Menat494bd9e2022-03-28 18:52:46 +05302668 check_doc_permissions(parent, "create")
Rohit Waghchaure8d5380a2020-06-18 14:06:31 +05302669 child_item = get_new_child_item(d)
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002670 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302671 check_doc_permissions(parent, "write")
2672 child_item = frappe.get_doc(parent_doctype + " Item", d.get("docname"))
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302673
Saqib Ansaric579b082020-05-29 22:21:50 +05302674 prev_rate, new_rate = flt(child_item.get("rate")), flt(d.get("rate"))
2675 prev_qty, new_qty = flt(child_item.get("qty")), flt(d.get("qty"))
Ankush Menat494bd9e2022-03-28 18:52:46 +05302676 prev_con_fac, new_con_fac = flt(child_item.get("conversion_factor")), flt(
2677 d.get("conversion_factor")
2678 )
Saqib61314242020-09-15 11:14:31 +05302679 prev_uom, new_uom = child_item.get("uom"), d.get("uom")
Saqib Ansaric579b082020-05-29 22:21:50 +05302680
Ankush Menat494bd9e2022-03-28 18:52:46 +05302681 if parent_doctype == "Sales Order":
Saqib Ansaric579b082020-05-29 22:21:50 +05302682 prev_date, new_date = child_item.get("delivery_date"), d.get("delivery_date")
Ankush Menat494bd9e2022-03-28 18:52:46 +05302683 elif parent_doctype == "Purchase Order":
marinationb7e94cc2020-06-15 11:32:42 +05302684 prev_date, new_date = child_item.get("schedule_date"), d.get("schedule_date")
Saqib Ansaric579b082020-05-29 22:21:50 +05302685
2686 rate_unchanged = prev_rate == new_rate
marinationf9c4b202020-06-12 15:49:53 +05302687 qty_unchanged = prev_qty == new_qty
Saqib61314242020-09-15 11:14:31 +05302688 uom_unchanged = prev_uom == new_uom
Saqib Ansaric579b082020-05-29 22:21:50 +05302689 conversion_factor_unchanged = prev_con_fac == new_con_fac
Ankush Menatdd11f262022-06-27 15:55:08 +05302690 any_conversion_factor_changed |= not conversion_factor_unchanged
Ankush Menat494bd9e2022-03-28 18:52:46 +05302691 date_unchanged = (
2692 prev_date == getdate(new_date) if prev_date and new_date else False
2693 ) # in case of delivery note etc
2694 if (
2695 rate_unchanged
2696 and qty_unchanged
2697 and conversion_factor_unchanged
2698 and uom_unchanged
2699 and date_unchanged
2700 ):
Saqibdd374ff2020-02-27 12:51:31 +05302701 continue
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002702
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302703 validate_quantity(child_item, d)
Ankush Menatdd11f262022-06-27 15:55:08 +05302704 if flt(child_item.get("qty")) != flt(d.get("qty")):
2705 any_qty_changed = True
deepeshgarg00777cde832018-12-27 15:56:51 +05302706
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002707 child_item.qty = flt(d.get("qty"))
Saqib56fea7d2020-10-09 21:19:25 +05302708 rate_precision = child_item.precision("rate") or 2
2709 conv_fac_precision = child_item.precision("conversion_factor") or 2
2710 qty_precision = child_item.precision("qty") or 2
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002711
Ankush Menat494bd9e2022-03-28 18:52:46 +05302712 if flt(child_item.billed_amt, rate_precision) > flt(
2713 flt(d.get("rate"), rate_precision) * flt(d.get("qty"), qty_precision), rate_precision
2714 ):
2715 frappe.throw(
2716 _("Row #{0}: Cannot set Rate if amount is greater than billed amount for Item {1}.").format(
2717 child_item.idx, child_item.item_code
2718 )
2719 )
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002720 else:
Saqib56fea7d2020-10-09 21:19:25 +05302721 child_item.rate = flt(d.get("rate"), rate_precision)
marinationf9c4b202020-06-12 15:49:53 +05302722
Saqib Ansari2c3c8aa2020-05-29 21:55:38 +05302723 if d.get("conversion_factor"):
marinationf9c4b202020-06-12 15:49:53 +05302724 if child_item.stock_uom == child_item.uom:
2725 child_item.conversion_factor = 1
2726 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302727 child_item.conversion_factor = flt(d.get("conversion_factor"), conv_fac_precision)
marination665c27a2020-09-15 12:04:38 +05302728
Saqib61314242020-09-15 11:14:31 +05302729 if d.get("uom"):
2730 child_item.uom = d.get("uom")
Ankush Menat494bd9e2022-03-28 18:52:46 +05302731 conversion_factor = flt(
2732 get_conversion_factor(child_item.item_code, child_item.uom).get("conversion_factor")
2733 )
2734 child_item.conversion_factor = (
2735 flt(d.get("conversion_factor"), conv_fac_precision) or conversion_factor
2736 )
Mangesh-Khairnara3d52002019-08-05 10:16:40 +05302737
Ankush Menat494bd9e2022-03-28 18:52:46 +05302738 if d.get("delivery_date") and parent_doctype == "Sales Order":
2739 child_item.delivery_date = d.get("delivery_date")
marinationf9c4b202020-06-12 15:49:53 +05302740
Ankush Menat494bd9e2022-03-28 18:52:46 +05302741 if d.get("schedule_date") and parent_doctype == "Purchase Order":
2742 child_item.schedule_date = d.get("schedule_date")
Saqib Ansaric579b082020-05-29 22:21:50 +05302743
Mangesh-Khairnara3d52002019-08-05 10:16:40 +05302744 if flt(child_item.price_list_rate):
Maricaf0674472019-10-11 10:47:09 +05302745 if flt(child_item.rate) > flt(child_item.price_list_rate):
2746 # if rate is greater than price_list_rate, set margin
2747 # or set discount
2748 child_item.discount_percentage = 0
rohitwaghchaure81c21752019-10-31 15:56:10 +05302749
2750 if parent_doctype in sales_doctypes:
2751 child_item.margin_type = "Amount"
Ankush Menat494bd9e2022-03-28 18:52:46 +05302752 child_item.margin_rate_or_amount = flt(
2753 child_item.rate - child_item.price_list_rate, child_item.precision("margin_rate_or_amount")
2754 )
rohitwaghchaure81c21752019-10-31 15:56:10 +05302755 child_item.rate_with_margin = child_item.rate
Maricaf0674472019-10-11 10:47:09 +05302756 else:
Ankush Menat494bd9e2022-03-28 18:52:46 +05302757 child_item.discount_percentage = flt(
2758 (1 - flt(child_item.rate) / flt(child_item.price_list_rate)) * 100.0,
2759 child_item.precision("discount_percentage"),
2760 )
2761 child_item.discount_amount = flt(child_item.price_list_rate) - flt(child_item.rate)
rohitwaghchaure81c21752019-10-31 15:56:10 +05302762
2763 if parent_doctype in sales_doctypes:
2764 child_item.margin_type = ""
2765 child_item.margin_rate_or_amount = 0
2766 child_item.rate_with_margin = 0
Mangesh-Khairnara3d52002019-08-05 10:16:40 +05302767
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002768 child_item.flags.ignore_validate_update_after_submit = True
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002769 if new_child_flag:
Saqib Ansarif53299e2020-04-15 22:08:12 +05302770 parent.load_from_db()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302771 child_item.idx = len(parent.items) + 1
Stavros Anastasiadis3d82b742018-12-10 13:00:55 +01002772 child_item.insert()
2773 else:
2774 child_item.save()
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002775
Rushabh Mehtafafbb022018-12-24 22:09:15 +05302776 parent.reload()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302777 parent.flags.ignore_validate_update_after_submit = True
2778 parent.set_qty_as_per_stock_uom()
2779 parent.calculate_taxes_and_totals()
Ankush Menatdf6e2082021-02-11 11:04:39 +05302780 parent.set_total_in_words()
Nabin Hait49a46f02019-10-21 13:35:43 +05302781 if parent_doctype == "Sales Order":
Marica3dee5272020-06-23 10:33:47 +05302782 make_packing_list(parent)
Nabin Hait49a46f02019-10-21 13:35:43 +05302783 parent.set_gross_profit()
Ankush Menat494bd9e2022-03-28 18:52:46 +05302784 frappe.get_doc("Authorization Control").validate_approving_authority(
2785 parent.doctype, parent.company, parent.base_grand_total
2786 )
Doridel Cahanap6f06cc22018-05-17 16:28:58 +08002787
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302788 parent.set_payment_schedule()
Ankush Menat494bd9e2022-03-28 18:52:46 +05302789 if parent_doctype == "Purchase Order":
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302790 parent.validate_minimum_order_qty()
2791 parent.validate_budget()
2792 if parent.is_against_so():
2793 parent.update_status_updater()
Nabin Haitb2da0822018-07-13 17:01:40 +05302794 else:
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302795 parent.check_credit_limit()
Ankush Menat733c9de2022-01-04 18:39:30 +05302796
2797 # reset index of child table
2798 for idx, row in enumerate(parent.get(child_docname), start=1):
2799 row.idx = idx
2800
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302801 parent.save()
Nabin Haitb2da0822018-07-13 17:01:40 +05302802
Ankush Menat494bd9e2022-03-28 18:52:46 +05302803 if parent_doctype == "Purchase Order":
2804 update_last_purchase_rate(parent, is_submit=1)
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302805 parent.update_prevdoc_status()
2806 parent.update_requested_qty()
2807 parent.update_ordered_qty()
2808 parent.update_ordered_and_reserved_qty()
2809 parent.update_receiving_percentage()
s-aga-r6d89b2f2022-06-18 15:46:59 +05302810 if parent.is_old_subcontracting_flow:
Ankush Menatdd11f262022-06-27 15:55:08 +05302811 if should_update_supplied_items(parent):
2812 parent.update_reserved_qty_for_subcontract()
Sagar Sharma78ff1782022-06-28 22:20:32 +05302813 parent.create_raw_materials_supplied()
s-aga-r6d89b2f2022-06-18 15:46:59 +05302814 parent.save()
Ankush Menatc84e11a2022-06-01 12:55:10 +05302815 else: # Sales Order
2816 parent.validate_warehouse()
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302817 parent.update_reserved_qty()
2818 parent.update_project()
Ankush Menat494bd9e2022-03-28 18:52:46 +05302819 parent.update_prevdoc_status("submit")
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302820 parent.update_delivery_status()
Nabin Haitb2da0822018-07-13 17:01:40 +05302821
Saqib6db92fb2020-09-14 19:54:17 +05302822 parent.reload()
2823 validate_workflow_conditions(parent)
2824
Rushabh Mehtac9b1a352018-12-24 20:55:35 +05302825 parent.update_blanket_order()
2826 parent.update_billing_percentage()
2827 parent.set_status()
Gauravf1e28e02019-02-13 16:46:24 +05302828
s-aga-rac24d772023-04-05 19:48:15 +05302829 # Cancel and Recreate Stock Reservation Entries.
s-aga-r38e93672023-04-02 21:24:59 +05302830 if parent_doctype == "Sales Order":
2831 from erpnext.stock.doctype.stock_reservation_entry.stock_reservation_entry import (
2832 cancel_stock_reservation_entries,
2833 has_reserved_stock,
s-aga-r38e93672023-04-02 21:24:59 +05302834 )
2835
2836 if has_reserved_stock(parent.doctype, parent.name):
2837 cancel_stock_reservation_entries(parent.doctype, parent.name)
s-aga-rac24d772023-04-05 19:48:15 +05302838 parent.create_stock_reservation_entries()
s-aga-r38e93672023-04-02 21:24:59 +05302839
Ankush Menat494bd9e2022-03-28 18:52:46 +05302840
Gauravf1e28e02019-02-13 16:46:24 +05302841@erpnext.allow_regional
2842def validate_regional(doc):
2843 pass
Saqib Ansaric5782b02022-01-27 20:09:56 +05302844
Ankush Menat494bd9e2022-03-28 18:52:46 +05302845
Saqib Ansaric5782b02022-01-27 20:09:56 +05302846@erpnext.allow_regional
2847def validate_einvoice_fields(doc):
2848 pass