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
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
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.
Thank you . I will try that and get back to you.
Done…!! that’s working. Thank you very much.!