[sqr-users] Comparing/Difference of Two Payroll Summaries

["Jean Myles" <jean_myles@fitnyc.edu>]

I have been asked to create a report that compares two consecutive payroll
summaries for a specific pay year, pay id, and payroll run  (all prompts)  

The final report would appear like the following:

 

Payroll1
Payroll2                                                

Pay ID      Earn Code       Total                                      Pay
ID      Earn Code       Total                          Difference

 

RG            ABC               1000.00                                  RG
ABC                400.00                        600.00

RG            DEF                2000.00                                 RG
DEF                1500.00                      500.00

 

 

 

The issue is, both payrolls could have earn codes that do not exist in the
other payroll.  (Eg: Payroll 1 - GHI , 500.00 but does not exist in Payroll
2)  

 

RG           GHI                     500.00
DOES NOT EXIST IN THIS PAYROLL - CANNOT GET TO PRINT/DIFFERENCE

 

I have stored the first payroll in a temp table and can select the common
earn codes to the second payroll.  How do I get the earn codes that are
unique to each payroll to be listed as well?  And is there a way to insert a
zero if it does not exists so that it can be subtracted for a difference
value?

 

I thank you in advance for your assistance.

 

 

Jean Myles

 <mailto:jean_myles@fitnyc.edu> jean_myles@fitnyc.edu

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users