Creating Report to show multiple values

aristeff

Is there any way to create a report that lists all the values for one vendor? We are trying to develop a report on Purchasing Vendors that would list the account numbers for that vendor. The issue is that multiple account numbers can be per inventory location, but the report only lists the first record for that vendor. How can we get all of the records, or is there another option that I am missing?

Thanks

robert-canham

Reports can only do one-to-one relationships so you need to start with the most detailed business class.  In this case, you'd want to base your report on the PurchasingVendorAccount business class and then have fields from the PurchasingVendor business class added to that.