Sage Timberline Office

2010 Year-End Update

Accounting 9.6.0 Update 8

 

2010 Year-End

Amendment

Year-End Resources

Upgrading Data

Release Notes

Download Instructions

Note: The 9.6.0 year-end update has been amended. If you are using CD Version 9.6 and have not already installed 9.6.0 Update 8 but are required to file government forms, download and install the Update 8, and then determine from the list below if you should download and install Payroll Update 7.

If you have installed CD Version 9.6.0 Update 8, download and install Payroll Update 7 if you:

  • have HIRE Act qualified employees who received at least two consecutive payroll checks after 3/18/2010 that included reimbursement pays and you will print W-2 forms.
  • have employees in New Jersey.
  • will print Canadian T4 forms.

If these issues do not affect you and you have already installed Accounting 9.6.0 Update 8, you can disregard this notice.

Accounting 9.6.0 Update 8

Sage Timberline Office Updates are cumulative. The 2010 Year-End Update (Update 8) includes the latest enhancements and solutions plus all enhancements and fixes from previous updates. If you have not installed 9.6.0 updates, you can install this update to get all the previous enhancements and fixes.

Notes:

  • You must have installed Accounting 9.6 in order to install the 9.6 Year-End Update (Update 8).
  • If you use Document Management, you must stop the World Wide Web Publishing service before you install the update.
  • 9.6.0 Update 8 is available for Accounting only. An Estimating update is not required for compatibility.
  • If you install new or additional Sage Timberline Office applications after installing an update, you must reapply the update.
  • If this update applies to your company, but you are not the person who downloads and updates Sage Timberline Office payroll tax and other updates, please forward this notice to the correct person in your company.

Return to top

Download Instructions for 9.6.0 Update 8

Important: Download and install 9.6.0 Accounting Update 8 before you install Payroll Update 7.

Download the Software Update:

If you are operating in a client/server environment, you must install the update on the server and any workstation where you installed Sage Timberline Office Accounting & Management Products 9.6.0 CD or Sage Timberline Office Accounting & Management Products 9.6.0 Rev. 1 CD.

Before you begin, determine which version and update you have installed.

  1. Click the appropriate link to download the self-extracting file that contains the software update.

    9.6.0 Accounting Update 8

  2. When the File Download window appears, click [Save].

  3. In the Save As window, select a temporary location on the server to save the file, and then click [Save].

    Note: This location must be available to all workstations where Sage Timberline Office is installed. For example, create a folder named Update, if it does not exist, under X:\Timberline Office\9.5\Accounting\WinInst. Then, save the file to that location.

  4. In the Download Complete window, click [Close].

Update the Server:

  1. At the server or stand-alone computer, log on with full administrative rights.

    Note: Full administrative rights are defined as write access to the Windows registry and all the folders on the computer, including rights to the root of all hard disks. If you are unsure whether you have full administrative rights, ask your network administrator for assistance. Alternately, you can ask your network administrator to log on with the network administrator ID before you start the installation.

  2. Close all Sage Timberline Office applications and other program such as Outlook and Microsoft Office at the server and on all workstations.

  3. Additional step for Document Management users. If you do not use Document Management, skip to step 4.
    If you use Document Management 9.6.1 and DocuVault is installed on your Accounting server, you need to stop the World Wide Web Publishing service in order to install Update 8. Contact your system administrator if you have questions about stopping and starting a service.

    4. a. At the server, open Control Panel > Administrative Tools > Services.
    b. In the Services window, select World Wide Web Publishing or World Wide Web Publishing Service.
    c. Click Stop the service.

  4. Browse to the location where you saved the file in step 3 of the "Download the Software Update" section.

  5. Double-click the file 960AccUpdate8.exe only once.
  6. If a security warning appears, click [Run] or [Allow].

  7. The Ready to install window appears. Click [OK].

    Note: The update may take several minutes. Double-click the file 960AccUpdate8.exe only once. You will receive a message when the installation is complete.

  8. The Configuration Manager window displays the configuration setup. Click [OK].

  9. The message This update has been installed successfully appears. Click [OK].
  10. Additional step for Document Management users. Disregard this step if you do not use Document Management.
    Restart the service you stopped in step 3.
    11. a. At the server, open Control Panel > Administrative Tools > Services.
    b. In the Services window, select World Wide Web Publishing or World Wide Web Publishing Service.
    c. Click Start the service.

Upgrade Data

Upgrade the applications below after you have installed Update 8 on your server.

Determine which CD version and update you have installed:

  1. Start TS Main.
  2. Select Help > About TS Main.
If Update 4 or earlier is your current version: If Update 5 is your current version: If Update 6 is your current version: If Update 7 is your current version:
Payroll Payroll Payroll Payroll
Project Management (if you use Project Management) Purchasing (if you use Purchasing)    
Purchasing and Inventory (if you use Purchasing and Inventory)      


Important: Purchasing has specific upgrade requirements. Open and upgrade Purchasing data files at the server the first time you open the application. Upgrading this data on a workstation will incorrectly set DSNs and cause data access errors after the upgrade is completed.

How to Upgrade Data

For optimal performance, Sage recommends that you upgrade your data from the server. Perform the Upgrade Files process only after the update has already been applied at the server. If you prefer to upgrade your data from a workstation instead, you must apply the update at both the server and the workstation before starting the Upgrade Files process.

  1. In TS-Main, select Tools > Upgrade Files.
  2. At the Do you have a current backup of your data folders window, click [Yes].
  3. Select to upgrade the current data folder or all data folders.
    • If you select Current data folder, you upgrade files in the data folder in which you currently work.

    • If you select All data folders, you upgrade files in all data folders that display in the Open Data Folder window. This may include data folders on other drives. With this option, the upgrade process can take a long time if you have many data folders.
  4. From the Files list, select all files. Do not select the Force file upgrade check box. This ensures only files requiring an upgrade are upgraded.
  5. Click [Start]. The Print File Selection window opens.
  6. In the File name box, type a name for the upgrade report file and click [Save]. The upgrade process begins in the background.
  7. Review the report when the process is complete.

Update Each Workstation:

Update each workstation where you installed Sage Timberline Office.

  1. Log on to the workstation with full administrative rights.

  2. Close all Sage Timberline Office applications and other program such as Outlook and Microsoft Office.

  3. Browse to the location where you saved the file in step 3 of the "Download the Software Update" section.

  4. Double-click the file 960AccUpdate8.exe only once.

  5. If a security warning appears, click [Run] or [Allow].

  6. The Ready to install window appears. Click [OK].

    Note: The update may take several minutes. Double-click the file 960AccUpdate8.exe only once. You will receive a message when the installation is complete.

  7. The message This update has been installed successfully appears. Click [OK].

  8. Repeat steps 1 through 7 at each workstation where you installed this Sage Timberline Office application.

Important: If you run the workstation installation on additional workstations later, you must also install the update by following the instructions in this section.

Return to top

9.6.0 Release Notes

9.6.0 Accounting Update 8

Accounts Payable (United States)

  • 1099 magnetic media formats have been updated

Payroll (Canada)

  • T4 magnetic media format has been updated
  • When code 41 is specified in the Modify T4 forms a Pay, Deduct, Fringe, or Formula can now be selected

Payroll (United States)

HIRE Act - Under the Hiring Incentives to Restore Employment (HIRE) Act, enacted March 18, 2010, two new tax benefits are available to employers who hire certain previously unemployed workers. Wages are calculated from March 19, 2010 to December 31, 2010. In order to calculate and display exempt wages in box 12 of the W-2, you must:

  1. For each qualifying employee, open Setup > Employee > Misc Info tab and select the HIRE Act Qualified checkbox.
  2. Open Tools > Modify > W-2 forms > Amounts tab. Enter code CC in box 12 of the W-2.

For detailed information about the HIRE Act and HIRE Act reports, see Knowledgebase article KB8366.

Enhancements

  • The W-2 format has been updated to allow the code CC, which is used to indicate employees that are HIRE act qualified
  • The Hire Act Qualified checkbox on the employee record can now be updated via ODBC
  • Quarterly Magnetic Media formats have been updated for Iowa, Oklahoma, and Pennsylvania
  • Federal W-2 Magnetic Media format has been updated
  • W-2 Magnetic Media formats have been updated for Idaho, Ohio, Maine, and Vermont

Fixes

  • Louisiana SUI_E calculations no longer take into account earnings in other states.
  • The amount in column e of the NYS-45-ATT form has been corrected.
  • Alaska SUI now takes into account other state earnings if the other state does not have an equivalent tax.
  • In some cases boxes 5a and 5c on Form 941 would contain #### instead of amounts.
  • The default path for magnetic media files has been changed from A:\ to the current data folder.

Property Management

  • 1099 and 1098 magnetic media formats have been updated

Notes:

  • You must have installed Accounting 9.6 in order to install the 9.6 Year-End Update (Update 8).
  • If you use Document Management, you must stop the World Wide Web Publishing service before you install the update.
  • 9.6.0 Update 8 is available for Accounting only. An Estimating update is not required for compatibility.
  • If you install new or additional Sage Timberline Office applications after installing an update, you must reapply the update.
  • If this update applies to your company, but you are not the person who downloads and updates Sage Timberline Office payroll tax and other updates, please forward this notice to the correct person in your company.

Return to top

Update 7

Accounts Payable
The Accounts Payable (1099) magnetic media format has been updated to meet current specifications.

Payroll (Australia)

Direct Deposit Future Date
When you enter a future date in the Generate Direct Deposit window, you are now warned that you have entered a date that is not the current month.


Payment Summaries
In prior years the Payment Summaries process gave no warning if you had paid an Early Termination Payment (ETP) without updating the ETP tab in employee setup. A warning message is now displayed on the summary page when ETP information has not been updated.

Pay Groups
Custom check sort order now works correctly in Change Unposted Time with time that has been imported.

Payroll (Canada)

Pay Groups
Custom check sort order now works correctly in Change Unposted Time with time that has been imported.

Record of Employment (ROE)
Record of Employment (ROE) forms now generate the correct insurable earnings amounts (Box 15C) for employees with pay frequencies of Semi-Monthly (24 Periods).

Tax Calculation
Previously when earnings were marked as exempt from taxes, Quebec taxes were still calculated. This has been corrected.

Payroll (United States)

Payroll Fixes

Direct Deposit Future Date
When you enter a future date in the Generate Direct Deposit window, you are now warned that you have entered a date that is not the current month.

Louisiana State Unemployment
Earnings in other states are now included when calculating Louisiana State Unemployment (LASUI_E).

Pay Groups
Custom check sort order now works correctly in Change Unposted Time with time that has been imported.

New Jersey State Unemployment and Family Leave Insurance
Other states' earnings are now included when calculating New Jersey SUI and FLI even though the other state does not have an equivalent tax.

Security
Social Security numbers now display masked (XXX-XX-NNNN) in Enter Time, Change Unposted Time, and in the Equipment Detail windows if the user does not have permission to view the social security number.

Use Bank Assigned ID
The Generate Direct Deposit > Options > Use Bank Assigned ID now works correctly. This option allows you to enter the id assigned by your bank and have that id used when you generate direct deposits.

Government Reporting

Alabama W-2 Magnetic Media
The W-2 magnetic media format has been updated to meet the 2009 Alabama specifications.

Arkansas Quarterly Magnetic Media
Quarterly magnetic media have been updated to meet Arkansas specifications.

Maine Quarterly Magnetic Media
A rounding issue in the Maine quarterly magnetic media file has been fixed.

Maryland W-2 Magnetic Media
The W-2 magnetic media format has been updated to meet the Maryland 2009 specifications.

Massachusetts Quarterly Magnetic Media
The Massachusetts quarterly magnetic media format has been updated to meet the 2009 Q4 specifications.

Michigan Quarterly Report
The Michigan quarterly report (UIA 1017) now aligns correctly.

Missouri W-2 Magnetic Media
The W-2 magnetic media format has been updated to meet Missouri specifications.

New Jersey W-2
The W-2 forms and magnetic media format has been updated to meet the 2009 New Jersey specifications. The New Jersey forms now include Family Leave Insurance. See the Payroll Help topic “Special note about printing W-2 forms for New Jersey” for important changes when printing W-2 forms for New Jersey to meet the new requirements.

New Mexico Quarterly Magnetic Media
New Mexico has discontinued its fixed-length file format. Our quarterly magnetic media format has been updated to meet the CSV file specifications.

Texas Quarterly Magnetic Media
The Texas quarterly magnetic media format has been updated.

Property Management
The Property Management (1098 and 1099) magnetic media format has been updated to meet current specifications.

Service Management
Previously when multiple users were accessing work orders at the same time, they would receive a Btrieve 80 error. The instances of this error are now reduced.


Return to top

Update 6

Fixes

General
Previously in a limited number of cases, using MS SQL to query Sage Timberline Office data resulted in corruption of the Timberline Data ODBC driver.

Inventory
Previously when inventory items used in Service Management were synchronized with an Inventory location that did not have a positive quantity on hand, a zero unit cost was used. Now if the Inventory Company settings are set to "Allow Negative Quantity on Hand" then the Inventory Location item quantity on hand and value on hand will be allowed to go negative and the average cost retrieval hierarchy will be used as the item's average cost.

Purchasing

In some cases, blank records were being created, which caused a PO non-blob error. This has been addressed.

Tasks may now launch more quickly for customers with large amounts of data.

Purchasing and Inventory
Importing requisitions into companies that do not use Categories in Job Cost no longer creates invalid items.

When entering requisitions a warning is now displayed if the value of the requisition line will cause the cost estimate on the job category (cost code if not using categories in Job cost) to be exceeded.

Payroll (Canada)
Previously when earnings were marked as exempt from taxes, Quebec taxes were still calculated. This has been corrected.

Payroll (US)
The Ohio quarterly magnetic media format has been updated. Additional fields that were not validated by the state of Ohio are now included in the magnetic media file.

Earnings in other states are now included when calculating Louisiana State Unemployment (LASUI_E).

A new field, "Use Bank Assigned ID" has been added to the Generate Direct Deposit > Options window. If selected, this new option will allow you to enter the id assigned by your bank and have that id used when you generate direct deposits.

Project Management
Previously, if Project Management Change Request forms exceeded one page the "Submitted by" field was not shown. This has been corrected.

The print hub no longer displays behind other windows.

Return to top

Update 5

Sage Timberline Office updates are cumulative. Update 5 includes the following features plus all enhancements and fixes from previous updates.

Enhancements

Project Management Payroll Time

You can now enter payroll time in Project Management field reports and send the time to the Payroll application. This feature is secured, allowing you to control which users have access. You can enter the employee, date (for certified jobs), pay ID, extra, cost code, and units. When you send the time entries to Payroll, the entries are stored in the New.prt file until you are ready to process them. You can send time entries to Payroll up until the time you finalize the field report.

Note: The new capability is intended to allow you to enter time for field employees while creating field reports and is not intended as a replacement for the Payroll Enter Time task.

The new Field Reports—Payroll Time Activity report recaps payroll time activity entered into field reports. You can add this report to your Reports menu, as follows:

  1. In Project Management, select Reports > Reports Manager > [New].
  2. In the New Report window, make the following selections:
    • Report name: Payroll Time Activity
    • Menu group: Field Reports
    • Source: Crystal Report design
  3. Click in the File name box, and then click List.
  4. Browse to the location where your report designs are stored (typically, Documents and Settings\All Users\Application Data\Sage\Timberline Office\9.6\Accounting\Report).
  5. Select PJ Field Reports Payroll Time Activity (CR).rpt and then click [Open].
  6. Click [OK] to add the report to the menu.

Project Management - Create RFI

You can now create a new request for information (RFI) from with a Project Management field report. Click [Create RFI] in the field report to open a new RFI. This allows you to create an RFI conveniently without having to leave the field report.

Inquiry - Interface Improvements

The table and form views from within Inquiries now have an attractive and refreshed new look. We have replaced the buttons at the bottom of the windows with a more modern toolbar. You can select whether to use the new interface or continue using the "classic" view. See Inquiry Help for more details.

Inquiry - Print All Rows

This release gives you the ability to print all rows from within a given Inquiry. When printing the contents of an inquiry you can add or change conditions and select ranges to control the rows printed based on the security settings of the inquiry you are printing.

Service Management - Purchase Order Description Prefills

When you create a Purchase Order from a Work Order, the Work Order location description will automatically appear in the Purchase Order, eliminating the need for system lookups, streamlining PO generation, and minimizing data entry.

Inventory - Include Tax in Inventory Value

You can now select whether to post materials received in Purchasing at their net or gross value. Materials posted at gross value include taxes, which will save you time and ensure a more accurate GL reconciliation. To select this option, open Inventory, then click File > Company Settings > PO Settings tab. Select the Include Tax in Inventory Value checkbox.

 

Fixes

The following issues have been resolved in Update 5:

Inquiries

When resizing an inquiry window, the contents displayed could change.

In some cases, Inquiries could quit unexpectedly when the inquiry window had been maximized and the inquiry was left open for extended periods of time.

Contracts

While creating a macro to move closed contracts from current to history, the Contracts application quit.

Crystal Reports

When run from Sage Timberline Office report menus, Crystal Reports that used subreports to access Microsoft Access Databases would quit unexpectedly.

Inventory

Due to and due from prefixes are now retrieved correctly when transferring inventory between locations using the Enter Stock Transfers task.

Payroll

Employee totals moved from current period to prior period after upgrading to 9.6.0 Update 4.

Project Management

Approved Commitment Change Orders where the Revise Commitment checkbox was not selected caused the Commitment Change Order amount to not be included in the detail portion of the Subcontracts with CO detail report.

In some cases selecting Printer setup when printing would cause Project Management to appear to be locked up.

In some cases copying and pasting into the Commitment Scope window caused Project Management to appear to be locked up.

In some cases when viewing Change Orders within Project Management, the change order total displayed did not include the add-ons.

Pasting the job number into the Transmittals Job field caused Project Management to quit unexpectedly.

After installing Accounting & Management Update 5, customer-created custom logs no longer displayed and could not be accessed.

Property Management

Next fee date was changing on leases that should not have late charges assessed yet. The Next Fee date is now updated correctly when generating late fees.

You are now able to enter prepayments in Enter Cash Receipts and distribute the prepayments to two different leases.

Purchasing

PO stopped when unconfirming an invoice or delivery docket. You are now able to unconfirm an invoice line after the invoice has been unposted.

In some cases clicking off of the purchase order entry grid while entering lines of the purchase order caused the error "POHeader:Cannot perform this operation on a closed dataset' to be displayed.

Orders could not be created if the requisition was imported when Job Cost does not use categories.

Importing requisitions into companies where Job Cost does not use categories caused errors.

Requisition totals are now updated when items or Job Cost Categories are not being used.

Requisition totals are now updated if the units are changed on a line of the requisition.

Service Management

Preventative Maintenance work order report now prints the To Do's correctly when the work order contains multiple pieces of equipment.

Submit an Enhancement Request

We value your feedback and know your great ideas will help make our products better. To that end, we have provided a forum for you to offer your comments and ideas about Sage Timberline Office. Submitted from within the product, your ideas are automatically routed to our Product Management team for consideration. You can also view other users' comments as well as track the status of your requests. It's a quick and easy way to stay connected and share ideas with your Sage Timberline Office team.

To open the feedback system, click Help > Sage Timberline Office on the Web > Submit Enhancement Requests. In Desktop, click Tasks > Sage Timberline Office > Sage Timberline Office on the Web > Submit Enhancement Requests.

Sage Installation Manager

The Sage Installation Manager lets you install software updates to numerous workstations from a single location. For example, you can install Sage Installation Manager on your server, and use it to install updates to each individual workstation on your domain. You may benefit from using the Sage Installation Manager to install Accounting updates. Find out more.

 

Return to top

Sage Timberline Office updates are cumulative. The following features and fixes are included in Update 4:

Update 4 Amended

This update fixes an issue found in Update 4. The Employee Year to Date amounts in the Yearly Totals, Quarterly Totals, and Monthly Totals tabs appear in the Prior period totals. This issue appears only in the user interface, and does not affect data or reporting.

Update 4

Cash Management

Edit Register Task Causes Cash Management to Quit
Attempting to use the Edit Register task (Tasks > Edit Register) under some circumstances caused Cash Management to quit. This issue has been resolved.

General

Crystal Reports
Attempting to open Crystal Reports from the Reports menu caused Crystal Reports to quit if the reports contained subreports that were linked to an Access database. This issue has been corrected.

Payroll

Government-Mandated Changes

Form 941 (Rev. January 2009)
Form 941 format has been revised. Note: The revised form is also available in 9.5 2009 Report Update 3.

Schedule B (Form 941) (Rev. February 2009)
Form 941 Schedule B has been revised. Note: The revised form is also available in 9.5 2009 Report Update 3.

Washington Quarterly Detail 5208B Form
The Sage certification number has been removed from the Washington state quarterly detail 5208B form. Note: The revised form is also available in 9.5 2009 Report Update 3.

Australian Payroll Government-Mandated Changes

Australian Payment Summary Changes
The Employee Setup > ETP Payment Summary tab has been renamed as the ETP/INB Payment Summary tab and updated to allow the entry of the PAYG payment summary—individual non-business (INB) lump sum payment A type.

The PAYG payment summary—individual non-business (INB) and PAYG payment summary—employment termination payment (ETP) printed forms and magnetic media format have also been revised.


Purchasing

GL Account Cannot be Changed
Changes to the General Ledger (GL) account on a requisition were not being saved. This issue has been corrected.

Return to top

Update 3

General Ledger

GL Batches by Prefix Report
Printing or previewing the GL Batches by Prefix reconciliation report from the Reports > Reconciliation > Batches by Prefix menu caused General Ledger to quit. This issue has been resolved.

Payroll

Hawaii Quarterly Report
Printing or previewing the Hawaii state quarterly form from the Reports > Government Reporting menu caused Payroll to quit. This issue has been resolved.

Project Management

Import Estimate Option Not Allowing Blank Unit Description
When importing an estimate in Project Management, if there was a unit description in Estimating but the corresponding unit description field in Job Cost was blank, Project Management would not import the estimate. Now, Project Management will import the estimate if the corresponding unit description field in Job Cost is blank and will use the unit description from Estimating.

Adding More Than 1,000 Characters in Scope Field Caused Project Management to Quit
Adding or pasting more than 1,000 characters in the Scope field from the Setup > Jobs menu caused Project Management to quit. This issue has been resolved. Project Management no longer allows you to add or paste more than 1,000 characters in the Scope field.

Change Order Not Totaling Change Request Correctly if Categories Not Used in Job Cost
When viewing a change order from the Contract Controls > Change Orders menu, individual change request items did not reflect the add-ons in the total if categories were not used in Job Cost. This issue has been resolved.

Purchasing

Unconfirming Line Items Caused Purchasing to Quit
Unconfirming a line item after unposting an invoice from the Tasks > Enter Invoices menu caused Purchasing to quit. This issue has been resolved.

Report Designer

Changing Print Options Caused Report Designer to Quit
Using File > Page Setup > Print Options and selecting the Print to File > Save As option caused Report Designer to quit. This issue has been resolved.

Update 1

Payroll

Form 941 (Rev. January 2009)
The revised Form 941 (Rev. January 2009), originally issued in Software Notice 09-K, has been included in this update. The revised form is required for the first quarter of 2009.

Schedule B (Form 941) (Rev. February 2009)
The revised Schedule B (Form 941) (Rev. February 2009), originally issued in Software Notice 09-K, has been included in this update. The revised form is required for the first quarter of 2009.

Wisconsin Quarterly Magnetic Media
A carriage return/line feed (CR/LF) has been added to the end of each record in the Wisconsin state magnetic media file.

Return to top

Additional Support

Online Support Request

If you would like assistance with a solution and your service plan provides online technical support:

  1. Log on to https://customers.sagenorthamerica.com/irj/portal/anonymous/login.

  2. Click Self Service > My Requests > Customer Support Ticket.
    This sends your request directly to Customer Support.

Phone Support

In the U.S. or Canada, call 800-551-8307. Support hours are Monday through Friday from 6 a.m. to 5 p.m. PT (Pacific time).

Upgrading Your Service Plan

If your service plan does not provide online technical support and you would like to add or upgrade a service plan:

  1. Call 800-858-7098, or log on to https://customers.sagenorthamerica.com/irj/portal/anonymous/login.

  2. Click Self Service > My Requests > Customer Service Request.

 

© 2011 Sage Software, Inc | All rights reserved | Copyright/Trademarks.

This e-mail is considered a transactional or relationship message, which is specifically excluded from the federal law regulating e-mail communication.

Sage Timberline Office
15195 NW Greenbrier Parkway
Beaverton, OR 97006