Hello i am facing this issues when i try to access query report on accounting.
This for example when i am trying to access balance sheet.
I have some knowledge about SQL Query, So I assume the query is broken because there should be space on “andcoalesce”. What i mean is, instead of “andcoalesce” it should be “and coalesce”.
FYI, my app is on frappe cloud, so im not sure how to edit and fix that broken query.
I already did try bench migrate but the issue persist.
I’m experiencing the same issue. I’ve reported it as a bug on GitHub: SQL Syntax Error in Financial Statements (v16.6.1): Missing space in 'andcoalesce' for user permission filters · Issue #52913 · frappe/erpnext · GitHub
Workaround: Remove the Company User Permission for the affected user. As long as the user has the “Accounts Manager” role, they’ll still have full access to accounting reports and can edit accounts without restriction.
thanks for reply @Dje i did that workaround too by myself after exploring quite a bit.
okay so no real solution for now, might be just waiting for the new update
