The Tasks By Supplier By Community report shows all tasks of a particular status for a supplier during a specified date range. The report also shows the job name and the duration of the task. Use the View Printable and View In Excel links for printing options.

To generate the report:

1. Choose a Subdivision from the drop-down filter.

2. Enter the name of the Supplier in the supplier text field or leave blank to search for all suppliers.

3. Enter a job name in the Job text field or leave blank to search for all jobs.

4. Click the Task Status drop down box and choose the appropriate status for the tasks to appear in the report.

5. Click the Date Range field and type the appropriate date ranges.

6. Use the Supplier Name Starting With drop down box to filter the report by suppliers beginning with a certain letter.

7. Click the Max Rows field and type the desired number of rows to appear in the report.

8. Click the Industry drop down box to filter the report by industry.

9. Use the Job Status filter to only show jobs with a specific status or all statuses.

10. Click Generate Report.

Where does that come from?

Below is a list of information in the Tasks by Supplier report and where the information comes from.

Report Filters

Subdivision - Drop-down filter where you can choose a single subdivision to report on.

Supplier - Allows you to perform a ”like” search. This will search all supplier names for any part of the text entered.  

Job - Allows you to perform a  ”like” search. This will search all job names for any part of the text entered.

Task Status - Allows the report to be filtered by task status.

Date Range - Allows you to look for tasks with an end date within the range specified. This field defaults to today’s date and the same date in the next month.

Supplier Name Starting With - Allows you to filter suppliers by the first letter of their name.
Ex. Choosing T would find "The Cleaning Company" and "Terry’s Cleaning."

Max Rows - Allows you to choose the number of rows of data returned to the page.

Industry Filter - Shows all the industry filters by which you can filter the report.
Ex. Choosing Framing will show all the framing tasks.  

Job Status Filter - Allows you to filter the report by specific job statuses.

Report Columns

Job Name - Shows the date the task is scheduled to start and the job name for the task found according to your filter criteria.

Subdivision - Shows the name of the subdivision the job is in.

Task Name - Shows the name of the task.

Duration - The number of days to perform this task. The date in parenthesis is the end date of the task.

Status - Shows the status of the task.