Accounting Dimension error in Payment Entry

I have created sales order as an Accounting Dimension but while making a payment entry, the following error pops up when we click in the sales order feild on payment entry form. No solutions till now.

#paymententry #account #accounting #sales-order

@umair @rmehta any guess to above

@Ambareen

@rohit_w @Tech_Hack_IT @Techone_ERP

@szufisher

at the moment, I can confirm I have same issue on v13.22.1.

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 68, in application
    response = frappe.api.handle()
  File "apps/frappe/frappe/api.py", line 55, in handle
    return frappe.handler.handle()
  File "apps/frappe/frappe/handler.py", line 31, in handle
    data = execute_cmd(cmd)
  File "apps/frappe/frappe/handler.py", line 68, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "apps/frappe/frappe/__init__.py", line 1213, in call
    return fn(*args, **newargs)
  File "apps/frappe/frappe/desk/search.py", line 54, in search_link
    search_widget(doctype, txt.strip(), query, searchfield=searchfield, page_length=page_length, filters=filters, reference_doctype=reference_doctype, ignore_user_permissions=ignore_user_permissions)
  File "apps/frappe/frappe/desk/search.py", line 90, in search_widget
    raise e
  File "apps/frappe/frappe/desk/search.py", line 81, in search_widget
    searchfield, start, page_length, filters, as_dict=as_dict)
  File "apps/frappe/frappe/__init__.py", line 1213, in call
    return fn(*args, **newargs)
  File "apps/frappe/frappe/desk/search.py", line 241, in validate_and_sanitize_search_inputs
    return fn(**kwargs)
  File "apps/erpnext/erpnext/controllers/queries.py", line 577, in get_filtered_dimensions
    output = frappe.get_list(doctype, fields=fields, filters=query_filters, or_filters=or_filters, as_list=1)
  File "apps/frappe/frappe/__init__.py", line 1447, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
  File "apps/frappe/frappe/model/db_query.py", line 107, in execute
    result = self.build_and_run()
  File "apps/frappe/frappe/model/db_query.py", line 124, in build_and_run
    args = self.prepare_args()
  File "apps/frappe/frappe/model/db_query.py", line 152, in prepare_args
    self.build_conditions()
  File "apps/frappe/frappe/model/db_query.py", line 378, in build_conditions
    self.build_filter_conditions(self.or_filters, self.grouped_or_conditions)
  File "apps/frappe/frappe/model/db_query.py", line 398, in build_filter_conditions
    conditions.append(self.prepare_filter_condition(f))
  File "apps/frappe/frappe/model/db_query.py", line 515, in prepare_filter_condition
    value = frappe.db.format_date(f.value)
  File "apps/frappe/frappe/database/database.py", line 892, in format_date
    return getdate(date).strftime("%Y-%m-%d")
  File "apps/frappe/frappe/utils/data.py", line 68, in getdate
    ), title=frappe._('Invalid Date'))
  File "apps/frappe/frappe/__init__.py", line 444, in throw
    msgprint(msg, raise_exception=exc, title=title, indicator='red', is_minimizable=is_minimizable, wide=wide, as_list=as_list)
  File "apps/frappe/frappe/__init__.py", line 423, in msgprint
    _raise_exception()
  File "apps/frappe/frappe/__init__.py", line 378, in _raise_exception
    raise raise_exception(msg)
frappe.exceptions.ValidationError: <b>%%</b>不是有效的日期字符串。

as temporary fix, you can remove transaction_date (comma delimited fields list) from search field via customize form for Sales Order.

1 Like

Thank you :heart:. I will try that and get back to you.

Done…!! that’s working. Thank you very much.!:star_struck: