SELECT
razon_social,
documento,
fecha,
referencia,
descripcion,
SUM ( cantidad ) AS cantidad,
SUM ( precio ) AS precio,
SUM ( metros ) AS metros
FROM
(
SELECT
tercero.f200_razon_social AS razon_social,
fac.f350_id_tipo_docto + '-' + CAST(fac.f350_consec_docto AS VARCHAR) AS documento,
fac.f350_fecha AS fecha,
i.f120_referencia AS referencia,
i.f120_descripcion AS descripcion,
f470_cant_1 AS cantidad,
CASE
WHEN fac.f350_id_tipo_docto IN ( 'CFV' ) THEN
f470_vlr_bruto
WHEN fac.f350_id_tipo_docto IN ( 'CNV' ) THEN
(
f470_vlr_bruto * ( - 1.0 ))
END AS precio,
(
CONVERT ( INT, mvtoentidad.f753_dato_numero ) * 1.0
) / 1000 * f470_cant_1 AS metros
FROM
UnoEE.dbo.t350_co_docto_contable fac
INNER JOIN Unoee.dbo.t200_mm_terceros tercero ON fac.f350_rowid_tercero = tercero.f200_rowid
INNER JOIN UnoEE.dbo.t461_cm_docto_factura_venta ON f350_rowid = f461_rowid_docto
INNER JOIN UnoEE.dbo.t470_cm_movto_invent ON f470_rowid_docto_fact = f350_rowid
INNER JOIN unoee.dbo.t281_co_unidades_negocio unidad_negocio ON UnoEE.dbo.t470_cm_movto_invent.f470_id_un_movto = unidad_negocio.f281_id
INNER JOIN UnoEE.dbo.t121_mc_items_extensiones iext ON iext.f121_rowid = f470_rowid_item_ext
INNER JOIN unoee.dbo.t120_mc_items i ON i.f120_rowid = iext.f121_rowid_item
INNER JOIN unoee.dbo.t125_mc_items_criterios criterios ON i.f120_rowid = criterios.f125_rowid_item AND criterios.f125_id_plan = '020'
INNER JOIN unoee.dbo.t106_mc_criterios_item_mayores mayor1 ON mayor1.f106_id_plan = criterios.f125_id_plan AND mayor1.f106_id = criterios.f125_id_criterio_mayor
INNER JOIN unoee.dbo.t125_mc_items_criterios criterios1 ON i.f120_rowid = criterios1.f125_rowid_item AND criterios1.f125_id_plan = '021' AND criterios1.f125_id_criterio_mayor = '0102'
INNER JOIN unoee.dbo.t106_mc_criterios_item_mayores mayor2 ON mayor2.f106_id_plan = criterios1.f125_id_plan AND mayor2.f106_id = criterios1.f125_id_criterio_mayor
INNER JOIN unoee.dbo.t753_mm_movto_entidad_columna mvtoentidad ON i.f120_rowid_movto_entidad = mvtoentidad.f753_rowid_movto_entidad
WHERE
f350_id_cia = 1
AND f350_ind_estado IN ( 0, 1 )
AND mvtoentidad.f753_rowid_entidad_atributo IN ( '58' )
AND f350_fecha_ts_creacion  BETWEEN '2020-01-01 00:00:00' AND '2020-01-22 23:59:59' AND unidad_negocio.f281_id = '001'
)tbl
GROUP BY
razon_social,
documento,
fecha,
referencia,
descripcion