This report is produced when Daily Adjustments is selected from the Reports drop-down list. The report provides a summation, by loan and ledger account, of all financial adjustment transactions that were applied on a specified transaction date. For each transaction, the detail lines indicate the total amount of the Debit or Credit, as well as the type of adjustment performed. The report output is grouped by SSN.
When Daily Adjustments is selected, the top portion of the Reports screen is replaced with a parameter entry window as shown in the following example:
The user should enter the desired Transaction Date and the desired Adjustment type, and then click the Submit button to generate the report. If a date value is not entered, or an invalid date is entered, the following error message will be displayed:
The following is a sample Daily Activity Summary report:
The data elements which comprise the Daily Adjustments report are
described in the following table:
|
Column Name |
Description |
|
Ledger |
The ledger account for the financial transaction. |
|
DB/CR |
Debit or Credit indicator (D or C). |
|
Loan Name |
This is the loan name comprised of Loan Name and Loan Sub Name |
|
Campus |
Campus that the loan is assigned to. |
|
SSN |
Borrower's social security number. |
|
Adj Type |
The type of adjustment displayed (ADJ, NSF, REV). |
|
Debit Amount |
The amount debited in the transaction. |
|
Credit Amount |
The amount debited in the transaction. |
|
Net Amount |
The net amount between the Debit and the Credit. |
This report retrieves all Ledger data (and associated Campus, Loan and Customer information) from the CLM database that meets the following conditions:
The ledger record transaction date matches on the supplied Transaction Date parameter.
The ledger record transaction type matches the type selected.
A separate report detail line is created for each ledger account. The detail lines are grouped by SSN and by Loan.