Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
kothandaraman_nagarajan
Active Contributor
0 Kudos
1,548

The below query will helpful to know future ordered quantities need to be manufactured for specific customer per month.Further the query result will be in tabular format.

Query:

Just paste the below query in query in query generator

SELECT [custcode]
as Custcode, [1] as Jan, [2] as Feb, [3] as Mar, [4] as Apr,  [5] as May, [6] as june, [7] as July, [8] as Aug, [9] as Sept, [10] as Oct, [11] as Nov, [12] as Dec

From

(select T0.[CardCode] as Custcode, sum(T0.[PlannedQty]) as PlanQty,month(T0.[DueDate]) as Month

from dbo.OWOR T0
where T0.[Status] NOT IN ( 'C' ) and (T0.[CardCode] between 'XXX' and 'YYY' or T0.[CardCode] between 'SSS' and 'VVV') and year(T0.[DueDate]) =2013 group by T0.[CardCode],T0.[DueDate] )s

Pivot

(sum(Planqty) for month IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) P

order by [custcode]

Explanation:

The main two function of the query is Month and Year.

Month function will convert due date in to months like 1,2,3......12

Year function will convert due date to year like 2012, 2013

Input to query:

Add your customer code in the above query in  XXX, YYY, SSS and VVV

Same way you can report  for Released quantity, completed quantity for different customers.

Hope it will be helpful for producion department.

With Regards,

Nagarajan

Labels in this area