Skip to main content

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 ​@Manikandan96 

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.


@Manikandan96 

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