Skip to Content
0
Jun 05, 2017 at 01:42 PM

sale Quotation - whose is last update by AND Last Updated Date in SAP B1

126 Views Last edit Jun 08, 2017 at 06:37 AM 2 rev

Hello Sir,

Please help for below Query.

This query is run based on a date range and brings up details of quotes created.

(What I would like is the same report but based on the Last Updated Date and also add a field Last Updated By, it has a posting date which should be the same as date created could we have Last Updated Date as well?)

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