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.