Calculating accrual limit earned

Owned by Knowledge Assistant
Oct 22, 2024
1 min read
Description of Issue

Client wants to report on accrual limit earned

Context

  • All versions of Enterprise ERP

  • SSRS reports

  • Accruals

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

Cause

Accrual limit earned is a calculated field using the accrual date and the fields: al_from_month and al_to_month

Resolution

The following will give you the correct accrual limit per accrual:

SELECT
al_limit_earned
FROM 
pr_accruals
WHERE
al_from_months <=  DATEDIFF(MONTH, ac_accrual_date , GETDATE())
and al_to_month>=  DATEDIFF(MONTH,  ac_accrual_date  , GETDATE())

Additional Information