Sage 100 Contractor comes with over 1,200 reports, providing you with many ways to understand your business and to communicate with your clients. Standard reports include selection criteria that allow you to save your personal defaults for repeated use. For quick access to reports that you use often, you can drag them to the Sage 100 Contractor Desktop to create an icon.
You can drill down into special Dashboard reports and from there to the record source. This feature makes getting to the source of financial data just one mouse-click away.
You can also drill down into the 1,200 program-wide reports by running a report in print preview, which is available via the Preview report on screen button. With your pointer appearing as a magnifying glass with a red lens, double-clicking rows or fields drills down to report details and records.
To drill down into report information
| 1 | Open a record window (3-5 Jobs (Accounts Receivable), and select a record (for example, 186). |
| 2 | Click the Print records button. |
| 3 | Select a report, and click the Preview report on screen button. |
| 4 | The report appears in “print preview” mode. |
In the following examples, Sage 100 Contractor is running the Sample Company, menu 3-1-3 Receivable Aging, and the 31-Current Job Aging report. The report was run without selection criteria.
Drilling down into rows
A single click on the information reveals whether you are drilling to information contained in a row (notice the arrows at each end of the row) or an individual field. In this case, the first line contains a drillable row in addition to two drillable fields, Job# and Current Retention.
|
Job# |
Description |
Current + Retention |
|
186 |
Williams Post Office |
149,696.25 |
|
201 |
Trappen Motel |
156,053.48 |
|
207 |
Wood Elementary School |
Double-clicking the row drills down to the job record 186—Williams Post Office in the 3-5 Jobs (Accounts Receivable) window.
Drilling down into fields
Drillable information contained in a single field is depicted differently. In a drillable field, you see arrows at each end of the field.Double-clicking the field opens a grid window that shows the details of the value, as shown in the 31—Job Current Aging~Current + Retention window.
Notice that the grid window displays the value in addition to the values that have been added together to create the drillable field value. At the bottom left corner of the grid window is a Drill Down button. By selecting a grid cell in the A/R Invoices Balance column (9,569.34) and clicking Drill Down, you can drill to the invoice.
From that invoice, you can continue to drill down to information through other reports. In addition, the status bar below the grid displays the selection criteria of the cell when the query selection criteria contains a “Where” clause.
This information can help you understand why certain information is in a grid and (equally as important) why certain information is not in the grid. For example, if you are expecting to see an important invoice on a grid but it’s not showing up, the information in the status bar can show information revealing that the invoice has incorrect status. This allows you to locate the invoice and correct its status.
Note: We recommend that you try drilling down into your own business’s reports. Hands-on practice with familiar reports is the best way to understand how drilling down into reports actually works.
You can use the selection criteria to limit the scope of documents; however, many reports do not require you to use selection criteria. If a criterion is left blank, Sage 100 Contractor does not use the criterion when creating the document.
Specific criteria is required to print checks. You must provide the first check form number, check date, and ledger account number of the checking account.
If a document does not include information that you were expecting, examine the selection criteria. If all the criteria are correct, the scope of the criteria might be too narrow. Try removing some of the criteria.
Sage 100 Contractor provides several reports to reflect generally accepted accounting principles, or GAAP. These reports include the following:
You can view a list of reports in three ways:
To view a list of available reports
| 1 | Open a Sage 100 Contractor window, for example 3-2 Receivable Invoices/Credits. |
| 2 | Select the record you want to view in the data control. |
| 3 | In the toolbar, click the Print Records button. |
| 4 | In the Report Printing window, click the Report Criteria tab. |
| 5 | Double-click the report you want to view or print. |
To view a list of all reports by menu command
Note: You can only edit a calculated field on an existing report containing an existing calculated field.
| 1 | Open 13-6 Report/Query Lists. |
| 2 | The 13-6 Report/Query Lists window opens. |
| 3 | If not already selected, select 21-Report List~by Menu. |
| 4 | On the toolbar, click Preview report on screen to view the report. |
| 5 | Alternatively, select other printing and export options. |
To view the list of all reports by menu option
Note: You can only edit a calculated field on an existing report containing an existing calculated field.
| 1 | Open 13-6 Report/Query Lists. |
| 2 | The 13-6 Report/Query Lists window opens. |
| 3 | If not already selected, select 26-Report List~by Menu Option. |
| 4 | On the toolbar, click Preview report on screen to view the report. |
| 5 | Alternatively, select other printing and export options. |
Sage 100 Contractor provides representative samples of most reports that the system produces. These samples are not generated from the sample data, but are images for you to view. By viewing sample reports, you can get an idea of the report’s content without having to actually generate the report.
To view a sample report
| 1 | Open a Sage 100 Contractor window, for example 4-2 Payable Invoices/Credits. |
| 2 | On the toolbar, click the Print Records button. |
| 3 | In the Report Printing window, click the Samples tab. |
| 4 | In the reports list, click a report. |
| 5 | The sample appears in the right pane. |
Note: Not all reports have a sample. If there is no sample, a message appears: There is no example available for this report.
Sage 100 Contractor’s Quick Reports feature lets you create simple reports for review. When you view a Quick Report, Sage 100 Contractor displays the report information in a grid.
For example, here are some of the windows in which you can create Quick Reports:
You can change the font styles in individual cells or for the entire grid. In addition, you can hide columns of information. When you print the report, any information hidden in the Quick Report window will not appear on the printed report.
Although you can change the formatting of a Quick Report, the changes are not saved. They are only used for printing a Quick Report. For example, open 6-5 Cost Codes, and using the B, I, and U buttons located under the menu bar, apply bold, italic, or underline formatting to the contents of cells.
You can hide the columns by right-clicking the column heading and selecting the Hide Selected Column command from the drop-down menu. Then click the Print Records button. When the Grid Printing window opens, click the Preview report on screen button to view a preview of your changes.
In some cases, a grid may display too many columns for the report to fit on a standard-sized piece of paper even in landscape orientation. In such cases, we recommend that you export the quick report to Microsoft Excel, which has the capability to capture all the data on any grid in Sage 100 Contractor.
| 1 | Open any Report Printing window. |
| 2 | Click the Report Criteria tab. |
| 3 | Select a report. |
| 4 | In the lower left of the window, click Create a Shortcut to Selected Report. |
For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.
For additional training on Sage products, visit Sage University.