Help creating BAQ to pull in Inspections that are active, along with the received date to filter by later

Epicor ERP 10
1

Hello,

I have someone asking for a dashboard to see active inspections with the dates the purchased parts were received into inspection.
Not sure I am explaining well.
He wants to recreate the search from Inspection Processing Entry but include the date purchased part was received by shipping and checked in. Example of the search screen in question below.

image
image.png1600×860 86.3 KB

If that still doesn’t make sense, please let me know and I will try to get more detail.

I have found the fields in question in the Erp.RcvHead (ReceiptEntry - date), and Erp.RcvDtl (Partnum, JobNum, PONum, OurQty, IUM, InspectionReq, WarehouseCode, BinNum, Company fields) tables.
When I create the BAQ with those tables and put a table criteria on RcvDtl of InspectionReq = 1 and BinNum = IMQA, I get 1228 results. I need to see if I can get it down to the 48 results like shown in the picture.

Any and all help/ideas are appreciated.

Thanks,

Shawn

2

RcvDtl.PendingInspection is the field you should filter on.

3

Hi Shawn,

The PO receipts list provides a nice grid view of inspection pending IMO. Looking at the grid for the PO Receipts list, Receipt Date is already there in the dataset. If you just make this field visible to the user via personalization or customization, would it be satisfactory?

Nancy

image
image.png1011×597 30.4 KB

image
image.png1110×376 31.6 KB

4

There is a system query zpartinspect(?) that drives the inspection processing screen search.

FYI

Brad Boes
bradboes@boosterpconsulting.com
231-845-1090

E3FEB85129DB48D1BB79420BCDAFE2E9.png708×1 83 Bytes

5

Thanks to @BoostERP, @Nancy, and @jblomstedt for your input.

@BoostERP is the one I went with. The zPartInspect is exactly what I needed. Just had to trim down the fields and make a dashboard.