Skip to main content

Fiscal calendar period dates and status

Financial calendars can be created and accessed from General ledger > Setup > Financial calendars.

 Fiscal calendar periods status (Open, On hold and Closed) can be changed from General ledger > Setup > Ledger > button.











Following job can be used to  get Start and End date of current Fiscal year
static void fiscalCalendarDates(Args _args)
{
    PeriodStart     periodStartDate;
    PeriodEnd       periodEndDate;

    periodStartDate = FiscalCalendarYear::findYearByCalendarDate(CompanyInfo::fiscalCalendarRecId(), systemDateGet()).StartDate;
    periodEndDate   = FiscalCalendarYear::findYearByCalendarDate(CompanyInfo::fiscalCalendarRecId(), systemDateGet()).EndDate;

    info(strFmt("%1", periodStartDate));
    info(strFmt("%1", periodEndDate));

    periodStartDate = FiscalCalendars::findFirstDayofYear(Ledger::find(Ledger::current()).FiscalCalendar, systemDateGet());
    periodEndDate   = FiscalCalendars::findLastDayofYear(Ledger::find(Ledger::current()).FiscalCalendar, systemDateGet());

    info(strFmt("%1", periodStartDate));
    info(strFmt("%1", periodEndDate));

}

Following job can be used to get the period status (Open, On hold and Closed)

static void checkFiscalCalendarPeriod(Args _args)
{
    TransDate               transDate = systemDateGet();
    RecId                   calendarRecId;
    FiscalCalendarPeriod    fiscalCalendarPeriod;

    calendarRecId = Ledger::fiscalCalendar(CompanyInfo::find().RecId);

    fiscalCalendarPeriod = FiscalCalendars::findPeriodByPeriodCodeDate(calendarRecId, transDate, FiscalPeriodType::Operating);


    if (transDate)
    {
        if (! fiscalCalendarPeriod)
        {
            checkFailed(strFmt("@SYS17614",date2StrUsr(transDate, DateFlags::FormatAll)));
        }

        if (fiscalCalendarPeriod.currentLedgerPeriodStatus() !=  FiscalPeriodStatus::Open)
        {
            checkFailed(strFmt("@SYS17615", date2StrUsr(transDate, DateFlags::FormatAll)));
        }
    }
}

Labels:

Comments

  1. AnonymousApril 22, 2015 at 5:15 PM

    Very helpful for us and gained more knowledge from it. We are very greatful and thanks a lot.
    Microsoft Dynamics AX Training | Microsoft Dynamics CRM Online Training

    ReplyDelete
  2. Faisal FareedApril 22, 2015 at 6:39 PM

    Glad to know it helped you.

    ReplyDelete
  3. kbs training instituteNovember 24, 2015 at 4:10 PM

    nice post thanks given such helpful information more about MS Dynamics AX Microsoft Dynamics Online Tutorial

    ReplyDelete
  4. SørenPCNovember 24, 2015 at 6:43 PM

    Great.
    Anyone that have tried to get the "mandatory" account/dimension set information from code ?

    ReplyDelete

Post a Comment

I will appreciate your comments !

Popular posts from this blog

The Dual Write implementation - Part 1 - Understand and Setup

What is Dual-write? Tightly couples – complete at one transaction level Near real time Bi-directional Master data and business documents – Customer records you are creating and modifying and at this document we are talking about sales orders or quotes and invoice. Master data could be reference data e.g. customer groups and tax information Why Dual-write and why not Data Integrator? Data Integrator is Manual or Scheduled One directional Now, Let's deep dive and understand what is required for Dual-write setup and from where to start. First thing first, check you have access to https://make.powerapps.com/ Choose right environment of CDS (CE) Make sure you have access to the environment too, click on gear icon and Admin Center  Look for required environment and Open it, you must have access as going forward you are going to configure dual write steps in the environment user the same user you are logged in now. Now, go back to power platform admin center and...
55 comments
Read more

D365FO: Entity cannot be deleted while dependent Entities for a processing group exist. Delete dependent Entities for a processing group and try again.

Scenario: There are times when you want to delete an entity from target entity list and when you do so, you face an error message which does not tell you where exactly the entity has been used.  "Entity cannot be deleted while dependent Entities for the processing group exist. Delete dependent Entities for a processing group and try again. " Solution: Browse the environment by appending this part  /?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF   at the end.  For example; if the environment URL is  https://daxture.sandbox.operations.dynamics.com then the complete URL will be https://daxture.sandbox.operations.dynamics.com/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF Filter for Entity and it will give you the DefinitionGroup where the entity has been added or used in data management import/export projects. Get the DefinitionGroup name and search in the export/import projects under data management and either del...
4 comments
Read more

Dual-write connection set error: An item with the same key has already been added

If you happen to see this error message then you have duplicate records in cdm_company entity in CDS environment. Check for cdm_companycode field this is normally not allowed but have a look and delete the ones with duplicates.
1 comment
Read more