Find latest vendor of Item via transaction
Hello everyone, I would like to know how to create a Transaction search to find the latest vendor of a item, meaning that it is the lastest vendor that you bought a item from. As the pic belows, I would like to show the vendor "ACC0000021297" having transaction on 5 Mar. Kindly regards, Mei.