Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
html-wrap
classcol span_3_of_5
UI Text Box

These features are available only in AccountRight 2016.3 and later.

To help you analyse your Cards List, or to just make some cards stand out from the rest, use conditional formatting.

AccountRight can highlight details in the Cards List when rules and conditions you've set are met, and it can make ranking your cards really easy with visual indicators.

For example, you can use conditional formatting to:

  • Highlight cards that you need to contact next, based on their recontact date.
  • Identify cards that are on credit hold more clearly.
  • Highlight customers or suppliers with overdue balances greater than a certain amount.
  • Highlight your new customers.
  • Rank your customers or suppliers based on current balance, or overdue amount.

To access the conditional formatting options, right-click the column header you want to apply a rule to, and choose Conditional Formatting.

Conditional formatting options available when right-clicking a column headerImage Added

To clear any conditions you’ve set, right-click the column header and choose from the clearing options.

Clear rulesImage Added

Conditional formatting options

There are four types of condition rules you can set. The options available to you depend on the column that you’re applying the rule to:

UI Expand
titleHighlight Cell Rules

Highlight Cell Rules

You can distinguish certain cells or rows easily by creating highlight rules. You can choose to shade highlighted fields or rows, or bold text that matches your rule.

In the example below, we’ve applied a rule to the Country column. Any row that has “New Zealand” in the Country column will be shaded green.

Condition used to highlight all New Zealand-based cardsImage Added

You can use the following conditions to highlight a cell or entire row:

Use this condition
Use this condition...When you want to highlight cells or rows that...
Column types
Column types
Equal toonly have the exact characters, amount or date in the selected column.All
Text that containscontain the characters you enter.Text
Greater thanhave a value that's greater than a certain amount, or a date that's more recent than your selected date.Currency, Date
Less thanhave a value that's less than a certain amount, or a date that's earlier than your selected date.Currency, Date
Betweenhave a value that's within a range of amounts or dates.Currency, Date
A date occurring

are on, before or after a certain period.

For example, you can create a rule to highlight cells that contain today's date, tomorrow, last week, or later this year.

Date
Custom condition

meet a combination of the above conditions.

The Custom Condition window lets you add several conditions to a rule. Click the + button next to the “And” link and then specify the condition to apply.

All
UI Expand
titleTop/Bottom Rules

Top/Bottom Rules

For quick analysis of your Cards List, you can use a top/bottom rule.

For example, below we’ve applied a “Top 10” rule to the Overdue column, to identify the highest overdue balances. We’ve customised the rule to only show the top 3.

Condition showing the top 3 overdue balancesImage Added

UI Text Box
typetip

Top/bottom rules are best applied in the Customer view or Supplier view of the Cards List rather than the All Cards view.

These are the conditions you can set to the columns:

Use this condition
Use this condition...When you want to analyse...
Column types
Column types
Top 10 Itemsthe highest amounts by value, or most recent dates.Currency, Date
Top 10%

the cards that have the highest amount, and that are in the top 10% (or your own value) of all cards shown.

Note that the percentage relates to the number of cards, not the card values.

Currency
Bottom 10 ItemsThe lowest amounts by value, or the oldest dates.Currency, Date
Bottom 10%

The cards that have the lowest amount, and that are in the bottom 10% (or your own value) of all cards shown.

Note that the percentage relates to the number of cards, not the card values.

Currency
Above Average

All cards that have an above average amount.

The average is calculated using all amounts shown in the column, including $0 amounts.

Currency
Below Average

All cards that have a below average amount.

The average is calculated using all amounts shown in the column, including $0 amounts.

Currency
UI Expand
titleUnique/Duplicate Rules

Unique/Duplicate Rules

A quick way to check whether you have duplicate cards or information in the Cards List is to use the unique/duplicate rules.

For example, below we’ve used a unique/duplicate rule on the ABN (Customer) column to identify with red bold text all cards that have the same ABN

.Use this condition

(you could do the same with GST Registration numbers in New Zealand).

Condition showing duplicate ABNsImage Added

Use this condition...When you want to highlight...
Column types
Column types
Unique valuesall cards that have unique content in the column that you apply the rule to.All
Duplicate valuesall cards that have the same content as at least one other card in the column that you apply the rule to.All
UI Expand
titleData bars,
color
colour scales, icon sets

Data bars, colour scales, icon sets

For currency columns, you can apply formatting that will make it easier to see at a glance the scale of amounts owing or overdue.

For example, below we’ve applied a blue data bar gradient to the Overdue column that shows the scale of each overdue customer balance.

Conditional formatting showing scale of overdue balances with blue data bar gradientsImage Added

UI Text Box
typetip

Formatting is best used when viewing the Customer or Supplier view of the Cards List, rather than the All Cards view. 

Use this formatting
Use this formatting...To show scale...
Column types
Column types
Data barsusing horizontal bars. You can choose from several colours.Currency
Colour scales

by filling the cells with different shades of colour.

You can choose from several colours and gradient options.

Currency
Icon setswith icons. There are several styles you can choose from.Currency

 

 

HTML
</span>
HTML-wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Creating a card, editing and deleting cards

Deleting a record

The Cards List

Filter the Cards List

Finding a customer or supplier

Customise the Cards List

Group columns in the Cards List

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=cards+list&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap
classmorelinks

More »

...