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’ ?

Phone: 888.239.2818 | Fax: 312.621.9200

 Copyright © 2012 Clients First Business Solutions (North America) LLC. All rights reserved

CFBS Locations: New Jersey (Head Office)Alabama | California | FloridaIllinois | Minnesota | TennesseeTexas