How does the Time Off Accrual Report calculate hours available.

Summary

This article explains how Sage 100 ERP calculates Hours Available on the Time-Off Accrual Report. The calculation depends on the value in the "Base Time-Off Availability on" field in Payroll Options.

Resolution

Review the Time-Off availability setting

Open Payroll, Setup, Payroll Options, and select the Time-Off tab.
The "Base Time-Off Availability on" field determines how the Time-Off Accrual Report calculates Hours Available.

When Base Time-Off Availability is set to "L" for Limit

If the "Base Time-Off Availability on" field is set to L for Limit, the report calculates Available Hours using this formula: 
(Annual Limit + Carry Over Hours) - Hours Used
The system multiplies the Available Hours by the employee's pay rate to calculate the Accrual Balance.
When the calculation uses annual limits, the report ignores YTD Accrual Hours.

When Base Time-Off Availability is set to "A" for Accrual

If the "Base Time-Off Availability on" field is set to A for Accrual, the report calculates Available Hours using this formula:
(Carry Over Hours + Hours Accrued) - Hours Used
The system then multiplies the Available Hours by the employee's pay rate to calculate the Accrual Balance.

Need more help?

Chat now

 

Solution Properties

Solution ID
222924950027275
Last Modified Date
Fri Aug 28 17:23:41 UTC 2026
Views
0