Printing prepared by user name in reports

Hi all

I want to print prepared by user name in purchase invoice report.

I checked in VendInvoiceJour table and couldnt find the field.

How I can print prepared by user name in all purchase cycle printable documents???

How i can print logined user(current working machine) name for the report??

Regards

hi,

to get the name of the user who printed the report use curuserid() method…

to get the name of the user who created the salesorder set the created by to yes in salestable properties and use the field in the report

to get the name of the user who invocied the salesorder set the created by to yes in vendinvoicejour table properties and use the field in the report

verify, if solution is clear…

Thanks Mr.Chaitanya Kumar

hello,
curuserid(), shows the userId not the user name , if you want to get the user name:
use curuserid() to get the userId , get the user name for InfoUser by select Name from InfoUser where curuserid() == infoUser.Id

good luck