Archive for May, 2009
SQL View for Sales Margin Analysis
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’ WHEN 3 THEN ‘Invoice’ WHEN 4 THEN ‘Returns’ WHEN 5 THEN ‘Back Order’ WHEN [...]
May 2, 2009 · 
veeyeskay · 
2 Comments
Posted in: Dynamics, Great Plains, Sales Order Processing Total Views: 824
SQL View for Inventory Aging
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 to write out a simple view to achieve the same. CREATE VIEW vw_IVStockAgeing AS [...]
May 2, 2009 · veeyeskay · 6 Comments
Posted in: Dynamics, Great Plains, Inventory Total Views: 1,422