I added the Part table to the Inventory WIP Recon as relationship type “Output” and linked on fields Company -> Company and TmpPartNum -> PartNum.
For some reason, once I modify the dataset to bring the data in, I’m getting duplicate results with my data.
Now, when I run the WIP Recon without changing anything, but adding that job number to the filter, it does NOT duplicate the row.
Anyone know what’s going on?