Home      Ask a Question      My Stuff      Help   
  
Converting Numeric Clock Prompts into a Pay Item
Most numeric values (non-hours) that need to be collected and totaled on the time card are normally gathered with a Numeric Clock Prompt (I, J, K, Web Only Numeric). These prompts would be used for items like:
• tips
• mileage
• piece work
Some payroll platforms support mapping of these categories through the file format. That means you can use File Format Maintenance to instruct TimeWorksPlus to export the numeric prompt totals in a certain place on the Download Activity File.

However, if your payroll platform does not support mapping these numeric clock prompts, you may need to convert them to a Pay Only category on the time card. This conversion would need to be done through a script. Below is an example case involving Tips and how we can take a tip value, entered by the employee at the clock, and change it into a pay item on the time card so it exports as a Punch Category called “Tips”.

In addition to the script, you will need:
• a numeric clock prompt for the tip entry that is collected on the out punch. You can call this prompt whatever you want, but for this example, we will use the Field Name of tipPrompt.
• a Punch Category to which the script will copy the clock prompt values. This needs to be setup in the Processing Rules page under Processing/ Punch Categories. Click the Add button at the bottom of the page to create the new category.
o Name of the category is Tips.
o User Selectable should be set to No
o In the Amount Collection column, select Pay from the dropdown
o Hour Collection set to None. The end result will be an additional row on the time card with the tips under this category.
• The following scripts
Note, if you use different field names/category names than this example, you will need to alter your script.

Next you will need to add the following scripts in the corresponding script rule boxes. These are founding in the Scripting category of the Processing Rules page.

AddEntryScript


if(reportingdate.totalday("tipPrompt") > 0){
addentry("amount", reportingdate.totalday("tipPrompt"), "Tips");
}
ID
1682
Category
>Support
  Scripting
Date Created
10/2/2015 8:42:28 AM
Date Updated
10/7/2015 8:05:02 AM
Back to Search Results