0
Loading...
Hola Rurangwa Schadrack ,
Anteriormente me enfrenté al mismo problema en mi consulta, pero se solucionó agregando el Grupo y Resumen en el Informe Crystal:
SELECT T0.[DocNum] PaymentNo, T0.[DocDate] PaymentDate, T0.[CardCode], T0.[CardName], T1.[BfDcntSum] PaymentTot, T2.[DocNum] InvNo, T3.[SlpName],T2.[U_Branch], T2.[DocTotal] InvTot, T2.[DiscSum] TotDiscount, T4.[AcctName] InvAcct, T2.[DocDate] InvDate FROM ORCT T0 INNER JOIN RCT2 T1 ON T0.[DocEntry] = T1.[DocNum] Left Outer Join OINV T2 ON T1.[DocEntry] =T2.[DocEntry] And T0.[CardCode] =T2.[CardCode] INNER JOIN OSLP T3 ON T2.[SlpCode] = T3.[SlpCode] INNER JOIN OACT T4 ON T2.[CtlAccount]= T4.[AcctCode] WHERE T2.[CANCELED] ='N' And T0.[Canceled] ='N'Gracias.
Respondido el 15/04/2024
LUCIANO RIOJA GHIOTTO
Se unió el 13/07/2019
