User code log info

[Former Member]

Hi all,

How do i call out / extract out the user log's name into an ORDR table query? I would like to know who are the users who keyed in the Sales Order.

Appreciate your advice.

Thanks.

Harith

[Former Member · Accepted solution]

Try this query:

SELECT T1.U_NAME FROM dbo.ORDR T0 INNER JOIN dbo.OUSR T1 ON T0.UserSign = T1.INTERNAL_K WHERE T0.DocNum = $[$8.0.0\]

Please note, it can only run as a FMS query. Will not run under query manager.

Thanks,

Gordon

[Former Member]

Hi Harith,

Try the query in query generator

Reagrds

Jambulingam.P

[Former Member]

Hi there,

the document owner code does not return me any result.Any other ideas?

Thanks.

Harith

[Former Member]

Hi harith,

Use ORDR->Usersign

SELECT T1.[U_NAME] FROM ORDR T0 INNER JOIN OUSR T1 ON T0.UserSign = T1.INTERNAL_K WHERE T0.[DocNum] = '10'

Regards

Jambulingam.P

[former_member187989]

owner name in sales order.

Edited by: Jeyakanthan A on May 25, 2009 2:36 PM