Can I some how see which user/emp input a payment daily?

For users or potential users.
Post Reply
djanash@mac.com
Posts: 59
Joined: Sat Mar 13, 2010 11:11 am

Can I some how see which user/emp input a payment daily?

Post by djanash@mac.com » Fri Mar 14, 2014 3:14 pm

or rather, for the end of day sheet once a day

I know audit trial exist but we keep these on file after we bring it out for reconciliation. Would nice to ave an extra column that showed which person put that payment into the system

Thanks!

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: Can I some how see which user/emp input a payment daily?

Post by tgriswold » Mon Mar 17, 2014 1:05 pm

The audit trail can be queried to get this information. The rows you would be looking for are in the securitylog table, and would have a PermType of 15 (PaymentCreate). The usernum, and the date that audit trail are created are also located in that same table. You cannot currently track an individual payment's audit trail entries like you can with appointments, but you can see how many payments were created on a particular date.

I do not see any queries on our query examples page (http://opendentalsoft.com:1942/ODQueryL ... yList.aspx) that would give you the information you are asking for. However, you are welcome to call in to OpenDental and submit a query request with the assistance of our staff.
Travis Griswold
Open Dental Software
http://www.opendental.com

Post Reply