Does anyone know of a way to reference a table 2 times in the same BAQ? I’m trying to export data from Vantage 8 t Epicor 10 WITHOUT having to do other calculations, configurations, deletions in Microsoft excel before trying to load in Epicor 10.
What’s doing is going through all Active Parts, approved revisions and then exporting their bills of materials from Vantage 8 and bringing them into Epicor 10. The problem is that (in some cases) we have inactive parts on active Bills of materials. I would like to build this extra check into my export BAQ so that any mtl part number that is also marked as inactive will also be excluded from the export.
In order to do this, I would need to reference the part master table 2 times in the same BAQ. Once for the master part number (checking for active parts) and then linking back to the part master table using the mtl part number from the BOM and then checking again to see if that part may be marked as inactive too.
I know I can accomplish this using Excel and then filtering records out - but I’m trying to avoid that kind of editing at all costs (unless there is not other way).
M-B Companies Inc.