PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

450+ FREE Tips dari Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner,
yang dapat menjadikan anda SAP B1 Super User

Custom Report –  Query Production Order Planned dan Released Summary

SAP Business One Tips Query Production Order Planned And Release Summary

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
SAP Business One Tips - Custom Report – Query Production Order Planned and Released Summary

SAP Business One Tips – Custom Report – Query Production Order Planned and Released Summary

Mau TahuCara Mudah Mengatur Perusahaan Dengan SAP Business One

Artikel ini ditulis oleh PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner di Indonesia.
Lebih detail tentang SAP Business One,
email ke: sales-enquiry@sterling-team.com atau hubungi +6221-5806336 atau wa +6287786555055

, , , , , , , , , , , ,