http://forums.blackbaud.com/forums/62.aspxenCommunityServer 2007 SP2 (Debug Build: 20611.960)http://forums.blackbaud.com/forums/thread/10117.aspxWed, 15 Jun 2005 17:38:50 GMTf90a95a0-00e2-4810-8af8-0bbdde08f853:10117William Falls0http://forums.blackbaud.com/forums/thread/10117.aspxhttp://forums.blackbaud.com/forums/commentrss.aspx?SectionID=62&PostID=10117You can create a query in AP by selecting an invoice query type. Then in criteria click on the Inoice Properties and a list drops down where you can select Added By, Date Added, Import ID, Last Changed By, & System Invoice ID. I don't know if this is what you need or not, but it is as close as I can figure it. Good Luck!http://forums.blackbaud.com/forums/thread/10107.aspxWed, 15 Jun 2005 15:29:30 GMTf90a95a0-00e2-4810-8af8-0bbdde08f853:10107George Barnard0http://forums.blackbaud.com/forums/thread/10107.aspxhttp://forums.blackbaud.com/forums/commentrss.aspx?SectionID=62&PostID=10107Roy, I don't think there is a way to id exactly who approved an invoice. The invoice status field values are either Pending, Approved, Paid, Partially Paid or Deleted. I have tried to isolate this information both in AP and eReqs and have not been successful. Apparently there is no means by which the system can track who made that particular change, only that the record itself was changed. An alternative would be to create an attribute to track that data. While an attribute would be more data entry and somewhat cumbersome, it would serve the purpose. The attribute could be set to be required so each invoice would carry it initially and the value would typically be Pending. Beyond that, the user would have to change the value after they approved the invoice, in effect reducing the value of the internal control. - George Envision For Non-Profits Blackbaud Business Solutions Partner (BSP) [Email Removed]http://forums.blackbaud.com/forums/thread/10086.aspxTue, 14 Jun 2005 20:17:49 GMTf90a95a0-00e2-4810-8af8-0bbdde08f853:10086Roy New0http://forums.blackbaud.com/forums/thread/10086.aspxhttp://forums.blackbaud.com/forums/commentrss.aspx?SectionID=62&PostID=10086Is there a way to create a query to show who approved each invoice for an audit trail?