Choose your columns and export a list
Most of the main lists and reports let you arrange their columns the way you work, and so do the tables on a record’s tabs, such as a customer’s Sales or a sale’s Deliveries. Look for Columns above the list or table. A tab’s layout is the same on every record: arrange a customer’s Sales tab once and every customer’s shows it that way.
You can also export the main lists as a file: Customers, Suppliers, Products, Sales, Invoices, Proformas, Purchase orders, Requisitions, Leads, Opportunities, Deliveries, Works orders, Stock takes, Stock transfers, Staff, Tasks, Reorder, Goods in, To make, To despatch, To invoice, Price lists and the prices on a price list, Configurable products, Families, Schedules, Works order costs and Stock variance. The Audit log keeps its own export: it doesn’t change with your columns.
Choose your columns
Section titled “Choose your columns”- Open Columns, above the list on the right.
- Tick the columns you want and untick the ones you don’t. A column that opens the record can’t be turned off.
Some columns are only there if you ask for them. On Products, each of your company’s properties is one.
If you take away a column you were filtering or sorting by, the filter or sort goes with it, so the list doesn’t stay narrowed by something you can’t see.
Move and resize columns
Section titled “Move and resize columns”- Move a column by dragging its heading to where you want it.
- Resize a column by dragging the right-hand edge of its heading.
Your layout follows you
Section titled “Your layout follows you”Your columns, their order and their widths are saved for you, on any device you sign in on. Nobody else’s list changes.
Filters and sorting aren’t saved: a list opens without them each time.
Go back to the default
Section titled “Go back to the default”Open Columns and select Reset to default. The list goes back to its usual columns, order and widths.
Export a list
Section titled “Export a list”- Filter, search and sort the list until it shows what you want.
- Select Export, then CSV or Excel.
The file has the same rows in the same order as the list, across all its pages, not just the page you’re on. It has the columns you’re showing, in the same order. In Excel, numbers and dates are real numbers and dates, so you can add them up and sort them.
An export can take up to 10,000 rows. If your list has more, filter it down first.
You’ll only see Export if your role allows you to export that list. If you need it, ask your administrator.