Query Laporan Produksi: Planned & Released SAP B1

Terkadang kita bingung untuk menentukan Production Order mana yang seharusnya sudah kita Closed statusnya.

Berikut ini adalah tips untuk melihat report Production Order yang satatusnya Planned dan Released yang bisa kita gunakan sebagai acuan apakah Production Order tersebut memiliki Plan Receipt, Actual Receipt, Plan Issue, Actual Issue, dan 2 field Tambahan Receipt Status dan Issue Status.

Jadi jika :

• Actual Receipt ≥ Plan Receipt maka Receipt Statusnya berisi ‘Fully Received’,
• Actual Receipt < Plan Receipt maka field terset berisi ‘Not Fully Received’
• Actual Issue ≥ Plan Issue maka Isue Statusnya berisi ‘Fully Issued’
• Actual Issue < Plan Issued maka fieldnya berisi ‘Not Fully Issued’.

Berikut adalah query Production Order Planned and Released Summary:

SELECT T0.DocEntry,T0.DocNum,CASE T0.Type WHEN 'S' THEN 'Standard' WHEN 'P' THEN 'Special' END [Prod. Type],T0.PostDate,T0.DueDate, CASE T0.Status  WHEN 'P' THEN'Planned' WHEN 'R' 

THEN 'Release' END [Prod. Status],T0.ItemCode,T0.ProdName,T0.PlannedQty AS [Plan Receipt],T0.CmpltQty + T0.RjctQty AS [Actual Receipt], SUM(T1.PlannedQty) [Plan Issue], SUM(T1.IssuedQty) [Actual Issue],

CASE WHEN T0.PlannedQty > T0.CmpltQty + T0.RjctQty THEN 'Not Fully Received' ELSE 'Fully Received' END [Receipt Status],

CASE WHEN SUM(T1.PlannedQty) > SUM(T1.IssuedQty) THEN 'Not Fully Issued' ELSE 'Fully Issued' END [Issue Status]

FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.Status IN ('P','R')

GROUP BY T0.DocEntry,T0.DocNum,T0.Type, T0.PostDate, T0.DueDate, T0.Status,T0.ItemCode,T0.ProdName,T0.PlannedQty, T0.CmpltQty, T0.RjctQty

ORDER BY T0.PostDate

Baca juga Tips SAP Business One yang relevan: