SAP Business One Training Tips #5

This query uses only standard fields, and lists for any production order in Planned status, component shortages. The “AND T0.[Status] = ‘P'” can be changed to ” AND T0.[Status] = ‘R'” to show release production order shortages, or ” AND T0.[Status] <> ‘L'” to show Planned and Release component shortages in production.