Home » Archives
SQL View for Sales Margin Analysis
Written on 2 May, 2009 at 12:21 in Dynamics, Great Plains, Sales Order Processing | viewed 1 views times | 2 Comments
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 1 THEN 'Quote' WHEN 2 THEN 'Order'... (Continue reading)
SQL View for Inventory Aging
Written on 2 May, 2009 at 12:06 in Dynamics, Great Plains, Inventory | viewed 1 views times | 1 Comment
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)