General Ledger Posting Detail Report

You can use the General Ledger Posting Detail report to generate selected general ledger transaction posting details.

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

Prerequisites

You must have: 

  • Common - Reports - View authorization

  • Either Reports - Student Accounts - General Ledger Posting Detail 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 SSRS Export to Excel. under Settings > System > General.

Access Method

Select the Reports tile > expand Student Accounts > select General Ledger Posting Detail.

Procedure to Generate the Report

  1. Specify the data selection criteria.

    Account Number Closed Specify the general ledger account number to show only transactions that are associated with that account number.

    Batch DateClosed Date range that indicates the creation date of the batch. From and To

    CampusesClosed Select the campuses to view transactions released to the General Ledger for the selected campuses only.

    Campus GroupClosed Specify the campus groups to view transactions released to the General Ledger for the campuses that are part of the selected campus groups only.

    GL Batch NumberClosed Specify the General Ledger batch number to view transactions that are associated with that batch number only.

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

    Transaction DateClosed Date range that represents the transaction date. Specify a date range to view released transactions that have transaction date within the specified date range. From and To

    TypesClosed Indicate the type of transactions that have been released to the General Ledger. By default, it is set to Include All. The options are Include All, Credit Memo, Debit Memo, Invoice, Payment, and Revenue. You can select more than one option. Select the appropriate types to view transactions for the selected transaction types only.

  2. 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.

    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.

    If you entered special characters like *, -, !, (, or ) in the report fields, 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 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 selection criteria for the report.
    Delete the selection criteria

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

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

You can also save to a student group. For more information, refer to Create or Update a Student Group Using a Report.

Details for the Report

In the report:

  • Group and grand totals are included for the amount fields

  • General Ledger Posting Details are sorted by Campus, Batch Number, Account Number, and Debit Amount