Announcements
No record found.
Hi,
I am using Dynamic AX2012. I need to get the start and end date of any fiscal year both in x++ and crystal report. Please help to get it.
*This post is locked for comments
Aren't you simply looking for StartDate and EndDate fields in FiscalPeriod table?
I have check the table FiscalCalendarPeriod that is contain the fiscal years with quarter detail. But if we can get it by some global variable that will be more better.
Is there any way to get it from global variable?
static void Job36(Args _args){
PeriodStart start; PeriodEnd End;
start = FiscalCalendarYear::findYearByCalendarDate(CompanyInfo::fiscalCalendarRecId(), systemDateGet()).StartDate; End = FiscalCalendarYear::findYearByCalendarDate(CompanyInfo::fiscalCalendarRecId(), systemDateGet()).enddate; info(strFmt("%1,%2",start,End));}
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader