Query to view which user created Sales Invoice.

[larryenet]

Hello SAP Gurus,

Can someone explain to me how to check which user created Sales Invoice in SAP Business One 9.0?

Thank you.

Larry T.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please run below query,

SELECT T0.[DocNum], T0.[DocDate], T1.[U_NAME] FROM OINV T0  INNER JOIN OUSR T1 ON T0.[UserSign] = T1.[USERID] WHERE T0.[DocNum]  = [%0]

Thanks

[larryenet · Accepted solution]

Thank you very much!!!