Print Accrued Benefits on Payroll Checks and Direct Deposit Stubs [Legacy]

Summary

Use Crystal Reports to add vacation, sick, or PTO accrual information to Sage 100 payroll checks and direct deposit stubs. These steps apply to Sage 100 2017 and earlier versions.

Resolution


CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

These steps are for informational purposes only.
Sage Customer Support does not provide assistance with form customizations.
If these steps don’t work for your check form, contact your business partner or a third-party consultant for assistance. 

CAUTION:

Always create a backup of your current check form before making changes. These steps require Crystal Reports experience.

 

NOTE:

Install Crystal Reports Designer so you can modify Crystal check forms.

 

Resolution

Add accrual fields to the check form

  1. Open Payroll, Main, Check Printing.
  2. Click Form to open the check form in Crystal Reports.
  3. Optional: Click Insert, then select Text Object.
  4. Optional: Draw a text box where you want the label to print.
  5. Type Vacation Available, then press ENTER.
  6. Repeat the previous steps for additional accrual descriptions.
  7. In Field Explorer, expand PR_31 CrystalCheckHeader.
  8. Drag the required fields onto the check form.

Vacation fields

Add any of the following fields:
  • VacationAnnualLimit
  • VacationAccrued
  • VacationUsed
  • VacationAvailable
  • VacationAccruedThisCheck

Sick fields

Add any of the following fields:
  • SickAnnualLimit
  • SickAccrued
  • SickUsed
  • SickAvailable
  • SickAccruedThisCheck

PTO or third benefit fields

Add any of the following fields:
  • ThirdBenefitAnnualLimit
  • ThirdBenefitAccrued
  • ThirdBenefitUsed
  • ThirdBenefitAvailable
  • ThirdBenefitAccruedThisCheck

Use formulas when needed

Vacation formulas

  • PR_31VacationAccrued = VacationAccruedThisCheck + PR1_VacationAccrued + PR1_VacationCarryover
  • PR_31VacationUsed = PR1_VacationUsed + vacation earnings used on the current check
  • PR_31VacationAvailable = PR_31VacationAccrued - PR_31VacationUsed

Sick formulas

  • PR_31SickAccrued = SickAccruedThisCheck + PR1_SickAccrued + PR1_SickCarryover
  • PR_31SickUsed = PR1_SickUsed + sick earnings used on the current check
  • PR_31SickAvailable = PR_31SickAccrued - PR_31SickUsed

PTO or third benefit formulas

  • PR_31ThirdBenefitAccrued = ThirdBenefitAccruedThisCheck + PR1_ThirdBenefitAccrued + PR1_ThirdBenefitCarryover
  • PR_31ThirdBenefitUsed = PR1_ThirdBenefitUsed + benefit earnings used on the current check
  • PR_31ThirdBenefitAvailable = PR_31ThirdBenefitAccrued - PR_31ThirdBenefitUsed

Add the fields to other stub sections

  1. Right-click the text object created earlier.
  2. Select Copy.
  3. Paste the object into each section where it must print.
  4. Copy and paste the corresponding PR_31 data fields into the same sections.

Save and test the form

  1. Click File, Save.
  2. Print a test check or stub.
  3. Verify that the accrual information prints correctly.

TIP:

If alignment is incorrect, select the field and move it with the keyboard arrow keys. You can also drag the field with your mouse.

  

NOTE:

These steps also work for payroll and direct deposit forms.

 

Related Solutions

How to find or access additional Crystal Reports resources and help for Sage 100
How to install Crystal Reports Designer for Sage 100
What stubs are used for the different Check Form Types?
How to add Vacation and Sick Accruals to Payroll Check on Sage 100 2018 and higher

Solution Properties

Solution ID
223924850045387
Last Modified Date
Mon Aug 31 21:33:46 UTC 2026
Views
0