Summary
What tables is the tax info information held
Where does Sage HRMS post the employee tax withholdings
Tax info Sage HRMS
Employee withholding status
Number of tax exemptions
Employees tax exemptions
Description
Cause
Resolution
Taxes are stored in UPEMPT however the tax fields (marital status, exemptions, etc) are in UPEMTF and the field or values are coded based on the tax. So the two fields you need to note are PARMSEQ and PARMVAL. The PARMSEQ is a numerical value that increments with each tax or person and corresponds with the fields on the screen (same order). If you open Tax info button on the Employee Payroll detail for USFIT, you will see 7 parameters, and in the database you will find each the for the employee that USFIT has 7 PARMSEQ.
The PARMVAL is the value in the field. For exemptions it is easy 1=1, 2=2 etc. but for other items like marital status, it is the same order as the drop down menu that you choose from (differs from tax to tax).
Example:
Lets say you wanted to add the number of exemptions on the USFIT tax code to a Crystal report, to do this you would create a formula field in Crystal using the below:
- Set TAXID=USFIT, PARMSEQ =2 as conditions of the formula field and then use the value of PARMVAL
- If TAXID="USFIT" and PARMSEQ="2" then PARMVAL