Trying to create a GI for when parts were cycle counted

Try this instead 

Thank you for the suggestion ​@bwhite49. Unfortunately, it made the results worse without resolve the issue. All of the older than 360 days parts got folded into the not counted box, and the parts without their correct serial still didn’t have them. The only I’ve been able to get the serial number to appear is to have the INPIDetail as the parent table, but that has the unfortunate result of leaving out all of the parts without serial numbers.

Ah, well that does not sound good. I don’t think I can be of help without understanding your data. 

Hi ​@kkraus were you able to find a solution? Thank you!