on 2024 Jun 14 1:20 PM
Que tal genios del Sistema, tengo un inconveniente con un reporte, es un reporte de antiguedad de saldos que funciona exvcelente. El inconveniente es al momento de querer agregar un rango de fechas ya que me genera error de "Job de trabajo" o error de sintaxis. Anteriormente no tenia inconveniente con este metodo de rango pero ahora actualizamos al SAP HANA 10 y al parecer cambio el metodo de rangear. Favor si podrian ayudarme.
SELECT
T0."CardCode" AS "Código de Proveedor",
T0."CardName" AS "Nombre de Proveedor",
T1."DocNum" AS "Numero de Documento",
T1."DocDate" AS "Fecha de Documento",
T1."DocDueDate" AS "Fecha de Vencimiento",
T1."NumAtCard" AS "N° de Factura",
T1."DocTotal" AS "Total de Documento",
T1. "PaidToDate" AS "Pagos Realizados",
T1."DocTotal" - T1."PaidToDate" AS "Saldo Pendiente",
DAYS_BETWEEN(T1."DocDueDate", CURRENT_DATE) AS "Días Vencidos",
CASE
WHEN DAYS_BETWEEN(T1."DocDueDate", CURRENT_DATE) <= 30 THEN '0-30 días'
WHEN DAYS_BETWEEN(T1."DocDueDate", CURRENT_DATE) BETWEEN 31 AND 60 THEN '31-60 días'
WHEN DAYS_BETWEEN(T1."DocDueDate", CURRENT_DATE) BETWEEN 61 AND 90 THEN '61-90 días'
ELSE 'Más de 90 días'
END AS "Rango de Antigüedad",
CASE
WHEN T1."GroupNum"= 0 THEN 'Contado'
ELSE 'Credito'
END AS "Contado/Credito"
FROM
ENGINEERING.OCRD AS T0 -- Tabla de proveedores
INNER JOIN ENGINEERING.OPCH AS T1 ON T0."CardCode" = T1."CardCode" -- Facturas de proveedores
WHERE
T0."CardType" = 'S' AND -- Asegurarse de que es un proveedor
T1."DocTotal" - T1."PaidToDate" > 0 -- Solo facturas pendientes de pago
T1.[DocDate] >= '[%0]' -- Rango de fecha
ORDER BY
T0."CardCode", T1."DocDueDate";
Request clarification before answering.
User | Count |
---|---|
12 | |
12 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.