BAQ Timing Out Needs Streamlining

Epicor ERP 10
1

Hi. I have a BAQ that is timing out and hope you can help me with streamlining it to speed things up. My goal is a list of:

  • all parts with cost from the last PO if we have ordered it. Due to UOM issues, I’m taking the extended cost divided by our quantity

  • for each part, the sum of the transactions for the last year (365 days) where we issued material (pur-mtl, stk-mtl and stk-cus)

  • for each part, the on hand quantity

  • total required on open jobs

What I want to do with this is then filter on items where we have inventory on hand, the quantity required for jobs is 0, the quantity issued in the past year is 0 and then filter on a dollar amount either cost or total inventory $. I’ve attached the BAQ and appreciate any advice.
DV_Slow.baq (117.9 KB)

2

Have you tried using PartQty instead of PartWhse? I didn’t see anywhere you were grouping parts into separate warehouses.

3

Wow. Looks like that did it! Thanks.