Detail Subsidiary Transaction Register

You can use the Detail Subsidiary Transaction Register report to generate detailed information about transactions in the subsidiary register.

If you frequently generate reports with the same selection criteria, you can save the selection criteria under a name. This makes it easier to regenerate the report with the same settings in the future.

It is recommended to:

  • Generate the report in Excel

  • Refine the selection criteria while generating the report

Prerequisites

You must have: 

  • Common - Reports - View authorization

  • Either Reports - Student Accounts - Detail Subsidiary Transaction Register or Student Accounts - All Reports authorization (All Reports provides authorization to view all reports for Student Accounts.) 

To configure the timeout duration for the Export to Excel button, your institution must have configured Export to Excel Timeout in SecondsClosed Enter the Timeout Value in seconds (0-900) for all the SSRS Export to Excel. The timeout duration for PDF export has been extended from 15 minutes. The timeout duration for the SSRS Report Timeout has been extended from 20 minutes. under Settings > System > General.

Access Method

Select the Reports tile > expand Student Accounts > select Detail Subsidiary Transaction Register.

Procedure to Generate the Report

  1. Specify the data selection criteria.

    Bank AccountsClosed The bank account associated with the transaction.

    Bill CodesClosed The bank account associated with the transaction.

    Campus GroupsClosed The campus or campuses to which a person or item is assigned. It is filtered to display the campuses to which you have access. In some cases, it is also used to filter a list to only those items for the campus. In some lists, you can select more than one campus or select All. In lists that display columns, if the column contains more than one campus, you cannot sort or filter on that column.

    CampusesClosed The campus or campuses to which a person or item is assigned. It is filtered to display the campuses to which you have access. In some cases, it is also used to filter a list to only those items for the campus. In some lists, you can select more than one campus or select All. In lists that display columns, if the column contains more than one campus, you cannot sort or filter on that column.

    Check DateClosed The date when the check was issued. From and To

    Check StatusClosed Indicate the status of the check. The options are Include All, Cleared, Sent, Unclaimed, and Void.

    Load Saved CriteriaClosed Select the saved criteria you want to load in the selection criteria fields.

    ProgramsClosed The name of the program. Programs are configured by your institution. Select programs from the list to access transactions for students who are associated with the selected programs only.

    Ref ValueClosed Specify the Ref values to include only revenue transactions that are associated with those Ref values. Separate multiple values with a semi-colon (;).

    Student ID to PrintClosed Indicates whether you want to include the Student ID, Social Security Number, Enrollment Number, or None. Note: The ID is printed for each student selected for the report. Most reports have all three student IDs available to print on the report. The SSN is required on some reports. You must be authorized to view social security numbers (SSNs) and to select SSNs in the list. Reports about leads (prospects) do not have an Enrollment ID. The ID selection is not used for reports that do not list individual students.

    Student StatusesClosed The prospect or student status at your institution is configurable and may differ by school. When you change a student's status, you must confirm the update in a dialog box, and if there are pending tasks from the previous status, another dialog lets you choose which tasks to keep or close as canceled. A student's current status (like Active) depends on their history and activation units; simply entering a Version Start Date does not automatically activate them without proper status progression. Status values help filter student records in lists, processes, and reports. Alumni statuses include "complete" or "graduated."

    SubsidiariesClosed Select subsidiaries to be included in the report, or select the name and code of the subsidiary to which you will post the charge or payment.

    TermsClosed Specifies the term associated with the record. Terms are configured by your institution. The term start date must be before the end date of the award year.

    Transaction TypesClosed Indicate the transaction type. The options are Include All, Credit Memo, Debit Memo, Invoice, and Payment.

    Transaction DateClosed The date when the transaction record was posted. From and To

  2. Take the appropriate action.

    Task Action to Take
    View the report Select the View Report button. Anthology Student displays the generated report.
    Export the report

    1. Select the Export to Excel button. Anthology Student displays the Export Report Data dialog.

    2. Review, specify, or change the following value.

      Export File NameClosed The name of the item (e.g., data set, batch, job, process, task, person, organization, entity, file).

    3. Select the Export button.

    Anthology Student exports the generated report as a.csv file which may be viewed in Excel. In some cases, the exported file will contain additional data not displayed in the report on your screen.

    If you have entered specific characters like *, -, !, (, or ) into the fields of the report, Anthology Student automatically prepends an apostrophe to those field values upon export to Excel or CSV. The apostrophe is added to reduce vulnerability, as these characters are perceived by Excel as an actionable formula. Once the report is exported to Excel, Anthology suggests using find and replace on the characters only if necessary to restore original values.
    Save Student Group

    1. Select the Save Student Group button. Anthology Student displays save student group dialog.

    2. Specify the student group name.

    3. Select the Save button. Anthology Student saves student group.
    Save the selection criteria

    1. Select the Save Criteria button. Anthology Student displays the Save Criteria dialog.

    2. Specify the name to save the criteria.

    3. Select the Save button. Anthology Student saves the selected criteria for the report.
    Delete the selection criteria

    1. Select the Delete Saved Criteria button. Anthology Student displays the confirmation dialog.

    2. Select the Delete button. Anthology Student deletes the selected saved criteria for the report.

Details for the Report

In the report:

  • Detail Subsidiary Transaction Register records are sorted by Campus and Student Name
  • The Summary By Program is displayed on the last page