Submit Your Suggestions for Vista

Please find the attached FYI.

Thanks

Karen Thayer
Finance Director
1390 Norman Ave., Santa Clara, CA 95054
T 408-970-9800 x 207 F 408-970-9975
E karen@andpac.com

[cid:2e292d83-6474-4b5e-ba69-6244214b97c9]

Mr. Gilmore,

We updated to Vista 6.16 and I ran one of the unemployment reports to use for a SUTA report that I had not completed as yet but I do not see the number of employees listed that worked on the 12th of each month. Many if not most of the SUTA reports filed in the 8-10 states we work, require input of the number of workers on the 12th of the month before ever uploading the file into their system. If not the unemployment report, another report within the payroll. Please advise.

Thank You.

Jean Grayson
Wright Brothers Construction

Loved it!  Thank you so much! Why reinvent the wheel if you have done it already ;)

Thank you Gary!

All the more reason to upgrade...:)

The full query is comprised of three linked VA inquiries beginning with a summary that drills down to the employee level - for those familiar with SQL, here's an abbreviated version that provides overall totals with breakout by state (no employee detail)

No warranties.....

declare @PRCo tinyint, @BegMonth smalldatetime, @EndMonth smalldatetime
select @PRCo = 1, @BegMonth = '01/01/2018', @EndMonth = '04/01/2018'

select PRCo, Day12 as [12th], count(Employee) as [Employee Count], dbo.vfFirstDayOfMonth(Day12) as Mth
from (
select distinct h.PRCo,h.UnempState,h.Employee,
convert(DateTime,substring(convert(varchar(15),BeginDate,102),1,8)+'12') as Day12,
c.BeginDate,c.PREndDate
from PRPC c
JOIN PRTH h on c.PRCo=h.PRCo and c.PREndDate = h.PREndDate and c.PRGroup = h.PRGroup
where c.PRCo=@PRCo and
c.BeginDate >= @BegMonth and c.BeginDate < dateadd(m,1,@EndMonth)
and
convert(DateTime,substring(convert(varchar(15),BeginDate,102),1,8)+'12')
between c.BeginDate and c.PREndDate
) a
group by PRCo, Day12
order by Day12

select PRCo, Day12 as [12th], UnempState as [Unemployment State], count(Employee) as [Employee Count], dbo.vfFirstDayOfMonth(Day12) as Mth
from (
select distinct h.PRCo,h.UnempState,h.Employee,
convert(DateTime,substring(convert(varchar(15),BeginDate,102),1,8)+'12') as Day12,
c.BeginDate,c.PREndDate
from PRPC c
JOIN PRTH h on c.PRCo=h.PRCo and c.PREndDate = h.PREndDate and c.PRGroup = h.PRGroup
where c.PRCo=@PRCo and
c.BeginDate >= @BegMonth and c.BeginDate < dateadd(m,1,@EndMonth)
and
convert(DateTime,substring(convert(varchar(15),BeginDate,102),1,8)+'12')
between c.BeginDate and c.PREndDate
) a
group by PRCo, Day12, UnempState
order by Day12,UnempState

Thanks Gary!  Any chance you could post here the code of the inquiry PREmployeesActiveOn12 for those who still have not upgraded to 6.16?

A standard query for this is now available in 6.16 -see VA Inquiry - PREmployeesActiveOn12. It displays employee counts by month and state and drills down to list individual employees

Included when creating an Accounting Work Center in the Menu or can be added to an existing Work Center 

My company enters everyone's time on one line (not daily time cards) using the payroll week ending date which isn't always the 12th.   Can you make the report pull either payroll ending date or the 12th of the month so if we use payroll end date we can still use the report?

Vista has provided this count as part of its quarterly SUI reporting for those states that require it, but understandably, its not always convenient to run an unemployment report just for this value.  So, in the upcoming release (6.16) a standard VA query has been added and available for on-screen display as part of the Accounting Work Center.  If you have already setup your Accounting Work Center you will need to add the query to you existing list, but if you have not yet created your Accounting Work Center or willing to recreate one, the query will be automatically added under the Payroll folder when you initialize.

People who suggest finding other ways around this obviously don't have any experience with payroll reporting. Every other software I have ever used does this basic task!  It should appear on the quarterly reports right out of the box, you shouldn't have to write a custom report, etc. to get this information!! 

Excellent.  Georgia also has this requirement.  We were shocked that Vista couldn't already do this when we implemented 2+ years ago.

These counts will calculate once you run the "PR unemployment process"  for each particular state.    Our IT staff wrote a crystal report to then pull the numbers for each month.    

Whoever created this, possibly consider writing a complete custom report (or copy the standard SUTA report) and add in the employee count yourself?

So glad to see this posted and that it is likely to implement finally.  Every SUTA report we do also requires to know the number of employees on the 12th of the month and on Viewpoint  to have to take the time to run additional reports for the week of the 12th in each state then manually count each employee is not a selling point for this software.  My previous software listed the total employees on the 12th of each month on the report.