BUG Custom Groups

Using my Dolibarr Financial modules
,
1

Greetings everyone!

I have an error in the “Custom Groups” section

image
image1920×1044 473 KB

Error page link: https://homologacao.lavanderiaumarizal.com.br/compta/resultat/result.php?leftmenu=accountancy_report

I can’t create a formula-based group for calculating groups. The system does not perform the calculation.

I created all the groups, and the following error appears:

It seems to me that it is something related to the database. Probably some insertion in the Bank that is giving the bug.

Here is the error displayed in SQL:

Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.5.101,2.5.102,2.5.103,2.5.109) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.5.101,2.5.102,2.5.103,2.5.109) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.6.101,2.6.102,2.6.103,2.6.104,2.6.105,2.6.106,2.6.107,2.6.108,2.6.109,…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.5.101,2.5.102,2.5.103,2.5.109) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.6.101,2.6.102,2.6.103,2.6.104,2.6.105,2.6.106,2.6.107,2.6.108,2.6.109,…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.7.101,2.7.102,2.7.103) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.5.101,2.5.102,2.5.103,2.5.109) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.6.101,2.6.102,2.6.103,2.6.104,2.6.105,2.6.106,2.6.107,2.6.108,2.6.109,…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.7.101,2.7.102,2.7.103) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.8.101,2.8.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.5.101,2.5.102,2.5.103,2.5.109) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.6.101,2.6.102,2.6.103,2.6.104,2.6.105,2.6.106,2.6.107,2.6.108,2.6.109,…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.7.101,2.7.102,2.7.103) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.8.101,2.8.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.9.101,2.9.102,2.9.103) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.1.101) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 2…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,1.3.101,1.3.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.1.101,2.1.102,2.1.103,2.1.104,2.1.105,2.1.106,2.1.107,2.1.108,2.1.109)…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.2.101,2.2.102,2.2.103,2.2.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.3.101,2.3.102,2.3.103,2.3.105,2.3.106,2.3.107) AND (t.doc_date BETWEEN…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.4.101,2.4.102,2.4.103,2.4.104) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.5.101,2.5.102,2.5.103,2.5.109) AND (t.doc_date BETWEEN ‘2021-01-01 00:…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.6.101,2.6.102,2.6.103,2.6.104,2.6.105,2.6.106,2.6.107,2.6.108,2.6.109,…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.7.101,2.7.102,2.7.103) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.100,2.8.101,2.8.102) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.100,2.9.101,2.9.102,2.9.103) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1
Error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘.104,3.0.100,3.0.101,5.0.100) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ A…’ at line 1

Whenever I add a new “Custom Group” it increases one line in the error.

Can anyone help me fix this please?

My name is Pedro, Brazilian, and I’m using a translator.

Thank you all!

Dolibarr 16.0.0
OS Linux Ubuntu 14.04
Nginx/1.22.0
PHP 7.4.30
MariaDB 5.5.5-10.5.17
Charset utf8_general_ci

2

I also have the same issue.

The debug bar show this error message:

SELECT SUM(t.debit) as debit, SUM(t.credit) as credit, t.numero_compte as accountancy_account FROM rpllx8l_accounting_bookkeeping as t WHERE t.entity = 1 AND t.numero_compte IN (4-000-) AND (t.doc_date BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59') GROUP BY t.numero_compte 0.4

[DB_ERROR_SYNTAX] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘) AND (t.doc_date BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’) GR…’ at line 1

But after removed “Parent Account” from List of accounts in custom group menu, the message gone.

3

This bug happens because the account number is interpreted as a number, which fails at special characters like hyphens - or more than one decimal point. Needs to be treated as a string.

See also issue #22294 on GitHub : Bug: Income and expense balance, By custom groups · Issue #22294 · Dolibarr/dolibarr · GitHub

2 Likes