ArticlesCHKLINKS UtilitySummaryThis document describes how to run CHKLINKS, a utility program designed to check the linking of each account in the Escape database in a single fiscal year to another fiscal year. After creating a new fiscal year of accounts each spring, Escape recommends running this utility on a monthly basis to ensure that new accounts that are added have been linked. It will NOT automatically link accounts, but is a tool, used by System Managers to verify that all accounts that should be linked from year to year are linked! This utility should reside in \ESCAPE\UTIL folder and can be run anytime with users in the Escape database. In order to run the utility, you will need rights to the \ESCAPE\UTIL folder. It can be run from the DOS prompt, batch file or icon. Users can be signed in while the utility is running. You should not notice any network speed degradation while this utility is running. It will report progress both on screen and in an error log, that can be viewed with any text editor or printed to the printer. Running CHKLINKSFrom a DOS prompt, change to the \ESCAPE\COMMON directory and type: \ESCAPE\UTIL\CHKLINKS and press ENTER. Your screen will turn black and in the bottom left, you will be prompted for a fiscal year to compare. Since this utility compares one fiscal year to another, you are prompted for a fiscal year that Escape will use to compare to a prior year. So, if you have just created accounts in the Fiscal Year 2005, and want to compare them to the accounts in Fiscal Year 2004, enter 2005 in the prompt. Then press ENTER. If you want to compare general ledger accounts only, enter Y in the prompt. Otherwise, enter N. Then press ENTER. You will see a message that the program is comparing backwards and then forwards. This means for example, that the program compares the accounts in 2005 (the fiscal year you entered in the prompt) to the accounts in 2004 to see if they exist and are linked. Then, it reads through the accounts in 2004 and compares them to the accounts in 2005. The process will start immediately when you press ENTER! CHKLINKS reports its progress on screen. It reports the results in an error log. The error log is called CHKLINKS.ERR and is created in the folder of the fiscal year you specified. So, in our example, it would create an error log in \ESCAPE\2004 folder. Each time you run the utility, it appends to the bottom of the file. So, occasionally you will want to rename or delete it. (123) Escape Unified School District ****************************************************** ChkLinks started running 8/14/04 at 11:20AM for fiscal year 2005 ****************************************************** Comparing Backwards in Fiscal Year 2005 to 2004: 11:20:07 Does not exist in prior Year #01-0000- - - -8095- -0000 Does not exist in prior Year #01-0000- - - -8590- -9910 Does not exist in prior Year #01-0000-0-0000-2100-3101-355-5030 Does not exist in prior Year #01-0000-0-0000-2100-3322-355-5035 Not linked but exists #25-0000- 9791- Comparing Forwards in fiscal Year 2004 to 2005: 11:22:34 Does not exist in Current Year #2431-9110- - - Does not exist in Current Year #2433-9110- - - Does not exist in Current Year #2433-9155- - - Does not exist in Current Year #2433-9160- - - Does not exist in Current Year #2434-4560-2632-9620-13 Does not exist in Current Year #2434-4560-2632-9620-29 Expired Account With Balance #2434-4560-2632-9620-37 ! 6/30/1999 Bal: $-0.11 does not exist in Current Year Does not exist in Current Year #S440-1907-2420-5610-54 Compared Fiscal Year 2005 to 2004: 11:22:43 ****************************************************** CHKLINKS: Finished running 8/14/04 at 11:22AM for fiscal year 2005 ****************************************************** Understanding the CHKLINKS.ERR FileOnce the utility is finished running, check the accounts that are reported with errors:
|
|
