Add Tax ID to Bills & Adjustments Generic Inquiry

Hello everyone,

I would like to add the Vendor tax registration ID to the Bills and Adjustments generic inquiry. I’ve attempted to do this by adding PX.Objects.CR.Location to the tables and adding the location object and TaxRegistrationID to the data field in the results grid. When viewing the inquiry, the tax ID is there, however, it creates many lines of the same invoices. Any ideas on how to clean up this report customization?

Thank you!

@tgillum29 & @khowe86