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 |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 8 | from frappe import _, bold, qb, 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 |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 10 | from frappe.query_builder.custom import ConstantColumn |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 11 | from frappe.query_builder.functions import Abs, Sum |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 12 | from frappe.utils import ( |
| 13 | add_days, |
| 14 | add_months, |
| 15 | cint, |
| 16 | flt, |
| 17 | fmt_money, |
| 18 | formatdate, |
| 19 | get_last_day, |
| 20 | get_link_to_form, |
| 21 | getdate, |
| 22 | nowdate, |
GangaManoj | d24cfff | 2021-10-28 20:06:48 +0530 | [diff] [blame] | 23 | today, |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 24 | ) |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 25 | |
| 26 | import erpnext |
| 27 | from erpnext.accounts.doctype.accounting_dimension.accounting_dimension import ( |
| 28 | get_accounting_dimensions, |
| 29 | ) |
| 30 | from erpnext.accounts.doctype.pricing_rule.utils import ( |
| 31 | apply_pricing_rule_for_free_items, |
| 32 | apply_pricing_rule_on_transaction, |
| 33 | get_applied_pricing_rules, |
| 34 | ) |
| 35 | from erpnext.accounts.party import ( |
| 36 | get_party_account, |
| 37 | get_party_account_currency, |
Deepesh Garg | a7f15a0 | 2021-12-12 21:09:11 +0530 | [diff] [blame] | 38 | get_party_gle_currency, |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 39 | validate_party_frozen_disabled, |
| 40 | ) |
| 41 | from erpnext.accounts.utils import get_account_currency, get_fiscal_years, validate_fiscal_year |
| 42 | from erpnext.buying.utils import update_last_purchase_rate |
| 43 | from erpnext.controllers.print_settings import ( |
| 44 | set_print_templates_for_item_table, |
| 45 | set_print_templates_for_taxes, |
| 46 | ) |
| 47 | from erpnext.controllers.sales_and_purchase_return import validate_return |
| 48 | from erpnext.exceptions import InvalidCurrency |
| 49 | from erpnext.setup.utils import get_exchange_rate |
Ankush Menat | 10583eb | 2022-06-17 12:13:27 +0530 | [diff] [blame] | 50 | from erpnext.stock.doctype.item.item import get_uom_conv_factor |
Marica | 3dee527 | 2020-06-23 10:33:47 +0530 | [diff] [blame] | 51 | from erpnext.stock.doctype.packed_item.packed_item import make_packing_list |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 52 | from erpnext.stock.get_item_details import ( |
| 53 | _get_item_tax_template, |
| 54 | get_conversion_factor, |
| 55 | get_item_details, |
| 56 | get_item_tax_map, |
| 57 | get_item_warehouse, |
| 58 | ) |
Sagar Vora | 4205f56 | 2023-07-24 18:37:36 +0530 | [diff] [blame] | 59 | from erpnext.utilities.regional import temporary_flag |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 60 | from erpnext.utilities.transaction_base import TransactionBase |
| 61 | |
Nabin Hait | 1d21842 | 2015-07-17 15:19:02 +0530 | [diff] [blame] | 62 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 63 | class AccountMissingError(frappe.ValidationError): |
| 64 | pass |
marination | 53b1a9a | 2020-11-03 15:45:25 +0530 | [diff] [blame] | 65 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 66 | |
| 67 | force_item_fields = ( |
| 68 | "item_group", |
| 69 | "brand", |
| 70 | "stock_uom", |
| 71 | "is_fixed_asset", |
| 72 | "item_tax_rate", |
| 73 | "pricing_rules", |
| 74 | "weight_per_unit", |
| 75 | "weight_uom", |
| 76 | "total_weight", |
| 77 | ) |
| 78 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 79 | |
Nabin Hait | bf495c9 | 2013-01-30 12:49:08 +0530 | [diff] [blame] | 80 | class AccountsController(TransactionBase): |
Nabin Hait | 7eba1a3 | 2017-10-02 15:59:27 +0530 | [diff] [blame] | 81 | def __init__(self, *args, **kwargs): |
| 82 | super(AccountsController, self).__init__(*args, **kwargs) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 83 | |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 84 | def get_print_settings(self): |
| 85 | print_setting_fields = [] |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 86 | items_field = self.meta.get_field("items") |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 87 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 88 | if items_field and items_field.fieldtype == "Table": |
| 89 | print_setting_fields += ["compact_item_print", "print_uom_after_quantity"] |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 90 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 91 | taxes_field = self.meta.get_field("taxes") |
| 92 | if taxes_field and taxes_field.fieldtype == "Table": |
| 93 | print_setting_fields += ["print_taxes_with_zero_amount"] |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 94 | |
| 95 | return print_setting_fields |
| 96 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 97 | @property |
| 98 | def company_currency(self): |
| 99 | if not hasattr(self, "__company_currency"): |
Rushabh Mehta | cc8b2b2 | 2017-03-31 12:44:29 +0530 | [diff] [blame] | 100 | self.__company_currency = erpnext.get_company_currency(self.company) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 101 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 102 | return self.__company_currency |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 103 | |
Rohit Waghchaure | 7d52989 | 2016-10-06 14:35:04 +0530 | [diff] [blame] | 104 | def onload(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 105 | self.set_onload( |
| 106 | "make_payment_via_journal_entry", |
| 107 | frappe.db.get_single_value("Accounts Settings", "make_payment_via_journal_entry"), |
| 108 | ) |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 109 | |
tunde | e52bb82 | 2017-09-25 09:02:23 +0100 | [diff] [blame] | 110 | if self.is_new(): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 111 | relevant_docs = ( |
| 112 | "Quotation", |
| 113 | "Purchase Order", |
| 114 | "Sales Order", |
| 115 | "Purchase Invoice", |
| 116 | "Sales Invoice", |
| 117 | ) |
tunde | e52bb82 | 2017-09-25 09:02:23 +0100 | [diff] [blame] | 118 | if self.doctype in relevant_docs: |
| 119 | self.set_payment_schedule() |
Rohit Waghchaure | 7d52989 | 2016-10-06 14:35:04 +0530 | [diff] [blame] | 120 | |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 121 | def ensure_supplier_is_not_blocked(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 122 | is_supplier_payment = self.doctype == "Payment Entry" and self.party_type == "Supplier" |
| 123 | is_buying_invoice = self.doctype in ["Purchase Invoice", "Purchase Order"] |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 124 | supplier = None |
| 125 | supplier_name = None |
| 126 | |
| 127 | if is_buying_invoice or is_supplier_payment: |
| 128 | supplier_name = self.supplier if is_buying_invoice else self.party |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 129 | supplier = frappe.get_doc("Supplier", supplier_name) |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 130 | |
| 131 | if supplier and supplier_name and supplier.on_hold: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 132 | if (is_buying_invoice and supplier.hold_type in ["All", "Invoices"]) or ( |
| 133 | is_supplier_payment and supplier.hold_type in ["All", "Payments"] |
| 134 | ): |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 135 | if not supplier.release_date or getdate(nowdate()) <= supplier.release_date: |
| 136 | frappe.msgprint( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 137 | _("{0} is blocked so this transaction cannot proceed").format(supplier_name), |
| 138 | raise_exception=1, |
| 139 | ) |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 140 | |
Saurabh | 6f75318 | 2013-03-20 12:55:28 +0530 | [diff] [blame] | 141 | def validate(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 142 | 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] | 143 | self.validate_qty_is_not_zero() |
| 144 | |
nabinhait | 23cce73 | 2014-07-03 12:25:06 +0530 | [diff] [blame] | 145 | if self.get("_action") and self._action != "update_after_submit": |
Nabin Hait | 704a453 | 2014-06-05 16:55:31 +0530 | [diff] [blame] | 146 | self.set_missing_values(for_validate=True) |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 147 | |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 148 | self.ensure_supplier_is_not_blocked() |
| 149 | |
Nabin Hait | cfecd2b | 2013-07-11 17:49:18 +0530 | [diff] [blame] | 150 | self.validate_date_with_fiscal_year() |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 151 | self.validate_party_accounts() |
| 152 | |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 153 | self.validate_inter_company_reference() |
| 154 | |
Ankush Menat | 3714e36 | 2022-05-16 18:09:14 +0530 | [diff] [blame] | 155 | self.disable_pricing_rule_on_internal_transfer() |
Deepesh Garg | 8d30ebb | 2022-11-05 20:51:15 +0530 | [diff] [blame] | 156 | self.disable_tax_included_prices_for_internal_transfer() |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 157 | self.set_incoming_rate() |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 158 | |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 159 | if self.meta.get_field("currency"): |
Anand Doshi | 923d41d | 2013-05-28 17:23:36 +0530 | [diff] [blame] | 160 | self.calculate_taxes_and_totals() |
Rohit Waghchaure | 6087fe1 | 2016-04-09 14:31:09 +0530 | [diff] [blame] | 161 | |
Nabin Hait | 1d21842 | 2015-07-17 15:19:02 +0530 | [diff] [blame] | 162 | if not self.meta.get_field("is_return") or not self.is_return: |
| 163 | self.validate_value("base_grand_total", ">=", 0) |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 164 | |
Nabin Hait | 3cf67a4 | 2015-07-24 13:26:36 +0530 | [diff] [blame] | 165 | validate_return(self) |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 166 | self.set_total_in_words() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 167 | |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 168 | self.validate_all_documents_schedule() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 169 | |
ankitjavalkarwork | 6c29d87 | 2014-10-06 13:20:53 +0530 | [diff] [blame] | 170 | if self.meta.get_field("taxes_and_charges"): |
| 171 | self.validate_enabled_taxes_and_charges() |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 172 | self.validate_tax_account_company() |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 173 | |
Neil Trini Lasrado | 3fbbb71 | 2015-07-17 12:10:12 +0530 | [diff] [blame] | 174 | self.validate_party() |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 175 | self.validate_currency() |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 176 | self.validate_party_account_currency() |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 177 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 178 | if self.doctype in ["Purchase Invoice", "Sales Invoice"]: |
| 179 | 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] | 180 | 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] | 181 | self.set_advances() |
| 182 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 183 | self.set_advance_gain_or_loss() |
| 184 | |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 185 | if self.is_return: |
| 186 | self.validate_qty() |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 187 | else: |
| 188 | self.validate_deferred_start_and_end_date() |
rohitwaghchaure | 7048925 | 2018-06-11 12:02:14 +0530 | [diff] [blame] | 189 | |
Deepesh Garg | 9bf5f76 | 2022-04-06 17:33:46 +0530 | [diff] [blame] | 190 | self.validate_deferred_income_expense_account() |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 191 | self.set_inter_company_account() |
| 192 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 193 | if self.doctype == "Purchase Invoice": |
Deepesh Garg | 7f06c8c | 2021-11-26 10:27:57 +0530 | [diff] [blame] | 194 | self.calculate_paid_amount() |
| 195 | # apply tax withholding only if checked and applicable |
| 196 | self.set_tax_withholding() |
| 197 | |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 198 | validate_regional(self) |
Deepesh Garg | 7c30085 | 2020-12-26 20:14:51 +0530 | [diff] [blame] | 199 | |
Saqib Ansari | c5782b0 | 2022-01-27 20:09:56 +0530 | [diff] [blame] | 200 | validate_einvoice_fields(self) |
| 201 | |
Deepesh Garg | b741ae1 | 2022-12-02 17:14:06 +0530 | [diff] [blame] | 202 | if self.doctype != "Material Request" and not self.ignore_pricing_rule: |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 203 | apply_pricing_rule_on_transaction(self) |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 204 | |
Saqib Ansari | c5782b0 | 2022-01-27 20:09:56 +0530 | [diff] [blame] | 205 | def before_cancel(self): |
| 206 | validate_einvoice_fields(self) |
| 207 | |
Saqib | 8e55677 | 2021-01-28 12:26:45 +0530 | [diff] [blame] | 208 | def on_trash(self): |
ruthra kumar | c722f28 | 2023-02-19 12:09:10 +0530 | [diff] [blame] | 209 | # delete references in 'Repost Payment Ledger' |
| 210 | rpi = frappe.qb.DocType("Repost Payment Ledger Items") |
| 211 | frappe.qb.from_(rpi).delete().where( |
| 212 | (rpi.voucher_type == self.doctype) & (rpi.voucher_no == self.name) |
| 213 | ).run() |
| 214 | |
Saqib | 8e55677 | 2021-01-28 12:26:45 +0530 | [diff] [blame] | 215 | # delete sl and gl entries on deletion of transaction |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 216 | if frappe.db.get_single_value("Accounts Settings", "delete_linked_ledger_entries"): |
ruthra kumar | 70313df | 2022-09-08 18:53:30 +0530 | [diff] [blame] | 217 | ple = frappe.qb.DocType("Payment Ledger Entry") |
| 218 | frappe.qb.from_(ple).delete().where( |
| 219 | (ple.voucher_type == self.doctype) & (ple.voucher_no == self.name) |
| 220 | ).run() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 221 | frappe.db.sql( |
| 222 | "delete from `tabGL Entry` where voucher_type=%s and voucher_no=%s", (self.doctype, self.name) |
| 223 | ) |
| 224 | frappe.db.sql( |
| 225 | "delete from `tabStock Ledger Entry` where voucher_type=%s and voucher_no=%s", |
| 226 | (self.doctype, self.name), |
| 227 | ) |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 228 | |
Deepesh Garg | 9bf5f76 | 2022-04-06 17:33:46 +0530 | [diff] [blame] | 229 | def validate_deferred_income_expense_account(self): |
| 230 | field_map = { |
| 231 | "Sales Invoice": "deferred_revenue_account", |
| 232 | "Purchase Invoice": "deferred_expense_account", |
| 233 | } |
| 234 | |
| 235 | for item in self.get("items"): |
| 236 | if item.get("enable_deferred_revenue") or item.get("enable_deferred_expense"): |
| 237 | if not item.get(field_map.get(self.doctype)): |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 238 | default_deferred_account = frappe.get_cached_value( |
Deepesh Garg | 9bf5f76 | 2022-04-06 17:33:46 +0530 | [diff] [blame] | 239 | "Company", self.company, "default_" + field_map.get(self.doctype) |
| 240 | ) |
| 241 | if not default_deferred_account: |
| 242 | frappe.throw( |
| 243 | _( |
| 244 | "Row #{0}: Please update deferred revenue/expense account in item row or default account in company master" |
| 245 | ).format(item.idx) |
| 246 | ) |
| 247 | else: |
| 248 | item.set(field_map.get(self.doctype), default_deferred_account) |
| 249 | |
Deepesh Garg | fa15221 | 2022-11-28 19:22:35 +0530 | [diff] [blame] | 250 | def validate_auto_repeat_subscription_dates(self): |
Deepesh Garg | 6a47fb6 | 2022-11-28 22:47:44 +0530 | [diff] [blame] | 251 | if ( |
| 252 | self.get("from_date") |
| 253 | and self.get("to_date") |
| 254 | and getdate(self.from_date) > getdate(self.to_date) |
| 255 | ): |
Deepesh Garg | fa15221 | 2022-11-28 19:22:35 +0530 | [diff] [blame] | 256 | frappe.throw(_("To Date cannot be before From Date"), title=_("Invalid Auto Repeat Date")) |
| 257 | |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 258 | def validate_deferred_start_and_end_date(self): |
| 259 | for d in self.items: |
| 260 | if d.get("enable_deferred_revenue") or d.get("enable_deferred_expense"): |
| 261 | if not (d.service_start_date and d.service_end_date): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 262 | frappe.throw( |
| 263 | _("Row #{0}: Service Start and End Date is required for deferred accounting").format(d.idx) |
| 264 | ) |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 265 | elif getdate(d.service_start_date) > getdate(d.service_end_date): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 266 | frappe.throw( |
| 267 | _("Row #{0}: Service Start Date cannot be greater than Service End Date").format(d.idx) |
| 268 | ) |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 269 | elif getdate(self.posting_date) > getdate(d.service_end_date): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 270 | frappe.throw( |
| 271 | _("Row #{0}: Service End Date cannot be before Invoice Posting Date").format(d.idx) |
| 272 | ) |
Nabin Hait | acdd508 | 2019-12-04 15:30:01 +0530 | [diff] [blame] | 273 | |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 274 | def validate_invoice_documents_schedule(self): |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 275 | self.validate_payment_schedule_dates() |
| 276 | self.set_due_date() |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 277 | self.set_payment_schedule() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 278 | if not self.get("ignore_default_payment_terms_template"): |
Deepesh Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 279 | self.validate_payment_schedule_amount() |
Deepesh Garg | bd709f8 | 2021-08-23 19:05:52 +0530 | [diff] [blame] | 280 | self.validate_due_date() |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 281 | self.validate_advance_entries() |
| 282 | |
| 283 | def validate_non_invoice_documents_schedule(self): |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 284 | self.set_payment_schedule() |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 285 | self.validate_payment_schedule_dates() |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 286 | self.validate_payment_schedule_amount() |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 287 | |
| 288 | def validate_all_documents_schedule(self): |
| 289 | if self.doctype in ("Sales Invoice", "Purchase Invoice") and not self.is_return: |
| 290 | self.validate_invoice_documents_schedule() |
| 291 | elif self.doctype in ("Quotation", "Purchase Order", "Sales Order"): |
| 292 | self.validate_non_invoice_documents_schedule() |
| 293 | |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 294 | def before_print(self, settings=None): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 295 | if self.doctype in [ |
| 296 | "Purchase Order", |
| 297 | "Sales Order", |
| 298 | "Sales Invoice", |
| 299 | "Purchase Invoice", |
| 300 | "Supplier Quotation", |
| 301 | "Purchase Receipt", |
| 302 | "Delivery Note", |
| 303 | "Quotation", |
| 304 | ]: |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 305 | if self.get("group_same_items"): |
| 306 | self.group_similar_items() |
| 307 | |
Zarrar | 5be6d19 | 2018-11-08 12:16:26 +0530 | [diff] [blame] | 308 | df = self.meta.get_field("discount_amount") |
| 309 | if self.get("discount_amount") and hasattr(self, "taxes") and not len(self.taxes): |
| 310 | df.set("print_hide", 0) |
| 311 | self.discount_amount = -self.discount_amount |
| 312 | else: |
| 313 | df.set("print_hide", 1) |
| 314 | |
prssanna | 71e5b60 | 2020-10-29 14:19:34 +0530 | [diff] [blame] | 315 | set_print_templates_for_item_table(self, settings) |
| 316 | set_print_templates_for_taxes(self, settings) |
| 317 | |
Mangesh-Khairnar | 7bcb24e | 2019-09-11 10:49:33 +0530 | [diff] [blame] | 318 | def calculate_paid_amount(self): |
Saurabh | 43520f9 | 2016-03-21 18:32:48 +0530 | [diff] [blame] | 319 | if hasattr(self, "is_pos") or hasattr(self, "is_paid"): |
| 320 | is_paid = self.get("is_pos") or self.get("is_paid") |
Mangesh-Khairnar | 7bcb24e | 2019-09-11 10:49:33 +0530 | [diff] [blame] | 321 | |
| 322 | if is_paid: |
| 323 | if not self.cash_bank_account: |
| 324 | # show message that the amount is not paid |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 325 | frappe.throw( |
| 326 | _("Note: Payment Entry will not be created since 'Cash or Bank Account' was not specified") |
| 327 | ) |
Marica | 23d7b09 | 2019-09-25 17:17:36 +0530 | [diff] [blame] | 328 | |
Mangesh-Khairnar | 7bcb24e | 2019-09-11 10:49:33 +0530 | [diff] [blame] | 329 | if cint(self.is_return) and self.grand_total > self.paid_amount: |
| 330 | self.paid_amount = flt(flt(self.grand_total), self.precision("paid_amount")) |
| 331 | |
| 332 | elif not flt(self.paid_amount) and flt(self.outstanding_amount) > 0: |
| 333 | self.paid_amount = flt(flt(self.outstanding_amount), self.precision("paid_amount")) |
| 334 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 335 | self.base_paid_amount = flt( |
| 336 | self.paid_amount * self.conversion_rate, self.precision("base_paid_amount") |
| 337 | ) |
Saurabh | 43520f9 | 2016-03-21 18:32:48 +0530 | [diff] [blame] | 338 | |
Anand Doshi | abc1003 | 2013-06-14 17:44:03 +0530 | [diff] [blame] | 339 | def set_missing_values(self, for_validate=False): |
Rohit Waghchaure | 5d97d89 | 2016-05-12 12:58:29 +0530 | [diff] [blame] | 340 | if frappe.flags.in_test: |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 341 | for fieldname in ["posting_date", "transaction_date"]: |
Rohit Waghchaure | 5d97d89 | 2016-05-12 12:58:29 +0530 | [diff] [blame] | 342 | if self.meta.get_field(fieldname) and not self.get(fieldname): |
| 343 | self.set(fieldname, today()) |
| 344 | break |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 345 | |
Nabin Hait | 3237c75 | 2015-02-17 11:11:11 +0530 | [diff] [blame] | 346 | def calculate_taxes_and_totals(self): |
Nabin Hait | fe81da2 | 2015-02-18 12:23:18 +0530 | [diff] [blame] | 347 | from erpnext.controllers.taxes_and_totals import calculate_taxes_and_totals |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 348 | |
Nabin Hait | fe81da2 | 2015-02-18 12:23:18 +0530 | [diff] [blame] | 349 | calculate_taxes_and_totals(self) |
Nabin Hait | 3237c75 | 2015-02-17 11:11:11 +0530 | [diff] [blame] | 350 | |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 351 | if self.doctype in ( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 352 | "Sales Order", |
| 353 | "Delivery Note", |
| 354 | "Sales Invoice", |
| 355 | "POS Invoice", |
Raffael Meyer | e10ab16 | 2021-11-30 13:24:18 +0100 | [diff] [blame] | 356 | ): |
Nabin Hait | 3237c75 | 2015-02-17 11:11:11 +0530 | [diff] [blame] | 357 | self.calculate_commission() |
| 358 | self.calculate_contribution() |
| 359 | |
Nabin Hait | cfecd2b | 2013-07-11 17:49:18 +0530 | [diff] [blame] | 360 | def validate_date_with_fiscal_year(self): |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 361 | if self.meta.get_field("fiscal_year"): |
Rohan Bansal | 1e3a3b2 | 2021-05-26 15:18:10 +0530 | [diff] [blame] | 362 | date_field = None |
Nabin Hait | cfecd2b | 2013-07-11 17:49:18 +0530 | [diff] [blame] | 363 | if self.meta.get_field("posting_date"): |
| 364 | date_field = "posting_date" |
| 365 | elif self.meta.get_field("transaction_date"): |
| 366 | date_field = "transaction_date" |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 367 | |
Rushabh Mehta | f2227d0 | 2014-03-31 23:37:40 +0530 | [diff] [blame] | 368 | if date_field and self.get(date_field): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 369 | validate_fiscal_year( |
| 370 | self.get(date_field), self.fiscal_year, self.company, self.meta.get_label(date_field), self |
| 371 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 372 | |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 373 | def validate_party_accounts(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 374 | if self.doctype not in ("Sales Invoice", "Purchase Invoice"): |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 375 | return |
| 376 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 377 | if self.doctype == "Sales Invoice": |
| 378 | party_account_field = "debit_to" |
| 379 | item_field = "income_account" |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 380 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 381 | party_account_field = "credit_to" |
| 382 | item_field = "expense_account" |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 383 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 384 | for item in self.get("items"): |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 385 | if item.get(item_field) == self.get(party_account_field): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 386 | frappe.throw( |
| 387 | _("Row {0}: {1} {2} cannot be same as {3} (Party Account) {4}").format( |
| 388 | item.idx, |
| 389 | frappe.bold(frappe.unscrub(item_field)), |
| 390 | item.get(item_field), |
| 391 | frappe.bold(frappe.unscrub(party_account_field)), |
| 392 | self.get(party_account_field), |
| 393 | ) |
| 394 | ) |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 395 | |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 396 | def validate_inter_company_reference(self): |
Rohit Waghchaure | 38aaba5 | 2023-05-13 13:00:05 +0530 | [diff] [blame] | 397 | if self.get("is_return"): |
| 398 | return |
| 399 | |
Rohit Waghchaure | b4a102d | 2022-09-06 16:22:00 +0530 | [diff] [blame] | 400 | if self.doctype not in ("Purchase Invoice", "Purchase Receipt"): |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 401 | return |
| 402 | |
| 403 | if self.is_internal_transfer(): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 404 | if not ( |
| 405 | self.get("inter_company_reference") |
| 406 | or self.get("inter_company_invoice_reference") |
| 407 | or self.get("inter_company_order_reference") |
Deepesh Garg | 906ad10 | 2023-01-15 17:32:57 +0530 | [diff] [blame] | 408 | ) and not self.get("is_return"): |
Deepesh Garg | 4c8d15b | 2021-04-26 15:24:34 +0530 | [diff] [blame] | 409 | msg = _("Internal Sale or Delivery Reference missing.") |
Deepesh Garg | b4be292 | 2021-01-28 13:09:56 +0530 | [diff] [blame] | 410 | msg += _("Please create purchase from internal sale or delivery document itself") |
| 411 | frappe.throw(msg, title=_("Internal Sales Reference Missing")) |
| 412 | |
Rohit Waghchaure | 19911b4 | 2023-04-21 16:49:48 +0530 | [diff] [blame] | 413 | label = "Delivery Note Item" if self.doctype == "Purchase Receipt" else "Sales Invoice Item" |
| 414 | |
| 415 | field = frappe.scrub(label) |
| 416 | |
| 417 | for row in self.get("items"): |
| 418 | if not row.get(field): |
| 419 | msg = f"At Row {row.idx}: The field {bold(label)} is mandatory for internal transfer" |
| 420 | frappe.throw(_(msg), title=_("Internal Transfer Reference Missing")) |
| 421 | |
Ankush Menat | 3714e36 | 2022-05-16 18:09:14 +0530 | [diff] [blame] | 422 | def disable_pricing_rule_on_internal_transfer(self): |
| 423 | if not self.get("ignore_pricing_rule") and self.is_internal_transfer(): |
| 424 | self.ignore_pricing_rule = 1 |
| 425 | frappe.msgprint( |
| 426 | _("Disabled pricing rules since this {} is an internal transfer").format(self.doctype), |
| 427 | alert=1, |
| 428 | ) |
| 429 | |
Deepesh Garg | 8d30ebb | 2022-11-05 20:51:15 +0530 | [diff] [blame] | 430 | def disable_tax_included_prices_for_internal_transfer(self): |
| 431 | if self.is_internal_transfer(): |
| 432 | tax_updated = False |
| 433 | for tax in self.get("taxes"): |
| 434 | if tax.get("included_in_print_rate"): |
| 435 | tax.included_in_print_rate = 0 |
| 436 | tax_updated = True |
| 437 | |
| 438 | if tax_updated: |
| 439 | frappe.msgprint( |
| 440 | _("Disabled tax included prices since this {} is an internal transfer").format(self.doctype), |
| 441 | alert=1, |
| 442 | ) |
| 443 | |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 444 | def validate_due_date(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 445 | if self.get("is_pos"): |
| 446 | return |
rohitwaghchaure | ea943c6 | 2018-07-06 12:28:58 +0530 | [diff] [blame] | 447 | |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 448 | from erpnext.accounts.party import validate_due_date |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 449 | |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 450 | if self.doctype == "Sales Invoice": |
Nabin Hait | 04d244a | 2015-07-22 17:47:49 +0530 | [diff] [blame] | 451 | if not self.due_date: |
| 452 | frappe.throw(_("Due Date is mandatory")) |
Rushabh Mehta | b16b9cd | 2015-08-03 16:13:33 +0530 | [diff] [blame] | 453 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 454 | validate_due_date( |
| 455 | self.posting_date, |
| 456 | self.due_date, |
| 457 | "Customer", |
| 458 | self.customer, |
| 459 | self.company, |
| 460 | self.payment_terms_template, |
| 461 | ) |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 462 | elif self.doctype == "Purchase Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 463 | validate_due_date( |
| 464 | self.bill_date or self.posting_date, |
| 465 | self.due_date, |
| 466 | "Supplier", |
| 467 | self.supplier, |
| 468 | self.company, |
| 469 | self.bill_date, |
| 470 | self.payment_terms_template, |
| 471 | ) |
Nabin Hait | e9daefe | 2014-08-27 16:46:33 +0530 | [diff] [blame] | 472 | |
Nabin Hait | 096d363 | 2013-10-17 17:01:14 +0530 | [diff] [blame] | 473 | def set_price_list_currency(self, buying_or_selling): |
Nabin Hait | 1cc55fb | 2016-12-08 14:09:23 +0530 | [diff] [blame] | 474 | if self.meta.get_field("posting_date"): |
Nabin Hait | 288a18e | 2016-12-08 15:36:23 +0530 | [diff] [blame] | 475 | transaction_date = self.posting_date |
Nabin Hait | 1cc55fb | 2016-12-08 14:09:23 +0530 | [diff] [blame] | 476 | else: |
Nabin Hait | 288a18e | 2016-12-08 15:36:23 +0530 | [diff] [blame] | 477 | transaction_date = self.transaction_date |
Rushabh Mehta | 6695830 | 2017-01-16 16:57:53 +0530 | [diff] [blame] | 478 | |
Rushabh Mehta | 4a404e9 | 2013-08-09 18:11:35 +0530 | [diff] [blame] | 479 | if self.meta.get_field("currency"): |
Nabin Hait | 7a75e10 | 2013-09-17 10:21:20 +0530 | [diff] [blame] | 480 | # price list part |
Shreya | 3f77852 | 2018-05-15 16:59:20 +0530 | [diff] [blame] | 481 | if buying_or_selling.lower() == "selling": |
| 482 | fieldname = "selling_price_list" |
| 483 | args = "for_selling" |
| 484 | else: |
| 485 | fieldname = "buying_price_list" |
| 486 | args = "for_buying" |
| 487 | |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 488 | if self.meta.get_field(fieldname) and self.get(fieldname): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 489 | 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] | 490 | |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 491 | if self.price_list_currency == self.company_currency: |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 492 | self.plc_conversion_rate = 1.0 |
Nabin Hait | 11f4195 | 2013-09-24 14:36:55 +0530 | [diff] [blame] | 493 | |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 494 | elif not self.plc_conversion_rate: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 495 | self.plc_conversion_rate = get_exchange_rate( |
| 496 | self.price_list_currency, self.company_currency, transaction_date, args |
| 497 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 498 | |
Nabin Hait | 7a75e10 | 2013-09-17 10:21:20 +0530 | [diff] [blame] | 499 | # currency |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 500 | if not self.currency: |
| 501 | self.currency = self.price_list_currency |
| 502 | self.conversion_rate = self.plc_conversion_rate |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 503 | elif self.currency == self.company_currency: |
Anand Doshi | f78d1ae | 2014-03-28 13:55:00 +0530 | [diff] [blame] | 504 | self.conversion_rate = 1.0 |
| 505 | elif not self.conversion_rate: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 506 | self.conversion_rate = get_exchange_rate( |
| 507 | self.currency, self.company_currency, transaction_date, args |
| 508 | ) |
Nabin Hait | 7a75e10 | 2013-09-17 10:21:20 +0530 | [diff] [blame] | 509 | |
Nabin Hait | cccc45e | 2016-10-05 17:15:43 +0530 | [diff] [blame] | 510 | def set_missing_item_details(self, for_validate=False): |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 511 | """set missing item values""" |
Nabin Hait | f37d43d | 2017-07-18 12:14:42 +0530 | [diff] [blame] | 512 | from erpnext.stock.doctype.serial_no.serial_no import get_serial_nos |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 513 | |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 514 | if hasattr(self, "items"): |
Nabin Hait | 444f956 | 2014-06-20 15:59:49 +0530 | [diff] [blame] | 515 | parent_dict = {} |
Pratik Vyas | f7daab7 | 2014-04-10 17:53:30 +0530 | [diff] [blame] | 516 | for fieldname in self.meta.get_valid_columns(): |
| 517 | parent_dict[fieldname] = self.get(fieldname) |
| 518 | |
mbauskar | a52472c | 2016-03-05 15:10:25 +0530 | [diff] [blame] | 519 | if self.doctype in ["Quotation", "Sales Order", "Delivery Note", "Sales Invoice"]: |
| 520 | document_type = "{} Item".format(self.doctype) |
mbauskar | c97becb | 2016-01-18 16:28:21 +0530 | [diff] [blame] | 521 | parent_dict.update({"document_type": document_type}) |
| 522 | |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 523 | # party_name field used for customer in quotation |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 524 | if ( |
| 525 | self.doctype == "Quotation" |
| 526 | and self.quotation_to == "Customer" |
| 527 | and parent_dict.get("party_name") |
| 528 | ): |
Nabin Hait | 34c551d | 2019-07-03 10:34:31 +0530 | [diff] [blame] | 529 | parent_dict.update({"customer": parent_dict.get("party_name")}) |
| 530 | |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 531 | self.pricing_rules = [] |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 532 | |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 533 | for item in self.get("items"): |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 534 | if item.get("item_code"): |
Nabin Hait | 444f956 | 2014-06-20 15:59:49 +0530 | [diff] [blame] | 535 | args = parent_dict.copy() |
| 536 | args.update(item.as_dict()) |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 537 | |
Nabin Hait | 34d2822 | 2016-01-19 15:45:49 +0530 | [diff] [blame] | 538 | args["doctype"] = self.doctype |
| 539 | args["name"] = self.name |
Rohit Waghchaure | 8bfe330 | 2019-03-18 14:34:19 +0530 | [diff] [blame] | 540 | args["child_docname"] = item.name |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 541 | args["ignore_pricing_rule"] = ( |
| 542 | self.ignore_pricing_rule if hasattr(self, "ignore_pricing_rule") else 0 |
| 543 | ) |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 544 | |
Nabin Hait | e2f054c | 2015-03-09 14:54:37 +0530 | [diff] [blame] | 545 | if not args.get("transaction_date"): |
| 546 | args["transaction_date"] = args.get("posting_date") |
Anand Doshi | 2b2b639 | 2015-03-20 14:18:09 +0530 | [diff] [blame] | 547 | |
| 548 | if self.get("is_subcontracted"): |
| 549 | args["is_subcontracted"] = self.is_subcontracted |
Rohit Waghchaure | 8bfe330 | 2019-03-18 14:34:19 +0530 | [diff] [blame] | 550 | |
Deepesh Garg | a7051cb | 2023-04-14 09:59:42 +0530 | [diff] [blame] | 551 | ret = get_item_details(args, self, for_validate=True, overwrite_warehouse=False) |
Rohit Waghchaure | 8bfe330 | 2019-03-18 14:34:19 +0530 | [diff] [blame] | 552 | |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 553 | for fieldname, value in ret.items(): |
Anand Doshi | 602e825 | 2015-11-16 19:05:46 +0530 | [diff] [blame] | 554 | if item.meta.get_field(fieldname) and value is not None: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 555 | if item.get(fieldname) is None or fieldname in force_item_fields: |
Rushabh Mehta | f14b809 | 2014-04-03 14:30:42 +0530 | [diff] [blame] | 556 | item.set(fieldname, value) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 557 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 558 | elif fieldname in ["cost_center", "conversion_factor"] and not item.get(fieldname): |
Anand Doshi | 602e825 | 2015-11-16 19:05:46 +0530 | [diff] [blame] | 559 | item.set(fieldname, value) |
| 560 | |
Rohit Waghchaure | dc981dc | 2017-04-03 14:17:08 +0530 | [diff] [blame] | 561 | elif fieldname == "serial_no": |
Alchez | 9155e40 | 2018-07-09 16:57:42 +0530 | [diff] [blame] | 562 | # Ensure that serial numbers are matched against Stock UOM |
| 563 | item_conversion_factor = item.get("conversion_factor") or 1.0 |
| 564 | item_qty = abs(item.get("qty")) * item_conversion_factor |
Alchez | 8f2a0f3 | 2018-07-06 14:36:52 +0530 | [diff] [blame] | 565 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 566 | if item_qty != len(get_serial_nos(item.get("serial_no"))): |
Rohit Waghchaure | dc981dc | 2017-04-03 14:17:08 +0530 | [diff] [blame] | 567 | item.set(fieldname, value) |
Nabin Hait | a74468b | 2014-12-30 18:33:52 +0530 | [diff] [blame] | 568 | |
Saqib Ansari | ab36b27 | 2022-02-09 10:10:17 +0530 | [diff] [blame] | 569 | elif ( |
| 570 | ret.get("pricing_rule_removed") |
| 571 | and value is not None |
| 572 | and fieldname |
| 573 | in [ |
| 574 | "discount_percentage", |
| 575 | "discount_amount", |
| 576 | "rate", |
| 577 | "margin_rate_or_amount", |
| 578 | "margin_type", |
| 579 | "remove_free_item", |
| 580 | ] |
| 581 | ): |
Saqib Ansari | b8c41e3 | 2022-01-20 13:06:08 +0530 | [diff] [blame] | 582 | # reset pricing rule fields if pricing_rule_removed |
| 583 | item.set(fieldname, value) |
| 584 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 585 | if self.doctype in ["Purchase Invoice", "Sales Invoice"] and item.meta.get_field( |
| 586 | "is_fixed_asset" |
| 587 | ): |
| 588 | item.set("is_fixed_asset", ret.get("is_fixed_asset", 0)) |
Rohit Waghchaure | f6f503a | 2018-12-19 15:06:44 +0530 | [diff] [blame] | 589 | |
Deepesh Garg | a60c308 | 2021-05-11 16:38:33 +0530 | [diff] [blame] | 590 | # Double check for cost center |
| 591 | # Items add via promotional scheme may not have cost center set |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 592 | if hasattr(item, "cost_center") and not item.get("cost_center"): |
| 593 | item.set( |
| 594 | "cost_center", self.get("cost_center") or erpnext.get_default_cost_center(self.company) |
| 595 | ) |
Deepesh Garg | a60c308 | 2021-05-11 16:38:33 +0530 | [diff] [blame] | 596 | |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 597 | if ret.get("pricing_rules"): |
| 598 | self.apply_pricing_rule_on_items(item, ret) |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 599 | self.set_pricing_rule_details(item, ret) |
Ankush Menat | 10583eb | 2022-06-17 12:13:27 +0530 | [diff] [blame] | 600 | else: |
| 601 | # Transactions line item without item code |
| 602 | |
| 603 | uom = item.get("uom") |
| 604 | stock_uom = item.get("stock_uom") |
| 605 | if bool(uom) != bool(stock_uom): # xor |
| 606 | item.stock_uom = item.uom = uom or stock_uom |
| 607 | |
Deepesh Garg | 6175183 | 2022-12-29 10:41:36 +0530 | [diff] [blame] | 608 | # UOM cannot be zero so substitute as 1 |
| 609 | item.conversion_factor = ( |
| 610 | get_uom_conv_factor(item.get("uom"), item.get("stock_uom")) |
| 611 | or item.get("conversion_factor") |
| 612 | or 1 |
| 613 | ) |
Rushabh Mehta | b46069d | 2016-01-15 16:59:26 +0530 | [diff] [blame] | 614 | |
Nabin Hait | 14aa9c5 | 2016-04-18 15:54:01 +0530 | [diff] [blame] | 615 | if self.doctype == "Purchase Invoice": |
Nabin Hait | cccc45e | 2016-10-05 17:15:43 +0530 | [diff] [blame] | 616 | self.set_expense_account(for_validate) |
Nabin Hait | a3dd72a | 2014-05-28 12:49:20 +0530 | [diff] [blame] | 617 | |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 618 | def apply_pricing_rule_on_items(self, item, pricing_rule_args): |
| 619 | if not pricing_rule_args.get("validate_applied_rule", 0): |
| 620 | # if user changed the discount percentage then set user's discount percentage ? |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 621 | if pricing_rule_args.get("price_or_product_discount") == "Price": |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 622 | item.set("pricing_rules", pricing_rule_args.get("pricing_rules")) |
Rohit Waghchaure | f5bd3fa | 2022-09-16 15:23:10 +0530 | [diff] [blame] | 623 | if pricing_rule_args.get("apply_rule_on_other_items"): |
| 624 | other_items = json.loads(pricing_rule_args.get("apply_rule_on_other_items")) |
| 625 | if other_items and item.item_code not in other_items: |
| 626 | return |
| 627 | |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 628 | item.set("discount_percentage", pricing_rule_args.get("discount_percentage")) |
| 629 | item.set("discount_amount", pricing_rule_args.get("discount_amount")) |
| 630 | if pricing_rule_args.get("pricing_rule_for") == "Rate": |
| 631 | item.set("price_list_rate", pricing_rule_args.get("price_list_rate")) |
| 632 | |
| 633 | if item.get("price_list_rate"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 634 | item.rate = flt( |
| 635 | item.price_list_rate * (1.0 - (flt(item.discount_percentage) / 100.0)), |
| 636 | item.precision("rate"), |
| 637 | ) |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 638 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 639 | if item.get("discount_amount"): |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 640 | item.rate = item.price_list_rate - item.discount_amount |
| 641 | |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 642 | if item.get("apply_discount_on_discounted_rate") and pricing_rule_args.get("rate"): |
| 643 | item.rate = pricing_rule_args.get("rate") |
| 644 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 645 | elif pricing_rule_args.get("free_item_data"): |
| 646 | 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] | 647 | |
| 648 | elif pricing_rule_args.get("validate_applied_rule"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 649 | for pricing_rule in get_applied_pricing_rules(item.get("pricing_rules")): |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 650 | pricing_rule_doc = frappe.get_cached_doc("Pricing Rule", pricing_rule) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 651 | for field in ["discount_percentage", "discount_amount", "rate"]: |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 652 | if item.get(field) < pricing_rule_doc.get(field): |
| 653 | title = get_link_to_form("Pricing Rule", pricing_rule) |
| 654 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 655 | frappe.msgprint( |
| 656 | _("Row {0}: user has not applied the rule {1} on the item {2}").format( |
| 657 | item.idx, frappe.bold(title), frappe.bold(item.item_code) |
| 658 | ) |
| 659 | ) |
rohitwaghchaure | a85ddf2 | 2019-11-19 18:47:48 +0530 | [diff] [blame] | 660 | |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 661 | def set_pricing_rule_details(self, item_row, args): |
| 662 | pricing_rules = get_applied_pricing_rules(args.get("pricing_rules")) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 663 | if not pricing_rules: |
| 664 | return |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 665 | |
| 666 | for pricing_rule in pricing_rules: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 667 | self.append( |
| 668 | "pricing_rules", |
| 669 | { |
| 670 | "pricing_rule": pricing_rule, |
| 671 | "item_code": item_row.item_code, |
| 672 | "child_docname": item_row.name, |
| 673 | "rule_applied": True, |
| 674 | }, |
| 675 | ) |
Rohit Waghchaure | a248dfb | 2020-07-16 17:27:26 +0530 | [diff] [blame] | 676 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 677 | def set_taxes(self): |
| 678 | if not self.meta.get_field("taxes"): |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 679 | return |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 680 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 681 | tax_master_doctype = self.meta.get_field("taxes_and_charges").options |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 682 | |
rohitwaghchaure | 57914f1 | 2018-04-24 19:19:47 +0530 | [diff] [blame] | 683 | 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] | 684 | if self.company and not self.get("taxes_and_charges"): |
Anand Doshi | 3543f30 | 2013-05-24 19:25:01 +0530 | [diff] [blame] | 685 | # get the default tax master |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 686 | self.taxes_and_charges = frappe.db.get_value( |
| 687 | tax_master_doctype, {"is_default": 1, "company": self.company} |
| 688 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 689 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 690 | self.append_taxes_from_master(tax_master_doctype) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 691 | |
rohitwaghchaure | 57914f1 | 2018-04-24 19:19:47 +0530 | [diff] [blame] | 692 | def is_pos_profile_changed(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 693 | if ( |
| 694 | self.doctype == "Sales Invoice" |
| 695 | and self.is_pos |
| 696 | and self.pos_profile != frappe.db.get_value("Sales Invoice", self.name, "pos_profile") |
| 697 | ): |
rohitwaghchaure | 57914f1 | 2018-04-24 19:19:47 +0530 | [diff] [blame] | 698 | return True |
| 699 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 700 | def append_taxes_from_master(self, tax_master_doctype=None): |
| 701 | if self.get("taxes_and_charges"): |
Anand Doshi | 99100a4 | 2013-07-04 17:13:53 +0530 | [diff] [blame] | 702 | if not tax_master_doctype: |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 703 | tax_master_doctype = self.meta.get_field("taxes_and_charges").options |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 704 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 705 | 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] | 706 | |
Anand Doshi | ac32bad | 2014-04-18 01:30:14 +0530 | [diff] [blame] | 707 | def set_other_charges(self): |
Nabin Hait | e7d1536 | 2014-12-25 16:01:55 +0530 | [diff] [blame] | 708 | self.set("taxes", []) |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 709 | self.set_taxes() |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 710 | |
ankitjavalkarwork | 6c29d87 | 2014-10-06 13:20:53 +0530 | [diff] [blame] | 711 | def validate_enabled_taxes_and_charges(self): |
| 712 | taxes_and_charges_doctype = self.meta.get_options("taxes_and_charges") |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 713 | 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] | 714 | frappe.throw( |
| 715 | _("{0} '{1}' is disabled").format(taxes_and_charges_doctype, self.taxes_and_charges) |
| 716 | ) |
ankitjavalkarwork | 6c29d87 | 2014-10-06 13:20:53 +0530 | [diff] [blame] | 717 | |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 718 | def validate_tax_account_company(self): |
| 719 | for d in self.get("taxes"): |
| 720 | if d.account_head: |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 721 | tax_account_company = frappe.get_cached_value("Account", d.account_head, "company") |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 722 | if tax_account_company != self.company: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 723 | frappe.throw( |
| 724 | _("Row #{0}: Account {1} does not belong to company {2}").format( |
| 725 | d.idx, d.account_head, self.company |
| 726 | ) |
| 727 | ) |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 728 | |
deepeshgarg007 | 3d11ac0 | 2019-05-19 00:02:01 +0530 | [diff] [blame] | 729 | def get_gl_dict(self, args, account_currency=None, item=None): |
Nabin Hait | 2df4d54 | 2013-01-29 11:34:39 +0530 | [diff] [blame] | 730 | """this method populates the common properties of a gl entry record""" |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 731 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 732 | posting_date = args.get("posting_date") or self.get("posting_date") |
Rohit Waghchaure | aa7b434 | 2018-05-11 01:56:05 +0530 | [diff] [blame] | 733 | fiscal_years = get_fiscal_years(posting_date, company=self.company) |
Nabin Hait | 2ed0b59 | 2016-03-29 13:14:17 +0530 | [diff] [blame] | 734 | if len(fiscal_years) > 1: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 735 | frappe.throw( |
| 736 | _("Multiple fiscal years exist for the date {0}. Please set company in Fiscal Year").format( |
| 737 | formatdate(posting_date) |
| 738 | ) |
| 739 | ) |
Nabin Hait | 2ed0b59 | 2016-03-29 13:14:17 +0530 | [diff] [blame] | 740 | else: |
| 741 | fiscal_year = fiscal_years[0][0] |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 742 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 743 | gl_dict = frappe._dict( |
| 744 | { |
| 745 | "company": self.company, |
| 746 | "posting_date": posting_date, |
| 747 | "fiscal_year": fiscal_year, |
| 748 | "voucher_type": self.doctype, |
| 749 | "voucher_no": self.name, |
| 750 | "remarks": self.get("remarks") or self.get("remark"), |
| 751 | "debit": 0, |
| 752 | "credit": 0, |
| 753 | "debit_in_account_currency": 0, |
| 754 | "credit_in_account_currency": 0, |
| 755 | "is_opening": self.get("is_opening") or "No", |
| 756 | "party_type": None, |
| 757 | "party": None, |
| 758 | "project": self.get("project"), |
| 759 | "post_net_value": args.get("post_net_value"), |
Deepesh Garg | da6bc1a | 2023-06-23 20:57:51 +0530 | [diff] [blame] | 760 | "voucher_detail_no": args.get("voucher_detail_no"), |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 761 | } |
| 762 | ) |
deepeshgarg007 | d83cf65 | 2019-05-12 18:34:23 +0530 | [diff] [blame] | 763 | |
Sagar Vora | 4205f56 | 2023-07-24 18:37:36 +0530 | [diff] [blame] | 764 | with temporary_flag("company", self.company): |
| 765 | update_gl_dict_with_regional_fields(self, gl_dict) |
| 766 | |
deepeshgarg007 | d83cf65 | 2019-05-12 18:34:23 +0530 | [diff] [blame] | 767 | accounting_dimensions = get_accounting_dimensions() |
| 768 | dimension_dict = frappe._dict() |
| 769 | |
| 770 | for dimension in accounting_dimensions: |
| 771 | dimension_dict[dimension] = self.get(dimension) |
deepeshgarg007 | 3d11ac0 | 2019-05-19 00:02:01 +0530 | [diff] [blame] | 772 | if item and item.get(dimension): |
| 773 | dimension_dict[dimension] = item.get(dimension) |
deepeshgarg007 | d83cf65 | 2019-05-12 18:34:23 +0530 | [diff] [blame] | 774 | |
| 775 | gl_dict.update(dimension_dict) |
Nabin Hait | 2df4d54 | 2013-01-29 11:34:39 +0530 | [diff] [blame] | 776 | gl_dict.update(args) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 777 | |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 778 | if not account_currency: |
Anand Doshi | cd0989e | 2015-09-28 13:31:17 +0530 | [diff] [blame] | 779 | account_currency = get_account_currency(gl_dict.account) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 780 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 781 | if gl_dict.account and self.doctype not in [ |
| 782 | "Journal Entry", |
| 783 | "Period Closing Voucher", |
| 784 | "Payment Entry", |
| 785 | "Purchase Receipt", |
| 786 | "Purchase Invoice", |
| 787 | "Stock Entry", |
| 788 | ]: |
Anand Doshi | be6cfdd | 2015-09-17 21:07:04 +0530 | [diff] [blame] | 789 | self.validate_account_currency(gl_dict.account, account_currency) |
Deepesh Garg | 7c30085 | 2020-12-26 20:14:51 +0530 | [diff] [blame] | 790 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 791 | if gl_dict.account and self.doctype not in [ |
| 792 | "Journal Entry", |
| 793 | "Period Closing Voucher", |
| 794 | "Payment Entry", |
| 795 | ]: |
| 796 | set_balance_in_account_currency( |
| 797 | gl_dict, account_currency, self.get("conversion_rate"), self.company_currency |
| 798 | ) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 799 | |
Nabin Hait | c561a49 | 2015-08-19 19:22:34 +0530 | [diff] [blame] | 800 | return gl_dict |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 801 | |
Anurag Mishra | e657fe8 | 2018-11-26 15:19:17 +0530 | [diff] [blame] | 802 | def validate_qty_is_not_zero(self): |
Marica | c68a940 | 2019-12-03 12:59:22 +0530 | [diff] [blame] | 803 | if self.doctype != "Purchase Receipt": |
| 804 | for item in self.items: |
| 805 | if not item.qty: |
| 806 | frappe.throw(_("Item quantity can not be zero")) |
Anurag Mishra | e657fe8 | 2018-11-26 15:19:17 +0530 | [diff] [blame] | 807 | |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 808 | def validate_account_currency(self, account, account_currency=None): |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 809 | valid_currency = [self.company_currency] |
| 810 | if self.get("currency") and self.currency != self.company_currency: |
| 811 | valid_currency.append(self.currency) |
| 812 | |
Nabin Hait | 895029d | 2015-08-20 14:55:39 +0530 | [diff] [blame] | 813 | if account_currency not in valid_currency: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 814 | frappe.throw( |
| 815 | _("Account {0} is invalid. Account Currency must be {1}").format( |
| 816 | account, (" " + _("or") + " ").join(valid_currency) |
| 817 | ) |
| 818 | ) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 819 | |
Anand Doshi | 613cb6a | 2013-02-06 17:33:46 +0530 | [diff] [blame] | 820 | def clear_unallocated_advances(self, childtype, parentfield): |
Rushabh Mehta | f191f85 | 2014-04-02 18:09:34 +0530 | [diff] [blame] | 821 | self.set(parentfield, self.get(parentfield, {"allocated_amount": ["not in", [0, None, ""]]})) |
| 822 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 823 | frappe.db.sql( |
| 824 | """delete from `tab%s` where parentfield=%s and parent = %s |
| 825 | and allocated_amount = 0""" |
| 826 | % (childtype, "%s", "%s"), |
| 827 | (parentfield, self.name), |
| 828 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 829 | |
Walstan Baptista | d636075 | 2021-03-31 12:30:32 +0530 | [diff] [blame] | 830 | @frappe.whitelist() |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 831 | def apply_shipping_rule(self): |
| 832 | if self.shipping_rule: |
| 833 | shipping_rule = frappe.get_doc("Shipping Rule", self.shipping_rule) |
| 834 | shipping_rule.apply(self) |
| 835 | self.calculate_taxes_and_totals() |
| 836 | |
| 837 | def get_shipping_address(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 838 | """Returns Address object from shipping address fields if present""" |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 839 | |
| 840 | # shipping address fields can be `shipping_address_name` or `shipping_address` |
| 841 | # try getting value from both |
| 842 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 843 | for fieldname in ("shipping_address_name", "shipping_address"): |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 844 | shipping_field = self.meta.get_field(fieldname) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 845 | if shipping_field and shipping_field.fieldtype == "Link": |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 846 | if self.get(fieldname): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 847 | return frappe.get_doc("Address", self.get(fieldname)) |
Rushabh Mehta | 30dc9a1 | 2017-11-17 14:31:09 +0530 | [diff] [blame] | 848 | |
| 849 | return {} |
| 850 | |
Walstan Baptista | d636075 | 2021-03-31 12:30:32 +0530 | [diff] [blame] | 851 | @frappe.whitelist() |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 852 | def set_advances(self): |
| 853 | """Returns list of advances against Account, Party, Reference""" |
| 854 | |
Deepesh Garg | fd3fb64 | 2023-04-05 12:02:44 +0530 | [diff] [blame] | 855 | res = self.get_advance_entries( |
| 856 | include_unallocated=not cint(self.get("only_include_allocated_payments")) |
| 857 | ) |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 858 | |
| 859 | self.set("advances", []) |
| 860 | advance_allocated = 0 |
| 861 | for d in res: |
Deepesh Garg | 181df2f | 2022-11-04 15:49:37 +0530 | [diff] [blame] | 862 | if self.get("party_account_currency") == self.company_currency: |
| 863 | amount = self.get("base_rounded_total") or self.base_grand_total |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 864 | else: |
Deepesh Garg | 181df2f | 2022-11-04 15:49:37 +0530 | [diff] [blame] | 865 | amount = self.get("rounded_total") or self.grand_total |
Deepesh Garg | 181df2f | 2022-11-04 15:49:37 +0530 | [diff] [blame] | 866 | allocated_amount = min(amount - advance_allocated, d.amount) |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 867 | advance_allocated += flt(allocated_amount) |
Rushabh Mehta | 708e47a | 2018-08-08 16:37:31 +0530 | [diff] [blame] | 868 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 869 | advance_row = { |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 870 | "doctype": self.doctype + " Advance", |
| 871 | "reference_type": d.reference_type, |
| 872 | "reference_name": d.reference_name, |
| 873 | "reference_row": d.reference_row, |
| 874 | "remarks": d.remarks, |
| 875 | "advance_amount": flt(d.amount), |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 876 | "allocated_amount": allocated_amount, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 877 | "ref_exchange_rate": flt(d.exchange_rate), # exchange_rate of advance entry |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 878 | } |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 879 | if d.get("paid_from"): |
| 880 | advance_row["account"] = d.paid_from |
| 881 | if d.get("paid_to"): |
| 882 | advance_row["account"] = d.paid_to |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 883 | |
| 884 | self.append("advances", advance_row) |
Nabin Hait | 041a5c2 | 2018-08-01 18:07:39 +0530 | [diff] [blame] | 885 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 886 | def get_advance_entries(self, include_unallocated=True): |
| 887 | if self.doctype == "Sales Invoice": |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 888 | party_type = "Customer" |
| 889 | party = self.customer |
| 890 | amount_field = "credit_in_account_currency" |
| 891 | order_field = "sales_order" |
| 892 | order_doctype = "Sales Order" |
| 893 | else: |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 894 | party_type = "Supplier" |
| 895 | party = self.supplier |
| 896 | amount_field = "debit_in_account_currency" |
| 897 | order_field = "purchase_order" |
| 898 | order_doctype = "Purchase Order" |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 899 | |
| 900 | party_account = get_party_account( |
| 901 | party_type, party=party, company=self.company, include_advance=True |
| 902 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 903 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 904 | 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] | 905 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 906 | journal_entries = get_advance_journal_entries( |
| 907 | party_type, party, party_account, amount_field, order_doctype, order_list, include_unallocated |
| 908 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 909 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 910 | payment_entries = get_advance_payment_entries( |
| 911 | party_type, party, party_account, order_doctype, order_list, include_unallocated |
| 912 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 913 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 914 | res = journal_entries + payment_entries |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 915 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 916 | return res |
Nabin Hait | 48f5fa6 | 2014-09-18 15:03:54 +0530 | [diff] [blame] | 917 | |
rohitwaghchaure | bf4c114 | 2018-01-08 15:20:15 +0530 | [diff] [blame] | 918 | def is_inclusive_tax(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 919 | is_inclusive = cint( |
| 920 | frappe.db.get_single_value("Accounts Settings", "show_inclusive_tax_in_print") |
| 921 | ) |
rohitwaghchaure | bf4c114 | 2018-01-08 15:20:15 +0530 | [diff] [blame] | 922 | |
| 923 | if is_inclusive: |
| 924 | is_inclusive = 0 |
| 925 | if self.get("taxes", filters={"included_in_print_rate": 1}): |
| 926 | is_inclusive = 1 |
| 927 | |
| 928 | return is_inclusive |
| 929 | |
Anand Baburajan | 491a50a | 2023-06-13 19:42:56 +0530 | [diff] [blame] | 930 | def should_show_taxes_as_table_in_print(self): |
| 931 | return cint(frappe.db.get_single_value("Accounts Settings", "show_taxes_as_table_in_print")) |
| 932 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 933 | def validate_advance_entries(self): |
Nabin Hait | 05aefbb | 2016-06-28 19:42:19 +0530 | [diff] [blame] | 934 | order_field = "sales_order" if self.doctype == "Sales Invoice" else "purchase_order" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 935 | 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] | 936 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 937 | if not order_list: |
| 938 | return |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 939 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 940 | advance_entries = self.get_advance_entries(include_unallocated=False) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 941 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 942 | if advance_entries: |
| 943 | advance_entries_against_si = [d.reference_name for d in self.get("advances")] |
| 944 | for d in advance_entries: |
| 945 | 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] | 946 | frappe.msgprint( |
| 947 | _( |
| 948 | "Payment Entry {0} is linked against Order {1}, check if it should be pulled as advance in this invoice." |
| 949 | ).format(d.reference_name, d.against_order) |
| 950 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 951 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 952 | def set_advance_gain_or_loss(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 953 | if self.get("conversion_rate") == 1 or not self.get("advances"): |
Saqib Ansari | 64efe8b | 2021-09-26 15:46:13 +0530 | [diff] [blame] | 954 | return |
| 955 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 956 | is_purchase_invoice = self.doctype == "Purchase Invoice" |
Saqib Ansari | 64efe8b | 2021-09-26 15:46:13 +0530 | [diff] [blame] | 957 | party_account = self.credit_to if is_purchase_invoice else self.debit_to |
| 958 | if get_account_currency(party_account) != self.currency: |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 959 | return |
| 960 | |
| 961 | for d in self.get("advances"): |
| 962 | advance_exchange_rate = d.ref_exchange_rate |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 963 | if d.allocated_amount and self.conversion_rate != advance_exchange_rate: |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 964 | |
| 965 | base_allocated_amount_in_ref_rate = advance_exchange_rate * d.allocated_amount |
| 966 | base_allocated_amount_in_inv_rate = self.conversion_rate * d.allocated_amount |
| 967 | difference = base_allocated_amount_in_ref_rate - base_allocated_amount_in_inv_rate |
| 968 | |
| 969 | d.exchange_gain_loss = difference |
| 970 | |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 971 | def make_exchange_gain_loss_journal(self) -> None: |
| 972 | """ |
| 973 | Make Exchange Gain/Loss journal for Invoices and Payments |
| 974 | """ |
| 975 | # Cancelling is existing exchange gain/loss journals is handled in on_cancel event |
| 976 | if self.docstatus == 1: |
| 977 | if self.get("doctype") == "Payment Entry": |
| 978 | gain_loss_to_book = [x for x in self.references if x.exchange_gain_loss != 0] |
| 979 | booked = [] |
| 980 | if gain_loss_to_book: |
| 981 | vtypes = [x.reference_doctype for x in gain_loss_to_book] |
| 982 | vnames = [x.reference_name for x in gain_loss_to_book] |
| 983 | je = qb.DocType("Journal Entry") |
| 984 | jea = qb.DocType("Journal Entry Account") |
| 985 | parents = ( |
| 986 | qb.from_(jea) |
| 987 | .select(jea.parent) |
| 988 | .where( |
| 989 | (jea.reference_type == "Payment Entry") |
| 990 | & (jea.reference_name == self.name) |
| 991 | & (jea.docstatus == 1) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 992 | ) |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 993 | .run() |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 994 | ) |
| 995 | |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 996 | booked = [] |
| 997 | if parents: |
| 998 | booked = ( |
| 999 | qb.from_(je) |
| 1000 | .inner_join(jea) |
| 1001 | .on(je.name == jea.parent) |
| 1002 | .select(jea.reference_type, jea.reference_name, jea.reference_detail_no) |
| 1003 | .where( |
| 1004 | (je.docstatus == 1) |
| 1005 | & (je.name.isin(parents)) |
| 1006 | & (je.voucher_type == "Exchange Gain or Loss") |
| 1007 | ) |
| 1008 | .run() |
| 1009 | ) |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 1010 | |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 1011 | for d in gain_loss_to_book: |
| 1012 | if d.exchange_gain_loss and ( |
| 1013 | (d.reference_doctype, d.reference_name, str(d.idx)) not in booked |
| 1014 | ): |
| 1015 | journal_entry = frappe.new_doc("Journal Entry") |
| 1016 | journal_entry.voucher_type = "Exchange Gain Or Loss" |
| 1017 | journal_entry.company = self.company |
| 1018 | journal_entry.posting_date = nowdate() |
| 1019 | journal_entry.multi_currency = 1 |
| 1020 | |
| 1021 | if self.payment_type == "Receive": |
| 1022 | party_account = self.paid_from |
| 1023 | elif self.payment_type == "Pay": |
| 1024 | party_account = self.paid_to |
| 1025 | |
| 1026 | party_account_currency = frappe.get_cached_value( |
| 1027 | "Account", party_account, "account_currency" |
| 1028 | ) |
| 1029 | dr_or_cr = "debit" if d.exchange_gain_loss > 0 else "credit" |
| 1030 | reverse_dr_or_cr = "debit" if dr_or_cr == "credit" else "credit" |
| 1031 | |
| 1032 | gain_loss_account = frappe.get_cached_value( |
| 1033 | "Company", self.company, "exchange_gain_loss_account" |
| 1034 | ) |
| 1035 | if not gain_loss_account: |
| 1036 | frappe.throw( |
| 1037 | _("Please set default Exchange Gain/Loss Account in Company {}").format( |
| 1038 | self.get("company") |
| 1039 | ) |
| 1040 | ) |
| 1041 | gain_loss_account_currency = get_account_currency(gain_loss_account) |
| 1042 | if gain_loss_account_currency != self.company_currency: |
| 1043 | frappe.throw( |
| 1044 | _("Currency for {0} must be {1}").format(gain_loss_account, self.company_currency) |
| 1045 | ) |
| 1046 | |
| 1047 | journal_account = frappe._dict( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1048 | { |
| 1049 | "account": party_account, |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 1050 | "party_type": self.party_type, |
| 1051 | "party": self.party, |
| 1052 | "account_currency": party_account_currency, |
| 1053 | "exchange_rate": 0, |
| 1054 | "cost_center": erpnext.get_default_cost_center(self.company), |
| 1055 | "reference_type": d.reference_doctype, |
| 1056 | "reference_name": d.reference_name, |
| 1057 | "reference_detail_no": d.idx, |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1058 | dr_or_cr: abs(d.exchange_gain_loss), |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 1059 | dr_or_cr + "_in_account_currency": 0, |
| 1060 | } |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1061 | ) |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 1062 | |
| 1063 | journal_entry.append("accounts", journal_account) |
| 1064 | |
| 1065 | journal_account = frappe._dict( |
| 1066 | { |
| 1067 | "account": gain_loss_account, |
| 1068 | "account_currency": gain_loss_account_currency, |
| 1069 | "exchange_rate": 1, |
| 1070 | "cost_center": erpnext.get_default_cost_center(self.company), |
| 1071 | "reference_type": self.doctype, |
| 1072 | "reference_name": self.name, |
| 1073 | "reference_detail_no": d.idx, |
| 1074 | reverse_dr_or_cr + "_in_account_currency": abs(d.exchange_gain_loss), |
| 1075 | reverse_dr_or_cr: abs(d.exchange_gain_loss), |
| 1076 | } |
| 1077 | ) |
| 1078 | |
| 1079 | journal_entry.append("accounts", journal_account) |
| 1080 | |
| 1081 | journal_entry.save() |
| 1082 | journal_entry.submit() |
| 1083 | # frappe.throw("stopping...") |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 1084 | |
Deepesh Garg | 016ed95 | 2023-06-20 13:22:32 +0530 | [diff] [blame] | 1085 | def update_against_document_in_jv(self): |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1086 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1087 | Links invoice and advance voucher: |
| 1088 | 1. cancel advance voucher |
| 1089 | 2. split into multiple rows if partially adjusted, assign against voucher |
| 1090 | 3. submit advance voucher |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1091 | """ |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 1092 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1093 | if self.doctype == "Sales Invoice": |
Nabin Hait | ff2f3ef | 2016-07-04 11:41:14 +0530 | [diff] [blame] | 1094 | party_type = "Customer" |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1095 | party = self.customer |
| 1096 | party_account = self.debit_to |
| 1097 | dr_or_cr = "credit_in_account_currency" |
| 1098 | else: |
Nabin Hait | ff2f3ef | 2016-07-04 11:41:14 +0530 | [diff] [blame] | 1099 | party_type = "Supplier" |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1100 | party = self.supplier |
| 1101 | party_account = self.credit_to |
| 1102 | dr_or_cr = "debit_in_account_currency" |
Nabin Hait | 48f5fa6 | 2014-09-18 15:03:54 +0530 | [diff] [blame] | 1103 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1104 | lst = [] |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1105 | for d in self.get("advances"): |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1106 | if flt(d.allocated_amount) > 0: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1107 | args = frappe._dict( |
| 1108 | { |
| 1109 | "voucher_type": d.reference_type, |
| 1110 | "voucher_no": d.reference_name, |
| 1111 | "voucher_detail_no": d.reference_row, |
| 1112 | "against_voucher_type": self.doctype, |
| 1113 | "against_voucher": self.name, |
| 1114 | "account": party_account, |
| 1115 | "party_type": party_type, |
| 1116 | "party": party, |
| 1117 | "is_advance": "Yes", |
| 1118 | "dr_or_cr": dr_or_cr, |
| 1119 | "unadjusted_amount": flt(d.advance_amount), |
| 1120 | "allocated_amount": flt(d.allocated_amount), |
| 1121 | "precision": d.precision("advance_amount"), |
| 1122 | "exchange_rate": ( |
| 1123 | self.conversion_rate if self.party_account_currency != self.company_currency else 1 |
| 1124 | ), |
| 1125 | "grand_total": ( |
| 1126 | self.base_grand_total |
| 1127 | if self.party_account_currency == self.company_currency |
| 1128 | else self.grand_total |
| 1129 | ), |
| 1130 | "outstanding_amount": self.outstanding_amount, |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1131 | "difference_account": frappe.get_cached_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1132 | "Company", self.company, "exchange_gain_loss_account" |
| 1133 | ), |
| 1134 | "exchange_gain_loss": flt(d.get("exchange_gain_loss")), |
| 1135 | } |
| 1136 | ) |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1137 | lst.append(args) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 1138 | |
Nabin Hait | 28a0528 | 2016-06-27 17:41:39 +0530 | [diff] [blame] | 1139 | if lst: |
| 1140 | from erpnext.accounts.utils import reconcile_against_document |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1141 | |
Deepesh Garg | 016ed95 | 2023-06-20 13:22:32 +0530 | [diff] [blame] | 1142 | reconcile_against_document(lst) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1143 | |
Rohit Waghchaure | 5fa9a7a | 2019-04-01 00:40:38 +0530 | [diff] [blame] | 1144 | def on_cancel(self): |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 1145 | from erpnext.accounts.utils import ( |
| 1146 | cancel_exchange_gain_loss_journal, |
| 1147 | unlink_ref_doc_from_payment_entries, |
| 1148 | ) |
Rohit Waghchaure | 5fa9a7a | 2019-04-01 00:40:38 +0530 | [diff] [blame] | 1149 | |
ruthra kumar | 81cd787 | 2023-04-27 09:46:54 +0530 | [diff] [blame^] | 1150 | if self.doctype in ["Sales Invoice", "Purchase Invoice", "Payment Entry"]: |
| 1151 | # Cancel Exchange Gain/Loss Journal before unlinking |
| 1152 | cancel_exchange_gain_loss_journal(self) |
| 1153 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1154 | 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] | 1155 | unlink_ref_doc_from_payment_entries(self) |
| 1156 | |
| 1157 | elif self.doctype in ["Sales Order", "Purchase Order"]: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1158 | if frappe.db.get_single_value( |
| 1159 | "Accounts Settings", "unlink_advance_payment_on_cancelation_of_order" |
| 1160 | ): |
Rohit Waghchaure | 5fa9a7a | 2019-04-01 00:40:38 +0530 | [diff] [blame] | 1161 | unlink_ref_doc_from_payment_entries(self) |
| 1162 | |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1163 | if self.doctype == "Sales Order": |
| 1164 | self.unlink_ref_doc_from_po() |
| 1165 | |
| 1166 | def unlink_ref_doc_from_po(self): |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1167 | so_items = [] |
| 1168 | for item in self.items: |
| 1169 | so_items.append(item.name) |
| 1170 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1171 | linked_po = list( |
| 1172 | set( |
| 1173 | frappe.get_all( |
| 1174 | "Purchase Order Item", |
| 1175 | filters={ |
| 1176 | "sales_order": self.name, |
| 1177 | "sales_order_item": ["in", so_items], |
| 1178 | "docstatus": ["<", 2], |
| 1179 | }, |
| 1180 | pluck="parent", |
| 1181 | ) |
| 1182 | ) |
| 1183 | ) |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1184 | |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1185 | if linked_po: |
GangaManoj | e77534f | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1186 | frappe.db.set_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1187 | "Purchase Order Item", |
| 1188 | {"sales_order": self.name, "sales_order_item": ["in", so_items], "docstatus": ["<", 2]}, |
| 1189 | {"sales_order": None, "sales_order_item": None}, |
GangaManoj | e77534f | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1190 | ) |
GangaManoj | 8396f24 | 2021-09-20 19:01:46 +0530 | [diff] [blame] | 1191 | |
| 1192 | frappe.msgprint(_("Purchase Orders {0} are un-linked").format("\n".join(linked_po))) |
| 1193 | |
Deepesh Garg | d18dde7 | 2020-11-29 21:40:04 +0530 | [diff] [blame] | 1194 | def get_tax_map(self): |
| 1195 | tax_map = {} |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1196 | for tax in self.get("taxes"): |
Deepesh Garg | d18dde7 | 2020-11-29 21:40:04 +0530 | [diff] [blame] | 1197 | tax_map.setdefault(tax.account_head, 0.0) |
| 1198 | tax_map[tax.account_head] += tax.tax_amount |
| 1199 | |
| 1200 | return tax_map |
| 1201 | |
Deepesh Garg | 92f7a5a | 2021-07-21 15:25:40 +0530 | [diff] [blame] | 1202 | def get_amount_and_base_amount(self, item, enable_discount_accounting): |
| 1203 | amount = item.net_amount |
| 1204 | base_amount = item.base_net_amount |
| 1205 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1206 | if ( |
| 1207 | enable_discount_accounting |
| 1208 | and self.get("discount_amount") |
| 1209 | and self.get("additional_discount_account") |
| 1210 | ): |
Deepesh Garg | 92f7a5a | 2021-07-21 15:25:40 +0530 | [diff] [blame] | 1211 | amount = item.amount |
| 1212 | base_amount = item.base_amount |
| 1213 | |
| 1214 | return amount, base_amount |
| 1215 | |
| 1216 | def get_tax_amounts(self, tax, enable_discount_accounting): |
| 1217 | amount = tax.tax_amount_after_discount_amount |
| 1218 | base_amount = tax.base_tax_amount_after_discount_amount |
| 1219 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1220 | if ( |
| 1221 | enable_discount_accounting |
| 1222 | and self.get("discount_amount") |
| 1223 | and self.get("additional_discount_account") |
| 1224 | and self.get("apply_discount_on") == "Grand Total" |
| 1225 | ): |
Deepesh Garg | 92f7a5a | 2021-07-21 15:25:40 +0530 | [diff] [blame] | 1226 | amount = tax.tax_amount |
| 1227 | base_amount = tax.base_tax_amount |
| 1228 | |
| 1229 | return amount, base_amount |
| 1230 | |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1231 | def make_discount_gl_entries(self, gl_entries): |
rahib-hassan | f3fa6ac | 2022-04-20 16:01:12 +0530 | [diff] [blame] | 1232 | if self.doctype == "Purchase Invoice": |
| 1233 | enable_discount_accounting = cint( |
| 1234 | frappe.db.get_single_value("Buying Settings", "enable_discount_accounting") |
| 1235 | ) |
| 1236 | elif self.doctype == "Sales Invoice": |
| 1237 | enable_discount_accounting = cint( |
| 1238 | frappe.db.get_single_value("Selling Settings", "enable_discount_accounting") |
| 1239 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1240 | |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1241 | if self.doctype == "Purchase Invoice": |
| 1242 | dr_or_cr = "credit" |
| 1243 | rev_dr_cr = "debit" |
| 1244 | supplier_or_customer = self.supplier |
| 1245 | |
| 1246 | else: |
| 1247 | dr_or_cr = "debit" |
| 1248 | rev_dr_cr = "credit" |
| 1249 | supplier_or_customer = self.customer |
| 1250 | |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1251 | if enable_discount_accounting: |
| 1252 | for item in self.get("items"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1253 | if item.get("discount_amount") and item.get("discount_account"): |
Deepesh Garg | ad7bb31 | 2021-07-28 11:38:44 +0530 | [diff] [blame] | 1254 | discount_amount = item.discount_amount * item.qty |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1255 | if self.doctype == "Purchase Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1256 | income_or_expense_account = ( |
| 1257 | item.expense_account |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1258 | if (not item.enable_deferred_expense or self.is_return) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1259 | else item.deferred_expense_account |
| 1260 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1261 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1262 | income_or_expense_account = ( |
| 1263 | item.income_account |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1264 | if (not item.enable_deferred_revenue or self.is_return) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1265 | else item.deferred_revenue_account |
| 1266 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1267 | |
| 1268 | account_currency = get_account_currency(item.discount_account) |
| 1269 | gl_entries.append( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1270 | self.get_gl_dict( |
| 1271 | { |
| 1272 | "account": item.discount_account, |
| 1273 | "against": supplier_or_customer, |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1274 | dr_or_cr: flt( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1275 | discount_amount * self.get("conversion_rate"), item.precision("discount_amount") |
| 1276 | ), |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1277 | 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] | 1278 | "cost_center": item.cost_center, |
| 1279 | "project": item.project, |
| 1280 | }, |
| 1281 | account_currency, |
| 1282 | item=item, |
| 1283 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1284 | ) |
| 1285 | |
| 1286 | account_currency = get_account_currency(income_or_expense_account) |
| 1287 | gl_entries.append( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1288 | self.get_gl_dict( |
| 1289 | { |
| 1290 | "account": income_or_expense_account, |
| 1291 | "against": supplier_or_customer, |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1292 | rev_dr_cr: flt( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1293 | discount_amount * self.get("conversion_rate"), item.precision("discount_amount") |
| 1294 | ), |
Saqib Ansari | f915a9c | 2022-05-17 11:22:01 +0530 | [diff] [blame] | 1295 | rev_dr_cr |
| 1296 | + "_in_account_currency": flt(discount_amount, item.precision("discount_amount")), |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1297 | "cost_center": item.cost_center, |
| 1298 | "project": item.project or self.project, |
| 1299 | }, |
| 1300 | account_currency, |
| 1301 | item=item, |
| 1302 | ) |
GangaManoj | 8f7b0a1 | 2021-07-13 03:01:02 +0530 | [diff] [blame] | 1303 | ) |
GangaManoj | 857501c | 2021-07-15 22:03:46 +0530 | [diff] [blame] | 1304 | |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1305 | if ( |
Deepesh Garg | ae3dce0 | 2022-08-22 08:57:58 +0530 | [diff] [blame] | 1306 | (enable_discount_accounting or self.get("is_cash_or_non_trade_discount")) |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1307 | and self.get("additional_discount_account") |
| 1308 | and self.get("discount_amount") |
| 1309 | ): |
| 1310 | gl_entries.append( |
| 1311 | self.get_gl_dict( |
| 1312 | { |
| 1313 | "account": self.additional_discount_account, |
| 1314 | "against": supplier_or_customer, |
| 1315 | dr_or_cr: self.discount_amount, |
| 1316 | "cost_center": self.cost_center, |
| 1317 | }, |
| 1318 | item=self, |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1319 | ) |
Deepesh Garg | 3b15966 | 2022-08-21 17:51:05 +0530 | [diff] [blame] | 1320 | ) |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1321 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1322 | def validate_multiple_billing(self, ref_dt, item_ref_dn, based_on): |
Nabin Hait | 868766d | 2019-07-15 18:02:58 +0530 | [diff] [blame] | 1323 | from erpnext.controllers.status_updater import get_allowance_for |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1324 | |
Nabin Hait | 868766d | 2019-07-15 18:02:58 +0530 | [diff] [blame] | 1325 | item_allowance = {} |
| 1326 | global_qty_allowance, global_amount_allowance = None, None |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1327 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1328 | role_allowed_to_over_bill = frappe.db.get_single_value( |
| 1329 | "Accounts Settings", "role_allowed_to_over_bill" |
| 1330 | ) |
Ankush Menat | 648b2d7 | 2021-09-20 15:27:12 +0530 | [diff] [blame] | 1331 | user_roles = frappe.get_roles() |
| 1332 | |
Ankush Menat | 43bf82b | 2021-09-20 16:31:20 +0530 | [diff] [blame] | 1333 | total_overbilled_amt = 0.0 |
| 1334 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1335 | reference_names = [d.get(item_ref_dn) for d in self.get("items") if d.get(item_ref_dn)] |
| 1336 | reference_details = self.get_billing_reference_details( |
| 1337 | reference_names, ref_dt + " Item", based_on |
| 1338 | ) |
| 1339 | |
Nabin Hait | 4b8185d | 2014-12-25 18:19:39 +0530 | [diff] [blame] | 1340 | for item in self.get("items"): |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1341 | if not item.get(item_ref_dn): |
| 1342 | continue |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1343 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1344 | ref_amt = flt(reference_details.get(item.get(item_ref_dn)), self.precision(based_on, item)) |
| 1345 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1346 | if not ref_amt: |
| 1347 | frappe.msgprint( |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1348 | _("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] | 1349 | item.item_code, ref_dt |
| 1350 | ), |
| 1351 | title=_("Warning"), |
| 1352 | indicator="orange", |
| 1353 | ) |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1354 | continue |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1355 | |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1356 | 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] | 1357 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1358 | total_billed_amt = flt( |
| 1359 | flt(already_billed) + flt(item.get(based_on)), self.precision(based_on, item) |
| 1360 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1361 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1362 | allowance, item_allowance, global_qty_allowance, global_amount_allowance = get_allowance_for( |
| 1363 | item.item_code, item_allowance, global_qty_allowance, global_amount_allowance, "amount" |
| 1364 | ) |
rohitwaghchaure | 285344e | 2019-10-11 11:02:11 +0530 | [diff] [blame] | 1365 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1366 | max_allowed_amt = flt(ref_amt * (100 + allowance) / 100) |
Deepesh Garg | cb718fc | 2021-04-19 13:25:15 +0530 | [diff] [blame] | 1367 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1368 | if total_billed_amt < 0 and max_allowed_amt < 0: |
| 1369 | # while making debit note against purchase return entry(purchase receipt) getting overbill error |
| 1370 | total_billed_amt = abs(total_billed_amt) |
| 1371 | max_allowed_amt = abs(max_allowed_amt) |
Afshan | 53fefd7 | 2021-06-24 10:09:02 +0530 | [diff] [blame] | 1372 | |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1373 | overbill_amt = total_billed_amt - max_allowed_amt |
| 1374 | total_overbilled_amt += overbill_amt |
| 1375 | |
| 1376 | if overbill_amt > 0.01 and role_allowed_to_over_bill not in user_roles: |
| 1377 | if self.doctype != "Purchase Invoice": |
| 1378 | self.throw_overbill_exception(item, max_allowed_amt) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1379 | elif not cint( |
| 1380 | frappe.db.get_single_value( |
| 1381 | "Buying Settings", "bill_for_rejected_quantity_in_purchase_invoice" |
| 1382 | ) |
| 1383 | ): |
Ankush Menat | 5e4fbba | 2021-09-20 16:36:27 +0530 | [diff] [blame] | 1384 | self.throw_overbill_exception(item, max_allowed_amt) |
| 1385 | |
| 1386 | 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] | 1387 | frappe.msgprint( |
| 1388 | _("Overbilling of {} ignored because you have {} role.").format( |
| 1389 | total_overbilled_amt, role_allowed_to_over_bill |
| 1390 | ), |
| 1391 | indicator="orange", |
| 1392 | alert=True, |
| 1393 | ) |
Afshan | 53fefd7 | 2021-06-24 10:09:02 +0530 | [diff] [blame] | 1394 | |
Deepesh Garg | 4c61ee3 | 2023-04-02 09:35:27 +0530 | [diff] [blame] | 1395 | def get_billing_reference_details(self, reference_names, reference_doctype, based_on): |
| 1396 | return frappe._dict( |
| 1397 | frappe.get_all( |
| 1398 | reference_doctype, |
| 1399 | filters={"name": ("in", reference_names)}, |
| 1400 | fields=["name", based_on], |
| 1401 | as_list=1, |
| 1402 | ) |
| 1403 | ) |
| 1404 | |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1405 | 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] | 1406 | """ |
| 1407 | Returns Sum of Amount of |
| 1408 | Sales/Purchase Invoice Items |
| 1409 | that are linked to `item_ref_dn` (`dn_detail` / `pr_detail`) |
| 1410 | that are submitted OR not submitted but are under current invoice |
| 1411 | """ |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1412 | |
| 1413 | from frappe.query_builder import Criterion |
| 1414 | from frappe.query_builder.functions import Sum |
| 1415 | |
| 1416 | item_doctype = frappe.qb.DocType(item.doctype) |
| 1417 | based_on_field = frappe.qb.Field(based_on) |
| 1418 | join_field = frappe.qb.Field(item_ref_dn) |
| 1419 | |
| 1420 | result = ( |
| 1421 | frappe.qb.from_(item_doctype) |
| 1422 | .select(Sum(based_on_field)) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1423 | .where(join_field == item.get(item_ref_dn)) |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1424 | .where( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1425 | Criterion.any( |
| 1426 | [ # select all items from other invoices OR current invoices |
| 1427 | Criterion.all( |
| 1428 | [ # for selecting items from other invoices |
| 1429 | item_doctype.docstatus == 1, |
| 1430 | item_doctype.parent != self.name, |
| 1431 | ] |
| 1432 | ), |
| 1433 | Criterion.all( |
| 1434 | [ # for selecting items from current invoice, that are linked to same reference |
| 1435 | item_doctype.docstatus == 0, |
| 1436 | item_doctype.parent == self.name, |
| 1437 | item_doctype.name != item.name, |
| 1438 | ] |
| 1439 | ), |
| 1440 | ] |
| 1441 | ) |
Saqib | 9c913c9 | 2021-11-26 12:00:13 +0530 | [diff] [blame] | 1442 | ) |
| 1443 | ).run() |
| 1444 | |
| 1445 | return result[0][0] if result else 0 |
| 1446 | |
Afshan | 53fefd7 | 2021-06-24 10:09:02 +0530 | [diff] [blame] | 1447 | def throw_overbill_exception(self, item, max_allowed_amt): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1448 | frappe.throw( |
| 1449 | _( |
| 1450 | "Cannot overbill for Item {0} in row {1} more than {2}. To allow over-billing, please set allowance in Accounts Settings" |
| 1451 | ).format(item.item_code, item.idx, max_allowed_amt) |
| 1452 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1453 | |
Rohit Waghchaure | 2a14f25 | 2021-07-30 12:36:35 +0530 | [diff] [blame] | 1454 | def get_company_default(self, fieldname, ignore_validation=False): |
Rushabh Mehta | 1f84799 | 2013-12-12 19:12:19 +0530 | [diff] [blame] | 1455 | from erpnext.accounts.utils import get_company_default |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1456 | |
Rohit Waghchaure | 2a14f25 | 2021-07-30 12:36:35 +0530 | [diff] [blame] | 1457 | return get_company_default(self.company, fieldname, ignore_validation=ignore_validation) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1458 | |
Nabin Hait | a36adbd | 2013-08-02 14:50:12 +0530 | [diff] [blame] | 1459 | def get_stock_items(self): |
| 1460 | stock_items = [] |
Nabin Hait | dd38a26 | 2014-12-26 13:15:21 +0530 | [diff] [blame] | 1461 | 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] | 1462 | if item_codes: |
Saqib Ansari | 199a6da | 2022-03-31 11:41:52 +0530 | [diff] [blame] | 1463 | stock_items = frappe.db.get_values( |
| 1464 | "Item", {"name": ["in", item_codes], "is_stock_item": 1}, pluck="name", cache=True |
| 1465 | ) |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1466 | |
Nabin Hait | a36adbd | 2013-08-02 14:50:12 +0530 | [diff] [blame] | 1467 | return stock_items |
Anand Doshi | d294650 | 2014-04-08 20:10:03 +0530 | [diff] [blame] | 1468 | |
Ankit Javalkar | 8e7ca41 | 2014-09-12 15:18:53 +0530 | [diff] [blame] | 1469 | def set_total_advance_paid(self): |
ruthra kumar | 4487065 | 2022-11-01 10:11:38 +0530 | [diff] [blame] | 1470 | ple = frappe.qb.DocType("Payment Ledger Entry") |
| 1471 | party = self.customer if self.doctype == "Sales Order" else self.supplier |
| 1472 | advance = ( |
| 1473 | frappe.qb.from_(ple) |
ruthra kumar | bf76b85 | 2022-11-22 12:16:11 +0530 | [diff] [blame] | 1474 | .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] | 1475 | .where( |
| 1476 | (ple.against_voucher_type == self.doctype) |
| 1477 | & (ple.against_voucher_no == self.name) |
| 1478 | & (ple.party == party) |
ruthra kumar | bf76b85 | 2022-11-22 12:16:11 +0530 | [diff] [blame] | 1479 | & (ple.docstatus == 1) |
ruthra kumar | 4487065 | 2022-11-01 10:11:38 +0530 | [diff] [blame] | 1480 | & (ple.company == self.company) |
| 1481 | ) |
| 1482 | .run(as_dict=True) |
| 1483 | ) |
Ankit Javalkar | 8e7ca41 | 2014-09-12 15:18:53 +0530 | [diff] [blame] | 1484 | |
Nabin Hait | b2206d1 | 2016-01-27 15:43:12 +0530 | [diff] [blame] | 1485 | if advance: |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1486 | advance = advance[0] |
Deepesh Garg | 2a9c5ba | 2020-04-30 10:38:58 +0530 | [diff] [blame] | 1487 | |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1488 | advance_paid = flt(advance.amount, self.precision("advance_paid")) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1489 | formatted_advance_paid = fmt_money( |
| 1490 | advance_paid, precision=self.precision("advance_paid"), currency=advance.account_currency |
| 1491 | ) |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1492 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1493 | 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] | 1494 | |
| 1495 | if advance.account_currency == self.currency: |
finbyz | 5efc797 | 2019-01-05 11:12:11 +0530 | [diff] [blame] | 1496 | order_total = self.get("rounded_total") or self.grand_total |
| 1497 | precision = "rounded_total" if self.get("rounded_total") else "grand_total" |
Nabin Hait | b2206d1 | 2016-01-27 15:43:12 +0530 | [diff] [blame] | 1498 | else: |
finbyz | 5efc797 | 2019-01-05 11:12:11 +0530 | [diff] [blame] | 1499 | order_total = self.get("base_rounded_total") or self.base_grand_total |
| 1500 | 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] | 1501 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1502 | formatted_order_total = fmt_money( |
| 1503 | order_total, precision=self.precision(precision), currency=advance.account_currency |
| 1504 | ) |
Anand Doshi | 7c0a58a | 2016-01-29 12:16:24 +0530 | [diff] [blame] | 1505 | |
Nabin Hait | 9db1b22 | 2016-06-30 12:37:53 +0530 | [diff] [blame] | 1506 | if self.currency == self.company_currency and advance_paid > order_total: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1507 | frappe.throw( |
| 1508 | _( |
| 1509 | "Total advance ({0}) against Order {1} cannot be greater than the Grand Total ({2})" |
| 1510 | ).format(formatted_advance_paid, self.name, formatted_order_total) |
| 1511 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 1512 | |
Nabin Hait | 13093b4 | 2016-06-29 18:04:37 +0530 | [diff] [blame] | 1513 | frappe.db.set_value(self.doctype, self.name, "advance_paid", advance_paid) |
Ankit Javalkar | 8e7ca41 | 2014-09-12 15:18:53 +0530 | [diff] [blame] | 1514 | |
ankitjavalkarwork | e60822b | 2014-08-26 14:29:06 +0530 | [diff] [blame] | 1515 | @property |
| 1516 | def company_abbr(self): |
Nabin Hait | 6a5695f | 2018-08-09 11:30:21 +0530 | [diff] [blame] | 1517 | if not hasattr(self, "_abbr"): |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1518 | self._abbr = frappe.get_cached_value("Company", self.company, "abbr") |
ankitjavalkarwork | e60822b | 2014-08-26 14:29:06 +0530 | [diff] [blame] | 1519 | |
| 1520 | return self._abbr |
| 1521 | |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1522 | def raise_missing_debit_credit_account_error(self, party_type, party): |
marination | 53b1a9a | 2020-11-03 15:45:25 +0530 | [diff] [blame] | 1523 | """Raise an error if debit to/credit to account does not exist.""" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1524 | db_or_cr = ( |
| 1525 | frappe.bold("Debit To") if self.doctype == "Sales Invoice" else frappe.bold("Credit To") |
| 1526 | ) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1527 | rec_or_pay = "Receivable" if self.doctype == "Sales Invoice" else "Payable" |
| 1528 | |
| 1529 | link_to_party = frappe.utils.get_link_to_form(party_type, party) |
| 1530 | link_to_company = frappe.utils.get_link_to_form("Company", self.company) |
| 1531 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1532 | message = _("{0} Account not found against Customer {1}.").format( |
| 1533 | db_or_cr, frappe.bold(party) or "" |
| 1534 | ) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1535 | message += "<br>" + _("Please set one of the following:") + "<br>" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1536 | message += ( |
| 1537 | "<br><ul><li>" |
| 1538 | + _("'Account' in the Accounting section of Customer {0}").format(link_to_party) |
| 1539 | + "</li>" |
| 1540 | ) |
| 1541 | message += ( |
| 1542 | "<li>" |
| 1543 | + _("'Default {0} Account' in Company {1}").format(rec_or_pay, link_to_company) |
| 1544 | + "</li></ul>" |
| 1545 | ) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1546 | |
marination | 53b1a9a | 2020-11-03 15:45:25 +0530 | [diff] [blame] | 1547 | frappe.throw(message, title=_("Account Missing"), exc=AccountMissingError) |
marination | 4be5b5c | 2020-10-08 19:08:27 +0530 | [diff] [blame] | 1548 | |
Neil Trini Lasrado | 3fbbb71 | 2015-07-17 12:10:12 +0530 | [diff] [blame] | 1549 | def validate_party(self): |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1550 | party_type, party = self.get_party() |
shreyas | eba9ca4 | 2016-01-26 14:56:52 +0530 | [diff] [blame] | 1551 | validate_party_frozen_disabled(party_type, party) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1552 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1553 | def get_party(self): |
Neil Trini Lasrado | 79bf233 | 2015-07-20 13:03:48 +0530 | [diff] [blame] | 1554 | party_type = None |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1555 | if self.doctype in ("Opportunity", "Quotation", "Sales Order", "Delivery Note", "Sales Invoice"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1556 | party_type = "Customer" |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1557 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1558 | elif self.doctype in ( |
| 1559 | "Supplier Quotation", |
| 1560 | "Purchase Order", |
| 1561 | "Purchase Receipt", |
| 1562 | "Purchase Invoice", |
| 1563 | ): |
| 1564 | party_type = "Supplier" |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1565 | |
| 1566 | elif self.meta.get_field("customer"): |
| 1567 | party_type = "Customer" |
Neil Trini Lasrado | 3fbbb71 | 2015-07-17 12:10:12 +0530 | [diff] [blame] | 1568 | |
Neil Trini Lasrado | 79bf233 | 2015-07-20 13:03:48 +0530 | [diff] [blame] | 1569 | elif self.meta.get_field("supplier"): |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1570 | party_type = "Supplier" |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1571 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1572 | party = self.get(party_type.lower()) if party_type else None |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1573 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1574 | return party_type, party |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1575 | |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1576 | def validate_currency(self): |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 1577 | if self.get("currency"): |
Nabin Hait | 4ffd7f3 | 2015-08-27 12:28:36 +0530 | [diff] [blame] | 1578 | party_type, party = self.get_party() |
Nabin Hait | 6e439a5 | 2015-08-28 19:24:22 +0530 | [diff] [blame] | 1579 | if party_type and party: |
Anand Doshi | b20baf8 | 2015-09-25 16:17:50 +0530 | [diff] [blame] | 1580 | party_account_currency = get_party_account_currency(party_type, party, self.company) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1581 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1582 | if ( |
| 1583 | party_account_currency |
| 1584 | and party_account_currency != self.company_currency |
| 1585 | and self.currency != party_account_currency |
| 1586 | ): |
| 1587 | frappe.throw( |
| 1588 | _("Accounting Entry for {0}: {1} can only be made in currency: {2}").format( |
| 1589 | party_type, party, party_account_currency |
| 1590 | ), |
| 1591 | InvalidCurrency, |
| 1592 | ) |
Anand Doshi | 979326b | 2015-09-11 16:22:37 +0530 | [diff] [blame] | 1593 | |
shreyas | 29b565f | 2016-01-25 17:30:49 +0530 | [diff] [blame] | 1594 | # Note: not validating with gle account because we don't have the account |
| 1595 | # at quotation / sales order level and we shouldn't stop someone |
| 1596 | # from creating a sales invoice if sales order is already created |
Rushabh Mehta | 2cb7a9f | 2016-06-15 16:45:03 +0530 | [diff] [blame] | 1597 | |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1598 | def validate_party_account_currency(self): |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1599 | if self.doctype not in ("Sales Invoice", "Purchase Invoice"): |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1600 | return |
| 1601 | |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1602 | if self.is_opening == "Yes": |
Deepesh Garg | 60915e8 | 2021-08-21 23:05:48 +0530 | [diff] [blame] | 1603 | return |
| 1604 | |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1605 | party_type, party = self.get_party() |
| 1606 | party_gle_currency = get_party_gle_currency(party_type, party, self.company) |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1607 | party_account = ( |
| 1608 | self.get("debit_to") if self.doctype == "Sales Invoice" else self.get("credit_to") |
| 1609 | ) |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1610 | party_account_currency = get_account_currency(party_account) |
Deepesh Garg | e04e67c | 2022-07-11 19:25:18 +0530 | [diff] [blame] | 1611 | 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] | 1612 | "Accounts Settings", "allow_multi_currency_invoices_against_single_party_account" |
| 1613 | ) |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1614 | |
Deepesh Garg | 3cf609f | 2022-07-11 13:46:59 +0530 | [diff] [blame] | 1615 | if ( |
| 1616 | not party_gle_currency |
| 1617 | and (party_account_currency != self.currency) |
| 1618 | and not allow_multi_currency_invoices_against_single_party_account |
| 1619 | ): |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1620 | frappe.throw( |
Devin Slauenwhite | 3a1c923 | 2022-06-02 14:15:50 -0400 | [diff] [blame] | 1621 | _("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] | 1622 | frappe.bold(party_account), party_account_currency, self.currency |
Deepesh Garg | 33d9767 | 2022-05-12 16:40:29 +0530 | [diff] [blame] | 1623 | ) |
| 1624 | ) |
Deepesh Garg | 80c85dd | 2021-08-12 15:39:07 +0530 | [diff] [blame] | 1625 | |
Nabin Hait | 297d74a | 2016-11-23 15:58:51 +0530 | [diff] [blame] | 1626 | def delink_advance_entries(self, linked_doc_name): |
| 1627 | total_allocated_amount = 0 |
| 1628 | for adv in self.advances: |
| 1629 | consider_for_total_advance = True |
| 1630 | if adv.reference_name == linked_doc_name: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1631 | frappe.db.sql( |
| 1632 | """delete from `tab{0} Advance` |
| 1633 | where name = %s""".format( |
| 1634 | self.doctype |
| 1635 | ), |
| 1636 | adv.name, |
| 1637 | ) |
Nabin Hait | 297d74a | 2016-11-23 15:58:51 +0530 | [diff] [blame] | 1638 | consider_for_total_advance = False |
| 1639 | |
| 1640 | if consider_for_total_advance: |
| 1641 | total_allocated_amount += flt(adv.allocated_amount, adv.precision("allocated_amount")) |
| 1642 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1643 | frappe.db.set_value( |
| 1644 | self.doctype, self.name, "total_advance", total_allocated_amount, update_modified=False |
| 1645 | ) |
Rohit Waghchaure | 6087fe1 | 2016-04-09 14:31:09 +0530 | [diff] [blame] | 1646 | |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1647 | def group_similar_items(self): |
| 1648 | group_item_qty = {} |
| 1649 | group_item_amount = {} |
Shreya Shah | 785f1aa | 2018-10-11 10:14:25 +0530 | [diff] [blame] | 1650 | # to update serial number in print |
| 1651 | count = 0 |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1652 | |
| 1653 | for item in self.items: |
| 1654 | group_item_qty[item.item_code] = group_item_qty.get(item.item_code, 0) + item.qty |
| 1655 | group_item_amount[item.item_code] = group_item_amount.get(item.item_code, 0) + item.amount |
| 1656 | |
| 1657 | duplicate_list = [] |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1658 | for item in self.items: |
| 1659 | if item.item_code in group_item_qty: |
Shreya Shah | 785f1aa | 2018-10-11 10:14:25 +0530 | [diff] [blame] | 1660 | count += 1 |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1661 | item.qty = group_item_qty[item.item_code] |
| 1662 | item.amount = group_item_amount[item.item_code] |
deepeshgarg007 | e8d21cd | 2019-06-24 17:46:44 +0530 | [diff] [blame] | 1663 | |
| 1664 | if item.qty: |
| 1665 | item.rate = flt(flt(item.amount) / flt(item.qty), item.precision("rate")) |
| 1666 | else: |
| 1667 | item.rate = 0 |
| 1668 | |
Shreya Shah | 785f1aa | 2018-10-11 10:14:25 +0530 | [diff] [blame] | 1669 | item.idx = count |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1670 | del group_item_qty[item.item_code] |
| 1671 | else: |
| 1672 | duplicate_list.append(item) |
KanchanChauhan | 49a50fe | 2016-11-18 13:57:53 +0530 | [diff] [blame] | 1673 | for item in duplicate_list: |
| 1674 | self.remove(item) |
| 1675 | |
tunde | 32aa7c1 | 2017-09-07 06:52:15 +0100 | [diff] [blame] | 1676 | def set_payment_schedule(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1677 | if self.doctype == "Sales Invoice" and self.is_pos: |
| 1678 | self.payment_terms_template = "" |
Manas Solanki | a7f5589 | 2018-04-02 10:32:00 +0530 | [diff] [blame] | 1679 | return |
rohitwaghchaure | db9fa78 | 2018-03-01 10:32:29 +0530 | [diff] [blame] | 1680 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1681 | party_account_currency = self.get("party_account_currency") |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1682 | if not party_account_currency: |
| 1683 | party_type, party = self.get_party() |
| 1684 | |
| 1685 | if party_type and party: |
| 1686 | party_account_currency = get_party_account_currency(party_type, party, self.company) |
| 1687 | |
rohitwaghchaure | da941af | 2018-01-17 16:23:04 +0530 | [diff] [blame] | 1688 | 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] | 1689 | date = self.get("due_date") |
| 1690 | due_date = date or posting_date |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1691 | |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1692 | base_grand_total = self.get("base_rounded_total") or self.base_grand_total |
| 1693 | grand_total = self.get("rounded_total") or self.grand_total |
Deepesh Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 1694 | automatically_fetch_payment_terms = 0 |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1695 | |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 1696 | if self.doctype in ("Sales Invoice", "Purchase Invoice"): |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1697 | base_grand_total = base_grand_total - flt(self.base_write_off_amount) |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 1698 | grand_total = grand_total - flt(self.write_off_amount) |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1699 | po_or_so, doctype, fieldname = self.get_order_details() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1700 | automatically_fetch_payment_terms = cint( |
| 1701 | frappe.db.get_single_value("Accounts Settings", "automatically_fetch_payment_terms") |
| 1702 | ) |
tunde | 96b8f22 | 2017-09-08 15:35:59 +0100 | [diff] [blame] | 1703 | |
Rohit Waghchaure | 4a267b9 | 2019-05-09 19:50:00 +0530 | [diff] [blame] | 1704 | if self.get("total_advance"): |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1705 | if party_account_currency == self.company_currency: |
| 1706 | base_grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1707 | grand_total = flt( |
| 1708 | base_grand_total / self.get("conversion_rate"), self.precision("grand_total") |
| 1709 | ) |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1710 | else: |
| 1711 | grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1712 | base_grand_total = flt( |
| 1713 | grand_total * self.get("conversion_rate"), self.precision("base_grand_total") |
| 1714 | ) |
Rohit Waghchaure | 4a267b9 | 2019-05-09 19:50:00 +0530 | [diff] [blame] | 1715 | |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1716 | if not self.get("payment_schedule"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1717 | if ( |
| 1718 | self.doctype in ["Sales Invoice", "Purchase Invoice"] |
| 1719 | and automatically_fetch_payment_terms |
| 1720 | and self.linked_order_has_payment_terms(po_or_so, fieldname, doctype) |
| 1721 | ): |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1722 | self.fetch_payment_terms_from_order(po_or_so, doctype) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1723 | if self.get("payment_terms_template"): |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1724 | self.ignore_default_payment_terms_template = 1 |
| 1725 | elif self.get("payment_terms_template"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1726 | data = get_payment_terms( |
| 1727 | self.payment_terms_template, posting_date, grand_total, base_grand_total |
| 1728 | ) |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1729 | for item in data: |
| 1730 | self.append("payment_schedule", item) |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1731 | elif self.doctype not in ["Purchase Receipt"]: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1732 | data = dict( |
| 1733 | due_date=due_date, |
| 1734 | invoice_portion=100, |
| 1735 | payment_amount=grand_total, |
| 1736 | base_payment_amount=base_grand_total, |
| 1737 | ) |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1738 | self.append("payment_schedule", data) |
Deepesh Garg | bcf56e6 | 2021-08-06 23:53:16 +0530 | [diff] [blame] | 1739 | |
Deepesh Garg | f7b50f2 | 2023-04-25 19:18:45 +0530 | [diff] [blame] | 1740 | if not ( |
| 1741 | automatically_fetch_payment_terms |
| 1742 | and self.linked_order_has_payment_terms(po_or_so, fieldname, doctype) |
| 1743 | ): |
Deepesh Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 1744 | for d in self.get("payment_schedule"): |
| 1745 | if d.invoice_portion: |
| 1746 | d.payment_amount = flt( |
| 1747 | grand_total * flt(d.invoice_portion / 100), d.precision("payment_amount") |
| 1748 | ) |
| 1749 | d.base_payment_amount = flt( |
| 1750 | base_grand_total * flt(d.invoice_portion / 100), d.precision("base_payment_amount") |
| 1751 | ) |
| 1752 | d.outstanding = d.payment_amount |
| 1753 | elif not d.invoice_portion: |
| 1754 | d.base_payment_amount = flt( |
| 1755 | d.payment_amount * self.get("conversion_rate"), d.precision("base_payment_amount") |
| 1756 | ) |
ruthra kumar | 0da6c16 | 2023-05-16 18:57:42 +0530 | [diff] [blame] | 1757 | else: |
| 1758 | self.fetch_payment_terms_from_order(po_or_so, doctype) |
| 1759 | self.ignore_default_payment_terms_template = 1 |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1760 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1761 | def get_order_details(self): |
| 1762 | if self.doctype == "Sales Invoice": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1763 | po_or_so = self.get("items")[0].get("sales_order") |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1764 | po_or_so_doctype = "Sales Order" |
| 1765 | po_or_so_doctype_name = "sales_order" |
| 1766 | |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1767 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1768 | po_or_so = self.get("items")[0].get("purchase_order") |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1769 | po_or_so_doctype = "Purchase Order" |
| 1770 | po_or_so_doctype_name = "purchase_order" |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1771 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1772 | return po_or_so, po_or_so_doctype, po_or_so_doctype_name |
| 1773 | |
GangaManoj | c7c9024 | 2021-07-29 19:18:35 +0530 | [diff] [blame] | 1774 | def linked_order_has_payment_terms(self, po_or_so, fieldname, doctype): |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1775 | 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] | 1776 | if self.linked_order_has_payment_terms_template(po_or_so, doctype): |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1777 | return True |
| 1778 | elif self.linked_order_has_payment_schedule(po_or_so): |
| 1779 | return True |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1780 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1781 | return False |
| 1782 | |
| 1783 | 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] | 1784 | for item in self.get("items"): |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1785 | if item.get(fieldname) != po_or_so: |
| 1786 | return False |
Ankush Menat | 4551d7d | 2021-08-19 13:41:10 +0530 | [diff] [blame] | 1787 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1788 | return True |
| 1789 | |
GangaManoj | c7c9024 | 2021-07-29 19:18:35 +0530 | [diff] [blame] | 1790 | def linked_order_has_payment_terms_template(self, po_or_so, doctype): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1791 | return frappe.get_value(doctype, po_or_so, "payment_terms_template") |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1792 | |
| 1793 | def linked_order_has_payment_schedule(self, po_or_so): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1794 | return frappe.get_all("Payment Schedule", filters={"parent": po_or_so}) |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1795 | |
| 1796 | def fetch_payment_terms_from_order(self, po_or_so, po_or_so_doctype): |
| 1797 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1798 | 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] | 1799 | """ |
| 1800 | po_or_so = frappe.get_cached_doc(po_or_so_doctype, po_or_so) |
| 1801 | |
| 1802 | self.payment_schedule = [] |
| 1803 | self.payment_terms_template = po_or_so.payment_terms_template |
| 1804 | |
| 1805 | for schedule in po_or_so.payment_schedule: |
| 1806 | payment_schedule = { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1807 | "payment_term": schedule.payment_term, |
| 1808 | "due_date": schedule.due_date, |
| 1809 | "invoice_portion": schedule.invoice_portion, |
| 1810 | "mode_of_payment": schedule.mode_of_payment, |
| 1811 | "description": schedule.description, |
Deepesh Garg | 5c75894 | 2023-04-16 17:11:24 +0530 | [diff] [blame] | 1812 | "payment_amount": schedule.payment_amount, |
| 1813 | "base_payment_amount": schedule.base_payment_amount, |
| 1814 | "outstanding": schedule.outstanding, |
| 1815 | "paid_amount": schedule.paid_amount, |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1816 | } |
GangaManoj | 5b33e75 | 2021-08-05 21:50:09 +0530 | [diff] [blame] | 1817 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1818 | if schedule.discount_type == "Percentage": |
| 1819 | payment_schedule["discount_type"] = schedule.discount_type |
| 1820 | payment_schedule["discount"] = schedule.discount |
GangaManoj | 5b33e75 | 2021-08-05 21:50:09 +0530 | [diff] [blame] | 1821 | |
ruthra kumar | 9bd56b0 | 2022-02-01 14:14:04 +0530 | [diff] [blame] | 1822 | if not schedule.invoice_portion: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1823 | payment_schedule["payment_amount"] = schedule.payment_amount |
ruthra kumar | 9bd56b0 | 2022-02-01 14:14:04 +0530 | [diff] [blame] | 1824 | |
GangaManoj | 4323f4b | 2021-07-22 05:57:42 +0530 | [diff] [blame] | 1825 | self.append("payment_schedule", payment_schedule) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1826 | |
tunde | be1b871 | 2017-08-19 08:21:44 +0100 | [diff] [blame] | 1827 | def set_due_date(self): |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1828 | due_dates = [d.due_date for d in self.get("payment_schedule") if d.due_date] |
| 1829 | if due_dates: |
| 1830 | self.due_date = max(due_dates) |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 1831 | |
| 1832 | def validate_payment_schedule_dates(self): |
tunde | 77ecacc | 2017-09-22 23:12:55 +0100 | [diff] [blame] | 1833 | dates = [] |
tunde | 9bed2de | 2017-09-25 10:19:35 +0100 | [diff] [blame] | 1834 | li = [] |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1835 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1836 | if self.doctype == "Sales Invoice" and self.is_pos: |
| 1837 | return |
rohitwaghchaure | db9fa78 | 2018-03-01 10:32:29 +0530 | [diff] [blame] | 1838 | |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1839 | for d in self.get("payment_schedule"): |
Nabin Hait | 2f9f4f9 | 2017-12-20 12:24:59 +0530 | [diff] [blame] | 1840 | 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] | 1841 | frappe.throw( |
| 1842 | _("Row {0}: Due Date in the Payment Terms table cannot be before Posting Date").format(d.idx) |
| 1843 | ) |
tunde | 77ecacc | 2017-09-22 23:12:55 +0100 | [diff] [blame] | 1844 | elif d.due_date in dates: |
mnatalia | 5f0e8d6 | 2018-05-22 06:38:50 +0300 | [diff] [blame] | 1845 | li.append(_("{0} in row {1}").format(d.due_date, d.idx)) |
tunde | 9bed2de | 2017-09-25 10:19:35 +0100 | [diff] [blame] | 1846 | dates.append(d.due_date) |
| 1847 | |
| 1848 | if li: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1849 | duplicates = "<br>" + "<br>".join(li) |
| 1850 | frappe.throw( |
| 1851 | _("Rows with duplicate due dates in other rows were found: {0}").format(duplicates) |
| 1852 | ) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1853 | |
tunde | 62af5c5 | 2017-09-22 15:16:38 +0100 | [diff] [blame] | 1854 | def validate_payment_schedule_amount(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1855 | if self.doctype == "Sales Invoice" and self.is_pos: |
| 1856 | return |
rohitwaghchaure | db9fa78 | 2018-03-01 10:32:29 +0530 | [diff] [blame] | 1857 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1858 | party_account_currency = self.get("party_account_currency") |
Deepesh Garg | 2621016 | 2020-08-11 16:06:13 +0530 | [diff] [blame] | 1859 | if not party_account_currency: |
| 1860 | party_type, party = self.get_party() |
| 1861 | |
| 1862 | if party_type and party: |
| 1863 | party_account_currency = get_party_account_currency(party_type, party, self.company) |
| 1864 | |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1865 | if self.get("payment_schedule"): |
| 1866 | total = 0 |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1867 | base_total = 0 |
Nabin Hait | 0551f7b | 2017-11-21 19:58:16 +0530 | [diff] [blame] | 1868 | for d in self.get("payment_schedule"): |
Deepesh Garg | 9c17052 | 2021-10-25 20:06:24 +0530 | [diff] [blame] | 1869 | total += flt(d.payment_amount, d.precision("payment_amount")) |
| 1870 | base_total += flt(d.base_payment_amount, d.precision("base_payment_amount")) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1871 | |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1872 | base_grand_total = self.get("base_rounded_total") or self.base_grand_total |
| 1873 | grand_total = self.get("rounded_total") or self.grand_total |
Rohit Waghchaure | 4a267b9 | 2019-05-09 19:50:00 +0530 | [diff] [blame] | 1874 | |
Nabin Hait | e591c85 | 2017-12-21 11:46:30 +0530 | [diff] [blame] | 1875 | if self.doctype in ("Sales Invoice", "Purchase Invoice"): |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1876 | base_grand_total = base_grand_total - flt(self.base_write_off_amount) |
Nabin Hait | e591c85 | 2017-12-21 11:46:30 +0530 | [diff] [blame] | 1877 | grand_total = grand_total - flt(self.write_off_amount) |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1878 | |
| 1879 | if self.get("total_advance"): |
| 1880 | if party_account_currency == self.company_currency: |
| 1881 | base_grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1882 | grand_total = flt( |
| 1883 | base_grand_total / self.get("conversion_rate"), self.precision("grand_total") |
| 1884 | ) |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 1885 | else: |
| 1886 | grand_total -= self.get("total_advance") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1887 | base_grand_total = flt( |
| 1888 | grand_total * self.get("conversion_rate"), self.precision("base_grand_total") |
| 1889 | ) |
Deepesh Garg | 9c17052 | 2021-10-25 20:06:24 +0530 | [diff] [blame] | 1890 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1891 | if ( |
| 1892 | flt(total, self.precision("grand_total")) - flt(grand_total, self.precision("grand_total")) |
| 1893 | > 0.1 |
| 1894 | or flt(base_total, self.precision("base_grand_total")) |
| 1895 | - flt(base_grand_total, self.precision("base_grand_total")) |
| 1896 | > 0.1 |
| 1897 | ): |
| 1898 | frappe.throw( |
| 1899 | _("Total Payment Amount in Payment Schedule must be equal to Grand / Rounded Total") |
| 1900 | ) |
tunde | 43870aa | 2017-08-18 11:59:30 +0100 | [diff] [blame] | 1901 | |
Nabin Hait | 877e1bb | 2017-11-17 12:27:43 +0530 | [diff] [blame] | 1902 | def is_rounded_total_disabled(self): |
| 1903 | if self.meta.get_field("disable_rounded_total"): |
| 1904 | return self.disable_rounded_total |
| 1905 | else: |
| 1906 | return frappe.db.get_single_value("Global Defaults", "disable_rounded_total") |
| 1907 | |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1908 | def set_inter_company_account(self): |
| 1909 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1910 | Set intercompany account for inter warehouse transactions |
| 1911 | This account will be used in case billing company and internal customer's |
| 1912 | representation company is same |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1913 | """ |
| 1914 | |
| 1915 | if self.is_internal_transfer() and not self.unrealized_profit_loss_account: |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 1916 | unrealized_profit_loss_account = frappe.get_cached_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1917 | "Company", self.company, "unrealized_profit_loss_account" |
| 1918 | ) |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1919 | |
| 1920 | if not unrealized_profit_loss_account: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1921 | msg = _( |
| 1922 | "Please select Unrealized Profit / Loss account or add default Unrealized Profit / Loss account account for company {0}" |
| 1923 | ).format(frappe.bold(self.company)) |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1924 | frappe.throw(msg) |
| 1925 | |
| 1926 | self.unrealized_profit_loss_account = unrealized_profit_loss_account |
| 1927 | |
| 1928 | def is_internal_transfer(self): |
| 1929 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1930 | It will an internal transfer if its an internal customer and representation |
| 1931 | company is same as billing company |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1932 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1933 | if self.doctype in ("Sales Invoice", "Delivery Note", "Sales Order"): |
| 1934 | internal_party_field = "is_internal_customer" |
| 1935 | elif self.doctype in ("Purchase Invoice", "Purchase Receipt", "Purchase Order"): |
| 1936 | internal_party_field = "is_internal_supplier" |
Ankush Menat | 3714e36 | 2022-05-16 18:09:14 +0530 | [diff] [blame] | 1937 | else: |
| 1938 | return False |
Deepesh Garg | f17ea2c | 2020-12-11 21:30:39 +0530 | [diff] [blame] | 1939 | |
| 1940 | if self.get(internal_party_field) and (self.represents_company == self.company): |
| 1941 | return True |
| 1942 | |
| 1943 | return False |
| 1944 | |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1945 | def process_common_party_accounting(self): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1946 | is_invoice = self.doctype in ["Sales Invoice", "Purchase Invoice"] |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1947 | if not is_invoice: |
| 1948 | return |
| 1949 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1950 | if frappe.db.get_single_value("Accounts Settings", "enable_common_party_accounting"): |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1951 | party_link = self.get_common_party_link() |
| 1952 | if party_link and self.outstanding_amount: |
| 1953 | self.create_advance_and_reconcile(party_link) |
| 1954 | |
| 1955 | def get_common_party_link(self): |
| 1956 | party_type, party = self.get_party() |
Saqib Ansari | 7254368 | 2021-08-25 20:15:23 +0530 | [diff] [blame] | 1957 | return frappe.db.get_value( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1958 | doctype="Party Link", |
| 1959 | filters={"secondary_role": party_type, "secondary_party": party}, |
| 1960 | fieldname=["primary_role", "primary_party"], |
| 1961 | as_dict=True, |
Saqib Ansari | 7254368 | 2021-08-25 20:15:23 +0530 | [diff] [blame] | 1962 | ) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1963 | |
| 1964 | def create_advance_and_reconcile(self, party_link): |
| 1965 | secondary_party_type, secondary_party = self.get_party() |
| 1966 | primary_party_type, primary_party = party_link.primary_role, party_link.primary_party |
| 1967 | |
| 1968 | primary_account = get_party_account(primary_party_type, primary_party, self.company) |
| 1969 | secondary_account = get_party_account(secondary_party_type, secondary_party, self.company) |
| 1970 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1971 | jv = frappe.new_doc("Journal Entry") |
| 1972 | jv.voucher_type = "Journal Entry" |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1973 | jv.posting_date = self.posting_date |
| 1974 | jv.company = self.company |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1975 | jv.remark = "Adjustment for {} {}".format(self.doctype, self.name) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1976 | |
| 1977 | reconcilation_entry = frappe._dict() |
| 1978 | advance_entry = frappe._dict() |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1979 | |
| 1980 | reconcilation_entry.account = secondary_account |
| 1981 | reconcilation_entry.party_type = secondary_party_type |
| 1982 | reconcilation_entry.party = secondary_party |
| 1983 | reconcilation_entry.reference_type = self.doctype |
| 1984 | reconcilation_entry.reference_name = self.name |
Deepesh Garg | f88431a | 2023-04-25 20:54:22 +0530 | [diff] [blame] | 1985 | reconcilation_entry.cost_center = self.cost_center or erpnext.get_default_cost_center( |
| 1986 | self.company |
| 1987 | ) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1988 | |
| 1989 | advance_entry.account = primary_account |
| 1990 | advance_entry.party_type = primary_party_type |
| 1991 | advance_entry.party = primary_party |
Deepesh Garg | f88431a | 2023-04-25 20:54:22 +0530 | [diff] [blame] | 1992 | 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] | 1993 | advance_entry.is_advance = "Yes" |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1994 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 1995 | if self.doctype == "Sales Invoice": |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 1996 | reconcilation_entry.credit_in_account_currency = self.outstanding_amount |
| 1997 | advance_entry.debit_in_account_currency = self.outstanding_amount |
| 1998 | else: |
| 1999 | advance_entry.credit_in_account_currency = self.outstanding_amount |
| 2000 | reconcilation_entry.debit_in_account_currency = self.outstanding_amount |
| 2001 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2002 | jv.append("accounts", reconcilation_entry) |
| 2003 | jv.append("accounts", advance_entry) |
Saqib Ansari | 977b09b | 2021-08-19 17:57:30 +0530 | [diff] [blame] | 2004 | |
| 2005 | jv.save() |
| 2006 | jv.submit() |
| 2007 | |
Deepesh Garg | d05d153 | 2022-06-14 12:50:49 +0530 | [diff] [blame] | 2008 | def check_conversion_rate(self): |
| 2009 | default_currency = erpnext.get_company_currency(self.company) |
| 2010 | if not default_currency: |
| 2011 | throw(_("Please enter default currency in Company Master")) |
| 2012 | if ( |
| 2013 | (self.currency == default_currency and flt(self.conversion_rate) != 1.00) |
| 2014 | or not self.conversion_rate |
| 2015 | or (self.currency != default_currency and flt(self.conversion_rate) == 1.00) |
| 2016 | ): |
| 2017 | throw(_("Conversion rate cannot be 0 or 1")) |
| 2018 | |
Saif Ur Rehman | 7a5d75b | 2021-09-13 23:01:52 +0500 | [diff] [blame] | 2019 | def check_finance_books(self, item, asset): |
Nabin Hait | fefe950 | 2022-09-09 14:40:36 +0530 | [diff] [blame] | 2020 | if ( |
| 2021 | len(asset.finance_books) > 1 |
| 2022 | and not item.get("finance_book") |
| 2023 | and not self.get("finance_book") |
| 2024 | and asset.finance_books[0].finance_book |
| 2025 | ): |
| 2026 | frappe.throw( |
| 2027 | _("Select finance book for the item {0} at row {1}").format(item.item_code, item.idx) |
| 2028 | ) |
Saif Ur Rehman | 7a5d75b | 2021-09-13 23:01:52 +0500 | [diff] [blame] | 2029 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2030 | |
Rushabh Mehta | 793ba6b | 2014-02-14 15:47:51 +0530 | [diff] [blame] | 2031 | @frappe.whitelist() |
Rushabh Mehta | f56d73c | 2013-10-10 16:35:09 +0530 | [diff] [blame] | 2032 | def get_tax_rate(account_head): |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 2033 | return frappe.get_cached_value( |
| 2034 | "Account", account_head, ["tax_rate", "account_name"], as_dict=True |
| 2035 | ) |
Rushabh Mehta | a33d468 | 2015-06-01 17:15:42 +0530 | [diff] [blame] | 2036 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2037 | |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 2038 | @frappe.whitelist() |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 2039 | 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] | 2040 | if not company: |
| 2041 | return {} |
rohitwaghchaure | 505661b | 2017-12-11 14:52:28 +0530 | [diff] [blame] | 2042 | |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 2043 | if tax_template and company: |
Daizy Modi | 4efc947 | 2022-11-07 09:21:03 +0530 | [diff] [blame] | 2044 | tax_template_company = frappe.get_cached_value(master_doctype, tax_template, "company") |
Nabin Hait | a2426fc | 2018-01-15 17:45:46 +0530 | [diff] [blame] | 2045 | if tax_template_company == company: |
| 2046 | return |
| 2047 | |
| 2048 | default_tax = frappe.db.get_value(master_doctype, {"is_default": 1, "company": company}) |
rohitwaghchaure | 505661b | 2017-12-11 14:52:28 +0530 | [diff] [blame] | 2049 | |
Rushabh Mehta | 98aa581 | 2017-11-14 09:32:32 +0530 | [diff] [blame] | 2050 | return { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2051 | "taxes_and_charges": default_tax, |
| 2052 | "taxes": get_taxes_and_charges(master_doctype, default_tax), |
Rushabh Mehta | 98aa581 | 2017-11-14 09:32:32 +0530 | [diff] [blame] | 2053 | } |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 2054 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2055 | |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 2056 | @frappe.whitelist() |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 2057 | def get_taxes_and_charges(master_doctype, master_name): |
Nabin Hait | 1fe5012 | 2015-05-16 12:14:39 +0530 | [diff] [blame] | 2058 | if not master_name: |
| 2059 | return |
Ankush Menat | 77dcdff | 2022-06-01 22:01:07 +0530 | [diff] [blame] | 2060 | from frappe.model import child_table_fields, default_fields |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2061 | |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 2062 | tax_master = frappe.get_doc(master_doctype, master_name) |
| 2063 | |
| 2064 | taxes_and_charges = [] |
Nabin Hait | ffc7f3f | 2015-05-12 15:07:02 +0530 | [diff] [blame] | 2065 | for i, tax in enumerate(tax_master.get("taxes")): |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 2066 | tax = tax.as_dict() |
| 2067 | |
Ankush Menat | 77dcdff | 2022-06-01 22:01:07 +0530 | [diff] [blame] | 2068 | for fieldname in default_fields + child_table_fields: |
Nabin Hait | 6b03914 | 2014-05-02 15:45:10 +0530 | [diff] [blame] | 2069 | if fieldname in tax: |
| 2070 | del tax[fieldname] |
| 2071 | |
| 2072 | taxes_and_charges.append(tax) |
| 2073 | |
| 2074 | return taxes_and_charges |
Rushabh Mehta | 66e08e3 | 2014-09-29 12:17:03 +0530 | [diff] [blame] | 2075 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2076 | |
Rushabh Mehta | 66e08e3 | 2014-09-29 12:17:03 +0530 | [diff] [blame] | 2077 | def validate_conversion_rate(currency, conversion_rate, conversion_rate_label, company): |
| 2078 | """common validation for currency and price list currency""" |
| 2079 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2080 | company_currency = frappe.get_cached_value("Company", company, "default_currency") |
Rushabh Mehta | 66e08e3 | 2014-09-29 12:17:03 +0530 | [diff] [blame] | 2081 | |
| 2082 | if not conversion_rate: |
Saqib | 60212ff | 2020-10-26 11:17:04 +0530 | [diff] [blame] | 2083 | throw( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2084 | _("{0} is mandatory. Maybe Currency Exchange record is not created for {1} to {2}.").format( |
| 2085 | conversion_rate_label, currency, company_currency |
| 2086 | ) |
Saqib | 60212ff | 2020-10-26 11:17:04 +0530 | [diff] [blame] | 2087 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2088 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2089 | |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2090 | def validate_taxes_and_charges(tax): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2091 | if tax.charge_type in ["Actual", "On Net Total", "On Paid Amount"] and tax.row_id: |
| 2092 | frappe.throw( |
| 2093 | _("Can refer row only if the charge type is 'On Previous Row Amount' or 'Previous Row Total'") |
| 2094 | ) |
| 2095 | 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] | 2096 | if cint(tax.idx) == 1: |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2097 | frappe.throw( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2098 | _( |
| 2099 | "Cannot select charge type as 'On Previous Row Amount' or 'On Previous Row Total' for first row" |
| 2100 | ) |
| 2101 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2102 | elif not tax.row_id: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2103 | frappe.throw( |
| 2104 | _("Please specify a valid Row ID for row {0} in table {1}").format(tax.idx, _(tax.doctype)) |
| 2105 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2106 | elif tax.row_id and cint(tax.row_id) >= cint(tax.idx): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2107 | frappe.throw( |
| 2108 | _("Cannot refer row number greater than or equal to current row number for this Charge type") |
| 2109 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2110 | |
Rushabh Mehta | 2a21bc9 | 2015-02-25 15:08:42 +0530 | [diff] [blame] | 2111 | if tax.charge_type == "Actual": |
Nabin Hait | bc6c360 | 2015-02-27 23:40:56 +0530 | [diff] [blame] | 2112 | tax.rate = None |
Rushabh Mehta | 2a21bc9 | 2015-02-25 15:08:42 +0530 | [diff] [blame] | 2113 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2114 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2115 | def validate_account_head(idx, account, company, context=""): |
| 2116 | account_company = frappe.get_cached_value("Account", account, "company") |
Anuja Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2117 | |
Deepesh Garg | 5a2b571 | 2022-02-18 20:05:49 +0530 | [diff] [blame] | 2118 | if account_company != company: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2119 | frappe.throw( |
| 2120 | _("Row {0}: {3} Account {1} does not belong to Company {2}").format( |
| 2121 | idx, frappe.bold(account), frappe.bold(company), context |
| 2122 | ), |
| 2123 | title=_("Invalid Account"), |
| 2124 | ) |
Anuja Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2125 | |
| 2126 | |
| 2127 | def validate_cost_center(tax, doc): |
| 2128 | if not tax.cost_center: |
| 2129 | return |
| 2130 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2131 | company = frappe.get_cached_value("Cost Center", tax.cost_center, "company") |
Anuja Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2132 | |
| 2133 | if company != doc.company: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2134 | frappe.throw( |
| 2135 | _("Row {0}: Cost Center {1} does not belong to Company {2}").format( |
| 2136 | tax.idx, frappe.bold(tax.cost_center), frappe.bold(doc.company) |
| 2137 | ), |
| 2138 | title=_("Invalid Cost Center"), |
| 2139 | ) |
Anuja Pawar | 0e337be | 2021-08-10 17:26:35 +0530 | [diff] [blame] | 2140 | |
| 2141 | |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2142 | def validate_inclusive_tax(tax, doc): |
| 2143 | def _on_previous_row_error(row_range): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2144 | throw( |
| 2145 | _("To include tax in row {0} in Item rate, taxes in rows {1} must also be included").format( |
| 2146 | tax.idx, row_range |
| 2147 | ) |
| 2148 | ) |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2149 | |
| 2150 | if cint(getattr(tax, "included_in_print_rate", None)): |
| 2151 | if tax.charge_type == "Actual": |
| 2152 | # inclusive tax cannot be of type Actual |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2153 | throw( |
| 2154 | _("Charge of type 'Actual' in row {0} cannot be included in Item Rate or Paid Amount").format( |
| 2155 | tax.idx |
| 2156 | ) |
| 2157 | ) |
| 2158 | elif tax.charge_type == "On Previous Row Amount" and not cint( |
| 2159 | doc.get("taxes")[cint(tax.row_id) - 1].included_in_print_rate |
| 2160 | ): |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2161 | # referred row should also be inclusive |
| 2162 | _on_previous_row_error(tax.row_id) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2163 | elif tax.charge_type == "On Previous Row Total" and not all( |
| 2164 | [cint(t.included_in_print_rate) for t in doc.get("taxes")[: cint(tax.row_id) - 1]] |
| 2165 | ): |
Deepesh Garg | 5ef9a62 | 2021-06-14 14:34:44 +0530 | [diff] [blame] | 2166 | # all rows about the referred tax should be inclusive |
Nabin Hait | 613d081 | 2015-02-23 11:58:15 +0530 | [diff] [blame] | 2167 | _on_previous_row_error("1 - %d" % (tax.row_id,)) |
Nabin Hait | 93b3a37 | 2015-02-24 17:08:34 +0530 | [diff] [blame] | 2168 | elif tax.get("category") == "Valuation": |
Nabin Hait | 19ea721 | 2020-08-11 20:34:57 +0530 | [diff] [blame] | 2169 | frappe.throw(_("Valuation type charges can not be marked as Inclusive")) |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2170 | |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2171 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2172 | def set_balance_in_account_currency( |
| 2173 | gl_dict, account_currency=None, conversion_rate=None, company_currency=None |
| 2174 | ): |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2175 | if (not conversion_rate) and (account_currency != company_currency): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2176 | frappe.throw( |
| 2177 | _("Account: {0} with currency: {1} can not be selected").format( |
| 2178 | gl_dict.account, account_currency |
| 2179 | ) |
| 2180 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2181 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2182 | gl_dict["account_currency"] = ( |
| 2183 | company_currency if account_currency == company_currency else account_currency |
| 2184 | ) |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2185 | |
| 2186 | # set debit/credit in account currency if not provided |
| 2187 | 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] | 2188 | gl_dict.debit_in_account_currency = ( |
| 2189 | gl_dict.debit |
| 2190 | if account_currency == company_currency |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2191 | else flt(gl_dict.debit / conversion_rate, 2) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2192 | ) |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2193 | |
| 2194 | 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] | 2195 | gl_dict.credit_in_account_currency = ( |
| 2196 | gl_dict.credit |
| 2197 | if account_currency == company_currency |
Revant Nandgaonkar | 5da941b | 2016-02-18 16:02:05 +0530 | [diff] [blame] | 2198 | else flt(gl_dict.credit / conversion_rate, 2) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2199 | ) |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2200 | |
| 2201 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2202 | def get_advance_journal_entries( |
| 2203 | party_type, |
| 2204 | party, |
| 2205 | party_account, |
| 2206 | amount_field, |
| 2207 | order_doctype, |
| 2208 | order_list, |
| 2209 | include_unallocated=True, |
| 2210 | ): |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2211 | journal_entry = frappe.qb.DocType("Journal Entry") |
| 2212 | journal_acc = frappe.qb.DocType("Journal Entry Account") |
| 2213 | q = ( |
| 2214 | frappe.qb.from_(journal_entry) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2215 | .inner_join(journal_acc) |
| 2216 | .on(journal_entry.name == journal_acc.parent) |
| 2217 | .select( |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2218 | ConstantColumn("Journal Entry").as_("reference_type"), |
| 2219 | (journal_entry.name).as_("reference_name"), |
| 2220 | (journal_entry.remark).as_("remarks"), |
Deepesh Garg | 3aead05 | 2023-06-22 11:41:43 +0530 | [diff] [blame] | 2221 | (journal_acc[amount_field]).as_("amount"), |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2222 | (journal_acc.name).as_("reference_row"), |
| 2223 | (journal_acc.reference_name).as_("against_order"), |
| 2224 | (journal_acc.exchange_rate), |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2225 | ) |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2226 | .where( |
| 2227 | journal_acc.account.isin(party_account) |
| 2228 | & (journal_acc.party_type == party_type) |
| 2229 | & (journal_acc.party == party) |
| 2230 | & (journal_acc.is_advance == "Yes") |
| 2231 | & (journal_entry.docstatus == 1) |
| 2232 | ) |
| 2233 | ) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2234 | if party_type == "Customer": |
| 2235 | q = q.where(journal_acc.credit_in_account_currency > 0) |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2236 | |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2237 | else: |
| 2238 | q = q.where(journal_acc.debit_in_account_currency > 0) |
| 2239 | |
Deepesh Garg | 3aead05 | 2023-06-22 11:41:43 +0530 | [diff] [blame] | 2240 | if include_unallocated: |
| 2241 | q = q.where((journal_acc.reference_name.isnull()) | (journal_acc.reference_name == "")) |
| 2242 | |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2243 | if order_list: |
Deepesh Garg | 3aead05 | 2023-06-22 11:41:43 +0530 | [diff] [blame] | 2244 | q = q.where( |
Deepesh Garg | 6d121ae | 2023-06-22 13:03:09 +0530 | [diff] [blame] | 2245 | (journal_acc.reference_type == order_doctype) & ((journal_acc.reference_type).isin(order_list)) |
Deepesh Garg | 3aead05 | 2023-06-22 11:41:43 +0530 | [diff] [blame] | 2246 | ) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2247 | |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2248 | q = q.orderby(journal_entry.posting_date) |
Rushabh Mehta | 6695830 | 2017-01-16 16:57:53 +0530 | [diff] [blame] | 2249 | |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2250 | journal_entries = q.run(as_dict=True) |
Nabin Hait | 1991c7b | 2016-06-27 20:09:05 +0530 | [diff] [blame] | 2251 | return list(journal_entries) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2252 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2253 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2254 | def get_advance_payment_entries( |
| 2255 | party_type, |
| 2256 | party, |
| 2257 | party_account, |
| 2258 | order_doctype, |
| 2259 | order_list=None, |
| 2260 | include_unallocated=True, |
| 2261 | against_all_orders=False, |
| 2262 | limit=None, |
| 2263 | condition=None, |
| 2264 | ): |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2265 | |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2266 | payment_entries = [] |
| 2267 | payment_entry = frappe.qb.DocType("Payment Entry") |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2268 | |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2269 | if order_list or against_all_orders: |
| 2270 | q = get_common_query( |
| 2271 | party_type, |
| 2272 | party, |
| 2273 | party_account, |
| 2274 | limit, |
| 2275 | condition, |
| 2276 | ) |
| 2277 | payment_ref = frappe.qb.DocType("Payment Entry Reference") |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2278 | |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2279 | q = q.inner_join(payment_ref).on(payment_entry.name == payment_ref.parent) |
| 2280 | q = q.select( |
| 2281 | (payment_ref.allocated_amount).as_("amount"), |
| 2282 | (payment_ref.name).as_("reference_row"), |
| 2283 | (payment_ref.reference_name).as_("against_order"), |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2284 | ) |
| 2285 | |
Deepesh Garg | 3aead05 | 2023-06-22 11:41:43 +0530 | [diff] [blame] | 2286 | q = q.where(payment_ref.reference_doctype == order_doctype) |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2287 | if order_list: |
| 2288 | q = q.where(payment_ref.reference_name.isin(order_list)) |
| 2289 | |
| 2290 | allocated = list(q.run(as_dict=True)) |
| 2291 | payment_entries += allocated |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2292 | if include_unallocated: |
| 2293 | q = get_common_query( |
| 2294 | party_type, |
| 2295 | party, |
| 2296 | party_account, |
| 2297 | limit, |
| 2298 | condition, |
| 2299 | ) |
| 2300 | q = q.select((payment_entry.unallocated_amount).as_("amount")) |
| 2301 | q = q.where(payment_entry.unallocated_amount > 0) |
| 2302 | |
| 2303 | unallocated = list(q.run(as_dict=True)) |
| 2304 | payment_entries += unallocated |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2305 | return payment_entries |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2306 | |
Saqib | a20999c | 2021-07-12 14:33:23 +0530 | [diff] [blame] | 2307 | |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2308 | def get_common_query( |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2309 | party_type, |
| 2310 | party, |
| 2311 | party_account, |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2312 | limit, |
| 2313 | condition, |
| 2314 | ): |
| 2315 | payment_type = "Receive" if party_type == "Customer" else "Pay" |
| 2316 | payment_entry = frappe.qb.DocType("Payment Entry") |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2317 | |
| 2318 | q = ( |
| 2319 | frappe.qb.from_(payment_entry) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2320 | .select( |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2321 | ConstantColumn("Payment Entry").as_("reference_type"), |
| 2322 | (payment_entry.name).as_("reference_name"), |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2323 | payment_entry.posting_date, |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2324 | (payment_entry.remarks).as_("remarks"), |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2325 | ) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2326 | .where(payment_entry.payment_type == payment_type) |
| 2327 | .where(payment_entry.party_type == party_type) |
| 2328 | .where(payment_entry.party == party) |
| 2329 | .where(payment_entry.docstatus == 1) |
| 2330 | ) |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2331 | |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2332 | if party_type == "Customer": |
Deepesh Garg | b64ebc6 | 2023-06-21 17:49:45 +0530 | [diff] [blame] | 2333 | q = q.select((payment_entry.paid_from_account_currency).as_("currency")) |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2334 | q = q.select(payment_entry.paid_from) |
| 2335 | q = q.where(payment_entry.paid_from.isin(party_account)) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2336 | else: |
Deepesh Garg | b64ebc6 | 2023-06-21 17:49:45 +0530 | [diff] [blame] | 2337 | q = q.select((payment_entry.paid_to_account_currency).as_("currency")) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2338 | q = q.select(payment_entry.paid_to) |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2339 | q = q.where(payment_entry.paid_to.isin(party_account)) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2340 | |
| 2341 | if payment_type == "Receive": |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2342 | q = q.select((payment_entry.source_exchange_rate).as_("exchange_rate")) |
Gursheen Anand | 4ee1637 | 2023-06-08 13:15:23 +0530 | [diff] [blame] | 2343 | else: |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2344 | q = q.select((payment_entry.target_exchange_rate).as_("exchange_rate")) |
Rushabh Mehta | ea0ff23 | 2016-07-07 14:02:26 +0530 | [diff] [blame] | 2345 | |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2346 | if condition: |
| 2347 | q = q.where(payment_entry.company == condition["company"]) |
| 2348 | q = ( |
| 2349 | q.where(payment_entry.posting_date >= condition["from_payment_date"]) |
| 2350 | if condition.get("from_payment_date") |
| 2351 | else q |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2352 | ) |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2353 | q = ( |
| 2354 | q.where(payment_entry.posting_date <= condition["to_payment_date"]) |
| 2355 | if condition.get("to_payment_date") |
| 2356 | else q |
| 2357 | ) |
| 2358 | if condition.get("get_payments") == True: |
| 2359 | q = ( |
| 2360 | q.where(payment_entry.cost_center == condition["cost_center"]) |
| 2361 | if condition.get("cost_center") |
| 2362 | else q |
| 2363 | ) |
| 2364 | q = ( |
| 2365 | q.where(payment_entry.unallocated_amount >= condition["minimum_payment_amount"]) |
| 2366 | if condition.get("minimum_payment_amount") |
| 2367 | else q |
| 2368 | ) |
| 2369 | q = ( |
| 2370 | q.where(payment_entry.unallocated_amount <= condition["maximum_payment_amount"]) |
| 2371 | if condition.get("maximum_payment_amount") |
| 2372 | else q |
| 2373 | ) |
| 2374 | else: |
| 2375 | q = ( |
| 2376 | q.where(payment_entry.total_debit >= condition["minimum_payment_amount"]) |
| 2377 | if condition.get("minimum_payment_amount") |
| 2378 | else q |
| 2379 | ) |
| 2380 | q = ( |
| 2381 | q.where(payment_entry.total_debit <= condition["maximum_payment_amount"]) |
| 2382 | if condition.get("maximum_payment_amount") |
| 2383 | else q |
| 2384 | ) |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2385 | |
| 2386 | q = q.orderby(payment_entry.posting_date) |
| 2387 | q = q.limit(limit) if limit else q |
Deepesh Garg | 92f845c | 2023-06-21 12:21:19 +0530 | [diff] [blame] | 2388 | |
Gursheen Anand | 7461926 | 2023-06-02 17:13:51 +0530 | [diff] [blame] | 2389 | return q |
Rohit Waghchaure | 2f1db57 | 2016-11-08 12:39:33 +0530 | [diff] [blame] | 2390 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2391 | |
Rohit Waghchaure | 2f1db57 | 2016-11-08 12:39:33 +0530 | [diff] [blame] | 2392 | def update_invoice_status(): |
Sagar Vora | c8b9a55 | 2021-09-22 12:11:35 +0530 | [diff] [blame] | 2393 | """Updates status as Overdue for applicable invoices. Runs daily.""" |
Sagar Vora | 8d9d098 | 2021-10-20 19:15:35 +0530 | [diff] [blame] | 2394 | today = getdate() |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2395 | payment_schedule = frappe.qb.DocType("Payment Schedule") |
Sagar Vora | c8b9a55 | 2021-09-22 12:11:35 +0530 | [diff] [blame] | 2396 | for doctype in ("Sales Invoice", "Purchase Invoice"): |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2397 | invoice = frappe.qb.DocType(doctype) |
| 2398 | |
| 2399 | consider_base_amount = invoice.party_account_currency != invoice.currency |
| 2400 | payment_amount = ( |
| 2401 | frappe.qb.terms.Case() |
| 2402 | .when(consider_base_amount, payment_schedule.base_payment_amount) |
| 2403 | .else_(payment_schedule.payment_amount) |
Sagar Vora | 8d9d098 | 2021-10-20 19:15:35 +0530 | [diff] [blame] | 2404 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2405 | |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2406 | payable_amount = ( |
| 2407 | frappe.qb.from_(payment_schedule) |
| 2408 | .select(Sum(payment_amount)) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2409 | .where((payment_schedule.parent == invoice.name) & (payment_schedule.due_date < today)) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2410 | ) |
| 2411 | |
| 2412 | total = ( |
| 2413 | frappe.qb.terms.Case() |
| 2414 | .when(invoice.disable_rounded_total, invoice.grand_total) |
| 2415 | .else_(invoice.rounded_total) |
| 2416 | ) |
| 2417 | |
| 2418 | base_total = ( |
| 2419 | frappe.qb.terms.Case() |
| 2420 | .when(invoice.disable_rounded_total, invoice.base_grand_total) |
| 2421 | .else_(invoice.base_rounded_total) |
| 2422 | ) |
| 2423 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2424 | 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] | 2425 | |
| 2426 | is_overdue = total_amount - invoice.outstanding_amount < payable_amount |
| 2427 | |
| 2428 | conditions = ( |
| 2429 | (invoice.docstatus == 1) |
| 2430 | & (invoice.outstanding_amount > 0) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2431 | & (invoice.status.like("Unpaid%") | invoice.status.like("Partly Paid%")) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2432 | & ( |
Pruthvi Patel | 16a90d3 | 2021-12-20 13:24:19 +0530 | [diff] [blame] | 2433 | ((invoice.is_pos & invoice.due_date < today) | is_overdue) |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2434 | if doctype == "Sales Invoice" |
| 2435 | else is_overdue |
| 2436 | ) |
| 2437 | ) |
| 2438 | |
Pruthvi Patel | 0799f37 | 2021-11-12 12:56:29 +0530 | [diff] [blame] | 2439 | status = ( |
| 2440 | frappe.qb.terms.Case() |
| 2441 | .when(invoice.status.like("%Discounted"), "Overdue and Discounted") |
| 2442 | .else_("Overdue") |
| 2443 | ) |
| 2444 | |
| 2445 | frappe.qb.update(invoice).set("status", status).where(conditions).run() |
Pruthvi Patel | 6c96ed4 | 2021-10-30 16:44:15 +0530 | [diff] [blame] | 2446 | |
| 2447 | |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2448 | @frappe.whitelist() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2449 | def get_payment_terms( |
| 2450 | terms_template, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None |
| 2451 | ): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2452 | if not terms_template: |
| 2453 | return |
| 2454 | |
| 2455 | terms_doc = frappe.get_doc("Payment Terms Template", terms_template) |
| 2456 | |
| 2457 | schedule = [] |
tunde | fb14430 | 2017-08-19 15:01:40 +0100 | [diff] [blame] | 2458 | for d in terms_doc.get("terms"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2459 | term_details = get_payment_term_details( |
| 2460 | d, posting_date, grand_total, base_grand_total, bill_date |
| 2461 | ) |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2462 | schedule.append(term_details) |
| 2463 | |
| 2464 | return schedule |
| 2465 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2466 | |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2467 | @frappe.whitelist() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2468 | def get_payment_term_details( |
| 2469 | term, posting_date=None, grand_total=None, base_grand_total=None, bill_date=None |
| 2470 | ): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2471 | term_details = frappe._dict() |
Ankush Menat | 8fe5feb | 2021-11-04 19:48:32 +0530 | [diff] [blame] | 2472 | if isinstance(term, str): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2473 | term = frappe.get_doc("Payment Term", term) |
| 2474 | else: |
| 2475 | term_details.payment_term = term.payment_term |
| 2476 | term_details.description = term.description |
| 2477 | term_details.invoice_portion = term.invoice_portion |
Rohit Waghchaure | 52bf56d | 2017-11-27 11:43:52 +0530 | [diff] [blame] | 2478 | term_details.payment_amount = flt(term.invoice_portion) * flt(grand_total) / 100 |
Saqib Ansari | d552fe6 | 2021-04-23 14:46:52 +0530 | [diff] [blame] | 2479 | 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] | 2480 | term_details.discount_type = term.discount_type |
| 2481 | term_details.discount = term.discount |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2482 | term_details.outstanding = term_details.payment_amount |
| 2483 | term_details.mode_of_payment = term.mode_of_payment |
| 2484 | |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2485 | if bill_date: |
| 2486 | term_details.due_date = get_due_date(term, bill_date) |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2487 | term_details.discount_date = get_discount_date(term, bill_date) |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2488 | elif posting_date: |
| 2489 | term_details.due_date = get_due_date(term, posting_date) |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2490 | term_details.discount_date = get_discount_date(term, posting_date) |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2491 | |
| 2492 | if getdate(term_details.due_date) < getdate(posting_date): |
| 2493 | term_details.due_date = posting_date |
| 2494 | |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2495 | return term_details |
| 2496 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2497 | |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2498 | def get_due_date(term, posting_date=None, bill_date=None): |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2499 | due_date = None |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2500 | date = bill_date or posting_date |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2501 | if term.due_date_based_on == "Day(s) after invoice date": |
Shreya Shah | 3a9eec2 | 2018-02-16 13:05:21 +0530 | [diff] [blame] | 2502 | due_date = add_days(date, term.credit_days) |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2503 | 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] | 2504 | due_date = add_days(get_last_day(date), term.credit_days) |
Nabin Hait | 9275969 | 2017-08-15 08:23:51 +0530 | [diff] [blame] | 2505 | 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] | 2506 | due_date = get_last_day(add_months(date, term.credit_months)) |
tunde | 96b8f22 | 2017-09-08 15:35:59 +0100 | [diff] [blame] | 2507 | return due_date |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2508 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2509 | |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2510 | def get_discount_date(term, posting_date=None, bill_date=None): |
| 2511 | discount_validity = None |
| 2512 | date = bill_date or posting_date |
| 2513 | if term.discount_validity_based_on == "Day(s) after invoice date": |
| 2514 | discount_validity = add_days(date, term.discount_validity) |
| 2515 | elif term.discount_validity_based_on == "Day(s) after the end of the invoice month": |
| 2516 | discount_validity = add_days(get_last_day(date), term.discount_validity) |
| 2517 | 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] | 2518 | discount_validity = get_last_day(add_months(date, term.discount_validity)) |
Saqib | 0586b7d | 2021-03-31 15:03:53 +0530 | [diff] [blame] | 2519 | return discount_validity |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2520 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2521 | |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2522 | def get_supplier_block_status(party_name): |
| 2523 | """ |
| 2524 | Returns a dict containing the values of `on_hold`, `release_date` and `hold_type` of |
| 2525 | a `Supplier` |
| 2526 | """ |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2527 | supplier = frappe.get_doc("Supplier", party_name) |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2528 | info = { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2529 | "on_hold": supplier.on_hold, |
| 2530 | "release_date": supplier.release_date, |
| 2531 | "hold_type": supplier.hold_type, |
tundebabzy | ad08d4c | 2018-05-16 07:01:41 +0100 | [diff] [blame] | 2532 | } |
| 2533 | return info |
| 2534 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2535 | |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2536 | def set_child_tax_template_and_map(item, child_item, parent_doc): |
| 2537 | args = { |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2538 | "item_code": item.item_code, |
| 2539 | "posting_date": parent_doc.transaction_date, |
| 2540 | "tax_category": parent_doc.get("tax_category"), |
| 2541 | "company": parent_doc.get("company"), |
| 2542 | } |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2543 | |
| 2544 | child_item.item_tax_template = _get_item_tax_template(args, item.taxes) |
| 2545 | if child_item.get("item_tax_template"): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2546 | child_item.item_tax_rate = get_item_tax_map( |
| 2547 | parent_doc.get("company"), child_item.item_tax_template, as_json=True |
| 2548 | ) |
| 2549 | |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2550 | |
Afshan | b3bbebd | 2021-08-09 14:39:32 +0530 | [diff] [blame] | 2551 | 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] | 2552 | add_taxes_from_item_tax_template = frappe.db.get_single_value( |
| 2553 | "Accounts Settings", "add_taxes_from_item_tax_template" |
| 2554 | ) |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2555 | |
| 2556 | if child_item.get("item_tax_rate") and add_taxes_from_item_tax_template: |
| 2557 | tax_map = json.loads(child_item.get("item_tax_rate")) |
| 2558 | for tax_type in tax_map: |
| 2559 | tax_rate = flt(tax_map[tax_type]) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2560 | taxes = parent_doc.get("taxes") or [] |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2561 | # add new row for tax head only if missing |
| 2562 | found = any(tax.account_head == tax_type for tax in taxes) |
| 2563 | if not found: |
| 2564 | tax_row = parent_doc.append("taxes", {}) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2565 | tax_row.update( |
| 2566 | { |
| 2567 | "description": str(tax_type).split(" - ")[0], |
| 2568 | "charge_type": "On Net Total", |
| 2569 | "account_head": tax_type, |
| 2570 | "rate": tax_rate, |
| 2571 | } |
| 2572 | ) |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2573 | if parent_doc.doctype == "Purchase Order": |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2574 | tax_row.update({"category": "Total", "add_deduct_tax": "Add"}) |
Afshan | b3bbebd | 2021-08-09 14:39:32 +0530 | [diff] [blame] | 2575 | if db_insert: |
| 2576 | tax_row.db_insert() |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2577 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2578 | |
| 2579 | def set_order_defaults( |
| 2580 | parent_doctype, parent_doctype_name, child_doctype, child_docname, trans_item |
| 2581 | ): |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2582 | """ |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2583 | Returns a Sales/Purchase Order Item child item containing the default values |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2584 | """ |
Saqib | 438e043 | 2020-04-03 10:02:56 +0530 | [diff] [blame] | 2585 | p_doc = frappe.get_doc(parent_doctype, parent_doctype_name) |
Ankush Menat | 686685b | 2023-05-31 12:50:14 +0530 | [diff] [blame] | 2586 | 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] | 2587 | item = frappe.get_doc("Item", trans_item.get("item_code")) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2588 | |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2589 | for field in ("item_code", "item_name", "description", "item_group"): |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2590 | child_item.update({field: item.get(field)}) |
| 2591 | |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2592 | 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] | 2593 | 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] | 2594 | child_item.stock_uom = item.stock_uom |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2595 | child_item.uom = trans_item.get("uom") or item.stock_uom |
Andy Zhu | 1062d7e | 2020-10-06 10:51:42 +1300 | [diff] [blame] | 2596 | child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2597 | conversion_factor = flt( |
| 2598 | get_conversion_factor(item.item_code, child_item.uom).get("conversion_factor") |
| 2599 | ) |
| 2600 | child_item.conversion_factor = flt(trans_item.get("conversion_factor")) or conversion_factor |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2601 | |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2602 | if child_doctype == "Purchase Order Item": |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2603 | # Initialized value will update in parent validation |
| 2604 | child_item.base_rate = 1 |
| 2605 | child_item.base_amount = 1 |
pateljannat | 637ddff | 2021-02-09 16:17:30 +0530 | [diff] [blame] | 2606 | if child_doctype == "Sales Order Item": |
| 2607 | child_item.warehouse = get_item_warehouse(item, p_doc, overwrite_warehouse=True) |
| 2608 | if not child_item.warehouse: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2609 | frappe.throw( |
| 2610 | _("Cannot find {} for item {}. Please set the same in Item Master or Stock Settings.").format( |
| 2611 | frappe.bold("default warehouse"), frappe.bold(item.item_code) |
| 2612 | ) |
| 2613 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2614 | |
marination | 698d983 | 2020-08-19 14:59:46 +0530 | [diff] [blame] | 2615 | set_child_tax_template_and_map(item, child_item, p_doc) |
Marica | 3b1be2b | 2020-10-22 17:04:31 +0530 | [diff] [blame] | 2616 | add_taxes_from_tax_template(child_item, p_doc) |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2617 | return child_item |
| 2618 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2619 | |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2620 | def validate_child_on_delete(row, parent): |
| 2621 | """Check if partially transacted item (row) is being deleted.""" |
| 2622 | if parent.doctype == "Sales Order": |
| 2623 | if flt(row.delivered_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2624 | frappe.throw( |
| 2625 | _("Row #{0}: Cannot delete item {1} which has already been delivered").format( |
| 2626 | row.idx, row.item_code |
| 2627 | ) |
| 2628 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2629 | if flt(row.work_order_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2630 | frappe.throw( |
| 2631 | _("Row #{0}: Cannot delete item {1} which has work order assigned to it.").format( |
| 2632 | row.idx, row.item_code |
| 2633 | ) |
| 2634 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2635 | if flt(row.ordered_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2636 | frappe.throw( |
| 2637 | _("Row #{0}: Cannot delete item {1} which is assigned to customer's purchase order.").format( |
| 2638 | row.idx, row.item_code |
| 2639 | ) |
| 2640 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2641 | |
| 2642 | if parent.doctype == "Purchase Order" and flt(row.received_qty): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2643 | frappe.throw( |
| 2644 | _("Row #{0}: Cannot delete item {1} which has already been received").format( |
| 2645 | row.idx, row.item_code |
| 2646 | ) |
| 2647 | ) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2648 | |
| 2649 | if flt(row.billed_amt): |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2650 | frappe.throw( |
| 2651 | _("Row #{0}: Cannot delete item {1} which has already been billed.").format( |
| 2652 | row.idx, row.item_code |
| 2653 | ) |
| 2654 | ) |
| 2655 | |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2656 | |
| 2657 | def update_bin_on_delete(row, doctype): |
| 2658 | """Update bin for deleted item (row).""" |
Chillar Anand | 915b343 | 2021-09-02 16:44:59 +0530 | [diff] [blame] | 2659 | from erpnext.stock.stock_balance import ( |
| 2660 | get_indented_qty, |
| 2661 | get_ordered_qty, |
| 2662 | get_reserved_qty, |
| 2663 | update_bin_qty, |
| 2664 | ) |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2665 | |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2666 | qty_dict = {} |
| 2667 | |
| 2668 | if doctype == "Sales Order": |
| 2669 | qty_dict["reserved_qty"] = get_reserved_qty(row.item_code, row.warehouse) |
| 2670 | else: |
| 2671 | if row.material_request_item: |
| 2672 | qty_dict["indented_qty"] = get_indented_qty(row.item_code, row.warehouse) |
| 2673 | |
| 2674 | qty_dict["ordered_qty"] = get_ordered_qty(row.item_code, row.warehouse) |
| 2675 | |
Deepesh Garg | a61790c | 2022-02-22 20:58:10 +0530 | [diff] [blame] | 2676 | if row.warehouse: |
| 2677 | update_bin_qty(row.item_code, row.warehouse, qty_dict) |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2678 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2679 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2680 | def validate_and_delete_children(parent, data) -> bool: |
Saqib | 0ad7449 | 2019-12-24 16:42:30 +0530 | [diff] [blame] | 2681 | deleted_children = [] |
| 2682 | updated_item_names = [d.get("docname") for d in data] |
| 2683 | for item in parent.items: |
| 2684 | if item.name not in updated_item_names: |
| 2685 | deleted_children.append(item) |
| 2686 | |
| 2687 | for d in deleted_children: |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2688 | validate_child_on_delete(d, parent) |
Saqib | 0ad7449 | 2019-12-24 16:42:30 +0530 | [diff] [blame] | 2689 | d.cancel() |
| 2690 | d.delete() |
marination | 0673f55 | 2021-03-31 01:38:22 +0530 | [diff] [blame] | 2691 | |
| 2692 | # need to update ordered qty in Material Request first |
| 2693 | # bin uses Material Request Items to recalculate & update |
| 2694 | parent.update_prevdoc_status() |
| 2695 | |
| 2696 | for d in deleted_children: |
| 2697 | update_bin_on_delete(d, parent.doctype) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2698 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2699 | return bool(deleted_children) |
| 2700 | |
Rohan Bansal | a93b514 | 2021-04-06 17:10:52 +0530 | [diff] [blame] | 2701 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2702 | @frappe.whitelist() |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2703 | 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] | 2704 | def check_doc_permissions(doc, perm_type="create"): |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2705 | try: |
| 2706 | doc.check_permission(perm_type) |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2707 | except frappe.PermissionError: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2708 | actions = {"create": "add", "write": "update"} |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2709 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2710 | frappe.throw( |
| 2711 | _("You do not have permissions to {} items in a {}.").format( |
| 2712 | actions[perm_type], parent_doctype |
| 2713 | ), |
| 2714 | title=_("Insufficient Permissions"), |
| 2715 | ) |
marination | 665c27a | 2020-09-15 12:04:38 +0530 | [diff] [blame] | 2716 | |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2717 | def validate_workflow_conditions(doc): |
| 2718 | workflow = get_workflow_name(doc.doctype) |
| 2719 | if not workflow: |
| 2720 | return |
| 2721 | |
| 2722 | workflow_doc = frappe.get_doc("Workflow", workflow) |
| 2723 | current_state = doc.get(workflow_doc.workflow_state_field) |
| 2724 | roles = frappe.get_roles() |
| 2725 | |
| 2726 | transitions = [] |
| 2727 | for transition in workflow_doc.transitions: |
| 2728 | if transition.next_state == current_state and transition.allowed in roles: |
| 2729 | if not is_transition_condition_satisfied(transition, doc): |
| 2730 | continue |
| 2731 | transitions.append(transition.as_dict()) |
| 2732 | |
| 2733 | if not transitions: |
Saqib | 1831893 | 2020-09-23 13:01:49 +0530 | [diff] [blame] | 2734 | frappe.throw( |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2735 | _("You are not allowed to update as per the conditions set in {} Workflow.").format( |
| 2736 | get_link_to_form("Workflow", workflow) |
| 2737 | ), |
| 2738 | title=_("Insufficient Permissions"), |
Saqib | 1831893 | 2020-09-23 13:01:49 +0530 | [diff] [blame] | 2739 | ) |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2740 | |
Rohit Waghchaure | 8d5380a | 2020-06-18 14:06:31 +0530 | [diff] [blame] | 2741 | def get_new_child_item(item_row): |
Rohit Waghchaure | ff70e61 | 2021-03-06 22:08:08 +0530 | [diff] [blame] | 2742 | 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] | 2743 | return set_order_defaults( |
| 2744 | parent_doctype, parent_doctype_name, child_doctype, child_docname, item_row |
| 2745 | ) |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2746 | |
marination | 0c91543 | 2022-05-10 18:04:02 +0530 | [diff] [blame] | 2747 | def validate_quantity(child_item, new_data): |
| 2748 | if not flt(new_data.get("qty")): |
| 2749 | frappe.throw( |
| 2750 | _("Row # {0}: Quantity for Item {1} cannot be zero").format( |
| 2751 | new_data.get("idx"), frappe.bold(new_data.get("item_code")) |
| 2752 | ), |
| 2753 | title=_("Invalid Qty"), |
| 2754 | ) |
| 2755 | |
| 2756 | 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] | 2757 | frappe.throw(_("Cannot set quantity less than delivered quantity")) |
| 2758 | |
marination | 0c91543 | 2022-05-10 18:04:02 +0530 | [diff] [blame] | 2759 | if parent_doctype == "Purchase Order" and flt(new_data.get("qty")) < flt( |
| 2760 | child_item.received_qty |
| 2761 | ): |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2762 | frappe.throw(_("Cannot set quantity less than received quantity")) |
| 2763 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2764 | def should_update_supplied_items(doc) -> bool: |
| 2765 | """Subcontracted PO can allow following changes *after submit*: |
| 2766 | |
| 2767 | 1. Change rate of subcontracting - regardless of other changes. |
| 2768 | 2. Change qty and/or add new items and/or remove items |
| 2769 | Exception: Transfer/Consumption is already made, qty change not allowed. |
| 2770 | """ |
| 2771 | |
| 2772 | supplied_items_processed = any( |
| 2773 | item.supplied_qty or item.consumed_qty or item.returned_qty for item in doc.supplied_items |
| 2774 | ) |
| 2775 | |
| 2776 | update_supplied_items = ( |
| 2777 | any_qty_changed or items_added_or_removed or any_conversion_factor_changed |
| 2778 | ) |
| 2779 | if update_supplied_items and supplied_items_processed: |
| 2780 | frappe.throw(_("Item qty can not be updated as raw materials are already processed.")) |
| 2781 | |
| 2782 | return update_supplied_items |
| 2783 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2784 | data = json.loads(trans_items) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2785 | |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2786 | any_qty_changed = False # updated to true if any item's qty changes |
| 2787 | items_added_or_removed = False # updated to true if any new item is added or removed |
| 2788 | any_conversion_factor_changed = False |
| 2789 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2790 | sales_doctypes = ["Sales Order", "Sales Invoice", "Delivery Note", "Quotation"] |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2791 | parent = frappe.get_doc(parent_doctype, parent_doctype_name) |
marination | 665c27a | 2020-09-15 12:04:38 +0530 | [diff] [blame] | 2792 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2793 | check_doc_permissions(parent, "write") |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2794 | _removed_items = validate_and_delete_children(parent, data) |
| 2795 | items_added_or_removed |= _removed_items |
Saqib | 0ad7449 | 2019-12-24 16:42:30 +0530 | [diff] [blame] | 2796 | |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2797 | for d in data: |
| 2798 | new_child_flag = False |
Ankush Menat | 6de7b8e | 2021-08-24 12:18:40 +0530 | [diff] [blame] | 2799 | |
| 2800 | if not d.get("item_code"): |
| 2801 | # ignore empty rows |
| 2802 | continue |
| 2803 | |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2804 | if not d.get("docname"): |
| 2805 | new_child_flag = True |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2806 | items_added_or_removed = True |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2807 | check_doc_permissions(parent, "create") |
Rohit Waghchaure | 8d5380a | 2020-06-18 14:06:31 +0530 | [diff] [blame] | 2808 | child_item = get_new_child_item(d) |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2809 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2810 | check_doc_permissions(parent, "write") |
| 2811 | child_item = frappe.get_doc(parent_doctype + " Item", d.get("docname")) |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2812 | |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2813 | prev_rate, new_rate = flt(child_item.get("rate")), flt(d.get("rate")) |
| 2814 | 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] | 2815 | prev_con_fac, new_con_fac = flt(child_item.get("conversion_factor")), flt( |
| 2816 | d.get("conversion_factor") |
| 2817 | ) |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2818 | prev_uom, new_uom = child_item.get("uom"), d.get("uom") |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2819 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2820 | if parent_doctype == "Sales Order": |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2821 | 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] | 2822 | elif parent_doctype == "Purchase Order": |
marination | b7e94cc | 2020-06-15 11:32:42 +0530 | [diff] [blame] | 2823 | 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] | 2824 | |
| 2825 | rate_unchanged = prev_rate == new_rate |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2826 | qty_unchanged = prev_qty == new_qty |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2827 | uom_unchanged = prev_uom == new_uom |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2828 | conversion_factor_unchanged = prev_con_fac == new_con_fac |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2829 | any_conversion_factor_changed |= not conversion_factor_unchanged |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2830 | date_unchanged = ( |
| 2831 | prev_date == getdate(new_date) if prev_date and new_date else False |
| 2832 | ) # in case of delivery note etc |
| 2833 | if ( |
| 2834 | rate_unchanged |
| 2835 | and qty_unchanged |
| 2836 | and conversion_factor_unchanged |
| 2837 | and uom_unchanged |
| 2838 | and date_unchanged |
| 2839 | ): |
Saqib | dd374ff | 2020-02-27 12:51:31 +0530 | [diff] [blame] | 2840 | continue |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2841 | |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2842 | validate_quantity(child_item, d) |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2843 | if flt(child_item.get("qty")) != flt(d.get("qty")): |
| 2844 | any_qty_changed = True |
deepeshgarg007 | 77cde83 | 2018-12-27 15:56:51 +0530 | [diff] [blame] | 2845 | |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2846 | child_item.qty = flt(d.get("qty")) |
Saqib | 56fea7d | 2020-10-09 21:19:25 +0530 | [diff] [blame] | 2847 | rate_precision = child_item.precision("rate") or 2 |
| 2848 | conv_fac_precision = child_item.precision("conversion_factor") or 2 |
| 2849 | qty_precision = child_item.precision("qty") or 2 |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2850 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2851 | if flt(child_item.billed_amt, rate_precision) > flt( |
| 2852 | flt(d.get("rate"), rate_precision) * flt(d.get("qty"), qty_precision), rate_precision |
| 2853 | ): |
| 2854 | frappe.throw( |
| 2855 | _("Row #{0}: Cannot set Rate if amount is greater than billed amount for Item {1}.").format( |
| 2856 | child_item.idx, child_item.item_code |
| 2857 | ) |
| 2858 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2859 | else: |
Saqib | 56fea7d | 2020-10-09 21:19:25 +0530 | [diff] [blame] | 2860 | child_item.rate = flt(d.get("rate"), rate_precision) |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2861 | |
Saqib Ansari | 2c3c8aa | 2020-05-29 21:55:38 +0530 | [diff] [blame] | 2862 | if d.get("conversion_factor"): |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2863 | if child_item.stock_uom == child_item.uom: |
| 2864 | child_item.conversion_factor = 1 |
| 2865 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2866 | child_item.conversion_factor = flt(d.get("conversion_factor"), conv_fac_precision) |
marination | 665c27a | 2020-09-15 12:04:38 +0530 | [diff] [blame] | 2867 | |
Saqib | 6131424 | 2020-09-15 11:14:31 +0530 | [diff] [blame] | 2868 | if d.get("uom"): |
| 2869 | child_item.uom = d.get("uom") |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2870 | conversion_factor = flt( |
| 2871 | get_conversion_factor(child_item.item_code, child_item.uom).get("conversion_factor") |
| 2872 | ) |
| 2873 | child_item.conversion_factor = ( |
| 2874 | flt(d.get("conversion_factor"), conv_fac_precision) or conversion_factor |
| 2875 | ) |
Mangesh-Khairnar | a3d5200 | 2019-08-05 10:16:40 +0530 | [diff] [blame] | 2876 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2877 | if d.get("delivery_date") and parent_doctype == "Sales Order": |
| 2878 | child_item.delivery_date = d.get("delivery_date") |
marination | f9c4b20 | 2020-06-12 15:49:53 +0530 | [diff] [blame] | 2879 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2880 | if d.get("schedule_date") and parent_doctype == "Purchase Order": |
| 2881 | child_item.schedule_date = d.get("schedule_date") |
Saqib Ansari | c579b08 | 2020-05-29 22:21:50 +0530 | [diff] [blame] | 2882 | |
Mangesh-Khairnar | a3d5200 | 2019-08-05 10:16:40 +0530 | [diff] [blame] | 2883 | if flt(child_item.price_list_rate): |
Marica | f067447 | 2019-10-11 10:47:09 +0530 | [diff] [blame] | 2884 | if flt(child_item.rate) > flt(child_item.price_list_rate): |
| 2885 | # if rate is greater than price_list_rate, set margin |
| 2886 | # or set discount |
| 2887 | child_item.discount_percentage = 0 |
rohitwaghchaure | 81c2175 | 2019-10-31 15:56:10 +0530 | [diff] [blame] | 2888 | |
| 2889 | if parent_doctype in sales_doctypes: |
| 2890 | child_item.margin_type = "Amount" |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2891 | child_item.margin_rate_or_amount = flt( |
| 2892 | child_item.rate - child_item.price_list_rate, child_item.precision("margin_rate_or_amount") |
| 2893 | ) |
rohitwaghchaure | 81c2175 | 2019-10-31 15:56:10 +0530 | [diff] [blame] | 2894 | child_item.rate_with_margin = child_item.rate |
Marica | f067447 | 2019-10-11 10:47:09 +0530 | [diff] [blame] | 2895 | else: |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2896 | child_item.discount_percentage = flt( |
| 2897 | (1 - flt(child_item.rate) / flt(child_item.price_list_rate)) * 100.0, |
| 2898 | child_item.precision("discount_percentage"), |
| 2899 | ) |
| 2900 | 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] | 2901 | |
| 2902 | if parent_doctype in sales_doctypes: |
| 2903 | child_item.margin_type = "" |
| 2904 | child_item.margin_rate_or_amount = 0 |
| 2905 | child_item.rate_with_margin = 0 |
Mangesh-Khairnar | a3d5200 | 2019-08-05 10:16:40 +0530 | [diff] [blame] | 2906 | |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2907 | child_item.flags.ignore_validate_update_after_submit = True |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2908 | if new_child_flag: |
Saqib Ansari | f53299e | 2020-04-15 22:08:12 +0530 | [diff] [blame] | 2909 | parent.load_from_db() |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2910 | child_item.idx = len(parent.items) + 1 |
Stavros Anastasiadis | 3d82b74 | 2018-12-10 13:00:55 +0100 | [diff] [blame] | 2911 | child_item.insert() |
| 2912 | else: |
| 2913 | child_item.save() |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2914 | |
Rushabh Mehta | fafbb02 | 2018-12-24 22:09:15 +0530 | [diff] [blame] | 2915 | parent.reload() |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2916 | parent.flags.ignore_validate_update_after_submit = True |
| 2917 | parent.set_qty_as_per_stock_uom() |
| 2918 | parent.calculate_taxes_and_totals() |
Ankush Menat | df6e208 | 2021-02-11 11:04:39 +0530 | [diff] [blame] | 2919 | parent.set_total_in_words() |
Nabin Hait | 49a46f0 | 2019-10-21 13:35:43 +0530 | [diff] [blame] | 2920 | if parent_doctype == "Sales Order": |
Marica | 3dee527 | 2020-06-23 10:33:47 +0530 | [diff] [blame] | 2921 | make_packing_list(parent) |
Nabin Hait | 49a46f0 | 2019-10-21 13:35:43 +0530 | [diff] [blame] | 2922 | parent.set_gross_profit() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2923 | frappe.get_doc("Authorization Control").validate_approving_authority( |
| 2924 | parent.doctype, parent.company, parent.base_grand_total |
| 2925 | ) |
Doridel Cahanap | 6f06cc2 | 2018-05-17 16:28:58 +0800 | [diff] [blame] | 2926 | |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2927 | parent.set_payment_schedule() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2928 | if parent_doctype == "Purchase Order": |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2929 | parent.validate_minimum_order_qty() |
| 2930 | parent.validate_budget() |
| 2931 | if parent.is_against_so(): |
| 2932 | parent.update_status_updater() |
Nabin Hait | b2da082 | 2018-07-13 17:01:40 +0530 | [diff] [blame] | 2933 | else: |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2934 | parent.check_credit_limit() |
Ankush Menat | 733c9de | 2022-01-04 18:39:30 +0530 | [diff] [blame] | 2935 | |
| 2936 | # reset index of child table |
| 2937 | for idx, row in enumerate(parent.get(child_docname), start=1): |
| 2938 | row.idx = idx |
| 2939 | |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2940 | parent.save() |
Nabin Hait | b2da082 | 2018-07-13 17:01:40 +0530 | [diff] [blame] | 2941 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2942 | if parent_doctype == "Purchase Order": |
| 2943 | update_last_purchase_rate(parent, is_submit=1) |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2944 | parent.update_prevdoc_status() |
| 2945 | parent.update_requested_qty() |
| 2946 | parent.update_ordered_qty() |
| 2947 | parent.update_ordered_and_reserved_qty() |
| 2948 | parent.update_receiving_percentage() |
s-aga-r | 6d89b2f | 2022-06-18 15:46:59 +0530 | [diff] [blame] | 2949 | if parent.is_old_subcontracting_flow: |
Ankush Menat | dd11f26 | 2022-06-27 15:55:08 +0530 | [diff] [blame] | 2950 | if should_update_supplied_items(parent): |
| 2951 | parent.update_reserved_qty_for_subcontract() |
Sagar Sharma | 78ff178 | 2022-06-28 22:20:32 +0530 | [diff] [blame] | 2952 | parent.create_raw_materials_supplied() |
s-aga-r | 6d89b2f | 2022-06-18 15:46:59 +0530 | [diff] [blame] | 2953 | parent.save() |
Ankush Menat | c84e11a | 2022-06-01 12:55:10 +0530 | [diff] [blame] | 2954 | else: # Sales Order |
| 2955 | parent.validate_warehouse() |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2956 | parent.update_reserved_qty() |
| 2957 | parent.update_project() |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2958 | parent.update_prevdoc_status("submit") |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2959 | parent.update_delivery_status() |
Nabin Hait | b2da082 | 2018-07-13 17:01:40 +0530 | [diff] [blame] | 2960 | |
Saqib | 6db92fb | 2020-09-14 19:54:17 +0530 | [diff] [blame] | 2961 | parent.reload() |
| 2962 | validate_workflow_conditions(parent) |
| 2963 | |
Rushabh Mehta | c9b1a35 | 2018-12-24 20:55:35 +0530 | [diff] [blame] | 2964 | parent.update_blanket_order() |
| 2965 | parent.update_billing_percentage() |
| 2966 | parent.set_status() |
Gaurav | f1e28e0 | 2019-02-13 16:46:24 +0530 | [diff] [blame] | 2967 | |
s-aga-r | ac24d77 | 2023-04-05 19:48:15 +0530 | [diff] [blame] | 2968 | # Cancel and Recreate Stock Reservation Entries. |
s-aga-r | 38e9367 | 2023-04-02 21:24:59 +0530 | [diff] [blame] | 2969 | if parent_doctype == "Sales Order": |
| 2970 | from erpnext.stock.doctype.stock_reservation_entry.stock_reservation_entry import ( |
| 2971 | cancel_stock_reservation_entries, |
| 2972 | has_reserved_stock, |
s-aga-r | 38e9367 | 2023-04-02 21:24:59 +0530 | [diff] [blame] | 2973 | ) |
| 2974 | |
| 2975 | if has_reserved_stock(parent.doctype, parent.name): |
| 2976 | cancel_stock_reservation_entries(parent.doctype, parent.name) |
s-aga-r | ac24d77 | 2023-04-05 19:48:15 +0530 | [diff] [blame] | 2977 | parent.create_stock_reservation_entries() |
s-aga-r | 38e9367 | 2023-04-02 21:24:59 +0530 | [diff] [blame] | 2978 | |
Ankush Menat | 494bd9e | 2022-03-28 18:52:46 +0530 | [diff] [blame] | 2979 | |
Gursheen Anand | a06017c | 2023-06-12 15:24:53 +0530 | [diff] [blame] | 2980 | @erpnext.allow_regional |
| 2981 | def validate_regional(doc): |
| 2982 | pass |
| 2983 | |
| 2984 | |
| 2985 | @erpnext.allow_regional |
| 2986 | def validate_einvoice_fields(doc): |
| 2987 | pass |
| 2988 | |
| 2989 | |
| 2990 | @erpnext.allow_regional |
| 2991 | def update_gl_dict_with_regional_fields(doc, gl_dict): |
| 2992 | pass |