[sqr-users] Recomputing Peoplesoft Balance Tables YTD, QTD amounts fromMTD amounts

["Dan Brinkley" <DBrinkley@techneglas.com>]

Does anyone  know of an SQR (or some procedure) that recalculate the QTD
and YTD amounts from the MTD amounts in the Payroll balance tables.  We
have some inconsistency because, during conversion of PS_EARNINGS_BAL,
periods 5 and 6 (may, June) were written with QTR=1  (should be 2).   We
just noticed this now and also caused the YTD totals to not jive with
the MTD totals.  Fortunately, a small set of earnings codes are
affected.

I can easily fix the bad QUARTER, but fixing the numbers would take me
more time.
Surely someone has had to write something to fix (or at least report)
this kind of table inconsistency.
Peoplesoft support has stated they provide nothing, but to use
TAX015.sqr as a guide.

Thanks in advance for anyone's help.  Maybe this is really easy.  I
just hate to miss something, and really screw up these tables.  

Daniel Brinkley
Techneglas, Inc.


Daniel Brinkley
Programmer/Analyst
Techneglas, Inc.
dbrinkley@techneglas.com
phone: (614) 445-4721
fax: (614) 445-4723

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