Common-ID & Name correlation
Is there a table based on common-id that has names/descriptions for both Orgs and/or Persons? I'm trying to build an A/R report for some of our departments and they have customers that are both persons and orgs. When I try to do a combined report, even using left out joins, my results are not complete. I'm trying to pull data from Item_SF, GL_Interface, as well as Names & Ext_org_tbl.
Thanks
Stacy Combs
Washington State University