Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to write a query t...

How to write a query to compare Current year fiscal period sales to Last year Fiscal Period sales in SQL Server

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am trying to write a query in SQL server that pulls data from multiple tables and stores it into a new table and I only want the data that compares current year Fiscal period to Last year Fiscal period.

Any help is greatly appreciated.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to write a query to compare Current year fiscal period sales to Last year Fiscal Period sales in SQL Server

Hi NP41,

Maybe it would be much simpler to just use Management Reporter 2012 to do that work ? it has built-in functions to pull data based on Fiscal periods, so you could compare current period with LY period at the same time, and even add the Budget for that period..
Richard Wheeler 75,730 on at

Like (0)

Report

RE: How to write a query to compare Current year fiscal period sales to Last year Fiscal Period sales in SQL Server

You can follow these examples plus use the SQL DateDiff function to separate current and last fiscal years.

stackoverflow.com/.../how-to-do-a-sum-inside-a-case-statement-in-sql-server
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to write a query to compare Current year fiscal period sales to Last year Fiscal Period sales in SQL Server

P.S : I already have a table that has fiscal period and year defined so I can just join that table. To be specific, I want to write a query that only gives data for last year fiscal period based on current year fiscal period.