Introduction

Credit Hound's Rules and Actions window allows you to identify which accounts or transactions are to be chased, by editing critieria at either account level or transaction level.

Above: Transaction level criteria (A) and Account level criteria (B)

When a rule is run, Credit Hound will search for all accounts that match the account criteria in the left hand pane, then from those will select all transactions that match the transaction criteria. In formal terms, each individual criteria row is tested with an AND operator, so in this example:

The Transaction must be Outstanding AND

The Transaction Age must be greater than 15 AND 

The Transaction Age must be less than 23 AND 

The Transaction Type must be Invoice AND

....etc... AND 

Account Balance must be greater than £5 AND 

Account Category must equal Basic

Some of the criteria windows allow for more than one option. So, if we wanted to include accounts from the categories Basic and Standard, we can add this in the window here:

This would be evaluated to a logical OR, reading Account Category = Basic OR Account Category = Standard

The rule will now be evaluated as :

The Transaction must be Outstanding AND 

The Transaction Age must be greater than 15 AND 

The Transaction Age must be less than 23 AND 

The Transaction Type must be Invoice AND

....etc...AND 

Account Balance must be greater than £5 AND 

(Account Category must equal Basic OR Account Category Must Equal Standard).

Be careful when using Not Equals in these windows, the following configuration:

Would return ALL accounts, as accounts in the categoriy of Basic will be selected, because it does not equal Standard, similarly Standard accounts will be selcted because they are not Basic accounts. Additionally accounts in other categories will be selected because, for example, the Problem accounts are neither Standard nor Basic. 

To exclude accounts from these two categories, we need to have two Account Category Criteria entries in our rule, each with only one line:

and 

This will now select all accounts EXCEPT those in Category of Basic or Standard, as it will be evaluated to 

The Transaction must be Outstanding AND 

The Transaction Age must be greater than 15 AND 

The Transaction Age must be less than 23 AND 

The Transaction Type must be Invoice AND

...etc...AND 

Account Balance must be greater than £5 AND 

Account Category must not equal Basic AND 

Account Category must not equal Standard.

Knowledge Base Article Details

Related ProductCredit Hound, Credit Hound Express for Sage 50
Reference NumberKBA-03-02-029
Document Date02/05/2023
Original AuthorVince Hodgson
Document Version1.0
Last Updated 02/05/2023
Update AuthorVince Hodgson