Skip to Content
0

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

Jun 05, 2017 at 01:42 PM

49

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Balaji Selvaraj Jun 08, 2017 at 12:09 PM
0

Hi Datta,

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

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
DIEGO LOTHER Jun 08, 2017 at 06:11 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded