SUMMARY
This article provides a set of SQL scripts designed to locate and correct potential mismatched entries causing wrong fiscal year data errors that may occur when migrating SL data to other platforms.
DETAILS
Open Sequel Server Management Studio and run this script against the SL application database to determine if any GLTran entries are showing mismatched fiscal year data
select * from gltran where fiscyr <> left(perpost,4)
If results come back from the first script, run this second script against the same application database
update gltran set fiscyr = left(perpost,4) where fiscyr <> left(perpost,4)
Any errors should now be corrected