Points: 55409

3/6/2012 9:54:35 AM

Get a List of Financial Period Start and End Dates

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

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:
Version: GP 8,GP 9,GP 10,GP 2010
Section: Dynamics GP,SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables