Purchased Parts can be made Inactive

Yahoo Archive
1
Thanks for your advice.  I wanted to do the list in a BAQ so that we could use a BAQ search on the Part Maintenance screen to select them all to make them Inactive (we don't have DMT!).  I think 2 BAQ's is the way forward though :/
2


Hi.  Am sure I'm making this more difficult than it is but I have myself going round in circles... I basically want a BAQ that will show all Purchased Parts that are currently Active that have not been received within the past year OR have no receipts.  I'm struggling to get both in the one query (my attempt is below):

for each Part where (  Part.TypeCode = 'P' AND  Part.InActive = False) no-lock , each RcvDtl outer-join  where (  RcvDtl.ReceiptDate < TODAY + -366) and (Part.Company = RcvDtl.Company and Part.PartNum = RcvDtl.PartNum) no-lock .


We're on Vantage 8.03.409a.  Thanks.

3

Hi Tracey,

 

I would run this in two BAQ's.... the first one list all active purchased parts and export to excel.  The second BAQ select parts that have had receipts the last year and export this to excel.  Now do a vlookup on part..... these records you want to exclude, the rest are what you have not had a receipt for last year or ever.

 

Hope this helps

 

cheers