Customers Reference

Customers are those companies or individuals that you invoice for sales or services rendered. You may add an unlimited number of Customers to your database. Provision is made to add multiple contact people to customer records and specify their positions. Documents and correspondence are always sent to a Contact Person linked to a customer.

By default, a red Warning bar appears to warn you about the following: Blank Name, Duplicate Name, Duplicate Account No, No Contacts, Blank Accounts Contact.

You may change the default Warning if you are familiar with SQL.

Settings

These settings relate to Customer records and transactions.

General Settings

Navigation Example

Main Menu > Setup > Settings > General (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
Accounting > Setup Customer Age AnalysisAn Edit field to select all the Transaction Types that should appear on the Customer Age Analysis (e.g. Customer Invoices, Customer Credit Notes, and for Work in Progress: Sales Orders and Sales Order Returns).Not applicable
Accounting > Setup Customer Summary
  • Select the Transaction Types that should appear on the Activity graph (Account tab) on the Customer Summary.
  • All the transactions that involve the customer are automatically displayed on the transactions tab and no setup is required for that.
Not applicable
Alerts > Customer Warning Message
  • Enter an SQL query that returns a field named WARNING. Its text is shown on the red warning bar of the customer, instead of the standard warnings.
  • Fields of the open customer can be used as parameters, for example, :CUSID.
  • Leave blank to use the standard warnings.
Blank
CRM > Transaction Type IDs for Customer Credit Notes (e.g. = 2, in (1,2,3))
  • Enter the codes for the Transaction Types that generate Customer Credit Notes.
  • The ID fields appear in the ID column when you navigate to Main Menu > Setup > Transactions > Transaction Types (tab).
Blank
CRM > Transaction Type IDs for Customer Invoices (e.g. = 2, in (1,2,3))
  • Enter the codes for the Transaction Types that generate Customer Invoices.
  • The ID fields appear in the ID column when you navigate to Main Menu > Setup > Transactions > Transaction Types (tab).
Blank
CRM > Transaction Type IDs for Customer Orders (e.g. = 2, in (1,2,3))Enter the codes for the Transaction Types that generate Customer Orders. The ID fields appear in the ID column when you navigate to Main Menu > Setup > Transactions > Transaction Types (tab).Blank
General > Default: Sales Representative
  • Select the sales representative to link to new customers.
  • Users with Mine access to customers get themselves as the sales representative instead.
Not set
General > Set new Customer Status to 'Active'Checkbox. If checked, new records have the status of Active.Unchecked
Payments > Transaction Type – Customer PaymentsA dropdown list of all the Transaction Types to select the relevant one (e.g. Customer Receipts or Customer Payments).Not set

Transaction Settings

Navigation Example

Main Menu > Setup > Settings > Transactions (tab)

Info

The following settings can be added to these Transaction Types.

Customer Receipts (CR)

Setting Description Default
Accounting > Set Transaction Complete when allocatedIf the payment amount is fully allocated the Status of the transaction is automatically set to Complete.Unchecked
Payments > Payments – Item ID – CashTo use the Customer Payments feature, items must be created for cash and change. The Item IDs are filled in here.0
Payments > Payments – Item ID – ChangeTo use the Customer Payments feature, items must be created for cash and change. The Item IDs are filled in here.0
Transactions > Enable 'Clear Overpayment' function in ledgerCheckbox. If checked, overpayments may be written off to a general ledger account.Unchecked

Customer Receipts – Forex 2 (CRFX2)

Setting Description Default
Transactions > Enable 'Record Foreign Exchange Gain' function in LedgerCheckbox. If checked, the feature is enabled.Unchecked

Customer Receipts – Forex 1 (CRFX1)

Setting Description Default
Accounting > Set Transaction Complete when allocatedIf the payment amount is fully allocated the Status of the transaction is automatically set to complete.Unchecked

Customer Credit Notes (CC)

Setting Description Default
Alerts > Warning MessageCustomise the warning message using SQL.0

Customer Invoices (CI)

Setting Description Default
Alerts > Warning MessageCustomise the warning message using SQL.0
NCR > Transaction used for 'Customer Complaints'Checkbox. If checked, the transaction is used.Unchecked
Payments > Enable Customer PaymentsCheckbox. If checked, Customer Payments are enabled.Unchecked
Service Manager > Transaction used for Progress InvoicesCheckbox. If checked, the transaction is used.Unchecked
Tracker > Module Field ServiceCheckbox. If checked, the transaction is used.Unchecked
Transactions > Caption for Due DateEnter a caption. If no caption is provided, the field is supressed.Blank
Transactions > Default: Deposit percentage (Control is hidden when set to default of 0%)Field to enter an amount.0
Transactions > Enable 'Discount Outstanding' function in LedgerCheckbox. If checked, the feature is enabled.Unchecked
Transactions > Enable 'Record Foreign Exchange Loss' function in LedgerCheckbox. If checked, the feature is enabled.Unchecked
Transactions > Enable SignaturesOptions are:
  • None: No signatures are required.
  • Transaction: Signatures are required on the transaction.
  • Transaction Flow: Signatures are required for the entire transaction flow.
None
Transactions > Link Meter Data to Transaction ItemsCheckbox. If checked, the feature is enabled.Unchecked
Transactions > Show Delivery AddressCheckbox. If checked, delivery addresses appear.Unchecked

Transaction Access Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

  • Access is needed for all the Transaction Types that affect Customer Accounts.
  • Access is set in the Transaction Access column per selected user.
  • Access can also be set in bulk using Actions (button) > Batch Update.
  • Modules can be added or removed by using Actions (button) > Add/Remove Modules. Removing a module also removes the user's access.
  • The Access options are:
    • View: 
      • None: You have no access and cannot receive access for any of the other options.
      • All: You can view all transactions.
      • Own (Rep): You can view transactions if you were selected as the rep on the transaction.
      • Admin: You can view all the transactions and change the statuses.
    • New: If checked, you can create transactions. Having access to copy transactions overrides this setting.
    • Edit: If checked, you can edit transactions.
    • Delete: If checked, you can delete transactions.
    • Est (Form only): Applies to estimates. Only view the form, and not the profit margins.
    • Status (Up only): Only move a transaction forward (e.g. change the status from Pending to Active, but not from Active to Pending). Users with Admin rights can change the status regardless of this setting.

User Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

Setting Description Default
Accounting > Customer Age Analysis – Access AllowedCheckbox. If checked, access is allowed.Unchecked
General > Customer Summary – Access AllowedOptions are:
  • None: No access is allowed.
  • Limited: You can view the customer summary, except the Account and Transactions tabs.
  • Full Access: You have access to all the context menu functions.
Full Access
Service Manager > View all CustomersCheckbox. If checked, you can view all customer records.Unchecked
Setups > Customers – Access AllowedThe options are:
  • All: You can access all customer setups.
  • None: You have no access to customer setups.
  • Mine (Rep): You only have access where you are the rep.
None
Setups > Customers Accounting – Access AllowedCheckbox. If checked, access is allowed.Unchecked

List View

Buttons Explained

Button Description
ViewGenerates a list of Customers based on the selected filters.
NewCreates a Customer Record.
ActionsAllows changes to all the selected records:
  • Batch Update: Changes all the selected records when Update (button) is clicked. The options are:
    • Status: Changes the Status to the one selected from the dropdown list.
    • Terms: Changes the Terms to the one selected from the dropdown list.
    • Credit Limit: Changes the Credit Limit to the one selected from the dropdown list.
    • Rep: Changes the Rep to the one selected from the dropdown list.
    • Category: Changes the Category to the one selected from the dropdown list.
    • Region: Changes the Region to the one selected from the dropdown list.
    • VAT Type: Changes the VAT Type to the one selected from the dropdown list.
    • Adj% – Trans Items: Changes the Adjustment for Transaction Items to the percentage entered in the adjacent block. (All the adjustment fields are on the Accounting tab in Edit View under the heading Default Adjustments.)
    • Adj% – Est Overall: Changes the Overall Estimate Adjustment to the percentage entered in the adjacent block.
    • Adj% – Est Materials: Changes the Adjustment for Material Items on an Estimate to the percentage entered in the adjacent block.
    • Adj% – Est Services: Changes the Adjustment for Service Items on an Estimate to the percentage entered in the adjacent block.
    • Adj% – Est Outwork: Changes the Adjustment for Outwork Items on an Estimate to the percentage entered in the adjacent block.
    • Entities: Changes the allocated Entity to the one selected on the dropdown list. Only applies if more than one Entity was created.
    • Billing Method: Changes the Billing Method to the one selected from the dropdown list.
    • Price List: Changes the Price List to the one selected from the dropdown list.
  • Format: Formats the customer names so each word starts with a capital letter.
Output
  • Lists the Output Templates linked to this screen under Print, Print (Show Dialogue), Preview and Email (see Onscreen Output Options).
  • Shows "No available Templates" when none are linked. QuickEasy sets up templates on request.
Menu
  • Reset Data Filter: Resets all the data filters.
  • View Changelog: Displays a list of changes, including the dates and user who made the changes (see Changelog).
  • Settings
    • Edit Categories: Interface to create or edit categories.
    • Edit Regions: Interface to create or edit regions.
    • Edit Positions: Interface to create or edit job positions.
  • Export
    • Email Excel
    • Export Grid
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Filters Explained

Filter Description
SetSets a specific period (e.g. Today, This Month, This Year, Fin Year).
DateFilters the data to the set Start and End Dates.
ArrowsBack/Forward arrows toggle the dates based on the Set period.
CategoryFilters the data to include All or only a specific Category.
RegionFilters the data to include All or only a specific Region.
StatusDropdown list of statuses. Shows only records matching the selected Status unless All is chosen.
RepDropdown list of reps. Shows only records matching the selected Rep unless All is chosen.
TermsDropdown list of terms. Shows only records matching the selected Terms unless All is chosen.

Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number allocated to the entry.
RIDThe system-generated number allocated to the entry.
StatusThe status of the customer record.
NameThe customer's name.
Reg. asThe customer's registered name.
CodeThe customer's code (account number).
CategoryThe category allocated to the customer.
RegionThe customer's region
RepThe name of the rep allocated to the customer.
WebsiteThe customer's website URL.
Accounts ContactThe customer's account contact.
TermsThe customer's terms.
VAT TypeThe customer's VAT Type.
VAT No.The customer's VAT registration number.
Created byThe user who created the entry.
Vendor No.The customer's vendor number.
Credit App.The date of the customer's Credit Application.
CurrencyThe customer's currency.
Credit LimitThe customer's credit limit.
Created byThe user who created the transaction.
Price ListThe Price List allocated to the customer.
Billing MethodThe billing method allocated to the customer.
Bank NameThe customer's bank details: Bank Name.
Bank Branch NoThe customer's bank details: Branch Code.
Bank Account NoThe customer's bank details: Account Number.
Updated byThe name of the user who last updated the transaction.
UpdatedThe date on which the transaction was last Updated.
Adj % – Trans – ItemsDisplays the percentage adjustment applied to Transaction Items.
Adj% – Est OverallDisplays the percentage adjustment applied to the Overall Estimate.
Adj% – Est OutworkDisplays the percentage adjustment applied to Estimate Outwork.
Adj% – Est ServicesDisplays the percentage adjustment applied to Estimate Services.
Adj% – Est MaterialsDisplays the percentage adjustment applied to Estimate Materials.
MenuClick the button or right-click a customer for these options:
  • Open Customer: Opens the customer record for editing.
  • Delete Customer: Deletes the customer record if it is not used in any transactions or linked to any service tickets.
  • View Customer Summary: Displays the customer summary.

Edit View

Buttons Explained

Button Description
ArrowsArrows to scroll through customer records.
Output
  • Lists the Output Templates linked to this screen under Print, Print (Show Dialogue), Preview and Email (see Onscreen Output Options).
  • Shows "No available Templates" when none are linked. QuickEasy sets up templates on request.
NewCreates a Customer Record.
DeleteDeletes the customer record if it is not used.
SaveSaves the changes (greyed out if there are no changes).
Menu
  • View Customer Summary: Displays a summary of the customer's transactions as specified under General Settings.
  • View Changelog: Displays a note with a summary of all the changes (see Changelog below for which changes are recorded).
  • Add Inventory Location: Provides a dropdown list of locations to select one or an option to select Not linked to a Group.
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Fields Explained

Field Description
NameEnter the Trade Name of the customer.
Reg. asEnter the Registered Name of the customer.
CategoryA dropdown list of categories from which to select one.
RegionA dropdown list of regions from which to select one.
RepA dropdown list of staff from which to select a rep.
VAT No.Enter the VAT registration number.
WebsiteEnter the website URL.
TelephoneEnter the customer's telephone number.
Postal AddressEnter the postal address.
Street Address (Default)Enter the street address.
NoteEnter a note.
Contacts (tab)
  • Options to add contacts to specify contact people for the customer.
  • An Add Contact button opens a form to type in the necessary contact details.
  • The first contact added becomes the customer's account contact.
Street Addresses (tab)
  • Options to add additional addresses.
  • An Add Street Address button open a line in which the details can be entered.
  • Select the checkbox to set the address as the default address.
Accounting (tab)Options to provide the following information:
  • Status: A dropdown list of statuses to select one.
  • Contact: Select the contact who should receive the invoices.
  • Contact (Statements): Select the contact who should receive the statements.
  • Code: Generate a code (click the three dots (...)) or enter a code.
  • Vendor No.: Enter a vendor number.
  • Reg No.: Enter a registration number.
  • VAT Type: A dropdown list of VAT Types from which to select one.
  • VAT No.: Enter the customer's VAT Registration Number.
  • Currency: A dropdown list of currencies to select one.
  • Credit Terms: A dropdown list of credit terms to select one.
  • Credit App.: Select the Date of the Credit Application.
  • Credit limit: Enter the customer's credit limit.
  • Secured limit: Enter the customer's secured credit limit.
  • Billing Method: A dropdown list of billing methods to select one.
  • Price List: A dropdown list of Price Lists to select one.
  • Debit Order Bank Detail
    • Bank: Enter the name of the customer's bank.
    • Branch No: Enter the bank's branch number or code.
    • Account No: Enter the account number.
  • Default Adjustments
    • Trans Items Adj%: Enter the default adjustment to apply to Transaction Items and General Estimates that use Sell Prices.
    • Estimates – Overall Adj%: Enter the default adjustment to apply to General Estimates (that is, Estimate Items on transactions).
    • Estimates – Materials – Adj%: Enter the default adjustment to apply to the Material Items on estimates. Only applies to estimates that are created from Estimate Types.
    • Estimates – Services Adj%: Enter the default adjustment to apply to the Service Items on estimates. Only applies to estimates that are created from Estimate Types.
    • Estimates – Outwork Adj%: Enter the default adjustment to apply to Outwork Items on estimates. Only applies to estimates that are created from Estimate Types.
  • Warning (Display on Transactions): Enter a warning that will appear on transactions and on service tickets.
Attachments (tab)Options to add attachments which can be uploaded files or URLs. An Add Attachment button opens an interface from which a file can be uploaded, or URL inserted.

Changelog

Changes to the following fields are recorded:

  • Account No.
  • Adj% Items & Est
  • Bank
  • Branch No
  • Company
  • Credit Limit
  • Currency
  • Price List
  • Rep
  • Status
  • Terms
  • VAT Type

Customer Categories

  • Customers can be linked to Categories (e.g. hospitality, manufacturing).
  • Categories are created from Customer List View > Menu (button) > Edit Categories.

Customer Regions

  • Customers can be linked to Regions.
  • Regions are created from Customer List View > Menu (button) > Edit Regions.

Positions (Job Descriptions)

  • Positions can be created to specify the positions held by Customer's Contact staff (e.g. Manager, Bookkeeper).
  • Positions are created from Customer List View > Menu (button) > Edit Positions.

Data Pipelines

The Data Pipelines for Customers Output Templates are listed in Output Data Pipelines.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.