Anche a me non visualizza i crediti verso i clienti dopo l'aggiornamento dalla 2.2. alla 2.3.1.
Ho provato a risolvere con i seguenti passaggi:
1) inizializzazione un nuovo database con il programma e copia dei dati tramite dump mysql
2) inizializzazione nuovo database con il programma, creazione di una fattura, poi import con
attivato
In questo caso, l'importo a credito rimaneva quello della singola fattura creata prima di fare l'import.
Riporto il general.log sperando che possa essere d'aiuto... io non vedo nessuna query che calcoli l'importo con dir='uscita'... non vorrei che la query schiantasse...
2018-07-04T18:27:21.220816Z 3219 Connect root@localhost on gest_int using Socket
2018-07-04T18:27:21.221452Z 3219 Query SELECT VERSION()
2018-07-04T18:27:21.221837Z 3219 Query SET SESSION old_passwords = 0
2018-07-04T18:27:21.222040Z 3219 Query SET NAMES 'utf8mb4'
2018-07-04T18:27:21.222131Z 3219 Query SET sql_mode = ''
2018-07-04T18:27:21.222272Z 3219 Query SHOW TABLES LIKE 'updates'
2018-07-04T18:27:21.223742Z 3219 Query SELECT * FROM `updates`
2018-07-04T18:27:21.224420Z 3219 Query SELECT * FROM `updates` WHERE `done` != 1 OR `done` IS NULL ORDER BY `done` DESC, `id` ASC
2018-07-04T18:27:21.224721Z 3219 Query SHOW TABLES LIKE 'zz_modules'
2018-07-04T18:27:21.225116Z 3219 Query SELECT valore, tipo FROM zz_settings WHERE nome='Cifre decimali per importi'
2018-07-04T18:27:21.226239Z 3219 Query SELECT id AS id_utente, idanagrafica, username, (SELECT nome FROM zz_groups WHERE zz_groups.id=zz_users.idgruppo) AS gruppo FROM zz_users WHERE id = '1' AND enabled = 1 LIMIT 1
2018-07-04T18:27:21.242338Z 3219 Query SELECT * FROM `zz_modules` LEFT JOIN (SELECT `idmodule`, `permessi` FROM `zz_permissions` WHERE `idgruppo` = (SELECT `idgruppo` FROM `zz_users` WHERE `id` = '1')) AS `zz_permissions` ON `zz_modules`.`id`=`zz_permissions`.`idmodule` LEFT JOIN (SELECT `idmodule`, `clause`, `position` FROM `zz_group_module` WHERE `idgruppo` = (SELECT `idgruppo` FROM `zz_users` WHERE `id` = '1') AND `enabled` = 1) AS `zz_group_module` ON `zz_modules`.`id`=`zz_group_module`.`idmodule`
2018-07-04T18:27:21.245647Z 3219 Query SELECT * FROM `zz_modules` LEFT JOIN (SELECT `idmodule`, `permessi` FROM `zz_permissions` WHERE `idgruppo`=(SELECT `idgruppo` FROM `zz_users` WHERE `id`='1')) AS `zz_permissions` ON `zz_modules`.`id`=`zz_permissions`.`idmodule` LEFT JOIN (SELECT `idmodule`, `clause` FROM `zz_group_module` WHERE `idgruppo`=(SELECT `idgruppo` FROM `zz_users` WHERE `id`='1')) AS `zz_group_module` ON `zz_modules`.`id`=`zz_group_module`.`idmodule`
2018-07-04T18:27:21.248238Z 3219 Query SELECT valore, tipo FROM zz_settings WHERE nome='Nascondere la barra sinistra di default'
2018-07-04T18:27:21.248727Z 3219 Query SELECT `t0`.`id` AS 't0.id', `t1`.`id` AS 't1.id', `t2`.`id` AS 't2.id' FROM `zz_modules` AS `t0` LEFT JOIN `zz_modules` AS `t1` ON `t1`.`parent` = `t0`.`id` LEFT JOIN `zz_modules` AS `t2` ON `t2`.`parent` = `t1`.`id` WHERE `t0`.`parent` IS NULL ORDER BY `t0`.`order` ASC, `t1`.`order` ASC, `t2`.`order` ASC
2018-07-04T18:27:21.250447Z 3219 Query START TRANSACTION
2018-07-04T18:27:21.250965Z 3219 Query COMMIT
2018-07-04T18:27:21.251241Z 3219 Query SELECT id, location, class FROM zz_widgets WHERE id_module='14' AND ( location='controller_top' ) AND enabled=1 ORDER BY `order` ASC
2018-07-04T18:27:21.251884Z 3219 Query SELECT *, (SELECT name FROM zz_modules WHERE id = zz_widgets.id_module) AS 'module_name' FROM zz_widgets WHERE id='13'
2018-07-04T18:27:21.252384Z 3219 Query SELECT CONCAT_WS(" ", REPLACE(REPLACE(REPLACE(FORMAT(SUM((SELECT SUM(subtotale+iva-sconto) FROM co_righe_documenti WHERE iddocumento=co_documenti.id)+iva_rivalsainps+rivalsainps+bollo-ritenutaacconto), 2), ",", "#"), ".", ","), "#", "."), "€") AS dato FROM co_documenti WHERE idtipodocumento IN(SELECT id FROM co_tipidocumento WHERE dir="entrata") AND data >= "2018-01-01" AND data = '2018-01-01' AND `data` = '2018-01-01' AND `data`
