TimeCardWorksheetImportBusinessRulesCheck

(Version 9.5.0.3)  

A new Tailored Solution framework has been added for the Time Card Worksheet screen which allows for business rules and exceptions to be validated on all the entries BEFORE the import process will be carried out.  If any exceptions to the business rules are discovered, the import process will be canceled and the time card items will need to be corrected before the import can be carried out. The following information documents the steps needed to set up this new feature:

•The new Advanced Settings Feature entitled TimeCardWorksheetImportBusinessRulesCheck must be enabled using the Advanced Property Settings Button on the Company Configuration.

•The new company based stored procedure should be tailored to add specific business rules for  your company that you would like to be enforced BEFORE allowing timecards to be imported.  The new stored procedure is called sp_ab_TCWorkSheetImportRulesCheck and must be tailored under the CLASS 113000 - Company Based Stored Procedures.  This procedure is designed to return an error code and error message when the rules are violated.  The error code must be a negative number and the error message will be displayed to the user if the routine is canceled.  If the rules are in order, then the error code should be returned as zero.

•The time card worksheet report for exceptions should be modified so that the business rule violations can be identified by the payroll manager when the import process is stopped.  This report can be found in the MAR Reports screen under the Payroll Forms section for class 265.

•IMPORTANT NOTE on Salary Pay Amounts: When this setting is enabled, the Distributed Salary and Mobile 40 Hour Salary calculations are DISABLED during the time card import routine.  If you use these types of Salary Pays, then the tailored process will need to compute the salary amounts.

•When this setting IS enabled, the IMPORT option for the the time card worksheet screen now creates a new user table containing a copy of all the records to be imported.  This table is called AB_TCW_ImportRecList and is used for enforcing business rules during the import process.