AX 2012 - DeleteFiscalCalendarYear

gistfile1.cs

static void DeleteFiscalCalendarYear(Args _args)
{
    FiscalCalendarYear fiscalCalendarYear;
    FiscalCalendarPeriod fiscalCalendarPeriod;
    LedgerFiscalCalendarPeriod ledgerFiscalCalendarPeriod;
    LedgerPeriodModuleAccessControl ledgerPeriodModuleAccessControl;
    
    FiscalYearName yearToDelete = '2011';
    
    ttsBegin;
    delete_from ledgerPeriodModuleAccessControl
        exists join ledgerFiscalCalendarPeriod
            where ledgerFiscalCalendarPeriod.RecId == ledgerPeriodModuleAccessControl.LedgerFiscalCalendarPeriod
        exists join fiscalCalendarPeriod
            where fiscalCalendarPeriod.RecId == ledgerFiscalCalendarPeriod.FiscalCalendarPeriod
        exists join fiscalCalendarYear
            where fiscalCalendarYear.RecId == fiscalCalendarPeriod.FiscalCalendarYear
                && fiscalCalendarYear.Name == yearToDelete
    ;
    
    delete_from ledgerFiscalCalendarPeriod
        exists join fiscalCalendarPeriod
            where fiscalCalendarPeriod.RecId == ledgerFiscalCalendarPeriod.FiscalCalendarPeriod
        exists join fiscalCalendarYear
            where fiscalCalendarYear.RecId == fiscalCalendarPeriod.FiscalCalendarYear
                && fiscalCalendarYear.Name == yearToDelete
    ;
    
    delete_from fiscalCalendarPeriod
        exists join fiscalCalendarYear
            where fiscalCalendarYear.RecId == fiscalCalendarPeriod.FiscalCalendarYear
                && fiscalCalendarYear.Name == yearToDelete
    ;
    
    delete_from fiscalCalendarYear
            where fiscalCalendarYear.Name == yearToDelete
    ;
    ttsCommit;
}