Uploaded image for project: 'ui-users'
  1. ui-users
  2. UIU-1961

Create 'Cash drawer reconciliation report' in CSV format

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: TBD
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 6.1.0
    • Labels:
    • Template:
    • Sprint:
      EPAM-Veg Sprint 114, EPAM-Veg Sprint 115
    • Story Points:
      3
    • Development Team:
      Vega

      Description

      Purpose:  Generate Cash drawer reconciliation report in CSV format based on criteria entered by user, and then make the report available for download.  This report is used by staff members who have been assigned a register to cash out their register drawer at the end of their shift.

      SCENARIOS

      Scenario 1

      • Given report criteria saved on Cash drawer reconciliation report modal (see UIU-1959)
      • When Report format = CSV or BOTH and one or more payment fee/fine actions not found for criteria
      • Then display the red "no success toast" with error message:  No items found

      Scenario 2

      • Given report criteria saved on Cash drawer reconciliation report modal (see UIU-1959)
      • When Report format = CSV or BOTH and one or more payment fee/fine actions found for criteria
        * Then...
        ** Generate the Cash drawer reconciliation report per the instructions below (as shown in attached sample Cash-Drawer-Reconciliation-Report-format.xlsx
        ** Make report available for download (as shown in attached screen mock-up 4-cash-drawer-downloaded.png) in the Report format of CSV

         

        INSTRUCTIONS FOR GENERATING REPORT

        Produce the title of the report -
        * Cash Drawer Reconciliation Report for <Service Point>, Source(s) <Source 1, Source 2, Source X> - <Start-date> to <End-date>
        ** Insert Service Point from Cash drawer reconciliation report modal (will only have one)
        ** Insert Source(s) from Cash drawer reconciliation report modal (will have zero to many)
        ** Insert Start date from Cash drawer reconciliation report modal (will have one)
        ** Insert End date from Cash drawer reconciliation report modal (if not provided from modal, use system date)
        ** Examples:
        *** Cash Drawer Reconciliation Report for Main Circ Desk - 3/8/2021 to 3/10/2021
        *** Cash Drawer Reconciliation Report for Main Circ Desk, Source(s) Holly Mistlebauer - 3/8/2021 to 3/10/2021
        *** Cash Drawer Reconciliation Report for Main Circ Desk, Source(s) Holly Mistlebauer, Minnie Mouse, Jane Doe - 3/8/2021 to 3/10/2021

        Produce the columns of the report -
        * Source:  Source from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Payment method:  Payment method (displayed as part of Action) from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Payment amount:  Amount from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Fee/fine owner:  Fee/fine owner from Fee/Fine record (aka Fee/Fine Details upper part)
        * Fee/fine type:  Fee/fine type from Fee/Fine record (aka Fee/Fine Details upper part)
        * Payment date/time:  Action date from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Payment status:  Action from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Transaction information:  Transaction information from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Payment additional staff information:  Additional staff information from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Payment additional patron information:  Additional patron information from Fee/Fine Action record (aka Fee/Fine Details table of "actions")
        * Fee/fine details:  FOLIO internal id for Fee/Fine Details page as a link to that page

        Sort the report by -
        * Source, within Fee/fine owner

        Produce the report totals -
        * Source:  Provide a total of Payment amount and a count by Source, with a grand total for all Sources (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)
        * Payment method:  Provide a total of Payment amount and a count by Payment method, with a grand total for all Payment methods (as shown at bottom of attached report mock-up _Cash-Drawer-Reconciliation-Report-format.xlsx
        _)
      • Fee/fine type:  Provide a total of Payment amount and a count by Fee/fine type, with a grand total for all Fee/fine types (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)
      • Fee/fine owner:  Provide a total of Payment amount and a count by Fee/fine owner, with a grand total for all Fee/fine owners (as shown at bottom of attached report mock-up Cash-Drawer-Reconciliation-Report-format.xlsx)

       

       

       

       

       

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                annamelnyk Anna Melnyk
                Reporter:
                hollyolepm Holly Mistlebauer
                Tester Assignee:
                Holly Mistlebauer Holly Mistlebauer
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases