Query

[Former Member]

hi all..

can anyone help me. i wanna write a query to know who create a marketing document. i know we can track user by change log. but i want to do it using query generator so that i can see all of the documents and its user/creator, when i do query, i can't find any field related to user in the documents, such as ORDR, OINV, ODLN etc..

thanks in advance,

Bruce.

[Former Member · Accepted solution]

Something like this?

SELECT T0.DocNum, T0.CardCode, T0.CardName, T0.DocTotal, T1.U_NAME as 'Created by' FROM ORDR T0 INNER JOIN OUSR T1 ON T0.UserSign = T1.userid

HTH

Juha

[Former Member]

usersign on all docs join ousr to get name