Sate Wage & Hour Report

[dBjason]

Hello,

I have a bug I've been trying chase without much success.

In our great plains environment, we have a report called "State Wage And Hour Report" (under reports -> payroll -> wage and hour -> state wage report). It prints the employee id, name, SSAN, taxable wages, and tax withholding for every employee in the database. And it works great for everybody -- except one.

One employee is missing $$$ in her taxable wages column. I've checked the math, and she's missing her January salary to the penny. For whatever reason, the report is not including that month's earnings.

I've opened the report in report designer and found out it gets it's data from a temporary table (Payroll Temp State Wage Report). I've looked in the db through SQL Query Analyzer, no such table exists in the database. I figured the table gets dropped after the report is closed, so I even triple-checked the db with the report still open. It still doesn't exist. I have no idea how this table is generated or populated, and desperately need to find out how so I can fix whatever is hosing up.

Does anyone know how I can find out how this data / table is generated? Please Help!

Thanks,
Jason

 

[bradth]

What you might wanna try and do is in Great Plains goto Tools > Resource Descriptions > Tables. This is a good tool to find out information about all of the tables GP uses. Search out the table by the physical name and when you find it, double click and it'll give you information all about the table. Also you may wanna try and run a trace on this table using the SQL Profiler. Create a dummy entry and trace it to see where all of the data is being stored. Hope this helps, good luck!

Brad