I want to find the user who has created the manual suppier invoice. Is there any way to find it through the sql query
Hi
If create ‘posting at entry’ option has been checked in company screen, We can use the voucher type and number from screen GL Voucher rows analysis or Manual voucher and query for the field ‘entered by’. This should give who has created the invoice.
Let me know if this helps.
Hello,
If the invoice was posted, you can see it in GL Voucher Rows Analysis once you make the “Update GL Vouchers”
Regards.
my concern is that
for Example: Some of the users will create the manual supplier invoice and post the invoice
how to find the user id who has created the manual supplier invoice.
If you are using Posting proposal in your company, you can go to manual supplier invoice → select posting proposal button → there is a option called ‘invoice history’. You can find the entire history including who created the invoice.

If you are not using posting proposal, you can find in GL Voucher analysis

hope this helps
Hi,
You can easily turn on history tracking for the new invoices. This would give user ID and other data (such as dates). Insert only, probably don’t want all history including changes. I had to do that for a client back in 2004 who needed same information.
The suggestions above, work under certain situations, whereas history should always work.
Depending on how many invoices you create you may want to remove the history after X days.
Best regards,
Thomas
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.