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.
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 Analysis
An 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 Payments
A dropdown list of all the Transaction Types to select the relevant one (e.g. Customer Receipts or Customer Payments).
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.
Generates a list of Customers based on the selected filters.
New
Creates a Customer Record.
Actions
Allows 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.
A dropdown list of categories from which to select one.
Region
A dropdown list of regions from which to select one.
Rep
A dropdown list of staff from which to select a rep.
VAT No.
Enter the VAT registration number.
Website
Enter the website URL.
Telephone
Enter the customer's telephone number.
Postal Address
Enter the postal address.
Street Address (Default)
Enter the street address.
Note
Enter 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.