I am trying to write a BAQ in the PartTran table that will show the parts that do not show up with a specific date range. As simple as this sound, I am surprisingly not getting the results I want. How can i pull this off? Thanks!

No, you’re almost there. You actually want to start with a list of everything that IS in that range. So switch your <> around. so if heres if your set a= 1 a = 3 a = 5 b = 1 b=5 You end up with this a=3 Now on different level you get all of the possible parts (use the part table) you get t…

BAQ Part Tran :: Show Parts that are NOT within a date range

Epicor ERP 10

tse.dba (Andrew Koemm) September 13, 2019, 2:06pm 21

This is good stuff. Thanks so much!

Topic		Replies	Views
BAQ - Where something is NOT in joined table Epicor ERP 10 baq	8	3491	November 22, 2021
BAQ to get quantities for all parts on a specific date Epicor ERP 10 e10 , baq	15	10410	June 11, 2024
BAQ Woes Epicor ERP 10 baq , baq-calculated-field	9	1575	November 9, 2021
BAQ to select PartTran records for a Part and any Part that it is an alternate for Epicor ERP 10	2	483	August 16, 2018
PartRevs with No Ops BAQ Epicor ERP 10 baq	7	689	May 21, 2019

BAQ Part Tran :: Show Parts that are NOT within a date range

Related topics