Transcript Slide 1

Contact Information:
Laurie Jones
Towson University
Assistant Director of
Systems and Technology/Bursar’s Office
Students Financials Lead
410-704-3692
[email protected]
Contact Information:
Laurie Jones
Towson University
Assistant Director of
Systems and Technology/Bursar’s Office
Students Financials Lead
410-704-3692
[email protected]
Customer Account
Why?
 Modified to reduce the level of drill down.
 Modified to place pertinent information on initial page to expedite
research effort.
 Modified to provide instantaneous balance of specific items.
 Modified to have a clear picture of all term activity at a glance.
(Billing date, Due date, Payment ID, Item Type, Net total and Item Balance)
 Modified to provide an Overall Account Balance less Anticipated Aid.
Blue Prints for Development
 Not just Debits and Credits.
 Based on Line Action of the Process
 QCK, TUI = Quick Post and Tuition Calc
 GRP = Group Post
 CRV = Charge Reversal
 WRO = Write Off
 TPP = Third Party
How do you use…. Header Information
Anticipated Aid with View Anticipated Aid Link
How do you use….
Header Information
Detail Information …
How are Transactions Sorted
 Most Recent Term First
 Effective Date in
ascending order
 Item Type Number
Item and Item Type
Payment ID
Easy way to identify
Charge Items versus
Payment Items
Easy way to track the
order payments were
made.
Easy identification of
where swapping may
have occurred.
Easy identification of
what Payment ID is
unapplied.
Easy identification of
what payment paid what
charge at the drill down
level.
Billing and Due Date Information
Charge Items
 Billed
 Unbilled
Billing and Due Date Information
 Payment Items
 No Billing and Due
Date displayed at this
level.
Line Total
Net of all transactions for an Item Type.
Item Balance
 The Item Balance
represents the unpaid
balance on charge
items and the
unapplied credit on
payment items.
 Expedites the
researching effort in
identifying what is still
outstanding.
 The amounts in this
column added together
will result in the
Amount Total.
Number of Transactions
If a Number appears under the Nbr of Trns
column this means:
There is more
than one
transaction
associated with that
item type for a
particular term.
The Number
represents how
many transaction
lines make up that
overall total.
Click on Item Detail
Item Details
What information does this link provide to the user?
 Charge Items
Displays what payments paid this charge.
Provides information about the transaction line.
Payment Items
Payment Line Details
Displays what charges this payment paid.
Provides information about the payment transaction.
Multiple Transactions
Displays the detail of each transaction.
Class Fee Charges
Associates the Class ID to the class fee
Bye-Bye Unapplieds
 Item Balance
 Unapplied Payments
 Outstanding Balance
 Amount Total
Why move UNAPPLIED PAYMENTS ?
 Accounts Receivable and Unapplied reports were
inflated.
 Trouble writing off charges for collections.
 Eliminate the manual effort of removing and reapplying
the payment.
 Went out on the ListServe for help and everyone was
having issues.
How can you find your Unapplied Payments?
Run Query
Use Item_Line_SF,
Item_SF, and
Account_Tot_Vw
tables
Can break it down by
Item Type Codes
Look for the Item
Balance to be less
than 0
Look for Item Term
not to be greater than
a specified term.
Look for Item
Balance not to be
equal to Account
Balance
Run Query and these results are displayed …
Payment ID
Item Types
Item Type Charge Priority
Charge Priority Rule that is attached to FA_ALL
Current Term
Prior Term
Prior Year
Future Term
Run Query using Item_SF Table for a specific ID.
Results show the Charge Priority rule that was
attached to the Payment at the Transaction Level.
How do you change the Charge Priority Rule at the Transaction Level?
Enter ID
Enter Payment ID Nbr
Select Search
Information that appears relating to Payment ID
 ID
 Payment ID Nbr
 Item Type
 Payment Amount
Term
Charge Priority
attached to the
payment
 Priority of Payment
Application
Change Charge Priority Rule to SF_UNAPL
Run the Payment Applier for One ID
Enter Student ID
Fix more than One ID
Click Run
Payment ID #2 has now been fully applied.
Item Balance = 0.00
Details for Payment ID #2
Item Effective
Date
Verify that the Charge Priority Rule has
changed at the Transaction Level
Easy as 1…2…3
Payment ID #3
Pull up information for Payment ID
Enter ID
Enter Payment ID Nbr
Change Charge Priority from
…to SF_UNAPL
Run the Payment Applier for One ID
Click Run
All Payments are fully applied.
Charges have been fully paid except for $20.
Amount Total of $20 now matches the Outstanding
Amount Due in the Item Balance Column.
Bye-Bye Unapplieds
Contact Information:
Laurie Jones
Towson University
Assistant Director of
Systems and Technology/Bursar’s Office
Students Financials Lead
410-704-3692
[email protected]