Skip to Content
0
Jun 14, 2017 at 01:48 PM

How to run this query on in sap business one?

203 Views Last edit Aug 22, 2017 at 12:19 PM 2 rev

Hi Team,

How to run this query when using parameter {using the last updated filed rather than the created by field } ?

SELECT T1.[U_NAME]'Created BY', T0.[DocNum], T0.[DocDate], T0.[Cardname]'Customer Name', T2.[SlpName], T0.[DocTotal], T0.[GrosProfit],T0.comments FROM OQUT T0 INNER JOIN OUSR T1 ON T0.[UserSign] = T1.[USERID] INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode] WHERE T0.[DocDate] between [%0] and [%1] Order by T1.u_name ,T0.docdate