Reference Documents
ACL QUICK REFERENCE SHEET: This is an excellent reference document outlining many of the commands, syntax requirements and common functions. This is highly recommended for beginners and intermittent users. Quick Reference Sheet.pdf
ACL SAS 99 TESTING GUIDE: This is a listing of tests for 'Testing Journal Entries for Potential Compliance Issues'. ACL SAS 99 Testing.pdf
PRINT FILE DEFINITION GUIDE: This is a guide detailing how to define print image or report files. The same methodology applies to PDF files. The guide is a couple versions old but the instructions have not changed. Print File Definition.pdf
ADVANCED USE OF SUMMARIZE: This is a document detailing the advanced use of summarize. Advanced Use of Summarize.pdf
NETWORK HELP ISSUE: This is the instruction to fix the ACL Network Edition unreachable help issue where the help documentation is prevented from appearing in the ACL Network Edition by a Microsoft security patch. The instruction is a pdf of an email from ACL Tech Support that explains the resolution. Network Help Fix.pdf
DUAL MONITOR DISAPPEARING TABLE LAYOUT: This bug exists on Dell laptops when the user normally uses two monitors in an extended desktop setup. The subsequent change to a single monitor leaves the table layout stuck on the desktop of the non-existent extended monitor. The key to fixing it can be found in this image which displays the registry key which can be deleted triggering the automated repair.
ENABLE MOUSE SCROLL WHEEL IN VIEWING PANE: Install the free Flywheel mouse utility to enable the scroll wheel in the viewing pane of ACL. The utility is free and comes with the registration code for use. Download using this link.
SECURING YOUR SCRIPTS: This clip from the knowledge base provides instruction on how to secure your scripts in a shared environment. This is especially useful when you are setting up a project for users and prefer to minimize the opportunity for corruption of the scripting. Once configured, you will find the scripts available under the 'Applications' menu. The instruction is located in this JPG image.
TRANSACTIONAL ACL: This little hack allows you to update an ACL table which is not something ACL normally allows. What we do is re-develop the data source file with the updates and link the existing table layout to the new updated data. Presto, table update! The instruction is a zipped project file with the methodology in a script labeled "_Run_Me" and it and is located in this ZIP file.
