Do You Have a Reports “Monster” in Your Sage 300 CRE?
Powerful Reporting Inside Sage 300 CRE
Among the most important aspects of having powerful accounting software like Sage 300 Construction and Real Estate are the reporting capabilities.
The ability to store huge quantities of diverse data is significant, but the true value is in the ability to provide timely, accurate and often critical information to decision-makers at every level throughout the organization to support them in their work. To this end, Sage 300 CRE comes installed with literally hundreds of reports that fit most of the management and financial reporting needs of construction-type operations. Many companies, however, have preferential reporting needs and end up adding a myriad of custom reports to the host of canned reports already present in their reports menus.
Over time, as users come and go, reporting needs change, and custom reports accumulate, the beginnings of a Reports Monster can emerge!
You can tell you have a Reports Monster living in your system when you spend precious time searching for the right report, don’t know which reports in your system are custom and which are canned reports, or receive error messages when you try to launch certain reports.
Here are some tips for keeping a Reports Monster at bay:
- Don’t mix custom reports with canned reports in the reports menus. When adding custom reports to a reports menu, use a menu group that is separate from the menu groups installed with the system. A menu group such as “Custom Reports” can be easily added just by typing the name into the Menu Group field in the Reports Manager window. Reorganize existing menu groups simply by using the Reports Manager to change the menu group for a custom report, but be sure you’re not changing the menu group of a canned report!
- Use the Print button in the Reports Manager to help identify which reports are custom and which are canned. As a best practice, custom reports should be stored in a folder separate from the reports installed with the system. In any application’s Reports Manager, the location of the report designs can be viewed by clicking the Print button. The resulting report will show you the menu group (sub-menu) under which the report can be found, the title of the report, the type of design, and the report design name. For report designs not stored in the default reports location, the path to the report design will preface the name of the report design. For an all-out reports cleanup project, print the reports lists to .txt files for each Sage 300 CRE application, and then import the lists into Excel so that you can note which reports need to be moved, retired, updated, etc.
- Error messages can appear when the system can’t locate a report design. Report designs created by in-house users are sometimes stored outside of the recommended location for custom reports. If the designs get moved or are not included in a server migration, the tip above can be used to find the last known location of the design so that it can be moved to the proper folder and relinked in the Reports Manager.
Ledgerwood Associates offers affordable, live training right at your desktop! Led by Sr. Sage Certified Consultant, Kyle Zeigler, these interactive classes with shoo the Boogey Man right out of your Sage software! Bookmark the LAI Training & Event calendar, to see when the next “Take the Fear Out of Report Designing” starts.