nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Customer detail list format

AngeC

Hi All

I need help constructing a detailed customer list that includes name Abn and Identifiers. I tried the customer detail report but that gives me 1 customer per page -which is not workable as we have 2600 customers. It Does not allow me to send it to excel

Find more posts tagged with

Accepted answers

Mike_James

Hi @AngeC , once you have added the ABN to the card list display, right-click the list and choose Copy List to clipboard, then open Excel and paste the copied values. The ABN will be included.

All comments

Mike_James

Hi @AngeC , the customer card export file is usually one row per customer. Maybe the advice was to delete columns you do not need (in Excel). The exported data can be easily copied to Excel then filtered etc as usual. Will this suit your requirements?

AngeC

To all also struggling. I just got of the Chat to be told the only way it can be done is to export the list and add the ABN in Manually, or export the whole card list and detele the rows not needed. With 2600 customers this is unworkable -very disappointing. A bit antiquated as ABN's are a statutory requirement. I know other programs can do it easily