Notice of Maintenance on October 9th. Click here for further details.

Benefit letter report

Does anyone know if there is a way to use the benefit letter in HRMS and have it only pull current plan information?

  • 0

    @sdurst 

    A standard benefit report (one run from the HR Benefit Reports menu in Sage HRMS) pulls employee records based on the Effective Date the user enters on the report's Specific Criteria tab.

    This Effective Date is compared to the effective dates and 'Latest Change to Amounts' dates for each benefit record on an employee's Insurance Benefits or Savings Benefits panel when the system determines which records to display.

    If there are multiple records (history and current) for a benefit code and the user want the current record to display on the report, the current record's 'Latest Change to Amounts' date must be populated with a date greater than the Effective Date selected for the report.

    If the user is unable to populate or correct dates, the following expression may be applied to the report as a workaround:

    1. Access the report's Standard Criteria tab
    2. From the Custom Criteria drop-down menu, select "Visual FoxPro Expression Builder"
    3. Enter following expression: INLIST(Be.b_beneid,"I","S") AND (Be.b_expdate > DATE() OR Be.b_expdate={ })
    4. Print or preview the report

    Save the Custom Criteria to the Custom Criteria table for reuse.

    Legend: Be.b_beneid

    I = Current Insurance or expired plan
    S = Current Savings
    N = History Insurance
    V = History Savings

  • 0 in reply to Beth W

    So I am putting dates in after the DATE in the () and {}.  When I try to verify it says Too few arguments.

  • 0 in reply to Beth W

    This formula keeps giving me an error message.