QUERY SAP BUSINESS ONE OPEN DOCUMENTS

[former_member581766]

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

[Johan_H · Accepted solution]

Hi Diogo,

This is normal system behavior. Unfortunately there is nothing you can do to change these input titles.

You are not the first to ask this, and I recommend that you post an idea on the SAP Influence site for B1, or vote for the idea if someone else already posted it.

Regards,

Johan

[kothandaraman_nagarajan]

Hi,

It is not possible use alias SAP B1 field in where condition. This is standard system behavior.

Regards,

Nagarajan