Note: You must track vacation/sick pay units as pays for this solution to provide the expected results. If you do not, contact your business partner or solution provider for assistance.
Create a year-to-date vacation hours formula to report unused vacation hours:
- From the Tools menu, select Formulas.
- Use the example formula (below) as a guide to create the formula for your company.
Note:
- The 5 in the example formula indicate that the pay IDs are setup as Accrual pay types. (Use 1 for Regular pay types, 2 for Overtime pay types, 3 for Other pay types, 4 for Reimbursement pay types, and 5 for Accrual pay types.)
- "VAC EARNED" represents the pay ID used to accrue vacation hours.
- "VAC TAKEN" represents the pay ID used to take vacation time.
YTD Vacation Balance
LOOKUP (YTD Units [PR Employee Pay], Employee [PR Check], 5, "VAC EARNED") - LOOKUP (YTD Units [PR Employee Pay], Employee [PR Check], 3, "VAC TAKEN")
Add the YTD Vacation Balance formula to your Payroll check format:
- In From the Tools menu, select Modify Forms, Check Forms.
- Select the applicable Check Form.
- Select the Earnings tab (For Short or Extended stubs) or Deducts, Taxes & Fringes tab (for Standard stubs).
- Select the YTD field and click Formula
- Select the formula you created above and click OK and Close.
Notes :
- You must change the vacation pay IDs and pay types in the example formula to exactly match the vacation pay IDs and pay types your company uses.
- For vacation pay dollars, change the formula to look up YTD Pay instead of YTD Units.
- This formula retrieves the vacation hours accrued year-to-date (YTD) and subtracts the vacation hours taken for this employee YTD.
- Lookup formulas that retrieve year-to-date amounts for the employee automatically include the current check amount.
- If you previously used Automatically prefill earnings/Automatically prefill employee-paid taxes and deductions you will need to manually add the earnings or employee-paid taxes and deductions. See attached article 24246 "How do I add totals for pay, deductions, taxes and fringes to Payroll check stub and direct deposit notifications?"
Important: The sample check forms that come with Sage 300 Construction and Real Estate may not be fully compliant with all federal, state, and local laws and other requirements, which can differ from one jurisdiction to another. It is your responsibility to familiarize yourself with all applicable laws and requirements, and to modify your check forms as needed to ensure compliance.