M9-PR-1030 Employer Taxes (Actual) Posted to Job Cost

From BlythecoDev Wiki

Jump to: navigation, search



This Custom Solution to the standard MAS 90 MAS 200 Payroll and Job Cost modules allows the Employer portion of Payroll taxes (including FICA, Unemployment, Medicare and Workman’s Compensation) to be posted to the Job Cost module. The Job Labor Distribution Report has been enhanced to report the tax amounts. Taxes are summarized by Job Number/Cost Code/Employee Number/Earnings Code. A Setup option is available to post the taxes to the G/L Accounts set up in Job Cost. Refer to the Operations section of this manual for explanations of the tax calculation methods.


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 Payroll 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. Select this part number and the Setup screen for this Custom Solution will appear (Figure 1). Check the ‘Enable Custom Solution’ box to activate this Custom Solution.

PR-1030 Setup Options

Answer the following prompts:

COST CODE FOR PAYROLL TAXES: Enter the Cost Code for Payroll Taxes. If you leave the Cost Code blank, then the cost code from Payroll Data Entry will be used. If you enter a Cost Code, only Cost Types that are active for that Cost Code may be entered. If you leave the Cost Code blank, any defined Cost Type may be entered.
COST TYPE FOR PAYROLL TAXES: Select a Cost Type for Payroll Taxes from the drop box. If you select ‘None,’ the ‘Labor’ Cost Type will be used.
USE JOB COST ACCOUNT(S) FOR TAXES: Check this box to post taxes to the G/L Accounts set up in Job Cost.
POST TO JOB COST IN DETAIL: Check this box to break the tax postings from Payroll into five entries: FICA, FUTA, SUTA, Medicare and Worker’ Comp.
SPECIFY COST TYPE BY TAX TYPE: When ‘Post to Job in Detail’ is checked, ‘Cost Type for Payroll Taxes’ is set to ‘None’, and 'Post to J/C in Detail' is checked you will see five additional fields of entry to define a Cost Type for each of the following: FICA, FUTA, SUTA, Medicare, and Workers Comp.
CALCULATE WORKER’S COMP AS IF IT WERE ONLY LINE ON CHECK: If this box is checked, for each earnings code line in payroll that has a job number and workers comp code, the Worker’s Comp amount posting to job cost will be calculated as though it were the only line on the check.

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


The Job Labor Distribution Report (appears as ‘Labor Distribution Report’ on the Payroll main menu), includes new columns for the Payroll tax amounts (Figure 2).

PR-1030 Job Labor Distribution Report

The tax amounts are calculated in two different ways. The FICA, Unemployment and Medicare amounts are calculated on a Payroll line-item-by-line-item basis. The tax amount calculated for each item will be the exact portion of the total tax for the employee associated with that line item. The Workman’s Compensation tax is calculated on a percentage basis. The percentage is calculated as the pay amount against the wages subject to tax for that State/Workman’s Compensation Code. This percentage is then applied to the total tax for that State/Workman’s Compensation Code. Due to this percentage calculation, it is possible for the total of the individual tax amount to vary slightly from the Total Tax amount on the Employers Expense Summary Report.

Though the Job Labor Distribution Report will detail the individual tax amounts by type (e.g. FICA, Medicare), the taxes post to Job Cost as a total.

If you do not enter a Cost Code during Setup, then the Cost Code entered during Payroll Data Entry will be used. If the resulting combination of Cost Code/Cost Type is not active, you will not be able to update the Daily Job Transaction Register. An Error Log will be printed indicating the inactive combination, and you will have to resolve the problem before the update will be allowed. (This is standard in MAS 90 MAS 200 and is not affected by this Custom Solution.)

When the setup question ‘Use Job Cost Accounts for Taxes’ is checked, the taxes on the Daily Transaction Register will post to the G/L Accounts set up in Job Cost. The original postings from the Payroll Department will still post, but there will be a reversal line with the posting comment, ‘P/R Taxes To Job Cost – PE: {date}’ to offset the original tax postings.

When setup question ‘Post to Job Cost in Detail’ is checked, the tax postings from Payroll will be broken out into five entries by employee number: FICA, Federal Unemployment, State Unemployment, Medicare, and Workman’s Comp. The posting comment per cost code in Job Transaction Detail will be:

Reference/Posting Remarks

Employee #/Check Number/Date-FICA
Employee #/Check Number/Date-MED
Employee #/Check Number/Date-FUTA
Employee #/Check Number/Date-SUTA (*)
Employee #/Check Number/Date-WC

(*) SUTA is defined as all non-Federal Unemployment

The corresponding amount will be referenced in the ‘AMOUNT’ column.

We will also modify the method used to determine the Worker’s comp posting to Job Cost. If you check the box ‘Calculate Worker’s Comp as if it Were the Only Line on Check’ at Setup, for each Earnings Code line in Payroll data entry which has a Job Number and a workman’s comp code, the Worker’s Comp. amount posting to Job Cost will calculate as though that was the only workman’s comp line on the check.

When ‘Specify Cost Type by Tax Type’ is checked, Update to Job Cost will be modified to post to the Cost Type specified with the Tax Type, rather than all of them to the one Cost Type previously allowed.

Helpful Hints

If you check ‘Calculate Worker’s Comp as if it Were Only Line on Check’ in Setup, the amount of Worker’s Comp posted to Job Cost may not match the actual amount of Worker’s Comp.

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.

PR-1030 ODBC Dictionary Files for Crystal Reports

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

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