manual change current fiscal year

[troyddaniels]

We had an issue where someone tried to convert an old DB into an established one. Well it didn't convert of course, but it did reset the fiscal year to 2005. If I run "create new fiscal year" it will give me an error and jump up to 2006. however if I run it again it's a no go. Is there anyway I can get accpac (ERP 5.3a) to go back to 2007?

 

[jayconverse]

Restore from backup.

Jay Converse
IT Director
Systemlink, Inc.

 

[troyddaniels]

Unfortunately back up isn't an option. Yeah I know, don't say it.

 

[jayconverse]

Wow, somebody really screwed up, you've got mixed tables. Your best bet is editing GL01: YRCLSLST (Last closed year), YRLSTACTL (Oldest year of Fiscal Sets), and YRNOPSTPR (Oldest year of Trans. Detail). But I'd be worried about the condition of GLAFS.

Jay Converse
IT Director
Systemlink, Inc.

 

[troyddaniels]

Thanks a ton, I'll do that.