
Hi Guys,
So I made a query and it is returning what I wanted. But when it asks to input client code it appears Client/Supplier Code. Do you Know How I can resolve this ? As you can see in the picture. It says Code Client/supplier
here is my query:
SET ARITHABORT OFF SET ANSI_WARNINGS OFF /**SELECT FROM OINV T0**/ /**SELECT FROM INV1 T1**/ declare @IDCliente1 as VARCHAR(6) declare @IDCliente2 as VARCHAR(6) declare @DocDateFrom as datetime declare @DocDateTo as datetime set @DocDateFrom = /* T0.DocDueDate */ '[%0]' set @DocDateTo = /* T0.DocDueDate */ '[%1]' Set @IDCliente1 = /* T0.CardCode */ '[%2]' Set @IDCliente2 = /* T0.CardCode */ '[%3]' SELECT 'Fatura de cliente' 'Tipo de Documento',T0.[DocNum] as 'Número' ,T0.[CardCode] as 'ID do Cliente', T0.[CardName] as 'Nome',convert(varchar, T0.[TaxDate], 105) as 'Data do Documento', convert(varchar, T0.[DocDueDate], 105) as 'Data de Vencimento', T0.[DocTotal] as 'Total', T0.[DocCur] FROM OINV T0 LEFT JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry Where T0.[Docstatus]='O' and T0.DocDueDate >= @DocDateFrom and T0.DocDueDate <= @DocDateTo and T0.CardCode >= @IDCliente1 and T0.CardCode <= @IDCliente2 UNION SELECT 'Nota de crédito de cliente',T0.[DocNum],T0.[CardCode], T0.[CardName], convert(varchar, T0.[TaxDate], 105) as 'Data do Documento', convert(varchar, T0.[DocDueDate], 105) ,T0.[DocTotal], T0.[DocCur] FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry Where T0.[Docstatus]='O' and T0.DocDueDate >= @DocDateFrom and T0.DocDueDate <= @DocDateTo and T0.CardCode >= @IDCliente1 and T0.CardCode <= @IDCliente2