Skip to Content

sales report by sub dept (UDF) with this year and last year comparitive

Jul 06, 2017 at 09:34 PM


avatar image
Former Member

Hi guys Im really stuck on doing this keeps telling me my syntax is wrong and now my queries aren't running at all !

I need a query grouped by sub dept ( UDF) on OINM showing sales for this year and the same period for last year.

columns required are

Sub Dept (UDF), Item code, Qty, Sales value, Margin

hope someone can help.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers