Reference Data & Lookups: Broker

Broker

Brokers can be linked to quotes and are stored in the Quotes / Finance "Broker" field.

Brokers can be set-up to be linked to a specific Financier.

Using brokers and broker rates in quotes is an optional feature.

Brokers can be set-up to have a default rate, this goes into the Quotes / Finance "Broker Rate" field and the "Broker Fee" is calculated from this.

Open the calculation model to see how the fee is calculated.

Below is a description of the logic that is applied to default or add a broker and a broker rate into a quote:

Create

When creating new quotes, Quotes / Finance "Financier" will be populated in the following preference order

1. If Clients / Quote Defaults "Financier" is populated, use this financier.
2. If Contract Types / Details "Quote Financier" is populated, use this financier.
3. Lookup or directly enter a financier.

The "Broker" defaults in this order

1. Quotes / Finance "Financier" - linked Suppliers / Account "Agent" (broker) is added.
2. User can add

The "Broker Rate" defaults in this order

1. "Broker" - linked where is on or before the quote's "Effective Date"
2. User can add

Edit

The "Financier" can change in the following situations

1. The "Client" is changed I.e., Clients / Quote Defaults "Financier"
2. The "Contract Type" is changed I.e., Contract Types / Details "Financier"
3. User updates

The "Broker" can change in the following situations

1. The Financier is changed AND the new Financier has a linked Broker
2. User changes

The "Broker Rate" can change in the following situations

1. The "Broker" is changed
2. The "Effective Date" is changed I.e., is on or before the quote's "Effective Date"
3. User changes the "Broker Rate"
4. User changes the "Broker Fee"

Calculation

The basis for the Broker Fee calculation uses to determine the amount used in the calculation.

It can be either 'depreciable-amount' (default) or 'on-road-price'.

Refer also to calculation model.

Set the calculation basis

The calculation for the broker fee uses either 'depreciable-amount' (default) or 'on-road-price' as the basis for calculating the amount.

Check and update with the setting you wan to us for the calculation.

Create a Broker

Suppliers / Account "Supplier Type" - choose 'Broker'

Link to a Financier

Suppliers / Account "Agent" - in the Financier record, use the lookup to add the required broker or enter the "Supplier Code" if you know it.

Add or update Broker Rates

Broker rates are stored in the table .

Export data from a table to see the current rates.

Import data to a table to update or add new rates.

For rate changes - add a new record for the supplier with the updated rate and date.

The date is used in conjunction with the quote "Effective Date" field to select the correct rate for the quote.

Role Restrictions

The fields "Broker", "Broker Name", "Broker Rate" and "Broker Fee" can be role restricted.

Useful Queries

## Broker and Broker Ratesselect s.supplier_code, s.name, s.supplier_type, sbr.rate, sbr.datefrom fm_suppliers as sleft join qt_broker_rates as sbr on sbr.supplier_id = s.supplier_idwhere s.supplier_type = 'broker';## Financier, Broker and Broker Ratesselect sf.supplier_code as financier_code, sf.name as financier_name, sb.supplier_code as broker_code, sb.name as broker_name, sb.supplier_type, sbr.rates, sbr.min_rate, sbr.max_rate, sbr.min_date, sbr.max_datefrom fm_suppliers as sfleft join fm_suppliers as sb on sb.supplier_id = sf.supplier_id_agentleft join (select supplier_id, count(broker_rate_id) as rates, min(rate) as min_rate, max(rate) as max_rate, MIN(date) as min_date, MAX(date) as max_datefrom qt_broker_rates) as sbr on sbr.supplier_id = sb.supplier_idwhere sf.supplier_type = 'financier'order by sf.supplier_code;

Introducer

Access Type: Internal

Restriction: The Introducer role has access to the system as noted below.

Set Up: This user role type is set up by a system Administrator.

Screen access and permissions

Company

Your companies are stored in the table gb_companies. Most of you only need one record, but you can store and use multiple companies in Catch-e if desired.

Companies can also be used for more detailed management of particular channels.

Accepting or settling a quote

Below are the business rules that are used to update the Contracts / Contract "Company" field when a quote is accepted or settled;

1. If only one company record exists, this will be used.
2. If the quote being accepted or settled is linked to a channel, the channel's linked company record is used.
3. Where only one company record has the = 'yes', then this will be used.
4. In all other cases, the correct company record cannot be determined, so you will see 'TBA' in the "Company" field.

Creating a contract

If a contract is created directly using the New button, the following behaviour applies;

1. If only one company record exists, this will default into the field.
2. Where only one entry has the * = yes*, then this will default into the field.
3. Where there are no records where * = yes*, then the first record in the table will default into the field.

Use in the Transactions report

If configured, the field is used in the Contracts / FBT → Transactions report.

It is shown as the Supplier for Contracts / Payments Management Fee transactions.

If is '0', Supplier will be blank for those records.

Use in Export files

The "Company" field can be used to create separate accounting export files for portions of your fleet.

When system transactions are created and and the multicompanyexportflag is active, accounting entries that are written to gltransactions will include the contract's company id which is, in turn, used to group the transactions into separate export files for each company.

Visit MYOB export or Xero export to find out more.

Note: Where the control multicompanyexport_flag is active and a company is not assigned to a contract (Company is shown as 'TBA') transactions will not be included in the export files.

Use in BECS files

If you are using multiple companies, you can also configure the driver claim reimbursements to use multiple bank accounts if needed.

gb_companies

1. Create new records as required in the table gb_companies.
2. To create a default company for new contracts, set = 'yes' for only one record.

Channels

1. Populate the Channels / Contact "Company" field for each channel to link it to the appropriate company record.
2. When a quote is accepted or a contract created for a channel, it's linked company will be applied to the contract.
3. Open this flowchart to see the business logic that is used.
4. Remittance Advice: follow these links for more details: Company, Channels Setup, Payments Setup

Salary Packaging

1. Go to the Salary Packaging Setup page for full details.
2. Create a new company record for your Salary Packaging business.
3. Update the field to record the company you are using for your Salary Packaging transactions.
4. When an item is accepted or made active, this company will be applied to the new package contract.
5. Open this flowchart to see the logic that is used to do this.
6. Set the required controls to generate separate accounting exports for each company.

Accounting

1. Check and update the Global Controls) flag gl.multicompanyexport_flag to match your preferences for the MYOB export or the Xero export will use multiple companies.

Validations and Alerts

Warning: Only one company can have = 'yes'.
If more than one record is set as the default, data errors can arise.

Employees / Item - an item cannot be made active and you will be alerted.

Insurer

Where Suppliers / Account "Supplier Type" = 'Insurer'

Insurer Locations

Suppliers will only be available in the "Insurer" field if the Suppliers / Account "Supplier Type" field is set as 'Insurer'.

The "Insurer" field exists in the following places:

• Setup / Reference Data → qtinternalinsurers
• Clients / Quote Defaults
• Quotes / Contract
• Quotes / Lease
• Contracts / Insurance

Default

If the Clients / Quote Defaults "Insurer" field is populated, the Quotes / Contract "Insurer" value will initially show this value when a new quote is being raised.

If the selected "Policy Owner" is an Internal Policy and there is a default "Insurer" stored in the table, this insurer will default into the quote.

Drop List

The "Insurer" list selection is restricted in the following ways:

1. If ) is set to 'no', "Insurer" is disabled and only the insurer stored in the Clients / Quote Defaults "Insurer" field can be selected and saved.
2. If the selected "Policy Owner" is an Internal Policy, "Insurer" list is limited to active insurers stored in the table.
3. If the selected "Policy Owner" is Driver Policy or Client Policy, any active insurance supplier who is not stored in in can be selected.

Quotes Insurance Budget

The chosen "Insurer" can be configured to generate a calculated insurance budget on a quote.
This is usual for internal_insurers, but can also be configured for other insurance suppliers.
When calculated, the insurance amounts populate into Contracts / Insurance fields when a quote is accepted or settled.

Treasury

Access Type: Internal

Restriction: The Treasury role has full access the system except where noted below.

Set Up: This user role type is set up by a system Administrator.

Screen access and permissions