Is there a way to create a query to show who approved each invoice for an audit trail?

Roy, 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]

You 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!