| # Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors |
| # License: GNU General Public License v3. See license.txt |
| |
| |
| import copy |
| |
| import frappe |
| from frappe import _ |
| from frappe.model.meta import get_field_precision |
| from frappe.utils import cint, flt, formatdate, getdate, now |
| |
| import erpnext |
| from erpnext.accounts.doctype.accounting_dimension.accounting_dimension import ( |
| get_accounting_dimensions, |
| ) |
| from erpnext.accounts.doctype.accounting_dimension_filter.accounting_dimension_filter import ( |
| get_dimension_filter_map, |
| ) |
| from erpnext.accounts.doctype.accounting_period.accounting_period import ClosedAccountingPeriod |
| from erpnext.accounts.doctype.budget.budget import validate_expense_against_budget |
| from erpnext.accounts.utils import create_payment_ledger_entry |
| from erpnext.exceptions import InvalidAccountDimensionError, MandatoryAccountDimensionError |
| |
| |
| def make_gl_entries( |
| gl_map, |
| cancel=False, |
| adv_adj=False, |
| merge_entries=True, |
| update_outstanding="Yes", |
| from_repost=False, |
| ): |
| if gl_map: |
| if not cancel: |
| make_acc_dimensions_offsetting_entry(gl_map) |
| validate_accounting_period(gl_map) |
| validate_disabled_accounts(gl_map) |
| gl_map = process_gl_map(gl_map, merge_entries) |
| if gl_map and len(gl_map) > 1: |
| create_payment_ledger_entry( |
| gl_map, |
| cancel=0, |
| adv_adj=adv_adj, |
| update_outstanding=update_outstanding, |
| from_repost=from_repost, |
| ) |
| save_entries(gl_map, adv_adj, update_outstanding, from_repost) |
| # Post GL Map process there may no be any GL Entries |
| elif gl_map: |
| frappe.throw( |
| _( |
| "Incorrect number of General Ledger Entries found. You might have selected a wrong Account in the transaction." |
| ) |
| ) |
| else: |
| make_reverse_gl_entries(gl_map, adv_adj=adv_adj, update_outstanding=update_outstanding) |
| |
| |
| def make_acc_dimensions_offsetting_entry(gl_map): |
| accounting_dimensions_to_offset = get_accounting_dimensions_for_offsetting_entry( |
| gl_map, gl_map[0].company |
| ) |
| no_of_dimensions = len(accounting_dimensions_to_offset) |
| if no_of_dimensions == 0: |
| return |
| |
| offsetting_entries = [] |
| |
| for gle in gl_map: |
| for dimension in accounting_dimensions_to_offset: |
| offsetting_entry = gle.copy() |
| debit = flt(gle.credit) / no_of_dimensions if gle.credit != 0 else 0 |
| credit = flt(gle.debit) / no_of_dimensions if gle.debit != 0 else 0 |
| offsetting_entry.update( |
| { |
| "account": dimension.offsetting_account, |
| "debit": debit, |
| "credit": credit, |
| "debit_in_account_currency": debit, |
| "credit_in_account_currency": credit, |
| "remarks": _("Offsetting for Accounting Dimension") + f" - {dimension.name}", |
| "against_voucher": None, |
| } |
| ) |
| offsetting_entry["against_voucher_type"] = None |
| offsetting_entries.append(offsetting_entry) |
| |
| gl_map += offsetting_entries |
| |
| |
| def get_accounting_dimensions_for_offsetting_entry(gl_map, company): |
| acc_dimension = frappe.qb.DocType("Accounting Dimension") |
| dimension_detail = frappe.qb.DocType("Accounting Dimension Detail") |
| |
| acc_dimensions = ( |
| frappe.qb.from_(acc_dimension) |
| .inner_join(dimension_detail) |
| .on(acc_dimension.name == dimension_detail.parent) |
| .select(acc_dimension.fieldname, acc_dimension.name, dimension_detail.offsetting_account) |
| .where( |
| (acc_dimension.disabled == 0) |
| & (dimension_detail.company == company) |
| & (dimension_detail.automatically_post_balancing_accounting_entry == 1) |
| ) |
| ).run(as_dict=True) |
| |
| accounting_dimensions_to_offset = [] |
| for acc_dimension in acc_dimensions: |
| values = set([entry.get(acc_dimension.fieldname) for entry in gl_map]) |
| if len(values) > 1: |
| accounting_dimensions_to_offset.append(acc_dimension) |
| |
| return accounting_dimensions_to_offset |
| |
| |
| def validate_disabled_accounts(gl_map): |
| accounts = [d.account for d in gl_map if d.account] |
| |
| Account = frappe.qb.DocType("Account") |
| |
| disabled_accounts = ( |
| frappe.qb.from_(Account) |
| .where(Account.name.isin(accounts) & Account.disabled == 1) |
| .select(Account.name, Account.disabled) |
| ).run(as_dict=True) |
| |
| if disabled_accounts: |
| account_list = "<br>" |
| account_list += ", ".join([frappe.bold(d.name) for d in disabled_accounts]) |
| frappe.throw( |
| _("Cannot create accounting entries against disabled accounts: {0}").format(account_list), |
| title=_("Disabled Account Selected"), |
| ) |
| |
| |
| def validate_accounting_period(gl_map): |
| accounting_periods = frappe.db.sql( |
| """ SELECT |
| ap.name as name |
| FROM |
| `tabAccounting Period` ap, `tabClosed Document` cd |
| WHERE |
| ap.name = cd.parent |
| AND ap.company = %(company)s |
| AND cd.closed = 1 |
| AND cd.document_type = %(voucher_type)s |
| AND %(date)s between ap.start_date and ap.end_date |
| """, |
| { |
| "date": gl_map[0].posting_date, |
| "company": gl_map[0].company, |
| "voucher_type": gl_map[0].voucher_type, |
| }, |
| as_dict=1, |
| ) |
| |
| if accounting_periods: |
| frappe.throw( |
| _( |
| "You cannot create or cancel any accounting entries with in the closed Accounting Period {0}" |
| ).format(frappe.bold(accounting_periods[0].name)), |
| ClosedAccountingPeriod, |
| ) |
| |
| |
| def process_gl_map(gl_map, merge_entries=True, precision=None): |
| if not gl_map: |
| return [] |
| |
| if gl_map[0].voucher_type != "Period Closing Voucher": |
| gl_map = distribute_gl_based_on_cost_center_allocation(gl_map, precision) |
| |
| if merge_entries: |
| gl_map = merge_similar_entries(gl_map, precision) |
| |
| gl_map = toggle_debit_credit_if_negative(gl_map) |
| |
| return gl_map |
| |
| |
| def distribute_gl_based_on_cost_center_allocation(gl_map, precision=None): |
| cost_center_allocation = get_cost_center_allocation_data(gl_map[0]["company"], gl_map[0]["posting_date"]) |
| if not cost_center_allocation: |
| return gl_map |
| |
| new_gl_map = [] |
| for d in gl_map: |
| cost_center = d.get("cost_center") |
| |
| # Validate budget against main cost center |
| validate_expense_against_budget(d, expense_amount=flt(d.debit, precision) - flt(d.credit, precision)) |
| |
| if cost_center and cost_center_allocation.get(cost_center): |
| for sub_cost_center, percentage in cost_center_allocation.get(cost_center, {}).items(): |
| gle = copy.deepcopy(d) |
| gle.cost_center = sub_cost_center |
| for field in ("debit", "credit", "debit_in_account_currency", "credit_in_account_currency"): |
| gle[field] = flt(flt(d.get(field)) * percentage / 100, precision) |
| new_gl_map.append(gle) |
| else: |
| new_gl_map.append(d) |
| |
| return new_gl_map |
| |
| |
| def get_cost_center_allocation_data(company, posting_date): |
| par = frappe.qb.DocType("Cost Center Allocation") |
| child = frappe.qb.DocType("Cost Center Allocation Percentage") |
| |
| records = ( |
| frappe.qb.from_(par) |
| .inner_join(child) |
| .on(par.name == child.parent) |
| .select(par.main_cost_center, child.cost_center, child.percentage) |
| .where(par.docstatus == 1) |
| .where(par.company == company) |
| .where(par.valid_from <= posting_date) |
| .orderby(par.valid_from, order=frappe.qb.desc) |
| ).run(as_dict=True) |
| |
| cc_allocation = frappe._dict() |
| for d in records: |
| cc_allocation.setdefault(d.main_cost_center, frappe._dict()).setdefault(d.cost_center, d.percentage) |
| |
| return cc_allocation |
| |
| |
| def merge_similar_entries(gl_map, precision=None): |
| merged_gl_map = [] |
| accounting_dimensions = get_accounting_dimensions() |
| merge_properties = get_merge_properties(accounting_dimensions) |
| |
| for entry in gl_map: |
| entry.merge_key = get_merge_key(entry, merge_properties) |
| # if there is already an entry in this account then just add it |
| # to that entry |
| same_head = check_if_in_list(entry, merged_gl_map) |
| if same_head: |
| same_head.debit = flt(same_head.debit) + flt(entry.debit) |
| same_head.debit_in_account_currency = flt(same_head.debit_in_account_currency) + flt( |
| entry.debit_in_account_currency |
| ) |
| same_head.credit = flt(same_head.credit) + flt(entry.credit) |
| same_head.credit_in_account_currency = flt(same_head.credit_in_account_currency) + flt( |
| entry.credit_in_account_currency |
| ) |
| else: |
| merged_gl_map.append(entry) |
| |
| company = gl_map[0].company if gl_map else erpnext.get_default_company() |
| company_currency = erpnext.get_company_currency(company) |
| |
| if not precision: |
| precision = get_field_precision(frappe.get_meta("GL Entry").get_field("debit"), company_currency) |
| |
| # filter zero debit and credit entries |
| merged_gl_map = filter( |
| lambda x: flt(x.debit, precision) != 0 |
| or flt(x.credit, precision) != 0 |
| or ( |
| x.voucher_type == "Journal Entry" |
| and frappe.get_cached_value("Journal Entry", x.voucher_no, "voucher_type") |
| == "Exchange Gain Or Loss" |
| ), |
| merged_gl_map, |
| ) |
| merged_gl_map = list(merged_gl_map) |
| |
| return merged_gl_map |
| |
| |
| def get_merge_properties(dimensions=None): |
| merge_properties = [ |
| "account", |
| "cost_center", |
| "party", |
| "party_type", |
| "voucher_detail_no", |
| "against_voucher", |
| "against_voucher_type", |
| "project", |
| "finance_book", |
| "voucher_no", |
| ] |
| if dimensions: |
| merge_properties.extend(dimensions) |
| return merge_properties |
| |
| |
| def get_merge_key(entry, merge_properties): |
| merge_key = [] |
| for fieldname in merge_properties: |
| merge_key.append(entry.get(fieldname, "")) |
| |
| return tuple(merge_key) |
| |
| |
| def check_if_in_list(gle, gl_map): |
| for e in gl_map: |
| if e.merge_key == gle.merge_key: |
| return e |
| |
| |
| def toggle_debit_credit_if_negative(gl_map): |
| for entry in gl_map: |
| # toggle debit, credit if negative entry |
| if flt(entry.debit) < 0: |
| entry.credit = flt(entry.credit) - flt(entry.debit) |
| entry.debit = 0.0 |
| |
| if flt(entry.debit_in_account_currency) < 0: |
| entry.credit_in_account_currency = flt(entry.credit_in_account_currency) - flt( |
| entry.debit_in_account_currency |
| ) |
| entry.debit_in_account_currency = 0.0 |
| |
| if flt(entry.credit) < 0: |
| entry.debit = flt(entry.debit) - flt(entry.credit) |
| entry.credit = 0.0 |
| |
| if flt(entry.credit_in_account_currency) < 0: |
| entry.debit_in_account_currency = flt(entry.debit_in_account_currency) - flt( |
| entry.credit_in_account_currency |
| ) |
| entry.credit_in_account_currency = 0.0 |
| |
| update_net_values(entry) |
| |
| return gl_map |
| |
| |
| def update_net_values(entry): |
| # In some scenarios net value needs to be shown in the ledger |
| # This method updates net values as debit or credit |
| if entry.post_net_value and entry.debit and entry.credit: |
| if entry.debit > entry.credit: |
| entry.debit = entry.debit - entry.credit |
| entry.debit_in_account_currency = ( |
| entry.debit_in_account_currency - entry.credit_in_account_currency |
| ) |
| entry.credit = 0 |
| entry.credit_in_account_currency = 0 |
| else: |
| entry.credit = entry.credit - entry.debit |
| entry.credit_in_account_currency = ( |
| entry.credit_in_account_currency - entry.debit_in_account_currency |
| ) |
| |
| entry.debit = 0 |
| entry.debit_in_account_currency = 0 |
| |
| |
| def save_entries(gl_map, adv_adj, update_outstanding, from_repost=False): |
| if not from_repost: |
| validate_cwip_accounts(gl_map) |
| |
| process_debit_credit_difference(gl_map) |
| |
| dimension_filter_map = get_dimension_filter_map() |
| if gl_map: |
| check_freezing_date(gl_map[0]["posting_date"], adv_adj) |
| is_opening = any(d.get("is_opening") == "Yes" for d in gl_map) |
| if gl_map[0]["voucher_type"] != "Period Closing Voucher": |
| validate_against_pcv(is_opening, gl_map[0]["posting_date"], gl_map[0]["company"]) |
| |
| for entry in gl_map: |
| validate_allowed_dimensions(entry, dimension_filter_map) |
| make_entry(entry, adv_adj, update_outstanding, from_repost) |
| |
| |
| def make_entry(args, adv_adj, update_outstanding, from_repost=False): |
| gle = frappe.new_doc("GL Entry") |
| gle.update(args) |
| gle.flags.ignore_permissions = 1 |
| gle.flags.from_repost = from_repost |
| gle.flags.adv_adj = adv_adj |
| gle.flags.update_outstanding = update_outstanding or "Yes" |
| gle.flags.notify_update = False |
| gle.submit() |
| |
| if not from_repost and gle.voucher_type != "Period Closing Voucher": |
| validate_expense_against_budget(args) |
| |
| |
| def validate_cwip_accounts(gl_map): |
| """Validate that CWIP account are not used in Journal Entry""" |
| if gl_map and gl_map[0].voucher_type != "Journal Entry": |
| return |
| |
| cwip_enabled = any( |
| cint(ac.enable_cwip_accounting) |
| for ac in frappe.db.get_all("Asset Category", "enable_cwip_accounting") |
| ) |
| if cwip_enabled: |
| cwip_accounts = [ |
| d[0] |
| for d in frappe.db.sql( |
| """select name from tabAccount |
| where account_type = 'Capital Work in Progress' and is_group=0""" |
| ) |
| ] |
| |
| for entry in gl_map: |
| if entry.account in cwip_accounts: |
| frappe.throw( |
| _( |
| "Account: <b>{0}</b> is capital Work in progress and can not be updated by Journal Entry" |
| ).format(entry.account) |
| ) |
| |
| |
| def process_debit_credit_difference(gl_map): |
| precision = get_field_precision( |
| frappe.get_meta("GL Entry").get_field("debit"), |
| currency=frappe.get_cached_value("Company", gl_map[0].company, "default_currency"), |
| ) |
| |
| voucher_type = gl_map[0].voucher_type |
| voucher_no = gl_map[0].voucher_no |
| allowance = get_debit_credit_allowance(voucher_type, precision) |
| |
| debit_credit_diff = get_debit_credit_difference(gl_map, precision) |
| |
| if abs(debit_credit_diff) > allowance: |
| if not ( |
| voucher_type == "Journal Entry" |
| and frappe.get_cached_value("Journal Entry", voucher_no, "voucher_type") |
| == "Exchange Gain Or Loss" |
| ): |
| raise_debit_credit_not_equal_error(debit_credit_diff, voucher_type, voucher_no) |
| |
| elif abs(debit_credit_diff) >= (1.0 / (10**precision)): |
| make_round_off_gle(gl_map, debit_credit_diff, precision) |
| |
| debit_credit_diff = get_debit_credit_difference(gl_map, precision) |
| if abs(debit_credit_diff) > allowance: |
| if not ( |
| voucher_type == "Journal Entry" |
| and frappe.get_cached_value("Journal Entry", voucher_no, "voucher_type") |
| == "Exchange Gain Or Loss" |
| ): |
| raise_debit_credit_not_equal_error(debit_credit_diff, voucher_type, voucher_no) |
| |
| |
| def get_debit_credit_difference(gl_map, precision): |
| debit_credit_diff = 0.0 |
| for entry in gl_map: |
| entry.debit = flt(entry.debit, precision) |
| entry.credit = flt(entry.credit, precision) |
| debit_credit_diff += entry.debit - entry.credit |
| |
| debit_credit_diff = flt(debit_credit_diff, precision) |
| |
| return debit_credit_diff |
| |
| |
| def get_debit_credit_allowance(voucher_type, precision): |
| if voucher_type in ("Journal Entry", "Payment Entry"): |
| allowance = 5.0 / (10**precision) |
| else: |
| allowance = 0.5 |
| |
| return allowance |
| |
| |
| def raise_debit_credit_not_equal_error(debit_credit_diff, voucher_type, voucher_no): |
| frappe.throw( |
| _("Debit and Credit not equal for {0} #{1}. Difference is {2}.").format( |
| voucher_type, voucher_no, debit_credit_diff |
| ) |
| ) |
| |
| |
| def make_round_off_gle(gl_map, debit_credit_diff, precision): |
| round_off_account, round_off_cost_center = get_round_off_account_and_cost_center( |
| gl_map[0].company, gl_map[0].voucher_type, gl_map[0].voucher_no |
| ) |
| round_off_gle = frappe._dict() |
| round_off_account_exists = False |
| |
| if gl_map[0].voucher_type != "Period Closing Voucher": |
| for d in gl_map: |
| if d.account == round_off_account: |
| round_off_gle = d |
| if d.debit: |
| debit_credit_diff -= flt(d.debit) - flt(d.credit) |
| else: |
| debit_credit_diff += flt(d.credit) |
| round_off_account_exists = True |
| |
| if round_off_account_exists and abs(debit_credit_diff) < (1.0 / (10**precision)): |
| gl_map.remove(round_off_gle) |
| return |
| |
| if not round_off_gle: |
| for k in ["voucher_type", "voucher_no", "company", "posting_date", "remarks"]: |
| round_off_gle[k] = gl_map[0][k] |
| |
| round_off_gle.update( |
| { |
| "account": round_off_account, |
| "debit_in_account_currency": abs(debit_credit_diff) if debit_credit_diff < 0 else 0, |
| "credit_in_account_currency": debit_credit_diff if debit_credit_diff > 0 else 0, |
| "debit": abs(debit_credit_diff) if debit_credit_diff < 0 else 0, |
| "credit": debit_credit_diff if debit_credit_diff > 0 else 0, |
| "cost_center": round_off_cost_center, |
| "party_type": None, |
| "party": None, |
| "is_opening": "No", |
| "against_voucher_type": None, |
| "against_voucher": None, |
| } |
| ) |
| |
| update_accounting_dimensions(round_off_gle) |
| if not round_off_account_exists: |
| gl_map.append(round_off_gle) |
| |
| |
| def update_accounting_dimensions(round_off_gle): |
| dimensions = get_accounting_dimensions() |
| meta = frappe.get_meta(round_off_gle["voucher_type"]) |
| has_all_dimensions = True |
| |
| for dimension in dimensions: |
| if not meta.has_field(dimension): |
| has_all_dimensions = False |
| |
| if dimensions and has_all_dimensions: |
| dimension_values = frappe.db.get_value( |
| round_off_gle["voucher_type"], round_off_gle["voucher_no"], dimensions, as_dict=1 |
| ) |
| |
| for dimension in dimensions: |
| round_off_gle[dimension] = dimension_values.get(dimension) |
| |
| |
| def get_round_off_account_and_cost_center(company, voucher_type, voucher_no, use_company_default=False): |
| round_off_account, round_off_cost_center = frappe.get_cached_value( |
| "Company", company, ["round_off_account", "round_off_cost_center"] |
| ) or [None, None] |
| |
| # Use expense account as fallback |
| if not round_off_account: |
| round_off_account = frappe.get_cached_value("Company", company, "default_expense_account") |
| |
| meta = frappe.get_meta(voucher_type) |
| |
| # Give first preference to parent cost center for round off GLE |
| if not use_company_default and meta.has_field("cost_center"): |
| parent_cost_center = frappe.db.get_value(voucher_type, voucher_no, "cost_center") |
| if parent_cost_center: |
| round_off_cost_center = parent_cost_center |
| |
| if not round_off_account: |
| frappe.throw(_("Please mention Round Off Account in Company")) |
| |
| if not round_off_cost_center: |
| frappe.throw(_("Please mention Round Off Cost Center in Company")) |
| |
| return round_off_account, round_off_cost_center |
| |
| |
| def make_reverse_gl_entries( |
| gl_entries=None, |
| voucher_type=None, |
| voucher_no=None, |
| adv_adj=False, |
| update_outstanding="Yes", |
| partial_cancel=False, |
| ): |
| """ |
| Get original gl entries of the voucher |
| and make reverse gl entries by swapping debit and credit |
| """ |
| |
| if not gl_entries: |
| gl_entry = frappe.qb.DocType("GL Entry") |
| gl_entries = ( |
| frappe.qb.from_(gl_entry) |
| .select("*") |
| .where(gl_entry.voucher_type == voucher_type) |
| .where(gl_entry.voucher_no == voucher_no) |
| .where(gl_entry.is_cancelled == 0) |
| .for_update() |
| ).run(as_dict=1) |
| |
| if gl_entries: |
| create_payment_ledger_entry( |
| gl_entries, |
| cancel=1, |
| adv_adj=adv_adj, |
| update_outstanding=update_outstanding, |
| partial_cancel=partial_cancel, |
| ) |
| validate_accounting_period(gl_entries) |
| check_freezing_date(gl_entries[0]["posting_date"], adv_adj) |
| |
| is_opening = any(d.get("is_opening") == "Yes" for d in gl_entries) |
| validate_against_pcv(is_opening, gl_entries[0]["posting_date"], gl_entries[0]["company"]) |
| if partial_cancel: |
| # Partial cancel is only used by `Advance` in separate account feature. |
| # Only cancel GL entries for unlinked reference using `voucher_detail_no` |
| gle = frappe.qb.DocType("GL Entry") |
| for x in gl_entries: |
| query = ( |
| frappe.qb.update(gle) |
| .set(gle.is_cancelled, True) |
| .set(gle.modified, now()) |
| .set(gle.modified_by, frappe.session.user) |
| .where( |
| (gle.company == x.company) |
| & (gle.account == x.account) |
| & (gle.party_type == x.party_type) |
| & (gle.party == x.party) |
| & (gle.voucher_type == x.voucher_type) |
| & (gle.voucher_no == x.voucher_no) |
| & (gle.against_voucher_type == x.against_voucher_type) |
| & (gle.against_voucher == x.against_voucher) |
| & (gle.voucher_detail_no == x.voucher_detail_no) |
| ) |
| ) |
| query.run() |
| else: |
| set_as_cancel(gl_entries[0]["voucher_type"], gl_entries[0]["voucher_no"]) |
| |
| for entry in gl_entries: |
| new_gle = copy.deepcopy(entry) |
| new_gle["name"] = None |
| debit = new_gle.get("debit", 0) |
| credit = new_gle.get("credit", 0) |
| |
| debit_in_account_currency = new_gle.get("debit_in_account_currency", 0) |
| credit_in_account_currency = new_gle.get("credit_in_account_currency", 0) |
| |
| new_gle["debit"] = credit |
| new_gle["credit"] = debit |
| new_gle["debit_in_account_currency"] = credit_in_account_currency |
| new_gle["credit_in_account_currency"] = debit_in_account_currency |
| |
| new_gle["remarks"] = "On cancellation of " + new_gle["voucher_no"] |
| new_gle["is_cancelled"] = 1 |
| |
| if new_gle["debit"] or new_gle["credit"]: |
| make_entry(new_gle, adv_adj, "Yes") |
| |
| |
| def check_freezing_date(posting_date, adv_adj=False): |
| """ |
| Nobody can do GL Entries where posting date is before freezing date |
| except authorized person |
| |
| Administrator has all the roles so this check will be bypassed if any role is allowed to post |
| Hence stop admin to bypass if accounts are freezed |
| """ |
| if not adv_adj: |
| acc_frozen_upto = frappe.db.get_single_value("Accounts Settings", "acc_frozen_upto") |
| if acc_frozen_upto: |
| frozen_accounts_modifier = frappe.db.get_single_value( |
| "Accounts Settings", "frozen_accounts_modifier" |
| ) |
| if getdate(posting_date) <= getdate(acc_frozen_upto) and ( |
| frozen_accounts_modifier not in frappe.get_roles() or frappe.session.user == "Administrator" |
| ): |
| frappe.throw( |
| _("You are not authorized to add or update entries before {0}").format( |
| formatdate(acc_frozen_upto) |
| ) |
| ) |
| |
| |
| def validate_against_pcv(is_opening, posting_date, company): |
| if is_opening and frappe.db.exists("Period Closing Voucher", {"docstatus": 1, "company": company}): |
| frappe.throw( |
| _("Opening Entry can not be created after Period Closing Voucher is created."), |
| title=_("Invalid Opening Entry"), |
| ) |
| |
| last_pcv_date = frappe.db.get_value( |
| "Period Closing Voucher", {"docstatus": 1, "company": company}, "max(posting_date)" |
| ) |
| |
| if last_pcv_date and getdate(posting_date) <= getdate(last_pcv_date): |
| message = _("Books have been closed till the period ending on {0}").format(formatdate(last_pcv_date)) |
| message += "</br >" |
| message += _("You cannot create/amend any accounting entries till this date.") |
| frappe.throw(message, title=_("Period Closed")) |
| |
| |
| def set_as_cancel(voucher_type, voucher_no): |
| """ |
| Set is_cancelled=1 in all original gl entries for the voucher |
| """ |
| frappe.db.sql( |
| """UPDATE `tabGL Entry` SET is_cancelled = 1, |
| modified=%s, modified_by=%s |
| where voucher_type=%s and voucher_no=%s and is_cancelled = 0""", |
| (now(), frappe.session.user, voucher_type, voucher_no), |
| ) |
| |
| |
| def validate_allowed_dimensions(gl_entry, dimension_filter_map): |
| for key, value in dimension_filter_map.items(): |
| dimension = key[0] |
| account = key[1] |
| |
| if gl_entry.account == account: |
| if value["is_mandatory"] and not gl_entry.get(dimension): |
| frappe.throw( |
| _("{0} is mandatory for account {1}").format( |
| frappe.bold(frappe.unscrub(dimension)), frappe.bold(gl_entry.account) |
| ), |
| MandatoryAccountDimensionError, |
| ) |
| |
| if value["allow_or_restrict"] == "Allow": |
| if gl_entry.get(dimension) and gl_entry.get(dimension) not in value["allowed_dimensions"]: |
| frappe.throw( |
| _("Invalid value {0} for {1} against account {2}").format( |
| frappe.bold(gl_entry.get(dimension)), |
| frappe.bold(frappe.unscrub(dimension)), |
| frappe.bold(gl_entry.account), |
| ), |
| InvalidAccountDimensionError, |
| ) |
| else: |
| if gl_entry.get(dimension) and gl_entry.get(dimension) in value["allowed_dimensions"]: |
| frappe.throw( |
| _("Invalid value {0} for {1} against account {2}").format( |
| frappe.bold(gl_entry.get(dimension)), |
| frappe.bold(frappe.unscrub(dimension)), |
| frappe.bold(gl_entry.account), |
| ), |
| InvalidAccountDimensionError, |
| ) |