casa icon indicating copy to clipboard operation
casa copied to clipboard

Add Description, Amount, Expense Type, and Reimbursement Complete Columns to Mileage Report Export

Open DirkCionci opened this issue 4 years ago • 4 comments

What type(s) of user does this feature affect?

  • all casa admins

Description As an Admin, I would like the ability to export all reimbursement requests so that all of the data is on one spreadsheet for end of year audits.

Screenshots of current behavior, if any
Download current report here:

  • https://casa-qa.herokuapp.com/reports
  • Current column order on Mileage Report
    • Contact Types
    • Occurred At
    • Miles Driven
    • Casa Case Number
    • Creator Name

How should it work

  • Update name to Reimbursement Report
  • Reimbursement Report Order
    • Contact Types
    • Occurred At
    • Miles Driven updated to Description
      • Miles Driven
      • Describe other expense will be displayed in this column
    • Expense Type
    • Amount
    • Reimbursement Complete
    • Casa Case Number
    • Creator Name

Acceptance Criteria

  • CSV export includes above columns
  • CSV behaves as expected

QA Login Details:
Link to QA site

Login Emails:

password for all users: 12345678

Questions? Join Slack!

We highly recommend that you join us in slack https://rubyforgood.herokuapp.com/ #casa channel to ask questions quickly and hear about office hours (currently Wednesday 6-8pm Pacific), stakeholder news, and upcoming new issues.

DirkCionci avatar Oct 14 '21 15:10 DirkCionci

can I work on this issue?

nikhilbhatt avatar Oct 15 '21 08:10 nikhilbhatt

This issue has been inactive for 250 hours (10.42 days) and will be automatically unassigned after 110 more hours (4.58 days).

github-actions[bot] avatar Oct 26 '21 00:10 github-actions[bot]

This issue has been inactive for 370 hours (15.42 days) and is past the limit of 360 hours (15.00 days) so is being unassigned.

github-actions[bot] avatar Oct 31 '21 00:10 github-actions[bot]

Hello!

There are no "expense type" anywhere in the code, in fact, its column in the "Reimbursement Queue" is hardcoded to be always empty, same for the "description" column. The "amount" column from the reimbursement uses the same value from "miles driven". So, the only new column here would be "Reimbursement Complete". Is this correct or am I missing something?

cc @FireLemons @compwron

marmitoTH avatar Jun 10 '22 14:06 marmitoTH

Alternately, just leave out the requests that have been fulfilled!! Screen Shot 2022-09-09 at 11 15 42 AM

compwron avatar Sep 09 '22 18:09 compwron