Issue/Request:
Would like a script to view all paid expense reports for a specific date range
Resolution:
Run SQL script to get the desired report.
NOTE: The text in red will need to be changed to the desired date.
SELECT ExpenseReports.ShortReportID, ExpenseItems.Payee, ExpenseItems.Description, ExpenseItems.Amount, ExpenseItems.Miles, ExpenseItems.GLAccountNumber,
a.FirstName + ' ' + a.LastName AS Submitter, ExpenseReports.BeginDate, ExpenseReports.EndDate, b.FirstName + ' ' + b.LastName AS Approver,
c.FirstName + ' ' + c.LastName as Payer
FROM ExpenseItems INNER JOIN
ExpenseReports ON ExpenseItems.ReportID = ExpenseReports.ReportID INNER JOIN
Production_Portal_PortalFx.dbo.PWUser AS a ON ExpenseReports.UserID = a.UserID INNER JOIN
Production_Portal_PortalFx.dbo.PWUser AS b ON ExpenseReports.ApprovalManagerUserID = b.UserID INNER JOIN
AuditTrail ON ExpenseItems.ReportID = AuditTrail.ReportId
INNER JOIN
Production_Portal_PortalFx.dbo.PWUser AS c ON AuditTrail.PerformedBy = c.UserID
WHERE (ExpenseReports.BeginDate > '2014-01-01') and cast(audittrail.Description as varchar(50)) like 'Paid%'
ORDER BY ExpenseReports.ShortReportID
Comments
0 comments
Please sign in to leave a comment.