Add user who last updated order

[jeroenw]

Hi,

I want to create a summary query of a collection of sales orders.

This data comes from the ORDR or RDR1 table.

I want to add which user last updated the sales order.

Can this be added?

[Felipe_Lima]

Hi @jeroenw ,

In documents, the field UserSign represents who created it, whereas UserSign2, who's last updated it. You could use the latter to identify who has made the last change. You just need to join ORDR with OUSR to get the user code/name. See an example below:

SELECT
	DocNum
	, ousr.USER_CODE AS 'Updating User Code'
	, ousr.U_NAME AS 'Updating User Name'
FROM ORDR
	LEFT JOIN OUSR
		ON ordr.UserSign2 = ousr.USERID

 *** If this answer resolves your question, kindly consider marking it as accepted. This helps our community by highlighting useful solutions. Thank you! ***

BR,
Felipe

[williamwachholz]

Hello,

Yes, ou can get this information from the ORDR.UserSign2 field.

There you have the user that has updated the SalesOrder the last time. 

It relates with the OUSR table.

Best regards