Smart Contractor

What's New In This Release?


Here's what's new in this release:

Version 2010.6.220
Bonus Calculation Report

There is a new "Bonus Calculation Report" option in the Reports > Job Summary reports menu.

The Bonus Calculation report prompts you for the project manager and job site foreman, and their corresponding bonus percentages (for each job phase of the job selected, and then calculates the bonuses for all employees associated with the job selected.

Company Profiles

There is a new File > Select Company Profile... menu option that allows you to create and select additional company profiles.

A Smart Contractor "Company Profile" is somewhat like a user log in account. A user login account allows each user to use different settings for various options.

A Smart Contractor Company Profile allows you to define a number of options differently in each Profile, and switch between them by simply selecting the profile.

Each Job can be associated with a different Company Profile; select the Company Profile in the prompt for "Use Company Profile" in the General Setup tab of the Edit Job form).

When a Job is selected in the prompt for Select Job at the top of the main form, Smart Contractor automatically switches to the profile set for that job.

Each Company Profile can have different settings in each of the following menu options...

* Setup > Preferences
* Setup > Company Info
* Setup > Data Backup
* Setup > Job List Criteria
* Setup > Job Options
* Setup > Security > Security Options
* Setup > Other > Email
* Setup > Other > Printed Forms
* Setup > Other > Website Publishing

Smart Contractor Company Profiles are typically used to store settings for differend "DBA" companies that are operated within a single fiscal company. One company may operate under more than one "DBA" name so as to market to multiple disciplines. For example, "Affordable Kitchens and Baths", "Affordable Floors", "Affordable Doors and Windows", etc.

Using multiple profiles allows you to set each profile to use a different company name, address, letterhead logo, etc.

Important Note: While Smart Contractor allows you to set up multiple profiles, each with a different company name, each Smart Contractor database can only connect to a single QuickBooks company file.

If you want Smart Contractor to write transaction information for each DBA company in a separate QuickBooks company file, you will need to create a separate Smart Contractor database for each DBA company, and each Smart Contractor database will need to be connected to a separate QuickBooks company file.

Email Setup: Add Option To Request Reciept Notification

The Email Setup form now has an option to allow you to request an email reciept notification with emails sent from Smart Contractor.

Invoice Entry: Add Option To Print Item Notes, Item Status

The Print Options box in the Create Invoices form has a new prompts for "Show Item Notes" and "Show Item Status".

Also, the "Print By Item Structure" option has been removed. The option to print by item structure has been integrated into the "Sort Items By" prompt.

Job Entry: Allow Multiple Deposit Entries

The prompts associated with entering a job deposit in the Enter Job form (Estimate Setup tab) have been removed and replaced by a small grid that allows you to enter up to 10 deposits for the job. Each of these deposit entries will go to QuickBooks as a separate sales receipt.

Also, multiple sales receipt entries can be made (against the Deposit item) in QuickBooks, and Smart Contractor will retrieve those when the Update QuickBooks Transactions utility is run.

Job Site Photos: Change To Be On Job Level

Job Site Photos have been moved from the job item level to the job level. Whereas Smart Contractor used to store and retrieve job site photos separately for each job item, all job site photos for a job are now stored together.

And instead of being accessed from the "Photo" tab in the Edit Estimate form, job site photos are not accessed from a new "Job Site Photos" menu option in the Job menu on the main screen.

Markups On Allowances

The program has been changed to calculate the markup based on the allowance (estimate) amount (not the actual cost) when the actual cost of the allowance item is less than the allowance (estimate).

NOTE: This will cause the totals of existing jobs to INCREASE if the job has allowance items whose actual cost is less than the allowance amount.

New Merge Fields: Customer Info, Customer Salutation, Customer Signature

The merge documents now have three new merge fields: <> merges the customer name(s) and the job site address, <> merges "Dear ...", and <> merges places for the customer(2) to sign a document. These merge fields are dynamically formatted for the number of customer names and their titles (which are set in the Setup > Lists > Enter Customers menu option).

Product Images

The "Photos" tab in the Edit Estimate form has been replaced by an "Images" tab. The "Photos" tab was used to enter and view job site photos (separately for each job item), but that function has been moved to the "Job Site Photos" menu option in the Job menu on the main screen.

The Images tab now displays image files that have been attached to the product that you select in the prompt for Product in the Item Info tab. This means that you can attach any number of image files (.jpg, .tif, .gif, .bmp) to a product (in the Setup > Lists > Products menu option) and Smart Contractor will automatically retrieve and display these images in the Image tab when you assign that product to a job item.

Also, if you check the option to Display Item Products when you print a customer document that merges in the job listing, the job listing will automatically include the product images (along with the product notes) below the product in the job listing.

Purchase Order Deliver To's

The prompt for Deliver To: in the Create Purchase Order screen now maps to a list of "Deliver To's" that you can create and modify by going to the Setup > Lists > Deliver To's menu option.

Schedule Listing: Add Display Of Estimated Labor Hours

The Schedule Listing report now shows the estimated labor hours in a column next to Days.

Schedule Listing: Add Prompts For Job Status, Job Project, Allow All Jobs

The Print Schedule Listing menu option now allows you to specify the status and/or project of jobs to include in the job schedule listing. Also, there is an "(All Jobs") option in the job check list box. Instead of having to check all of the jobs in the list to include them all, you can check "(All Jobs").

What Was New In Previous Releases?

See below for information about what was new in previous releases.

Version 2010.4.90
Invoice Entry: Add Option To Print Item Notes, Item Status

The Print Options box in the Create Invoices form has a new prompts for "Show Item Notes" and "Show Item Status".

Also, the "Print By Item Structure" option has been removed. The option to print by item structure has been integrated into the "Sort Items By" prompt.

Job Site Photos: Change To Be On Job Level

Job Site Photos have been moved from the job item level to the job level. Whereas Smart Contractor used to store and retrieve job site photos separately for each job item, all job site photos for a job are now stored together.

And instead of being accessed from the "Photo" tab in the Edit Estimate form, job site photos are not accessed from a new "Job Site Photos" menu option in the Job menu on the main screen.

Markups On Allowances

The program has been changed to calculate the markup based on the allowance (estimate) amount (not the actual cost) when the actual cost of the allowance item is less than the allowance (estimate).

NOTE: This will cause the totals of existing jobs to INCREASE if the job has allowance items whose actual cost is less than the allowance amount.

New Merge Fields: Customer Info, Customer Salutation, Customer Signature

The merge documents now have three new merge fields: <> merges the customer name(s) and the job site address, <> merges "Dear ...", and <> merges places for the customer(2) to sign a document. These merge fields are dynamically formatted for the number of customer names and their titles (which are set in the Setup > Lists > Enter Customers menu option).

Product Images

The "Photos" tab in the Edit Estimate form has been replaced by an "Images" tab. The "Photos" tab was used to enter and view job site photos (separately for each job item), but that function has been moved to the "Job Site Photos" menu option in the Job menu on the main screen.

The Images tab now displays image files that have been attached to the product that you select in the prompt for Product in the Item Info tab. This means that you can attach any number of image files (.jpg, .tif, .gif, .bmp) to a product (in the Setup > Lists > Products menu option) and Smart Contractor will automatically retrieve and display these images in the Image tab when you assign that product to a job item.

Also, if you check the option to Display Item Products when you print a customer document that merges in the job listing, the job listing will automatically include the product images (along with the product notes) below the product in the job listing.

Purchase Order Deliver To's

The prompt for Deliver To: in the Create Purchase Order screen now maps to a list of "Deliver To's" that you can create and modify by going to the Setup > Lists > Deliver To's menu option.

Schedule Listing: Add Display Of Estimated Labor Hours

The Schedule Listing report now shows the estimated labor hours in a column next to Days.

What Was New In Previous Releases?

See below for information about what was new in previous releases.

Version 2010.3.15
Change Order Entry: Doesn't Remove Items From Change Order

Fixed.

Change Orders: Add Option To Show Only Change Order Totals

There is a new "Display C.O. Totals Only" option in the form to print change orders. Check "Display C.O. Totals Only" to generate the change order without item detail information displayed - only the net total change amount.

Create Invoices: Not Defaulting To Next Invoice Number Correctly

When adding a new invoice, the Create Invoices form was not defaulting to the next invoice number correctly. This has been fixed.

Customer Documents: Add Page Numbers

There is a new "<>" merge field available in the list of merged fields on the right side of the edit merge document form. If you insert the "<>" merge field, the program will print page numbers (as "n of x") at the bottom center of each page. You can place the "<>" merge field anywhere in the document, and the page numbers will always be printed at the bottom center of each page.

Dashboard: Allow Copy Customer Name, Address, Etc. Info

You can now copy text from the customer name, address, phone, email, etc. box.

Dashboard: Change Costs To Date To Be Without Markup

The Costs To Date in the dashboard has been changed to show costs before markup, and another field ("Markup") has been added below it to display the markup on the costs to date.

Edit Estimate: Set Scheduled Checkbox For Sub Items

The "Schedule Group Item" prompt in the Edit Estimate form now has a "=" button to the right of it. If you click "=", the program will set all sub items to the same scheduled status as the group item.

Import Job Estimates

Smart Contractor now has a File > Import... menu option that allows you to define import setups to import job estimate and product/price data. Please see the "How Do I... Import Data?" in the help documentation for full information.

Import Product Price Lists

Smart Contractor now has a File > Import... menu option that allows you to define import setups to import job estimate and product/price data. Please see the "How Do I... Import Data?" in the help documentation for full information.

Import: Add Ability To Import Labor Hours From Exactime

Smart Contractor now has the ability to import labor hours from Exactime. To import labor hours, use the File > Import... menu option and check the "Import Data Has Time Sheet Data" box.

Invoice Totals

The invoice total section has been enhanced. There are two formats, depending on the setting of the "Show Job Total Due In Invoice:" check box in the invoice "Print Options" section.

When "Show Job Total Due In Invoice:" is NOT checked, the format is:
Subtotal:
Sales Tax:
Invoice Total:
Deposit Applied:
Total Due This Invoice:

When "Show Job Total Due In Invoice:" IS checked, the format is:
Subtotal:
Sales Tax:
Invoice Total:
Deposit Applied:
Payment ~ (date):
Credit Memo ~ (date):
Total Balance Due:

Invoices: Add Option To Display Job Total Payment Due

The "Print Options" box in the Create Invoices form now has a new "Show Job Total Due In Invoice:" check box. If you check "Show Job Total Due In Invoice:", the total payments due (for all invoices for the job) will be displayed below the invoice total.

Job Entry: Add Prompt For Warranty Expiration Date

The Enter Job form now has a prompt for Warranty Expiration Date. The Warranty Expiration Date can be merged into merge documents using the <> merge field.

Job Entry: Add Prompts For Loan Officer, Loan Number

The General Info tab of the Enter Job form now has prompts for Loan Office and Loan Number. These will appear under the Bill To information in printed invoices.

Job Entry: Allow "Get Product Prices Button" To Find Other Vendors For Product

The Get Product Prices Button ($) has been changed so that it will find prices for any vendor that has been entered in the product info screen for the product. You can leave the vendor blank and click the Get Product Prices Button, and it will find a vendor for the product.

Job Entry: Copy From Other Databases Doesn't Copy Item Reference Info

When you copy estimate items into a job from a different database, the program does not copy in the job phase, vendor, or product associated with the item being copied.

Job Entry: Copy Items From Other Database

The Copy Item tab in the Edit Estimate form now has a prompt for "Database To Copy From:" with a "Browse..." button. Click Browse... to browse to and select another database to copy from. The program will list the jobs in that database in the next prompt. Select a job and item to copy from as usual.

Having the prompt for "Database To Copy From:" now allows you to store your job templates in a separate database.

Job Entry: Display Group Item Labor Hour Total

On the estimate entry screen when you have an item with sub items you can click on the main item and the program will also show a total for labor hours, in addition to the total cost for all the sub items below it.

Job Entry: Not Defaulting To Next Job Number Correctly

When adding a new job, the Enter Job form was not defaulting to the next job number correctly. This has been fixed.

Job Entry: Set Sub Item Markups Button

This has been changed so that you now have to click the "Set Sub Items" button next to the markups in the group item in order to set sub items to the group items markups. Once you change the sub items markups, these will not be overwritten (unless you click the "Set Sub Items" button in the group item).

Job Site Address Mapping

The Dashboard now has a "Map" link to the left of the job site address.
Click on the "Map" link to display a Google map of the job site address.
The map includes driving directions to the job site from the company address (entered in Company Info).

Job Site Photos: Saved PDF of Job Site Photos Document Is Huge

The PDF files of the Job Site Photos document is so large because it is storing the entire content of the photo in its original size - even though it is only being displayed in the size as it appears. This problem could be avoided if the user would use their camera's graphics processing software to re-save the photos in a small size, but that requires a lot of training and manual steps.

So this version of Smart Contractor has some third party software integrated with it that automatically converts the photos to the small size as they are loaded into Smart Contractor. The saved PDF files of the Job Site Photos are now quite reasonably sized.

Option To BCC Job Emails

The Setup > Job Options form now has a prompt for "BCC Job Emails To:". If you enter an email address in this prompt, all emails sent (to customers) from Smart Contractor will blind carbon copied to this address.

Publish Websites: Add Ability To Customize For Integration Into User Websites

Two things have been added to allow users to customize the uploaded customer web pages for visual integration with the user's website.

- A new check box option has been added to the Setup > Other > Website Publishing menu option to allow you to "Format Pages For iFrames". Check this option to prevent Smart Contractor from formatting uploaded web pages with page headings. This will allow the uploaded web pages to be displayed in iFrames within the user's website.

- There is a file called "SC_Style.css" in the C:\Program Files\Smart Contractor folder that can be edited by the user to define visual styles used to format the uploaded customer web page. The styles available for customization are listed in the help documentation for the Setup > Other > Website Publishing menu option.

Purchase Entry: Allow Change Cost Category Of Purchase Items

The Purchase entry form now allows you to change the cost category of purchase items when the Purchase entry is being created. You cannot change the cost category of an existing Purchase item

Purchase Order Entry: Allow Change Cost Category

The Purchase Order entry form now allows you to change the cost category of purchase items when the PO is being created. You cannot change the cost category of an existing PO.

Purchase Order: Add Display Of Company Contact Or Sales Rep

The pre-formatted PO has been changed so that it will display the name of the sales rep (if one is assigned to the job), or the company contact (if there is no sales rep assigned to the job).

Website Publishing: Improve User Login Security

The design of the customer website publishing has been changed to provide improved user log in security.

Work Offline: Allow Take Offline While Other Users Working

The Work Offline function has been changed so that users can take SC offline while other users are running in SC.

Version 2010.1.6
Change Order Entry: Doesn't Remove Items From Change Order

Fixed.

Create Invoices: Not Defaulting To Next Invoice Number Correctly

When adding a new invoice, the Create Invoices form was not defaulting to the next invoice number correctly. This has been fixed.

Customer Documents: Add Page Numbers

There is a new "<>" merge field available in the list of merged fields on the right side of the edit merge document form. If you insert the "<>" merge field, the program will print page numbers (as "n of x") at the bottom center of each page. You can place the "<>" merge field anywhere in the document, and the page numbers will always be printed at the bottom center of each page.

Dashboard: Change Costs To Date To Be Without Markup

The Costs To Date in the dashboard has been changed to show costs before markup, and another field ("Markup") has been added below it to display the markup on the costs to date.

Import Job Estimates

Smart Contractor now has a File > Import... menu option that allows you to define import setups to import job estimate and product/price data. Please see the "How Do I... Import Data?" in the help documentation for full information.

Import Product Price Lists

Smart Contractor now has a File > Import... menu option that allows you to define import setups to import job estimate and product/price data. Please see the "How Do I... Import Data?" in the help documentation for full information.

Invoices: Add Option To Display Job Total Payment Due

The "Print Options" box in the Create Invoices form now has a new "Show Job Total Due In Invoice:" check box. If you check "Show Job Total Due In Invoice:", the total payments due (for all invoices for the job) will be displayed below the invoice total.

Job Entry: Add Prompt For Warranty Expiration Date

The Enter Job form now has a prompt for Warranty Expiration Date. The Warranty Expiration Date can be merged into merge documents using the <> merge field.

Job Entry: Add Prompts For Loan Officer, Loan Number

The General Info tab of the Enter Job form now has prompts for Loan Office and Loan Number. These will appear under the Bill To information in printed invoices.

Job Entry: Allow "Get Product Prices Button" To Find Other Vendors For Product

The Get Product Prices Button ($) has been changed so that it will find prices for any vendor that has been entered in the product info screen for the product. You can leave the vendor blank and click the Get Product Prices Button, and it will find a vendor for the product.

Job Entry: Copy From Other Databases Doesn't Copy Item Reference Info

When you copy estimate items into a job from a different database, the program does not copy in the job phase, vendor, or product associated with the item being copied.

Job Entry: Copy Items From Other Database

The Copy Item tab in the Edit Estimate form now has a prompt for "Database To Copy From:" with a "Browse..." button. Click Browse... to browse to and select another database to copy from. The program will list the jobs in that database in the next prompt. Select a job and item to copy from as usual.

Having the prompt for "Database To Copy From:" now allows you to store your job templates in a separate database.

Job Entry: Not Defaulting To Next Job Number Correctly

When adding a new job, the Enter Job form was not defaulting to the next job number correctly. This has been fixed.

Job Entry: Set Sub Item Markups Button

This has been changed so that you now have to click the "Set Sub Items" button next to the markups in the group item in order to set sub items to the group items markups. Once you change the sub items markups, these will not be overwritten (unless you click the "Set Sub Items" button in the group item).

Job Site Address Mapping

The Dashboard now has a "Map" link to the left of the job site address.
Click on the "Map" link to display a Google map of the job site address.
The map includes driving directions to the job site from the company address (entered in Company Info).

Job Site Photos: Saved PDF of Job Site Photos Document Is Huge

The PDF files of the Job Site Photos document is so large because it is storing the entire content of the photo in its original size - even though it is only being displayed in the size as it appears. This problem could be avoided if the user would use their camera's graphics processing software to re-save the photos in a small size, but that requires a lot of training and manual steps.

So this version of Smart Contractor has some third party software integrated with it that automatically converts the photos to the small size as they are loaded into Smart Contractor. The saved PDF files of the Job Site Photos are now quite reasonably sized.

Publish Websites: Add Ability To Customize For Integration Into User Websites

Two things have been added to allow users to customize the uploaded customer web pages for visual integration with the user's website.

- A new check box option has been added to the Setup > Other > Website Publishing menu option to allow you to "Format Pages For iFrames". Check this option to prevent Smart Contractor from formatting uploaded web pages with page headings. This will allow the uploaded web pages to be displayed in iFrames within the user's website.

- There is a file called "SC_Style.css" in the C:\Program Files\Smart Contractor folder that can be edited by the user to define visual styles used to format the uploaded customer web page. The styles available for customization are listed in the help documentation for the Setup > Other > Website Publishing menu option.

Purchase Order: Add Display Of Company Contact Or Sales Rep

The pre-formatted PO has been changed so that it will display the name of the sales rep (if one is assigned to the job), or the company contact (if there is no sales rep assigned to the job).

Version 2009.10.13
Change Order Entry: Doesn't Remove Items From Change Order

Fixed.

Customer Documents: Add Page Numbers

There is a new "<>" merge field available in the list of merged fields on the right side of the edit merge document form. If you insert the "<>" merge field, the program will print page numbers (as "n of x") at the bottom center of each page. You can place the "<>" merge field anywhere in the document, and the page numbers will always be printed at the bottom center of each page.

Import Job Estimates

Smart Contractor now has a File > Import... menu option that allows you to define import setups to import job estimate and product/price data. Please see the "How Do I... Import Data?" in the help documentation for full information.

Import Product Price Lists

Smart Contractor now has a File > Import... menu option that allows you to define import setups to import job estimate and product/price data. Please see the "How Do I... Import Data?" in the help documentation for full information.

Job Entry: Set Sub Item Markups Button

This has been changed so that you now have to click the "Set Sub Items" button next to the markups in the group item in order to set sub items to the group items markups. Once you change the sub items markups, these will not be overwritten (unless you click the "Set Sub Items" button in the group item).

Job Site Address Mapping

The Dashboard now has a "Map" link to the left of the job site address.
Click on the "Map" link to display a Google map of the job site address.
The map includes driving directions to the job site from the company address (entered in Company Info).

Purchase Order: Add Display Of Company Contact Or Sales Rep

The pre-formatted PO has been changed so that it will display the name of the sales rep (if one is assigned to the job), or the company contact (if there is no sales rep assigned to the job).

Version 2009.8.24
Job Site Address Mapping

The Dashboard now has a "Map" link to the left of the job site address. Click on the "Map" link to display a Google map of the job site address. The map includes driving directions to the job site from the company address (entered in Company Info).

Emailed Attachments: Option To Enclose In A Zipped File

The Setup > Other > Email form now has an option to specify that all emailed attachments should be enclosed in a zipped file.

Gross Margin Report

There is a new report in the Reports > Job Summary menu called "Gross Margin". It reports gross margins for one or multiple jobs by sales rep.

Invoice Entry: Allow Change Item Taxable Status

The Invoice Entry form now allows you to change the taxable status of items by checking or unchecking the Taxable column.

Merge Documents: Add Merge Fields For Sales Rep Name And Contact Info

The Edit Merge Document form now has the following new merge fields available:
- Sales Rep First Name
- Sales Rep Last Name
- Sales Rep Phone
- Sales Rep Fax
- Sales Rep Cell
- Sales Rep Email
These will merge in the information corresponding to the sales rep that is selected in the prompt for Sales Rep in the General tab of the Edit Job form.

Publish Customer Documents: Add Option To Send Documents By Email

The Publish Customer Documents menu option (formerly Publish Website) now has an option to publish "To Website", or "By Email". If you select "By Email", the program will send all of the documents selected for uploading to the customer in an email.

QB Integration: Check Purchase Update Is Removing Check Cleared Status

The QuickBooks data update for check purchases has been changed so that it will not update checks that have been changed in any way in QuickBooks (i.e. cleared).

Quote Request: Add Ability To Attach Files

There is a new button to "Add Attachment" in the Create Quote Request form. Click the "Add Attachment" button to add attachment files to the quote request. Files attached to a quote request will be attached to the quote request when it is emailed to the vendor/subcontractor.

Quote Request: Add Ability To List Just Products For A Job

Instead of the prompts for "Job Products", and "All Products", the Quote Request form now has prompts for "List Job Items", "List Job Products", and "List All Products":

- The "List Job Items" option lists the selected job items in the quote request.
- The "List Job Products" option lists the products (only) in the selected job items in the quote request.
- The "List All Products" option lists all (selected) products, regardless of which job they are in, in the quote request.

Search Archive Data

There is a new menu option in the File dropdown menu at the top of the screen for "Search Archive Data...". The Search Archive Data form allows you to search for and open an archived job by job name and/or job number.

What Was New In Previous Releases?

See below for information about what was new in previous releases.

Version 2009.5.8
Job, Invoice, PO Numbers Not Incrementing

The Job, Invoice, and PO numbers are stored (and sorted) alpha-numerically (because users want to be able to mix letters with numbers). The problem with this is that it causes 9 sort after 10. The program has been changed to make these numbers sort alpha-numerically right justified. This is better in that it makes 10 sort after 9, but it still results in 10.5 sorting after 20.

Archive Utility

There is a new "Archive Data" option in the File menu. The Archive Data form prompts you for the status of jobs to be archived.

Check the status of jobs to be archived and click Archive Data. The program will save a copy of the current database to a sub folder in your Smart Contractor data folder (named for the company and the archive date), and then remove all of the jobs with the statuses you checked.

You can archive your data any number of times, but only once each day (because the archive folders are named for the date on which you archive the data).

You can access the archived data at any time by selecting the "File" > "Open Database..." menu option and navagating to any of the archive folders in your data folder.
When you open an archived database, you will notice the following:
- The title bar at the top of the screen says "... - ARCHIVED DATA".
- The background of all screens and data entry forms is a bright blue color.
- You cannot add new jobs.
- You cannot integrate archived data with QuickBooks.
- You cannot backup archived data, or run any of the Exit Options.
- When you exit and start Smart Contractor again, the program will open the last non-archived database you had open. It will not re-open an archive database when the program starts.

Change Orders: New Procedure

There is a new proceedure for creating change orders. All steps for creating a change order are now performed in the Enter Change Orders menu option in the Job menu.

Also, the change order creation procedure has been changed so that change orders are not applied to a job until the change order status is set to "C.O. Approved" in the Enter Change Orders menu option. This allows you to enter a change order and print it (or email it) before applying it to the job.

See "How Do I.... Create A Change Order?" in the help documentation for full information.

Customer Documents: Add Merge Field For Total Estimated Labor Hours

The merge document template editing form now includes a merge field for "Job Total Labor Hours". This will merge the total estimated labor hours into a document.

Data Export

There is now an "Export" button in the lower right of the Estimate Grid form, and in the grid that appears when you click the "List" button (to the right of the "Enter or Select... To Edit" prompt) anywhere in the program. When you click the Export button, the program will prompt you for a file name and location to export the data to, and then will export the data to a .csv (comma separated value) text file, which can then be opened in Excel.

Note that you can select the columns of data to appear in the export by hiding (shrinking) or revealing (expanding) the columns in the grid.

Estimate Grid: Add Ability To Export Estimate Data From Grid

The estimate grid form now has an "Export" button (in the lower right of the form) to allow you to export the contents of the grid.

You can select the columns to export by hiding (dragging the edge) of the column heading.

You can specify the order of the columns to export by dragging and dropping the column headings in the sequence that you want them in.

If you click the "Shrink" button at the top of the form, the grid will only display and export totals for each item group.

Estimate Grid: Add Buttons To Expand/Shrink Groups

The estimate grid now has buttons at the top of the form that allow you to expand or shrink the item groups in the grid.

Invoice Entry: Add Option To Invoice Estimated Amount For Allowance Items

The Create Invoices form has a new option in the "Invoice Options..." box for "Invoice Estimated Amount For Allowance Items With Zero Cost:". If you check "Invoice Estimated Amount For Allowance Items With Zero Cost:", the program will invoice the estimated cost for allowance items with zero cost. Otherwise, the program will invoice zero for allowance items with zero cost.

Main Window: Add Additional Information

The main window ("dashboard") now displays the following additional information:
- Customer contact info
- Labor Hours
- Open Change Orders

Merge Documents: Add Option To List Items In 5 Cost Categories

The Edit Job form now has a new option in the "Proposal/Contract Options" box in the "Estimate Setup" tab for "Show All Cost Categories". If you check "Show All Cost Categories", the program will show estimated amounts broken out in to the 5 separate cost categories (materials, subcontract, equipement, other, labor) when the job list is merged into customer documents.

Minimum Order Quantity, Minimum Labor Cost

The Enter Products form now has these new prompts:

- Minimum Order Quantity; Enter the minumum quantity in which the product can be purchased.

- Minimum Labor; Enter the minumum labor cost associated with installing the product. The minumum labor cost can be entered in either hours or dollars. To enter minimum hour labor cost in hours, click the button to the right of the prompt until it says "hrs". To enter minimum hour labor cost in dollars, click the button to the right of the prompt until it says "$".

- Labor Rate; Enter the minumum hourly labor cost (in dollars) associated with installing this product.

Publish Website: Add Link To Company Website To Customer Info Page

Added code to format company info heading on uploaded web pages the same as it is on printed forms.

Purchase Order Listing: Increase PO # Column Width

The width of the PO # column in the Purchase Order Listing report has been increased to 1 inch.

Version 2009.3.22
Materials Ordering Schedule

Added prompts for vendor, product, and date range to materials ordering schedule requester form.

Website Publishing From Two Databases Overwrites /customerlogin/default.htm

A new field has been added to the Setup > Website Publishing form for "Customer Login Path". Enter the path name that your customers will use to access the customer login page on your website. For example, if you set the customer login path to "customerlogin", and your website URL is www.CompanyName.com, then your customer will type "www.CompanyName.com/customerlogin" into their web browser address to get to their login page.

NOTE: If you use more than one Smart Contractor database, then the customer login path name must be different in each database. If they are named the same in more than one database, then when you publish customer information to your website, the customer login information from one database will be overwritten by the customer login information from the other database.

Website Publishing: Send Email To Customer To Notify When Website Updated

The program now sends an email to customers to notify them whenever their updated job information has been uploaded to their web page.

Cost To Complete Report

There is a new report available in the Job Summary Reports menu called Cost To Complete. This report lists the following information for one or multiple jobs:

Job - Lists the Job name.

Status - Lists the job status.

Estimated Cost To Date - Lists the estimate amount as of the current date, including change orders, but without markups.

With Markup - Lists the estimate amount as of the current date, including change orders, with markups.

Completed To Date - Lists the sum of the estimated costs (without markup) for job items that have costs entered.

Actual Cost To Date - Lists the sum of the job costs entered to date.

Variance - Lists the difference between the "Actual Cost To Date" and "Completed To Date" ("Actual Cost To Date" - "Completed To Date").
A negative number indicates that job costs to date are below estimated.
A positive number indicates that job costs to date are above estimated.

Percent Variance - Lists the variance as a percent of the contract "Completed To Date".

Cost To Complete - Lists the sum of the remaining estimated job costs (without markup).
NOTE: This number reflects the estimated cost of all job items that have not had any job costs entered.

Contract Balance - Lists the difference between the "Estimated Cost To Date With Markup" (column 4) and the "Actual Cost To Date" (column 6).

Documents: Add Customer Envelopes, Vendor/Sub Envelope

The Documents menu now has an option to print Customer Envelope, and the Purchase menu now has an option to print Vendor/Sub Envelope. These will print envelopes for customer or vendor/subs.

Note: To print envelopes, you must first select File > Print Setup... and change the printing mode to "Landscape", and then put the envelope into the printer sideways.

Estimate Entry: Allow 2 Decimal Places In Markup Prompts

The job markups and job item markups now allow entry of 2 decimal places.

Estimate Entry: Make Product Description Multi Line

The Product Description prompt now allows multi line entries. When active, the prompt expands to display several lines.

Invoice Entry: Not Invoicing Allowance Items With Zero Actual Costs

The program has been changed so that allowance items that do not have actual costs entered it will invoice the estimated costs. If actual costs are entered after an invoice is created, then a subsequent invoice will invoice for the differences between the estimated and actual costs.

Job Entry: Allow Enter Labor Rate With No Hours In Template Jobs

The Edit Estimate form has been changed so that you can enter labor rates on job items with no labor hours estimated - if the job is designated as a "template job".

To designate the job as a template job, check the "Template Job" box in the Estimate Setup tab in the Edit Job form.

Labor Hours Entry: Add Column For Job

The Enter Labor Hours form now has a column for Job, which allows you to enter labor hours for multiple jobs in one entry.

Print Documents: Add Ability To Export Merged Documents To RTF Text

The form that appears when you select a document to print now has a new "Export" button at the bottom. If you click the "Export" button, the program will prompt you to select a location to save the file and will export the merged document text to an .rtf file in that location. You may then edit (and cut and paste from) that file using MS Word.

Product Entry: Add Prompt For Product Notes

The Enter Products form now has a multi line text box prompt for Product Notes. This can be used to enter any notes to further describe a product.

Note that the Product Notes in the Entry products form is separate from the Description box and the Item Notes box in the Enter Estimate form.

Text that you enter in the Product Notes box will appear in Quote Requests, and in Purchase Orders.

Quote Request: Add Option To Include Job Item Notes In Quote Request Listing

The quote request form now has a check box option to allow you to "Include Item Notes". If you check the "Include Item Notes" box when you create a quote request, the program will include item notes in the quote request item listing.

User Interface Enhancements

This release of Smart Contractor has several enhancements to the user interface:

- New icons in the shortcut tool bar on the left side of the screen.

- The function of the shortcut tool bar on the left side of the screen has been improved so that it can dynamically shift back and forth between the popup menu mode, and the tree view menu mode by simply sliding the border of the menu in and out (left and right).

- Option to use large or small screen fonts. By default the program is set to use smaller screen fonts, but a new option has been added to the Setup > Preferences screen to "Use Large Fonts". Check that option to use large fonts.

Version 2.1, Release 28
Estimate Grid Entry: Changes Estimated Count Without Changing Pre-Waste Count

The Estimate Grid entry form now has columns for the percent waste and total count as well as the estimated count. You can set the percent waste and the estimated count, and the program will set the total count.

Invoice Entry: Allow Select Items By Group Item, Or Job Phase

The Invoice Options... drop down box has two new prompts: Select By: and Select For:
Select By has two options "Group Item", and "Job Phase". If you select "Group Item", then the Select For prompt will allow you to select a group item for which to select invoice items. If you select "Job Phase", then the Select For prompt will allow you to select a job phase for which to select invoice items.

Purchase Order Entry: Re-Add "Show More" Button

The "Show More" button has been re-added to the Purchase Order Entry form.

QB Integration Setup: Add Prompts For Checking Account And Credit Card Account

The Setup QuickBooks Integration form has two new prompts for Checking Account and Credit Card Account. These are used as the default accounts for check purchases and credit card purchases entered in the Enter Purchases form.

Website Publishing: Improve User Login Security

The design of the customer website publishing has been changed to provide improved user log in security.

Website Publishing: Ability To Select Jobs To Upload

There is a new Publish Customer Websites form that appears when you select the "Publish Customer Websites" option from the Utilities menu. The Publish Customer Websites form displays a grid with a list of jobs (with active status). The grid...
- Allows you to select which jobs will be published by checking a box next to the job.
- Allows you to view and enter the customer's website login password.
- Displays an indication as to whether any documents have been selected for upload for the job.
- Displays the date and time that the customer's website was last uploaded.