Get a List of Financial Period Start and End Dates

I log into many clients in a day, and I'm sometimes asked to troubleshoot financial data or financial reports. To do that, I often need to know the financial period setup.

I know, I can just go into Dynamics and get that. But that's not me, I'm a back end guy.

Too, I might need to delineate a report by it's period, or some task along that line.

Today I need to evaluate the financial data for one period, hence the script below. This script will return a list of the financial periods and the dates that they encompass.

The result looks something like this:

 

select PERNAME, PERIODDT, PERDENDT
    from sy40100
    where SERIES = 0
        and PERIODID <> 0
        and PERIODDT > DATEADD(MONTH,-8,GETDATE())
        and PERIODDT < DATEADD(MONTH,4,GETDATE())
    order by 2

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences