Demand for warehouse where part revision is NOT approved

Lee_Myers · October 20, 2020, 4:00pm

Afternoon,

Has anyone done a report that shows demand for warehouse where part revision is not approved

I want to find any unapproved part that appear from time to time.

Jason_Woods · October 20, 2020, 5:01pm

Are you talking about unapproved Revisions or items waiting Inspection or…?

Lee_Myers · October 20, 2020, 5:45pm

Parts for warehouse or even jobs where revisions is not approved. Eg BOM parts

Jason_Woods · October 20, 2020, 5:59pm

This would be two BAQs.

PartWhse joined to PartRev. Filter for PartWhse.OnHandQty > 0 and PartRev.ApprovedRev = false. Note that the Revision is lost when an item is placed in Inventory.
JobMtl to PartRev. Filter for PartRev.ApprovedRev = false.

Lee_Myers · October 21, 2020, 9:25am

Hi Jason,
Thanks for the reply, yes i did come up with a sql query like this.

but in terms of two BAQs what do you mean by this? i dont do many baq’s

Jason_Woods · October 22, 2020, 12:04am

You question requested a “report” to show certain data. Since there isn’t already any output like this, it would have to be created. Most created reports must start with a BAQ. In this case you are asking for data from 2 different places, so it may be two reports and therefore 2 BAQs.