GROUP BY D.ITEMNMBR, D.Item_Description, D.Generic_Description, Updated to make column names Crystal-friendlyĬoalesce(I.ITEMDESC, SD.ITEMDESC) Item_Description,Ĭoalesce(I.ITMGEDSC, '') Generic_Description,Ĭoalesce(I.USCATVLS_1,'') User_Category_1,ĪND SD.ITEMNMBR not like 'XXXXXXXXXXXXXXX%'ĪND year(SH.DOCDATE) = 2011 -change year as needed Updated to add Generic Description, Item Class Document Date is used (not GL Posting Date) for all inventory items, and from SOP line items for Item Description is taken from Inventory Item Maintenance Only posted invoices and returns are included Returns total sales (invoices - returns) for each item by by Victoria Yudin - Flexible Solutions, Inc. I am making a few assumptions (listed in the view comments), and am hard coding one year at a time (2011 in this example). You can easily change the year as needed for one year at a time. Here is a new Dynamics GP SQL view in reponsse to a reader that liked my view for sales by item by year, but wanted to see the same thing by month.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |