I am attempting to build a report to show purchase history by vendor by item by lot with the unit cost.
I have the Item Ledger Entry table linked to the value entry and item tables. I can get all the fields I need.
I can see all purchase receipts however it does not filter out those receipts that were subsequently unreceived and the Po then received again. For example if we received it with incorrect information, unreceived it, and then received it again the data shows twice in my list- once correctly and once incorrectly.
How can I better filter my data to only show the final correct receipt?
Example of incorrect data: the Lot number was incorrect