The revised CA SPSL laws require the amount of SPSL taken to show on the employee stub even if the amount is zero.

SUGGESTED

I've tried different formulas. The calculations are working fine. However, if an employee has never taken the SPSL sick, CA requires the stub to show the zero amount for the pay ID related to SPSL. Sage 300 CRE PR automatically removes any zero amounts from displaying on the stub. How can this be overcome without using a custom report?

  • 0

    Not for SPSL pay, but for a different pay, we have a formula that prints on the stub with zeros under "Deducts, Taxes, and Fringe."   Maybe try your formula under this area of the stub using PR - Tools - Modify - Check Forms

  • 0 in reply to Rhonda V

    That didn't work for me either.

  • 0 in reply to js3-cre-consulting
    SUGGESTED

    I think it could be the formula.  I've got 3 public formulas:

    LOOKUP(YTD Units (PR Employee Pay), Employee (PR Employee), 1, "12") called YTD PID12 Units

    LOOKUP(YTD Units (PR Employee Pay), Employee (PR Employee), 2, "12") called YTD2 PID12 Units

    Then I have this last public formula sum them:

    YTD PID12 Units (Public Formula) + YTD2 PID12 Units(Public Formula)  called TOTAL YTD PID12 Units

    TOTAL YTD PID12 Units is what is on my check form for the formula and it does print zeros if someone hasn't had and Pay ID 12 Units. 

    "12" is the Pay ID I'm tracking.

    and it grabs from checks that are 1 or 2nd in sequence.

  • 0 in reply to Rhonda V

    I would like to see those formulas in action because I don't think they are doing what you think they are doing. Of course, the formulas you typed here could be in error. Either way, I have tried numerous formulas and such in that section of the check stub and it is not printing zero amounts if the pay ID doesn't exist (and therefore no YTD amounts/units) and there is no current activity. I've even tried typing 'SPSL' on the check stub description and added a formula that is just a zero and that doesn't print either.

  • 0 in reply to js3-cre-consulting

    You'd have to try them yourself as I cannot think of anyway to show you.  I assure you, this does work for us and does print zeros.  If they don't work for you, you can delete them from your public formulas.

    Ok:  I've looked at them again:  YTD2 PID12 Units does have a typo above.  Change the 2 to a 3.  I believe this represents "Other" type pays.  Not related to the sequence.  I don't recall but it could be calling on the standard order for PR Time or PR Check Pay - something like these. 

    So, correction is:  LOOKUP(YTD Units (PR Employee Pay), Employee (PR Employee), 3, "12") called YTD2 PID12 Units