You’re offline. This is a read only version of the page.
can you delete a fiscal year that was created in error? no transactions exist
*This post is locked for comments
I have the same question (0)
Hi Deanna,
I have had to remove incorrect year setups in the past and I used the following script:
NOTE: Please make sure that you have a restorable backup prior to performing any troubleshooting steps. I recommend using a test environment to ensure you get the results you desire.
Please verify in the GL20000 and GL10110 tables that there are no records posted to this fiscal year.
Select * from GL10110 where year1 = ‘XXXX’
Select * from GL20000 where year1 = ‘XXXX’
(Replace the 'XXXX' with your FY)
If there are no records in these tables then you can delete the records for this year in the SY40100 and SY40101.
Delete SY40101 where year1 = 'XXXX'
Delete SY40100 where year1 = 'XXXX'
Hope this helps,
Share
Report
All responses (
Answers (
1,022
