Displays the item's last purchase price in PO line

Hello Experts!,

Maybe some of you have done something similar.

The client needs the purchase order displays the item's last purchase price at the line level.

What we've achieved so far is adding a flexfield that shows a list of all the latest prices for that item.

The problem is that we can't truncate it to the "last price" or "the last 3 prices", it shows ALL THE PRICES, and this could often be counterproductive if the database grows and the PO has several lines, as it would slow down the loading of this screen due to the number of subqueries.