17/11/2021 01:39:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaGeneralDocumentos
ERROR->
Invalid query: ERROR: column suc.abrsuc does not exist
LINE 44: MAX(suc.abrsuc) AS abrsuc,
^
Whole query:
SELECT MAX(doc.codtipdoc) AS codtipdoc,
MAX(doc.numdoc) AS numdoc,
MAX(doc.numcont_doc) AS numcont_doc,
MAX(doc.fecdoc) AS fecdoc,
MAX(doc.estdoccxc) AS estdoccxc,
MAX(doc.formpagdoc) AS formpagdoc,
MAX(ed.denestdoccxc) AS denestdoccxc,
MAX(f.numfact) AS numfact,
MAX(cl.nombre_cliente) AS nombre_cliente,
MAX(tc.tipo_cliente) AS tipo_cliente,
MAX(cl.codcliente) AS codcliente,
MAX(f.id_cliente) AS id_cliente,
COALESCE(sum(canmay),0) as canmay,
COALESCE(sum(candet),0) as candet,
COALESCE(sum(cantidad_detdoc),0) as cantidad_detdoc,
COALESCE(sum(canmay*a.canuni+candet),0) as unidades,
COALESCE(sum(cantidad_detdoc*precio_detdoc),0) as bruto,
COALESCE(sum(desc_detdoc*cantidad_detdoc),0) as desc_detdoc,
COALESCE(sum(cantidad_detdoc*precioneto_detdoc),0) as subtot,
COALESCE(sum(neto_detdoc),0) as neto_detdoc,
COALESCE(sum(iva_detdoc),0) as iva_detdoc,
MAX(doc.baseimp_doc) AS baseimp_doc,
MAX(doc.subtot_doc) AS subtot_doc,
MAX(doc.total_doc) AS total_doc,
MAX(doc.descripdoc) AS descripdoc,
MAX(f.codmon) as codmon,
MAX(f.tascam) as tascam,
MAX(abrmon) as abrmon,
MAX(denmon) as denmon,
MAX(ft.numfact) AS numfact_tercero,
MAX(clt.codcliente) AS numfact_tercero,
MAX(clt.nombre_cliente) AS nombre_cliente_tercero,
MAX(tct.tipo_cliente) AS tipo_cliente_tercero,
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
) AS total_aplicado,
MAX(f.codsuc) AS codsuc,
MAX(f.codcaj) AS codcaj,
MAX(suc.abrsuc) AS abrsuc,
MAX(f.codopeneg) AS codopeneg
FROM cxc_dt_documento d
INNER JOIN cxc_documento doc ON doc.id_doc = d.id_doc
INNER JOIN cxc_estatus_documento ed ON ed.estdoccxc = doc.estdoccxc
INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN cxc_clientes cl ON cl.id_cliente = f.id_cliente
LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = cl.id_tipo_cliente
LEFT JOIN cxc_zonas z ON z.id_zona = cl.id_zona
LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = cl.id_clasif_cliente
LEFT JOIN cxc_vendedores vc ON vc.id_vend = cl.id_vend
LEFT JOIN sigesp_pais pais ON pais.codpai = cl.codpai
LEFT JOIN sigesp_estados e ON e.codpai = cl.codpai AND e.codest = cl.codest
LEFT JOIN sigesp_municipio m ON m.codpai = cl.codpai AND m.codest = cl.codest AND m.codmun = cl.codmun
LEFT JOIN sigesp_parroquia pa ON pa.codpai = cl.codpai AND pa.codest = cl.codest AND pa.codmun = cl.codmun AND pa.codpar = cl.codpar
LEFT JOIN siv_articulo a ON a.codart=d.coddetalle
AND a.codemp = d.codemp
AND d.id_tipodetalle = 'ARTIC'
LEFT JOIN soc_servicios s ON s.codser=d.coddetalle
AND d.id_tipodetalle = 'SERVI'
LEFT JOIN sep_conceptos sepc ON sepc.codconsep=d.coddetalle
AND (d.id_tipodetalle = 'CONNC' OR d.id_tipodetalle = 'CONND')
LEFT JOIN cxc_conceptofac c ON c.codconfac=d.coddetalle
AND d.id_tipodetalle = 'CONCE'
LEFT JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser
LEFT JOIN siv_unidadmedida u ON u.codunimed = d.codunimed
LEFT JOIN siv_producto p ON p.codprod = a.codmil AND p.codemp = a.codemp
LEFT JOIN siv_articuloalmacen aa ON aa.codart = a.codart AND aa.codemp = d.codemp AND aa.codalm = d.codalm
LEFT JOIN siv_almacen al ON al.codalm = aa.codalm AND al.codemp = aa.codemp
LEFT JOIN cxc_causas_devolucion cd ON cd.codcausadev = d.codcausadev
LEFT JOIN cxc_factura ft ON doc.id_fact_tercero = ft.id_fact
LEFT JOIN cxc_clientes clt ON doc.id_cliente_tercero = clt.id_cliente
LEFT JOIN cxc_tipo_clientes tct ON tct.id_tipo_cliente = clt.id_tipo_cliente
WHERE doc.codemp = '0001'
AND doc.estdoccxc != 'C' AND cl.codcliente ILIKE('%000045%') AND f.id_cliente = '95' AND doc.fecdoc BETWEEN '2020-12-01' AND '2021-11-16' AND f.codmon = 'USD' AND f.tipopecont = 'DEV' AND doc.formpagdoc = 'APLI'
GROUP BY doc.id_doc
ORDER BY 1,2
17/11/2021 01:39:58 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaGeneralDocumentos
ERROR->
Invalid query: ERROR: column f.codopeneg does not exist
LINE 45: MAX(f.codopeneg) AS codopeneg
^
HINT: Perhaps you meant to reference the column "f.tipopeneg".
Whole query:
SELECT MAX(doc.codtipdoc) AS codtipdoc,
MAX(doc.numdoc) AS numdoc,
MAX(doc.numcont_doc) AS numcont_doc,
MAX(doc.fecdoc) AS fecdoc,
MAX(doc.estdoccxc) AS estdoccxc,
MAX(doc.formpagdoc) AS formpagdoc,
MAX(ed.denestdoccxc) AS denestdoccxc,
MAX(f.numfact) AS numfact,
MAX(cl.nombre_cliente) AS nombre_cliente,
MAX(tc.tipo_cliente) AS tipo_cliente,
MAX(cl.codcliente) AS codcliente,
MAX(f.id_cliente) AS id_cliente,
COALESCE(sum(canmay),0) as canmay,
COALESCE(sum(candet),0) as candet,
COALESCE(sum(cantidad_detdoc),0) as cantidad_detdoc,
COALESCE(sum(canmay*a.canuni+candet),0) as unidades,
COALESCE(sum(cantidad_detdoc*precio_detdoc),0) as bruto,
COALESCE(sum(desc_detdoc*cantidad_detdoc),0) as desc_detdoc,
COALESCE(sum(cantidad_detdoc*precioneto_detdoc),0) as subtot,
COALESCE(sum(neto_detdoc),0) as neto_detdoc,
COALESCE(sum(iva_detdoc),0) as iva_detdoc,
MAX(doc.baseimp_doc) AS baseimp_doc,
MAX(doc.subtot_doc) AS subtot_doc,
MAX(doc.total_doc) AS total_doc,
MAX(doc.descripdoc) AS descripdoc,
MAX(f.codmon) as codmon,
MAX(f.tascam) as tascam,
MAX(abrmon) as abrmon,
MAX(denmon) as denmon,
MAX(ft.numfact) AS numfact_tercero,
MAX(clt.codcliente) AS numfact_tercero,
MAX(clt.nombre_cliente) AS nombre_cliente_tercero,
MAX(tct.tipo_cliente) AS tipo_cliente_tercero,
( SELECT COALESCE(sum(monmovdoc),0)
FROM cxc_dt_movdoc dmd
WHERE dmd.codtipdoc=doc.codtipdoc
AND dmd.id_doc=doc.id_doc
AND tipdocapl='FACT'
AND estmovdoc!='ANU'
) AS total_aplicado,
MAX(f.codsuc) AS codsuc,
MAX(f.codcaj) AS codcaj,
MAX(suc.sigsuc) AS sigsuc,
MAX(f.codopeneg) AS codopeneg
FROM cxc_dt_documento d
INNER JOIN cxc_documento doc ON doc.id_doc = d.id_doc
INNER JOIN cxc_estatus_documento ed ON ed.estdoccxc = doc.estdoccxc
INNER JOIN cxc_factura f ON doc.id_fact = f.id_fact
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN cxc_clientes cl ON cl.id_cliente = f.id_cliente
LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = cl.id_tipo_cliente
LEFT JOIN cxc_zonas z ON z.id_zona = cl.id_zona
LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = cl.id_clasif_cliente
LEFT JOIN cxc_vendedores vc ON vc.id_vend = cl.id_vend
LEFT JOIN sigesp_pais pais ON pais.codpai = cl.codpai
LEFT JOIN sigesp_estados e ON e.codpai = cl.codpai AND e.codest = cl.codest
LEFT JOIN sigesp_municipio m ON m.codpai = cl.codpai AND m.codest = cl.codest AND m.codmun = cl.codmun
LEFT JOIN sigesp_parroquia pa ON pa.codpai = cl.codpai AND pa.codest = cl.codest AND pa.codmun = cl.codmun AND pa.codpar = cl.codpar
LEFT JOIN siv_articulo a ON a.codart=d.coddetalle
AND a.codemp = d.codemp
AND d.id_tipodetalle = 'ARTIC'
LEFT JOIN soc_servicios s ON s.codser=d.coddetalle
AND d.id_tipodetalle = 'SERVI'
LEFT JOIN sep_conceptos sepc ON sepc.codconsep=d.coddetalle
AND (d.id_tipodetalle = 'CONNC' OR d.id_tipodetalle = 'CONND')
LEFT JOIN cxc_conceptofac c ON c.codconfac=d.coddetalle
AND d.id_tipodetalle = 'CONCE'
LEFT JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser
LEFT JOIN siv_unidadmedida u ON u.codunimed = d.codunimed
LEFT JOIN siv_producto p ON p.codprod = a.codmil AND p.codemp = a.codemp
LEFT JOIN siv_articuloalmacen aa ON aa.codart = a.codart AND aa.codemp = d.codemp AND aa.codalm = d.codalm
LEFT JOIN siv_almacen al ON al.codalm = aa.codalm AND al.codemp = aa.codemp
LEFT JOIN cxc_causas_devolucion cd ON cd.codcausadev = d.codcausadev
LEFT JOIN cxc_factura ft ON doc.id_fact_tercero = ft.id_fact
LEFT JOIN cxc_clientes clt ON doc.id_cliente_tercero = clt.id_cliente
LEFT JOIN cxc_tipo_clientes tct ON tct.id_tipo_cliente = clt.id_tipo_cliente
WHERE doc.codemp = '0001'
AND doc.estdoccxc != 'C' AND cl.codcliente ILIKE('%000045%') AND f.id_cliente = '95' AND doc.fecdoc BETWEEN '2020-12-01' AND '2021-11-16' AND f.codmon = 'USD' AND f.tipopecont = 'DEV' AND doc.formpagdoc = 'APLI'
GROUP BY doc.id_doc
ORDER BY 1,2
17/11/2021 15:52:35 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaAnticipoInvalid query: ERROR: syntax error at or near "("
LINE 14: round((
^
Whole query: SELECT
a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato,
a.scg_cuenta_ant,
a.fecant, a.conant, a.porant, a.codmon,
a.tascam AS tascam,
a.monant,
a.estant,
a.fecanuant,
a.conanuant, a.fecregant, a.usuregant, a.horaregant,
a.nroing, a.codsucres,
a.codcajres, a.resing, a.codmonref, a.tascamref,
cl.*,mo.*,e.*,
suc.sigsuc,suc.nomsuc
round((
a.monant
-
( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
AND estdesc='P'
)
)::numeric,2) AS saldo_ant,
(
SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
AND estdesc='P'
) AS ant_apl
FROM cxc_anticipos a INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
INNER JOIN cxc_estanticipo e ON e.estant = a.estant
LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon
LEFT JOIN cxc_sucursales suc ON suc.codemp = a.codemp
AND suc.codsuc = a.codsucres
LEFT JOIN cxc_cajas caj ON caj.codemp = a.codemp
AND caj.codsuc = a.codsucres
AND caj.codcaj = a.codcajres
WHERE a.estant!='CER'
AND a.estant!='ANU'
AND a.id_cliente = '95' AND a.fecant BETWEEN '01/12/2020' AND '16/11/2021' AND a.codmon = 'USD'
ORDER BY a.id_cliente, a.nroant
17/11/2021 15:53:13 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaAnticipoInvalid query: ERROR: date/time field value out of range: "16/11/2021"
LINE 55: ...te = '95' AND a.fecant BETWEEN '01/12/2020' AND '16/11/202...
^
HINT: Perhaps you need a different "datestyle" setting.
Whole query: SELECT
a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato,
a.scg_cuenta_ant,
a.fecant, a.conant, a.porant, a.codmon,
a.tascam AS tascam,
a.monant,
a.estant,
a.fecanuant,
a.conanuant, a.fecregant, a.usuregant, a.horaregant,
a.nroing, a.codsucres,
a.codcajres, a.resing, a.codmonref, a.tascamref,
cl.*,mo.*,e.*,
suc.sigsuc,suc.nomsuc,
round((
a.monant
-
( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
AND estdesc='P'
)
)::numeric,2) AS saldo_ant,
(
SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
AND estdesc='P'
) AS ant_apl
FROM cxc_anticipos a INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
INNER JOIN cxc_estanticipo e ON e.estant = a.estant
LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon
LEFT JOIN cxc_sucursales suc ON suc.codemp = a.codemp
AND suc.codsuc = a.codsucres
LEFT JOIN cxc_cajas caj ON caj.codemp = a.codemp
AND caj.codsuc = a.codsucres
AND caj.codcaj = a.codcajres
WHERE a.estant!='CER'
AND a.estant!='ANU'
AND a.id_cliente = '95' AND a.fecant BETWEEN '01/12/2020' AND '16/11/2021' AND a.codmon = 'USD'
ORDER BY a.id_cliente, a.nroant