Daily Production Report with Variance or receipt of Production

[Former Member]

Hi All..

my one of the clients want the Daily Production Report with Variance or receipt of Product?

Please let me know what does it mean and how can I fetch this report

Thanks

Rahul

[former_member206488]

Hi Rahul,

Check thread.

Thanks,

Neetu

[Former Member]

Hi Rahul,

Try This

Daily Receipt From Production report

SELECT T1.[BaseRef] as 'Production Order No', T0.[DocNum] as 'Receipt No', T0.[DocDate] as 'Receipt Date', T0.[CardCode] as'Customer/Vendore Code', T0.[CardName], T2.[ItemCode], T2.[ItemName], T1.[Quantity] as 'Receipt Qty', T1.[OpenQty] as 'Open Qty against Pro Order' FROM OIGN T0 INNER JOIN IGN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1] and

T1.[BaseRef] IS NOT NULL

Summary Report For Production Order

SELECT T0.[DocNum] as 'Production Order No', T0.[PostDate], T0.[DueDate], T0.[RlsDate], T0.[CloseDate], T2.[ItemCode], T2.[ItemName], T3.[CardCode], T3.[CardName], T0.[PlannedQty], T0.[CmpltQty], T0.[RjctQty] , (T0.[PlannedQty]-T0.[CmpltQty]-T0.[RjctQty] ) as 'Open Qty' FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry LEFT OUTER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode LEFT OUTER JOIN OCRD T3 ON T0.CardCode = T3.CardCode WHERE T0.[PostDate] >=[%0] and T0.[PostDate] <=[%1]

Thanks,

Srujal Patel

[Former Member]

Hi Rahul......

Daily Production Variance Report meaning Production Gain or Production Loss Report as per the Fixed Ration during Production Plan.

For record to be fetched from Tables are OWOR and WOR1.

Please make a join of these two tables and run. You get complete data of Production Variance....

Regards,

Rahul