e-office User Manual
  • Overview
    • Chinese Online User Manual
    • e-Office Training Video
  • Server
    • 1 Preparation
    • 2 Installation
    • 3 License
    • 4 FAQ
    • 5 Service Management Platform
  • Mobile APP
    • 1 Preparation
    • 2 Installation
    • 3 Configuration
  • Quick Start Guideline
  • Design a new workflow
    • 1 New Form - Leave Application
    • 2 New workflow-Leave Application
    • 3 Initialize new leave application
    • 4 Regular Expressions(Regex) in Field validation
  • App Studio - New Application
    • 1 New application - Customer Management
    • 2 Approval flow
    • 3 User Menu
    • 4 All the controls
  • Open API
    • 1 Overview
    • 2 Attachment
    • 3 User Management
  • Customisation
  • Expense
    • My expenses
    • Expense List
    • Enter expense
    • Budget Statistics
    • Setting
      • Budget
      • Permission
        • Expense List
        • Budget Statistics
        • Expense Category
      • Basic Settings
      • Expense category
    • Expense Report
  • Project
    • My project
      • Project Details
    • New project
    • Project Task
    • Report Management
    • Settings
  • CRM
    • CRM Homepage
    • New Customer
    • Details
      • Customer List
        • List Data
        • Data Operation
        • Customer Detail
      • Contact
      • Contact Log
      • Opportunity
      • Sales Record
      • Contracts
      • Customer Pool
        • Pools I Managed
        • Pools I Joined
        • Pool Configuration
    • Suppliers
    • Product
    • More
      • Import/Export
      • Transfer
      • Merge
      • Recycle Bin
      • Request to access
      • Permission Approval
    • Customer Report
    • Settings
      • Field Settings
      • Homepage Configuration
      • Pool Configuration
      • Permission Setting
      • Related Business Setting
  • Assets
    • New asset
    • Application for use ~ WIP
    • Application for approval
    • Changes
    • Maintenance
    • Asset inventory ~ WIP
    • Return of assets ~ WIP
    • Analysis ~ WIP
    • Settings ~ WIP
  • Leave
    • My Leave
    • Leave List
    • Leave Type
    • Leave Setting
  • Attendance ~ WIP
Powered by GitBook
On this page
  • 1 Customer List
  • 2. Stats Block
  • 2.1 Description
  • 2.2 Enable/Disable
  • 2.3 Stat Block Configuration
  • 3 Create New Customer
  • 3.1 Field Setting
  • 3.2 Similar Customer
  • 3.3 Similar Customer List
  • 4 Import/Export
  • 4.1 Import
  • 4.2 Export
  • 5 Tag Manage
  • 5.1 View all tags
  • 5.2 Replace current tag
  • 5.3 Assign customer(s) to current tag
  • 5.4 Add new tag
  • 6. Nearby Customer
  • 6.1 Permission Settings
  • 6.2 Configuration
  • 7. Filtering/Searching
  • 7.1 List Data
  • 7.2 Detail Data
  1. CRM
  2. Details
  3. Customer List

List Data

Last updated 8 months ago

1 Customer List

Customers in the customer list:

  1. Customer who had the current user as account executive and/or customer service representative.

  2. The current user's direct subordinates is the customers' account executive.

  3. Customer who is shared to the current user.

  4. According to the current user's permission settings.

2. Stats Block

2.1 Description

  • Current customers Number: All customers

  • Formal customer numbers: Customer whose type is "Customer".

  • No. of new customers this month: Number of customers that is created in this month.

  • Follow up this month: Customers who have been followed up with this month.

2.2 Enable/Disable

Settings > Field Settings > Customer Information > List

Page Name: Customer Information

On the left side of the page, under Form, click on the toggle to enable or disable the stats block.

2.2.1 Enable

2.2.2 Disable

2.3 Stat Block Configuration

Click on the desired Stat Block, and on the left side of the page, under Control, the user can configure its properties.

Here, the user can configure the statistic block, such as data source, statistics (count, total, average, etc.), icon, block title, unit, color, and click event.

3 Create New Customer

Purpose: Record new customer data and allow the centralisation of all customer data, making it easier to manage and access important information like contact details, purchase history, and communication logs.

  1. Customer Name: Full name of the customer (individual or company). Required

  2. Customer No.: A unique identifier for the customer.

  3. Account Executive: Defaulted as Creator. The person responsible for managing the customer relationship. This is typically the primary point of contact between the company and the customer, handling communication, sales, and account growth.

  4. Customer Service Representative: The individual responsible for providing support to the customer, addressing inquiries, resolving issues, and ensuring a positive customer experience.

  5. Customer Source: Indicates where or how the customer was acquired, such as through marketing campaigns, referrals, organic search, events, or partnerships. It helps track the effectiveness of lead generation efforts.

  6. Customer Status: Describes the current state of the customer relationship, such as Intended Purchase, Close Follow, or Wait till further notice.

  7. Customer Type: Categorizes customers based on their nature, such as Customer, High-Value Customer, and Lead.

  8. Customer Attributes: Specific characteristics that define the customer, such as their preferences, behaviors, or other relevant data points. This field helps in segmenting customers for more personalized service.

  9. Industry: Specifies the sector or field in which the customer operates.

  10. Region: Refers to the geographic area where the customer is located.

  11. Contact No.: The primary phone number for reaching the customer or their representative.

  12. Fax No.: The fax number for sending or receiving official documents from the customer. Although less common today, this may still be relevant in some industries.

  13. Official Website: The customer’s official company website, which can provide additional information about their business and serve as a point of reference for understanding their needs.

  14. Legal Person: The individual legally responsible for the customer company, often the CEO or another executive who is accountable for contracts and legal matters.

  15. Postal Code: The postal or zip code for the customer’s location. It is important for mailing purposes and verifying the customer's address.

  16. E-mail: The primary email address for communicating with the customer. It is often used for sending important updates, documents, and marketing materials.

  17. Company Address: The physical address of the customer’s company. This is used for shipping, billing, and any official correspondence.

  18. Location: More specific information about the customer's geographic presence, possibly including coordinates or landmarks, useful for logistics or sales planning.

  19. Company Size: Describes the scale of the customer’s company, usually categorized by the number of employees or other metrics like market share, which helps tailor sales and support strategies.

  20. Annual Sales: The yearly revenue generated by the customer’s company. This metric is important for understanding the customer’s financial capacity and determining the potential business opportunity.

  21. Create Date: Default as the date and time when the customer record is created. Cannot be modified.

  22. Company Logo: Allow user to upload, view, edit, delete the customer's company logo.

  23. Customer introduction: Allows the users to create a detailed introduction for the customer, with full customization capabilities for text and formatting.

  24. Creator: Default current user that is creating the customer record. Cannot be modified.

  25. Last Contacted Time: The date time of the latest record in the contact log. Cannot be modified.

  26. Last back time: The most recent date time when the customer was returned from the assigned Account Executive back into the pool of available customers. Cannot be modified.

  27. Days without contact: Current Date - Last Contacted Time (If the customer was never contacted, the system will calculate based on the customer creation date). Cannot be modified.

Remark:

  1. Customer No.: If the user did not assign a value for this, the system will automatically assign it with an increment from 1 based on C-NO-0000000001. It takes the maximum value of customer_id of the auto-increment number and adds 1.

  2. The customer name and customer number will be validated for their uniqueness; an error will be prompted if not.

  3. Customer source, status, type, attribute, and industry can be managed in Settings > Dropdown box > CRM

3.1 Field Setting

Path: CRM > Settings > Field Setting > Tab: Customer information > Form Design

This page functions the same way as form design in the Workflow module.

  • This page allows the user to add and remove fields, set field attributes, configure the form layout, and sort, which includes sorting mode, list display, advanced query settings, fields for filtering, and other settings.

3.2 Similar Customer

This feature is implemented todetects similarities in customer names during data entry to prevent duplicate customer entries in the system.

3.2.1 Configuration

Form Design > Field: Customer Name > Control, under Display settings, make sure that the "Show similar customers" is checked to be available.

3.2.2 Result

3.2.2.1 Enabled

When "Show similar customers" is enabled, in create or edit customer mode, and the customer name is filled in, the system will display a list of similar customers.

  • The list will display the Customer Name. Account Executive, Customer Service Representative, Create Date and Last Contact Time.

3.2.2.2 Disabled

When "Show similar customers" is enabled, in create or edit customer mode, and the customer name is filled in, the system will not search for similar customer.

3.3 Similar Customer List

3.3.1 View

3.3.1.1 No permission to view the customer, but the user has applied for sharing.

Error: "No view permission" will be prompted when the user click on the customer.

3.3.1.3 Have the permission to view

Click on the list data, a new page will be opened and the customer details will be displayed.

3.3.2 Pick Up

For customers who do not have an account executive and customer service executive can be picked up directly. Only for user who are in the pool, the user who are not in the respective pool will not see the "Pick up" button.

Remark:

3.3.3 Request to Share

Purpose: To have the permission to view the customer information by the current user.

Step 1: On the Similiar Customer List data row, click more, click "Sharing" to apply for the customer to be shared.

Once the application has been approved, then the user will be able to view the customer.

Click on the "View application" to view the customer data.

3.3.4 Apply as CSR

As long as the current user is not the Customer Service Representative, they will be able to apply as one.

Step 1: Click "Apply Customer Service Representative"

Step 2: Enter the [Application reason] and click "Submit".

When the application has not been processed, the current user will not be able to reapply (the process includes rejection and application deletion).

Request Approved

Request Rejected

2.3.5 Apply as Account Executive

As long as the current user is not the Account Executive, they will be able to apply as one.

Step 1: Click "Apply Account Executive"

Step 2: Enter the [Application reason] and click "Submit".

When the application has not been processed, the current user will not be able to reapply (the process includes rejection and application deletion).

Request Approved

Request Rejected

4 Import/Export

4.1 Import

Step 1: In the top-right corner of the page, click "Import".

Step 2: Export the template by clicking on "Export template"

Step 3: Fill up the Excel template

Step 4: Select the updated Excel file by double-clicking on the file or click on the file and click "Open".

Step 5: Select whether you would like to add new data or update the existing data, once done, click on "Start importing" to begin the import.

Status message will pop-up once done.

When the import is complete, an Excel file will be generated to inform the user of the import status of all rows and provide an error message if the import failed.

4.2 Export

Step 1: In the top-right corner of the page, click "Export".

Step 2: Select or de-select fields to be exported, and click "Confirm" to begin the process.

The system will automatically generate and download the exported data in Excel format onto the user's device.

Remark:

  • This will export all the data that is shown on the current display list, across all pages. If your settings for the list are set to 10 results per page, the export will still include all existing data.

  • The user can also export the desired data by filtering, searching, and applying query conditions before the export.

  • If there are any attachments, such as a logo, in the master data, the attachment and Excel file will be exported simultaneously and compressed into a single zipped file.

5 Tag Manage

Purpose: A centralized console for the user to manage all tags the user had associated to each customers.

5.1 View all tags

Step 1: Click on the "Tag Manage" button to open the console.

In this interface, the user can view all the current tags associated with each customer.

5.2 Replace current tag

Step 2: Change the tag by selecting existing tag or create a new tag by simply enter the new tag name and click enter on your keyboard, then click "Save".

5.3 Assign customer(s) to current tag

Step 2: Click on the avatar to open a dropdown list of customer that the current user has the permission to view for.

Step 3: Select the customer(s) and click "Confirm" to add them to the tag.

Step 4: Click "Save" to implement the changes made.

5.4 Add new tag

Step 2: In the newly created row, enter the new tag and the customer that is to be associated with the tag, and click save to create it.

Remark:

If the user attempt to remove the existing tag and save without replacing it with a new tag, an error message will be displayed.

6. Nearby Customer

Purpose: Retrieve customers who are within a few kilometers away from the current user.

Step 1: On [Customer list], click on "Nearby customers"

Step 2: The customer name will display on the map.

6.1 Permission Settings

Path: Settings > Permission Setting > Page Permission

Step 1: Click "New".

Step 2: Set the relevant scope of user whom can use this feature and click "Save".

6.2 Configuration

6.2.1 Customer Information: Location

Must have data in Customer Information: Location.

6.2.2 Within how many kilometers

The user may set the range parameter in [Related Business Settings] > [Customer].

7. Filtering/Searching

The conditions of “More filters”, “Search” and “Advanced Search” can be set in [Fields Setting].

7.1 List Data

7.1.1 Filter

The filter function allows users to refine or narrow down the data list based on the selected criteria.

Click on "More filters" to view more filtering options available.

7.1.2 Search

The users is able to filter customer with fieldsthat are similar/matched to the text entered in the search box.

The [Advance Query] allows the users to create complex searches or filters by specifying detailed conditions and criteria.

7.2 Detail Data

Allows user to search by customer name and opens in a new page

Whether or not the pick up will be successful will be according to the settings in Pool Configuration .

Step 1: Click on next to the tag that you want to replace.

Step 1: Under [Select customers], click .

Step 1: In the top row, click on to add a new row.

3.3 Recycling mechanism