02 | May | 2009 | Interesting Findings & Knowledge Sharing

SQL View for Sales Margin Analysis

Published 05/02/2009 | By veeyeskay

Guys

The next post that I have decided to make is on a SQL view for generating a sales margin analysis report in Dynamics GP.

 
CREATE   VIEW dbo.vw_SOPSalesAnalysis
AS  SELECT  CASE dbo.SOP10200.SOPTYPE
              WHEN… Continue reading →

Published 05/02/2009 | By veeyeskay

Guys

I have come across many requests from various friends and clients of mine, who have a need to print a stock aging report in GP.

There is no out-of-the-box report for stock aging report in GP. So I decided… Continue reading →