M9-TC-1010 Piecework for Payroll & TimeCard

From BlythecoDev Wiki

Jump to: navigation, search



This Custom Solution to the standard TimeCard for MAS 90 MAS 200 module adds the ability to have an employee’s wages calculated ‘by the piece’ while still continuing to track hours worked via two different calculation methods.

Sage Software Custom Solution TC-1011: User Defined Fields for TimeCard must be installed and enabled in order for the ‘Comparative Method’ calculation to function.

Additional functionality exists when TC-1045: Employee Rate or Cost Code Rate By Cost Code is enabled.


Before installing any Custom Solution, please verify that the version level referenced on your installation file is the same version level as your Sage 100 (MAS 90 MAS 200) installation. (For more information please call (800) 425-9843). It is recommended to have a complete and tested backup prior to installing any application on your Sage 100 (MAS 90 MAS 200) platform.

Custom Solutions Control Center

Installing any Custom Solution will add an Custom Solutions Control Center to the Sage 100 (MAS 90 MAS 200) Library Master Utilities menu. When you open the Control Center, the following options will be available:

  • Merge Installation Files
  • Custom Solutions Setup options

Custom Office

If you customize your Sage 100 (MAS 90 MAS 200), then you must run the Update Utility every time you install this Custom Solution.


Upon completion of software installation, you will need to access the TimeCard Setup menu option screen. After the standard MAS 90 MAS 200 option screens have been displayed, a Setup screen for this Custom Solution will appear. Check the ‘Enable Custom Solution box to activate this Custom Solution (Figure 1).

TC-1010 Setup Options
Figure 1

Answer the following prompts:

DECIMAL PLACES FOR NUMBER OF PIECES: Enter the number of decimal places for Number of Pieces. The resulting numeric mask will be displayed next to the entry.
POST UNITS AS # OF PIECES OR AS HOURS: Select ‘# of Pieces’ or ‘Hours,’ depending on how you would like units posted to Job Cost.
PAY AMOUNT CALCULATION: Select ‘Comparative Method’ or ‘Pay Rate * # of Pieces.’ See Operations for definitions. If ‘Comparative’ is selected, the user will be prevented from editing the Custom pay amount of any TimeCard Entry. If you selected ‘Comparative Method’ you will have access to the following Setup options:
DEPARTMENT FOR ALTERNATE CALCULATION RULE: Enter the Department to be the exception to the ‘either Piece Rate or Hourly Rate’ rule. This department will get paid both rates.
PREMIUM PAY EARNINGS CODE FOR OVERTIME: Enter the Earnings Code you would like to use to hold the calculated Premium Pay for Overtime. It must be of type ‘F’ixed.
DEPARTMENT WITH DAILY/WEEKLY RULES: Enter one department for which the Daily/Weekly rules will be applied.

If you have defined a 'Department with Daily/Weekly Rules' then you will access to the next Setup question and must answer it:

PREMIUM PAY EARNINGS CODE FOR DOUBLE TIME: Enter the Earnings Code you would like to use to hold the calculated Premium Pay for Double Time. It must be of type Fixed.

If you selected ‘Pay Rate * # of Pieces’ you will have access to the following Setup option:

APPLY OVERTIME RULES: Check this option to create overtime entries using standard

MAS 90 MAS 200 processing. It will only be used if you have enabled TimeClock.

You should visit this Setup screen after each upgrade or reinstallation of this Custom Solution.


TimeCard Entry
A new field has been added to the TimeCard Entry screen for ‘Number of Pieces’ (Figure 2). During TimeCard Entry, when a value is entered into this field, the entry’s Pay Amount will be determined based on the Pay Amount Calculation selected in Setup.

TC-1010 TimeCard Entry and Edit
Figure 2

‘Pay Rate * # of Pieces’ Calculation
The entry’s pay amount is determined by multiplying the Pay Rate by the Number of Pieces. If the Number of Pieces is left blank, standard MAS 90 MAS 200 processing will determine the Pay Amount for that entry. The hours worked field will still be available for entry.

If 'Apply Overtime Rules' is unchecked, and a regular hours entry is generated where a portion of the time puts the user into overtime, a regular entry will be created with the full Number of Pieces entered, and the Custom pay amount will not be altered. The Overtime entry will be created with the number of hours it would normally contain, with zero pieces and zero Custom-pay amount.

If only an Overtime entry is to be generated, it will contain the full Number of Pieces entered, the pay rate will be determined per standard processing, and the Custom amount will be calculated to be the number of pieces times the pay rate.

If ‘Apply Overtime Rules’ is checked, overtime pay will be calculated on the hours worked using the Employee Pay Rate associated with the overtime Earnings Code. There will be no access to the ‘Number of Pieces’ field for overtime entries.

If you elected to ‘Apply Overtime Rules,’ this assumes that the Pay Rate field will always be overridden in data entry for a Piece Rate record.

Hours Worked Entry
If TimeClock is not enabled and the Pay Amount Calculation is ‘Pay Rate * # of Pieces,’ then a new button will be available in TimeCard Entry and Edit for ‘Hours Worked’ (Figure 2). The button will be available once an employee number has been specified. When clicked, the user will be presented with a screen for ‘Hours Worked Entry' (Figure 2a) which allows for rapid editing of the hours worked field for all existing entries which have not been posted to Payroll. In a grid format, it lists the employee’s entries with four columns: Date Worked, Sequence, Number of Pieces and Hours Worked. The only field available for entry is the Hours Worked column. No new entries can be made.

When finished, the user will click Accept and all of the TimeCard entries will be updated with the new hours.

TC-1010 Hours Worked Entry

TC-1045, Employee Rate or Cost Code Rate By Cost Code
If you have TC-1045 enabled and are using the ‘Pay Rate * No. of Pieces’ method, access to the ‘Number of Pieces’ field will be disabled as TC-1045 determines it should use the Employee's Pay Rate for the entry. If the entry is using the Cost Code Rate, then the ‘Number of Pieces’ field must be greater than zero in order to accept an entry.

‘Comparative Method’ Calculation The entry’s pay amount can be either Piece Rate or the Employee’s Hourly Rate, depending on which is higher. You will have access to the ‘Number of Pieces’ field as well as an additional ‘Per Thousand Piece Rate’ field.

During data entry, you will enter data in the following TimeCard fields: Employee Number, Date Worked, Job Number, Cost Code, Hours Worked, Piece Count and Per Thousand Piece Rate.

The following calculations will be performed to determine the Pay Amount:

a) Regular TimeCard processing of Hours * Rate = x
b) (Piece Count/1000) * Piece Rate = y
c) x and y are compared, and whichever is higher = z
d) Pay Amount is set to z

There is one exception to the ‘either Piece Rate or Hourly Rate Rule.’ The one Payroll Department, specified in Setup, will get paid both the Piece Rate and the Hourly Rate. That department will have sent to Payroll, as a daily entry, the following:

  • Total Hours Worked
  • A Total Pay Amount, which is defined as:
(Pay Rate * Hours) + (Piece Count/1000 * Piece Rate)

In addition, you are expected to have set up two Numeric Type UDFs in Sage Software Custom Solution TC-1011: User Defined Fields for TimeCard. (Figure 2b).

TC-1010 User Defined Fields

  • UDF #1 will be called ‘Price;’ the user will enter data in this field
  • UDF #2, ‘Sales,’ is a calculated field: (UDF #1 * Total Pieces)/1000 = UDF #2

These fields will be used in the ‘Weekly Payroll Detail Report’ (see Reports, below).

Job Cost Interface
Depending on how you answered the Setup question ‘Post Units as # of Pieces or as Hours,’ when the Job Cost Selection is performed, either the TimeCard entry’s Hours Worked or the Number of Pieces will be sent to Job Cost. The rate and amount fields will be used as they normally would.

Payroll Interface
The interface between TimeCard and Payroll will be operationally unaffected by this Custom Solution. The Number of Pieces will not transfer to the Payroll module; the Hours Worked will transfer as per standard TimeCard, and Payroll will ‘back-calculate’ an average hourly pay rate by dividing the Custom Pay Amount by the Number of Hours.

Timecard Premium Pay Utility
This utility is available only if you selected the ‘Comparative Method’ in Setup.

This utility is available as a new menu option. When you select it, you will be prompted for a range of Employees and a Week Beginning Date (Figure 3). That date will be auto-incremented by six and the result placed in the Week Ending Date field.

TC-1010 TimeCard Premium Pay Utility

When you click the ‘Proceed’ button, the utility will locate all Employees with open TimeCard entries that total more than forty hours within the date range specified. A Premium Pay Rate will be calculated for these employees.

Premium Pay Rate is defined as: Average Hourly Rate * .5
Average Hourly Rate is calculated as: Total Weekly Pay Amount/Total Hours Worked

The Premium Pay Rate is multiplied by the number of weekly hours over forty.

The employee has worked 43 hours in the Date Range specified.
The Total Pay Amount is $358 for that same Date Range.
Average Hourly Rate: $385/43 = $8.326
Premium Pay: $8.326 * .5 = $4.163
43 Hours – 40 = 3 hours
3 * $4.163 = $12.49

A TimeCard entry using the Earnings Code specified in setup is created for $12.49.

A register will print, listing all Premium Pay entries created (Figure 4).

TC-1010 TC Premium Pay Utility

The ‘Existing PP Entry’ column will report any existing TimeCard entries with the specified Premium Pay Earnings Code (from Setup) that the utility found for that Employee in that Date Range. The ‘Expected Premium Pay’ column will report what this generation of the utility predicts the employee is owed (Premium Pay Rate * Hours Worked over 40). The ‘Create PP Entry’ column will report what will be posted as an entry to TimeCard.

Once the register has completed printing, you will be prompted to update. The update will create a Premium Pay entry in TimeCard for the amount printed in the Premium Pay Entry column, using the Setup-specified Earnings Code. There will be no hours associated with this entry. The date on the entry will be the Ending Date from the utility selection screen.

Generally, the first column of the report will be zero, and the next two will hold the same value. It is only when the utility is run a second time for the same, or overlapping, date range and there have been changes to the TimeCard entries that affect calculation. If so, then the amount in the Expected Premium Pay column will move to the Existing PP Entry column. The newly-calculated amount will appear in the Expected Premium Pay column, and the difference between the two will print in the last column, to become an additional Premium Pay TimeCard entry.

Department With Daily/Weekly Rules The Premium Pay Utility will be modified to perform a different Premium Pay Calculation for those employees whose home department matches the Department specified in the new ‘Department With Daily/Weekly Rules’ Setup question.

Processing will consider

  • all daily hours between 8-10
  • and all weekly hours (not already counted as daily excess) between 40-50 as overtime hours and use the standard Premium Pay calculation
  • all daily hours in excess of 10
  • and all weekly hours (not already counted as daily excess of 10) in excess of 50 as double time hours. Double Time hours will use the Premium Pay rate for those hours that meet the Double time standard. The result of the Double Time calculation will be placed in the fixed type Earnings Code specified in Setup for Double Time

The following is an example for an employee who belongs to the department flagged as the ‘Daily/Weekly Rules Department’ and who worked 8 hours a day for all seven days of the week. His Total Hours come to 56. Regular Hours are 40, OT Hours are 10, and DT Hours are 6.

If the employee’s Total Pay Amount for that week came to $1200, then the OT EA code would contain $107.10, calculated as

$1200/56 = $21.42
$21.42 * .5 = $10.71
10 * $10.71 = $107.10

and the DT Earnings Code would contain: $128.52, calculated as

6 * $21.42 = $128.52

The report will print one line for Overtime hours, and underneath it, a line for Double Time hours (Figure 5).

TC-1010 TimeCard Premium Pay Utility

The TimeCard Report Each sort option available on this report has been enhanced to print the Number of Pieces for each applicable entry. A new ‘Print Number of Pieces’ option (Figure 6), accessible via the ‘More…’ button, is available from the selector screen (Figure 7).

TC-1010 Report Selections
Figure 6

TC-1010 TimeCard Report

You can select ‘Print Pieces’ to print the number of pieces entered (in the column where ‘Hours Worked’ normally prints), ‘Print Hours Worked Only’ (the default) to print Hours Worked only or ‘Both’ to print Number of Pieces when it is not zero and Hours Worked otherwise. See (Figure 8) for an example of the report.

TC-1010 TimeCard Report

Average Hourly Pay Report
A new ‘Print Pieces’ option (Figure 9), accessible via the ‘More…’ button, is available from the selector screen (Figure 10).

TC-1010 Report Selections

TC-1010 Average Hourly Pay Report

This report will have two new columns for ‘# of Pieces’ and ‘Pieces Per Hour’. See (Figure 11) below for an example of the report.

||TC-1010 TC Average Hourly Pay Report

Factory Norm Report
This is a new report that is available only if both this Custom Solution and JC-1065: Factory Norms by Cost Code are installed. This report is available in three sort orders: Job Number/Employee Number/Cost Code, Job Number/Cost Code/Employee Number and Employee Number/Job Number/Cost Code (Figure 12).

TC-1010 TC Factory Norm Report

If TC-1011: User Defined Fields for TimeCard is installed and enabled, this report can be selected by ranges of UDFs, accessible via the ‘More’ button. The reports run in summary fashion only. (See figures 13, 14 and 15 for examples of the reports.)

TC-1010 TC Factory Norm Report

TC-1010 TC Factory Norm Report

TC-1010 TC Factory Norm Report

Weekly Payroll Detail Report
This is available only if you selected the ‘Comparative Method’ in Setup. This report details, for each employee selected, TimeCard Entries for the specified date range. The selection criteria for this new report will be Beginning and Ending Employee Number, and Beginning and Ending Date (Figure 16).

TC-1010 Weekly Payroll Detail Report

The report will print in Employee Number order, page-breaking by Employee. It will print one line for each TimeCard entry in the date range selected (Figure 17) detailing the following:

Job Number
Customer Number
Cost Code Description
Number of Pieces
Number of Hours
Hourly Pay Rate
Piece Rate
Calculated Hourly Pay (Number of Hours * Hourly Pay Rate)
Calculated Piece Pay (Number of Pieces/1000 * Piece Rate)
Price (TC-1011 UDF 1)
Sales (TC-1011 UDF 2)
Premium Pay

TC-1010 Weekly Payroll Detail Report

Each entry will always reflect data in all the columns except ‘Hourly Pay,’ ‘Piece Pay’ and ‘Premium Pay.’ In the first two, only one or the other entry will be reflected; the other column will contain a zero. The program will calculate which one was used for that entry. The calculation will return the appropriate Custom pay amount information to the report. The exception to this is the ‘One Department for Alternate Calculation’ defined in Setup; those employees will have both of the columns filled in. A ‘Premium Pay’ TimeCard entry will have zeroes in all columns except the Premium Pay column.

The following columns will sum: Number of Pieces, Number of Hours, Hourly Pay, Piece Pay and Sales.

A Totals Section will sum the following:

  • Regular Pay (Hourly Pay + Piece Pay)
  • Overtime Pay (the sum of all Premium Pay entries)
  • Total Gross Pay (the sum of Total Regular Pay + Total Overtime Pay)
  • The Employee’s Hourly Rate (Pay Rate 1 from the Employee Masterfile)
  • Average Hourly Rate (Total Pay for the date range / Total Hours for the date range)
  • Total Quantity (Total of the Number of Pieces column)
  • Profit (Total of the Sales column – Gross Pay)

Helpful Hints

  • On the Factory Norm Report the following calculation take place:
Pieces Per Hour: # of Pieces/Hours Worked; the resulting value is rounded to the number of decimal places in the mask before printing.
Factory Norm: When sort option 2 is selected, this simply is the factory norm for the cost code as entered in Job Masterfile Maintenance. When using sort option 1, this same value is used on the Cost Code Line itself, but the total and subtotal lines use the simple mean of the Factory Norms of the cost code lines. This means that the total pieces per hour will equal the total # of pieces/total hours worked.
Percent (%) of Factory Norm: This is calculated as the Pieces per Hour/Factory Norm * 100.
Note: The Pieces per Hour value used in the calculation is the full rate to 6 decimal places, not the rounded value as printed.

Visual Integrator

The files listed below have been added or changed in the Data Dictionary by this Custom Solution for Visual Integrator purposes.

TC-1010 Visual Integrator

The Data Dictionary may contain other files and data fields that are not available without their corresponding Sage Software Custom Solutions installed.

Crystal Reports and the ODBC Dictionary

The files listed below have been added or changed in the ODBC Dictionaries by this Custom Solution for Crystal Reports purposes.

TC-1010 ODBC Dictionary

Be aware that the ODBC Dictionaries may contain other files and data fields that will be unavailable without their corresponding Custom Solutions installed.

What’s New

With the 05-25-05 release:

  • Added ‘Hours Worked Entry’ grid to TimeCard Entry and Edit.

With the 10-05-04 release:

  • If TC-1045 is using cost code rate, then the number of pieces entered must be greater than zero.
  • If TC-1045 is enabled then Earnings Code / Cost Code combination will use employee's pay rate, and access to piece rate field will be disabled.

Upgrades and Compatibility

The installation CD is labeled with the version of the MAS 90 MAS 200 module for which this Custom Solution was prepared. This Custom Solution will check its compatibility with the appropriate MAS 90 MAS 200 modules and will be disabled if an incompatibility is found. If you upgrade your MAS 90 MAS 200 modules, this Custom Solution must be upgraded as well. Your MAS 90 MAS 200 dealer can supply this upgrade.


Only changes made by Blytheco, LLC to the standard operation of Sage Software, Inc. MAS 90 MAS 200 have been documented in this manual. Operations not documented in this manual are standard procedures of MAS 90 MAS 200 processing. Standard MAS 90 MAS 200 processes, data entry screens, inquiry screens, reports, updates, etc., have not been changed unless addressed in this document.

Parts of this document may refer to the Specific Purpose Rule. When referenced, the described feature was developed for a specific client to its specifications and may not conform to generally accepted MAS 90 MAS 200 standards and procedures. These features may or may not benefit you in your application of MAS 90 MAS 200.


Copyright © 2010 Blytheco, LLC. MAS 90 and MAS 200 are registered trademarks of Sage Software, Inc.

Revision Note: 4.4

Personal tools
MediaWiki Appliance - Powered by TurnKey Linux