How to create a Customer List using the Universal Report

How to create a Customer List using the Universal Report

Resolution is :
      1. Go to Reports → Universal Report.
      2. Select Catalog and Address/Contact.
      3. Click Show Settings, Grouping by "Owner"
      4. Click Run Report.




This will show all address/contacts from all customer cards grouped by company name.



Additional Filters may be added: Show Settings/Filter
eg: Filter by Contact id (primary, dropship and etc.)

Additional Fields may be added (or removed): Show Settings / Indicators

Formatting may be configured:  Show Settings / Conditional Formatting




    Need help applying this to your business?

    See how CustomBooks™ can support your accounting and inventory workflow

    If you are evaluating CustomBooks™ or want help setting up workflows for your business, explore the product or schedule a conversation with our team.

    Already using CustomBooks™? Explore the Knowledge Base or contact support for product help.



      • Related Articles

      • How to Get a Customer Address Report Grouped by City

        The universal report is a powerful tool. It has lots of options and to learn how to use it, it's best to use a real life example.  Navigation: Reports → Accounting → Universal Report In the first dropdown, choose Catalog. In the second drop down, ...
      • Exporting Companies' Email Addresses in CustomBooks™

        Need to export your customers' and vendors' email addresses? CustomBooks™ makes it easy with the Universal Report feature. Follow the steps below to generate and export a report containing your customers' email addresses and other relevant ...
      • The Universal Report

        Overview The Universal Report in CustomBooks™ is a highly versatile and powerful reporting tool that empowers users to extract, shape, and analyze data directly inside the application. It combines flexible reporting capabilities with advanced data ...
      • Adding Work Addresses

        To automate your payroll filings, we need to have your company's accurate addresses. Please enter your mailing and filing addresses and all addresses where you have employees physically working in the United States. To add new addresses, navigate to ...
      • How to process Cloud Commerce Orders when new addresses are found.

        Sometimes when Adding a new order in Cloud Commerce the address will be different than what is in CustomBooks™. In this case, the system will ask if you want to add a new address or update an existing address. See the figure below for instructions on ...