Home » Listing Details
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 400 resources listed. - Rose Business Solutions Blog New
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
| ID: | 9896 |
| Title: | How to See the Dynamics GP Items You Didn't Sell |
| URL: | http://dynamicssmallbusiness.blogspot.com/2010/05/how-to-see-dynamics-gp-items-you-didnt.html |
| Description: | Ever have someone that wants to see GP Items that didn't sell lately? Here is the SQL statement: select itemnmbr, itemdesc, Item_Sales_Aggregates.Last_Sold, Item_Sales_Aggregates.Line_Qty from iv00101 left outer join ( select max(document_date) as Last_Sold,count(document_date) as Line_Qty, item_number from (select sop10100.docdate as document_date, sop10200.itemnmbr as Item_Number, sop10100.soptype as sop_Type from sop10100 join sop10200 on sop10100.sopnumbe=sop10200.sopnumbe and sop10100.soptype=sop10200.soptype union select sop30200.docdate as document_date, sop30300.itemnmbr as item_number, sop30200.soptype as sop_Type from sop30200 join sop30300 on sop30200.sopnumbe=sop30300.sopnumbe and sop30200.soptype=sop30300.soptype) as B where sop_type=3 and document_date between '1/1/2009' and '5/30/2010' group by item_number ) as Item_Sales_Aggregates on iv00101.itemnmbr = Item_Sales_Aggregates.item_number where line_qty is null |
| Category: | |
| Link Owner: | |
| Date Added: | June 17, 2010 05:10:59 AM |
| Number Hits: | 1 |
Latest links
- Microsoft Dynamics CRM Partner Training Blitz Day – July 31 – Register Today!
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Printing a different company name and address on your checks based on the location assigned to the checkbook – report writer fun
- Why does my computer get stuck at Please Wait and fail to boot up?
- Management Reporter 2012 Process Service Not Running | azurecurve
- A Quick Tour of the Performance Dashboard Reports – SQLServerCentral
- Now Available – Microsoft Dynamics NAV and Microsoft Dynamics GP on Windows Azure!
- Microsoft Dynamics GP on Windows Azure!
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Printing a different company name and address on your checks based on the location assigned to the checkbook – report writer fun
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.