I am trying to look at inventory tables with the last cost attached, however I cannot get my BAQ to stop showing inventory for each Cost ID. It will show the same part 3 - 8 times. I tried to filter by cost ID then I lose all the items that are not in those specific plants. Has anyone run into this?
You must join the CostID from the Inventory table (whichever one you are using) to the cost id table.