[gazzae]

The data above has been pulled out of an MRP system. To give you a bit of background, some users weren't using the system correctly and we putting any old cost in the PO and only putting the correct cost in when the invoice from the supplier arrived. This meant that the cost on some parts is wrong as they were being updated with the wrong cost at GRN time. (Hope that makes sense).

What I am trying to do is a one off report with compares the last invoice price with the current price on the part and highlight any differences.

So the data above is from the invoice table, and I only want to have the cost off the most current invoice by"A" number and dump the rest. I can probably do this with code but was hoping for a quick and easy way.