Customers page (Customers): list, status filter, column filters, columns and exports

Modified on Fri, 13 Nov at 12:55 PM

Every customer of your account in one table: who they are, how much they shipped this year, their contacts, billing terms and credit status. Use it to find a customer, see which are on credit hold, check contracts and balances, and export the list.

Who can do this: you need permission to view the Customers list (by default Admin, Superadmin, Dispatcher, Capacity, Accounting and Safety roles). New customer and the exports only show or work for roles that were given them.

Before you begin

Open the page

In the left menu, select Customers.

The page has a New customer button (top) and one table. Select a customer's Name to open its profile.

Filter by status

Above the table there is a status drop-down (it opens showing Active). Pick one or several statuses: Active, Inactive, Do Not Use and Potential. Next to it, the page counts your customers by status, for example "4 Active", "1 Inactive". OpenRoad remembers your choice in this browser.

Rows are coloured by status: Do Not Use red, Inactive orange, Potential light grey. Active rows have no colour. A red triangle after a name means the customer is on Credit Hold; its tooltip says to contact the accounting team to remove the hold.

Filter by column

Under the column headers there is a filter row. Every filter you use narrows the list, so a customer must match all of them.

  • Text boxes (for example Name, City, State, MC, Contact, Phone, E-mail, AP Contact, Billing profile, Account Manager): type part of the value. Names are matched by word beginnings.
  • From / To boxes for numbers (Sales This Year, Loads This Year, Open Balance, Available Balance, Credit Limit) and for dates (Last Active Load, Contract Start Date, Contract End Date).
  • Yes / No drop-downs (for example Credit Hold, Custom Billing, User Portal, PFF, FSC Applies).
  • Tier and Customer Type drop-downs (Customer Type can combine 3PL, Broker, Direct and None).
  • Detention Request Email: a text box and a Filled / Empty choice.

Reset Values clears every column filter and search.

The columns

The table opens with these columns: Name, City, State, Sales This Year, Loads This Year, Last Active Load, MC, Contact, Phone, E-mail and Open Balance.

Many more are available but hidden at first. Select Edit columns above the table to show or hide them: Credit Hold, Street #1, Street #2, State, City, Zip Code, Setup date, Additional Contact, Additional Phone, Fax, Billing preference, Billing profile, Payment terms, AP Contact, AP Phone, AP Fax, AP E-mail, Detention Request Email, Custom Billing, Custom Subject, User Portal, Account Manager, Capacity Manager, Contract Start Date, Contract End Date, Contract valid (today), Available Balance, Credit Limit, Hard Block Limit, Tier, Customer Type, Billing Specialists, Detention Specialists, PFF, FSC Applies and Account Group Email. Some columns only appear when your account uses the matching feature: FourKites Integration, Macropoint Integration and Customer Service Representative.

You can drag columns to reorder them. OpenRoad keeps your layout for the browser session.

Sort and page

  • The list is sorted by Loads This Year, highest first, until you sort by another column. Account Manager, Capacity Manager, Customer Service Representative, Billing Specialists and Detention Specialists cannot be sorted.
  • Select Show 25 rows (the number may differ) to choose 10, 25, 50, 100 or 500 customers per page. The default is 25.
  • There is no free-text search box: use the column filters.

Export

  • Export exports the visible columns of the current page to Excel.
  • Export all exports the visible columns of every page, with an extra Actions column.
  • Export Detention Stats to Email opens Export Customer Detention Stats. Choose All Time, This Month, This Quarter or This Year and select Export. A CSV with the customers' contact, billing, balance, contract and detention figures is emailed to you ("Customers CSV will be sent via email after processing"). It respects your status and column filters. Only roles that were given this export can run it.

Frequently asked questions

I do not see all my customers.
The page opens with Active selected. Add Inactive, Do Not Use and Potential in the Status drop-down.
A customer's row is orange or red.
Orange means Inactive, red means Do Not Use.
What does the red triangle mean?
The customer is on Credit Hold.
I cannot add a customer.
New customer only shows to roles that may add customers. Ask an administrator.
I cannot sort by a column.
Some columns cannot be sorted, for example the manager and specialist columns.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article