Hola @Amarcos te dejo esta query por si te sirve de ayuda. Con esta consigues Facturas de Ventas + facturas de abono + Anticipos de clientes .
SELECT
T0.[DocNum], T0.[DocDate], T0.[CreateDate], T0.[CardCode] AS 'Código Cliente', T0.[CardName] AS 'Nombre Cliente', T0.[NumAtCard], T0.[ObjType] AS 'Tipo Factura', T0.[DocTotal]- T0.[VatSum] AS 'Base imponible', T0.[VatSum] AS 'Impuesto', T0.[DocTotal] 'Total Factura', T0.[Comments]
FROM OINV T0 WHERE T0.[CANCELED] ='N'
UNION ALL
SELECT
T0.[DocNum], T0.[DocDate], T0.[CreateDate], T0.[CardCode] AS 'Código Cliente', T0.[CardName] AS 'Nombre Cliente', T0.[NumAtCard], T0.[ObjType] AS 'Tipo Factura', T0.[DocTotal] *-1 - T0.[VatSum] * -1 AS 'Base imponible', T0.[VatSum] * -1 AS 'Impuesto', T0.[DocTotal] * -1 AS 'Total Factura', T0.[Comments]
FROM ORIN T0 WHERE T0.[CANCELED] ='N'
UNION ALL
SELECT
T0.[DocNum], T0.[DocDate], T0.[CreateDate], T0.[CardCode] AS 'Código Cliente', T0.[CardName] AS 'Nombre Cliente', T0.[NumAtCard], T0.[ObjType] AS 'Tipo Factura', T0.[DocTotal] - T0.[VatSum] AS 'Base imponible', T0.[VatSum] AS 'Impuesto', T0.[DocTotal] AS 'Total Factura', T0.[Comments]
FROM ODPI T0 WHERE T0.[CANCELED] ='N'