Hi,
We’re having some inconvenients with bank reconciliation tool.
First, it doesn’t work if you’re importing with goggle sheet. It recognizes the field, but doesn’t import the file.
And this is all.
Error log:
Traceback (most recent call last):
File “/home/diamo/Frappe/apps/frappe/frappe/utils/background_jobs.py”, line 100, in execute_job
method(**kwargs)
File “/home/diamo/Frappe/apps/erpnext/erpnext/accounts/doctype/bank_statement_import/bank_statement_import.py”, line 100, in start_import
import_file = ImportFile(“Bank Transaction”, file = import_file_path, import_type=“Insert New Records”)
File “/home/diamo/Frappe/apps/frappe/frappe/core/doctype/data_import/importer.py”, line 331, in init
frappe.throw(_(“Invalid template file for import”))
File “/home/diamo/Frappe/apps/frappe/frappe/init.py”, line 433, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’, is_minimizable=is_minimizable, wide=wide, as_list=as_list)
File “/home/diamo/Frappe/apps/frappe/frappe/init.py”, line 412, in msgprint
_raise_exception()
File “/home/diamo/Frappe/apps/frappe/frappe/init.py”, line 366, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.ValidationError: Invalid template file for import
It’s strange because model template have been downloaded from the ERP. The only way that it works is importing files from the device. Both images are exactly the same, but the difference is that from my device it works and from google sheet doesn’t.
After that,
The statement from my device has been successfully imported, but I couldn’t find the way to do the reconciliation. The only option I have is “go to transactions list” button, that shows this
Captura de Pantalla 2021-04-27 a la(s) 12.54.58
So, I’ve imported the statement, but I can’t find the way to reconcile automatically those. I can do it individually, but it it’s practical if you have a lot of transactions.
Is anybody using this? Could you explain me how they do, and if I’m doing something wrong or if it’s a bug?
Thanks in advance!