Try to closing 2022 fiscal year, got this message “Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1”.
Is there a way to find out the difference?
I’ve tried looking at the error log but it doesn’t help
Traceback with variables (most recent call last):
File "apps/erpnext/erpnext/accounts/doctype/period_closing_voucher/period_closing_voucher.py", line 197, in process_gl_entries
make_gl_entries(gl_entries, merge_entries=False)
gl_entries = [{'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 252040002, 'credit': 0, 'debit_in_account_currency': 252040002.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '41.01.02 - Data Management Consulting Service Revenue - CP', 'cost_center': 'General Affair & Administration - CP', 'finance_book': None, 'account_currency': 'IDR'}, {'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 2515362502, 'credit': 0, 'debit_in_account_currency': 2515362502.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '4...
make_gl_entries = <function make_gl_entries at 0x7fd86ff0aa70>
e = ValidationError('Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1.')
File "apps/erpnext/erpnext/accounts/general_ledger.py", line 45, in make_gl_entries
save_entries(gl_map, adv_adj, update_outstanding, from_repost)
gl_map = [{'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 252040002, 'credit': 0, 'debit_in_account_currency': 252040002.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '41.01.02 - Data Management Consulting Service Revenue - CP', 'cost_center': 'General Affair & Administration - CP', 'finance_book': None, 'account_currency': 'IDR'}, {'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 2515362502, 'credit': 0, 'debit_in_account_currency': 2515362502.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '4...
cancel = False
adv_adj = False
merge_entries = False
update_outstanding = 'Yes'
from_repost = False
File "apps/erpnext/erpnext/accounts/general_ledger.py", line 286, in save_entries
process_debit_credit_difference(gl_map)
gl_map = [{'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 252040002, 'credit': 0, 'debit_in_account_currency': 252040002.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '41.01.02 - Data Management Consulting Service Revenue - CP', 'cost_center': 'General Affair & Administration - CP', 'finance_book': None, 'account_currency': 'IDR'}, {'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 2515362502, 'credit': 0, 'debit_in_account_currency': 2515362502.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '4...
adv_adj = False
update_outstanding = 'Yes'
from_repost = False
File "apps/erpnext/erpnext/accounts/general_ledger.py", line 348, in process_debit_credit_difference
raise_debit_credit_not_equal_error(debit_credit_diff, voucher_type, voucher_no)
gl_map = [{'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 252040002, 'credit': 0, 'debit_in_account_currency': 252040002.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '41.01.02 - Data Management Consulting Service Revenue - CP', 'cost_center': 'General Affair & Administration - CP', 'finance_book': None, 'account_currency': 'IDR'}, {'company': 'My Company', 'posting_date': '2022-12-31', 'fiscal_year': '2022', 'voucher_type': 'Period Closing Voucher', 'voucher_no': 'ACC-PCV-2023-00001', 'remarks': 'Closing PL account 2022', 'debit': 2515362502, 'credit': 0, 'debit_in_account_currency': 2515362502.0, 'credit_in_account_currency': 0, 'is_opening': 'No', 'party_type': None, 'party': None, 'project': None, 'post_net_value': None, 'account': '4...
precision = 0
voucher_type = 'Period Closing Voucher'
voucher_no = 'ACC-PCV-2023-00001'
allowance = 0.5
debit_credit_diff = 1
File "apps/erpnext/erpnext/accounts/general_ledger.py", line 380, in raise_debit_credit_not_equal_error
frappe.throw(
debit_credit_diff = 1
voucher_type = 'Period Closing Voucher'
voucher_no = 'ACC-PCV-2023-00001'
File "apps/frappe/frappe/__init__.py", line 524, in throw
msgprint(
msg = 'Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1.'
exc = <class 'frappe.exceptions.ValidationError'>
title = None
is_minimizable = False
wide = False
as_list = False
File "apps/frappe/frappe/__init__.py", line 492, in msgprint
_raise_exception()
title = None
as_table = False
as_list = False
indicator = 'red'
alert = False
primary_action = None
is_minimizable = False
wide = False
sys = <module 'sys' (built-in)>
out = {'message': 'Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1.', 'title': 'Message', 'indicator': 'red', 'raise_exception': 1}
_strip_html_tags = <functools._lru_cache_wrapper object at 0x7fd86d6f3c10>
_raise_exception = <function msgprint.<locals>._raise_exception at 0x7fd86d5671c0>
inspect = <module 'inspect' from '/usr/local/lib/python3.10/inspect.py'>
msg = 'Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1.'
raise_exception = <class 'frappe.exceptions.ValidationError'>
strip_html_tags = <function strip_html_tags at 0x7fd878557f40>
File "apps/frappe/frappe/__init__.py", line 444, in _raise_exception
raise raise_exception(msg)
inspect = <module 'inspect' from '/usr/local/lib/python3.10/inspect.py'>
msg = 'Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1.'
raise_exception = <class 'frappe.exceptions.ValidationError'>
frappe.exceptions.ValidationError: Debit and Credit not equal for Period Closing Voucher #ACC-PCV-2023-00001. Difference is 1.