Is there any way to export a customer list minus the jobs?

Options
MM_7769277
MM_7769277 Member Posts: 115
edited February 2018 in Accounts Hosted
Hi all,

Just trying to figure out a way to only export the top-level customer details without all the nested job documents underneath.

Have googled a few key words but haven't been able to find anything online.

Thanks in advance

MM

Comments

  • Shannon Sciuto
    Shannon Sciuto Member Posts: 98
    edited February 2018
    Options
    perhaps try generating a customer report and then exporting to excel?  I suppose it depends on the information you need to export. 
  • MM_7769277
    MM_7769277 Member Posts: 115
    edited January 2017
    Options
    Hi Shannon,

    Yep, I know how to do that bit :-)

    But we have multiple jobs nested underneath the parent customer document, and I only want to export the top level information.

  • Shannon Sciuto
    Shannon Sciuto Member Posts: 98
    edited February 2018
    Options
    I have used job types and customer types to help filter out jobs/customers in reports - I'm not sure if that helps? 
  • MM_7769277
    MM_7769277 Member Posts: 115
    edited January 2017
    Options
    Filter - Customer:Job Level = 0! Brilliant, thanks Shannon!