Skip to Content
avatar image
Former Member

Production Qty monthwise analysis

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 18, 2016 at 10:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2016 at 02:04 PM

    Need a lot more info.

    What version of Crystal Reports are you using?

    Are you using Business One?

    Add comment
    10|10000 characters needed characters exceeded