<span id="hs_cos_wrapper_name" class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="meta_field" data-hs-cos-type="text" >SAP Business One – Query – Production Planning Board</span>

SAP Business One – Query – Production Planning Board

Query – Production Planning Board

 

SAP Business One Production Production Planning Board. This is a great report and drill down, providing production planners a tool to help manage their planned and released production orders.

 

SELECT T3.[CardName], T3.[CardCode], T0.[DocNum], T0.[Status], T0.[ItemCode], T0.[DueDate], T0.[PlannedQty], T0.[CmpltQty], T0.[RjctQty], T1.[ItemCode], T1.[PlannedQty], T2.[OnHand] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode LEFT JOIN OCRD T3 ON T0.CardCode = T3.CardCode WHERE T0.[Status] <> ‘L’ ?
Photo of Technical Team at Clients First Business Solutions

About the Author

Technical Team at Clients First Business Solutions

This article was developed by the technical team at Clients First Business Solutions, drawing on hands-on experience with ERP, business applications, integrations, and process improvement. The team works with clients to solve practical technology challenges and help them get more value from their systems.

View all posts by Technical Team at Clients First Business Solutions

Read More