Custom report for Security Deposit

-Customer Funded Queue-

Customer is requesting a report be built with:

The report would ideally reference an enhancement that is documented in a separate Aha - DESK-I-270.

• Report parameters would be a typical filter, but no date range picker

  • The report needs to pull all accounts where the balance within the Account Deposit Balances screen ('Deposits' button within the ledger) does not equal zero.

  • The report filter would also need look for all accounts and children regardless of enrollment status by default.

• The report would be grouped by account, and then by child within the account according to the dropdown selected on the ledger per DESK-I-270

  • If no child is selected on the dropdown for a particular charge or credit, it would appear in an 'Unknown' section (see mockup)

  • The report would need to display transactions in a format similar to how the Charge Credit Summary - Specific Summary displays transactions (but not broken down by category, grouped instead by child as selected on the ledger:

  • Ledger (read as Primary Payer name, First, Last)

  • Post Date

  • Child Name (First, Last)

  • Amount

• The only transactions that should be on the report are Special Charges and Special Credits. They want all of the security deposit debits are credits represented here

  • They do NOT want Balance Forward on this report. That is the only Special Charge that should not be included.

• It would provide a total for all of the transactions listed by child, and also by the whole account

• The 'Child' column would reference the ledger modification (DESK-I-270). If no child is selected, it would remain blank on the report, and listed under the 'Unknown' section.

  • Child name would be listed as First, Last

• Credit amounts would show within parenthesis

• No page break after each Account Key group, just a continuous list of accounts as shown in the mockup.