I tried to install using the pwd.yml docker file with PostgreSQL 13.9/14.6
However after installation and login, I got this error while clicking some modules like CRM, stock, buying.
Error in query:
function if(boolean, numeric, unknown) does not exist
LINE 1: select t2.item_code, t2.item_name,SUM(IF(t1.transaction_date...
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Is there some settings I need to do to let ERPNext fully compatible with PostgreSQL?