I would like to get a query where only for the Vendors which have "ERS" -Evaluated Receipt Settlement type slected , I want to get the total dollars purchased from that vendor.
Which table gives the total Purchasing dollars per Vendor?