Note: These enhancements were included in the following Sage 100 versions: (PU=Product Update)

• 2016
• 2015 PU3
• 2014 PU7
• 2013 PU9

W2 and 1095 forms:

The "Sort Field" located in Employee Maintenance is now pulled into W2 grid in the "Sort Text" field and the "GROUP ID" field in the ACA Preparer

1. Open Payroll, Main, Employee Maintenance

2. In the Sort Field, type a sort code (this is a user defined field). This field provides an additional method of sorting employee information on reports. Most Payroll reports can be printed by employee number, Social Security number, or name sequence. They can also be sorted according to your own customized sort code. A common alternate sort field is work classification.

.

3. In the W2 grid, right click on the Sort Text column heading and click Sort rows by "Sort Text"

4. In the ACA Preparer, during the Employee Contact Information step, in the top left grid right click on GROUP ID column and select Sort rows by "GROUP ID"

1099 forms

The "Sort Field" located in Vendor Maintenance is now pulled into 1099 grid in the "Sort Text" field

1. Open Accounts Payable, Main, Vendor Maintenance
2. Select applicable venodr from look up
3. Click on the Additional tab, in the Printing section in the Sort field, type the information to use to sort reports (this is a user defined field). This field provides an additional method of sorting vendor information on reports. For example, you can enter an abbreviation of the vendor name in this field for alphabetic sorting, or you can enter an abbreviation of the vendor's industry to sort reports by similar types of businesses.

4. In the 1099 grid, right click on the Sort Text column heading and click Sort rows by "Sort Text"

Alternatively, you have the ability to sort by any column available in any of the grids above, by right clicking on the column header and selecting sort rows by .....