Production Qty monthwise analysis

[Former Member]

Hello Experts,

Kindly assist me, i am trying to get a report of production - different varieties, different units of production points, month wise. The management needs to know which unit is worth keeping or not. Kindly help.

Shaz

[KennedyT21 · Accepted solution]

SELECT Distinct T0.[DocNum],T0.[PostDate], T0.[ItemCode], T2.[ItemName], T0.[PlannedQty], T3.[IssuedQty], T0.[CmpltQty] FROM OWOR T0 INNER JOIN OITT T1 ON T0.ItemCode = T1.Code INNER JOIN OITM T2 ON T1.Code = T2.ItemCode INNER JOIN WOR1 T3 ON T0.DocEntry = T3.DocEntry

Rgds

[former_member11696]

Need a lot more info.

What version of Crystal Reports are you using?

Are you using Business One?