Introduction

Customer Master Records must be set up before you can begin processing transactions through the Sales System.  These records hold static information about each of your customers that needs to be kept up to date. Also, as you engage with new Customers, you will need to add their records to the system.

Prerequisites

Complete these prerequisite data tables before setting up your Customer Master Records:

• Currencies
• Tax
• General Ledger Codes
• Bank Accounts
• BI Codes (optional)
• Price Lists (optional)

Adding a Customer Account

To add a customer account, follow this process:

1. Go to Sales > Customers > New Customer.
2. Add the customer details in the relevant tab (see below).
3. Click Save to Create the Customer. Click Close to return to the Customer grid.

See:

Add Edit Customers (3.1) - AIQ Academy

How do I use Code Maintenance to Control the Behaviour of the System?‍ 

How do I Manage my Company Bank Accounts and Credit Cards?‍ 

How do I Implement Extended Business Analysis?‍ 

 Accounts Details tab

In the Account Details Tab, complete the following fields (mandatory items are indicated by *):

Customer Account

• Account Code: This is a unique code that identifies a customer. It can be of any length but must be alpha-numeric. If you leave this field blank, the system will automatically create the code from the Customer Name, taking the first three letters of the name you enter.
• Name*: Add the customer’s name. This must be unique.
• Currency code*: All customer transactions will be in this currency. 

• Bank GL Account*: This should be one of your accounts into which you will receive payments from this customer. You can change this on entry if required. 
• Account on Hold: Select whether this account is currently on hold or not. For example, if there is a long-standing overdue payment against this account, you can decide to flag it as On-hold for new orders and/or deliveries. The system will then warn you if you enter any further orders/deliveries.

Business Contacts

Complete the fields you require:

• Email Address: This field can hold up to three email addresses, separated by semi-colons. It will be used for emailing invoices and statements.

Business Address

Complete the fields you require.

Delivery Address

• Delivery Address: If the customer has a different Delivery address to their Business Address you can enter it here. If it's the same as their Business Address, click Copy from Business Address to copy the details.

 Account Settings tab 

General Ledger Settings

• General Ledger Account*: This will be the default Sales Account for all invoices and credit notes for this customer, but you can change it during data-entry stage if necessary.
• Control GL Code*: Select the correct Debtors Control Account from the list.

Account Dimensions

• BI Code: Like the General Ledger Account, this is a default code that can be set for all invoices and credit notes raised against this customer.

Delivery Settings

• Delivery Route: Set up and assign delivery routes.
• Ship Via: Set up and assign transport providers.
• Priority: Set up and assign an importance level.

Sales Settings

• Sales Rep: Select the Sales Rep assigned to this Customer. This allows for the calculation of Sales Rep’s Commissions based on invoiced sales.   

Account Dimensions

• Area: Select from the list or set up new Sales Areas. This is useful to classify your customer according to the Sales Area for Sales Analysis reporting purposes.
• Region: Select from a list or set up new Sales Regions. This is useful to classify your customer according to the Sales Region for Sales Analysis reporting purposes.
• Referral: This allows you to record, for marketing purposes, the source of this Customer.
• Account Group: Select from a list of Account Groups. You may wish to associate this customer with a common grouping for classification and reporting purposes.

Head Office Details 

• Head Office Account: Tick this to indicate that this Customer record is in respect of a Head Office Account. It is possible to link this Head Office account with subsidiary or branch accounts.
• Invoice Head Office: Use this flag to indicate whether the Head Office Account associated with this account should be invoiced instead of this Customer Account. If you tick this flag, specify the Head Office Account Code for Invoice purposes in the dropdown. 

See:

How does Head Office Accounting Work?‍ 

How do the Sales Reps & Commission Management Work?‍ 

 Finance Settings tab

Bank Details

Enter the Bank details of the Customer. These can also be used to extract a report and import information into alternative DD-generating systems.

• Payment Method:  This is the normal Payment Method normally used by this Customer to remit funds.

Pricing & Discount Settings

• Price Category:  Price Categories allow you to classify Customers into different Groups for individual pricing purposes.
• Price Lists: Price Lists allow you to set up and use special price lists, for example, to use in promotions.  
• Discount: This is the Discount percentage you are extending to this Customer on their Invoices. Enter it as a decimal, for example, 0.15 to represent a 15% discount. It is unrelated to Payment Terms. 
• Franchise: Use this flag to indicate whether you want this customer treated as a Franchisee in the context of a Franchise implementation of the system.  

Payment Details & Credit Terms

• Credit Terms: This will be the default for all invoices. It is used to calculate the due date for reporting. It comes from the Codes table.
• Credit Limit: This is the maximum amount of Credit allowed to the Customer. During Order entry or Invoice entry, warnings will appear if this limit, or the Credit Terms limit, is exceeded.
• EDI ID:  Identify each customer by a unique EDI number.
• EDI File Type: Select the EDI File type you need from the dropdown list. The system allows you to generate Electronic Data Interchange (EDI) files for the purposes of billing customers where this form of file transfer is supported. The file generated will contain a list of outstanding invoices due for payment and the individual customers will be identified using the ID number. 

Tax Settings

• Tax code:  This defines the default tax code used for any invoices or orders created. The item default tax code will take priority over the customer default tax code. 
• Use Tax Code: Tick if you would rather use the customer default tax code instead. This will then override any invoice or order with the tax code specified in the Default Tax code field.
• VAT (Tax) No: Enter the Customer Tax Number.
• VAT (Tax Exempt Ref): Enter the Customer's Tax-Exempt Number.

See:

How do I Maintain Product and Service Type Items?‍  

How do I as a Franchisor interact with my Franchisee Companies? ‍  

 Contacts tab

To set up a new contact: 

1. Click New Contact. 
2. Enter the appropriate details.
3. Click Save.
4. You can set a contact as the Primary Contact. Select it from the Set Primary Contact dropdown. The Primary Contact’s email address will be used for any automatically sent invoices or statements, taking precedence over the Email Address field in the Business Contacts tab.

 Notes tab 

On the Notes tab, you can add a series of Notes relevant to this customer, these are only visible to system users, not to customers.

To add a new Note:

1. Click Add New Note.
2. Enter the Note.
3. Click Save.

See:

  How do I Add Notes and Images to Documents?‍ 

Custom Fields tab 

You can add Custom Fields to the customer and invoice listing screen and use them to sort or filter data. 

1. Click New Custom Field.
2. In the screen, add the appropriate details and click Save.
3. In the new custom field, enter the appropriate customer details.
4. Click Save and Close to return to the Customer Listing Screen. 

See:

How Do I Create User Customised Fields on Master Records?‍ 

Add Documents

You can attach one or more Document Images and other Objects to the Customer’s Master record. These could include: 

• Terms & Conditions
• References
• Letters of Credit
• Voice Mails

To add a document:

1. Click the Paper Clip symbol displayed next to the Attach Document.
2. Click Browse to find your file.
3. Click Upload.

Editing a Customer Account

1. Go to Sales > Customers.
2. Find the account in the listing screen and its code.
3. Edit the details. Once transactions have been posted for the customer:
   • You cannot update certain fields, for example, Customer Code, Currency Code, and Control GL Code. You can update most other fields. 
   • The delete button no longer appears. If you do not need a customer anymore, deactivate them by un-ticking the Active box in the Account Details tab.
4. Click Save when finished.

Actions

Click Actions within the customer record, or from the customer grid to carry out the following and more:

• Create customer transactions.
• View, print, or email documents.

 FAQs

How can I set up a customer with more than one currency?

If you need to create transactions in more than one currency for a particular customer, then set up a customer record for each currency.

Can I change the control account for a customer/group of customers?

You can only do this if it is a new Customer account with no transactions recorded/saved against it. If there are transactions recorded against it, you cannot change the Control account.

Can I set up a new Control account to record sales transactions? 

Yes, you can set up a new type C Control account as a new Debtors Control account.

Can I delete a customer?

You can only delete a customer if no transactions, including Saved Sales orders or Sales Item invoices, exist against this customer.