Dynamics AX 2009 - Changing Accounting Year


I need to change the accounting year from 06/01/2011 - 05/31/2011 to 01/01/2011 - 12/31/2011

Problem is that some periods in the current year have been closed.

I have also tried to change the LEDGERPERIOD table via SQL to delete periods and amend the PeriodCode and PeriodStatus but whilst this successfully changes the LEDGERPERIOD table records it is not reflected in the AX screen view of periods.

Does anyone know which table AX is looking at…setup shows table 218 which is the LEDGERPERIOD table but it must be looking at another table.

Any comments would be gratefully received.


Solved the problem myself… use the “restore” option from the “command” menu for each period changes…period status reads the LEDGER PEROD table for the changes made.

Anyone who needs the SQL code for changes to LEDGERPERIOD table…more than willing to help.