4Site
Support Request System
View Patch #40.034.049
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
01833 -
GL Report doesn't show YTD totals correctly if run for prior fiscal yr
Symptoms:
GL Report doesn't show YTD totals if you are running in 2007, the last year closed was 2006 and you are running it for period 200612. Problem is only in SQL Server, Oracle is OK. This happened since patch 4.32.8
Solution:
The fix to print the totals if the previous fiscal year worked for running in the current year. But it no longer worked for previous years. The algorithm is now: If the period you requested is <= the last closed year start summing at the year of the period requested + 00 else start summing at the first period > last fiscal year closed + 99 (so > 200699 which is 200700) So if it is 2007 and the last year closed is 2006: Request period 200701 - starts summing YTD at 200700 Request period 200612 - starts summing TYD at 200600 Request period 200512 - starts summing TYD at 200500
Browse Patches
Find a Patch
Return to Request System Menu
