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

Question

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?

Rhonda V · Answer

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.

Sage Construction & Real Estate

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

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING