Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 08, 2017 at 12:09 PM

    Hi Datta,

    You can use the standard change log option to see the status of the sales order.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2017 at 06:11 PM

    Hi datta,

    Try this:

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

    Hope it helps.

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded