I am running version V5.5.0 and I recently figured out how to get my unit prices to accept more than three decimal places. The problem now is that when I try and save a document (in this case a Purchase Order), I get the following error…“Could not find Price List Currency: USD” I have been searching all over and can see that USD is one of the choices for currency, but I can’t figure out how to resolve the error.
I don’t think this is related to the decimal place issue.
Did you accidentally add an empty space? Can you share a screenshot?
Hello!
Thanks for your reply. I don’t think I included an empty space. I can check it tonight.
Attached is a couple of screen shots.
Thanks for your help!
KEVIN WEBB
President
logo orange
Bailey Products, Inc.
888-778-4094 ext. 800
949-338-8287(mobile)
mailto:kevin.webb@baileyproducts.com kevin.webb@baileyproducts.com
http://www.baileyproducts.com www.baileyproducts.com
CONNECTORS - RELAYS - SWITCHES
Your screenshots did not come through, can you share via a service like imgur?
KEVIN WEBB
President
logo orange
Bailey Products, Inc.
888-778-4094 ext. 800
949-338-8287(mobile)
mailto:kevin.webb@baileyproducts.com kevin.webb@baileyproducts.com
http://www.baileyproducts.com www.baileyproducts.com
CONNECTORS - RELAYS - SWITCHES
I just received this error message when trying to make sure that there were no spaces before or after “USD” in the Price List.
Traceback (innermost last):
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/app.py”, line 51, in application
response = frappe.handler.handle()
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/handler.py”, line 69, in handle
execute_cmd(cmd)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/handler.py”, line 92, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/init.py”, line 751, in call
return fn(*args, **newargs)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/desk/search.py”, line 13, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/desk/search.py”, line 87, in search_widget
as_list=True)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/desk/reportview.py”, line 17, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/model/db_query.py”, line 50, in execute
return self.build_and_run()
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/model/db_query.py”, line 53, in build_and_run
args = self.prepare_args()
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/model/db_query.py”, line 67, in prepare_args
self.remove_user_tags()
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/model/db_query.py”, line 160, in remove_user_tags
columns = frappe.db.get_table_columns(self.doctype)
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/database.py”, line 730, in get_table_columns
return [r[0] for r in self.sql(“DESC tab%s” % doctype)]
File “/home/frappe/press/benches/1508041321/apps/frappe/frappe/database.py”, line 146, in sql
self._cursor.execute(query)
File “/home/frappe/press/benches/1508041321/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/press/benches/1508041321/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1146, “Table ‘IemHkFCp0wUX9s2N.tabcurrency’ doesn’t exist”)
KEVIN WEBB
President
logo orange
Bailey Products, Inc.
888-778-4094 ext. 800
949-338-8287(mobile)
mailto:kevin.webb@baileyproducts.com kevin.webb@baileyproducts.com
http://www.baileyproducts.com www.baileyproducts.com
CONNECTORS - RELAYS - SWITCHES
solved…i reset most of the forms back to the original setting and then started over and it solved the problem.