Investeam

select
i.documentno no_factura,
i.dateinvoiced::date as fecha_factura,
bp.name as proveedor,
i.docstatus,
i.withholdingno no_retencion,
a.SRI_AuthorizationCode
from c_invoice i
inner join c_bpartner bp on bp.c_bpartner_id = i.c_bpartner_id
inner join SRI_Authorization a on a.SRI_Authorization_ID=i.SRI_Authorization_ID and a.SRI_AuthorizationDate notnull
where i.docstatus not in ('CO')
and i.issotrx='N'
and not exists (select 1 from c_invoice ic
where ic.issotrx='N'
and ic.docstatus in ('CO')
and ic.withholdingno=i.withholdingno)
and i.dateinvoiced::date>= '2021-01-01'
order by 5