lagoma619 escribió:Buenas tardes, adjunto comparto SQL que sirve para insertar el PUC para Colombia.
En este el modelo de cuentas es PUCCOL
Versión Dolibarr 10.0.1
me sale el siguiente error:
Import has been successfully finished, 1 query executed. (PUC_dolibarr.sql)
Error
SQL query:
INSERT INTO `llxav_accounting_account` (`rowid`,`entity`,`datec`,`tms`,`fk_pcg_version`,`pcg_type`,`pcg_subtype`,`account_number`,`account_parent`,`label`,`fk_accounting_category`,`fk_user_author`,`fk_user_modif`,`active`,`import_key`,`extraparams`) VALUES
(1,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','110505','4','CAJA EFECTIVO',0,1,NULL,1,NULL,NULL),
(2,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','1','2','ACTIVO',0,1,NULL,1,NULL,NULL),
(3,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','11','2','DISPONIBLE',0,1,NULL,1,NULL,NULL),
(4,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','1105','3','CAJA',0,1,NULL,1,NULL,NULL),
(5,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','110510','4','CAJAS MENORES',0,1,NULL,1,NULL,NULL),
(6,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','110515','4','MONEDA EXTRANJERA',0,1,NULL,1,NULL,NULL),
(7,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','1110','3','BANCOS',0,1,NULL,1,NULL,NULL),
(8,1,NULL,NULL,'PUCCOL','XXXXXX','XXXXXX','111005','7','MONEDA NACIONAL',0,1,NULL,1,NULL,NULL),
(9,1,NULL,NULL,[...]
MySQL said: Documentation
#1146 - Table 'f1hdfst_db1.llxav_accounting_account' doesn't exist