Anand Doshi | 885e074 | 2015-03-03 14:55:30 +0530 | [diff] [blame] | 1 | # Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors |
Rushabh Mehta | e67d1fb | 2013-08-05 14:59:54 +0530 | [diff] [blame] | 2 | # License: GNU General Public License v3. See license.txt |
Nabin Hait | 2df4d54 | 2013-01-29 11:34:39 +0530 | [diff] [blame] | 3 | |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 4 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 5 | import json |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 6 | |
| 7 | import frappe |
Rohit Waghchaure | 19911b4 | 2023-04-21 16:49:48 +0530 | [diff] [blame] | 8 | from frappe import _, bold, throw |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 9 | from frappe.model.workflow import get_workflow_name, is_transition_condition_satisfied |
ruthra kumar | 4487065 | 2022-11-01 10:11:38 +0530 | [diff] [blame] | 10 | from frappe.query_builder.functions import Abs, Sum |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 11 | from 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, |
GangaManoj | d24cfff | 2021-10-28 20:06:48 +0530 | [diff] [blame] | 22 | today, |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 23 | ) |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 24 | |
| 25 | import erpnext |
| 26 | from erpnext.accounts.doctype.accounting_dimension.accounting_dimension import ( |
| 27 | get_accounting_dimensions, |
| 28 | ) |
| 29 | from 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 | ) |
| 34 | from erpnext.accounts.party import ( |
| 35 | get_party_account, |
| 36 | get_party_account_currency, |
Deepesh Garg | a7f15a0 | 2021-12-12 21:09:11 +0530 | [diff] [blame] | 37 | get_party_gle_currency, |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 38 | validate_party_frozen_disabled, |
| 39 | ) |
| 40 | from erpnext.accounts.utils import get_account_currency, get_fiscal_years, validate_fiscal_year |
| 41 | from erpnext.buying.utils import update_last_purchase_rate |
| 42 | from erpnext.controllers.print_settings import ( |
| 43 | set_print_templates_for_item_table, |
| 44 | set_print_templates_for_taxes, |
| 45 | ) |
| 46 | from erpnext.controllers.sales_and_purchase_return import validate_return |
| 47 | from erpnext.exceptions import InvalidCurrency |
| 48 | from erpnext.setup.utils import get_exchange_rate |
Ankush Menat | 10583eb | 2022-06-17 12:13:27 +0530 | [diff] [blame] | 49 | from erpnext.stock.doctype.item.item import get_uom_conv_factor |
Marica | 3dee527 | 2020-06-23 10:33:47 +0530 | [diff] [blame] | 50 | from erpnext.stock.doctype.packed_item.packed_item import make_packing_list |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 51 | from 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 | ) |
| 58 | from erpnext.utilities.transaction_base import TransactionBase |
| 59 | |
Nabin Hait | 1d21842 | 2015-07-17 15:19:02 +0530 | [diff] [blame] | 60 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 61 | class AccountMissingError(frappe.ValidationError): |
| 62 | pass |
marination | 53b1a9a | 2020-11-03 15:45:25 +0530 | [diff] [blame] | 63 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 64 | |
| 65 | force_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 Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 77 | |
Nabin Hait | bf495c9 | 2013-01-30 12:49:08 +0530 | [diff] [blame] | 78 | class AccountsController(TransactionBase): |
Nabin Hait | 7eba1a3 | 2017-10-02 15:59:27 +0530 | [diff] [blame] | 79 | def __init__(self, *args, **kwargs): |
| 80 | super(AccountsController, self).__init__(*args, **kwargs) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 81 | |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 82 | def get_print_settings(self): |
| 83 | print_setting_fields = [] |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 84 | items_field = self.meta.get_field("items") |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 85 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 86 | if items_field and items_field.fieldtype == "Table": |
| 87 | print_setting_fields += ["compact_item_print", "print_uom_after_quantity"] |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 88 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 89 | 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"] |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 92 | |
| 93 | return print_setting_fields |
| 94 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 95 | @property |
| 96 | def company_currency(self): |
| 97 | if not hasattr(self, "__company_currency"): |
Rushabh Mehta | cc8b2b2 | 2017-03-31 12:44:29 +0530 | [diff] [blame] | 98 | self.__company_currency = erpnext.get_company_currency(self.company) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 99 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 100 | return self.__company_currency |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 101 | |
Rohit Waghchaure | 7d52989 | 2016-10-06 14:35:04 +0530 | [diff] [blame] | 102 | def onload(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 103 | self.set_onload( |
| 104 | "make_payment_via_journal_entry", |
| 105 | frappe.db.get_single_value("Accounts Settings", "make_payment_via_journal_entry"), |
| 106 | ) |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 107 | |
tunde | e52bb82 | 2017-09-25 09:02:23 +0100 | [diff] [blame] | 108 | if self.is_new(): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 109 | relevant_docs = ( |
| 110 | "Quotation", |
| 111 | "Purchase Order", |
| 112 | "Sales Order", |
| 113 | "Purchase Invoice", |
| 114 | "Sales Invoice", |
| 115 | ) |
tunde | e52bb82 | 2017-09-25 09:02:23 +0100 | [diff] [blame] | 116 | if self.doctype in relevant_docs: |
| 117 | self.set_payment_schedule() |
Rohit Waghchaure | 7d52989 | 2016-10-06 14:35:04 +0530 | [diff] [blame] | 118 | |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 119 | def ensure_supplier_is_not_blocked(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 120 | is_supplier_payment = self.doctype == "Payment Entry" and self.party_type == "Supplier" |
| 121 | is_buying_invoice = self.doctype in ["Purchase Invoice", "Purchase Order"] |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 122 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 127 | supplier = frappe.get_doc("Supplier", supplier_name) |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 128 | |
| 129 | if supplier and supplier_name and supplier.on_hold: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 130 | if (is_buying_invoice and supplier.hold_type in ["All", "Invoices"]) or ( |
| 131 | is_supplier_payment and supplier.hold_type in ["All", "Payments"] |
| 132 | ): |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 133 | if not supplier.release_date or getdate(nowdate()) <= supplier.release_date: |
| 134 | frappe.msgprint( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 135 | _("{0} is blocked so this transaction cannot proceed").format(supplier_name), |
| 136 | raise_exception=1, |
| 137 | ) |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 138 | |
Saurabh | 6f75318 | 2013-03-20 12:55:28 +0530 | [diff] [blame] | 139 | def validate(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 140 | if not self.get("is_return") and not self.get("is_debit_note"): |
Deepesh Garg | d301d26 | 2019-07-31 15:58:19 +0530 | [diff] [blame] | 141 | self.validate_qty_is_not_zero() |
| 142 | |
nabinhait | 23cce73 | 2014-07-03 12:25:06 +0530 | [diff] [blame] | 143 | if self.get("_action") and self._action != "update_after_submit": |
Nabin Hait | 704a453 | 2014-06-05 16:55:31 +0530 | [diff] [blame] | 144 | self.set_missing_values(for_validate=True) |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 145 | |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 146 | self.ensure_supplier_is_not_blocked() |
| 147 | |
Nabin Hait | cfecd2b | 2013-07-11 17:49:18 +0530 | [diff] [blame] | 148 | self.validate_date_with_fiscal_year() |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 149 | self.validate_party_accounts() |
| 150 | |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 151 | self.validate_inter_company_reference() |
| 152 | |
Ankush Menat | 3714e36 | 2022-05-16 18:09:14 +0530 | [diff] [blame] | 153 | self.disable_pricing_rule_on_internal_transfer() |
Deepesh Garg | 8d30ebb | 2022-11-05 20:51:15 +0530 | [diff] [blame] | 154 | self.disable_tax_included_prices_for_internal_transfer() |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 155 | self.set_incoming_rate() |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 156 | |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 157 | if self.meta.get_field("currency"): |
Anand Doshi | 923d41d | 2013-05-28 17:23:36 +0530 | [diff] [blame] | 158 | self.calculate_taxes_and_totals() |
Rohit Waghchaure | 6087fe1 | 2016-04-09 14:31:09 +0530 | [diff] [blame] | 159 | |
Nabin Hait | 1d21842 | 2015-07-17 15:19:02 +0530 | [diff] [blame] | 160 | if not self.meta.get_field("is_return") or not self.is_return: |
| 161 | self.validate_value("base_grand_total", ">=", 0) |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 162 | |
Nabin Hait | 3cf67a4 | 2015-07-24 13:26:36 +0530 | [diff] [blame] | 163 | validate_return(self) |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 164 | self.set_total_in_words() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 165 | |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 166 | self.validate_all_documents_schedule() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 167 | |
ankitjavalkarwork | 6c29d87 | 2014-10-06 13:20:53 +0530 | [diff] [blame] | 168 | if self.meta.get_field("taxes_and_charges"): |
| 169 | self.validate_enabled_taxes_and_charges() |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 170 | self.validate_tax_account_company() |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 171 | |
Neil Trini Lasrado | 3fbbb71 | 2015-07-17 12:10:12 +0530 | [diff] [blame] | 172 | self.validate_party() |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 173 | self.validate_currency() |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 174 | self.validate_party_account_currency() |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 175 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 176 | if self.doctype in ["Purchase Invoice", "Sales Invoice"]: |
| 177 | pos_check_field = "is_pos" if self.doctype == "Sales Invoice" else "is_paid" |
Nabin Hait | 4a994d4 | 2019-04-25 17:47:26 +0530 | [diff] [blame] | 178 | if cint(self.allocate_advances_automatically) and not cint(self.get(pos_check_field)): |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 179 | self.set_advances() |
| 180 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 181 | self.set_advance_gain_or_loss() |
| 182 | |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 183 | if self.is_return: |
| 184 | self.validate_qty() |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 185 | else: |
| 186 | self.validate_deferred_start_and_end_date() |
rohitwaghchaure | 7048925 | 2018-06-11 12:02:14 +0530 | [diff] [blame] | 187 | |
Deepesh Garg | 9bf5f76 | 2022-04-06 17:33:46 +0530 | [diff] [blame] | 188 | self.validate_deferred_income_expense_account() |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 189 | self.set_inter_company_account() |
| 190 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 191 | if self.doctype == "Purchase Invoice": |
Deepesh Garg | 7f06c8c | 2021-11-26 10:27:57 +0530 | [diff] [blame] | 192 | self.calculate_paid_amount() |
| 193 | # apply tax withholding only if checked and applicable |
| 194 | self.set_tax_withholding() |
| 195 | |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 196 | validate_regional(self) |
Deepesh Garg | 7c30085 | 2020-12-26 20:14:51 +0530 | [diff] [blame] | 197 | |
Saqib Ansari | c5782b0 | 2022-01-27 20:09:56 +0530 | [diff] [blame] | 198 | validate_einvoice_fields(self) |
| 199 | |
Deepesh Garg | b741ae1 | 2022-12-02 17:14:06 +0530 | [diff] [blame] | 200 | if self.doctype != "Material Request" and not self.ignore_pricing_rule: |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 201 | apply_pricing_rule_on_transaction(self) |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 202 | |
Saqib Ansari | c5782b0 | 2022-01-27 20:09:56 +0530 | [diff] [blame] | 203 | def before_cancel(self): |
| 204 | validate_einvoice_fields(self) |
| 205 | |
Saqib | 8e55677 | 2021-01-28 12:26:45 +0530 | [diff] [blame] | 206 | def on_trash(self): |
ruthra kumar | c722f28 | 2023-02-19 12:09:10 +0530 | [diff] [blame] | 207 | # 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 | |
Saqib | 8e55677 | 2021-01-28 12:26:45 +0530 | [diff] [blame] | 213 | # delete sl and gl entries on deletion of transaction |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 214 | if frappe.db.get_single_value("Accounts Settings", "delete_linked_ledger_entries"): |
ruthra kumar | 70313df | 2022-09-08 18:53:30 +0530 | [diff] [blame] | 215 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 219 | 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 Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 226 | |
Deepesh Garg | 9bf5f76 | 2022-04-06 17:33:46 +0530 | [diff] [blame] | 227 | 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 Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 236 | default_deferred_account = frappe.get_cached_value( |
Deepesh Garg | 9bf5f76 | 2022-04-06 17:33:46 +0530 | [diff] [blame] | 237 | "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 Garg | fa15221 | 2022-11-28 19:22:35 +0530 | [diff] [blame] | 248 | def validate_auto_repeat_subscription_dates(self): |
Deepesh Garg | 6a47fb6 | 2022-11-28 22:47:44 +0530 | [diff] [blame] | 249 | if ( |
| 250 | self.get("from_date") |
| 251 | and self.get("to_date") |
| 252 | and getdate(self.from_date) > getdate(self.to_date) |
| 253 | ): |
Deepesh Garg | fa15221 | 2022-11-28 19:22:35 +0530 | [diff] [blame] | 254 | frappe.throw(_("To Date cannot be before From Date"), title=_("Invalid Auto Repeat Date")) |
| 255 | |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 256 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 260 | frappe.throw( |
| 261 | _("Row #{0}: Service Start and End Date is required for deferred accounting").format(d.idx) |
| 262 | ) |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 263 | elif getdate(d.service_start_date) > getdate(d.service_end_date): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 264 | frappe.throw( |
| 265 | _("Row #{0}: Service Start Date cannot be greater than Service End Date").format(d.idx) |
| 266 | ) |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 267 | elif getdate(self.posting_date) > getdate(d.service_end_date): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 268 | frappe.throw( |
| 269 | _("Row #{0}: Service End Date cannot be before Invoice Posting Date").format(d.idx) |
| 270 | ) |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 271 | |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 272 | def validate_invoice_documents_schedule(self): |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 273 | self.validate_payment_schedule_dates() |
| 274 | self.set_due_date() |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 275 | self.set_payment_schedule() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 276 | if not self.get("ignore_default_payment_terms_template"): |
Deepesh Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 277 | self.validate_payment_schedule_amount() |
Deepesh Garg | bd709f8 | 2021-08-23 19:05:52 +0530 | [diff] [blame] | 278 | self.validate_due_date() |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 279 | self.validate_advance_entries() |
| 280 | |
| 281 | def validate_non_invoice_documents_schedule(self): |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 282 | self.set_payment_schedule() |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 283 | self.validate_payment_schedule_dates() |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 284 | self.validate_payment_schedule_amount() |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 285 | |
| 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 | |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 292 | def before_print(self, settings=None): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 293 | 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 | ]: |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 303 | if self.get("group_same_items"): |
| 304 | self.group_similar_items() |
| 305 | |
Zarrar | 5be6d19 | 2018-11-08 12:16:26 +0530 | [diff] [blame] | 306 | 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 | |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 313 | set_print_templates_for_item_table(self, settings) |
| 314 | set_print_templates_for_taxes(self, settings) |
| 315 | |
Mangesh-Khairnar | 7bcb24e | 2019-09-11 10:49:33 +0530 | [diff] [blame] | 316 | def calculate_paid_amount(self): |
Saurabh | 43520f9 | 2016-03-21 18:32:48 +0530 | [diff] [blame] | 317 | if hasattr(self, "is_pos") or hasattr(self, "is_paid"): |
| 318 | is_paid = self.get("is_pos") or self.get("is_paid") |
Mangesh-Khairnar | 7bcb24e | 2019-09-11 10:49:33 +0530 | [diff] [blame] | 319 | |
| 320 | if is_paid: |
| 321 | if not self.cash_bank_account: |
| 322 | # show message that the amount is not paid |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 323 | frappe.throw( |
| 324 | _("Note: Payment Entry will not be created since 'Cash or Bank Account' was not specified") |
| 325 | ) |
Marica | 23d7b09 | 2019-09-25 17:17:36 +0530 | [diff] [blame] | 326 | |
Mangesh-Khairnar | 7bcb24e | 2019-09-11 10:49:33 +0530 | [diff] [blame] | 327 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 333 | self.base_paid_amount = flt( |
| 334 | self.paid_amount * self.conversion_rate, self.precision("base_paid_amount") |
| 335 | ) |
Saurabh | 43520f9 | 2016-03-21 18:32:48 +0530 | [diff] [blame] | 336 | |
Anand Doshi | abc1003 | 2013-06-14 17:44:03 +0530 | [diff] [blame] | 337 | def set_missing_values(self, for_validate=False): |
Rohit Waghchaure | 5d97d89 | 2016-05-12 12:58:29 +0530 | [diff] [blame] | 338 | if frappe.flags.in_test: |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 339 | for fieldname in ["posting_date", "transaction_date"]: |
Rohit Waghchaure | 5d97d89 | 2016-05-12 12:58:29 +0530 | [diff] [blame] | 340 | if self.meta.get_field(fieldname) and not self.get(fieldname): |
| 341 | self.set(fieldname, today()) |
| 342 | break |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 343 | |
Nabin Hait | 3237c75 | 2015-02-17 11:11:11 +0530 | [diff] [blame] | 344 | def calculate_taxes_and_totals(self): |
Nabin Hait | fe81da2 | 2015-02-18 12:23:18 +0530 | [diff] [blame] | 345 | from erpnext.controllers.taxes_and_totals import calculate_taxes_and_totals |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 346 | |
Nabin Hait | fe81da2 | 2015-02-18 12:23:18 +0530 | [diff] [blame] | 347 | calculate_taxes_and_totals(self) |
Nabin Hait | 3237c75 | 2015-02-17 11:11:11 +0530 | [diff] [blame] | 348 | |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 349 | if self.doctype in ( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 350 | "Sales Order", |
| 351 | "Delivery Note", |
| 352 | "Sales Invoice", |
| 353 | "POS Invoice", |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 354 | ): |
Nabin Hait | 3237c75 | 2015-02-17 11:11:11 +0530 | [diff] [blame] | 355 | self.calculate_commission() |
| 356 | self.calculate_contribution() |
| 357 | |
Nabin Hait | cfecd2b | 2013-07-11 17:49:18 +0530 | [diff] [blame] | 358 | def validate_date_with_fiscal_year(self): |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 359 | if self.meta.get_field("fiscal_year"): |
Rohan Bansal | 1e3a3b2 | 2021-05-26 15:18:10 +0530 | [diff] [blame] | 360 | date_field = None |
Nabin Hait | cfecd2b | 2013-07-11 17:49:18 +0530 | [diff] [blame] | 361 | 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 Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 365 | |
Rushabh Mehta | f2227d0 | 2014-03-31 23:37:40 +0530 | [diff] [blame] | 366 | if date_field and self.get(date_field): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 367 | validate_fiscal_year( |
| 368 | self.get(date_field), self.fiscal_year, self.company, self.meta.get_label(date_field), self |
| 369 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 370 | |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 371 | def validate_party_accounts(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 372 | if self.doctype not in ("Sales Invoice", "Purchase Invoice"): |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 373 | return |
| 374 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 375 | if self.doctype == "Sales Invoice": |
| 376 | party_account_field = "debit_to" |
| 377 | item_field = "income_account" |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 378 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 379 | party_account_field = "credit_to" |
| 380 | item_field = "expense_account" |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 381 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 382 | for item in self.get("items"): |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 383 | if item.get(item_field) == self.get(party_account_field): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 384 | 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 Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 393 | |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 394 | def validate_inter_company_reference(self): |
Rohit Waghchaure | 38aaba5 | 2023-05-13 13:00:05 +0530 | [diff] [blame] | 395 | if self.get("is_return"): |
| 396 | return |
| 397 | |
Rohit Waghchaure | b4a102d | 2022-09-06 16:22:00 +0530 | [diff] [blame] | 398 | if self.doctype not in ("Purchase Invoice", "Purchase Receipt"): |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 399 | return |
| 400 | |
| 401 | if self.is_internal_transfer(): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 402 | 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 Garg | 906ad10 | 2023-01-15 17:32:57 +0530 | [diff] [blame] | 406 | ) and not self.get("is_return"): |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 407 | msg = _("Internal Sale or Delivery Reference missing.") |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 408 | msg += _("Please create purchase from internal sale or delivery document itself") |
| 409 | frappe.throw(msg, title=_("Internal Sales Reference Missing")) |
| 410 | |
Rohit Waghchaure | 19911b4 | 2023-04-21 16:49:48 +0530 | [diff] [blame] | 411 | 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 Menat | 3714e36 | 2022-05-16 18:09:14 +0530 | [diff] [blame] | 420 | 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 Garg | 8d30ebb | 2022-11-05 20:51:15 +0530 | [diff] [blame] | 428 | 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 Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 442 | def validate_due_date(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 443 | if self.get("is_pos"): |
| 444 | return |
rohitwaghchaure | ea943c6 | 2018-07-06 12:28:58 +0530 | [diff] [blame] | 445 | |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 446 | from erpnext.accounts.party import validate_due_date |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 447 | |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 448 | if self.doctype == "Sales Invoice": |
Nabin Hait | 04d244a | 2015-07-22 17:47:49 +0530 | [diff] [blame] | 449 | if not self.due_date: |
| 450 | frappe.throw(_("Due Date is mandatory")) |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 451 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 452 | 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 Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 460 | elif self.doctype == "Purchase Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 461 | 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 Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 470 | |
Nabin Hait | 096d363 | 2013-10-17 17:01:14 +0530 | [diff] [blame] | 471 | def set_price_list_currency(self, buying_or_selling): |
Nabin Hait | 1cc55fb | 2016-12-08 14:09:23 +0530 | [diff] [blame] | 472 | if self.meta.get_field("posting_date"): |
Nabin Hait | 288a18e | 2016-12-08 15:36:23 +0530 | [diff] [blame] | 473 | transaction_date = self.posting_date |
Nabin Hait | 1cc55fb | 2016-12-08 14:09:23 +0530 | [diff] [blame] | 474 | else: |
Nabin Hait | 288a18e | 2016-12-08 15:36:23 +0530 | [diff] [blame] | 475 | transaction_date = self.transaction_date |
Rushabh Mehta | 6695830 | 2017-01-16 16:57:53 +0530 | [diff] [blame] | 476 | |
Rushabh Mehta | 4a404e9 | 2013-08-09 18:11:35 +0530 | [diff] [blame] | 477 | if self.meta.get_field("currency"): |
Nabin Hait | 7a75e10 | 2013-09-17 10:21:20 +0530 | [diff] [blame] | 478 | # price list part |
Shreya | 3f77852 | 2018-05-15 16:59:20 +0530 | [diff] [blame] | 479 | 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 Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 486 | if self.meta.get_field(fieldname) and self.get(fieldname): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 487 | self.price_list_currency = frappe.db.get_value("Price List", self.get(fieldname), "currency") |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 488 | |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 489 | if self.price_list_currency == self.company_currency: |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 490 | self.plc_conversion_rate = 1.0 |
Nabin Hait | 11f4195 | 2013-09-24 14:36:55 +0530 | [diff] [blame] | 491 | |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 492 | elif not self.plc_conversion_rate: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 493 | self.plc_conversion_rate = get_exchange_rate( |
| 494 | self.price_list_currency, self.company_currency, transaction_date, args |
| 495 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 496 | |
Nabin Hait | 7a75e10 | 2013-09-17 10:21:20 +0530 | [diff] [blame] | 497 | # currency |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 498 | if not self.currency: |
| 499 | self.currency = self.price_list_currency |
| 500 | self.conversion_rate = self.plc_conversion_rate |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 501 | elif self.currency == self.company_currency: |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 502 | self.conversion_rate = 1.0 |
| 503 | elif not self.conversion_rate: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 504 | self.conversion_rate = get_exchange_rate( |
| 505 | self.currency, self.company_currency, transaction_date, args |
| 506 | ) |
Nabin Hait | 7a75e10 | 2013-09-17 10:21:20 +0530 | [diff] [blame] | 507 | |
Nabin Hait | cccc45e | 2016-10-05 17:15:43 +0530 | [diff] [blame] | 508 | def set_missing_item_details(self, for_validate=False): |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 509 | """set missing item values""" |
Nabin Hait | f37d43d | 2017-07-18 12:14:42 +0530 | [diff] [blame] | 510 | from erpnext.stock.doctype.serial_no.serial_no import get_serial_nos |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 511 | |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 512 | if hasattr(self, "items"): |
Nabin Hait | 444f956 | 2014-06-20 15:59:49 +0530 | [diff] [blame] | 513 | parent_dict = {} |
Pratik Vyas | f7daab7 | 2014-04-10 17:53:30 +0530 | [diff] [blame] | 514 | for fieldname in self.meta.get_valid_columns(): |
| 515 | parent_dict[fieldname] = self.get(fieldname) |
| 516 | |
mbauskar | a52472c | 2016-03-05 15:10:25 +0530 | [diff] [blame] | 517 | if self.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]: |
| 518 | document_type = "{} Item".format(self.doctype) |
mbauskar | c97becb | 2016-01-18 16:28:21 +0530 | [diff] [blame] | 519 | parent_dict.update({"document_type": document_type}) |
| 520 | |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 521 | # party_name field used for customer in quotation |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 522 | if ( |
| 523 | self.doctype == "Quotation" |
| 524 | and self.quotation_to == "Customer" |
| 525 | and parent_dict.get("party_name") |
| 526 | ): |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 527 | parent_dict.update({"customer": parent_dict.get("party_name")}) |
| 528 | |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 529 | self.pricing_rules = [] |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 530 | |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 531 | for item in self.get("items"): |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 532 | if item.get("item_code"): |
Nabin Hait | 444f956 | 2014-06-20 15:59:49 +0530 | [diff] [blame] | 533 | args = parent_dict.copy() |
| 534 | args.update(item.as_dict()) |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 535 | |
Nabin Hait | 34d2822 | 2016-01-19 15:45:49 +0530 | [diff] [blame] | 536 | args["doctype"] = self.doctype |
| 537 | args["name"] = self.name |
Rohit Waghchaure | 8bfe330 | 2019-03-18 14:34:19 +0530 | [diff] [blame] | 538 | args["child_docname"] = item.name |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 539 | args["ignore_pricing_rule"] = ( |
| 540 | self.ignore_pricing_rule if hasattr(self, "ignore_pricing_rule") else 0 |
| 541 | ) |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 542 | |
Nabin Hait | e2f054c | 2015-03-09 14:54:37 +0530 | [diff] [blame] | 543 | if not args.get("transaction_date"): |
| 544 | args["transaction_date"] = args.get("posting_date") |
Anand Doshi | 2b2b639 | 2015-03-20 14:18:09 +0530 | [diff] [blame] | 545 | |
| 546 | if self.get("is_subcontracted"): |
| 547 | args["is_subcontracted"] = self.is_subcontracted |
Rohit Waghchaure | 8bfe330 | 2019-03-18 14:34:19 +0530 | [diff] [blame] | 548 | |
Deepesh Garg | a7051cb | 2023-04-14 09:59:42 +0530 | [diff] [blame] | 549 | ret = get_item_details(args, self, for_validate=True, overwrite_warehouse=False) |
Rohit Waghchaure | 8bfe330 | 2019-03-18 14:34:19 +0530 | [diff] [blame] | 550 | |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 551 | for fieldname, value in ret.items(): |
Anand Doshi | 602e825 | 2015-11-16 19:05:46 +0530 | [diff] [blame] | 552 | if item.meta.get_field(fieldname) and value is not None: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 553 | if item.get(fieldname) is None or fieldname in force_item_fields: |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 554 | item.set(fieldname, value) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 555 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 556 | elif fieldname in ["cost_center", "conversion_factor"] and not item.get(fieldname): |
Anand Doshi | 602e825 | 2015-11-16 19:05:46 +0530 | [diff] [blame] | 557 | item.set(fieldname, value) |
| 558 | |
Rohit Waghchaure | dc981dc | 2017-04-03 14:17:08 +0530 | [diff] [blame] | 559 | elif fieldname == "serial_no": |
Alchez | 9155e40 | 2018-07-09 16:57:42 +0530 | [diff] [blame] | 560 | # 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 |
Alchez | 8f2a0f3 | 2018-07-06 14:36:52 +0530 | [diff] [blame] | 563 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 564 | if item_qty != len(get_serial_nos(item.get("serial_no"))): |
Rohit Waghchaure | dc981dc | 2017-04-03 14:17:08 +0530 | [diff] [blame] | 565 | item.set(fieldname, value) |
Nabin Hait | a74468b | 2014-12-30 18:33:52 +0530 | [diff] [blame] | 566 | |
Saqib Ansari | ab36b27 | 2022-02-09 10:10:17 +0530 | [diff] [blame] | 567 | 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 Ansari | b8c41e3 | 2022-01-20 13:06:08 +0530 | [diff] [blame] | 580 | # reset pricing rule fields if pricing_rule_removed |
| 581 | item.set(fieldname, value) |
| 582 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 583 | 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 Waghchaure | f6f503a | 2018-12-19 15:06:44 +0530 | [diff] [blame] | 587 | |
Deepesh Garg | a60c308 | 2021-05-11 16:38:33 +0530 | [diff] [blame] | 588 | # Double check for cost center |
| 589 | # Items add via promotional scheme may not have cost center set |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 590 | 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 Garg | a60c308 | 2021-05-11 16:38:33 +0530 | [diff] [blame] | 594 | |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 595 | if ret.get("pricing_rules"): |
| 596 | self.apply_pricing_rule_on_items(item, ret) |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 597 | self.set_pricing_rule_details(item, ret) |
Ankush Menat | 10583eb | 2022-06-17 12:13:27 +0530 | [diff] [blame] | 598 | 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 Garg | 6175183 | 2022-12-29 10:41:36 +0530 | [diff] [blame] | 606 | # 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 Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 612 | |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 613 | if self.doctype == "Purchase Invoice": |
Nabin Hait | cccc45e | 2016-10-05 17:15:43 +0530 | [diff] [blame] | 614 | self.set_expense_account(for_validate) |
Nabin Hait | a3dd72a | 2014-05-28 12:49:20 +0530 | [diff] [blame] | 615 | |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 616 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 619 | if pricing_rule_args.get("price_or_product_discount") == "Price": |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 620 | item.set("pricing_rules", pricing_rule_args.get("pricing_rules")) |
Rohit Waghchaure | f5bd3fa | 2022-09-16 15:23:10 +0530 | [diff] [blame] | 621 | 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 | |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 626 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 632 | item.rate = flt( |
| 633 | item.price_list_rate * (1.0 - (flt(item.discount_percentage) / 100.0)), |
| 634 | item.precision("rate"), |
| 635 | ) |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 636 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 637 | if item.get("discount_amount"): |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 638 | item.rate = item.price_list_rate - item.discount_amount |
| 639 | |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 640 | if item.get("apply_discount_on_discounted_rate") and pricing_rule_args.get("rate"): |
| 641 | item.rate = pricing_rule_args.get("rate") |
| 642 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 643 | elif pricing_rule_args.get("free_item_data"): |
| 644 | apply_pricing_rule_for_free_items(self, pricing_rule_args.get("free_item_data")) |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 645 | |
| 646 | elif pricing_rule_args.get("validate_applied_rule"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 647 | for pricing_rule in get_applied_pricing_rules(item.get("pricing_rules")): |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 648 | pricing_rule_doc = frappe.get_cached_doc("Pricing Rule", pricing_rule) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 649 | for field in ["discount_percentage", "discount_amount", "rate"]: |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 650 | if item.get(field) < pricing_rule_doc.get(field): |
| 651 | title = get_link_to_form("Pricing Rule", pricing_rule) |
| 652 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 653 | 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 | ) |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 658 | |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 659 | def set_pricing_rule_details(self, item_row, args): |
| 660 | pricing_rules = get_applied_pricing_rules(args.get("pricing_rules")) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 661 | if not pricing_rules: |
| 662 | return |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 663 | |
| 664 | for pricing_rule in pricing_rules: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 665 | 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 Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 674 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 675 | def set_taxes(self): |
| 676 | if not self.meta.get_field("taxes"): |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 677 | return |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 678 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 679 | tax_master_doctype = self.meta.get_field("taxes_and_charges").options |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 680 | |
rohitwaghchaure | 57914f1 | 2018-04-24 19:19:47 +0530 | [diff] [blame] | 681 | if (self.is_new() or self.is_pos_profile_changed()) and not self.get("taxes"): |
rohitwaghchaure | 505661b | 2017-12-11 14:52:28 +0530 | [diff] [blame] | 682 | if self.company and not self.get("taxes_and_charges"): |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 683 | # get the default tax master |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 684 | self.taxes_and_charges = frappe.db.get_value( |
| 685 | tax_master_doctype, {"is_default": 1, "company": self.company} |
| 686 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 687 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 688 | self.append_taxes_from_master(tax_master_doctype) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 689 | |
rohitwaghchaure | 57914f1 | 2018-04-24 19:19:47 +0530 | [diff] [blame] | 690 | def is_pos_profile_changed(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 691 | 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 | ): |
rohitwaghchaure | 57914f1 | 2018-04-24 19:19:47 +0530 | [diff] [blame] | 696 | return True |
| 697 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 698 | def append_taxes_from_master(self, tax_master_doctype=None): |
| 699 | if self.get("taxes_and_charges"): |
Anand Doshi | 99100a4 | 2013-07-04 17:13:53 +0530 | [diff] [blame] | 700 | if not tax_master_doctype: |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 701 | tax_master_doctype = self.meta.get_field("taxes_and_charges").options |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 702 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 703 | self.extend("taxes", get_taxes_and_charges(tax_master_doctype, self.get("taxes_and_charges"))) |
Akhilesh Darjee | 4cdb799 | 2014-01-30 13:56:57 +0530 | [diff] [blame] | 704 | |
Anand Doshi | ac32bad | 2014-04-18 01:30:14 +0530 | [diff] [blame] | 705 | def set_other_charges(self): |
Nabin Hait | e7d1536 | 2014-12-25 16:01:55 +0530 | [diff] [blame] | 706 | self.set("taxes", []) |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 707 | self.set_taxes() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 708 | |
ankitjavalkarwork | 6c29d87 | 2014-10-06 13:20:53 +0530 | [diff] [blame] | 709 | def validate_enabled_taxes_and_charges(self): |
| 710 | taxes_and_charges_doctype = self.meta.get_options("taxes_and_charges") |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 711 | if frappe.get_cached_value(taxes_and_charges_doctype, self.taxes_and_charges, "disabled"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 712 | frappe.throw( |
| 713 | _("{0} '{1}' is disabled").format(taxes_and_charges_doctype, self.taxes_and_charges) |
| 714 | ) |
ankitjavalkarwork | 6c29d87 | 2014-10-06 13:20:53 +0530 | [diff] [blame] | 715 | |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 716 | def validate_tax_account_company(self): |
| 717 | for d in self.get("taxes"): |
| 718 | if d.account_head: |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 719 | tax_account_company = frappe.get_cached_value("Account", d.account_head, "company") |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 720 | if tax_account_company != self.company: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 721 | 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 Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 726 | |
deepeshgarg007 | 3d11ac0 | 2019-05-19 00:02:01 +0530 | [diff] [blame] | 727 | def get_gl_dict(self, args, account_currency=None, item=None): |
Nabin Hait | 2df4d54 | 2013-01-29 11:34:39 +0530 | [diff] [blame] | 728 | """this method populates the common properties of a gl entry record""" |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 729 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 730 | posting_date = args.get("posting_date") or self.get("posting_date") |
Rohit Waghchaure | aa7b434 | 2018-05-11 01:56:05 +0530 | [diff] [blame] | 731 | fiscal_years = get_fiscal_years(posting_date, company=self.company) |
Nabin Hait | 2ed0b59 | 2016-03-29 13:14:17 +0530 | [diff] [blame] | 732 | if len(fiscal_years) > 1: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 733 | 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 Hait | 2ed0b59 | 2016-03-29 13:14:17 +0530 | [diff] [blame] | 738 | else: |
| 739 | fiscal_year = fiscal_years[0][0] |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 740 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 741 | 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 | ) |
deepeshgarg007 | d83cf65 | 2019-05-12 18:34:23 +0530 | [diff] [blame] | 760 | |
| 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) |
deepeshgarg007 | 3d11ac0 | 2019-05-19 00:02:01 +0530 | [diff] [blame] | 766 | if item and item.get(dimension): |
| 767 | dimension_dict[dimension] = item.get(dimension) |
deepeshgarg007 | d83cf65 | 2019-05-12 18:34:23 +0530 | [diff] [blame] | 768 | |
| 769 | gl_dict.update(dimension_dict) |
Nabin Hait | 2df4d54 | 2013-01-29 11:34:39 +0530 | [diff] [blame] | 770 | gl_dict.update(args) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 771 | |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 772 | if not account_currency: |
Anand Doshi | cd0989e | 2015-09-28 13:31:17 +0530 | [diff] [blame] | 773 | account_currency = get_account_currency(gl_dict.account) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 774 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 775 | 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 Doshi | be6cfdd | 2015-09-17 21:07:04 +0530 | [diff] [blame] | 783 | self.validate_account_currency(gl_dict.account, account_currency) |
Deepesh Garg | 7c30085 | 2020-12-26 20:14:51 +0530 | [diff] [blame] | 784 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 785 | 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 Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 793 | |
Nabin Hait | c561a49 | 2015-08-19 19:22:34 +0530 | [diff] [blame] | 794 | return gl_dict |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 795 | |
Anurag Mishra | e657fe8 | 2018-11-26 15:19:17 +0530 | [diff] [blame] | 796 | def validate_qty_is_not_zero(self): |
Marica | c68a940 | 2019-12-03 12:59:22 +0530 | [diff] [blame] | 797 | 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 Mishra | e657fe8 | 2018-11-26 15:19:17 +0530 | [diff] [blame] | 801 | |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 802 | def validate_account_currency(self, account, account_currency=None): |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 803 | valid_currency = [self.company_currency] |
| 804 | if self.get("currency") and self.currency != self.company_currency: |
| 805 | valid_currency.append(self.currency) |
| 806 | |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 807 | if account_currency not in valid_currency: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 808 | frappe.throw( |
| 809 | _("Account {0} is invalid. Account Currency must be {1}").format( |
| 810 | account, (" " + _("or") + " ").join(valid_currency) |
| 811 | ) |
| 812 | ) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 813 | |
Anand Doshi | 613cb6a | 2013-02-06 17:33:46 +0530 | [diff] [blame] | 814 | def clear_unallocated_advances(self, childtype, parentfield): |
Rushabh Mehta | f191f85 | 2014-04-02 18:09:34 +0530 | [diff] [blame] | 815 | self.set(parentfield, self.get(parentfield, {"allocated_amount": ["not in", [0, None, ""]]})) |
| 816 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 817 | 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 Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 823 | |
Walstan Baptista | d636075 | 2021-03-31 12:30:32 +0530 | [diff] [blame] | 824 | @frappe.whitelist() |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 825 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 832 | """Returns Address object from shipping address fields if present""" |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 833 | |
| 834 | # shipping address fields can be `shipping_address_name` or `shipping_address` |
| 835 | # try getting value from both |
| 836 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 837 | for fieldname in ("shipping_address_name", "shipping_address"): |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 838 | shipping_field = self.meta.get_field(fieldname) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 839 | if shipping_field and shipping_field.fieldtype == "Link": |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 840 | if self.get(fieldname): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 841 | return frappe.get_doc("Address", self.get(fieldname)) |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 842 | |
| 843 | return {} |
| 844 | |
Walstan Baptista | d636075 | 2021-03-31 12:30:32 +0530 | [diff] [blame] | 845 | @frappe.whitelist() |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 846 | def set_advances(self): |
| 847 | """Returns list of advances against Account, Party, Reference""" |
| 848 | |
Deepesh Garg | fd3fb64 | 2023-04-05 12:02:44 +0530 | [diff] [blame] | 849 | res = self.get_advance_entries( |
| 850 | include_unallocated=not cint(self.get("only_include_allocated_payments")) |
| 851 | ) |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 852 | |
| 853 | self.set("advances", []) |
| 854 | advance_allocated = 0 |
| 855 | for d in res: |
Deepesh Garg | 181df2f | 2022-11-04 15:49:37 +0530 | [diff] [blame] | 856 | if self.get("party_account_currency") == self.company_currency: |
| 857 | amount = self.get("base_rounded_total") or self.base_grand_total |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 858 | else: |
Deepesh Garg | 181df2f | 2022-11-04 15:49:37 +0530 | [diff] [blame] | 859 | amount = self.get("rounded_total") or self.grand_total |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 860 | |
Deepesh Garg | 181df2f | 2022-11-04 15:49:37 +0530 | [diff] [blame] | 861 | allocated_amount = min(amount - advance_allocated, d.amount) |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 862 | advance_allocated += flt(allocated_amount) |
Rushabh Mehta | 708e47a | 2018-08-08 16:37:31 +0530 | [diff] [blame] | 863 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 864 | advance_row = { |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 865 | "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), |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 871 | "allocated_amount": allocated_amount, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 872 | "ref_exchange_rate": flt(d.exchange_rate), # exchange_rate of advance entry |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 873 | } |
| 874 | |
| 875 | self.append("advances", advance_row) |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 876 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 877 | 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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 892 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 893 | order_list = list(set(d.get(order_field) for d in self.get("items") if d.get(order_field))) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 894 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 895 | journal_entries = get_advance_journal_entries( |
| 896 | party_type, party, party_account, amount_field, order_doctype, order_list, include_unallocated |
| 897 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 898 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 899 | payment_entries = get_advance_payment_entries( |
| 900 | party_type, party, party_account, order_doctype, order_list, include_unallocated |
| 901 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 902 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 903 | res = journal_entries + payment_entries |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 904 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 905 | return res |
Nabin Hait | 48f5fa6 | 2014-09-18 15:03:54 +0530 | [diff] [blame] | 906 | |
rohitwaghchaure | bf4c114 | 2018-01-08 15:20:15 +0530 | [diff] [blame] | 907 | def is_inclusive_tax(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 908 | is_inclusive = cint( |
| 909 | frappe.db.get_single_value("Accounts Settings", "show_inclusive_tax_in_print") |
| 910 | ) |
rohitwaghchaure | bf4c114 | 2018-01-08 15:20:15 +0530 | [diff] [blame] | 911 | |
| 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 Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 919 | def validate_advance_entries(self): |
Nabin Hait | 05aefbb | 2016-06-28 19:42:19 +0530 | [diff] [blame] | 920 | order_field = "sales_order" if self.doctype == "Sales Invoice" else "purchase_order" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 921 | order_list = list(set(d.get(order_field) for d in self.get("items") if d.get(order_field))) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 922 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 923 | if not order_list: |
| 924 | return |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 925 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 926 | advance_entries = self.get_advance_entries(include_unallocated=False) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 927 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 928 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 932 | 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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 937 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 938 | def set_advance_gain_or_loss(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 939 | if self.get("conversion_rate") == 1 or not self.get("advances"): |
Saqib Ansari | 64efe8b | 2021-09-26 15:46:13 +0530 | [diff] [blame] | 940 | return |
| 941 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 942 | is_purchase_invoice = self.doctype == "Purchase Invoice" |
Saqib Ansari | 64efe8b | 2021-09-26 15:46:13 +0530 | [diff] [blame] | 943 | party_account = self.credit_to if is_purchase_invoice else self.debit_to |
| 944 | if get_account_currency(party_account) != self.currency: |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 945 | return |
| 946 | |
| 947 | for d in self.get("advances"): |
| 948 | advance_exchange_rate = d.ref_exchange_rate |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 949 | if d.allocated_amount and self.conversion_rate != advance_exchange_rate: |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 950 | |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 958 | if self.get("doctype") in ["Purchase Invoice", "Sales Invoice"]: |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 959 | for d in self.get("advances"): |
| 960 | if d.exchange_gain_loss: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 961 | is_purchase_invoice = self.get("doctype") == "Purchase Invoice" |
Saqib | d4ae1fe | 2021-07-30 11:21:49 +0530 | [diff] [blame] | 962 | 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" |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 965 | |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 966 | gain_loss_account = frappe.get_cached_value( |
| 967 | "Company", self.company, "exchange_gain_loss_account" |
| 968 | ) |
Saqib | d4ae1fe | 2021-07-30 11:21:49 +0530 | [diff] [blame] | 969 | if not gain_loss_account: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 970 | frappe.throw( |
| 971 | _("Please set default Exchange Gain/Loss Account in Company {}").format(self.get("company")) |
| 972 | ) |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 973 | account_currency = get_account_currency(gain_loss_account) |
| 974 | if account_currency != self.company_currency: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 975 | frappe.throw( |
| 976 | _("Currency for {0} must be {1}").format(gain_loss_account, self.company_currency) |
| 977 | ) |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 978 | |
| 979 | # for purchase |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 980 | dr_or_cr = "debit" if d.exchange_gain_loss > 0 else "credit" |
Saqib | d4ae1fe | 2021-07-30 11:21:49 +0530 | [diff] [blame] | 981 | if not is_purchase_invoice: |
| 982 | # just reverse for sales? |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 983 | dr_or_cr = "debit" if dr_or_cr == "credit" else "credit" |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 984 | |
| 985 | gl_entries.append( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 986 | 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 | ) |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 998 | ) |
| 999 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1000 | dr_or_cr = "debit" if dr_or_cr == "credit" else "credit" |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 1001 | |
| 1002 | gl_entries.append( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1003 | 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 | ) |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 1017 | ) |
| 1018 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1019 | def update_against_document_in_jv(self): |
| 1020 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1021 | 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 Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1025 | """ |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 1026 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1027 | if self.doctype == "Sales Invoice": |
Nabin Hait | ff2f3ef | 2016-07-04 11:41:14 +0530 | [diff] [blame] | 1028 | party_type = "Customer" |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1029 | party = self.customer |
| 1030 | party_account = self.debit_to |
| 1031 | dr_or_cr = "credit_in_account_currency" |
| 1032 | else: |
Nabin Hait | ff2f3ef | 2016-07-04 11:41:14 +0530 | [diff] [blame] | 1033 | party_type = "Supplier" |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1034 | party = self.supplier |
| 1035 | party_account = self.credit_to |
| 1036 | dr_or_cr = "debit_in_account_currency" |
Nabin Hait | 48f5fa6 | 2014-09-18 15:03:54 +0530 | [diff] [blame] | 1037 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1038 | lst = [] |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1039 | for d in self.get("advances"): |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1040 | if flt(d.allocated_amount) > 0: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1041 | 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 Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1065 | "difference_account": frappe.get_cached_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1066 | "Company", self.company, "exchange_gain_loss_account" |
| 1067 | ), |
| 1068 | "exchange_gain_loss": flt(d.get("exchange_gain_loss")), |
| 1069 | } |
| 1070 | ) |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1071 | lst.append(args) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 1072 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1073 | if lst: |
| 1074 | from erpnext.accounts.utils import reconcile_against_document |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1075 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1076 | reconcile_against_document(lst) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1077 | |
Rohit Waghchaure | 5fa9a7a | 2019-04-01 00:40:38 +0530 | [diff] [blame] | 1078 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1082 | if frappe.db.get_single_value("Accounts Settings", "unlink_payment_on_cancellation_of_invoice"): |
Rohit Waghchaure | 5fa9a7a | 2019-04-01 00:40:38 +0530 | [diff] [blame] | 1083 | unlink_ref_doc_from_payment_entries(self) |
| 1084 | |
| 1085 | elif self.doctype in ["Sales Order", "Purchase Order"]: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1086 | if frappe.db.get_single_value( |
| 1087 | "Accounts Settings", "unlink_advance_payment_on_cancelation_of_order" |
| 1088 | ): |
Rohit Waghchaure | 5fa9a7a | 2019-04-01 00:40:38 +0530 | [diff] [blame] | 1089 | unlink_ref_doc_from_payment_entries(self) |
| 1090 | |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1091 | if self.doctype == "Sales Order": |
| 1092 | self.unlink_ref_doc_from_po() |
| 1093 | |
| 1094 | def unlink_ref_doc_from_po(self): |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1095 | so_items = [] |
| 1096 | for item in self.items: |
| 1097 | so_items.append(item.name) |
| 1098 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1099 | 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 | ) |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1112 | |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1113 | if linked_po: |
GangaManoj | e77534f | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1114 | frappe.db.set_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1115 | "Purchase Order Item", |
| 1116 | {"sales_order": self.name, "sales_order_item": ["in", so_items], "docstatus": ["<", 2]}, |
| 1117 | {"sales_order": None, "sales_order_item": None}, |
GangaManoj | e77534f | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1118 | ) |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1119 | |
| 1120 | frappe.msgprint(_("Purchase Orders {0} are un-linked").format("\n".join(linked_po))) |
| 1121 | |
Deepesh Garg | d18dde7 | 2020-11-29 21:40:04 +0530 | [diff] [blame] | 1122 | def get_tax_map(self): |
| 1123 | tax_map = {} |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1124 | for tax in self.get("taxes"): |
Deepesh Garg | d18dde7 | 2020-11-29 21:40:04 +0530 | [diff] [blame] | 1125 | tax_map.setdefault(tax.account_head, 0.0) |
| 1126 | tax_map[tax.account_head] += tax.tax_amount |
| 1127 | |
| 1128 | return tax_map |
| 1129 | |
Deepesh Garg | 92f7a5a | 2021-07-21 15:25:40 +0530 | [diff] [blame] | 1130 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1134 | if ( |
| 1135 | enable_discount_accounting |
| 1136 | and self.get("discount_amount") |
| 1137 | and self.get("additional_discount_account") |
| 1138 | ): |
Deepesh Garg | 92f7a5a | 2021-07-21 15:25:40 +0530 | [diff] [blame] | 1139 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1148 | 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 Garg | 92f7a5a | 2021-07-21 15:25:40 +0530 | [diff] [blame] | 1154 | amount = tax.tax_amount |
| 1155 | base_amount = tax.base_tax_amount |
| 1156 | |
| 1157 | return amount, base_amount |
| 1158 | |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1159 | def make_discount_gl_entries(self, gl_entries): |
rahib-hassan | f3fa6ac | 2022-04-20 16:01:12 +0530 | [diff] [blame] | 1160 | 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 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1168 | |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1169 | 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 | |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1179 | if enable_discount_accounting: |
| 1180 | for item in self.get("items"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1181 | if item.get("discount_amount") and item.get("discount_account"): |
Deepesh Garg | ad7bb31 | 2021-07-28 11:38:44 +0530 | [diff] [blame] | 1182 | discount_amount = item.discount_amount * item.qty |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1183 | if self.doctype == "Purchase Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1184 | income_or_expense_account = ( |
| 1185 | item.expense_account |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1186 | if (not item.enable_deferred_expense or self.is_return) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1187 | else item.deferred_expense_account |
| 1188 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1189 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1190 | income_or_expense_account = ( |
| 1191 | item.income_account |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1192 | if (not item.enable_deferred_revenue or self.is_return) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1193 | else item.deferred_revenue_account |
| 1194 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1195 | |
| 1196 | account_currency = get_account_currency(item.discount_account) |
| 1197 | gl_entries.append( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1198 | self.get_gl_dict( |
| 1199 | { |
| 1200 | "account": item.discount_account, |
| 1201 | "against": supplier_or_customer, |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1202 | dr_or_cr: flt( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1203 | discount_amount * self.get("conversion_rate"), item.precision("discount_amount") |
| 1204 | ), |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1205 | dr_or_cr + "_in_account_currency": flt(discount_amount, item.precision("discount_amount")), |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1206 | "cost_center": item.cost_center, |
| 1207 | "project": item.project, |
| 1208 | }, |
| 1209 | account_currency, |
| 1210 | item=item, |
| 1211 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1212 | ) |
| 1213 | |
| 1214 | account_currency = get_account_currency(income_or_expense_account) |
| 1215 | gl_entries.append( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1216 | self.get_gl_dict( |
| 1217 | { |
| 1218 | "account": income_or_expense_account, |
| 1219 | "against": supplier_or_customer, |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1220 | rev_dr_cr: flt( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1221 | discount_amount * self.get("conversion_rate"), item.precision("discount_amount") |
| 1222 | ), |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1223 | rev_dr_cr |
| 1224 | + "_in_account_currency": flt(discount_amount, item.precision("discount_amount")), |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1225 | "cost_center": item.cost_center, |
| 1226 | "project": item.project or self.project, |
| 1227 | }, |
| 1228 | account_currency, |
| 1229 | item=item, |
| 1230 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1231 | ) |
GangaManoj | 857501c | 2021-07-15 22:03:46 +0530 | [diff] [blame] | 1232 | |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1233 | if ( |
Deepesh Garg | ae3dce0 | 2022-08-22 08:57:58 +0530 | [diff] [blame] | 1234 | (enable_discount_accounting or self.get("is_cash_or_non_trade_discount")) |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1235 | 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 Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1247 | ) |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1248 | ) |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1249 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1250 | def validate_multiple_billing(self, ref_dt, item_ref_dn, based_on): |
Nabin Hait | 868766d | 2019-07-15 18:02:58 +0530 | [diff] [blame] | 1251 | from erpnext.controllers.status_updater import get_allowance_for |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1252 | |
Nabin Hait | 868766d | 2019-07-15 18:02:58 +0530 | [diff] [blame] | 1253 | item_allowance = {} |
| 1254 | global_qty_allowance, global_amount_allowance = None, None |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1255 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1256 | role_allowed_to_over_bill = frappe.db.get_single_value( |
| 1257 | "Accounts Settings", "role_allowed_to_over_bill" |
| 1258 | ) |
Ankush Menat | 648b2d7 | 2021-09-20 15:27:12 +0530 | [diff] [blame] | 1259 | user_roles = frappe.get_roles() |
| 1260 | |
Ankush Menat | 43bf82b | 2021-09-20 16:31:20 +0530 | [diff] [blame] | 1261 | total_overbilled_amt = 0.0 |
| 1262 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1263 | 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 Hait | 4b8185d | 2014-12-25 18:19:39 +0530 | [diff] [blame] | 1268 | for item in self.get("items"): |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1269 | if not item.get(item_ref_dn): |
| 1270 | continue |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1271 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1272 | ref_amt = flt(reference_details.get(item.get(item_ref_dn)), self.precision(based_on, item)) |
| 1273 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1274 | if not ref_amt: |
| 1275 | frappe.msgprint( |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1276 | _("System will not check over billing since amount for Item {0} in {1} is zero").format( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1277 | item.item_code, ref_dt |
| 1278 | ), |
| 1279 | title=_("Warning"), |
| 1280 | indicator="orange", |
| 1281 | ) |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1282 | continue |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1283 | |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1284 | already_billed = self.get_billed_amount_for_item(item, item_ref_dn, based_on) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1285 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1286 | total_billed_amt = flt( |
| 1287 | flt(already_billed) + flt(item.get(based_on)), self.precision(based_on, item) |
| 1288 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1289 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1290 | 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 | ) |
rohitwaghchaure | 285344e | 2019-10-11 11:02:11 +0530 | [diff] [blame] | 1293 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1294 | max_allowed_amt = flt(ref_amt * (100 + allowance) / 100) |
Deepesh Garg | cb718fc | 2021-04-19 13:25:15 +0530 | [diff] [blame] | 1295 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1296 | 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) |
Afshan | 53fefd7 | 2021-06-24 10:09:02 +0530 | [diff] [blame] | 1300 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1301 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1307 | elif not cint( |
| 1308 | frappe.db.get_single_value( |
| 1309 | "Buying Settings", "bill_for_rejected_quantity_in_purchase_invoice" |
| 1310 | ) |
| 1311 | ): |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1312 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1315 | 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 | ) |
Afshan | 53fefd7 | 2021-06-24 10:09:02 +0530 | [diff] [blame] | 1322 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1323 | 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 | |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1333 | def get_billed_amount_for_item(self, item, item_ref_dn, based_on): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1334 | """ |
| 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 | """ |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1340 | |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1351 | .where(join_field == item.get(item_ref_dn)) |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1352 | .where( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1353 | 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 | ) |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1370 | ) |
| 1371 | ).run() |
| 1372 | |
| 1373 | return result[0][0] if result else 0 |
| 1374 | |
Afshan | 53fefd7 | 2021-06-24 10:09:02 +0530 | [diff] [blame] | 1375 | def throw_overbill_exception(self, item, max_allowed_amt): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1376 | 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 Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1381 | |
Rohit Waghchaure | 2a14f25 | 2021-07-30 12:36:35 +0530 | [diff] [blame] | 1382 | def get_company_default(self, fieldname, ignore_validation=False): |
Rushabh Mehta | 1f84799 | 2013-12-12 19:12:19 +0530 | [diff] [blame] | 1383 | from erpnext.accounts.utils import get_company_default |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1384 | |
Rohit Waghchaure | 2a14f25 | 2021-07-30 12:36:35 +0530 | [diff] [blame] | 1385 | return get_company_default(self.company, fieldname, ignore_validation=ignore_validation) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1386 | |
Nabin Hait | a36adbd | 2013-08-02 14:50:12 +0530 | [diff] [blame] | 1387 | def get_stock_items(self): |
| 1388 | stock_items = [] |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 1389 | item_codes = list(set(item.item_code for item in self.get("items"))) |
Nabin Hait | a36adbd | 2013-08-02 14:50:12 +0530 | [diff] [blame] | 1390 | if item_codes: |
Saqib Ansari | 199a6da | 2022-03-31 11:41:52 +0530 | [diff] [blame] | 1391 | stock_items = frappe.db.get_values( |
| 1392 | "Item", {"name": ["in", item_codes], "is_stock_item": 1}, pluck="name", cache=True |
| 1393 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1394 | |
Nabin Hait | a36adbd | 2013-08-02 14:50:12 +0530 | [diff] [blame] | 1395 | return stock_items |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1396 | |
Ankit Javalkar | 8e7ca41 | 2014-09-12 15:18:53 +0530 | [diff] [blame] | 1397 | def set_total_advance_paid(self): |
ruthra kumar | 4487065 | 2022-11-01 10:11:38 +0530 | [diff] [blame] | 1398 | 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 kumar | bf76b85 | 2022-11-22 12:16:11 +0530 | [diff] [blame] | 1402 | .select(ple.account_currency, Abs(Sum(ple.amount_in_account_currency)).as_("amount")) |
ruthra kumar | 4487065 | 2022-11-01 10:11:38 +0530 | [diff] [blame] | 1403 | .where( |
| 1404 | (ple.against_voucher_type == self.doctype) |
| 1405 | & (ple.against_voucher_no == self.name) |
| 1406 | & (ple.party == party) |
ruthra kumar | bf76b85 | 2022-11-22 12:16:11 +0530 | [diff] [blame] | 1407 | & (ple.docstatus == 1) |
ruthra kumar | 4487065 | 2022-11-01 10:11:38 +0530 | [diff] [blame] | 1408 | & (ple.company == self.company) |
| 1409 | ) |
| 1410 | .run(as_dict=True) |
| 1411 | ) |
Ankit Javalkar | 8e7ca41 | 2014-09-12 15:18:53 +0530 | [diff] [blame] | 1412 | |
Nabin Hait | b2206d1 | 2016-01-27 15:43:12 +0530 | [diff] [blame] | 1413 | if advance: |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1414 | advance = advance[0] |
Deepesh Garg | 2a9c5ba | 2020-04-30 10:38:58 +0530 | [diff] [blame] | 1415 | |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1416 | advance_paid = flt(advance.amount, self.precision("advance_paid")) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1417 | formatted_advance_paid = fmt_money( |
| 1418 | advance_paid, precision=self.precision("advance_paid"), currency=advance.account_currency |
| 1419 | ) |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1420 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1421 | frappe.db.set_value(self.doctype, self.name, "party_account_currency", advance.account_currency) |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1422 | |
| 1423 | if advance.account_currency == self.currency: |
finbyz | 5efc797 | 2019-01-05 11:12:11 +0530 | [diff] [blame] | 1424 | order_total = self.get("rounded_total") or self.grand_total |
| 1425 | precision = "rounded_total" if self.get("rounded_total") else "grand_total" |
Nabin Hait | b2206d1 | 2016-01-27 15:43:12 +0530 | [diff] [blame] | 1426 | else: |
finbyz | 5efc797 | 2019-01-05 11:12:11 +0530 | [diff] [blame] | 1427 | 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 Vora | f733a39 | 2019-01-07 14:24:01 +0530 | [diff] [blame] | 1429 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1430 | formatted_order_total = fmt_money( |
| 1431 | order_total, precision=self.precision(precision), currency=advance.account_currency |
| 1432 | ) |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1433 | |
Nabin Hait | 9db1b22 | 2016-06-30 12:37:53 +0530 | [diff] [blame] | 1434 | if self.currency == self.company_currency and advance_paid > order_total: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1435 | 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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 1440 | |
Nabin Hait | 13093b4 | 2016-06-29 18:04:37 +0530 | [diff] [blame] | 1441 | frappe.db.set_value(self.doctype, self.name, "advance_paid", advance_paid) |
Ankit Javalkar | 8e7ca41 | 2014-09-12 15:18:53 +0530 | [diff] [blame] | 1442 | |
ankitjavalkarwork | e60822b | 2014-08-26 14:29:06 +0530 | [diff] [blame] | 1443 | @property |
| 1444 | def company_abbr(self): |
Nabin Hait | 6a5695f | 2018-08-09 11:30:21 +0530 | [diff] [blame] | 1445 | if not hasattr(self, "_abbr"): |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1446 | self._abbr = frappe.get_cached_value("Company", self.company, "abbr") |
ankitjavalkarwork | e60822b | 2014-08-26 14:29:06 +0530 | [diff] [blame] | 1447 | |
| 1448 | return self._abbr |
| 1449 | |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1450 | def raise_missing_debit_credit_account_error(self, party_type, party): |
marination | 53b1a9a | 2020-11-03 15:45:25 +0530 | [diff] [blame] | 1451 | """Raise an error if debit to/credit to account does not exist.""" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1452 | db_or_cr = ( |
| 1453 | frappe.bold("Debit To") if self.doctype == "Sales Invoice" else frappe.bold("Credit To") |
| 1454 | ) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1455 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1460 | message = _("{0} Account not found against Customer {1}.").format( |
| 1461 | db_or_cr, frappe.bold(party) or "" |
| 1462 | ) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1463 | message += "<br>" + _("Please set one of the following:") + "<br>" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1464 | 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 | ) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1474 | |
marination | 53b1a9a | 2020-11-03 15:45:25 +0530 | [diff] [blame] | 1475 | frappe.throw(message, title=_("Account Missing"), exc=AccountMissingError) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1476 | |
Neil Trini Lasrado | 3fbbb71 | 2015-07-17 12:10:12 +0530 | [diff] [blame] | 1477 | def validate_party(self): |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1478 | party_type, party = self.get_party() |
shreyas | eba9ca4 | 2016-01-26 14:56:52 +0530 | [diff] [blame] | 1479 | validate_party_frozen_disabled(party_type, party) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1480 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1481 | def get_party(self): |
Neil Trini Lasrado | 79bf233 | 2015-07-20 13:03:48 +0530 | [diff] [blame] | 1482 | party_type = None |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1483 | if self.doctype in ("Opportunity", "Quotation", "Sales Order", "Delivery Note", "Sales Invoice"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1484 | party_type = "Customer" |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1485 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1486 | elif self.doctype in ( |
| 1487 | "Supplier Quotation", |
| 1488 | "Purchase Order", |
| 1489 | "Purchase Receipt", |
| 1490 | "Purchase Invoice", |
| 1491 | ): |
| 1492 | party_type = "Supplier" |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1493 | |
| 1494 | elif self.meta.get_field("customer"): |
| 1495 | party_type = "Customer" |
Neil Trini Lasrado | 3fbbb71 | 2015-07-17 12:10:12 +0530 | [diff] [blame] | 1496 | |
Neil Trini Lasrado | 79bf233 | 2015-07-20 13:03:48 +0530 | [diff] [blame] | 1497 | elif self.meta.get_field("supplier"): |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1498 | party_type = "Supplier" |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1499 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1500 | party = self.get(party_type.lower()) if party_type else None |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1501 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1502 | return party_type, party |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1503 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1504 | def validate_currency(self): |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 1505 | if self.get("currency"): |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1506 | party_type, party = self.get_party() |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 1507 | if party_type and party: |
Anand Doshi | b20baf8 | 2015-09-25 16:17:50 +0530 | [diff] [blame] | 1508 | party_account_currency = get_party_account_currency(party_type, party, self.company) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1509 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1510 | 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 Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1521 | |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1522 | # 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 Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 1525 | |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1526 | def validate_party_account_currency(self): |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1527 | if self.doctype not in ("Sales Invoice", "Purchase Invoice"): |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1528 | return |
| 1529 | |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1530 | if self.is_opening == "Yes": |
Deepesh Garg | 60915e8 | 2021-08-21 23:05:48 +0530 | [diff] [blame] | 1531 | return |
| 1532 | |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1533 | party_type, party = self.get_party() |
| 1534 | party_gle_currency = get_party_gle_currency(party_type, party, self.company) |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1535 | party_account = ( |
| 1536 | self.get("debit_to") if self.doctype == "Sales Invoice" else self.get("credit_to") |
| 1537 | ) |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1538 | party_account_currency = get_account_currency(party_account) |
Deepesh Garg | e04e67c | 2022-07-11 19:25:18 +0530 | [diff] [blame] | 1539 | allow_multi_currency_invoices_against_single_party_account = frappe.db.get_singles_value( |
Deepesh Garg | 3cf609f | 2022-07-11 13:46:59 +0530 | [diff] [blame] | 1540 | "Accounts Settings", "allow_multi_currency_invoices_against_single_party_account" |
| 1541 | ) |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1542 | |
Deepesh Garg | 3cf609f | 2022-07-11 13:46:59 +0530 | [diff] [blame] | 1543 | 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 Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1548 | frappe.throw( |
Devin Slauenwhite | 3a1c923 | 2022-06-02 14:15:50 -0400 | [diff] [blame] | 1549 | _("Party Account {0} currency ({1}) and document currency ({2}) should be same").format( |
Devin Slauenwhite | b061ea4 | 2022-06-02 14:23:54 -0400 | [diff] [blame] | 1550 | frappe.bold(party_account), party_account_currency, self.currency |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1551 | ) |
| 1552 | ) |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1553 | |
Nabin Hait | 297d74a | 2016-11-23 15:58:51 +0530 | [diff] [blame] | 1554 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1559 | frappe.db.sql( |
| 1560 | """delete from `tab{0} Advance` |
| 1561 | where name = %s""".format( |
| 1562 | self.doctype |
| 1563 | ), |
| 1564 | adv.name, |
| 1565 | ) |
Nabin Hait | 297d74a | 2016-11-23 15:58:51 +0530 | [diff] [blame] | 1566 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1571 | frappe.db.set_value( |
| 1572 | self.doctype, self.name, "total_advance", total_allocated_amount, update_modified=False |
| 1573 | ) |
Rohit Waghchaure | 6087fe1 | 2016-04-09 14:31:09 +0530 | [diff] [blame] | 1574 | |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1575 | def group_similar_items(self): |
| 1576 | group_item_qty = {} |
| 1577 | group_item_amount = {} |
Shreya Shah | 785f1aa | 2018-10-11 10:14:25 +0530 | [diff] [blame] | 1578 | # to update serial number in print |
| 1579 | count = 0 |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1580 | |
| 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 = [] |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1586 | for item in self.items: |
| 1587 | if item.item_code in group_item_qty: |
Shreya Shah | 785f1aa | 2018-10-11 10:14:25 +0530 | [diff] [blame] | 1588 | count += 1 |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1589 | item.qty = group_item_qty[item.item_code] |
| 1590 | item.amount = group_item_amount[item.item_code] |
deepeshgarg007 | e8d21cd | 2019-06-24 17:46:44 +0530 | [diff] [blame] | 1591 | |
| 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 Shah | 785f1aa | 2018-10-11 10:14:25 +0530 | [diff] [blame] | 1597 | item.idx = count |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1598 | del group_item_qty[item.item_code] |
| 1599 | else: |
| 1600 | duplicate_list.append(item) |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1601 | for item in duplicate_list: |
| 1602 | self.remove(item) |
| 1603 | |
tunde | 32aa7c1 | 2017-09-07 06:52:15 +0100 | [diff] [blame] | 1604 | def set_payment_schedule(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1605 | if self.doctype == "Sales Invoice" and self.is_pos: |
| 1606 | self.payment_terms_template = "" |
Manas Solanki | a7f5589 | 2018-04-02 10:32:00 +0530 | [diff] [blame] | 1607 | return |
rohitwaghchaure | db9fa78 | 2018-03-01 10:32:29 +0530 | [diff] [blame] | 1608 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1609 | party_account_currency = self.get("party_account_currency") |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1610 | 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 | |
rohitwaghchaure | da941af | 2018-01-17 16:23:04 +0530 | [diff] [blame] | 1616 | posting_date = self.get("bill_date") or self.get("posting_date") or self.get("transaction_date") |
tunde | df3a175 | 2017-09-11 11:02:57 +0100 | [diff] [blame] | 1617 | date = self.get("due_date") |
| 1618 | due_date = date or posting_date |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1619 | |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1620 | 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 Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 1622 | automatically_fetch_payment_terms = 0 |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1623 | |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 1624 | if self.doctype in ("Sales Invoice", "Purchase Invoice"): |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1625 | base_grand_total = base_grand_total - flt(self.base_write_off_amount) |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 1626 | grand_total = grand_total - flt(self.write_off_amount) |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1627 | po_or_so, doctype, fieldname = self.get_order_details() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1628 | automatically_fetch_payment_terms = cint( |
| 1629 | frappe.db.get_single_value("Accounts Settings", "automatically_fetch_payment_terms") |
| 1630 | ) |
tunde | 96b8f22 | 2017-09-08 15:35:59 +0100 | [diff] [blame] | 1631 | |
Rohit Waghchaure | 4a267b9 | 2019-05-09 19:50:00 +0530 | [diff] [blame] | 1632 | if self.get("total_advance"): |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1633 | if party_account_currency == self.company_currency: |
| 1634 | base_grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1635 | grand_total = flt( |
| 1636 | base_grand_total / self.get("conversion_rate"), self.precision("grand_total") |
| 1637 | ) |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1638 | else: |
| 1639 | grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1640 | base_grand_total = flt( |
| 1641 | grand_total * self.get("conversion_rate"), self.precision("base_grand_total") |
| 1642 | ) |
Rohit Waghchaure | 4a267b9 | 2019-05-09 19:50:00 +0530 | [diff] [blame] | 1643 | |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1644 | if not self.get("payment_schedule"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1645 | 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 Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1650 | self.fetch_payment_terms_from_order(po_or_so, doctype) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1651 | if self.get("payment_terms_template"): |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1652 | self.ignore_default_payment_terms_template = 1 |
| 1653 | elif self.get("payment_terms_template"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1654 | data = get_payment_terms( |
| 1655 | self.payment_terms_template, posting_date, grand_total, base_grand_total |
| 1656 | ) |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1657 | for item in data: |
| 1658 | self.append("payment_schedule", item) |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1659 | elif self.doctype not in ["Purchase Receipt"]: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1660 | 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 Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1666 | self.append("payment_schedule", data) |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1667 | |
Deepesh Garg | f7b50f2 | 2023-04-25 19:18:45 +0530 | [diff] [blame] | 1668 | if not ( |
| 1669 | automatically_fetch_payment_terms |
| 1670 | and self.linked_order_has_payment_terms(po_or_so, fieldname, doctype) |
| 1671 | ): |
Deepesh Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 1672 | 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 kumar | 0da6c16 | 2023-05-16 18:57:42 +0530 | [diff] [blame] | 1685 | else: |
| 1686 | self.fetch_payment_terms_from_order(po_or_so, doctype) |
| 1687 | self.ignore_default_payment_terms_template = 1 |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1688 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1689 | def get_order_details(self): |
| 1690 | if self.doctype == "Sales Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1691 | po_or_so = self.get("items")[0].get("sales_order") |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1692 | po_or_so_doctype = "Sales Order" |
| 1693 | po_or_so_doctype_name = "sales_order" |
| 1694 | |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1695 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1696 | po_or_so = self.get("items")[0].get("purchase_order") |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1697 | po_or_so_doctype = "Purchase Order" |
| 1698 | po_or_so_doctype_name = "purchase_order" |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1699 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1700 | return po_or_so, po_or_so_doctype, po_or_so_doctype_name |
| 1701 | |
GangaManoj | c7c9024 | 2021-07-29 19:18:35 +0530 | [diff] [blame] | 1702 | def linked_order_has_payment_terms(self, po_or_so, fieldname, doctype): |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1703 | if po_or_so and self.all_items_have_same_po_or_so(po_or_so, fieldname): |
GangaManoj | c7c9024 | 2021-07-29 19:18:35 +0530 | [diff] [blame] | 1704 | if self.linked_order_has_payment_terms_template(po_or_so, doctype): |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1705 | return True |
| 1706 | elif self.linked_order_has_payment_schedule(po_or_so): |
| 1707 | return True |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1708 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1709 | return False |
| 1710 | |
| 1711 | def all_items_have_same_po_or_so(self, po_or_so, fieldname): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1712 | for item in self.get("items"): |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1713 | if item.get(fieldname) != po_or_so: |
| 1714 | return False |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1715 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1716 | return True |
| 1717 | |
GangaManoj | c7c9024 | 2021-07-29 19:18:35 +0530 | [diff] [blame] | 1718 | def linked_order_has_payment_terms_template(self, po_or_so, doctype): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1719 | return frappe.get_value(doctype, po_or_so, "payment_terms_template") |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1720 | |
| 1721 | def linked_order_has_payment_schedule(self, po_or_so): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1722 | return frappe.get_all("Payment Schedule", filters={"parent": po_or_so}) |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1723 | |
| 1724 | def fetch_payment_terms_from_order(self, po_or_so, po_or_so_doctype): |
| 1725 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1726 | Fetch Payment Terms from Purchase/Sales Order on creating a new Purchase/Sales Invoice. |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1727 | """ |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1735 | "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 Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 1740 | "payment_amount": schedule.payment_amount, |
| 1741 | "base_payment_amount": schedule.base_payment_amount, |
| 1742 | "outstanding": schedule.outstanding, |
| 1743 | "paid_amount": schedule.paid_amount, |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1744 | } |
GangaManoj | 5b33e75 | 2021-08-05 21:50:09 +0530 | [diff] [blame] | 1745 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1746 | if schedule.discount_type == "Percentage": |
| 1747 | payment_schedule["discount_type"] = schedule.discount_type |
| 1748 | payment_schedule["discount"] = schedule.discount |
GangaManoj | 5b33e75 | 2021-08-05 21:50:09 +0530 | [diff] [blame] | 1749 | |
ruthra kumar | 9bd56b0 | 2022-02-01 14:14:04 +0530 | [diff] [blame] | 1750 | if not schedule.invoice_portion: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1751 | payment_schedule["payment_amount"] = schedule.payment_amount |
ruthra kumar | 9bd56b0 | 2022-02-01 14:14:04 +0530 | [diff] [blame] | 1752 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1753 | self.append("payment_schedule", payment_schedule) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1754 | |
tunde | be1b871 | 2017-08-19 08:21:44 +0100 | [diff] [blame] | 1755 | def set_due_date(self): |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1756 | 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) |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 1759 | |
| 1760 | def validate_payment_schedule_dates(self): |
tunde | 77ecacc | 2017-09-22 23:12:55 +0100 | [diff] [blame] | 1761 | dates = [] |
tunde | 9bed2de | 2017-09-25 10:19:35 +0100 | [diff] [blame] | 1762 | li = [] |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1763 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1764 | if self.doctype == "Sales Invoice" and self.is_pos: |
| 1765 | return |
rohitwaghchaure | db9fa78 | 2018-03-01 10:32:29 +0530 | [diff] [blame] | 1766 | |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1767 | for d in self.get("payment_schedule"): |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 1768 | if self.doctype == "Sales Order" and getdate(d.due_date) < getdate(self.transaction_date): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1769 | frappe.throw( |
| 1770 | _("Row {0}: Due Date in the Payment Terms table cannot be before Posting Date").format(d.idx) |
| 1771 | ) |
tunde | 77ecacc | 2017-09-22 23:12:55 +0100 | [diff] [blame] | 1772 | elif d.due_date in dates: |
mnatalia | 5f0e8d6 | 2018-05-22 06:38:50 +0300 | [diff] [blame] | 1773 | li.append(_("{0} in row {1}").format(d.due_date, d.idx)) |
tunde | 9bed2de | 2017-09-25 10:19:35 +0100 | [diff] [blame] | 1774 | dates.append(d.due_date) |
| 1775 | |
| 1776 | if li: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1777 | duplicates = "<br>" + "<br>".join(li) |
| 1778 | frappe.throw( |
| 1779 | _("Rows with duplicate due dates in other rows were found: {0}").format(duplicates) |
| 1780 | ) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1781 | |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 1782 | def validate_payment_schedule_amount(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1783 | if self.doctype == "Sales Invoice" and self.is_pos: |
| 1784 | return |
rohitwaghchaure | db9fa78 | 2018-03-01 10:32:29 +0530 | [diff] [blame] | 1785 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1786 | party_account_currency = self.get("party_account_currency") |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1787 | 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 Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1793 | if self.get("payment_schedule"): |
| 1794 | total = 0 |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1795 | base_total = 0 |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1796 | for d in self.get("payment_schedule"): |
Deepesh Garg | 9c17052 | 2021-10-25 20:06:24 +0530 | [diff] [blame] | 1797 | total += flt(d.payment_amount, d.precision("payment_amount")) |
| 1798 | base_total += flt(d.base_payment_amount, d.precision("base_payment_amount")) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1799 | |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1800 | 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 Waghchaure | 4a267b9 | 2019-05-09 19:50:00 +0530 | [diff] [blame] | 1802 | |
Nabin Hait | e591c85 | 2017-12-21 11:46:30 +0530 | [diff] [blame] | 1803 | if self.doctype in ("Sales Invoice", "Purchase Invoice"): |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1804 | base_grand_total = base_grand_total - flt(self.base_write_off_amount) |
Nabin Hait | e591c85 | 2017-12-21 11:46:30 +0530 | [diff] [blame] | 1805 | grand_total = grand_total - flt(self.write_off_amount) |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1806 | |
| 1807 | if self.get("total_advance"): |
| 1808 | if party_account_currency == self.company_currency: |
| 1809 | base_grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1810 | grand_total = flt( |
| 1811 | base_grand_total / self.get("conversion_rate"), self.precision("grand_total") |
| 1812 | ) |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1813 | else: |
| 1814 | grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1815 | base_grand_total = flt( |
| 1816 | grand_total * self.get("conversion_rate"), self.precision("base_grand_total") |
| 1817 | ) |
Deepesh Garg | 9c17052 | 2021-10-25 20:06:24 +0530 | [diff] [blame] | 1818 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1819 | 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 | ) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1829 | |
Nabin Hait | 877e1bb | 2017-11-17 12:27:43 +0530 | [diff] [blame] | 1830 | 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 Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1836 | def set_inter_company_account(self): |
| 1837 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1838 | 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 Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1841 | """ |
| 1842 | |
| 1843 | if self.is_internal_transfer() and not self.unrealized_profit_loss_account: |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1844 | unrealized_profit_loss_account = frappe.get_cached_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1845 | "Company", self.company, "unrealized_profit_loss_account" |
| 1846 | ) |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1847 | |
| 1848 | if not unrealized_profit_loss_account: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1849 | 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 Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1852 | frappe.throw(msg) |
| 1853 | |
| 1854 | self.unrealized_profit_loss_account = unrealized_profit_loss_account |
| 1855 | |
| 1856 | def is_internal_transfer(self): |
| 1857 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1858 | It will an internal transfer if its an internal customer and representation |
| 1859 | company is same as billing company |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1860 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1861 | 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 Menat | 3714e36 | 2022-05-16 18:09:14 +0530 | [diff] [blame] | 1865 | else: |
| 1866 | return False |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1867 | |
| 1868 | if self.get(internal_party_field) and (self.represents_company == self.company): |
| 1869 | return True |
| 1870 | |
| 1871 | return False |
| 1872 | |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1873 | def process_common_party_accounting(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1874 | is_invoice = self.doctype in ["Sales Invoice", "Purchase Invoice"] |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1875 | if not is_invoice: |
| 1876 | return |
| 1877 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1878 | if frappe.db.get_single_value("Accounts Settings", "enable_common_party_accounting"): |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1879 | 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 Ansari | 7254368 | 2021-08-25 20:15:23 +0530 | [diff] [blame] | 1885 | return frappe.db.get_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1886 | doctype="Party Link", |
| 1887 | filters={"secondary_role": party_type, "secondary_party": party}, |
| 1888 | fieldname=["primary_role", "primary_party"], |
| 1889 | as_dict=True, |
Saqib Ansari | 7254368 | 2021-08-25 20:15:23 +0530 | [diff] [blame] | 1890 | ) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1891 | |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1899 | jv = frappe.new_doc("Journal Entry") |
| 1900 | jv.voucher_type = "Journal Entry" |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1901 | jv.posting_date = self.posting_date |
| 1902 | jv.company = self.company |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1903 | jv.remark = "Adjustment for {} {}".format(self.doctype, self.name) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1904 | |
| 1905 | reconcilation_entry = frappe._dict() |
| 1906 | advance_entry = frappe._dict() |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1907 | |
| 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 Garg | f88431a | 2023-04-25 20:54:22 +0530 | [diff] [blame] | 1913 | reconcilation_entry.cost_center = self.cost_center or erpnext.get_default_cost_center( |
| 1914 | self.company |
| 1915 | ) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1916 | |
| 1917 | advance_entry.account = primary_account |
| 1918 | advance_entry.party_type = primary_party_type |
| 1919 | advance_entry.party = primary_party |
Deepesh Garg | f88431a | 2023-04-25 20:54:22 +0530 | [diff] [blame] | 1920 | advance_entry.cost_center = self.cost_center or erpnext.get_default_cost_center(self.company) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1921 | advance_entry.is_advance = "Yes" |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1922 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1923 | if self.doctype == "Sales Invoice": |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1924 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1930 | jv.append("accounts", reconcilation_entry) |
| 1931 | jv.append("accounts", advance_entry) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1932 | |
| 1933 | jv.save() |
| 1934 | jv.submit() |
| 1935 | |
Deepesh Garg | d05d153 | 2022-06-14 12:50:49 +0530 | [diff] [blame] | 1936 | 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 Rehman | 7a5d75b | 2021-09-13 23:01:52 +0500 | [diff] [blame] | 1947 | def check_finance_books(self, item, asset): |
Nabin Hait | fefe950 | 2022-09-09 14:40:36 +0530 | [diff] [blame] | 1948 | 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 Rehman | 7a5d75b | 2021-09-13 23:01:52 +0500 | [diff] [blame] | 1957 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1958 | |
Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 1959 | @frappe.whitelist() |
Rushabh Mehta | f56d73c | 2013-10-10 16:35:09 +0530 | [diff] [blame] | 1960 | def get_tax_rate(account_head): |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1961 | return frappe.get_cached_value( |
| 1962 | "Account", account_head, ["tax_rate", "account_name"], as_dict=True |
| 1963 | ) |
Rushabh Mehta | a33d468 | 2015-06-01 17:15:42 +0530 | [diff] [blame] | 1964 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 1965 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 1966 | @frappe.whitelist() |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 1967 | def get_default_taxes_and_charges(master_doctype, tax_template=None, company=None): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1968 | if not company: |
| 1969 | return {} |
rohitwaghchaure | 505661b | 2017-12-11 14:52:28 +0530 | [diff] [blame] | 1970 | |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 1971 | if tax_template and company: |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1972 | tax_template_company = frappe.get_cached_value(master_doctype, tax_template, "company") |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 1973 | if tax_template_company == company: |
| 1974 | return |
| 1975 | |
| 1976 | default_tax = frappe.db.get_value(master_doctype, {"is_default": 1, "company": company}) |
rohitwaghchaure | 505661b | 2017-12-11 14:52:28 +0530 | [diff] [blame] | 1977 | |
Rushabh Mehta | 98aa581 | 2017-11-14 09:32:32 +0530 | [diff] [blame] | 1978 | return { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1979 | "taxes_and_charges": default_tax, |
| 1980 | "taxes": get_taxes_and_charges(master_doctype, default_tax), |
Rushabh Mehta | 98aa581 | 2017-11-14 09:32:32 +0530 | [diff] [blame] | 1981 | } |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 1982 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 1983 | |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 1984 | @frappe.whitelist() |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 1985 | def get_taxes_and_charges(master_doctype, master_name): |
Nabin Hait | 1fe5012 | 2015-05-16 12:14:39 +0530 | [diff] [blame] | 1986 | if not master_name: |
| 1987 | return |
Ankush Menat | 77dcdff | 2022-06-01 22:01:07 +0530 | [diff] [blame] | 1988 | from frappe.model import child_table_fields, default_fields |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1989 | |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 1990 | tax_master = frappe.get_doc(master_doctype, master_name) |
| 1991 | |
| 1992 | taxes_and_charges = [] |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 1993 | for i, tax in enumerate(tax_master.get("taxes")): |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 1994 | tax = tax.as_dict() |
| 1995 | |
Ankush Menat | 77dcdff | 2022-06-01 22:01:07 +0530 | [diff] [blame] | 1996 | for fieldname in default_fields + child_table_fields: |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 1997 | if fieldname in tax: |
| 1998 | del tax[fieldname] |
| 1999 | |
| 2000 | taxes_and_charges.append(tax) |
| 2001 | |
| 2002 | return taxes_and_charges |
Rushabh Mehta | 66e08e3 | 2014-09-29 12:17:03 +0530 | [diff] [blame] | 2003 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2004 | |
Rushabh Mehta | 66e08e3 | 2014-09-29 12:17:03 +0530 | [diff] [blame] | 2005 | def validate_conversion_rate(currency, conversion_rate, conversion_rate_label, company): |
| 2006 | """common validation for currency and price list currency""" |
| 2007 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2008 | company_currency = frappe.get_cached_value("Company", company, "default_currency") |
Rushabh Mehta | 66e08e3 | 2014-09-29 12:17:03 +0530 | [diff] [blame] | 2009 | |
| 2010 | if not conversion_rate: |
Saqib | 60212ff | 2020-10-26 11:17:04 +0530 | [diff] [blame] | 2011 | throw( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2012 | _("{0} is mandatory. Maybe Currency Exchange record is not created for {1} to {2}.").format( |
| 2013 | conversion_rate_label, currency, company_currency |
| 2014 | ) |
Saqib | 60212ff | 2020-10-26 11:17:04 +0530 | [diff] [blame] | 2015 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2016 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2017 | |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2018 | def validate_taxes_and_charges(tax): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2019 | 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 Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2024 | if cint(tax.idx) == 1: |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2025 | frappe.throw( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2026 | _( |
| 2027 | "Cannot select charge type as 'On Previous Row Amount' or 'On Previous Row Total' for first row" |
| 2028 | ) |
| 2029 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2030 | elif not tax.row_id: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2031 | frappe.throw( |
| 2032 | _("Please specify a valid Row ID for row {0} in table {1}").format(tax.idx, _(tax.doctype)) |
| 2033 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2034 | elif tax.row_id and cint(tax.row_id) >= cint(tax.idx): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2035 | frappe.throw( |
| 2036 | _("Cannot refer row number greater than or equal to current row number for this Charge type") |
| 2037 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2038 | |
Rushabh Mehta | 2a21bc9 | 2015-02-25 15:08:42 +0530 | [diff] [blame] | 2039 | if tax.charge_type == "Actual": |
Nabin Hait | bc6c360 | 2015-02-27 23:40:56 +0530 | [diff] [blame] | 2040 | tax.rate = None |
Rushabh Mehta | 2a21bc9 | 2015-02-25 15:08:42 +0530 | [diff] [blame] | 2041 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2042 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2043 | def validate_account_head(idx, account, company, context=""): |
| 2044 | account_company = frappe.get_cached_value("Account", account, "company") |
Anuja Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2045 | |
Deepesh Garg | 5a2b571 | 2022-02-18 20:05:49 +0530 | [diff] [blame] | 2046 | if account_company != company: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2047 | 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 Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2053 | |
| 2054 | |
| 2055 | def validate_cost_center(tax, doc): |
| 2056 | if not tax.cost_center: |
| 2057 | return |
| 2058 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2059 | company = frappe.get_cached_value("Cost Center", tax.cost_center, "company") |
Anuja Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2060 | |
| 2061 | if company != doc.company: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2062 | 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 Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2068 | |
| 2069 | |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2070 | def validate_inclusive_tax(tax, doc): |
| 2071 | def _on_previous_row_error(row_range): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2072 | 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 Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2077 | |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2081 | 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 Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2089 | # referred row should also be inclusive |
| 2090 | _on_previous_row_error(tax.row_id) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2091 | 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 Garg | 5ef9a62 | 2021-06-14 14:34:44 +0530 | [diff] [blame] | 2094 | # all rows about the referred tax should be inclusive |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2095 | _on_previous_row_error("1 - %d" % (tax.row_id,)) |
Nabin Hait | 93b3a37 | 2015-02-24 17:08:34 +0530 | [diff] [blame] | 2096 | elif tax.get("category") == "Valuation": |
Nabin Hait | 19ea721 | 2020-08-11 20:34:57 +0530 | [diff] [blame] | 2097 | frappe.throw(_("Valuation type charges can not be marked as Inclusive")) |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2098 | |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2099 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2100 | def set_balance_in_account_currency( |
| 2101 | gl_dict, account_currency=None, conversion_rate=None, company_currency=None |
| 2102 | ): |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2103 | if (not conversion_rate) and (account_currency != company_currency): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2104 | frappe.throw( |
| 2105 | _("Account: {0} with currency: {1} can not be selected").format( |
| 2106 | gl_dict.account, account_currency |
| 2107 | ) |
| 2108 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2109 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2110 | gl_dict["account_currency"] = ( |
| 2111 | company_currency if account_currency == company_currency else account_currency |
| 2112 | ) |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2113 | |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2116 | gl_dict.debit_in_account_currency = ( |
| 2117 | gl_dict.debit |
| 2118 | if account_currency == company_currency |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2119 | else flt(gl_dict.debit / conversion_rate, 2) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2120 | ) |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2121 | |
| 2122 | if flt(gl_dict.credit) and not flt(gl_dict.credit_in_account_currency): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2123 | gl_dict.credit_in_account_currency = ( |
| 2124 | gl_dict.credit |
| 2125 | if account_currency == company_currency |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2126 | else flt(gl_dict.credit / conversion_rate, 2) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2127 | ) |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2128 | |
| 2129 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2130 | def 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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2142 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2143 | conditions = [] |
| 2144 | if include_unallocated: |
| 2145 | conditions.append("ifnull(t2.reference_name, '')=''") |
| 2146 | |
| 2147 | if order_list: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2148 | 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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2154 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2155 | reference_condition = " and (" + " or ".join(conditions) + ")" if conditions else "" |
Rushabh Mehta | 6695830 | 2017-01-16 16:57:53 +0530 | [diff] [blame] | 2156 | |
Deepesh Garg | c38be53 | 2022-04-14 13:26:47 +0530 | [diff] [blame] | 2157 | # nosemgrep |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2158 | journal_entries = frappe.db.sql( |
| 2159 | """ |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2160 | select |
Conor | 74a782d | 2022-06-17 06:31:27 -0500 | [diff] [blame] | 2161 | 'Journal Entry' as reference_type, t1.name as reference_name, |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2162 | t1.remark as remarks, t2.{0} as amount, t2.name as reference_row, |
Deepesh Garg | 31883b6 | 2022-04-13 20:52:25 +0530 | [diff] [blame] | 2163 | t2.reference_name as against_order, t2.exchange_rate |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2164 | 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 Hait | ca627fb | 2016-09-05 16:16:53 +0530 | [diff] [blame] | 2170 | and {1} > 0 {2} |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2171 | 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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2177 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2178 | return list(journal_entries) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2179 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2180 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2181 | def 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 Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2192 | party_account_field = "paid_from" if party_type == "Customer" else "paid_to" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2193 | currency_field = ( |
| 2194 | "paid_from_account_currency" if party_type == "Customer" else "paid_to_account_currency" |
| 2195 | ) |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2196 | payment_type = "Receive" if party_type == "Customer" else "Pay" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2197 | exchange_rate_field = ( |
| 2198 | "source_exchange_rate" if payment_type == "Receive" else "target_exchange_rate" |
| 2199 | ) |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 2200 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2201 | payment_entries_against_order, unallocated_payment_entries = [], [] |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 2202 | limit_cond = "limit %s" % limit if limit else "" |
Nabin Hait | ff2f3ef | 2016-07-04 11:41:14 +0530 | [diff] [blame] | 2203 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2204 | if order_list or against_all_orders: |
| 2205 | if order_list: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2206 | reference_condition = " and t2.reference_name in ({0})".format( |
| 2207 | ", ".join(["%s"] * len(order_list)) |
| 2208 | ) |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2209 | else: |
| 2210 | reference_condition = "" |
| 2211 | order_list = [] |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2212 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2213 | payment_entries_against_order = frappe.db.sql( |
| 2214 | """ |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2215 | select |
Conor | 74a782d | 2022-06-17 06:31:27 -0500 | [diff] [blame] | 2216 | 'Payment Entry' as reference_type, t1.name as reference_name, |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2217 | t1.remarks, t2.allocated_amount as amount, t2.name as reference_row, |
Deepesh Garg | c7eadfc | 2020-07-22 17:59:37 +0530 | [diff] [blame] | 2218 | t2.reference_name as against_order, t1.posting_date, |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 2219 | t1.{0} as currency, t1.{4} as exchange_rate |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2220 | from `tabPayment Entry` t1, `tabPayment Entry Reference` t2 |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2221 | where |
Deepesh Garg | c7eadfc | 2020-07-22 17:59:37 +0530 | [diff] [blame] | 2222 | t1.name = t2.parent and t1.{1} = %s and t1.payment_type = %s |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2223 | and t1.party_type = %s and t1.party = %s and t1.docstatus = 1 |
Deepesh Garg | c7eadfc | 2020-07-22 17:59:37 +0530 | [diff] [blame] | 2224 | and t2.reference_doctype = %s {2} |
| 2225 | order by t1.posting_date {3} |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2226 | """.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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2232 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2233 | if include_unallocated: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2234 | unallocated_payment_entries = frappe.db.sql( |
| 2235 | """ |
Conor | 74a782d | 2022-06-17 06:31:27 -0500 | [diff] [blame] | 2236 | select 'Payment Entry' as reference_type, name as reference_name, posting_date, |
Anuja Pawar | 3e404f1 | 2021-08-31 18:59:29 +0530 | [diff] [blame] | 2237 | remarks, unallocated_amount as amount, {2} as exchange_rate, {3} as currency |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2238 | from `tabPayment Entry` |
| 2239 | where |
| 2240 | {0} = %s and party_type = %s and party = %s and payment_type = %s |
Anuja Pawar | 3e404f1 | 2021-08-31 18:59:29 +0530 | [diff] [blame] | 2241 | and docstatus = 1 and unallocated_amount > 0 {condition} |
Rohit Waghchaure | f725816 | 2019-01-15 18:12:04 +0530 | [diff] [blame] | 2242 | order by posting_date {1} |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2243 | """.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 Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2249 | |
Rohit Waghchaure | 2f1db57 | 2016-11-08 12:39:33 +0530 | [diff] [blame] | 2250 | return list(payment_entries_against_order) + list(unallocated_payment_entries) |
| 2251 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2252 | |
Rohit Waghchaure | 2f1db57 | 2016-11-08 12:39:33 +0530 | [diff] [blame] | 2253 | def update_invoice_status(): |
Sagar Vora | c8b9a55 | 2021-09-22 12:11:35 +0530 | [diff] [blame] | 2254 | """Updates status as Overdue for applicable invoices. Runs daily.""" |
Sagar Vora | 8d9d098 | 2021-10-20 19:15:35 +0530 | [diff] [blame] | 2255 | today = getdate() |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2256 | payment_schedule = frappe.qb.DocType("Payment Schedule") |
Sagar Vora | c8b9a55 | 2021-09-22 12:11:35 +0530 | [diff] [blame] | 2257 | for doctype in ("Sales Invoice", "Purchase Invoice"): |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2258 | 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 Vora | 8d9d098 | 2021-10-20 19:15:35 +0530 | [diff] [blame] | 2265 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2266 | |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2267 | payable_amount = ( |
| 2268 | frappe.qb.from_(payment_schedule) |
| 2269 | .select(Sum(payment_amount)) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2270 | .where((payment_schedule.parent == invoice.name) & (payment_schedule.due_date < today)) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2271 | ) |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2285 | total_amount = frappe.qb.terms.Case().when(consider_base_amount, base_total).else_(total) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2286 | |
| 2287 | is_overdue = total_amount - invoice.outstanding_amount < payable_amount |
| 2288 | |
| 2289 | conditions = ( |
| 2290 | (invoice.docstatus == 1) |
| 2291 | & (invoice.outstanding_amount > 0) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2292 | & (invoice.status.like("Unpaid%") | invoice.status.like("Partly Paid%")) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2293 | & ( |
Pruthvi Patel | 16a90d3 | 2021-12-20 13:24:19 +0530 | [diff] [blame] | 2294 | ((invoice.is_pos & invoice.due_date < today) | is_overdue) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2295 | if doctype == "Sales Invoice" |
| 2296 | else is_overdue |
| 2297 | ) |
| 2298 | ) |
| 2299 | |
Pruthvi Patel | 0799f37 | 2021-11-12 12:56:29 +0530 | [diff] [blame] | 2300 | 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 Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2307 | |
| 2308 | |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2309 | @frappe.whitelist() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2310 | def get_payment_terms( |
| 2311 | terms_template, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None |
| 2312 | ): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2313 | if not terms_template: |
| 2314 | return |
| 2315 | |
| 2316 | terms_doc = frappe.get_doc("Payment Terms Template", terms_template) |
| 2317 | |
| 2318 | schedule = [] |
tunde | fb14430 | 2017-08-19 15:01:40 +0100 | [diff] [blame] | 2319 | for d in terms_doc.get("terms"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2320 | term_details = get_payment_term_details( |
| 2321 | d, posting_date, grand_total, base_grand_total, bill_date |
| 2322 | ) |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2323 | schedule.append(term_details) |
| 2324 | |
| 2325 | return schedule |
| 2326 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2327 | |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2328 | @frappe.whitelist() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2329 | def get_payment_term_details( |
| 2330 | term, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None |
| 2331 | ): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2332 | term_details = frappe._dict() |
Ankush Menat | 8fe5feb | 2021-11-04 19:48:32 +0530 | [diff] [blame] | 2333 | if isinstance(term, str): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2334 | 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 Waghchaure | 52bf56d | 2017-11-27 11:43:52 +0530 | [diff] [blame] | 2339 | term_details.payment_amount = flt(term.invoice_portion) * flt(grand_total) / 100 |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 2340 | term_details.base_payment_amount = flt(term.invoice_portion) * flt(base_grand_total) / 100 |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2341 | term_details.discount_type = term.discount_type |
| 2342 | term_details.discount = term.discount |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2343 | term_details.outstanding = term_details.payment_amount |
| 2344 | term_details.mode_of_payment = term.mode_of_payment |
| 2345 | |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2346 | if bill_date: |
| 2347 | term_details.due_date = get_due_date(term, bill_date) |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2348 | term_details.discount_date = get_discount_date(term, bill_date) |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2349 | elif posting_date: |
| 2350 | term_details.due_date = get_due_date(term, posting_date) |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2351 | term_details.discount_date = get_discount_date(term, posting_date) |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2352 | |
| 2353 | if getdate(term_details.due_date) < getdate(posting_date): |
| 2354 | term_details.due_date = posting_date |
| 2355 | |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2356 | return term_details |
| 2357 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2358 | |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2359 | def get_due_date(term, posting_date=None, bill_date=None): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2360 | due_date = None |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2361 | date = bill_date or posting_date |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2362 | if term.due_date_based_on == "Day(s) after invoice date": |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2363 | due_date = add_days(date, term.credit_days) |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2364 | elif term.due_date_based_on == "Day(s) after the end of the invoice month": |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2365 | due_date = add_days(get_last_day(date), term.credit_days) |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2366 | elif term.due_date_based_on == "Month(s) after the end of the invoice month": |
Deepesh Garg | bfb81ef | 2022-11-30 20:53:41 +0530 | [diff] [blame] | 2367 | due_date = get_last_day(add_months(date, term.credit_months)) |
tunde | 96b8f22 | 2017-09-08 15:35:59 +0100 | [diff] [blame] | 2368 | return due_date |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2369 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2370 | |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2371 | def 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 Garg | bfb81ef | 2022-11-30 20:53:41 +0530 | [diff] [blame] | 2379 | discount_validity = get_last_day(add_months(date, term.discount_validity)) |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2380 | return discount_validity |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2381 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2382 | |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2383 | def 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2388 | supplier = frappe.get_doc("Supplier", party_name) |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2389 | info = { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2390 | "on_hold": supplier.on_hold, |
| 2391 | "release_date": supplier.release_date, |
| 2392 | "hold_type": supplier.hold_type, |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2393 | } |
| 2394 | return info |
| 2395 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2396 | |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2397 | def set_child_tax_template_and_map(item, child_item, parent_doc): |
| 2398 | args = { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2399 | "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 | } |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2404 | |
| 2405 | child_item.item_tax_template = _get_item_tax_template(args, item.taxes) |
| 2406 | if child_item.get("item_tax_template"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2407 | child_item.item_tax_rate = get_item_tax_map( |
| 2408 | parent_doc.get("company"), child_item.item_tax_template, as_json=True |
| 2409 | ) |
| 2410 | |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2411 | |
Afshan | b3bbebd | 2021-08-09 14:39:32 +0530 | [diff] [blame] | 2412 | def add_taxes_from_tax_template(child_item, parent_doc, db_insert=True): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2413 | add_taxes_from_item_tax_template = frappe.db.get_single_value( |
| 2414 | "Accounts Settings", "add_taxes_from_item_tax_template" |
| 2415 | ) |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2416 | |
| 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2421 | taxes = parent_doc.get("taxes") or [] |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2422 | # 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2426 | 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 | ) |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2434 | if parent_doc.doctype == "Purchase Order": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2435 | tax_row.update({"category": "Total", "add_deduct_tax": "Add"}) |
Afshan | b3bbebd | 2021-08-09 14:39:32 +0530 | [diff] [blame] | 2436 | if db_insert: |
| 2437 | tax_row.db_insert() |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2438 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2439 | |
| 2440 | def set_order_defaults( |
| 2441 | parent_doctype, parent_doctype_name, child_doctype, child_docname, trans_item |
| 2442 | ): |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2443 | """ |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2444 | Returns a Sales/Purchase Order Item child item containing the default values |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2445 | """ |
Saqib | 438e043 | 2020-04-03 10:02:56 +0530 | [diff] [blame] | 2446 | p_doc = frappe.get_doc(parent_doctype, parent_doctype_name) |
Ankush Menat | 686685b | 2023-05-31 12:50:14 +0530 | [diff] [blame] | 2447 | child_item = frappe.new_doc(child_doctype, parent_doc=p_doc, parentfield=child_docname) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2448 | item = frappe.get_doc("Item", trans_item.get("item_code")) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2449 | |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2450 | for field in ("item_code", "item_name", "description", "item_group"): |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2451 | child_item.update({field: item.get(field)}) |
| 2452 | |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2453 | date_fieldname = "delivery_date" if child_doctype == "Sales Order Item" else "schedule_date" |
Jannat Patel | bb0d8f8 | 2021-02-11 20:59:28 +0530 | [diff] [blame] | 2454 | child_item.update({date_fieldname: trans_item.get(date_fieldname) or p_doc.get(date_fieldname)}) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2455 | child_item.stock_uom = item.stock_uom |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2456 | child_item.uom = trans_item.get("uom") or item.stock_uom |
Andy Zhu | 1062d7e | 2020-10-06 10:51:42 +1300 | [diff] [blame] | 2457 | child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2458 | 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 |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2462 | |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2463 | if child_doctype == "Purchase Order Item": |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2464 | # Initialized value will update in parent validation |
| 2465 | child_item.base_rate = 1 |
| 2466 | child_item.base_amount = 1 |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2467 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2470 | 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 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2475 | |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2476 | set_child_tax_template_and_map(item, child_item, p_doc) |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2477 | add_taxes_from_tax_template(child_item, p_doc) |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2478 | return child_item |
| 2479 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2480 | |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2481 | def 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2485 | frappe.throw( |
| 2486 | _("Row #{0}: Cannot delete item {1} which has already been delivered").format( |
| 2487 | row.idx, row.item_code |
| 2488 | ) |
| 2489 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2490 | if flt(row.work_order_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2491 | 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 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2496 | if flt(row.ordered_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2497 | 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 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2502 | |
| 2503 | if parent.doctype == "Purchase Order" and flt(row.received_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2504 | frappe.throw( |
| 2505 | _("Row #{0}: Cannot delete item {1} which has already been received").format( |
| 2506 | row.idx, row.item_code |
| 2507 | ) |
| 2508 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2509 | |
| 2510 | if flt(row.billed_amt): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2511 | frappe.throw( |
| 2512 | _("Row #{0}: Cannot delete item {1} which has already been billed.").format( |
| 2513 | row.idx, row.item_code |
| 2514 | ) |
| 2515 | ) |
| 2516 | |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2517 | |
| 2518 | def update_bin_on_delete(row, doctype): |
| 2519 | """Update bin for deleted item (row).""" |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 2520 | from erpnext.stock.stock_balance import ( |
| 2521 | get_indented_qty, |
| 2522 | get_ordered_qty, |
| 2523 | get_reserved_qty, |
| 2524 | update_bin_qty, |
| 2525 | ) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2526 | |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2527 | 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 Garg | a61790c | 2022-02-22 20:58:10 +0530 | [diff] [blame] | 2537 | if row.warehouse: |
| 2538 | update_bin_qty(row.item_code, row.warehouse, qty_dict) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2539 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2540 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2541 | def validate_and_delete_children(parent, data) -> bool: |
Saqib | 0ad7449 | 2019-12-24 16:42:30 +0530 | [diff] [blame] | 2542 | 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: |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2549 | validate_child_on_delete(d, parent) |
Saqib | 0ad7449 | 2019-12-24 16:42:30 +0530 | [diff] [blame] | 2550 | d.cancel() |
| 2551 | d.delete() |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2552 | |
| 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 Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2559 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2560 | return bool(deleted_children) |
| 2561 | |
Rohan Bansal | a93b514 | 2021-04-06 17:10:52 +0530 | [diff] [blame] | 2562 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2563 | @frappe.whitelist() |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2564 | def update_child_qty_rate(parent_doctype, trans_items, parent_doctype_name, child_docname="items"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2565 | def check_doc_permissions(doc, perm_type="create"): |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2566 | try: |
| 2567 | doc.check_permission(perm_type) |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2568 | except frappe.PermissionError: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2569 | actions = {"create": "add", "write": "update"} |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2570 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2571 | 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 | ) |
marination | 665c27a | 2020-09-15 12:04:38 +0530 | [diff] [blame] | 2577 | |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2578 | 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: |
Saqib | 1831893 | 2020-09-23 13:01:49 +0530 | [diff] [blame] | 2595 | frappe.throw( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2596 | _("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"), |
Saqib | 1831893 | 2020-09-23 13:01:49 +0530 | [diff] [blame] | 2600 | ) |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2601 | |
Rohit Waghchaure | 8d5380a | 2020-06-18 14:06:31 +0530 | [diff] [blame] | 2602 | def get_new_child_item(item_row): |
Rohit Waghchaure | ff70e61 | 2021-03-06 22:08:08 +0530 | [diff] [blame] | 2603 | child_doctype = "Sales Order Item" if parent_doctype == "Sales Order" else "Purchase Order Item" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2604 | return set_order_defaults( |
| 2605 | parent_doctype, parent_doctype_name, child_doctype, child_docname, item_row |
| 2606 | ) |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2607 | |
marination | 0c91543 | 2022-05-10 18:04:02 +0530 | [diff] [blame] | 2608 | 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 Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2618 | frappe.throw(_("Cannot set quantity less than delivered quantity")) |
| 2619 | |
marination | 0c91543 | 2022-05-10 18:04:02 +0530 | [diff] [blame] | 2620 | if parent_doctype == "Purchase Order" and flt(new_data.get("qty")) < flt( |
| 2621 | child_item.received_qty |
| 2622 | ): |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2623 | frappe.throw(_("Cannot set quantity less than received quantity")) |
| 2624 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2625 | 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 Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2645 | data = json.loads(trans_items) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2646 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2647 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2651 | sales_doctypes = ["Sales Order", "Sales Invoice", "Delivery Note", "Quotation"] |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2652 | parent = frappe.get_doc(parent_doctype, parent_doctype_name) |
marination | 665c27a | 2020-09-15 12:04:38 +0530 | [diff] [blame] | 2653 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2654 | check_doc_permissions(parent, "write") |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2655 | _removed_items = validate_and_delete_children(parent, data) |
| 2656 | items_added_or_removed |= _removed_items |
Saqib | 0ad7449 | 2019-12-24 16:42:30 +0530 | [diff] [blame] | 2657 | |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2658 | for d in data: |
| 2659 | new_child_flag = False |
Ankush Menat | 6de7b8e | 2021-08-24 12:18:40 +0530 | [diff] [blame] | 2660 | |
| 2661 | if not d.get("item_code"): |
| 2662 | # ignore empty rows |
| 2663 | continue |
| 2664 | |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2665 | if not d.get("docname"): |
| 2666 | new_child_flag = True |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2667 | items_added_or_removed = True |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2668 | check_doc_permissions(parent, "create") |
Rohit Waghchaure | 8d5380a | 2020-06-18 14:06:31 +0530 | [diff] [blame] | 2669 | child_item = get_new_child_item(d) |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2670 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2671 | check_doc_permissions(parent, "write") |
| 2672 | child_item = frappe.get_doc(parent_doctype + " Item", d.get("docname")) |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2673 | |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2674 | 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 Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2676 | prev_con_fac, new_con_fac = flt(child_item.get("conversion_factor")), flt( |
| 2677 | d.get("conversion_factor") |
| 2678 | ) |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2679 | prev_uom, new_uom = child_item.get("uom"), d.get("uom") |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2680 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2681 | if parent_doctype == "Sales Order": |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2682 | prev_date, new_date = child_item.get("delivery_date"), d.get("delivery_date") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2683 | elif parent_doctype == "Purchase Order": |
marination | b7e94cc | 2020-06-15 11:32:42 +0530 | [diff] [blame] | 2684 | prev_date, new_date = child_item.get("schedule_date"), d.get("schedule_date") |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2685 | |
| 2686 | rate_unchanged = prev_rate == new_rate |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2687 | qty_unchanged = prev_qty == new_qty |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2688 | uom_unchanged = prev_uom == new_uom |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2689 | conversion_factor_unchanged = prev_con_fac == new_con_fac |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2690 | any_conversion_factor_changed |= not conversion_factor_unchanged |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2691 | 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 | ): |
Saqib | dd374ff | 2020-02-27 12:51:31 +0530 | [diff] [blame] | 2701 | continue |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2702 | |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2703 | validate_quantity(child_item, d) |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2704 | if flt(child_item.get("qty")) != flt(d.get("qty")): |
| 2705 | any_qty_changed = True |
deepeshgarg007 | 77cde83 | 2018-12-27 15:56:51 +0530 | [diff] [blame] | 2706 | |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2707 | child_item.qty = flt(d.get("qty")) |
Saqib | 56fea7d | 2020-10-09 21:19:25 +0530 | [diff] [blame] | 2708 | 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 Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2711 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2712 | 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 Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2720 | else: |
Saqib | 56fea7d | 2020-10-09 21:19:25 +0530 | [diff] [blame] | 2721 | child_item.rate = flt(d.get("rate"), rate_precision) |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2722 | |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2723 | if d.get("conversion_factor"): |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2724 | if child_item.stock_uom == child_item.uom: |
| 2725 | child_item.conversion_factor = 1 |
| 2726 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2727 | child_item.conversion_factor = flt(d.get("conversion_factor"), conv_fac_precision) |
marination | 665c27a | 2020-09-15 12:04:38 +0530 | [diff] [blame] | 2728 | |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2729 | if d.get("uom"): |
| 2730 | child_item.uom = d.get("uom") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2731 | 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-Khairnar | a3d5200 | 2019-08-05 10:16:40 +0530 | [diff] [blame] | 2737 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2738 | if d.get("delivery_date") and parent_doctype == "Sales Order": |
| 2739 | child_item.delivery_date = d.get("delivery_date") |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2740 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2741 | if d.get("schedule_date") and parent_doctype == "Purchase Order": |
| 2742 | child_item.schedule_date = d.get("schedule_date") |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2743 | |
Mangesh-Khairnar | a3d5200 | 2019-08-05 10:16:40 +0530 | [diff] [blame] | 2744 | if flt(child_item.price_list_rate): |
Marica | f067447 | 2019-10-11 10:47:09 +0530 | [diff] [blame] | 2745 | 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 |
rohitwaghchaure | 81c2175 | 2019-10-31 15:56:10 +0530 | [diff] [blame] | 2749 | |
| 2750 | if parent_doctype in sales_doctypes: |
| 2751 | child_item.margin_type = "Amount" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2752 | child_item.margin_rate_or_amount = flt( |
| 2753 | child_item.rate - child_item.price_list_rate, child_item.precision("margin_rate_or_amount") |
| 2754 | ) |
rohitwaghchaure | 81c2175 | 2019-10-31 15:56:10 +0530 | [diff] [blame] | 2755 | child_item.rate_with_margin = child_item.rate |
Marica | f067447 | 2019-10-11 10:47:09 +0530 | [diff] [blame] | 2756 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2757 | 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) |
rohitwaghchaure | 81c2175 | 2019-10-31 15:56:10 +0530 | [diff] [blame] | 2762 | |
| 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-Khairnar | a3d5200 | 2019-08-05 10:16:40 +0530 | [diff] [blame] | 2767 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2768 | child_item.flags.ignore_validate_update_after_submit = True |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2769 | if new_child_flag: |
Saqib Ansari | f53299e | 2020-04-15 22:08:12 +0530 | [diff] [blame] | 2770 | parent.load_from_db() |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2771 | child_item.idx = len(parent.items) + 1 |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2772 | child_item.insert() |
| 2773 | else: |
| 2774 | child_item.save() |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2775 | |
Rushabh Mehta | fafbb02 | 2018-12-24 22:09:15 +0530 | [diff] [blame] | 2776 | parent.reload() |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2777 | parent.flags.ignore_validate_update_after_submit = True |
| 2778 | parent.set_qty_as_per_stock_uom() |
| 2779 | parent.calculate_taxes_and_totals() |
Ankush Menat | df6e208 | 2021-02-11 11:04:39 +0530 | [diff] [blame] | 2780 | parent.set_total_in_words() |
Nabin Hait | 49a46f0 | 2019-10-21 13:35:43 +0530 | [diff] [blame] | 2781 | if parent_doctype == "Sales Order": |
Marica | 3dee527 | 2020-06-23 10:33:47 +0530 | [diff] [blame] | 2782 | make_packing_list(parent) |
Nabin Hait | 49a46f0 | 2019-10-21 13:35:43 +0530 | [diff] [blame] | 2783 | parent.set_gross_profit() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2784 | frappe.get_doc("Authorization Control").validate_approving_authority( |
| 2785 | parent.doctype, parent.company, parent.base_grand_total |
| 2786 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2787 | |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2788 | parent.set_payment_schedule() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2789 | if parent_doctype == "Purchase Order": |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2790 | parent.validate_minimum_order_qty() |
| 2791 | parent.validate_budget() |
| 2792 | if parent.is_against_so(): |
| 2793 | parent.update_status_updater() |
Nabin Hait | b2da082 | 2018-07-13 17:01:40 +0530 | [diff] [blame] | 2794 | else: |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2795 | parent.check_credit_limit() |
Ankush Menat | 733c9de | 2022-01-04 18:39:30 +0530 | [diff] [blame] | 2796 | |
| 2797 | # reset index of child table |
| 2798 | for idx, row in enumerate(parent.get(child_docname), start=1): |
| 2799 | row.idx = idx |
| 2800 | |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2801 | parent.save() |
Nabin Hait | b2da082 | 2018-07-13 17:01:40 +0530 | [diff] [blame] | 2802 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2803 | if parent_doctype == "Purchase Order": |
| 2804 | update_last_purchase_rate(parent, is_submit=1) |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2805 | 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-r | 6d89b2f | 2022-06-18 15:46:59 +0530 | [diff] [blame] | 2810 | if parent.is_old_subcontracting_flow: |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2811 | if should_update_supplied_items(parent): |
| 2812 | parent.update_reserved_qty_for_subcontract() |
Sagar Sharma | 78ff178 | 2022-06-28 22:20:32 +0530 | [diff] [blame] | 2813 | parent.create_raw_materials_supplied() |
s-aga-r | 6d89b2f | 2022-06-18 15:46:59 +0530 | [diff] [blame] | 2814 | parent.save() |
Ankush Menat | c84e11a | 2022-06-01 12:55:10 +0530 | [diff] [blame] | 2815 | else: # Sales Order |
| 2816 | parent.validate_warehouse() |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2817 | parent.update_reserved_qty() |
| 2818 | parent.update_project() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2819 | parent.update_prevdoc_status("submit") |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2820 | parent.update_delivery_status() |
Nabin Hait | b2da082 | 2018-07-13 17:01:40 +0530 | [diff] [blame] | 2821 | |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2822 | parent.reload() |
| 2823 | validate_workflow_conditions(parent) |
| 2824 | |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2825 | parent.update_blanket_order() |
| 2826 | parent.update_billing_percentage() |
| 2827 | parent.set_status() |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 2828 | |
s-aga-r | ac24d77 | 2023-04-05 19:48:15 +0530 | [diff] [blame] | 2829 | # Cancel and Recreate Stock Reservation Entries. |
s-aga-r | 38e9367 | 2023-04-02 21:24:59 +0530 | [diff] [blame] | 2830 | 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-r | 38e9367 | 2023-04-02 21:24:59 +0530 | [diff] [blame] | 2834 | ) |
| 2835 | |
| 2836 | if has_reserved_stock(parent.doctype, parent.name): |
| 2837 | cancel_stock_reservation_entries(parent.doctype, parent.name) |
s-aga-r | ac24d77 | 2023-04-05 19:48:15 +0530 | [diff] [blame] | 2838 | parent.create_stock_reservation_entries() |
s-aga-r | 38e9367 | 2023-04-02 21:24:59 +0530 | [diff] [blame] | 2839 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2840 | |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 2841 | @erpnext.allow_regional |
| 2842 | def validate_regional(doc): |
| 2843 | pass |
Saqib Ansari | c5782b0 | 2022-01-27 20:09:56 +0530 | [diff] [blame] | 2844 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2845 | |
Saqib Ansari | c5782b0 | 2022-01-27 20:09:56 +0530 | [diff] [blame] | 2846 | @erpnext.allow_regional |
| 2847 | def validate_einvoice_fields(doc): |
| 2848 | pass |