Detail Transaction Register

You can use the Detail Transaction Register report to generate detailed information about student ledger card transactions.

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

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 Transaction Register or Student Accounts - All Reports authorization (All Reports provides authorization to view all reports for Student Accounts.) 

If you selected the SSN option in Student ID to PrintClosed Specifies the ID that is printed. The values are Student Number, SSN, Enrollment Number, and None. and want Anthology Student to display the SSN details, your institution must have selected Allow reporting access to Social Security NumberClosed Select the check box if you want the staff member to view, print, and export social security numbers (SSNs) for all reports from the Reports tile and when they export lists that contain columns with the social security number. The social security number will be a selectable option from the Student ID to Print drop-down list on the Report Selection Information page, will appear on the selected report, and will be available for export. This feature applies to custom reports which use Anthology Student stored procedures. If the SSN is a specified field on the report and the staff member or staff group does not have permission, the phrase "SSN Blocked" is printed on the report instead of the social security number. The SSN is also not displayed for export. on the Staff page. (Select the Settings tile > expand System > select Staff > select the New button and specify the general information or select an existing staff member in the list > select the Specialized Permissions tile.).

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. under Settings > System > General.

Access Method

Select the Reports tile > expand Student Accounts > select Detail 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 Select group(s) of campuses for which you would like to view student ledger transactions.

    CampusesClosed Select campuses for which you would like to view student ledger transactions.

    Check Cleared DateClosed The date when the check was cleared for payment. From and To

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

    Included Applied PaymentsClosed Indicate whether you want to include applied payments. If you set Yes, the system populates a sub report. The sub report lists the charges that have been applied to the payment. For example, a payment of DIR SUB $1000 has been applied where $200 has been applied against Tuition, $400 against BOOK, and the remaining $400 against Technology fees.

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

    ProgramsClosed The name of the program. Programs are configured by your institution. Select program(s) from the list to see 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. Multiple values must be separated by a semi-colon (;).

    ReferenceClosed Text matching operator for the reference value.

    Student ID to PrintClosed Specifies the ID that is printed. The values are Student Number, Enrollment Number, and None.

    Student StatusesClosed Select statuses to gather only transactions for students who are associated with the selected statuses.

    TermsClosed Select the terms to gather only transactions that are associated with those terms.

    Trans 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

    Tuition Discount PoliciesClosed The name and code of the tuition discount policy.

  1. Take the appropriate action.

    Task Action to Take
    View the report

    1.  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 box.

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

    Export File NameClosed The name of the exported 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.

    Note: 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 box.

    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 save criteria dialog box.

    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 delete confirmation dialog box.

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

Details for the Report

In the report:

  • Detail Transaction Registers are sorted by Campus and Student Name

  • The total of each selected campus is displayed on the last page of each campus

  • The total of all campuses is displayed on the last page