Version 9.7.0.0 Navy - December 4, 2018

JOB COST

•ENHANCEMENT - Production Units by Detail Item Report - Partial Job List Expansion - [PMID Ref No: 10677]

The partial run job list was limited on the MAR report entitled Production Units by Detail Item Report and the stored procedures that work with this report have been updated to double the number of jobs allowed on the partial run list.  Two stored procedures were updated to expand the job list as listed below:

oabm_Get_DPU_BidItemMasterRecs_Lookup

oabm_Get_DPU_BidItemMasterRecs_FullDetail_Lookup

MY ACCUBUILD REPORTS

•CORRECTION - MAR Report Fix

The MAR Report entitled Payroll Check Detail Reconciliation Report - Trans Date (PRREP14D.644) was updated with a fix for the ETT Burden field on this report which was showing a blank value.

PAYROLL

•NEW FEATURE - Import Timecard Worksheet - [PMID Ref No: 10601]

A new advanced setting has been added for the TimeCard Worksheet Import process that will override the grid filter settings whenever the records are imported with a filter set on the timecard worksheet grid.  This new setting will help to insure that the filtered record list is maintained during the import process even when a tailored solution may be modifying some of the field values in the timecard worksheet table.  This is very useful if you are using column filters that will be changed during the import process.  This setting will prevent records from being excluded from the import process because of a change of a filtered field’s value.  For example, if a filter is set for union code = 100 during the import, and a tailored solution exists that would change the value of the union code to 200, the new field value of the union code would prevent the record from being imported because it no longer has 100 as the field value.  This setting will cause a test to be run, and if a filter is set, the filter method will be changed to use the record ID of the filtered records so that any changes will NOT affect the records being imported.  To enable this new feature use the new advanced setting entitled UseTCWorksheetFilterByRecID

•NEW FEATURE - Payroll Tax Calculations Business Rules Update - [PMID Ref No: 10057]

A new Advanced Setting entitled CancelTaxCalcsOnZeroAmountPayTrans has been added to the AccuBuild Program for implementing additional business rules that need to be met before the tax calculations can be performed.  This setting is necessary for companies that are using tailored solutions for timecard worksheet imports where additional timecard records are being created during the import process that could contain pay transactions with zero amounts.  When this setting is enabled, the system will validate all pay transactions amounts and cancel the tax calculation process if any zero amount transactions are discovered so that they can be corrected before continuing with the tax calculations. [PMID Ref No: 10057]

•NEW FEATURE - Payroll Burden Out of Balance Check - [PMID Ref No: 10057]

A new routine has been added to the payroll posting process that will check each pay transaction record to make sure that the payroll burden amounts are in balance.  The payroll burden amounts include the UNION_AMT (union burden), COMP_AMT (workers comp insurance burden), LIAB_AMT (liability insurance burden), and the payroll tax burden which is made up of FICA (Employer portion of Social Security and Medicare) , ETT (Employment Training Tax), FUTA (Federal Unemployment Tax) and SUI (State Unemployment Tax).  All of these burden amounts are summarized in the BRDN_AMT field of the pay transaction records and if sum of these burden fields do NOT match the total in the BRDN_AMT field, an error message will be generated to show the record information including the employee number and check number.  In addition, the error message will be logged in the posting process user activity file for look-back reference.

NOTE: If out of balance burden amounts are encountered, the payroll posting process will NOT be canceled and the entire batch of checks will be processed.  If you encounter this error, you will most likely need to void the problem payroll check(s) and re-issue those checks after determining the cause of the problem.  These types of out of balance burden errors are very rare and are usually related to tailored solutions that are set up for the timecard worksheet import processes and payroll posting processes.