Welcome to the SSDT Question and Answer Site!
Or Join with

# What is being used tor total hours calculating on the AFFORD report?

0

777 views

On the calculation it has the total hours for the time period divided by the number to get the average.  Where is that dividing number coming from?  I ran it in a district's files for two months.  That number is everything from 1.42, .87 to 2.0.  Twp people have 2 though one was paid one and the other was paid three times.

 asked October 7, 2013 09:46 AM

0

When running the report for the month the pays are normally set as 24, using the W option the pays are setup as 26.

When running it for the month you will want to make sure that you enter the first day of the beginning month and the last day of the ending month. Ex- 8/1/2013 - 10/31/2013. If these dates are not entered correctly this would cause your percentages to be slightly off.

Also, the calendar start date on the JOBSCN will also  be a factor in the calculation as well. You can see what start and stop dates (if applicable) are being used based on the start and stop dates on the report

The divisor is based on what is appearing in the start and stop dates field on the AFFORD report for each employee. This is what is used to determine the number of months.

Example- The AFFORD report is ran for the month using 8/1/2013- 10/31/2013 This employee was paid based on retirement hours that were added during the payroll process:

Test, Employee  08/01/2013 10/31/2013
01 2   09/20/2013 522497   54.00      0.00
01 2   10/04/2013 522564   74.25      0.00
--------- ---------
TOTALS:           128.25      0.00   128.25 / 3.00 =  42.75

The employee must have a calendar start date that is earlier or includes 8/1/2013 and therefore the retire hours are being divided by 3 months- August, September and October.

Example 2- The AFFORD report is ran for the month using 8/1/2013- 10/31/2013 This employee had adjusting entries added in ATDSCN for the retire hours both dated 9/15/2013.:

Test2, Employee.    09/01/2013 10/31/2013
00    09/15/2013            0    0.00     63.00
--------- ---------
TOTALS:                    0.00     63.00    63.00 / 2.00 =  31.50

The ATDSCN adjusting entries are dated 9/15/2013 and the calendar start date also reflect 9/15/2013. Therefore the retire hours are being divided by 2 months- September and October.

flag
 answered October 7, 2013 10:29 AM