PRS Technologies Home Page

 Home   Associates   References   Downloads   Elite   Links   Contact Us 

Elite Support, Downloads and Services

Contents
 Our Clients' Favorite Programs   
 Elite Support 
 Migration Info 
 Presentations 
 Month-End Balancing 
 Informix 4GL 
 Korn Scripts for SQL Server 
 Unix/Korn Shell Scripts 
 Informix SQL Scripts for Elite 
 Informix Stored Procedures (SPL) 
 Elite Bugs 
 Misc Info 
 Elite related Links 

Last updated 01/16/2008



.
Our Client's Favorite Programs
These are programs we actually have up and running.
Our clients really appreciate these features.
Why should other firms get all the good stuff!
Favorite End-User Programs
bullet Automatically Post Credits from Scanned Checks
Load Credits from a data file. No more manual Credit Entry! Incredible, but true!
bullet Electronic ACH Payments and Deposits
Perfect for expense reimbursement or just vendor payments. Send notification via E-mail
bullet Positive Pay
Notify your bank of which checks were actually issued. Prevents fraud!
bullet Only show reports on the menu that you have permission to run!
Restrict the Elite Report Tree to display only reports a user is allowed to run -- using *Report Level* security
What a great idea! Why show reports on the Enterprise Reports Menu that you can't run.
bullet Detect Multiple Current Proformas
Prevent billing problem before they happen. Send e-mail notification when detected
This doen't happen often, but when it does, it's always a big problem because you aren't aware of the cause.
bullet Detect Invalid Matter Numbers
With matter number masking, you would think improper matter numbers would be impossible.
Not so! Almost everyone has this problem and doesn't know it. Get alerted via e-mail.
bullet Detect inconsistent 1099 flags
Don't wait until the February rush.
Receive a monthly email alert reporting vendors and vouchers with 1099 flag discrepancies.
bullet Automatically have all your Audit Batches finalized every night
This way you don't end up with a huge number of open audit batches at the end of the month.
bullet Automatically load Foreign Payments as Pre-Costs
Process through Ruesch International   (See more about this)
bullet Be able to quickly create a Top Clients Report
Run by either billings or collections. Indicate the number of clients you want to see on the report.
bullet Buy just *one* Electronic Bill format E-Bill
(like LEDES 1998B, LEDES 2000 cXML, Litigation Advisor/Legal Solutions)

without having to buy the whole expensive package. Our clients really appreciate this option!
bullet Unhappy with the standard Elite conflicts report ?
Several of our clients have contracted for custom conflits hit reports. They are very happy with them
bullet Download/update the OFAC SDN list automatically into Conflicts
Office of Foreign Asset Control (OFAC) - Specially Designated Nationals (SDN)
You can do this manually now, but we set it up to check every night to see if there were any changes
in the last 24 hours and download and update automatically! It's painless.
Favorite System Administration Programs
bullet Have your Hot Spare Elite Backup Server pre-built and ready to turn on.
Copy the database over every night so the backup server is always ready to go. This could be a Virtural machine!
bullet Create a VIRTUAL copy of your Elite Server for testing and development.
With a Virtual Elite server, you can take your Elite "server" home on your laptop
or just use it in-house for local testing of billing templates, programs and trying out new things!
bullet Alert you by e-mail when you are running low on disk space
Tracks disk use over time to allow for projecting historical use.
bullet Split your Elite saved bills directory up into smaller subdirectories
Prevents having too many files in one directory. And still be able to re-print saved bills from Elite.
bullet *Really* clean up your saved reports directory. (Don't just pretend to)
Don't end up with thousands of old saved reports cluttering up your system.
bullet Send you an E-mail when your database backup has failed.
Are you SURE your backup is running successfully. How do you know ?
bullet Elite System Clean-Up and Review
Let us spend a day checking out your system. It's amazing what we have found and fixed by doing this!



Elite Support Services Available
bullet Installation and Support of Elite Enterprise Servers
bullet Elite Telephone Support and Troubleshooting
bullet Elite On-Site Support and Training
bullet Elite On-Site Temporary Billing Personnel
bullet Elite Month-End Balancing Assistance
bullet Elite Bill and Proforma Templates (Standard and Whitehill)
bullet Elite Electronic Bills
bullet Elite Financial Statement Formats
bullet Elite Custom Reports
bullet Elite Custom Time and Cost Load Programs
bullet Elite Merger Automation
bullet Elite General Ledger Re-Number
bullet Elite database purge and cleanup
bullet Elite VBA customization of the Elite Enterprise
bullet Elite WebView - Installation and customization
bullet Elite Business Intelligence and Business Objects programming (BI/BO)
bullet Elite interfacing with Interwoven Worksite (formerly iManage)
Document Management System (DMS)
bullet Informix and SQL Server Database Administration (DBA)    
bullet Unix Systems Administration
bullet Performance Tuning
bullet Load Ruesch foreign payments into Elite   More about this  

Back to top


Elite Downloads


Elite Enterprise Migration Information
File Name
Description
enterprise_migration_preparation.pdf Elite Enterprise Migration Preparation - Instructions to the client (PDF document)
elite_migration_validation_report_listing.xls Which Elite reports to run to validate an Elite migration (Spreadsheet) Note: All batches must be reported and finalized and all audit batches created and finalized prior to running any validation reports.
Product_System_Requirements.2006-02-09.pdf Product System Requirements for Elite Products - as of 02/09/2006

Back to top

Elite Presentations
File Name
Description
LawNet 2004 Crystal and Excel.ppt
LawNet 2004 Excel Example.xls
LawNet 2004 Crystal Report Example.rpt
LawNet 2004 SQL Example
LawNet User Conference 2004 Exporting Data and Creating Financial Reports with Excel and Crystal
Presented at the LawNet Annual User Conference
in Phoenix, Arizona on 08/25/2004
(PowerPoint Presentation, 3.7 Meg)

Back to top

Elite Month-End Balancing
Excel spreadsheets and SQL Scripts used for Month-End Balancing with Elite

Note: these SQL statements were originally written for SQL Server and they were converted to be used with Informix
File Name
Description
me_bal_wkst.xls This excel spreadsheet is based on the one from the 2000 Elite User's Conference and works in conjunction with the Balancing Guide distributed at the conference. It has been slightly enhanced based on our preferences.
ardebit.sql If Elite A/R does not equal A/R G/L Account, this sql will find the potential problem ledger index for a debit ledger code (ie. FEES, HCOST, etc.)
arvsrec1.sql This sql statement will calculate total Elite A/R for use in troubleshooting the Elite A/R Report vs. the Elite A/R Reconciliation discrepancies
arvsrec2.sql This sql will help troubleshoot discrepency between the Elite A/R Report and the Elite A/R Reconciliation
balprob.sql This sql looks for NB time or cost on billable matters in Elite, PB time or cost with non-zero bill amount. This sql also compares the time and cost tables to the Elite ledger table and looks for time/cost records modified or billed in an earlier period than worked.
costclear.sql This SQL compares costs in the current period of Elite to vouchers in the current period. It is possible that the voucher and cost are in different periods, and report as discrepancies here.
Written by PRS Tech for Elite Month End Balancing
fees_mat1.sql This sql statement will identify any discrepancy between fees collected in the Elite ledger table and fees posted to the fee income account

Back to top

Informix 4GL Programs used with Elite
File Name
Description
dupe_cost1.4gl
dupe_cost1.sh

To be used when duplicate costs are mixed in with other costs that are not duplicated. Create a new Elite L2 cost load file that contains only the costs that are not duplicated. Presumably you would delete the original batch and reload the costs from the new L2 cost load file created by this program.

dupe_cost2.4gl
dupe_cost2.sh

Find duplicate costs that have already been included in an Elite proforma. Search out proformas for costs that have been duplicated Create a report by matter billing attorney that Elite billers can use to be on the lookout for duplicated costs.


Back to top

Korn Shell Scripts for SQL Server used with Elite
File Name
Description
crossover.ksh This script identifies occurrences where dollars were collected by a working timekeeper from one office who worked on matters from another office.
This is a good example of running a SQL from a Korn script and passing the SQL using the "here-is" technique, as well as passing a variable to a SQL script, printing from the command line and using temp tables in MS-Transact SQL.

Back to top

Unix Shell Scripts used with Elite
File Name
Description
ck_glpost.ksh Check for glpost records where glpost.gpbatch is null.
This program will determine if any glpost records exist where the gpbatch field has not been successfully updated when the audit batch was finalized.
4ge_watch.sh Monitor progress of all Informix 4ge programs running in Elite
check_frx1.sh Check for Elite/FRX posting errors.
check_mcur_prof.sh Check for multiple current proformas in Elite.
cnt_rpts_by_user.sh Count how many Elite reports each user has in Elite-for-Windows
fix_winoutstat1.sh Delete (or recycle) all Elite reports for a selected user over a certain age that has a NULL filename or where the ascii file pointed to by elite is missing for a specific user id.
fix_winoutstat2.sh Put Unix files not referenced by Elite winoutstat into a RECYCLE bin for all users.
fix_winoutstat3.sh Delete (or recycle) all Elite reports for a selected user over a certain age.
fix_winoutstat4.sh Identify (do NOT delete) Elite winoutstat records that point to missing Unix files or Unix files that have no winoutstat records.
fix_winoutstat5.sh Delete Elite winoutstat records that point to Unix files that do not exist .
get_current_period.sh Get the current Elite accounting period (for use in shell scripts)
get_prior_period.sh Get the prior Elite accounting period (for use in shell scripts)
validate_period.sh Validate the Elite accounting period (for use in shell scripts)
login_disable.sh Disable selected Unix and Elite-for-Windows logins preventing access to Elite
login_enable.sh Enable Unix and Elite-for-Windows logins enabling access to Elite
l2_costview1.sh Review the contents of an Elite L2 cost load file, with total amount, and breakdowns by date, period and location.
rotate_elite_logs.sh Rotate Elite EIS logs - up to 10 versions
S910elite.sh Startup and shutdown Elite EIS deamons
watch_session.sh Monitor progress of a single Informix 4ge session running for Elite

Back to top

Informix SQL Scripts used with Elite
File Name
Description
dupe_costs3.sql A simple SQL script to list (and delete?) duplicate costs in Elite

Back to top

Informix Stored Procedures (SPL) used with Elite
File Name
Description
pr_mattsub.sql A stored procedure used in Elite bill templates to print a summary of Split Billing

Back to top

Elite Bugs
File Name
Description
apage.4gl This bug sometimes caused sqlerror -710 at line 784 when running an Elite A/P Aged report by vendor name.
frxpost.4gl This bug caused G/L budget changes to not correctly update the FRX tables in Elite/FMS.

Back to top

Miscellaneous Information about Elite
File Name
Description
Purge glpost Purging the glpost table in Elite
archive_reports Procedure for permanently archiving Elite reports
check.4ge option F Instructions on running check.4ge option F from the command line in Elite
checktab Instructions on running checktab.4ge from the command line in Elite
tc_erase Instructions on running tc_erase.4ge from the command line in Elite. This program is used to erase Elite time and costs globally, particularly in the case of inadvertent duplicate loads of time and cost files.
Timekeeper Sort Transfer This feature enables you to change the initials and sort levels for a list of Elite timekeepers.
There is also a script used to automate the process.
Security in custom reports This is how to set up security to control access to custom reports in Elite.
Also, here are some notes on setting up custom reports in Elite.

Back to top

Elite Links

bullet Elite Information Systems home page
bullet IBM/Informix home page
bullet Syndet Business Technologies home page and library (the Gerrity brothers)


 Home   Associates   References   Downloads   Elite   Links   Contact Us